How to write search button in database [Resolved]

Posted by chirivellaphaniraja-14771 under ASP.NET on 4/3/2012 | Points: 10 | Views : 2615 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

0	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

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

0	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

Latest Posts