110,566
社区成员
发帖
与我相关
我的任务
分享
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server=(local);Database=Mine;uid=sa;pwd=netbox123*;");
string sql = "delete from Count";
SqlCommand comm = new SqlCommand(sql, conn);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
Form2 f = new Form2();
f.Show();
}
public Form2()
{
InitializeComponent();
SqlConnection sqlConnection1 = new SqlConnection("Server=(local);Database=Mine;uid=sa;pwd=netbox123*;");
//创建数据连接 连接字符串改成用于读取自己数据库的
sqlConnection1.Open();
SqlCommand selectCMD = new SqlCommand("select count(*) from Count;", sqlConnection1);
//创建并初始化SqlCommand对象
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter();
selectCMD.Connection = sqlConnection1;
SqlDataAdapter custDA = new SqlDataAdapter();
sqlDataAdapter1.SelectCommand = selectCMD;
custDA.SelectCommand = selectCMD;
//创建SqlDataAdapter对象,并根据SelectCommand属性检索数据
DataSet dsDataSet1 = new DataSet();
sqlDataAdapter1.Fill(dsDataSet1, "Customers");
//使用SqlDataAdapter的Fill方法填充DataSet
label5.Text = dsDataSet1.Tables[0].Rows[0][0].ToString();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server=(local);Database=Mine;uid=sa;pwd=netbox123*;");
string sql = "delete from Count";
SqlCommand comm = new SqlCommand(sql, conn);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
//这里给label的text属性直接赋值不就行了.
label1.Text = "0";
}