روستا
یک شنبه 20 شهریور 1390, 16:29 عصر
با سلام و خسته نباشید.
من در C# 2010 برنامه ام رو نوشتم و همه چی ok هست ولی شیه ارور خیلی الکی می ده و برنامه رو اجرا نمی کنه. من همهی تنظیمات و ارتباط با SQL رو انجام دادم ولی در کدی که گذاشتم از
cmdclasf.ExecuteNonQuery();
ارور می گیره
لطفا راهنمایی کنید این برای چی اجرا نمی شه؟؟؟؟؟؟
SqlCommand
cmdclasf;
string strsql1;
strsql1 =
"INSERT INTO new(" + "date," + "code," + "name," + "family," + "sex," + "father," +
"birthday," + "telm," + "telmobile," + "telvaled," + "address," + "school," + "course," +
"avg," + "email," + "fatherjob," + "group1," + "pre," + "gh1," + "gh2," + "gh3," + "gh4," +
"gh5," + "gh6," + "gh7," + "gh8," + "gh9," + "m1," + "m2," + "m3," + "m4," + "m5," + "m6," + "m7," +
"m8," + "m9," +
") VALUES ('" + date.Text + "','" +txtcode.Text + "','" + name.Text + "','" + family.Text + "','" + sex.Text + "','" + father.Text + "','" + birthday.Text + "','" + telm.Text
+
"','" + telmobile.Text + "','" + telvaled.Text + "','" + address.Text + "','" + school.Text + "','" + course.Text + "','" + avg.Text + "','" + email.Text + "','" + fatherjob.Text + "','" + group.Text
+
"','" + pre.Text + "','" + gh1.Text + "','" + gh2.Text + "','" + gh3.Text + "','" + gh4.Text + "','" + gh5.Text + "','" + gh6.Text + "','" + gh7.Text + "','" + gh8.Text + "','" + gh9.Text + "','"
+ m1.Text +
"','" + m2.Text + "','" + m3.Text + "','" + m4.Text + "','" + m5.Text + "','" + m6.Text + "','" + m7.Text + "','" + m8.Text + "','" + m9.Text + "',)";
cmdclasf =
new SqlCommand(strsql1, con);
cmdclasf.ExecuteNonQuery();
con.Close();
MessageBox.Show("insert completed.");
ds.Clear();
da.Fill(ds,
"new");
من در C# 2010 برنامه ام رو نوشتم و همه چی ok هست ولی شیه ارور خیلی الکی می ده و برنامه رو اجرا نمی کنه. من همهی تنظیمات و ارتباط با SQL رو انجام دادم ولی در کدی که گذاشتم از
cmdclasf.ExecuteNonQuery();
ارور می گیره
لطفا راهنمایی کنید این برای چی اجرا نمی شه؟؟؟؟؟؟
SqlCommand
cmdclasf;
string strsql1;
strsql1 =
"INSERT INTO new(" + "date," + "code," + "name," + "family," + "sex," + "father," +
"birthday," + "telm," + "telmobile," + "telvaled," + "address," + "school," + "course," +
"avg," + "email," + "fatherjob," + "group1," + "pre," + "gh1," + "gh2," + "gh3," + "gh4," +
"gh5," + "gh6," + "gh7," + "gh8," + "gh9," + "m1," + "m2," + "m3," + "m4," + "m5," + "m6," + "m7," +
"m8," + "m9," +
") VALUES ('" + date.Text + "','" +txtcode.Text + "','" + name.Text + "','" + family.Text + "','" + sex.Text + "','" + father.Text + "','" + birthday.Text + "','" + telm.Text
+
"','" + telmobile.Text + "','" + telvaled.Text + "','" + address.Text + "','" + school.Text + "','" + course.Text + "','" + avg.Text + "','" + email.Text + "','" + fatherjob.Text + "','" + group.Text
+
"','" + pre.Text + "','" + gh1.Text + "','" + gh2.Text + "','" + gh3.Text + "','" + gh4.Text + "','" + gh5.Text + "','" + gh6.Text + "','" + gh7.Text + "','" + gh8.Text + "','" + gh9.Text + "','"
+ m1.Text +
"','" + m2.Text + "','" + m3.Text + "','" + m4.Text + "','" + m5.Text + "','" + m6.Text + "','" + m7.Text + "','" + m8.Text + "','" + m9.Text + "',)";
cmdclasf =
new SqlCommand(strsql1, con);
cmdclasf.ExecuteNonQuery();
con.Close();
MessageBox.Show("insert completed.");
ds.Clear();
da.Fill(ds,
"new");