110,500
社区成员
发帖
与我相关
我的任务
分享
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=刷卡记录;User ID=sa;password=sa;Integrated Security=False");
con.Open();
SqlCommand cmd = new SqlCommand(string.Format("select Count(*) from 门禁记录 where 卡号= '{0}'", textBox1.Text), con);
if ((int)cmd.ExecuteScalar() > 0)
{
listBox1.Items.Add(s1 + " 数据已经存在");
}
else
{
string strsql = "insert into 门禁记录(卡号,时间)value('" + textBox1.Text + "','" + textBox2.Text + "')";
cmd.CommandText = strsql;
cmd.ExecuteNonQuery();
listBox1.Items.Add(s1 + " 成功添加");
}
cmd.Dispose();
con.Close();
public static DataSet GetResult(string cmd)
{
string conn = "Data Source=BENDAN-PC;Initial Catalog=JMstudent;Integrated Security=True";
SqlConnection con = new SqlConnection(conn);
con.Open();
SqlDataAdapter ada = new SqlDataAdapter(cmd, con);
DataSet ds = new DataSet();
ada.Fill(ds);
return ds;
}
public static bool ExecCmd(string cmd)//增加修改删除
{
string conn = "Data Source=BENDAN-PC;Initial Catalog=JMstudent;Integrated Security=True";
SqlConnection con = new SqlConnection(conn);
con.Open();
SqlTransaction st = con.BeginTransaction();//启用事务实现
SqlCommand com = con.CreateCommand();
com.Transaction = st;
try
{
com.CommandText = cmd;
com.ExecuteNonQuery();
st.Commit();
return true;
}
catch
{
st.Rollback();
return false;
}
}