62,046
社区成员
发帖
与我相关
我的任务
分享
public class WebService : System.Web.Services.WebService
{
public WebService()
{
}
[WebMethod]
public int Insert(string title, string address)
{
string strconn = System.Configuration.ConfigurationSettings.AppSettings["connstring"];
SqlConnection cnn = new SqlConnection(strconn);
cnn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandText = "insert into test(title,address)values(@title,@address)";
SqlParameter fname = new SqlParameter("@title", title);
SqlParameter lname = new SqlParameter("@address", address);
cmd.Parameters.Add(title); //这是36行
cmd.Parameters.Add(address);
int i = cmd.ExecuteNonQuery();
cnn.Close();
return i;
}
}
cmd.Parameters.Add("@title", SqlDbType.VarChar, 50);
cmd.Parameters.Add("@address", SqlDbType.VarChar, 50);
cmd.Parameters["@title"].Value = title;
cmd.Parameters["@address"].Value = address;