Click here to Skip to main content
15,914,165 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: "Is Nothing" not running Pin
amapumu26-Oct-06 3:05
amapumu26-Oct-06 3:05 
GeneralRe: "Is Nothing" not running Pin
Dave Kreskowiak26-Oct-06 5:43
mveDave Kreskowiak26-Oct-06 5:43 
QuestionSaving an Image in VB.NET Pin
Zaegra24-Oct-06 21:09
Zaegra24-Oct-06 21:09 
AnswerRe: Saving an Image in VB.NET Pin
Dave Kreskowiak25-Oct-06 5:12
mveDave Kreskowiak25-Oct-06 5:12 
GeneralRe: Saving an Image in VB.NET Pin
Zaegra27-Oct-06 1:19
Zaegra27-Oct-06 1:19 
QuestionHow to insert records from DataGridView to SQL Server database Pin
VS200524-Oct-06 20:59
VS200524-Oct-06 20:59 
AnswerRe: How to insert records from DataGridView to SQL Server database Pin
Dave Kreskowiak25-Oct-06 4:48
mveDave Kreskowiak25-Oct-06 4:48 
QuestionRe: How to insert records from DataGridView Of Visual Studio 2005 to SQL Server database Pin
VS200525-Oct-06 15:59
VS200525-Oct-06 15:59 
Hi Dave and Everyone

I had done my sqlconnection in the public area.
I am trying to insert records from DataGridView into my SQL Server database without retrieving any information and I do not require to retrieve records from database. Initally, the database in SQL Server is empty. For this program, I made use of the SqlDataAdapter, DataSet and BindingSource.


This is my latest codings as listed below:

Dim sqlcom As SqlCommand = New SqlCommand()
Dim da As New SqlDataAdapter("SELECT * FROM TBReqDG", sqlcon)
Dim myDataSet As New DataSet()
Dim cb As New SqlCommandBuilder(da)
da.InsertCommand = cb.GetInsertCommand()
da.Update(myDataSet, "TBReqDG")'ERROR COMES FROM HERE
'Open connection, execute the commands
sqlcon.Open()
sqlcom.Connection = sqlcon
'Close Connection
sqlcon.Close()


As my program runs, it show this error  Update unable to find TableMapping['TBReqDG'] or DataTable 'TBReqDG'.

Is this line really necessary or I just only have to declare the sqldataadapter ?
-->Dim da As New SqlDataAdapter("SELECT * FROM TBReqDG", sqlcon)


I don't know where it had gone wrong and hope anyone who knows is able to guide me along.

Hope to receive reply soon as it’s urgent & thanks.Confused | :confused: Confused | :confused: Confused | :confused:


Rgds
Tracy
QuestionBest book for 'Working with graphics in VB.Net' or GDI+? Pin
BetimD24-Oct-06 20:44
BetimD24-Oct-06 20:44 
AnswerRe: Best book for 'Working with graphics in VB.Net' or GDI+? Pin
Dave Sexton24-Oct-06 21:32
Dave Sexton24-Oct-06 21:32 
GeneralRe: Best book for 'Working with graphics in VB.Net' or GDI+? Pin
Zaegra24-Oct-06 23:55
Zaegra24-Oct-06 23:55 
GeneralRe: Best book for 'Working with graphics in VB.Net' or GDI+? Pin
Dave Sexton25-Oct-06 2:36
Dave Sexton25-Oct-06 2:36 
GeneralRe: Best book for 'Working with graphics in VB.Net' or GDI+? Pin
Dave Kreskowiak25-Oct-06 3:29
mveDave Kreskowiak25-Oct-06 3:29 
GeneralRe: Best book for 'Working with graphics in VB.Net' or GDI+? Pin
Dave Sexton25-Oct-06 6:05
Dave Sexton25-Oct-06 6:05 
GeneralRe: Best book for 'Working with graphics in VB.Net' or GDI+? Pin
Dave Kreskowiak25-Oct-06 6:53
mveDave Kreskowiak25-Oct-06 6:53 
GeneralRe: Best book for 'Working with graphics in VB.Net' or GDI+? Pin
Dave Sexton25-Oct-06 20:13
Dave Sexton25-Oct-06 20:13 
GeneralRe: Best book for 'Working with graphics in VB.Net' or GDI+? Pin
BetimD24-Oct-06 23:58
BetimD24-Oct-06 23:58 
GeneralRe: Best book for 'Working with graphics in VB.Net' or GDI+? Pin
Dave Sexton25-Oct-06 2:44
Dave Sexton25-Oct-06 2:44 
AnswerRe: Best book for 'Working with graphics in VB.Net' or GDI+? Pin
Zaegra25-Oct-06 0:00
Zaegra25-Oct-06 0:00 
AnswerRe: Best book for 'Working with graphics in VB.Net' or GDI+? Pin
Dave Kreskowiak25-Oct-06 3:33
mveDave Kreskowiak25-Oct-06 3:33 
Questionhiding the colummn in datagrid .net Pin
amaneet24-Oct-06 19:51
amaneet24-Oct-06 19:51 
AnswerRe: hiding the colummn in datagrid .net Pin
Vikash Yadav24-Oct-06 20:25
Vikash Yadav24-Oct-06 20:25 
GeneralRe: hiding the colummn in datagrid .net Pin
amaneet24-Oct-06 20:40
amaneet24-Oct-06 20:40 
GeneralRe: hiding the colummn in datagrid .net Pin
Vikash Yadav24-Oct-06 22:26
Vikash Yadav24-Oct-06 22:26 
GeneralRe: hiding the colummn in datagrid .net Pin
xbiplav25-Oct-06 3:49
xbiplav25-Oct-06 3:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.