Ado.net, DateTime in SqlCommand

Question

I have DataSet "_cinemaZone" with DataTable "SessionsCinema", this DataTable has DataColumn "sessionDateTime" with DataType - "typeof(System.DateTime)".

Help me, please, to use "sessionDateTime" field in SqlCommand.

My wrong tries:

//first
commandSql.Parameters.Add("@sessionDateTime", SqlDbType.DateTime, sizeof(DateTime), "sessionDateTime");

//second
commandSql.Parameters.Add("@sessionDateTime", SqlDbType.DateTime);
commandSql.Parameters["@sessionDateTime"].Value = sessionDateTime;

//third
commandSql.Parameters.Add("@sessionDateTime", SqlDbType.DateTime);
commandSql.Parameters["@sessionDateTime"].Value = Convert.ToDateTime(_cinemaZone.Tables["SessionsCinema"].Columns["sessionDateTime"]);

Pantelis · Accepted Answer · 2014-04-10 23:07:08Z

2

foreach (DataRow row in _cinameZone.Tables["SessionsCinema"].Rows)
{
    var sqlParameter = new SqlParameter("@paramName", SqlDbType.DateTime) 
                       { 
                           Value = Convert.ToDateTime(row["sessionDateTime"].Value);                              
                       }
    cmd.Parameters.Add(sqlParameter);
}

answered Apr 10, 2014 at 23:07

Pantelis

2,0703 gold badges26 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Ado.net, DateTime in SqlCommand

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related