|
I don't understand what you mean by 'It appears to be bombing out making a connection to the database,'.
That kind of English is an bit to difficult for me.
I'm dutch.
Maybe you got an bit of code to show me what you mean.
My App.Config looks like this:
<
connectionStrings>
<add name="Access_DB_2.My.MySettings.TestDatabaseConnectionString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Data\TestDatabase.mdb;Persist Security Info=True"
providerName="System.Data.OleDb" />
</connectionStrings>
>
I also thought that would be an problem so i changed my VB code on the load event to this:
<br />
Dim oDa As New OleDb.OleDbDataAdapter("SELECT * FROM tNamen", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Data\TestDatabase.mdb;Persist Security Info=True")<br />
Dim oDt As New DataTable<br />
Dim oBs As New BindingSource<br />
<br />
oDa.Fill(oDt)<br />
oBs.DataSource = oDt<br />
<br />
Try<br />
DataGridView1.DataSource = oBs<br />
<br />
Catch ex As OleDbException<br />
MsgBox(ex.Message)<br />
Catch ex As Exception<br />
MsgBox(ex.Message)<br />
Finally<br />
oDa = Nothing<br />
End Try<br />
But that was not an solution.
The directory my Program is installed in is: c:\program files\EwR Development\Access DB 2.
And the database is in: c:\program files\EwR Development\Access DB 2\data
The images are located in: c:\program files\EwR Development\Access DB 2\Images
If you need my project I'll send it to you in an zip/rar file.
If you need de setup i can send it to you to. Also in an zip or rar file.
|
|
|
|
|
Erich Rebel wrote: 'It appears to be bombing out making a connection to the database,'.
That kind of English is an bit to difficult for me.
The code throws an exception...
Erich Rebel wrote: Data Source=|DataDirectory|\Data\TestDatabase.mdb;
Erich Rebel wrote: And the database is in: c:\program files\EwR Development\Access DB 2\data
If the code runs in the debugger, I'd check to see if your installation actually did put the database in the correct folder under Program Files. If it's there, open it up in Access and make sure it has the same schema you expect it to have.
|
|
|
|
|
Finally my problem is gone.
On the target PC I've made an new install of Windows XP and everything works fine now.
I was so tired of everything going wrong and had done so many thinks trying to make it work that i didn't see any other solution.
And it works.
Looks like my target PC was too full of sh*t and couldn't work any more.
Thanks for your help anyway.
|
|
|
|
|
When a multithreaded application hits a breakpoint do all threads stop or just the one that hit the breakpoint? If the first one is true then what happens to the other threads when you step through your code?
thanks,
Mike
|
|
|
|
|
|
 I am building an application using two forms. On form1 I have a list box, and two text boxes, one for a string and the other for an integer.
Form2 has two text boxes and a button. When the button is clicked, I would like the data (string and integer) diplayed in the textboxes on form2 to be displayed in the listbox on form1.Also when the item is selected in the listbox, I would like the string and integer to be displayed in the relevant textboxes on form1.
Please help..
|
|
|
|
|
roger6897 wrote: Please help..
With what? You haven't provided any code. Or are you expecting someone to do your work for you?
Read the MSDN documentation to learn about the properties and methods exposed by the textbox and listbox controls. Attempt to solve the problem yourself and post again if you have more specific questions.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
pmarfleet wrote: you expecting someone to do your work for you
Probably.
Hence my sig which was quoted by Pete O'Hanlon.
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
I have two forms. One is used to add data and the other to view that data.
The first form is used to add items to a listbox (on the first form). How can those items be added to the second form, so that they are available in the combo listbox on the second form?
|
|
|
|
|
|
Please look at Colin's article, and stop asking the same question over and over 
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
hai,
i do my project in vb.net 2005 windows application.In my project,currency is display like 1,213,456.00.so,i want to display the currency in india format like 12,13,456.00.how to do these in vb.net windows application.
|
|
|
|
|
You need to set your code to use an Indian locale. By defualt, your application will use US culture settings. The following example example produces the desired results using the Hindi (India) locale.
Thread.CurrentThread.CurrentCulture = New CultureInfo("hi-IN")
Dim d As Double = 1213456.05
Console.WriteLine(d.ToString("N"))
A full list of the available cultures can be found here[^]
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I am building an array so that items added in one form are made available to the second form.
I am able to update the array by editing and adding items, but how can I delete an item from the list, so that it is not available to either forms.
|
|
|
|
|
ArrayList.Remove, ArrayList.RemoveAt, ArrayList.RemoveRange?
|
|
|
|
|
Hi,
I have taken an example from MSDN.
Public Function GetSchemaTable(ByVal connectionString As String) _
As DataTable
Using connection As New OleDbConnection(connectionString)
connection.Open()
Dim schemaTable As DataTable = _
connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, _
New Object() {Nothing, Nothing, Nothing, "TABLE"})
Return schemaTable
End Using
End Function
I have called this function in my code on MS Access DB Connection String, and got DataTable object in return but I'm unable to find table names in DataTable object, can anyone please help me in that, what am I doing wrong.
Best Regards,
Mushq
Mushtaque Ahmed Nizamani
Software Engineer
Ultimus Pakistan
|
|
|
|
|
When a form loads, a button is disabled. How can I get the button enabled after selecting an item in a combo box?
|
|
|
|
|
perhaps by adding some code based on an event that fires when a selection is changed,
and a property that enables a Control.
|
|
|
|
|
on the selected item changed event:
If the selecteditem is equal to what you specify then perform your action. i.e.
If combobox1.selecteditem = "example" then<br />
textbox1.enabled = true<br />
end if
|
|
|
|
|
 When a form loads, a button is disabled. How can I get the button enabled after selecting an item in a combo box?
|
|
|
|
|
Put
myButton.Enabled = True
in the event handler for the combo box selection changed event.
|
|
|
|
|
Can anyone please help with using multiple forms. I am trying to have more than one form on a program, so that data is shared between both those forms.
|
|
|
|
|
dexter9703 wrote: Can anyone please help with using multiple forms. I am trying to have more than one form on a program, so that data is shared between both those forms.
That's a bit vague. What exactly are you having a problem with?
Do you need to know how to open mulitple forms simultaneously?
SomeForm form = new SomeForm();
form.Show();
SomeForm is the name of your Form class.
Do you need to know how to pass data between forms?
Passing values between forms[^]
Something else?
|
|
|
|
|
How can i select utf-8 encoded character fro ma text file and bind it to dataset.
Here is the code:
Dim srStreamReader As StreamReader
Dim sFile As String = "E:\FTPROOT\uni.txt"
Dim swfile As String = "E:\FTPROOT\"
Dim sFileText As String
srStreamReader = New StreamReader(sFile, Encoding.Default)
sFileText = srStreamReader.ReadToEnd()
srStreamReader.Close()
Dim swStreamWriter As TextWriter = New StreamWriter(swfile & "Import.txt", True)
swStreamWriter.Write(sFileText)
swStreamWriter.Close()
Dim _Dataset As New DataSet
'txt convertion and filling to dataset
Dim sConnectionString As String
sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & swfile & ";Extended Properties=text"
Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString)
objConn.Open()
Dim da As New System.Data.OleDb.OleDbDataAdapter("Select * from Import.txt", objConn) ''NLS_CHARACTERSET'
da.Fill(_Dataset, "test")
This code select from text file but not in correct format.
|
|
|
|
|
Hi all,
I am using this code to loop through the SQLDataReader.
'drResource - SQLDataReader
If drResource.HasRows Then
Do While drResource.Read
'Here I have to check whether there exist next read.
Loop
End if
How can I check there is a next row
Thanks
Dana
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
