Answer / 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();

}
}

Answer / sam

We have give Property runat="server" for th division in aspx page

How to create discussion forum in asp.net mvc? : Asp.Net MVC

0 Answers  

---

What are user controls?

0 Answers  

---

How information about the user's locale can be accessed?

0 Answers   MindCracker,

---

Differentiate between globalization and localization.

0 Answers  

---

What is X-Path?

2 Answers   Sherston,

---

ASP.NET 2.0's new membership API used for creating and managing user account is exposed through which 2 clause?

0 Answers  

---

What is the Difference between Web.config and global.asax? Can we write connection String code in global.asax?

10 Answers   Microsystems,

---

Is it possible to change the index of primary key on table?

0 Answers  

---

What setting must be added in the configuration file to deny a particular user from accessing the secured resources?

0 Answers  

---

Explain the procedure to handle the process request using mhpm events fired? : asp.net mvc

0 Answers  

---

Which of the following hosts Can't be used to create .net Application? a) IIS b) Internet Explorer c) ASP.Net d) Windows Shell Which one is correct?

1 Answers   CTS, TCS,

---

What are the best practices to follow to secure connection strings in an ASP.NET web application?

0 Answers   MCN Solutions,

---