快捷搜索:

一个不是很通用的数据管理类

public class dbmanage

{

public dbmanage()

{

//

// TODO: 在此处添加构造函数逻辑

//

}

public SqlConnection GetConnection()//建立数据库连接

{

SqlConnection cn=new SqlConnection();

cn.ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["conn"];

cn.Open();

return cn;

}

public void delid(int intId ,string strTable,SqlConnection cn)

{

SqlCommand DeleteCmd=new SqlCommand ("delete from "+strTable+" where id="+intId,cn);

DeleteCmd.ExecuteNonQuery();

}

public void ExecuteSql(string strSql,SqlConnection cn) //履行无返回值的sql敕令

{

SqlCommand ExecuteCmd=new SqlCommand (strSql,cn);

ExecuteCmd.ExecuteNonQuery();

ExecuteCmd.Dispose();

}

public void UpdateTb(string strTbName, string strFieldsName,string strValue,int intId, SqlConnection cn)

{

SqlCommand UpdateCmd=new SqlCommand ("update strTbName set "+strFieldsName+"="+strValue+" where Id="+intId.ToString(),cn);

UpdateCmd.ExecuteNonQuery();

}

public DataSet FillDs(string strSql, SqlConnection cn)

{

SqlDataAdapter FillDsAdapter=new SqlDataAdapter(strSql,cn);

FillDsAdapter.SelectCommand.CommandType=CommandType.Text ;

DataSet ds =new DataSet();

FillDsAdapter.Fill(ds);

FillDsAdapter.Dispose();

return ds;

}

public DataSet FillDs(string strSql, SqlConnection cn,string srcTable)

{

SqlDataAdapter FillDsAdapter=new SqlDataAdapter(strSql,cn);

FillDsAdapter.SelectCommand.CommandType=CommandType.Text ;

DataSet ds =new DataSet();

FillDsAdapter.Fill(ds,srcTable);

FillDsAdapter.Dispose();

return ds;

}

public string GetString(string strSql,SqlConnection cn)//获取字符串

{

string strGetString="";

SqlDataAdapter FillDsAdapter=new SqlDataAdapter(strSql,cn);

FillDsAdapter.SelectCommand.CommandType=CommandType.Text ;

DataSet ds =new DataSet();

FillDsAdapter.Fill(ds);

if(ds.Tables[0].Rows.Count==1)

{

strGetString=ds.Tables[0].Rows[0][0].ToString();

}

else

{

strGetString=null;

}

FillDsAdapter.Dispose();

ds.Dispose();

return strGetString;

}

}

您可能还会对下面的文章感兴趣: