Error in foreach loop.,

I tried to get data from database table(login_master)., i tried this in gridview but without gridview how can i get this.

Here is the code, that is what i tried now to reach the requirement :

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 ("");

Response.Write("

");

foreach(string[] x in objTable.Rows)

{

Response.Write("

");

Response.Write("

");

Response.Write("

");

Response.Write("

");

Response.Write("

") ;

}

Response.Write("

Email	Name	Emp_password
" & x("Email") & "	" & x("Name") & "	" & x("Emp_password") & "

");

dbconn.Close();

Error is: x is a variable but you used like a method in for loop.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.