Click here to Skip to main content
15,891,423 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: How to open word or notepad from the vb.net link? Pin
Anonymous12-Sep-05 23:05
Anonymous12-Sep-05 23:05 
QuestionHow to name an user-defined range into a excel file using .net language?? Pin
hustsay2312-Sep-05 17:13
hustsay2312-Sep-05 17:13 
QuestionContext Menus and Indexes Pin
No-e12-Sep-05 10:00
No-e12-Sep-05 10:00 
AnswerRe: Context Menus and Indexes Pin
Luis Alonso Ramos12-Sep-05 10:54
Luis Alonso Ramos12-Sep-05 10:54 
AnswerRe: Context Menus and Indexes Pin
Briga12-Sep-05 22:12
Briga12-Sep-05 22:12 
GeneralRe: Context Menus and Indexes Pin
No-e13-Sep-05 4:38
No-e13-Sep-05 4:38 
GeneralRe: Context Menus and Indexes Pin
Briga15-Sep-05 23:32
Briga15-Sep-05 23:32 
QuestionINSERT INTO database Pin
daviiie12-Sep-05 9:08
daviiie12-Sep-05 9:08 
Can someone tell me whats wrong with this code. Every time I execute it I get a "Operation must use an updateable query." error message. I have changed all the rights to the .mdb file so I am sure it isn't that.

I don't know if its the query itself, I may just have the wrong syntax.

HELP!!!


Public Function AddFixtures(ByVal HT As String, ByVal AT As String)

sConn = "Provider=Microsoft.Jet.OLEDB.4.0;"
sConn += "Data Source=C:\Inetpub\wwwroot\webapplication5\football.mdb;"
sConn += "Persist Security Info=False"

sCommAdd += "INSERT INTO Fixtures (Fixtures.HomeTeam, Fixtures.AwayTeam ) VALUES ('" + HT + "', '" + AT + "')"

oConn = New OleDbConnection(sConn)
oConn.Open()

oCommAdd = New OleDbCommand(sCommAdd, oConn)
oCommAdd.ExecuteNonQuery()

oConn.Close()

End Function

AnswerRe: INSERT INTO database Pin
Dave Kreskowiak12-Sep-05 10:04
mveDave Kreskowiak12-Sep-05 10:04 
GeneralRe: INSERT INTO database Pin
daviiie12-Sep-05 12:33
daviiie12-Sep-05 12:33 
GeneralRe: INSERT INTO database Pin
Christian Graus12-Sep-05 12:51
protectorChristian Graus12-Sep-05 12:51 
AnswerRe: INSERT INTO database Pin
KaptinKrunch12-Sep-05 14:32
KaptinKrunch12-Sep-05 14:32 
QuestionForm Loading Pin
No-e12-Sep-05 8:06
No-e12-Sep-05 8:06 
AnswerRe: Form Loading Pin
Dave Kreskowiak12-Sep-05 9:43
mveDave Kreskowiak12-Sep-05 9:43 
AnswerRe: Form Loading Pin
namazikhah12-Sep-05 9:51
namazikhah12-Sep-05 9:51 
QuestionDataBinding in VB 2005 Pin
watagal12-Sep-05 7:46
watagal12-Sep-05 7:46 
Questionprint a webpage in vb.net Pin
jelsner12-Sep-05 7:45
jelsner12-Sep-05 7:45 
AnswerRe: print a webpage in vb.net Pin
Dave Kreskowiak12-Sep-05 9:52
mveDave Kreskowiak12-Sep-05 9:52 
QuestionErl in VB.NET Pin
maroche12-Sep-05 6:49
maroche12-Sep-05 6:49 
AnswerRe: Erl in VB.NET Pin
Dave Kreskowiak12-Sep-05 8:02
mveDave Kreskowiak12-Sep-05 8:02 
QuestionFile Sharing Violation Problem - Remoting Pin
PranjalSharma12-Sep-05 2:36
PranjalSharma12-Sep-05 2:36 
AnswerRe: File Sharing Violation Problem - Remoting Pin
Steve Pullan12-Sep-05 14:00
Steve Pullan12-Sep-05 14:00 
GeneralRe: File Sharing Violation Problem - Remoting Pin
PranjalSharma12-Sep-05 23:33
PranjalSharma12-Sep-05 23:33 
QuestionKerberos in WSE3.0 &vb.net Pin
haraldsm12-Sep-05 2:13
haraldsm12-Sep-05 2:13 
QuestionEXIF and decoding Makernote data Pin
dazfl12-Sep-05 2:06
dazfl12-Sep-05 2:06 

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.