关于数据库的三个方法
第一个是连接数据库
第二个是查询数据库并以table形式返回
第三个是插入数据库
public SqlConnection Connection(string str_sql)
{
string str = "server=.;user id=sa;password='000000';database=CRCData";
SqlConnection sql_conn = new SqlConnection(str);
return sql_conn;
}
public DataTable SelectDataBySql(string str_sql)
{
SqlConnection sql_conn = Connection(str_sql);
SqlDataAdapter Adapter = new SqlDataAdapter(str_sql, sql_conn);
DataSet ds = new DataSet();
Adapter.Fill(ds);
return ds.Tables[0];
}
public int InsertDataBySql(string str_sql)
{
SqlConnection conn = Connection(str_sql);
SqlCommand Command = new SqlCommand();
Command.Connection = conn;
Command.CommandType = CommandType.Text;
Command.CommandText = str_sql;
conn.Open();
int result = Command.ExecuteNonQuery();
conn.Close();
return result;
}