Displaying data in same gridview when particular hyperlink is clicked.

Question

I have 2 Hyperlinks(SAP and OS) on one Page and a Gridview on another page.
When HyperLink(SAP) is clicked,onto the next page a panel with 3 text boxes and SEARCH button appears. after clicking SEARCH button i want to display data of SAP table(user_id,Descriptio,sap_system_password) in Gridview.
When Hyperlink(OS) is clicked,onto the next page a panel with 2 text boxes and SEARCH button appears. after clicking SEARCH button i want to display data of OS table(user_id,Descriptio,os_system_password) in the same Gridview.

The Gridview has 4 columns(UserID,Description,Password,Change Password)
SAP table contains fields as(sid,client_no,user_id,sap_system_password,description)
OS table contains fields as(user_id,ip,host_name,os_system_password,description)

How to do this? Please help..

Abhijit barua · Answer

u can do like below... i take 2 table like this SAP(user_idpwd) os(user_idpwd) aspx page like below onrowdatabound=GridView1_RowDataBound> .cs page SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings[Booking].ConnectionString); int count = 0; int count1 = 0; protected void Page_Load(object sender EventArgs e) { } protected void GridView1_RowDataBound(object sender GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { //GridViewRow row = e.Row; Label sapuid = (Label)e.Row.FindControl(Label80); Label osuserid = (Label)e.Row.FindControl(Label81); Label sappwd = (Label)e.Row.FindControl(Label82); Label ospwd = (Label)e.Row.FindControl(Label83); if (Session[b_click] == SAP) { GridView1.Columns[0].Visible = true; GridView1.Columns[2].Visible = true; GridView1.Columns[1].Visible = false; GridView1.Columns[3].Visible = false; SqlDataAdapter da2 = new SqlDataAdapter(select * from sap con1); DataTable dt2 = new DataTable(); da2.Fill(dt2); sapuid.Text = dt2.Rows[count][0].ToString(); sappwd.Text = dt2.Rows[count][1].ToString(); count++; } else { GridView1.Columns[1].Visible = true; GridView1.Columns[3].Visible = true; GridView1.Columns[0].Visible = false; GridView1.Columns[2].Visible = false; SqlDataAdapter da2 = new SqlDataAdapter(select * from os con1); DataTable dt2 = new DataTable(); da2.Fill(dt2); osuserid.Text = dt2.Rows[count1][0].ToString(); ospwd.Text = dt2.Rows[count1][1].ToString(); count1++; } } } protected void Button1_Click(object sender EventArgs e) { Session[b_click] = SAP; SqlDataAdapter da1 = new SqlDataAdapter(select * from sap con1); DataTable dt1 = new DataTable(); da1.Fill(dt1); if (dt1.Rows.Count > 0) { GridView1.DataSource = dt1; GridView1.DataBind(); //DataSet ds1 = new DataSet(); //ds1.Tables.Add(dt1); //Session.Add(ds1 ds1); } } protected void Button2_Click(object sender EventArgs e) { Session[b_click] = OS; SqlDataAdapter da2 = new SqlDataAdapter(select * from os con1); DataTable dt2 = new DataTable(); da2.Fill(dt2); if (dt2.Rows.Count > 0) { GridView1.DataSource = dt2; GridView1.DataBind(); //DataSet ds2 = new DataSet(); //ds2.Tables.Add(dt2); //Session.Add(ds2 ds2); } } u get attachment where i give code and table script....i have not get your code...i hope this will work...

Abumiyan Muqri · Answer

Problem Solved:) Thanks buddy...:):)

Abhijit barua · Answer

protected void Button1_Click(object sender EventArgs e) { Session[b_click] = SAP; response.redirect(your page); } protected void Button2_Click(object sender EventArgs e) { Session[b_click] = OS; response.redirect(your page); } at that page check session value and bind.

Abumiyan Muqri · Answer

But I have buttons on differnt page and gridview on differnt page. Refer my code file.

Abumiyan Muqri · Answer

Hi please refer the attachments for code file.. I want to display only four columns in Gridview(User ID Description Password Change Password). But if search button of SAP is clicked then data of SAP table should be displayed and if search button of OS is clicked then data of OS table should be displayed. Now tel me what changes i need to do in my code..

Abhijit barua · Answer

protected void GridView2_RowDataBound(object sender GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { Label no_of_veh = (Label)e.Row.FindControl(Label84); Label book_id = (Label)e.Row.FindControl(Label82); Button btassing = (Button)e.Row.FindControl(bttnassignveh); } } Like this you can find control of that gridview. now based on condition make control visible false.

Abumiyan Muqri · Answer

Thanks for replying. Can u please show me some code row_databiund? and also how to write conditions in that...

Abhijit barua · Answer

u have to condition based on 2 condition bind grid with two datatable. take all necessary field at gridview as template filed and at row_databind of your gridview check condition based on that do visible true/false.