我搞不定连数据库

Question

有谁有连数据库的教程啊，我搞不定啊！1

Answer 1

www.connectionstring.com
看看，都有了

Answer 2

/// <summary>
/// 打开数据库连接
/// </summary>
/// <param name="connStr">连接字符串</param>
public static void openConnection(String connStr)
{
if (myConnection.State == ConnectionState.Closed)
{
myConnection.ConnectionString = connStr;
myCommand.Connection = myConnection;
try
{
myConnection.Open();
}
catch(Exception e)
{
throw new Exception(e.Message);
}
}
}

Answer 3

/// <summary>
/// 关闭当前数据库连接
/// </summary>
public static void closeConnection()
{
if(myConnection.State == ConnectionState.Open)
myConnection.Close();
myConnection.Dispose();
myCommand.Dispose();
} /// <summary>
/// 执行SQL语句,不返回结果集
/// </summary>
/// <param name="connStr">连接字符串</param>
/// <param name="cmdStr">SQL语句</param>
public static void ExecuteSql(String connStr, String cmdStr)
{
try
{
openConnection(connStr);
myCommand.CommandType = CommandType.Text;
myCommand.CommandText = cmdStr;
myCommand.ExecuteNonQuery();
}
catch(Exception e)
{
throw new Exception(e.Message);
}
finally
{
closeConnection();
}
}
/// <summary>
/// 执行SQL语句,并返回DataSet
/// </summary>
/// <param name="connStr">连接字符串</param>
/// <param name="cmdStr">SQL语句</param>
/// <param name="dataTableName">DataTableName</param>
public static DataSet ExecuteSqlReturnDataset(String connStr, String cmdStr, string dataTableName)
{
SqlDataAdapter myAdapter = new SqlDataAdapter();
DataSet ds = new DataSet();
try
{
openConnection(connStr);
myCommand.CommandType = CommandType.Text;
myCommand.CommandText = cmdStr;
                myAdapter.SelectCommand = myCommand;
myAdapter.Fill(ds, dataTableName);
}
catch(Exception e)
{
throw new Exception(e.Message);
}
finally
{
closeConnection();
}
return ds;
}

Answer 4

ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.2052/cpref/html/frlrfsystemdatasqlclientsqlconnectionclasstopic.htm