Click here to Skip to main content
15,915,086 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Questionsearching through files Pin
Member 347198326-Jan-09 8:55
Member 347198326-Jan-09 8:55 
AnswerRe: searching through files Pin
Dave Kreskowiak26-Jan-09 11:42
mveDave Kreskowiak26-Jan-09 11:42 
QuestionHow Do I detect a video card in a splash screen Pin
rspercy6526-Jan-09 7:54
rspercy6526-Jan-09 7:54 
AnswerRe: How Do I detect a video card in a splash screen Pin
Dave Kreskowiak26-Jan-09 11:40
mveDave Kreskowiak26-Jan-09 11:40 
GeneralRe: How Do I detect a video card in a splash screen Pin
rspercy6527-Jan-09 3:28
rspercy6527-Jan-09 3:28 
GeneralRe: How Do I detect a video card in a splash screen Pin
Dave Kreskowiak27-Jan-09 4:24
mveDave Kreskowiak27-Jan-09 4:24 
GeneralRe: How Do I detect a video card in a splash screen Pin
rspercy6527-Jan-09 10:33
rspercy6527-Jan-09 10:33 
QuestionOther problem with Parameters in Select statement Pin
ivo7526-Jan-09 7:47
ivo7526-Jan-09 7:47 
I want to export to XML file and have problem this is the code but is not work, error is "No value given for one or more required parameters."

Private Sub GetDataFromAcessFile1()
Dim aCon As OleDbConnection
Dim aCmd As OleDbCommand
Dim strCon As String
Dim param1 As OleDbParameter
Dim param2 As OleDbParameter
Dim param3 As OleDbParameter

'create connection with mdb file
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strAcessFilePath & ";User ID=Admin;Password="
aCon = New OleDbConnection(strCon)
aCon.Open()

strQuery = "Select * from rabotnici where rabotnik_name=? and data_rabota>=? and data_rabota<=?"
param1 = New OleDbParameter("@rabotnik_name", OleDbType.VarWChar, 100)
param1.Value = ComboBox1.Text
param2 = New OleDbParameter("@data_rabota", OleDbType.Date)
param2.Value = DateTimePicker1.Value.ToShortDateString
param3 = New OleDbParameter("@data_rabota1", OleDbType.Date)
param3.Value = DateTimePicker2.Value.ToShortDateString()
aCmd = New OleDbCommand(strQuery, aCon)
aCmd.Parameters.Add(param1)
aCmd.Parameters.Add(param2)
aCmd.Parameters.Add(param3)
aCmd.ExecuteNonQuery()

aCmd = New OleDbCommand(strQuery, aCon)
Dim da As New OleDbDataAdapter
da.SelectCommand = aCmd
Dim ds As DataSet
ds = New DataSet("Customers1")
da.Fill(ds, "New Customers1")
Dim dt As DataTable
dt = New DataTable()
dt = ds.Tables("New Customers1")
CreateXMLFile()
WriteToXml(dt)
aCon.Close()
End Sub

Can You help me
AnswerRe: Other problem with Parameters in Select statement Pin
Jon_Boy26-Jan-09 8:07
Jon_Boy26-Jan-09 8:07 
GeneralRe: Other problem with Parameters in Select statement Pin
ivo7526-Jan-09 8:19
ivo7526-Jan-09 8:19 
GeneralRe: Other problem with Parameters in Select statement Pin
Dave Kreskowiak26-Jan-09 11:38
mveDave Kreskowiak26-Jan-09 11:38 
AnswerRe: Other problem with Parameters in Select statement Pin
Jon_Boy26-Jan-09 9:07
Jon_Boy26-Jan-09 9:07 
AnswerRe: Other problem with Parameters in Select statement Pin
Wendelius26-Jan-09 18:36
mentorWendelius26-Jan-09 18:36 
QuestionUse of Private Properties Pin
Jay Royall26-Jan-09 4:27
Jay Royall26-Jan-09 4:27 
AnswerRe: Use of Private Properties Pin
Wendelius26-Jan-09 5:23
mentorWendelius26-Jan-09 5:23 
GeneralRe: Use of Private Properties Pin
Jay Royall26-Jan-09 5:40
Jay Royall26-Jan-09 5:40 
GeneralRe: Use of Private Properties Pin
Wendelius26-Jan-09 6:06
mentorWendelius26-Jan-09 6:06 
AnswerRe: Use of Private Properties Pin
Jon_Boy26-Jan-09 7:55
Jon_Boy26-Jan-09 7:55 
GeneralRe: Use of Private Properties Pin
Jay Royall26-Jan-09 21:55
Jay Royall26-Jan-09 21:55 
GeneralRe: Use of Private Properties Pin
Dave Kreskowiak27-Jan-09 1:35
mveDave Kreskowiak27-Jan-09 1:35 
GeneralRe: Use of Private Properties Pin
Jon_Boy27-Jan-09 2:23
Jon_Boy27-Jan-09 2:23 
QuestionWebBrowser control Pin
Stephen Lintott26-Jan-09 0:25
Stephen Lintott26-Jan-09 0:25 
AnswerRe: WebBrowser control Pin
Manas Bhardwaj26-Jan-09 1:03
professionalManas Bhardwaj26-Jan-09 1:03 
GeneralRe: WebBrowser control Pin
Stephen Lintott26-Jan-09 1:24
Stephen Lintott26-Jan-09 1:24 
AnswerRe: WebBrowser control Pin
EliottA26-Jan-09 2:59
EliottA26-Jan-09 2:59 

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.