private void button1_Click(object sender, EventArgs e)
{
string con = "Server=localhost;DataBase=demo;user id=sa;password=123456789;"; //数据库的信息
SqlConnection mycon = new SqlConnection(con); //连接数据库
mycon.Open(); //打开数据库
//删除数据
string sel;
//GeneralMethod.IsNumberic()这个函数判断字符串是否为数字
if (rem == 0 && GeneralMethod.IsNumberic(textBox1.Text))//rem=0表示选择按订单号删除
{
sel = "delete from lianxi where 订单号 =" + textBox1.Text;
SqlCommand com = new SqlCommand(sel, mycon); //将执行代码放入命令中
com.ExecuteReader(); //执行
}
if (rem == 1) // rem = 1表示选择按客户名删除
{
string a = textBox1.Text;
string b = @"‘a’";
sel = "delete from lianxi where 客户 =" + "\'" + textBox1.Text + "\'";
SqlCommand com = new SqlCommand(sel, mycon); //将执行代码放入命令中
com.ExecuteReader(); //执行
}
if (rem == 2) // rem = 2表示选择按商品删除
{
sel = "delete from lianxi where 商品 =" + "\'" + textBox1.Text + "\'";
SqlCommand com = new SqlCommand(sel, mycon); //将执行代码放入命令中
com.ExecuteReader(); //执行
}
Close();
}
private void button1_Click(object sender, EventArgs e)
{
int orderNumber;
string con = "Server=localhost;DataBase=demo;user id=sa;password=123456789;"; //数据库的信息
SqlConnection mycon = new SqlConnection(con); //连接数据库
mycon.Open(); //打开数据库
//增加数据
string sql = "insert into lianxi(订单号,客户,商品)" +
"values('{0}','{1}','{2}')";
string sel;
SqlCommand com;//将执行代码放入命令中
if (GeneralMethod.IsNumberic(textBox1.Text))
{
orderNumber = Int32.Parse(textBox1.Text);
sel = string.Format(sql, orderNumber, textBox2.Text, comboBox1.Text);
com = new SqlCommand(sel, mycon);
com.ExecuteReader();//执行
}
else
{
MessageBox.Show("请输入正确的订单号", "输入错误！！！");
}
Close();
}
private void button1_Click(object sender, EventArgs e)
{
for (int i = 0; i < Program.form1.students.ToArray().Length; i++)
{
if (rem == 0 && GeneralMethod.IsNumberic(textBox1.Text) &&
Program.form1.students[i].OrderNumber == int.Parse(textBox1.Text))
{
item = Program.form1.students[i];
}
if (rem == 1 && Program.form1.students[i].ClientName == textBox1.Text)
{
item = Program.form1.students[i];
}
if (rem == 2 && Program.form1.students[i].GoodsName == textBox1.Text)
{
item = Program.form1.students[i];
}
}
orderitem.DataSource = null;
orderitem.DataSource = item;
dataGridView2.Visible = true;
}
private void button1_Click(object sender, EventArgs e)
{
string con = "Server=localhost;DataBase=demo;user id=sa;password=123456789;"; //数据库的信息
SqlConnection mycon = new SqlConnection(con); //连接数据库
mycon.Open(); //打开数据库
string sel;
//按订单号修改
if (rem == 0 && GeneralMethod.IsNumberic(textBox1.Text) && GeneralMethod.IsNumberic(textBox2.Text))
{ //rem=0表示按订单号修改，GeneralMethod.IsNumberic(string)函数用来判断字符串是否为数字
sel = "update lianxi set 订单号 =" + textBox2.Text + "where 订单号 =" + textBox1.Text; //修改项目的代码
SqlCommand com = new SqlCommand(sel, mycon); //将执行代码放入命令中
com.ExecuteReader(); //执行
}
//按客户修改
if (rem == 1)//rem=1表示按客户修改
{
sel = "update lianxi set 客户 =" +
"\'" + textBox2.Text + "\'" + "where 客户 =" + "\'" + textBox1.Text + "\'"; //修改项目的代码
SqlCommand com = new SqlCommand(sel, mycon); //将执行代码放入命令中
com.ExecuteReader(); //执行
}
//按商品修改
if (rem == 2)//rem=2表示按商品修改
{
sel = "update lianxi set 商品 =" +
"\'" + textBox2.Text + "\'" + "where 商品 =" + "\'" + textBox1.Text + "\'"; //修改项目的代码
SqlCommand com = new SqlCommand(sel, mycon); //将执行代码放入命令中
com.ExecuteReader(); //执行
}
Close();
}