I tried to get data from database table(login_master)., i tried this in gridview but without gridview how can i get this.
<%
SqlConnection dbconn;
SqlDataAdapter objAdapter;
DataTable objTable;
DataRow objRow;
DataSet objDataSet =new DataSet();
dbconn=new SqlConnection("Data Source = E-SOFT-5; Initial Catalog = attend; User Id = sa; Password = e-soft");
objAdapter=new SqlDataAdapter("SELECT * FROM login_master",dbconn);
objAdapter.Fill(objDataSet,"login_master");
objTable=objDataSet.Tables.Add("login_master");
objRow=objTable.Rows.Add(0);
Response.Write ("<table border='1'>");
Response.Write("<tr><th>Email</th><th>Name</th><th>Emp_password</th></tr>");
foreach(string[] x in objTable.Rows)
{
Response.Write("<tr>");
Response.Write("<td>" & x("Email") & "</td>");
Response.Write("<td>" & x("Name") & "</td>");
Response.Write("<td>" & x("Emp_password") & "</td>");
Response.Write("</tr>") ;
}
Response.Write("</table>");
dbconn.Close();
%>