I need the time from sqlserver

Question

i need the time from sqlserver (i already created the table in that table i store the system time .... i need that time in asp.net in page load and i need it in a textbox )

khaleel shaik · Answer

protected void Page_Load(object sender, EventArgs e) { string connection1 = "connectionstring"; SqlConnection connection = new SqlConnection(connection1); connection.Open(); sqlcommand cmd=new sqlcommand("select tablefieldnamefortimefiled from tablename",connection); sqldataadapter da=new dataadapter(cmd); dataset ds=new dataset(); da.fill(ds,"tablename"); txt1.text=ds.tables["tablename"].rows[indes][" tablefieldnamefortimefiled "].tostring(); connection.close(); } try this code go got the solution

Narayan · Answer

Try to use GETDATE() function in sql server to get the server time.

Keyur Narkhi · Answer

Hi Below is the code protected void Page_Load(object sender, EventArgs e) { string connection1 = "connectionstring"; SqlConnection connection = new SqlConnection(connection1); connection.Open(); SqlDataReader myReader = null; SqlCommand myCommand = new SqlCommand("SELECT CONVERT(VARCHAR(8),GETDATE(),108) AS HourMinuteSecond", connection); myCommand.Connection = connection; myReader = myCommand.ExecuteReader(); while (myReader.Read()) { txt1.Text = myReader["HourMinuteSecond"].ToString(); } } thanks

MuthuMari M · Answer

Hi, pls refer this samples they add the items in the list box. you have to use text box. ie create conn, read data use sqldata reader. For this you have to write the code in a page load using postback method. http://www.akadia.com/services/dotnet_data_reader.html thanks. If this post is useful then mark it as " Accepted Answer "

I need the time from sqlserver

Answers (4)