How return date from SQL using c# without time

Abdalla Elawad

10y1.9kVisual Basic .NET

Hi Programmer :

How return date from SQL using c# without time like in photo below attached both with code c# :

TextBox2.Text = dt.Rows[0]["Recycle_Date"].ToString();

TextBox3.Text = dt.Rows[0]["Masool_1"].ToString();

TextBox4.Text = dt.Rows[0]["Masool_2"].ToString();

TextBox5.Text = dt.Rows[0]["StartTeamDate"].ToString();

TextBox6.Text = dt.Rows[0]["NewShifitingDate"].ToString();

13 Replies

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

Midhun Tp10y ago
Accepted answer
Hi,
Try below code -
TextBox5.Text = Convert.ToDateTime(dt.Rows[0]["StartTeamDate"].ToString()).ToString(dd/MM/yyyy);
Tapan Patel10y ago
Simple solution would be to handle this on SQL Server side if feasible.
This would help you get conversion faster than writing it in c# code.
SELECTCONVERT(date,getdate())
Abdalla Elawad10y ago
Pravo Mr. Midhun
your code is working now
Manas Mohapatra10y ago
Try like below code:

Either you can change in Database side:
SELECT CONVERT(VARCHAR(10), GETDATE(),101);
or you can change in C# side:

Convert string to DateTime object and then object to string back.
// 10/22/2015 12:00:00 AM
DateTime dateOnly = DateTime.ParseExact(dateString, "MM-dd-yyyy", provider);
string temp = dateTime13.ToString();
textBox.Text = dateOnly.ToString("MM/dd/yyyy");
It is better to change in Database side if it is feasible for you.
ketan borsdiya10y ago
ok write your date column from table as below formate,
dt.Rows[0]["StartTeamDate"].ToString("dd/mm/yyyy");
Abdalla Elawad10y ago
please see to date on first screen .net above
Abdalla Elawad10y ago
hi / in sql good return
ketan borsdiya10y ago
write output of this procedure. because I dont know about your column name.
Abdalla Elawad10y ago
Use Stored Procedure as follow :
USE CASH_PLAN
GO
CREATE PROC SELECT_OPERATION
(@CARNO VARCHAR(50),
@TEAMNO VARCHAR(50))
AS
BEGIN
SELECT * FROM OPERATION WHER TEAMNO=@TEAMNO AND CARNO=@CARNO END
ketan borsdiya10y ago
Please provide your SQL Query. I will correct in your query.
Abdalla Elawad10y ago
Hi
ketan borsdiya
not understand ,Please applied your code in example
ketan borsdiya10y ago
Hi Abdalla,
write date column like CONVERT(date,InvoiceDate) in your sql query
Abdalla Elawad10y ago
Please see when execute Select btn display 00.00.00
i do not know what is problem in SQL or c# as same time SQL data type is Date