using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;namespace ADO
{
class ConSql
{
private SqlConnection con = null;
private SqlCommand comAdd = null;
private SqlCommand comModify = null;
private SqlCommand comDelete = null;
private SqlCommand comSearch = null;
private String demoDB_Add = "insert into userInfo (userName,userNumber) values ('哎',40)";
private String demoDB_Modify = "update userInfo set userNumber=100 where userNumber=50";
private String demoDB_Delite = "delete from userInfo where userNumber=40";
private String demoDB_Search = "select * from userInfo "; public void Add()
{
try
{
con =new SqlConnection("Server=.;database=demoDB;Integrated Security=SSPI");
comAdd = new SqlCommand(demoDB_Add, con);
comModify = new SqlCommand(demoDB_Modify);
comDelete = new SqlCommand(demoDB_Delite);
comSearch = new SqlCommand(demoDB_Search); }
catch (SqlException e)
{
MessageBox.Show(e.Message );
}
finally
{
con.Close();
} }
}
}哪里错了.告诉我...如果能帮我改成对的更好..谢谢!
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;namespace ADO
{
class ConSql
{
private SqlConnection con = null;
private SqlCommand comAdd = null;
private SqlCommand comModify = null;
private SqlCommand comDelete = null;
private SqlCommand comSearch = null;
private String demoDB_Add = "insert into userInfo (userName,userNumber) values ('哎',40)";
private String demoDB_Modify = "update userInfo set userNumber=100 where userNumber=50";
private String demoDB_Delite = "delete from userInfo where userNumber=40";
private String demoDB_Search = "select * from userInfo "; public void Add()
{
try
{
con =new SqlConnection("Server=.;database=demoDB;Integrated Security=SSPI");
comAdd = new SqlCommand(demoDB_Add, con);
comModify = new SqlCommand(demoDB_Modify);
comDelete = new SqlCommand(demoDB_Delite);
comSearch = new SqlCommand(demoDB_Search); }
catch (SqlException e)
{
MessageBox.Show(e.Message );
}
finally
{
con.Close();
} }
}
}哪里错了.告诉我...如果能帮我改成对的更好..谢谢!
这么写了,那么剩下的也在括号内加上con吧。比如 comModify = new SqlCommand(demoDB_Modify,con); 不过搞不懂你这代码是干什么的。
insert,update,delete,你最岂码得执行吧,比如comModify.ExecuteNonQuery();大哥,说真的,你还是先耐着性子看看书再提问题好吗?你这种问题提出来很丢人的,真的。
comModify = new SqlCommand(demoDB_Modify);
comDelete = new SqlCommand(demoDB_Delite);
comSearch = new SqlCommand(demoDB_Search); 这些代码不知道做什么的。增删改只要用ExecuteNonQuery()就可以了.