两种
1、直接SQL 语句,insert 2、给你段代码看看,string name = guest_name.Value;
name = name.Replace("<","<").Replace(">",">").Replace(" "," ").Replace("\r","<br>");
string mail = guest_mail.Value;
mail = mail.Replace("<","<").Replace(">",">").Replace(" "," ").Replace("\r","<br>");
string page = guest_page.Value;
page = page.Replace("<","<").Replace(">",">").Replace(" "," ").Replace("\r","<br>");
string oicq = guest_oicq.Value;
string mood = guest_mood.Value;
string face = guest_face.Value;
string ip = Request.UserHostAddress; //客户端IP地址
string title = word_title.Value;
title = title.Replace("\r","<br>").Replace("<","<").Replace(">",">").Replace(" "," ").Replace("\r","<br>");
string content = word_content.Value;
content = content.Replace("<","<").Replace(">",">").Replace(" "," ").Replace("\r","<br>");
string reply = "站长回复:未回复";
string userid = 1.ToString();
string time = System.DateTime.Now.ToString();
string insertCmd = "insert into leave_word(guest_name, guest_mail, guest_page, guest_oicq, guest_mood, guest_face, guest_ip, word_title, word_content, word_userid, word_reply, word_time) values (@name, @mail, @page, @oicq, @mood, @face, @ip, @title, @content, @userid, @reply, @time)";OleDbCommand Cmd = new OleDbCommand(insertCmd,Conn);Cmd.Parameters.Add(new OleDbParameter("@name",OleDbType.Char, 30 ));
Cmd.Parameters["@name"].Value=name;
Cmd.Parameters.Add(new OleDbParameter("@mail",OleDbType.Char,30));
Cmd.Parameters["@mail"].Value=mail;
Cmd.Parameters.Add(new OleDbParameter("@page",OleDbType.Char,50));
Cmd.Parameters["@page"].Value=page;
Cmd.Parameters.Add(new OleDbParameter("@oicq",OleDbType.Char,30));
Cmd.Parameters["@oicq"].Value=oicq;
Cmd.Parameters.Add(new OleDbParameter("@mood",OleDbType.Char,30));
Cmd.Parameters["@mood"].Value=mood;
Cmd.Parameters.Add(new OleDbParameter("@face",OleDbType.Char,30));
Cmd.Parameters["@face"].Value=face;
Cmd.Parameters.Add(new OleDbParameter("@ip",OleDbType.Char,20));
Cmd.Parameters["@ip"].Value=ip;
Cmd.Parameters.Add(new OleDbParameter("@title",OleDbType.Char,200));
Cmd.Parameters["@title"].Value=title;
Cmd.Parameters.Add(new OleDbParameter("@content",OleDbType.VarChar,0));
Cmd.Parameters["@content"].Value=content;
Cmd.Parameters.Add(new OleDbParameter("@userid",OleDbType.Char,20));
Cmd.Parameters["@userid"].Value=userid;
Cmd.Parameters.Add(new OleDbParameter("@reply",OleDbType.VarChar,0));
Cmd.Parameters["@reply"].Value=reply;
Cmd.Parameters.Add(new OleDbParameter("@time",OleDbType.Char,50));
Cmd.Parameters["@time"].Value=time; //系统日期时间
//Cmd.CommandType=CommandType.Text;
Cmd.ExecuteNonQuery();
Conn.Close();
1、直接SQL 语句,insert 2、给你段代码看看,string name = guest_name.Value;
name = name.Replace("<","<").Replace(">",">").Replace(" "," ").Replace("\r","<br>");
string mail = guest_mail.Value;
mail = mail.Replace("<","<").Replace(">",">").Replace(" "," ").Replace("\r","<br>");
string page = guest_page.Value;
page = page.Replace("<","<").Replace(">",">").Replace(" "," ").Replace("\r","<br>");
string oicq = guest_oicq.Value;
string mood = guest_mood.Value;
string face = guest_face.Value;
string ip = Request.UserHostAddress; //客户端IP地址
string title = word_title.Value;
title = title.Replace("\r","<br>").Replace("<","<").Replace(">",">").Replace(" "," ").Replace("\r","<br>");
string content = word_content.Value;
content = content.Replace("<","<").Replace(">",">").Replace(" "," ").Replace("\r","<br>");
string reply = "站长回复:未回复";
string userid = 1.ToString();
string time = System.DateTime.Now.ToString();
string insertCmd = "insert into leave_word(guest_name, guest_mail, guest_page, guest_oicq, guest_mood, guest_face, guest_ip, word_title, word_content, word_userid, word_reply, word_time) values (@name, @mail, @page, @oicq, @mood, @face, @ip, @title, @content, @userid, @reply, @time)";OleDbCommand Cmd = new OleDbCommand(insertCmd,Conn);Cmd.Parameters.Add(new OleDbParameter("@name",OleDbType.Char, 30 ));
Cmd.Parameters["@name"].Value=name;
Cmd.Parameters.Add(new OleDbParameter("@mail",OleDbType.Char,30));
Cmd.Parameters["@mail"].Value=mail;
Cmd.Parameters.Add(new OleDbParameter("@page",OleDbType.Char,50));
Cmd.Parameters["@page"].Value=page;
Cmd.Parameters.Add(new OleDbParameter("@oicq",OleDbType.Char,30));
Cmd.Parameters["@oicq"].Value=oicq;
Cmd.Parameters.Add(new OleDbParameter("@mood",OleDbType.Char,30));
Cmd.Parameters["@mood"].Value=mood;
Cmd.Parameters.Add(new OleDbParameter("@face",OleDbType.Char,30));
Cmd.Parameters["@face"].Value=face;
Cmd.Parameters.Add(new OleDbParameter("@ip",OleDbType.Char,20));
Cmd.Parameters["@ip"].Value=ip;
Cmd.Parameters.Add(new OleDbParameter("@title",OleDbType.Char,200));
Cmd.Parameters["@title"].Value=title;
Cmd.Parameters.Add(new OleDbParameter("@content",OleDbType.VarChar,0));
Cmd.Parameters["@content"].Value=content;
Cmd.Parameters.Add(new OleDbParameter("@userid",OleDbType.Char,20));
Cmd.Parameters["@userid"].Value=userid;
Cmd.Parameters.Add(new OleDbParameter("@reply",OleDbType.VarChar,0));
Cmd.Parameters["@reply"].Value=reply;
Cmd.Parameters.Add(new OleDbParameter("@time",OleDbType.Char,50));
Cmd.Parameters["@time"].Value=time; //系统日期时间
//Cmd.CommandType=CommandType.Text;
Cmd.ExecuteNonQuery();
Conn.Close();
解决方案 »
- 送分啦,要分的速度啦....现在等.........................标题要长.................
- 请教一下大家如何新建和结束会话?
- VS2010,如何实现两个DIV并列?
- 请教一个邮件群发的问题(比单纯的群发多些东西)。
- |zyciis| 用什么规则把/List.xhtml?Brand=0001&Series=0060&Gender=0001&Item=0007改为为/NIKE/Series/0060/Gender/0
- 有没有例子--自己编写web程序,打开对pdf ,tiff文件,,并且防止别人下载,复制、另存,打印等,
- 求一个长度大于4的时候首字母不能0的正则表达式
- 是不是asp.net的页面只有用6.0以上的浏览器才可以看
- 想学习,苦于买不起VS.NET的D版盘怎么办??
- 怎么创建公用代码单元??
- 升级到Crystal 9中遇到的问题
- 我想一点击下载的链接就从数据库中取数据然后把它写在一个文本文件里,下载到客户端,不知道怎么做呀?
sqlDataAdapter.Update()
也可
数据表更新我所知道的两种
但是最好是先用对象保存这些值,你现在用的不是面向对象,好好学习OOP先
这种方法在使用大量更新或大量数据插入时特别有用。