public static string strconn = @" Data Source=localhost;Initial Catalog=DB;Integrated Security=True;Pooling=False";
,
//这里将localhost换成你自己的数据源的地址,如果是本机就不用改了,DB是数据库名
public void ADDDATA()
{
string ConnectionString =strconn;
SqlConnection con = new SqlConnection();
con.ConnectionString = ConnectionString;
string cmdText = "select * from tb_post ";//换成你自己的语句
SqlDataAdapter da = new SqlDataAdapter(cmdText, con);
DataSet ds = new DataSet();
try
{
con.Open();
da.Fill(ds);
DataTable dt = ds.Tables[0];
DataRow newRow = dt.NewRow();//添加新的一行
newRow["aid"] = aid;
newRow["uid"] = uid;
newRow["pdatetime"] = pdatetime;
newRow["pnum"] =Convert.ToInt32(txtPnum) ;
newRow["pbal"] = Convert.ToInt32(txtPbal);
newRow["atype"] = atype;
newRow["pstat"] = pstat;
dt.Rows.Add(newRow);
SqlCommandBuilder scb = new SqlCommandBuilder(da);
da.Update(ds);
list = "添加成功";
}
catch (Exception ex)
{
}
con.Close();
return list;
}
第二种:
public void Search_uid()
{
int list = -1;
string ConnectionString = db.strconn;
SqlConnection con = new SqlConnection();
con.ConnectionString = ConnectionString;
string cmdText = "select * from tb_user where uname='" + name + "'";//换成你自己的语句
SqlCommand cmd = new SqlCommand(cmdText, con);
try
{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();//读取符合查找条件的所有数据
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
{
list = Convert.ToInt32(dr["ID"]);
}
}
dr.Close();
}
catch (Exception ex)
{
}
con.Close();
return list;
}