h_r_sh
شنبه 08 فروردین 1388, 16:04 عصر
با سلام. به نظر شما مشكل اين كد چيه؟ فقط اولين رديف جدول رو i بار به جدول اضافه مي كنه!!
OleDbDataAdapter _da = new OleDbDataAdapter("select * from tlh_force", con);
DataSet _ds = new DataSet();
_da.Fill(_ds, "tlh_force");
int _r = _ds.Tables[0].Rows.Count;
OleDbCommand _com = new OleDbCommand();
if (conn.State == ConnectionState.Closed)
conn.Open();
for (int i = 0; i < _r ; i++)
{
_com.CommandText = "insert into tbl_loc (point_id,point_loc,point_ecc,point_col,point_col_ w,point_col_h) values (@a,@b,@c,@d,@e,@f)";
OleDbParameter ap = new OleDbParameter("@a", _ds.Tables[0].Rows[i]["Point"].ToString());
OleDbParameter bp = new OleDbParameter("@b", "Edge");
OleDbParameter cp = new OleDbParameter("@c", 1);
OleDbParameter dp = new OleDbParameter("@d", "Box Shape");
OleDbParameter ep = new OleDbParameter("@e", 1);
OleDbParameter fp = new OleDbParameter("@f", 1);
_com.Parameters.AddRange(new OleDbParameter[] { ap, bp, cp, dp, ep, fp });
_com.Connection = conn;
_com.ExecuteNonQuery();
}
OleDbDataAdapter _da = new OleDbDataAdapter("select * from tlh_force", con);
DataSet _ds = new DataSet();
_da.Fill(_ds, "tlh_force");
int _r = _ds.Tables[0].Rows.Count;
OleDbCommand _com = new OleDbCommand();
if (conn.State == ConnectionState.Closed)
conn.Open();
for (int i = 0; i < _r ; i++)
{
_com.CommandText = "insert into tbl_loc (point_id,point_loc,point_ecc,point_col,point_col_ w,point_col_h) values (@a,@b,@c,@d,@e,@f)";
OleDbParameter ap = new OleDbParameter("@a", _ds.Tables[0].Rows[i]["Point"].ToString());
OleDbParameter bp = new OleDbParameter("@b", "Edge");
OleDbParameter cp = new OleDbParameter("@c", 1);
OleDbParameter dp = new OleDbParameter("@d", "Box Shape");
OleDbParameter ep = new OleDbParameter("@e", 1);
OleDbParameter fp = new OleDbParameter("@f", 1);
_com.Parameters.AddRange(new OleDbParameter[] { ap, bp, cp, dp, ep, fp });
_com.Connection = conn;
_com.ExecuteNonQuery();
}