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
- 4636 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
How will you maintain versioning in asp.net 2.0?
How can we access static variable?
How do you do Client-side validation in .Net?
Write a code snippet to implement the indentation in json in web api.
Write code to send e-mail from an asp.net application?
How can we pass info between 2 asp.net pages?
Why viewstate is used in asp.net?
Why session is used in asp.net?
I want to connect a system in LAN and I want to access that. Whenever I am moving a mouse in my desktop, the similar thing has to happen in another system in which I have connected. I need coding for this in C# and ASP.NET Can anyone please help me. It is very urgent. Thanks in advance. My email id is manojkumarchallagundla@gmail.com Will you please?
Difference between singleton and singlecall.
If iam developing an application that must accomodate multiple security levels though secure login and my asp.net web appplication is spanned across three web-servers (using round-robbin load balancing) what would be the best approach to maintain login-in state for the users?
Difference between .NET and previous version?
How Session outproc in Sqlserver stored?
What is the full form of asp.net?
Explain Areas in MVC?
