hi every one ..
i have login.aspx page with 2 textboxes ( userName and password ) and one button "login" .
once user put correct values , he/she goes to default.aspx .
and i have AUTHORS table in database contain more than one row .
this is code for " login " button , i know it is very easy :$ :$ but i dont know what's the wrong with it !
SqlConnection sqlcon = new SqlConnection();
sqlcon.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlCommandBuilder sqlComd;
SqlDataAdapter sqlAdapter = new SqlDataAdapter();
DataSet dataset = new DataSet();
string sqlString = "SELECT * FROM AUTHORS";
sqlComd = new SqlCommandBuilder(sqlAdapter);
sqlAdapter.SelectCommand = new SqlCommand(sqlString, sqlcon);
sqlAdapter.Fill(dataset, "AUTHORS");
...
Go to the complete details ...