I have a project where I added visually and successfully a datasource of MySql. I binded a datagridview with a table.
But, how do I change programatically the password, ip or user to connect with the MySql server? Because it can change at any time, so I can let the user change these values.
I am a brand new user of MS Visual Basic 2005 Express and MS SQL Server 2005 Express. I have familiarized myself with both programs but have one extremely frustrating problem. Once I open SQL Server, I can not establish a database connection from Visual Basic using the Visual Basic Data Source Configuration Wizard (even if I close SQL Server). If I reboot and open Visual Basic first, I can then connect using the Visual Basic Data Source Configuration Wizard. But then I can not switch to SQL Server and open the database (even if I close Visual Basic). Again, I must reboot to open the database in SQL Server.I suspect there is a setting somewhere that needs to be changed, but I can not find it?
View 6 Repliesi have a code which has the connection string as driver. dim s as string = "Driver={SQL Server}; Server=xxxSQLEXPRESS; Database=dbRegister; Trusted_Connection=yes" i need to change that to - "data source=1.2.3.4;user id=xx;password=xxxxx;initial catalog=xxxxx;Connect Timeout=30" when i just change the text it gives this error - "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" how do i declare the datasource?
View 2 Repliesi have a code which has the connection string as driver.dim s as string = "Drr={SQL Server};Server=xxxSQLEXPRESS; Database=dbRegister; Trusted_Connection=yes"i need to change that to"data source=1.2.3.4;user id=xx;password=xxxxx;initial catalog=xxxxx;Connect Timeout=30"hen i just change the text it gives this error -"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
View 13 RepliesI'm a beginner user of Microsoft Visual Studio 2008 and I want to ask what would be the initial code to connect a Visual Basic 2008 form to a SQL Server compact 3.5. I want to create an add new account program using the above applications.
View 1 RepliesWe are going to change the connection string in Settings.vb so we don't need to worry about what it is when our app runs on a different computer other than the development computer.
[Code]...
how do u use connection string in visualbasic? and i want to our compose mail cs file code in visual basic byusing to,cc,sub,message
View 2 Replieshow can i get data from mysql table and show it in listbox in visual basic 2008
mysql table
id
filename varchar 255
filetime timestamp
and it is windows application
I have AxSHDocVw.AxWebBrowser in my form. I want to get the source of the navigated webpage
View 3 Repliesim writing a little app to enable authorised staff to reset student passwords but having a few issues. . I am no expert and am now stuck The following code does not seem to error but also does not reset the password! Private Sub bt_pwd_reset_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bt_pwd_reset.Click
[Code]...
at the Moment in my code I have the words("C:PrivateWords"). and that is where the Username & Password is Stored/kept, But is there a way to store the Username & Password into the Programe. ect... in a form that only the owner of the programe can see. And what would you use on that form ie: listbox, textBox multiline, TableLayout Panel, that if it is possible to create a Form.
and would the code be something like The Altered code Below the code Below:
Public Class CreateUser
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
[Code].....
I do apologise if this has been answered 9000 times already. I have looked over forums and google for days now. I want to connect to an sql database (created locally in the windows form project) i want to then interact with this db (add, update, select) however i am struggling with the connection string (server:? localhost?) the update functions (tableadapter.update(dataset)?) adding new information (newrow etc).
[Code]...
How do you extract source code from a VB.NET .EXE file?
View 3 Repliesi can connect to only one Data Base with dataset in Visual Basic . but i want Have Dynamic connection to data base i mean in want to my appliction users have ablity to connect to any data base they want (For Example : Choose file from menu and then open and then Select any Data base.)
View 4 RepliesI developed a winform application and I want to send the .exe file to someone else. That means that my datasource for my connection string is not the same any more
Dim da As OleDbDataAdapter
Dim dt As New DataSet
Dim objConnection As OleDbConnection = New OleDb.OleDbConnection
[Code]....
I am connecting a MYSQL server with VB.NET.But its not safe, i can read my password in app.config.Are there some solutions to secure or hide my password?
View 1 RepliesHow do I strip out the data source from the connection string so that I only have the directory path and file name.
My connection string is thus:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsMartinMy DocumentsVisual Studio 2008ProjectsRestelRestel IIRestel IIRestel.mdb
i want to add TimeOfDay (Time) in Table Record which datatype is use for add Time.i am created a field "JoinedTime" DataType "time(7)"[code] "Specified cast is not valid.Couldn't store <1/1/0001 3:35:42 PM> in JoinedTime Column. Expected type is TimeSpan"want store like "3:40:14 pm" How Can I do?
View 8 RepliesI am looking to make a data connection with a network server(sql server 2005). When I run the data source configuration wizard, it allows me only to pick a local database file. I want to use a connection string like this "Data Source=SQLSERVER;Initial Catalog=mydb;User Id=username;Password=password;" I know I can do that programmatically. But I would like to know whether I can do that using the data source wizard so that I will be able to use Bindingsources and tableadapters.
View 4 RepliesVisual Basic 2010 Express, lets the user to add a Local Database with .sdf extension. These databases needs MICROSOFT SQL Server to be created or they can run in the user's pc without any additional software? What are the limit of these databases unlike an external database?
View 2 RepliesI have been trying for days now how to create a process to the user to easily create a connection to any installed data types they have installed. I have found an example right inside vb2008. I never use this because I code my own connections, but this would be real nice if I could include it or duplicate it.
View 1 RepliesHow Is It Possible That When A User Of A Tabbed WebBrowser Made In Visual Basic 2010 Maximizes The Browser And The Components (Example: TabControl, Buttons) Re-Size Themselves To Fit In The Form?
View 2 Replieshow to use the VS 2010 IDE tools in a way the Microsofties didn't specifically intend. But since this is something I immediately tried without success.
I have defined a .NET 4.0 WPF Application project with a simple class that looks like this:
Public Class Class1
Public Property One As String = "OneString"
Public Property Two As String = "TwoString"
[Code]....
The expected result was that "OneString" would appear next to "One" and "TwoString" next to "Two" in the running window.
The question is: Why didn't this work? What will work instead? If I put bindings in a DataTemplate, it works. Blend, with its sample data stuff, implied that this should work, but it doesn't.
How can I make a speech mark in a string? The following shows the whole of the line and all code after that (With the Express IDE) to be a comment as well:
View 2 RepliesI have several sets of similar objects (labels, progress bars) on a form in Visual Basic 2010 on Windows. In my code, I have collections that contain data, which needs to be pushed into the value/text property of each.
I would like to get a solution similar to PHP in that I can assign values somewhat like:
For ID as Integer from 0 to count(collectionExample)
lblExample{ID}.Text=collectionExample(variableID)
...and as such to loop through so each of the different lblExample's were updated to their corresponding value.
The issue I have come to is that I cannot seem to reference an object on the form using a variable. I have also tried using something like
CallByName("lblExample" + variableID, "Text", CallType.Set, exampleCollection(variableID))... however I still can't combine the string and variable to reference the object.
Any solutions on referring to objects in VB2010 by combining a string prefix and a variable string identifier, similar to PHP's $variable{$variable} approach?
Edit: Windows Platform
im trying to add a new data source to my visual studio 2010 project. As it stands my project consists of a few windows forms. I plan on making it access a database (made in access, unless this is a problem), and be able to perform pre-set queries, search/sort, and basic delete,add,edit functions. I will hopefully be later adding the function to print reports according to the database entries.However, the problem i am having is that when i go on to data sources, and click add new source, the following happens:3, it asks me which connection i will be using, i click new connection, then in the new connection dialog i choose the following : Microsoft Access Database File (OLE DB), then i browse for the database i made in the 'database file name' box, Then i delete the default username in the log in to database bit, as my database has no protection.
View 3 RepliesI try to find the example for reading data from USB Joystick using VB2010 but I couldn't. .
I found some but all were VB6.0.
Do I need to install DirectX or which component should I use. I can read data from mouse and keyboard.
create admin form to register, Remove, Edit user accounts in the system connected to Microsoft SQL Server R2 2008 or access database ? any toturial videos or instructuions step by step ?
View 3 RepliesMy responsibility is to build a vb.net function that when a scanner scans an object, it would take the scanned string and call a stored procedure to get a row of data that match that scanned string and pass the data row to an application that would print out a label. below is my vb.net and sql server stored procedure script 1. Do I have to come up with a public class in order to store my row of data to pass it on to a different vb.net application that would take that data row and print out a label? 2. In my stored procedure, how would I return the founded data row to the vb.net function?
[code]...
I have managed to successfully connect remotely to the MySQL database for my Joomla! 1.5 website using MySqlConnector in Visual Basic .NET 2010. Now I am trying to authenticate a user's password from values submitted in a simple form to those retrieved from a MySQL query.
I found a useful thread on forums.joomla.org titled "Joomla password MD5 & VB.NET MD5", but the code snippets there produce the incorrect hash.Here is another useful Joomla Forums thread as to how passwords are encrypted (using MD5 hash and "salt") in the Joomla DB.
[Code]...