How to insert the date in DB using the dataset

[kanimozhiz]

Hi
I am trying to insert the data in the DB(sql server2005) using the dataset. I was trying to insert the data using the stored procedures.The problem is I am unable to insert the 'date' in the DB.

It shows an error as "Cannot convert from 'int' to 'System.DateTime' ". plz anyone help me if u know the answer.

Thanks & Regards,
kani.z

[CyberSoftHari]

This error shows you that you are trying to (convert int to date time) insert int value to typeof datetime field. It will be easy to find only you post the code from insert part.

[kanimozhiz]

This error shows you that you are trying to (convert int to date time) insert int value to typeof datetime field. It will be easy to find only you post the code from insert part.

This is the code I have written in class file.
The class name is Corporate.cs
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Summary description for Corporate
/// </summary>
public class corporate
{
public corporate()
{
CorporateTableAdapters.CorporateTableAdapter cta = new CorporateTableAdapters.CorporateTableAdapter();
Corporate.CorporateDataTable cdt;
cdt = cta.GetDataByinsertCorporate("pizzahut", "raja", 2365412, "[e-mail]", "123456",6/26/2005, 6/26/2005, 6 / 26 / 2005, 1, 6/ 26 / 2006, 1, 6 / 26 / 2006);
}
}

This is the code I am trying to insert the data in the Corporate table. but the error occured as "cannot convert from 'int' to 'System.DateTime' " plz help me if u know the solution.

Thanks & Regards,
kani.z

[Curtis Rutland]

Put single quotes around your dates. The Sql engine is trying to integer divide the numbers you provide, and then insert the result as a date. It can't make that cast. It can cast a datetime from a string though.

This is the code I have written in class file.
The class name is Corporate.cs
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Summary description for Corporate
/// </summary>
public class corporate
{
public corporate()
{
CorporateTableAdapters.CorporateTableAdapter cta = new CorporateTableAdapters.CorporateTableAdapter();
Corporate.CorporateDataTable cdt;
cdt = cta.GetDataByinsertCorporate("pizzahut", "raja", 2365412, "[e-mail]", "123456",6/26/2005, 6/26/2005, 6 / 26 / 2005, 1, 6/ 26 / 2006, 1, 6 / 26 / 2006);
}
}

This is the code I am trying to insert the data in the Corporate table. but the error occured as "cannot convert from 'int' to 'System.DateTime' " plz help me if u know the solution.

Thanks & Regards,
kani.z