string T = TextBox1.Text.Trim();
string content = TextBox2.Text;
DateTime time = DateTime.Parse(TextBox3.Text);
string beizhu = TextBox4.Text;
string m = DropDownList1.SelectedItem.Text;
DataSet dtx;
dtx = BC.GetTagstext(m);
DataTable dm = dtx.Tables["datatable"];
DataRow dn = dm.Rows[0];
int b = Convert.ToInt32(dn["Tag_ID"]);
int c = 0;
// BC.insertsql(T, b, content, time, beizhu,c);
//string msg = BC.msg;
// Response.Write("<script language=javascript>alert('" + msg + "');</script>");
string cn = Convert.ToString(ConfigurationManager.ConnectionStrings["mysql"]);
SqlConnection mycon = new SqlConnection(cn);
mycon.Open();
string str = "insert into Articles(Title,Tag_ID,A_content,PublishedTime,Dec,ViewNum) values('" + T + "'," + b + ",'" +content+ "','" + time.ToString()+ "','" + beizhu + "'" + c+ ")";
SqlCommand mycom = new SqlCommand(str, mycon);
mycom.ExecuteNonQuery();
mycon.Close();
谢啦,这个题目我纠结的是插入数据库的语句中时间日期类型是如何插入的,原先我将time类型设置datetime传入,后来更改为string可以直接插入。我对字符串很注意,但还是掉了个逗号
谢谢你教的这个方法