protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["LJTConnectionString2"].ConnectionString; SqlCommand com = new SqlCommand();
com.CommandText = "insert into MessageBoard('姓名','主题','留言时间','留言内容')" + "values(@txtName,@txtTheme,@txtTime,@txtMessage)";
com.CommandType = CommandType.Text;
com.Connection = con;
com.Parameters.Add("@txtName", SqlDbType.Char, 10, "姓名");
com.Parameters.Add("@txtTheme", SqlDbType.Char, 20, "主题");
com.Parameters.Add("@txtTime", SqlDbType.Char, 50, "留言时间");
com.Parameters.Add("@txtMessage", SqlDbType.Char, 800, "留言内容");
SqlDataAdapter dr = new SqlDataAdapter();
dr.InsertCommand = com; dr.Dispose();
com.Dispose();
con.Dispose();
}
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["LJTConnectionString2"].ConnectionString; SqlCommand com = new SqlCommand();
com.CommandText = "insert into MessageBoard('姓名','主题','留言时间','留言内容')" + "values(@txtName,@txtTheme,@txtTime,@txtMessage)";
com.CommandType = CommandType.Text;
com.Connection = con;
com.Parameters.Add("@txtName", SqlDbType.Char, 10, "姓名");
com.Parameters.Add("@txtTheme", SqlDbType.Char, 20, "主题");
com.Parameters.Add("@txtTime", SqlDbType.Char, 50, "留言时间");
com.Parameters.Add("@txtMessage", SqlDbType.Char, 800, "留言内容");
SqlDataAdapter dr = new SqlDataAdapter();
dr.InsertCommand = com; dr.Dispose();
com.Dispose();
con.Dispose();
}
dr.InsertCommand = com; 去掉.
使用com.ExecuteNonQuery()就可以了.
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["LJTConnectionString2"].ConnectionString; SqlCommand com = new SqlCommand();
com.CommandText = "insert into MessageBoard('姓名','主题','留言时间','留言内容')" + "values(@txtName,@txtTheme,@txtTime,@txtMessage)";
com.CommandType = CommandType.Text;
com.Connection = con;
com.Parameters.Add("@txtName", SqlDbType.Char, 10, "姓名");
com.Parameters.Add("@txtTheme", SqlDbType.Char, 20, "主题");
com.Parameters.Add("@txtTime", SqlDbType.Char, 50, "留言时间");
com.Parameters.Add("@txtMessage", SqlDbType.Char, 800, "留言内容"); //注释掉这三行
//SqlDataAdapter dr = new SqlDataAdapter();
//dr.InsertCommand = com;
//dr.Dispose();
//加这行
com.ExecuteNonQuery();
com.Dispose();
con.Dispose();
}
cmd = new SqlCommand(insert into MessageBoard('姓名','主题','留言时间','留言内容')" + "values(@txtName,@txtTheme,@txtTime,@txtMessage)", conn);
cmd.ExecuteNonQuery();
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["LJTConnectionString2"].ConnectionString; SqlCommand com = new SqlCommand();
com.CommandText = "insert into MessageBoard('姓名','主题','留言时间','留言内容') values(@txtName,@txtTheme,@txtTime,@txtMessage)";
com.CommandType = CommandType.Text;
com.Connection = con;
com.Parameters.AddWithValue("@txtName", txtName.Text);
com.Parameters.AddWithValue("@txtTheme", txtTheme.Text);
com.Parameters.AddWithValue("@txtTime", txtTime.Text);
com.Parameters.AddWithValue("@txtMessage", txtMessage.Text); con.Open();
com.ExecuteNonQuery();
con.Close();
}
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["LJTConnectionString2"].ConnectionString; SqlCommand com = new SqlCommand();
com.CommandText = "insert into MessageBoard('姓名','主题','留言时间','留言内容')" + "values(@txtName,@txtTheme,@txtTime,@txtMessage)";
com.CommandType = CommandType.Text;
com.Connection = con;
com.Parameters.Add("@txtName", SqlDbType.Char, 10, "姓名");
com.Parameters.Add("@txtTheme", SqlDbType.Char, 20, "主题");
com.Parameters.Add("@txtTime", SqlDbType.Char, 50, "留言时间");
com.Parameters.Add("@txtMessage", SqlDbType.Char, 800, "留言内容");
con.Open();//要打开数据库的
com.ExecuteNonQuery();
com.Dispose();
con.Dispose();
}
SqlDataAdapter dr = new SqlDataAdapter();
dr.InsertCommand = com; dr.Dispose();
这三行没用,直接用com.ExecuteNonQuery();
就行了。
SqlCommand com = new SqlCommand("insert into MessageBoard('姓名') values('"+UserName.Text+"')",con );
com.ExecuteNonQuery();
con.close();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["LJTConnectionString2"].ConnectionString);
SqlCommand com = new SqlCommand("insert into MessageBoard('姓名') values('"+UserName.Text+"')",con );
com.ExecuteNonQuery();
con.close();