I have a webform in asp.net.In that webform there is 2
division class(DIV).in one of the div class there is a text
box for enter the id & a button for to check id with
database value.My doubt is that how can i appear the 2nd
Div contents only when the id is true with database
value.if wrong do not display the div . i Want code in c#.
Answer Posted / jyothis
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string flag;
object dsd;
flag= setconnection();
if (flag=="True" )
{
dsd = getconnection();
MyDiv.Visible=true;
GridView1.DataSource = dsd;
GridView1.DataBind();
}
}
public object getconnection()
{
String constr =
ConfigurationManager.ConnectionStrings["ConnectDBString"].ConnectionString;
SqlConnection con = new SqlConnection();
con.ConnectionString = constr;
String query = "SELECT * FROM EMPLOYEE WHERE
EmployeeName = '" + TextBox1.Text + "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = query;
cmd.Connection = con;
con.Open();
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(ds,"EMPLOYEE");
return (ds);
con.Close();
}
public string setconnection()
{
String constr =
ConfigurationManager.ConnectionStrings["ConnectDBString"].ConnectionString;
SqlConnection con = new SqlConnection();
con.ConnectionString=constr;
String query = "SELECT * FROM EMPLOYEE WHERE
EmployeeName = '" + TextBox1.Text + "'";
SqlCommand cmd =new SqlCommand();
cmd.CommandText= query;
cmd.Connection=con;
con.Open();
string hd;
hd="False";
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
int ID = (int)dr["ID"];
string Name = (string)dr["EmployeeName"];
}
if (dr.FieldCount >1)
{
hd="True";
}
}
return(hd);
con.Close();
}
}
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can you access the properties and controls of master pages from content pages?
What is the full form of asp.net?
What are early binding and late binding.
What is data reader in asp.net?
Explain the difference between panel and groupbox classes using .net?
Describe a Windows Service and its lifecycle ?
Which Is Faster MVC or ASP.net ?
What are the modes of updation in an updatepanel? What are triggers of an updatepanel?
Can you explain page lifecycle in net?
Describe briefly what is the role of IIS on an ASP.NET application? What does it for the same application?
To redirect the user to another page which method do we use without performing a round trip to the client?
What is virtual directory in asp.net?
How do cookies work?
Is asp.net core faster?
What are the asp.net list controls and difference between them?