Sub Button_Click(s As Object, e As EventArgs) Dim con as sqlconnection
Dim cmd as sqlcommand Dim rs as sqldatareader Dim intfield As Integer con=New
sqlconnection("Server=lc2000;pwd=;uid=sa;database=payrull")con.Opencmd=New
sqlcommand(txtQuery.Text,con)rs=cmd.ExecuteReader()txtResult.Text=""Session.LCID
= 2057while rs.Read() txtResult.Text = vbNewLine for
intfield=0 to rs.fieldcount - 1 txtResult.Text = rs( intfield
).ToString().PadRight(15) nextend whilers.close()con.close()end subSub
Button_Click(s As Object, e As EventArgs) Dim con as sqlconnection Dim
cmd as sqlcommand Dim rs as sqldatareader Dim intfield As Integer con=New
sqlconnection("Server=lc2000;pwd=;uid=sa;database=payrull")con.Opencmd=New
sqlcommand(txtQuery.Text,con)rs=cmd.ExecuteReader()txtResult.Text=""Session.LCID
= 2057while rs.Read() txtResult.Text = vbNewLine for
intfield=0 to rs.fieldcount - 1 txtResult.Text = rs( intfield
).ToString().PadRight(15) nextend whilers.close()con.close()end sub
<%@ Import NameSpace="System.Data.SqlClient" %>
<Script Runat="Server">
Sub Button_Click(s As Object, e As EventArgs)
Dim con as sqlconnection
Dim cmd as sqlcommand
Dim rs as sqldatareader
Dim intfield As Integer
con=New sqlconnection("Server=lc2000;pwd=;uid=sa;database=payrull")
con.Open
cmd=New sqlcommand(txtQuery.Text,con)
rs=cmd.ExecuteReader()
txtResult.Text=""
Session.LCID = 2057
while rs.Read()
txtResult.Text &= vbNewLine
for intfield=0 to rs.fieldcount - 1
txtResult.Text &= rs( intfield ).ToString().PadRight(15)
next
end while
rs.close()
con.close()
end sub
</script>
<html>
<head>
<title>SqlQuery</title>
</head>
<body>
<form runat="Server">
<asp:TextBox ID="txtQuery" TextMode="MultiLine" columns="80" Rows="4"
Runat="Server"/>
<br>
<asp:Button Text="Execute Query" OnClick="Button_Click" Runat="Server" />
<p>
<asp:TextBox ID="txtResult" TextMode="MultiLine" Columns="80" Rows="15"
wrap="False" Readonly="True" Runat="Server"/>
</form>
</body>
</html>
Help : How Can I take the txtResult a Print in dotmatrix Printer.
Please Help me.
---------------------------------
Free antispam, antivirus and 1GB to save all your messages
Only in Yahoo! Mail: http://in.mail.yahoo.com
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
