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

Sonali Avhad

6y5.6kLearn iOS Programming

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.

4 Replies

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

Mageshwaran R6y ago
1. public void NewDataTable(){
2. DataTable dt;
3. DataRow dr;
4. dt = new DataTable("TableName");
5. //ADDING DATETIME COLUMN
6. DataColumn colDateTime = new DataColumn("DateTimeCol");
7. colDateTime.DataType = System.Type.GetType("System.DateTime");
8. dt.Columns.Add(colDateTime);
9. //ADDING ROW TO DATA-Table
10. dr = dt.NewRow();
11. dr["DateTimeCol"] = System.DateTime.Now;
12. dt.Rows.Add(myNewRow);
13. }
+1

Jignesh Kumar6y ago

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 Musla6y ago

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

Sachin Singh6y ago

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