how to add current date and time to datacolumn of datatable in asp.net

Question

I want to save current date and time . i am adding it into datacolumn.but it giving error for IMPORT_DATE_TIME. My Code in cs file is as follow DataTable dt = new DataTable(); dt.Columns.AddRange( new DataColumn[3] { new DataColumn( "SRNO" , typeof (Int32)), new DataColumn( "BANKID" , typeof (Int32)), new DataColumn( "IMPORT_DATE_TIME" , typeof (DateTime),System.DateTime.Now.ToString( "MM/dd/yyyy HH:mm:ss tt" )) }); It gives error Syntax error: Missing operand after '13' operator.

Sachin Singh · Answer

DataColumn colDateTime = new DataColumn( "DateTimeCol" ); colDateTime.DataType = System.Type.GetType( "System.DateTime" ); then as per your code new DataCoulmn(colDateTime)

Mageshwaran R · Answer

public void NewDataTable(){ DataTable dt; DataRow dr; dt = new DataTable( "TableName" ); //ADDING DATETIME COLUMN DataColumn colDateTime = new DataColumn( "DateTimeCol" ); colDateTime.DataType = System.Type.GetType( "System.DateTime" ); dt.Columns.Add(colDateTime); //ADDING ROW TO DATA-Table dr = dt.NewRow(); dr[ "DateTimeCol" ] = System.DateTime.Now; dt.Rows.Add(myNewRow); }

Jignesh Kumar · Answer

Hi Sonali, Please use this one, DataTable dt = new DataTable(); DataRow dr; dt.Columns.AddRange( new DataColumn[3] { new DataColumn( "SRNO" , typeof (Int32)), new DataColumn( "BANKID" , typeof (Int32)), new DataColumn( "IMPORT_DATE_TIME" , typeof (DateTime)) }); dr = dt.NewRow(); dr[ "SRNO" ] = "1001" ; dr[ "BANKID" ] = "101" ; dr[ "IMPORT_DATE_TIME" ] = System.DateTime.Now.ToString( "MM/dd/yyyy HH:mm:ss tt" );

Junaid Musla · Answer

Hi, The purpose of the expression parameter of DataColumn is not what you want to achieve. I tried your code and got this as one of the possible solution. DataTable dt = new DataTable(); dt.Columns.AddRange( new DataColumn[3] { new DataColumn( "SRNO" , typeof (Int32)), new DataColumn( "BANKID" , typeof (Int32)), new DataColumn( "IMPORT_DATE_TIME" , typeof ( string )) // set this of type string. }); dt.Rows.Add(1, 1, DateTime.Now.ToString( "MM/dd/yyyy HH:mm:ss tt" )); // Format the date value when you add it to the column. Also you can refer this for expression parameter: https://docs.microsoft.com/en-us/dotnet/api/system.data.datacolumn.expression?view=netcore-3.1#System_Data_DataColumn_Expression