Connecting Tech Pros Worldwide Forums | Help | Site Map

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

Newbie
 
Join Date: Feb 2008
Posts: 16
#1: Feb 29 '08
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=strItemCode

Connection(VB code):
Dim con
con.ConnectionString = "Integrated Security=True;data source=ph-erwinm1;" & "persist security info=false;Initial Catalog=ITP"

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

Thank You In Advance

Reply