none
How i chage column datatype which in dataset to SQldb.DateTime. RRS feed

All replies

  • Hi,

     

    Is your columns datatype a string?

     

    Try the SqlDateTime dt = Convert.ToDateTime(strDate);

     

    Try posting some more info about the problem. This will makes it easy for anyone to understand the problem.

     

     

    HTH,
    Suprotim Agarwal

    -----
    http://www.dotnetcurry.com
    -----

    Friday, November 2, 2007 9:34 AM
  • I am doing project of db migration

    In that

    # I get Data from Access db to Dataset

    # That dataset I update to databae throw sqlbulkcopy.write mwthod.

    # for coloumn i get error  datatype of that in db is dateTime and in sql aslo same.

    Friday, November 2, 2007 9:41 AM
  • Are you using Integration Services to do the migration?

     

     

    Friday, November 2, 2007 9:53 AM
  • yaa, i am using web service for that

    Friday, November 2, 2007 9:55 AM
  • Hi,

     

    Post your code over here :

     

    Also the error that occurs.

     

     

    HTH,
    Suprotim Agarwal

    -----
    http://www.dotnetcurry.com
    -----

     

    Friday, November 2, 2007 9:58 AM