mehdi mahbobi
شنبه 07 خرداد 1390, 21:01 عصر
سلام دوستان میدونم سوالم تکراریِ اما من نتونستم تو کدام مشکل حل کنم لطفا اگه میشه بگید این
ارور چرا اتفاق میفته.
Int32 SumScore = new Int32();
Int32 NumberRows = new Int32();
SqlConnection Cn1 = new SqlConnection("server=(local); database=MEHDI_BANK;Integrated Security=True ");
SqlDataAdapter Dadap = new SqlDataAdapter();
SqlCommand Cm2 = new SqlCommand();
Cm2.CommandText = "SumAndNumRow";
Cm2.Connection = Cn1;
Cm2.CommandType = CommandType.StoredProcedure;
Cm2.Parameters.Add("@SumScoreRow", SqlDbType.BigInt);
Cm2.Parameters.Add("@RowNumbers", SqlDbType.BigInt);
Cm2.Parameters["@SumScoreRow"].Direction = ParameterDirection.Output;
Cm2.Parameters["@RowNumbers"].Direction = ParameterDirection.Output;
NumberRows = Int32.Parse(Cm2.Parameters["@RowNumbers"].Value.ToString());
SumScore = Int32.Parse(Cm2.Parameters["@SumScoreRow"].Value.ToString());
Dadap.SelectCommand = Cm2;
Cn1.Open();
Cm2.ExecuteNonQuery();
ارور تو این خط اتفاق میافته
NumberRows = Int32.Parse(Cm2.Parameters["@RowNumbers"].Value.ToString());
SumScore = Int32.Parse(Cm2.Parameters["@SumScoreRow"].Value.ToString());
ارور چرا اتفاق میفته.
Int32 SumScore = new Int32();
Int32 NumberRows = new Int32();
SqlConnection Cn1 = new SqlConnection("server=(local); database=MEHDI_BANK;Integrated Security=True ");
SqlDataAdapter Dadap = new SqlDataAdapter();
SqlCommand Cm2 = new SqlCommand();
Cm2.CommandText = "SumAndNumRow";
Cm2.Connection = Cn1;
Cm2.CommandType = CommandType.StoredProcedure;
Cm2.Parameters.Add("@SumScoreRow", SqlDbType.BigInt);
Cm2.Parameters.Add("@RowNumbers", SqlDbType.BigInt);
Cm2.Parameters["@SumScoreRow"].Direction = ParameterDirection.Output;
Cm2.Parameters["@RowNumbers"].Direction = ParameterDirection.Output;
NumberRows = Int32.Parse(Cm2.Parameters["@RowNumbers"].Value.ToString());
SumScore = Int32.Parse(Cm2.Parameters["@SumScoreRow"].Value.ToString());
Dadap.SelectCommand = Cm2;
Cn1.Open();
Cm2.ExecuteNonQuery();
ارور تو این خط اتفاق میافته
NumberRows = Int32.Parse(Cm2.Parameters["@RowNumbers"].Value.ToString());
SumScore = Int32.Parse(Cm2.Parameters["@SumScoreRow"].Value.ToString());