navid1n2000
یک شنبه 03 آبان 1388, 20:27 عصر
اين كد منه :
String str1;
str1=str;
SqlConnection objConnection = new SqlConnection("Server=PC;Database=VamDB;Integrated Security = True");
SqlDataAdapter objDataAdapter = new SqlDataAdapter();
DataSet objDataSet10;
DataView objDataView;
objDataAdapter.SelectCommand = new SqlCommand();
objDataAdapter.SelectCommand.Connection = objConnection;
objDataAdapter.SelectCommand.CommandText = "SELECT * FROM n WHERE ShOzviat in (" + str1 + ")";
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
objDataSet10 = new DataSet();
objConnection.Open();
objDataAdapter.Fill(objDataSet10, "n");
objConnection.Close();
objDataView = new DataView(objDataSet10.Tables["n"]);
dataGridView6.DataSource = objDataView;
dataGridView6.Columns[0].HeaderText = "ëي ¢";
dataGridView6.Columns[0].Width = 100;
dataGridView6.Columns[1].HeaderText = "¬êں©ى مàيی¢";
dataGridView6.Columns[1].Width = 130;
dataGridView6.Columns[2].HeaderText = "ëںê";
dataGridView6.Columns[2].Width = 130;
dataGridView6.Columns[3].HeaderText = "ëںê ¦ںëيں§گی";
dataGridView6.Columns[3].Width = 130;
dataGridView6.Columns[4].HeaderText = "ëںê پ§©";
dataGridView6.Columns[4].Width = 130;
dataGridView6.Columns[5].HeaderText = "¬êں©ى ¬ëں«ëںêى";
dataGridView6.Columns[5].Width = 130;
dataGridView6.Columns[6].HeaderText = "ک§ êéی";
dataGridView6.Columns[6].Width = 130;
dataGridView6.Columns[7].HeaderText = "ک§ پ©«ëéی";
dataGridView6.Columns[7].Width = 130;
dataGridView6.Columns[8].HeaderText = "¢ں©ی¦";
dataGridView6.Columns[8].Width = 130;
dataGridView6.Columns[9].HeaderText = "êیھںë يںê";
dataGridView6.Columns[9].Width = 130;
dataGridView6.Columns[10].HeaderText = "¢ں©ی¦ پ©§ں¦¢ يںê";
dataGridView6.Columns[10].Width = 150;
dataGridView6.Columns[11].HeaderText = "¢ں©ی¦ مàيی¢";
dataGridView6.Columns[11].Width = 130;
dataGridView6.Columns[12].HeaderText = "ëيم يںê";
dataGridView6.Columns[12].Width = 130;
dataGridView6.Columns[13].HeaderText = "êیھںë «©êںیى";
dataGridView6.Columns[13].Width = 130;
dataGridView6.Columns[14].HeaderText = "êیھںë ç«ل «©êںیى";
dataGridView6.Columns[14].Width = 150;
dataGridView6.Columns[15].HeaderText = "¢éهë";
dataGridView6.Columns[15].Width = 130;
dataGridView6.Columns[16].HeaderText = "ىê©ںى";
dataGridView6.Columns[16].Width = 130;
label32.Text = num.ToString() + " ëه© ";
DataTable dt = new DataTable();
DataView dv = new DataView();
objDataAdapter.Fill(dt);
dv = dt.DefaultView;
dv.Sort = "ShOzviat";
CrystalReport1 rptmain = new CrystalReport1();
rptmain.SetDataSource(dv);
crystalReportViewer1.ReportSource = rptmain;
اينم خطا :
http://up.iranblog.com/2/1256496399.jpg
دليلش چيه ؟
String str1;
str1=str;
SqlConnection objConnection = new SqlConnection("Server=PC;Database=VamDB;Integrated Security = True");
SqlDataAdapter objDataAdapter = new SqlDataAdapter();
DataSet objDataSet10;
DataView objDataView;
objDataAdapter.SelectCommand = new SqlCommand();
objDataAdapter.SelectCommand.Connection = objConnection;
objDataAdapter.SelectCommand.CommandText = "SELECT * FROM n WHERE ShOzviat in (" + str1 + ")";
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
objDataSet10 = new DataSet();
objConnection.Open();
objDataAdapter.Fill(objDataSet10, "n");
objConnection.Close();
objDataView = new DataView(objDataSet10.Tables["n"]);
dataGridView6.DataSource = objDataView;
dataGridView6.Columns[0].HeaderText = "ëي ¢";
dataGridView6.Columns[0].Width = 100;
dataGridView6.Columns[1].HeaderText = "¬êں©ى مàيی¢";
dataGridView6.Columns[1].Width = 130;
dataGridView6.Columns[2].HeaderText = "ëںê";
dataGridView6.Columns[2].Width = 130;
dataGridView6.Columns[3].HeaderText = "ëںê ¦ںëيں§گی";
dataGridView6.Columns[3].Width = 130;
dataGridView6.Columns[4].HeaderText = "ëںê پ§©";
dataGridView6.Columns[4].Width = 130;
dataGridView6.Columns[5].HeaderText = "¬êں©ى ¬ëں«ëںêى";
dataGridView6.Columns[5].Width = 130;
dataGridView6.Columns[6].HeaderText = "ک§ êéی";
dataGridView6.Columns[6].Width = 130;
dataGridView6.Columns[7].HeaderText = "ک§ پ©«ëéی";
dataGridView6.Columns[7].Width = 130;
dataGridView6.Columns[8].HeaderText = "¢ں©ی¦";
dataGridView6.Columns[8].Width = 130;
dataGridView6.Columns[9].HeaderText = "êیھںë يںê";
dataGridView6.Columns[9].Width = 130;
dataGridView6.Columns[10].HeaderText = "¢ں©ی¦ پ©§ں¦¢ يںê";
dataGridView6.Columns[10].Width = 150;
dataGridView6.Columns[11].HeaderText = "¢ں©ی¦ مàيی¢";
dataGridView6.Columns[11].Width = 130;
dataGridView6.Columns[12].HeaderText = "ëيم يںê";
dataGridView6.Columns[12].Width = 130;
dataGridView6.Columns[13].HeaderText = "êیھںë «©êںیى";
dataGridView6.Columns[13].Width = 130;
dataGridView6.Columns[14].HeaderText = "êیھںë ç«ل «©êںیى";
dataGridView6.Columns[14].Width = 150;
dataGridView6.Columns[15].HeaderText = "¢éهë";
dataGridView6.Columns[15].Width = 130;
dataGridView6.Columns[16].HeaderText = "ىê©ںى";
dataGridView6.Columns[16].Width = 130;
label32.Text = num.ToString() + " ëه© ";
DataTable dt = new DataTable();
DataView dv = new DataView();
objDataAdapter.Fill(dt);
dv = dt.DefaultView;
dv.Sort = "ShOzviat";
CrystalReport1 rptmain = new CrystalReport1();
rptmain.SetDataSource(dv);
crystalReportViewer1.ReportSource = rptmain;
اينم خطا :
http://up.iranblog.com/2/1256496399.jpg
دليلش چيه ؟