protected void New1(object sender, EventArgs e)
{
String strConn3 = "Provider=Microsoft.Jet.OLEDB.4.0; "
+ "Data Source=" + Request.ServerVariables["APPL_PHYSICAL_PATH"]
+ "/Database/Company.mdb";
String sqlSelect = "Select * "
+ "from Performance_Review "
+ "INNER JOIN Employee "
+ "ON Performance_Review.ee_ID = Employee.ssn "
+ "WHERE Employee.ssn="
+ ddlEmp.Text;
}
<div>
<asp:DropDownList ID="ddlEmp" runat="server">
<asp:ListItem>Item1</asp:ListItem>
<asp:ListItem>Item2</asp:ListItem>
</asp:DropDownList>
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" /><br />
<asp:TextBox ID="TextBox1" runat="server" Visible="false"></asp:TextBox><br />
<asp:TextBox ID="TextBox2" runat="server" Visible="false"></asp:TextBox>
</div>
protected void Button1_Click(object sender, EventArgs e)
{
String strConn3 = "Provider=Microsoft.Jet.OLEDB.4.0; "
+ "Data Source=" + Request.ServerVariables["APPL_PHYSICAL_PATH"]
+ "/Database/Company.mdb";
SqlConnection con = new SqlConnection(strConn3);
String sqlSelect = "Select * "
+ "from Performance_Review "
+ "INNER JOIN Employee "
+ "ON Performance_Review.ee_ID = Employee.ssn "
+ "WHERE Employee.ssn="
+ ddlEmp.SelectedItem.Text;
SqlDataAdapter da = new SqlDataAdapter(sqlSelect, con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
TextBox1.Text = dt.Rows[0]["ee_ID"].ToString();
TextBox2.Text = dt.Rows[0]["ee_year"].ToString();
TextBox1.Visible = true;
TextBox2.Visible = true;
}
else
{
TextBox1.Visible = false;
TextBox2.Visible = false;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
String strConn3 = "Provider=Microsoft.Jet.OLEDB.4.0; "
+ "Data Source=" + Request.ServerVariables["APPL_PHYSICAL_PATH"]
+ "/Database/Company.mdb";
String sqlSelect = "Select * "
+ "from Performance_Review "
+ "INNER JOIN Employee "
+ "ON Performance_Review.ee_ID = Employee.ssn "
+ "WHERE Employee.ssn="
+ ddlEmp.SelectedItem.Text;
OleDbConnection objConn3 = new OleDbConnection(strConn3);
OleDbCommand objCommand3 = new OleDbCommand(sqlSelect, objConn3);
OleDbDataAdapter objAdapter3 = new OleDbDataAdapter(objCommand3);
DataSet objDataSet = new DataSet();
DataTable dt = new DataTable();
objAdapter3.Fill(objDataSet, "dt");
if (dt.Rows.Count > 0)
{
eeID.Text = dt.Rows[0]["ee_ID"].ToString();
evalyr.Text = dt.Rows[1]["evaluation_year"].ToString();
eeID.Visible = true;
evalyr.Visible = true;
}
else
{
eeID.Visible = false;
evalyr.Visible = false;
}
}
or use a span and just change the visible state of the span from false to true and vice versa