指点下我写的代码?
刚转学c#,写了一点点代码 ,请指点下,我这样写行不?
最好多发表自己的意见。。
万分感谢!
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace Member_database
{
public class sqldbconnection
{
public static SqlConnection mysqlcon = new SqlConnection("server=.;userid=sa;password=123;database=member");
public void Mysql_conOpen()
{
try{
if (mysqlcon.State == ConnectionState.Open){
}
if (mysqlcon.State == ConnectionState.Closed){
mysqlcon.Open();
}
}catch (Exception ex){
if (ex!= null) mysqlcon = null;
}
}
public void Mysql_conClose()
{
try{
if (mysqlcon.State == ConnectionState.Open){
mysqlcon.Close();
mysqlcon.Dispose();
}
if (mysqlcon.State == ConnectionState.Closed){
mysqlcon.Dispose();
}
}catch (Exception ex){
if (ex != null) mysqlcon = null;
}
}
public static SqlDataReader SqlReader(string SqlCmd)
{
SqlDataReader sqldr = null;
// Mysql_conOpen;
SqlCommand cmd = new SqlCommand(SqlCmd, mysqlcon);
try{
sqldr = cmd.ExecuteReader();
}catch (Exception ex){
if (ex != null) sqldr = null;
}
return sqldr;
}
public static SqlCommand Ex_SqlCmd(string sqlcmd)
{
SqlCommand cmd = null;
// Mysql_conOpen();
cmd = new SqlCommand(sqlcmd, mysqlcon);
try{
cmd.ExecuteNonQuery();
}catch (Exception ex){
if (ex != null) cmd = null;
}
return cmd;
}
public static DataTable Read_table(string sqlcmd)
{
DataTable dt = null;
dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(sqlcmd, mysqlcon);
try{
da.Fill(dt);
}catch (Exception ex){
if (ex != null) dt = null;
}
return dt;
}
public static DataSet Read_Dataset(string sqlcmd)
{
DataSet ds = null;
ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sqlcmd, mysqlcon);
try{
da.Fill(ds);
}catch (Exception ex){
if (ex != null) ds = null;
}
return ds;
}
}
}