我做了一个asp.net WebForm中含有一些列表框,文本框,下拉列表等列表框中选择的模式是多个。当我运行我的代码,并在各种盒子的输入值,并单击"Go"按钮,在同一页返回与选定的项目和数据不到数据库中去。
怎么办.... plz帮助{S0的}
代码为:
private void Postjob(string username,string companyname,string locations,string experiencemin,string experiencemax,string keyskills, string funcArea,string Industry, string postdate, string about, string desc)
{
SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Project3\\App_Data\\ojb1.mdf;Integrated Security=True;User Instance=True");
String sql = "INSERT INTO db(username,Companyname,Locations,Experiencemin,Experiencemax,Keyskills,Functionarea,Industry,Posted_date,About_Company,Job_Description)" +"VALUES(@userName,@Companyname,@Locations,@Experiencemin,@Experiencemax,@Keyskills,@Functionarea,@Industry,@Posted_date,@About_Company,@Job_Description)";
try
{
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlParameter[] param = new SqlParameter[11];
param[0] = new SqlParameter("@userName", SqlDbType.VarChar, 50);
param[1] = new SqlParameter("@Companyname", SqlDbType.VarChar, 50);
param[2] = new SqlParameter("@Locations", SqlDbType.VarChar, 100);
param[3] = new SqlParameter("@Experiencemin", SqlDbType.VarChar, 50);
param[4] = new SqlParameter("@Experiencemax", SqlDbType.VarChar, 50);
param[5] = new SqlParameter("@Keyskills", SqlDbType.VarChar, 1000);
param[6] = new SqlParameter("@Functionarea", SqlDbType.VarChar, 50);
param[7] = new SqlParameter("@Industry", SqlDbType.VarChar, 50);
param[8] = new SqlParameter("@Posted_date", SqlDbType.VarChar, 50);
param[9] = new SqlParameter("@About_Company", SqlDbType.VarChar, 1000);
param[10] = new SqlParameter("@Job_Description", SqlDbType.VarChar, 1000);
param[0].Value = username;
param[1].Value = companyname;
param[2].Value = locations;
param[3].Value = experiencemin;
param[4].Value = experiencemax;
param[5].Value = keyskills;
param[6].Value = funcArea;
param[7].Value = Industry;
param[8].Value = postdate;
param[9].Value = about;
param[10].Value = desc;
for (int i = 0; i < param.Length; i++)
{
cmd.Parameters.Add(param[i]);
}
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
string msg = "Insert Error";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
con.Close();
}
}
{C}