34,593
社区成员
发帖
与我相关
我的任务
分享
public DataTable getDataTable(String strSql)//strSql为查询用的SQL语句,自己写
{
System.Data.DataTable dt=null;
using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(
"server=ip;uid=sa;pwd=密码;database=数据库"))
{
using (System.Data.SqlClient.SqlCommand command = conn.CreateCommand())
{
command.CommandText =strSql;
using (System.Data.SqlClient.SqlDataAdapter adp = new
System.Data.SqlClient.SqlDataAdapter(command))
{
dt= new System.Data.DataTable();
adp.Fill(dt);
}
}
}
return dt;
}
public bool updateTable(String updateSql)
{
SqlConnection conn=new SqlConnection("server=.;uid=sa;pwd=;database=数据库名");
SqlCommand cmd=new SqlCommand(updateSql,conn);
conn.open();
int result=cmd.executeNonequery();
if(result>0)
return true;
else
return false;
}
//更新记录
SqlCommand updateCmd = new SqlCommand("update TableA set KeyValue = @KeyValue" + "where KeyName='" + 变量 + "'", _conn);
adapter.UpdateCommand = updateCmd;
adapter.UpdateCommand.Parameters.Add("@KeyValue", SqlDbType.NVarChar, 2, "KeyValue");
dt.Rows[0][2] = 新的值;
adapter.Update(dt);
string mSql = "select ID,KeyName,KeyValue,UpdateTime from TableA ";
//连接数据库
string SqlConn = "data source=服务名;initial catalog=数据库名;user id=登陆名;password=密码";
SqlConnection _conn = new SqlConnection(SqlConn);
_conn.Open();
//查询后存入DataTable
DataTable dt = new DataTable("result");
SqlCommand mySqlDataSetCmd = new SqlCommand(mSql, _conn);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = mySqlDataSetCmd;
adapter.Fill(dt);
//返回DataTable
if (dt.Rows.Count == 0)
{
return null;
}
else
{
return dt;
}
//从title表中取数据放在datatable中
SqlConnection conn=new SqlConnection("server=.;database=pubs;uid=sa;pwd=sa");
SqlCommand cmd=new SqlCommand("select * from titles",conn);
SqlDataAdapter da=new SqlDataAdapter(cmd);
dataset ds=new DataSet();
da.Fill(ds,"titles");
//修改datatable中第一行title字段的数据为“s”,并提交数据库更改。
ds.Tables[0].Rows[0]["title"]="s";
da.Update(ds,"titles");
ds.AcceptChanges();
using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection("server=ip;uid=sa;pwd=密码;database=数据库"))
{
using (System.Data.SqlClient.SqlCommand command = conn.CreateCommand())
{
command.CommandText = "select ...";
using (System.Data.SqlClient.SqlDataAdapter adp = new System.Data.SqlClient.SqlDataAdapter(command))
{
System.Data.DataTable dt = new System.Data.DataTable();
adp.Fill(dt);
}
}
}