How to write search button in database [Resolved]

Posted by chirivellaphaniraja-14771 under ASP.NET on 4/3/2012 | Points: 10 | Views : 1804 | Status : [Member] | Replies : 4
Hi to all how to write search button , the database fields is emailid, password,fullname, skills, years,months,......
skills :.net,java, php.oracle, dba.............. then if u choose .net then it will display the list of .net members with years and months
please give me answer urgently
Thanks to u all




Responses

Posted by: chirivellaphaniraja-14771 on: 4/4/2012 [Member] Starter | Points: 25

Up
0
Down

Resolved
Thank u sabarimahesh

chirivellaphaniraja-14771, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajni.Shekhar on: 4/3/2012 [Member] Bronze | Points: 25

Up
0
Down
take a drop down filled by skills and on change of dropdown value call a jquery function to get all data from data base where skill=".net" from database.

You can do it in C# also or for efficient use jquery.

Thanks,
Rajni Shekhar

chirivellaphaniraja-14771, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sabarimahesh on: 4/3/2012 [Member] Bronze | Points: 25

Up
0
Down
SqlConnection con = new SqlConnection("Ur Connection)


SqlCommand cmd = new SqlCommand("select * from Tablename where Skill= '" + TextBox1.Text + "' ", con);

con.Open();

cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "Tablename");
GridView1.DataSourceID = null;
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}


This Might be Useful...
if it is useful Mark As Answer

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

chirivellaphaniraja-14771, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sabarimahesh on: 4/4/2012 [Member] Bronze | Points: 25

Up
0
Down
Chirivella.Phaniraja@Gmail.Com

You are Welocome Man....


If You Feel This as a Answer ...

Plz...
Click That Mark as Answer

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

chirivellaphaniraja-14771, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response