-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Sooraj
Message 4 in Discussion
Hi
Please try to use the Command Parameters.
eg:
seq = "SELECT Name FROM test WHERE [EMAIL PROTECTED]" 'Id as the parameter
Dim cmd As SqlCommand = New SqlCommand(seq, New SqlConnection("Server=<your
server name>;Database=<your database name>;Trusted_Connection=True;"))
cmd.Connection.Open()
'Add Parameter and set its value
cmd.Parameters.Add("@Id", SqlDbType.VarChar, 50).Value = id
Dim datareader As SqlDataReader = cmd.ExecuteReader()
DataGrid1.DataSource = datareader
DataGrid1.DataBind()
Sooraj
Microsoft India Community Star
http://www.microsoft.com/india/communitystar/currentselections.aspx
----- Original Message ----
From: MohangandhiC <[EMAIL PROTECTED]>
To: BDOTNET <[email protected]>
Sent: Monday, February 5, 2007 9:49:50 AM
Subject: Re: How display data from DB by selecting from DropdownList
<STYLE type=text/css>
/* Foreground colors */
ThmFgColumnHeader, A.FrameLink, A.HeaderLink, A.FooterLink, A.LgtCmd, A.MSNLink
{color:#FFFFFF;}
ThmFgTitleLightBk {color:#FF6600;}
ThmFgSmallLight {color:#ff0000;}
ThmFgNavLink, A.NavLink, A.ChildLink:hover {color:#666699;}
ThmFgInactiveText, A.SystemLink {color:#666666;}
ThmFgFrameTitle {color:#FFFFCC;}
ThmFgTitleDarkBk, A.NavLink:hover, A.TitleLink {color:#CC6600;}
ThmFgMiscText, A.Cat, A.SubCat {color:#336699;}
ThmFgCommand, A.Command, A.LargeCommand, A.MsgLink {color:#003366;}
ThmFgHeader {color:#333333;}
ThmFgStandard, A.SystemLink:hover, A.SubLink, A.ChildLink, A.StdLink,
SELECT.Standard {color:#000000;}
ThmFgDivider {color:#CCCCCC;}/* primarily for HR tags */
/* Background colors */
ThmBgStandard {background-color:#FFFFFF;}
ThmBgUnknown1 {background-color:#FF6600;}
ThmBgFraming {background-color:#666699;}
ThmBgUnknown2 {background-color:#666666;}
ThmBgHighlightDark {background-color:#FFFFCC;}
ThmBgHighlightLight, #idToolbar, #tbContents {background-color:#FFFFE8;}
ThmBgTitleDarkBk {background-color:#F1F1F1;}
ThmBgAlternate {background-color:#ECF1F6;}
ThmBgUnknown3 {background-color:#CCCCFF;}
ThmBgDivider {background-color:#CCCCCC;}
ThmBgHeader {background-color:#9999CC;}
ThmBgLinks {background-color:#8696C9;}
ThmBgSharkBar {background-color:#8696C9;}
ThmBgGlobalNick {background-color:#9394A9;}
/* Calendar styles */
calfgndcolor {color:#E00505;}
calbgndcolor {color:#E00505;}
</STYLE>
New Message on BDOTNET
How display data from DB by selecting from DropdownList
Reply
Reply to Sender Recommend
Message 3 in Discussion
From: MohangandhiC
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.
View other groups in this category.
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
Need help? If you've forgotten your password, please go to Passport Member
Services.
For other questions or feedback, go to our Contact Us page.
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.
Remove my e-mail address from BDOTNET.
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]
