Displaying data in same gridview when particular hyperlink is clicked.

Abumiyan Muqri

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..

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhijit barua14y ago
Accepted answer
u can do like below...
i take 2 table like this SAP(user_id,pwd), os(user_id,pwd)
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 Muqri14y ago
Problem Solved:)
Thanks buddy...:):)
Abhijit barua14y ago
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 Muqri14y ago
But I have buttons on differnt page and gridview on differnt page. Refer my code file.
Abumiyan Muqri14y ago
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 barua14y ago
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 Muqri14y ago
Thanks for replying. Can u please show me some code row_databiund?
and also how to write conditions in that...
Abhijit barua14y ago
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.