public void ConnectToData() { System.Data.Odbc.OdbcConnection conn = new System.Data.Odbc.OdbcConnection (); // TODO: Modify the connection string and include any // additional required properties for your database. conn.ConnectionString = "FIL=MS Access;DSN=valid data source name"; try { conn.Open(); // Process data here. } catch (Exception ex) { MessageBox.Show("Failed to connect to data source"); } finally { conn.Close(); } } sqlserver数据库是使用sql连接语句的
{
System.Data.Odbc.OdbcConnection conn =
new System.Data.Odbc.OdbcConnection ();
// TODO: Modify the connection string and include any
// additional required properties for your database.
conn.ConnectionString = "FIL=MS Access;DSN=valid data source name";
try
{
conn.Open();
// Process data here.
}
catch (Exception ex)
{
MessageBox.Show("Failed to connect to data source");
}
finally
{
conn.Close();
}
}
sqlserver数据库是使用sql连接语句的
注意: 对于在末尾紧跟着DSN 参数被引用的双引号(VB语法), 你必须改变符合你所使用的语言所指定的引用符号语法。DSN参数为空实际上非常重要,如果不包括的话将导致7778错误。