-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: BalajiKrishnan
Message 1 in Discussion
Hi Friends,
Review the code below....
When i print the value of NO it prints - 2
So I have two rows in my data grid......
Dim NO As Integer
NO = DataGrid1.Items.Count
Dim I As Integer
For I = 0 To NO - 1
Dim txtSelTable = "ExchData_" & Trim(CType(DataGrid1.Items.Item(I).FindControl("ID"),
Label).Text)
Dim StrConnection As String
StrConnection = ConfigurationSettings.AppSettings("connString")
Dim Conn As New SqlConnection(StrConnection)
Dim ArgSQL As String = "SELECT * FROM " & txtSelTable & " WHERE year = '" &
Trim(CType(DataGrid1.Items.Item(I).FindControl("Year"), Label).Text) & "' and & Month
= '" & Trim(CType(DataGrid1.Items.Item(I).FindControl("Month"), Label).Text) & "'"
Response.Write(ArgSQL)
Next I
WHEN I PRINT THE ArgSQL
It Prints only once - the Sql Statement is printed for the first row.....
help me pls...Balaji.K
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
