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

Question

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'.)

Senthilkumar · 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(); } }

Senthilkumar · Answer

Hi Selvi If you have any requirement to retrieve the time for particular user then you need to check for that user.

selvi subramanian · Answer

select logintime from tablename;

selvi subramanian · Answer

ya nice senthil but username=test whats that test tel that one

selvi subramanian · Answer

it throws error ma.

Satyapriya Nayak · Answer

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