السلام عليكم
لقد واجهتني مشكلة كبيرة في موضوع Array في باراميتر
ولم اجد حلا مطلقا فالمشكلة كما يبدو في SqlCommand
Customer c = new Customer();
DataSet dss = new DataSet();
int[] xxx = new int[3] { 1, 2, 3 };
dss = c.GetCustomersForID(xxx);
listBox2.DisplayMember = "customername";
listBox2.ValueMember = "customerid";
listBox2.DataSource = dss.Tables["customers1"];
}
public DataSet GetCustomersForID(int[] custid)
{
SqlCommand com = new SqlCommand();
for (int i = 0; i < 3; i++)
{
// DataSet dss = new DataSet();
ds = new DataSet();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=FADI-PC;Initial Catalog=Car_Rent;Integrated Security=True;";
com.Connection = conn;
ds = new DataSet();
SqlParameter par1 = new SqlParameter();
com.CommandText = "getcustomersforid";
com.CommandType = CommandType.StoredProcedure;
par1.ParameterName = "@customerid";
par1.Value = custid;
com.Parameters.Add(par1);
da = new SqlDataAdapter(com);
}
da.Fill(ds, "customers1");
return ds;
}