| Author: Sukanya 22 Nov 2006 | Member Level: Diamond | Rating:  Points: 2 |
Check this link
www.connectionstrings.com
|
| Author: Padma 22 Nov 2006 | Member Level: Diamond | Rating: Points: 2 |
hi check it out
Dim str As String = "data source=(local);" _
& "initial catalog=av;uid=sa;pwd=sa;"
|
| Author: venkatesan 22 Nov 2006 | Member Level: Diamond | Rating: Points: 2 |
Standard Security:
1. "Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;" < br>2. "Server=Your_Server_Name;Database=Your_Database_Name;UserID=Your_Username;Password=Your_Password;Trusted_Connection=False"
|
| Author: Mohan Kumar 22 Nov 2006 | Member Level: Diamond | Rating: Points: 2 |
hi,
try this.
"Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;"
|
| Author: sreelatha 22 Nov 2006 | Member Level: Silver | Rating: Points: 2 |
HI
import system
import system.data
import system.data.sqlclient
dim conn as new sqlconnection
dim dad as new sqldataAdapter
below code u write in the button
cn= sqlconnection("user id=sa;initial catalog=your_databasename;")
dad= sqldataAdapter(""select * from std", cn)
ds=new dataset()
dad.Fill(ds,"std")
|
| Author: sreelatha 22 Nov 2006 | Member Level: Silver | Rating: Points: 2 |
http://www.connectionstrings.com
|