Comments by Member 13802222 (Top 8 by date)

thanks.alright.

thank you for replying.
how do i mark the data?

<title>

#Select1
{
width: 197px;
}







<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource1" DataTextField="Album_name"
DataValueField="Album_name">
<asp:listitem>Lamborghini
<asp:listitem>BMW

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:iuploadaz %>"
SelectCommand="SELECT [Album_name] FROM [tb_Gallery]">
<asp:ScriptManager ID="ScriptManager1" runat="server">

<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />
<asp:AnimationExtender ID="Button1_AnimationExtender" runat="server"
Enabled="True" TargetControlID="Button1">

<asp:GridView ID="gvsearch" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" Width="305px">
<columns>
<asp:BoundField DataField="Album_name" HeaderText="Album_name"
SortExpression="Album_name" />


<asp:ListBox ID="ListBox1" runat="server" DataSourceID="SqlDataSource1"
DataTextField="Album_name" DataValueField="Album_name">




....
code:
public partial class searchaz : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["iuploadaz"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)
{

// Label3.Text = a.ToString();
}

protected void Button1_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("select * from tb_Gallery", con);
// SqlDataAdapter da = new SqlDataAdapter(cmd);

// DataSet ds = new DataSet();
// da.Fill(ds, "album_name");
// DropDownList1.DataSource = ds;
// DropDownList1.DataTextField = "album_name";
//DropDownList1.DataBind();
SqlDataAdapter da = new SqlDataAdapter("select album_name from tb_Gallery where album_name like '" + DropDownList1.Text + "'", con);
//DataSet ds = new DataSet();
//da.Fill(ds);
//DropDownList1.DataSource = ds;
//DropDownList1.DataTextField = "album_name";
//DropDownList1.DataBind();
//gvsearch.DataSource = ds;
//gvsearch.DataBind();

}
}
}