c#中SQL Server问题 谁能给出c#中SQL Server连接的详细代码,以及如何往sql语句中传递参数的方法!谢谢!50点求解!高人指点! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 参看http://blog.csdn.net/knight94/archive/2006/04/15/664530.aspx 这里给出一个完整的VS2003连接SQL数据库,并填充datagrid的代码.string strConn="Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;";SqlConnection conn = new SqlConnection(strConn);SqlCommand cmd = new SqlCommand("select * from Orders");cmd.Connection = conn;conn.Open();SqlDataAdapter da = new SqlDataAdapter(cmd);DataSet ds=new DataSet();da.Fill(ds,"Orders");conn.Close();dtgUserInfo.SetDataBinding(ds,"Orders"); 关键是如何往sql语句里面传参数的问题!比如string sql="insert table (id,name,adress) values (?,?,?,?)"我要把4个TextBox的值取出来然后传给sql语句中的四个问号!例如:string id=TextBox1.text.ToString().trim(); . . .我们将这个四个字段如何传到sql语句中去,而且values(?,?,?,?)里面应该是参数呢 还是问号呢? 请给出详细代码! 分不够再加!求高人指点! 我晕 这还要问string sql="insert table (id,name,adress) values ('" + txt_id.text.trim() + "'," +..... + "')"; MySqlCommand cmd = new MySqlCommand("insert into table (id,name,adress) values (@id,@name,@adress)", Conn);cmd.Parameters.Add("@ID", MySqlDbType.Int24).Value = 1;...Conn.Open();MySqlDataReader dr = cmd.ExecuteReader();if(dr.Read()){ }dr.Close(); public int Addtable(int ID, string name, string adress) { string strConn = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;"; string strSQL = string.Format("insert table (id,name,adress) values ({0},{1},{2})", ID, name, adress); SqlConnection conn = new SqlConnection(strConn); SqlCommand cmd = new SqlCommand(strSQL, conn); try { conn.Open(); return cmd.ExecuteNonQuery(); conn.Close(); } catch { return 0; } } 楼上的string strSQL = string.Format("insert table (id,name,adress) values ({0},{1},{2})", ID, name, adress);没单引号会报错吧.... protected void btnSave_Click(object sender, EventArgs e) { string updateStr = "update code set code=@code"; String strConn = ConfigurationManager.AppSettings["webBlog"] + Server.MapPath("WebBlog.mdb"); OleDbConnection cn = new OleDbConnection(); cn.ConnectionString = strConn; OleDbCommand oledbCmd = new OleDbCommand(updateStr, cn); oledbCmd.Parameters.Add(new OleDbParameter("@code", OleDbType.VarChar, 50)); oledbCmd.Parameters["@code"].Value = tbpwd.Text.ToString(); cn.Open(); try { oledbCmd.ExecuteNonQuery(); label1.Text = "update succeed!"; } catch { message.Text = "update failure!"; } cn.Close(); }//配置文件中的内容:<appSettings> <add key="webblog" value="Provider = Microsoft.Jet.OLEDB.4.0;Data Source = "/> </appSettings> //webBlog是我的access数据库文件 winform中的datagridview问题 编写控制台应用程序时,应主要使用class diagram,还是直接编写代码? 读取Excel的老问题.. 怎么分析这个错误了? c# + sql server ce建表失败 用DataSet怎样取得记录的中某一列的值? 关于c#.net和usb加密狗 关于平台调用 100分跪求答案! 关于参数的使用~oledb的 为什么要使用枚举类型?有什么好处? 怎样调整表中列的宽度使其填满整个datagrid
http://blog.csdn.net/knight94/archive/2006/04/15/664530.aspx
string strConn="Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;";
SqlConnection conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("select * from Orders");
cmd.Connection = conn;
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);DataSet ds=new DataSet();
da.Fill(ds,"Orders");
conn.Close();
dtgUserInfo.SetDataBinding(ds,"Orders");
比如string sql="insert table (id,name,adress) values (?,?,?,?)"
我要把4个TextBox的值取出来然后传给sql语句中的四个问号!
例如:string id=TextBox1.text.ToString().trim(); . . .
我们将这个四个字段如何传到sql语句中去,而且values(?,?,?,?)里面应该是参数呢 还是问号呢? 请给出详细代码! 分不够再加!求高人指点!
string sql="insert table (id,name,adress) values ('" + txt_id.text.trim() + "'," +..... + "')";
cmd.Parameters.Add("@ID", MySqlDbType.Int24).Value = 1;
...
Conn.Open();
MySqlDataReader dr = cmd.ExecuteReader();
if(dr.Read())
{
}
dr.Close();
{
string strConn = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;";
string strSQL = string.Format("insert table (id,name,adress) values ({0},{1},{2})", ID, name, adress);
SqlConnection conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand(strSQL, conn);
try
{
conn.Open();
return cmd.ExecuteNonQuery();
conn.Close();
}
catch
{
return 0;
}
}
string strSQL = string.Format("insert table (id,name,adress) values ({0},{1},{2})", ID, name, adress);没单引号会报错吧....
{
string updateStr = "update code set code=@code";
String strConn = ConfigurationManager.AppSettings["webBlog"] + Server.MapPath("WebBlog.mdb");
OleDbConnection cn = new OleDbConnection();
cn.ConnectionString = strConn;
OleDbCommand oledbCmd = new OleDbCommand(updateStr, cn);
oledbCmd.Parameters.Add(new OleDbParameter("@code", OleDbType.VarChar, 50));
oledbCmd.Parameters["@code"].Value = tbpwd.Text.ToString();
cn.Open();
try {
oledbCmd.ExecuteNonQuery();
label1.Text = "update succeed!";
}
catch {
message.Text = "update failure!";
}
cn.Close(); }//配置文件中的内容:
<appSettings>
<add key="webblog" value="Provider = Microsoft.Jet.OLEDB.4.0;Data Source = "/>
</appSettings> //webBlog是我的access数据库文件