Insertion process in vb.net RSS

• • Reply
  

  SudhaRubini

  Member

  391 Points

  383 Posts

  Insertion process in vb.net

  May 17, 2012 05:58 AM|LINK

  Hi,

   In a single table i want to save three records in at a time. with a single query. how i can do?  can u give a  simple example?

  please its very urgent..........................

• • Reply
  

  cninjas

  Contributor

  4868 Points

  851 Posts

  Re: Insertion process in vb.net

  May 17, 2012 06:08 AM|LINK

  hi

  Can you try this below example. You can use the Bulklcopy to do this

  http://www.dotnetcurry.com/ShowArticle.aspx?ID=323

  hope it helps,thanks.

  Microsoft Community Contributor 2011
  Niranjan
• • Reply
  

  SudhaRubini

  Member

  391 Points

  383 Posts

  Re: Insertion process in vb.net

  May 17, 2012 06:18 AM|LINK

  hi

  iam using 2005 sql server. so i can't use sqlbulk copy. can you give me any other idea. i want save atleast 3 records its enough for me.

  please help me.

• • Reply
  

  cninjas

  Contributor

  4868 Points

  851 Posts

  Re: Insertion process in vb.net

  May 17, 2012 06:24 AM|LINK

  hi

  You are passing the values from vb.net to sqlserver 2005 right? What is the values? is it in a datatable? 

  Can you post the saving part alone?

  thanks,

  Microsoft Community Contributor 2011
  Niranjan
• • Reply
  

  cninjas

  Contributor

  4868 Points

  851 Posts

  Re: Insertion process in vb.net

  May 17, 2012 06:44 AM|LINK

  hi

  Please go thru the link again. I tried the same with SQL Server 2005 table and the SQL Server 2008. Its working fine.

  thanks,

  Microsoft Community Contributor 2011
  Niranjan
  • Marked as answer by SudhaRubini on May 17, 2012 07:06 AM
• • Reply
  

  SudhaRubini

  Member

  391 Points

  383 Posts

  Re: Insertion process in vb.net

  May 17, 2012 07:06 AM|LINK

  Hi 

   thank you so much................