如何把textbox中的内容插入数据库中 可能这个问题很幼稚,请大家请教了! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 insert into tablename(textbox) values(TextBox.Text) 先写个简单完整的给你参考一下string AnnouncementTypeID = TextBox1.Text;string Name = TextBox2.Text;string SQL = "insert into [Announcement_Information](AnnouncementTypeID,Name) values( '" + AnnouncementTypeID + "','" + Name + "')"; SqlConnection myConn = new SqlConnection("server=JAMES_CUI;database=LivePortal_WorkFlow;uid=sa;pwd=sa;");SqlCommand mySqlCommand = new SqlCommand(SQL, myConn); 例如我在textbox中的输入一个内容,然后在button事件中把这个内容插入到数据库中 string AnnouncementTypeID = TextBox1.Text;string Name = TextBox2.Text;string SQL = "insert into [Announcement_Information](AnnouncementTypeID,Name) values( '" + AnnouncementTypeID + "','" + Name + "')"; SqlConnection myConn = new SqlConnection("server=JAMES_CUI;database=LivePortal_WorkFlow;uid=sa;pwd=sa;");SqlCommand mySqlCommand = new SqlCommand(SQL, myConn);cmd.CommandType = CommandType.Textcmd.ExecuteNonQuery(); 呵呵 真不好意思 没认真string AnnouncementTypeID = TextBox1.Text;string Name = TextBox2.Text;string SQL = "insert into [Announcement_Information](AnnouncementTypeID,Name) values( '" + AnnouncementTypeID + "','" + Name + "')"; SqlConnection myConn = new SqlConnection("server=JAMES_CUI;database=LivePortal_WorkFlow;uid=sa;pwd=sa;");SqlCommand mySqlCommand = new SqlCommand(SQL, myConn);mySqlCommand.CommandType = CommandType.TextmySqlCommand.ExecuteNonQuery(); protected void Button1_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(""); SqlCommand comm = new SqlCommand("", conn); comm.CommandText = "insert into a(a) values('"+TextBox1.Text+"')"; conn.Open(); comm.ExecuteNonQuery; } 数据库操作都是一样的,2005只是在03的基础上增加了些内容,SqlConnection conn = new SqlConnection(""); SqlCommand comm = new SqlCommand("", conn); comm.CommandText = "insert into a(a) values('"+TextBox1.Text+"')"; conn.Open(); comm.ExecuteNonQuery;是可以运行的 忘了告诉你要加上using System.Data.SqlClient;然后SqlConnection conn = new SqlConnection(""); 引号里写上自己的数据库连接字符串"insert into a(a) values 也自己改一下 SqlConnection conn = new SqlConnection("server=127.0.0.1;uid=sa;pwd=sa;database=a"); 如果用Windows 身份验证登录数据库,SqlConnection conn = new SqlConnection("");这个语句中如何填写? "insert into a(a) values( ' "+TextBox1.Text+ " ',' "+TextBox2.Text+ " ',' "+TextBox3.Text+ " ') ";为什么会提示错误: 字符文本中的字符太多呢 VS2008 asp.net 如何用C#判断用户是否已登录 如何固定页面的顶部 aspx 中在 div下动态添加html元素 生成静态页后表单如何提交数据 请教关于DataList的问题~~ 请问:在北京,有哪些公司是用.NET(C#)搞WebService开发的? 数据绑定问题,高手请进 大家讨论一下如何本机端口读得QQ对方发来得信息 HTTP 错误 500.19 - Internal Server Error问题 好不容易在ASP+BET1中实现了上传文件后自动解压,升级到.NET时,又不行了,请看 谁传一个asp.net做的WEBQQ 为Gridview添加确认删除的对话框
string AnnouncementTypeID = TextBox1.Text;
string Name = TextBox2.Text;
string SQL = "insert into [Announcement_Information](AnnouncementTypeID,Name) values( '" + AnnouncementTypeID + "','" + Name + "')";
SqlConnection myConn = new SqlConnection("server=JAMES_CUI;database=LivePortal_WorkFlow;uid=sa;pwd=sa;");
SqlCommand mySqlCommand = new SqlCommand(SQL, myConn);
string Name = TextBox2.Text;
string SQL = "insert into [Announcement_Information](AnnouncementTypeID,Name) values( '" + AnnouncementTypeID + "','" + Name + "')";
SqlConnection myConn = new SqlConnection("server=JAMES_CUI;database=LivePortal_WorkFlow;uid=sa;pwd=sa;");
SqlCommand mySqlCommand = new SqlCommand(SQL, myConn);
cmd.CommandType = CommandType.Text
cmd.ExecuteNonQuery();
string AnnouncementTypeID = TextBox1.Text;
string Name = TextBox2.Text;
string SQL = "insert into [Announcement_Information](AnnouncementTypeID,Name) values( '" + AnnouncementTypeID + "','" + Name + "')";
SqlConnection myConn = new SqlConnection("server=JAMES_CUI;database=LivePortal_WorkFlow;uid=sa;pwd=sa;");
SqlCommand mySqlCommand = new SqlCommand(SQL, myConn);
mySqlCommand.CommandType = CommandType.Text
mySqlCommand.ExecuteNonQuery();
{
SqlConnection conn = new SqlConnection("");
SqlCommand comm = new SqlCommand("", conn);
comm.CommandText = "insert into a(a) values('"+TextBox1.Text+"')";
conn.Open();
comm.ExecuteNonQuery;
}
SqlConnection conn = new SqlConnection("");
SqlCommand comm = new SqlCommand("", conn);
comm.CommandText = "insert into a(a) values('"+TextBox1.Text+"')";
conn.Open();
comm.ExecuteNonQuery;
是可以运行的
SqlConnection conn = new SqlConnection("");
这个语句中如何填写?
为什么会提示错误: 字符文本中的字符太多呢