数据库课设计某电力公司收费系统

trSqls;Р strSqls = string.Format("SELECT * FROM 用电信息 where 客户号='" + textBox1.Text.Trim() + "'and 类别号='" + textBox2.Text.Trim() + "'and 月份='" + textBox3.Text.Trim() + "';");Р //定义SQL Server连接对象Р SqlDataAdapter da = new SqlDataAdapter(strSqls, sqlcon);Р da.Fill(ds);Р if (ds.Tables[0].Rows.Count > 1)Р {Р MessageBox.Show("已经存在", "信息提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);Р }Р elseР {Р strSqls = "insert into 用电信息 values ('" + textBox1.Text.Trim() + "','" + textBox2.Text.Trim() + "','" + textBox3.Text.Trim() + "','" + textBox4.Text.Trim() + "');";Р //定义SQL Server连接对象Р ///////////////////Р SqlConnection sqlcon1 = new SqlConnection(consqlserver);Р mand cmd = new mand(strSqls, sqlcon1);Р tryР {Р sqlcon1.Open();Р cmd.ExecuteNonQuery();Р }Р catch { }