-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: MohangandhiC
Message 3 in Discussion
Hope the following snip will help u in better way: Try Dim id As String
Dim seq As String id = DropDownList1.SelectedValue seq = "SELECT Name FROM
test WHERE ID =" + DropDownList1.SelectedValue Dim cmd As SqlCommand = New
SqlCommand(seq, New SqlConnection("Server=<your server name>;Database=<your
database name>;Trusted_Connection=True;")) cmd.Connection.Open() Dim
datareader As SqlDataReader = cmd.ExecuteReader() DataGrid1.DataSource =
datareader DataGrid1.DataBind() cmd.Connection.Close()
cmd.Connection.Dispose() Catch ex As Exception 'Handle exception End Try
Ofcourse this code should be with proper convention!! Thanks,
MohanGandhi. C
pravi-pravi <[EMAIL PROTECTED]> wrote: New Message on BDOTNET
How display data from DB by selecting from
DropdownList
Reply
Reply
to Sender Recommend Message 1 in Discussion From: pravi-pravi
Sir, By using SQLString = "SELECT Name FROM test WHERE ID =
+DropDownList1.SelectedValue"
I got the selected item from dropdown list.Now how can i place the out put of
the query in a DataGrid? i want the syntax or coding?
This is the code that i have written,,,But not getting the query out put?? Dim
id As String Dim seq As String id = DropDownList1.SelectedValue seq =
"SELECT Name FROM test WHERE ID =" + DropDownList1.SelectedValue
DataGrid1.DataSource = seq DataGrid1.DataBind() Pleas help me...
View other groups in this category.
Cheers, MohanGandhi. C<o:p></o:p>
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.
-----------------------------------------------------------
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]
