VB SCRIPT - How Do to Save the Gridview Data to MSSQL DB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jaredciagar
    New Member
    • Feb 2008
    • 16

    #1

    VB SCRIPT - How Do to Save the Gridview Data to MSSQL DB

    Hello Guys,

    Can You Help ME Please....

    I'm Using VB scipt,Asp.net and MS SQL 2005

    I have Temporary Data in my gridview and I want it to save in MS SQL DB...
    For Example:
    gridview field=Item Code
    Data in Item Code Field= "Pencil2544 "

    When I click the save button, the "Pencil2544 " from gridview will save to MS SQL DB.
    DB:
    Table Name=tblProduct
    Table Field=strItemCo de

    Connection(VB code):
    Dim con
    con.ConnectionS tring = "Integrated Security=True;d ata source=ph-erwinm1;" & "persist security info=false;Init ial Catalog=ITP"

    What Should I do?
    How Can I Do It usingVB Script?

    Thank You In Advance
Working...