Click here to Skip to main content
15,888,401 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Questionhow to get value's valuemember property of combobox control Pin
roitha10-May-06 18:27
roitha10-May-06 18:27 
AnswerRe: how to get value's valuemember property of combobox control Pin
albCode10-May-06 20:39
albCode10-May-06 20:39 
QuestionSNMP Get/Set using VB.Net Pin
test@corbus-systems.com10-May-06 17:33
test@corbus-systems.com10-May-06 17:33 
AnswerRe: SNMP Get/Set using VB.Net Pin
Tarakeshwar Reddy10-May-06 17:47
professionalTarakeshwar Reddy10-May-06 17:47 
QuestionGet unique values in dataview Pin
Brent Lamborn10-May-06 8:37
Brent Lamborn10-May-06 8:37 
AnswerRe: Get unique values in dataview Pin
Brent Lamborn10-May-06 8:38
Brent Lamborn10-May-06 8:38 
QuestionSimple change in the connection string problem... VB.net 2005 Pin
nirishere10-May-06 8:29
nirishere10-May-06 8:29 
AnswerRe: Simple change in the connection string problem... VB.net 2005 Pin
Mandar Patankar10-May-06 12:08
Mandar Patankar10-May-06 12:08 
Assuming that your dataAdapter is an OLeDB adapter.

Here is what you can do.

Change the connection string of dataadapter in button click event.open a fileopendialog box in the buttonclick event

'textPath is a textbox which displays the selected db path



Private Sub dbConnect_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dbConnect.Click
OpenFileDialog1.ShowDialog()
txtPath.Text = OpenFileDialog1.FileName

Dim DBString As String

DBString = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=" & txtPath.Text & ";Jet OLEDB:Engin" & _
"e Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB" & _
":SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None" & _
";Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLE" & _
"DB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=F" & _
"alse;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"

dataconn.ConnectionString = DBString
End Sub


I hope this helps

Mandar Patankar
Microsoft Certified professional
GeneralRe: Simple change in the connection string problem... VB.net 2005 Pin
nirishere10-May-06 22:04
nirishere10-May-06 22:04 
GeneralRe: Simple change in the connection string problem... VB.net 2005 Pin
nirishere15-May-06 0:58
nirishere15-May-06 0:58 
QuestionRunning an exe from the app Pin
projectcode110-May-06 4:36
projectcode110-May-06 4:36 
AnswerRe: Running an exe from the app Pin
Rizwan Bashir10-May-06 4:49
Rizwan Bashir10-May-06 4:49 
GeneralRe: Running an exe from the app Pin
epedroza29-Jun-06 9:54
epedroza29-Jun-06 9:54 
AnswerRe: Running an exe from the app Pin
Fu Manchu10-May-06 5:00
Fu Manchu10-May-06 5:00 
AnswerRe: Running an exe from the app Pin
projectcode110-May-06 5:20
projectcode110-May-06 5:20 
QuestionMaster-Detail in a single datagrid Pin
hisuman10010-May-06 4:04
hisuman10010-May-06 4:04 
AnswerRe: Master-Detail in a single datagrid Pin
Mandar Patankar10-May-06 11:58
Mandar Patankar10-May-06 11:58 
GeneralRe: Master-Detail in a single datagrid Pin
hisuman10010-May-06 20:03
hisuman10010-May-06 20:03 
Questionregarding web services Pin
Vijaya Krishnamoorthy10-May-06 2:23
Vijaya Krishnamoorthy10-May-06 2:23 
AnswerRe: regarding web services Pin
Mandar Patankar10-May-06 12:14
Mandar Patankar10-May-06 12:14 
QuestionRegarding setup of an application Pin
Vijaya Krishnamoorthy10-May-06 2:21
Vijaya Krishnamoorthy10-May-06 2:21 
AnswerRe: Regarding setup of an application Pin
Fu Manchu10-May-06 3:23
Fu Manchu10-May-06 3:23 
QuestionCrystal Reports Pin
microuser_200010-May-06 2:07
microuser_200010-May-06 2:07 
AnswerRe: Crystal Reports Pin
chinnasrihari10-May-06 3:34
chinnasrihari10-May-06 3:34 
GeneralRe: Crystal Reports Pin
microuser_200010-May-06 20:31
microuser_200010-May-06 20:31 

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.