I need retrieve time from sqlserver to asp.net using c# in a textbox

selvi subramanian

14y2.3k.NET

i need retrieve time from sqlserver to asp.net using c# in a textbox.........

protected void Page_Load(object sender, EventArgs e)
{
SqlDataReader sdr = null;
string qry = "select logintime from logintime";
ds = net.GETDS(qry);
da.Fill(ds, "logintime");
// TextBox1.Text = ds.Tables["logintime"].Rows[indes]["logintime"].ToString();
while (sdr.Read())
{
TextBox1.Text = sdr["logintime"].ToString();
}
}
}

it throws the error like this ( The SelectCommand property has not been initialized before calling 'Fill'.)

6 Replies

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

Senthilkumar14y ago
Accepted answer
Hi Selvi,

protected void Page_Load(object sender, EventArgs e)
{

SqlConnection sqlConnection = new SqlConnection(ConnectionString);
sqlConnection .Open();

string SqlQuery = "SELECT TOP 1 logTime FROM LogDetails WHERE username=test";
SqlCommand sqlCommand = new SqlCommand( SqlQuery , sqlConnection );
SqlDataAdapter adapter = new SqlDataAdapter(sqlCommand);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet );

if( dataSet != null)
{
TextBox1.Text = dataSet.Tables[0].Rows[0][0].ToString();
}



sqlConnection .Close();

}
}
Senthilkumar14y ago
Hi Selvi,

If you have any requirement to retrieve the time for particular user then
you need to check for that user.
selvi subramanian14y ago
"select logintime from tablename";
selvi subramanian14y ago
ya nice senthil but username=test whats that test tel that one
selvi subramanian14y ago
it throws error ma.,
Satyapriya Nayak14y ago
Hi Selvi,

Try...

protected void Page_Load(object sender, EventArgs e)
{

con.Open();

string qry = "select logintime from logintime";
SqlCommand com = new SqlCommand(qry, con);
SqlDataReader sdr = null;
sdr=com.ExecuteReader();

while (sdr.Read())
{
TextBox1.Text = sdr["logintime"].ToString();
}

con.Close();
sdr.Close();
}
}

Thanks