Click here to Skip to main content
15,909,518 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionFile view in an explorer window: details, list... Pin
Maarten773-Oct-06 4:28
Maarten773-Oct-06 4:28 
AnswerRe: File view in an explorer window: details, list... Pin
Dave Kreskowiak3-Oct-06 8:31
mveDave Kreskowiak3-Oct-06 8:31 
AnswerFile view in a Forms.Webbrowser Pin
Maarten773-Oct-06 19:55
Maarten773-Oct-06 19:55 
GeneralRe: File view in a Forms.Webbrowser Pin
Dave Kreskowiak4-Oct-06 1:52
mveDave Kreskowiak4-Oct-06 1:52 
GeneralRe: File view in a Forms.Webbrowser Pin
Maarten774-Oct-06 20:13
Maarten774-Oct-06 20:13 
Questionvb.net to Access Pin
anne lewis3-Oct-06 4:14
anne lewis3-Oct-06 4:14 
AnswerRe: vb.net to Access Pin
Guffa3-Oct-06 5:59
Guffa3-Oct-06 5:59 
GeneralRe: vb.net to Access Pin
anne lewis3-Oct-06 7:21
anne lewis3-Oct-06 7:21 
this is my code for the insert

Private Sub submit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles submit.Click
Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;data source=D:\\inetpub\wwwroot\purchasing\ReturnToVendor\2006 Shipping db.mdb"
Dim SQL2 As String = "Insert into ReturnToVendor (shippername, ponumber, ranumber, authorizedby, itemtoreturn, itemvalue, qtytoreturn, qtyunitofmeasure, reasonforreturn, actiontobetaken, notes, shipvia, rcicontact, contactdepartment, contactcostcenter, contactphonenumber, contactfaxnumber, carriername, Documentdate) values ('" & shippername.SelectedValue & "', '" & PONumber.Text & "', '" & ranumber.Text & "', '" & AuthorizedBy.Text & "', '" & ItemToReturn.Text & "', '" & ItemValue.Text & "', '" & qtyToReturn.Text & "', '" & qtyUnitofMeasure.SelectedValue & "', '" & reasonForReturn.Text & "', '" & ActiontoBeTaken.SelectedValue & "', '" & notes.Text & "', '" & shipvia.SelectedValue & "', '" & RCIContact.Text & "', '" & contactdepartment.Text & "', '" & contactcostcenter.Text & "', '" & ContactPhoneNumber.Text & "', '" & contactfaxnumber.Text & "', '" & carriername.Text & "', '" & Date.Today() & "')"
Dim dbConn2 As New OleDbConnection(connString)
Dim Cmd2 As New OleDbCommand(SQL2, dbConn2)
dbConn2.Open()
Cmd2.ExecuteNonQuery()
dbConn2.Close()
Response.Redirect("http://rfrmsweb/Purchasing/returntovendor/returntovendor3.aspx")
End Sub

how do I place the documentnumber in my insert statement to create the number in the table?
GeneralRe: vb.net to Access Pin
nlindley73-Oct-06 8:16
nlindley73-Oct-06 8:16 
GeneralRe: vb.net to Access Pin
anne lewis3-Oct-06 8:48
anne lewis3-Oct-06 8:48 
GeneralRe: vb.net to Access Pin
nlindley73-Oct-06 9:39
nlindley73-Oct-06 9:39 
GeneralRe: vb.net to Access Pin
xujexy4-Oct-06 1:50
xujexy4-Oct-06 1:50 
Questionvb.net to Access Pin
anne lewis3-Oct-06 4:13
anne lewis3-Oct-06 4:13 
QuestionMulti level context menu Pin
dAb73-Oct-06 2:55
dAb73-Oct-06 2:55 
AnswerRe: Multi level context menu Pin
UltraCoder9-Oct-06 17:21
UltraCoder9-Oct-06 17:21 
Questiontextbox in class Pin
nbulut3-Oct-06 1:54
nbulut3-Oct-06 1:54 
AnswerRe: textbox in class Pin
Dave Kreskowiak3-Oct-06 2:13
mveDave Kreskowiak3-Oct-06 2:13 
QuestionVb6 to Vb 2005 Pin
prashweenet3-Oct-06 1:37
prashweenet3-Oct-06 1:37 
AnswerRe: Vb6 to Vb 2005 [modified] Pin
Dave Kreskowiak3-Oct-06 2:09
mveDave Kreskowiak3-Oct-06 2:09 
QuestionBizarre Winsock behaviour in VB 6.0 Pin
Nic Rowan3-Oct-06 0:46
Nic Rowan3-Oct-06 0:46 
Questionsending parameters through asp.net page Pin
ADY0072-Oct-06 23:13
ADY0072-Oct-06 23:13 
AnswerRe: sending parameters through asp.net page Pin
Christian Graus2-Oct-06 23:42
protectorChristian Graus2-Oct-06 23:42 
GeneralRe: sending parameters through asp.net page Pin
ADY0073-Oct-06 0:11
ADY0073-Oct-06 0:11 
GeneralRe: sending parameters through asp.net page Pin
Christian Graus3-Oct-06 0:21
protectorChristian Graus3-Oct-06 0:21 
GeneralRe: sending parameters through asp.net page Pin
Dave Sexton3-Oct-06 0:20
Dave Sexton3-Oct-06 0:20 

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.