Interested to Buy Any Domain ? << Click Here >> for more details...
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#.
- 2 Answers
- 5680 Views
- I also Faced
- E-Mail Answers
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
Define dll hell?
How can you handle unmanaged code exceptions in asp.net?
What is asp net objects?
What r the asp.net list controls and diff. Between them?
Explain what does mvc represent in asp.net? : asp.net mvc
Just by seeing the signature of the bean how can you specify whether it is a stateful or stateless session bean?
What are the features of asp.net mvc?
Define cookie.
how to transfer the file from client to server using asp.net
What is sta?
What is connection pooling and how to enable and disable connection pooling?
How many types of Cookies are available in ASP.NET?
What is viewstate information stored?
What are the modes of updation in an updatepanel? What are triggers of an updatepanel?
What is web api and why to use it?
