读书人

怎么把textbox中的内容插入数据库中

发布时间: 2012-01-19 20:57:58 作者: rapoo

如何把textbox中的内容插入数据库中
可能这个问题很幼稚,请大家请教了!

[解决办法]
呵呵 真不好意思 没认真
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( "server=127.0.0.1;uid=sa;pwd=sa;database=a ");

读书人网 >asp.net

热点推荐