Click here to Skip to main content
15,890,512 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: How Font is related to Character set Pin
Dave Kreskowiak15-Apr-09 2:26
mveDave Kreskowiak15-Apr-09 2:26 
AnswerRe: How Font is related to Character set Pin
Andy Missico15-Apr-09 2:25
Andy Missico15-Apr-09 2:25 
GeneralRe: How Font is related to Character set Pin
sunil goyalG15-Apr-09 3:00
sunil goyalG15-Apr-09 3:00 
GeneralRe: How Font is related to Character set Pin
Andy Missico18-Apr-09 18:49
Andy Missico18-Apr-09 18:49 
QuestionVisual Basic script error Pin
subramanyeswari15-Apr-09 1:02
subramanyeswari15-Apr-09 1:02 
AnswerRe: Visual Basic script error Pin
Andy Missico15-Apr-09 1:57
Andy Missico15-Apr-09 1:57 
AnswerRe: Visual Basic script error Pin
0x3c015-Apr-09 1:58
0x3c015-Apr-09 1:58 
QuestionOleDB Data Adaptor Problem Pin
specialdreamsin15-Apr-09 0:08
specialdreamsin15-Apr-09 0:08 
Hi,

I wrote code as

Public Function UploadData(ByVal UDs As DataSet) As Long
Dim SkipRecCnt As Long = 0
For i As Integer = 0 To UDs.Tables(0).Rows.Count - 1
Try
SQLCmd.CommandText = UDs.Tables(0).Rows(i)(0).ToString()
SQLCmd.ExecuteNonQuery()
UDs.Tables(0).Rows(i)(1) = "1"
UDs.AcceptChanges()
Dim builder As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(AccDa)
builder.GetUpdateCommand()
AccDa.Update(UDs)
Catch ex As Exception
SkipRecCnt = SkipRecCnt + 1
End Try
Next

At line builder.GetUpdateCommand() it is giving following error

Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.

Please help me out.
AnswerRe: OleDB Data Adaptor Problem Pin
Dave Kreskowiak15-Apr-09 2:25
mveDave Kreskowiak15-Apr-09 2:25 
Questionrefresh datagrid on another windows form Pin
sohaib_a14-Apr-09 21:36
sohaib_a14-Apr-09 21:36 
AnswerRe: refresh datagrid on another windows form Pin
Anubhava Dimri14-Apr-09 21:45
Anubhava Dimri14-Apr-09 21:45 
GeneralRe: refresh datagrid on another windows form Pin
sohaib_a14-Apr-09 22:09
sohaib_a14-Apr-09 22:09 
GeneralRe: refresh datagrid on another windows form Pin
Christian Graus14-Apr-09 22:12
protectorChristian Graus14-Apr-09 22:12 
AnswerRe: refresh datagrid on another windows form Pin
Christian Graus14-Apr-09 22:07
protectorChristian Graus14-Apr-09 22:07 
RantRe: refresh datagrid on another windows form Pin
Andy Missico15-Apr-09 0:15
Andy Missico15-Apr-09 0:15 
AnswerRe: refresh datagrid on another windows form Pin
Andy Missico15-Apr-09 0:12
Andy Missico15-Apr-09 0:12 
GeneralRe: refresh datagrid on another windows form Pin
sohaib_a16-Apr-09 8:45
sohaib_a16-Apr-09 8:45 
Questionhow to control 2 frames by 2 option buttons? Pin
zhiyuan1614-Apr-09 20:38
zhiyuan1614-Apr-09 20:38 
AnswerRe: how to control 2 frames by 2 option buttons? Pin
Guffa14-Apr-09 20:58
Guffa14-Apr-09 20:58 
AnswerRe: how to control 2 frames by 2 option buttons? Pin
Christian Graus14-Apr-09 22:08
protectorChristian Graus14-Apr-09 22:08 
AnswerRe: how to control 2 frames by 2 option buttons? Pin
Dalek Dave14-Apr-09 22:17
professionalDalek Dave14-Apr-09 22:17 
QuestionTwo way Data synchronization mssql 2008 express Pin
r_mohd14-Apr-09 20:01
r_mohd14-Apr-09 20:01 
AnswerRe: Two way Data synchronization mssql 2008 express Pin
Ashfield14-Apr-09 21:07
Ashfield14-Apr-09 21:07 
QuestionAppActivate and Send Keys not working correctly Pin
CARisk314-Apr-09 12:29
CARisk314-Apr-09 12:29 
AnswerRe: AppActivate and Send Keys not working correctly Pin
Dave Kreskowiak15-Apr-09 2:23
mveDave Kreskowiak15-Apr-09 2:23 

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.