hi
i want put search engine like google in my web site this is my code :
body> <form id="form1" runat="server"> <div> <asp:TextBox ID="TextBox1" runat="server" AutoCompleteType="Search"></asp:TextBox> <asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" /> </div> <asp:GridView ID="GridView1" runat="server"> </asp:GridView> </form>
AND FOR BUTTON
protected void Button1_Click(object sender, EventArgs e) { SqlDataAdapter _da = new SqlDataAdapter("SELECT * FROM main WHERE name=@name", _cn); _da.SelectCommand.Parameters.AddWithValue("@name", TextBox1.Text); _cn.Open(); _da.Fill(_ds, "name"); _cn.Close(); GridView1.AutoGenerateColumns = true; GridView1.DataSource = _ds; GridView1.DataMember = "name"; GridView1.DataBind(); } }
I HAVE 2 question:
1-at first when user type some word in text box it show some words that associated Words typed by a user EX: when user typed Soft ,in TB show (software,computer software and...)means show some defult word in TB
like google
how i can do it?
2-i want when user type forexample COM in TB, it show all row in my database that related to COM in grid view i write this code but it does not work
SqlDataAdapter _da = new SqlDataAdapter("SELECT * FROM main WHERE name like '%@name%' ", _cn); _da.SelectCommand.Parameters.AddWithValue("@name", TextBox1.Text); _cn.Open(); _da.Fill(_ds, "name"); _cn.Close(); GridView1.AutoGenerateColumns = true; GridView1.DataSource = _ds; GridView1.DataMember = "name"; GridView1.DataBind();
how i can do it?
tanx
