gridview data in single button click

Question

when i enter employee_id nd press SHOW button then show griedview data for perticular employee_id data Using visual studio 2008 c#.net with sql server 2005

Khan Abrar Ahmed · Answer

AutoGenerateColumns="False" > SortExpression="FirstName" /> SortExpression="SecondName" /> SortExpression="ThirdName" /> SortExpression="EmployeeID" /> ConnectionString=" " SelectCommand="SELECT [FirstName], [SecondName], [ThirdName], [EmployeeID] FROM [Users] WHERE ([EmployeeID] = @EmployeeID)" > PropertyName="Text" Type="String" /> in .cs file protected void btnShow_Click(object sender, EventArgs e) { ParameterCollection prm = SqlDataSource1.SelectParameters; prm[0].DefaultValue = txtEmpID.Text; }

Khan Abrar Ahmed · Answer

HI, Can you please send the aspx and aspx.cs code so I can look on it.

pankaj diyora · Answer

I got this error "System.Data.SqlClient.SqlException: Must declare the scalar variable "@EMP_ID"." where i implement this code employeeupdate.aspx Update Employess Details Emp Id : --%> " SelectCommand="SELECT [EMP_ID], [EMP_F_NAME], [EMP_L_NAME], [EMP_ADDRESS], [EMP_CITY], [EMP_PHONE_NO], [EMP_MOBILE_NO], [EMP_SALARY], [EMP_REMARKS], [EMP_EMAIL], [EMP_DESIGNATION], [EMP_GEN] FROM [EMPLOYEE_MASTER] WHERE [EMP_ID] = @EMP_ID" > .cs file protected void btnShow1_Click(object sender, EventArgs e) { ParameterCollection prm = SqlDataSource1.SelectParameters; prm[0].DefaultValue = txtEmpId.Text; }

Munesh Sharma · Answer

you can do this by using drop down list, if you click on ID in drop down list you can get all data. C lick on drop down list in write this code { string str = "server = MUNESH\SQL2008R2;Database=datastore;UID=sa;Password=123;" ; SqlConnection con = new SqlConnection(str); string query = "select * from tablename where name = '" + dropdownlist .text+ "' " ; SqlCommand cmd = new SqlCommand( query,con); sqldatareader dbr; try { con.open(); dbr = cmd.executereader(); while (dbr.read()) { string sID = ( string ) dbr[ "ID" ].tostring; string sname = ( string ) dbr[ "name" ] // name is string value string sage = ( string ) dbr[ "age" ].tostring; textbox1.text = sid; textbox2.text = sname; textbox3.text = sage; showgrid(); } catch (execption es) { messagebox.show(es.message); } } } If you want to more operation with grid view or data gridview then go to my C-sharp corner blogs.

pankaj diyora · Answer

PLZ DEAR GIVE ME AN EXAMPLE OF THAT

Khan Abrar Ahmed · Answer

HI, public Datatable bindGridview(int empID) { //Call the store procedure or sql query to get the data from database DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count == 0) { GridView1.Visible = false; } else { GridView1.Visible = true; GridView1.DataSource = dt; GridView1.DataBind(); } } protected void Button1_Click(object sender, EventArgs e) { bindGridview(empID) } Hope this will help.

gridview data in single button click

Answers (6)