yuttrim20
دوشنبه 29 خرداد 1391, 11:49 صبح
دوستان اگه میشه لطفا کد رو ببینید و بگید که کجا رو تغییر بدم تا خطا نده مقدار lable یک اسمه!
query = "SELECT id FROM movie WHERE id=@id1";
com.CommandText = query;
com.Connection = conn;
com.Parameters.AddWithValue("@id1", Convert.ToInt32(Label1.Text.ToString()));
int id1 = Convert.ToInt32(com.ExecuteScalar());
query = "INSERT INTO [nazar sanji] VALUES(@id,@rate,@id1)";
com.CommandText = query;
com.Connection = conn;
com.Parameters.AddWithValue("@rate", title);
com.Parameters.AddWithValue("@id", id);
com.Parameters.AddWithValue("@id1", id1);
تو این خط:
com.Parameters.AddWithValue("@id1", Convert.ToInt32(Label1.Text.ToString()));
این error رو میده:Input string was not in a correct format.
query = "SELECT id FROM movie WHERE id=@id1";
com.CommandText = query;
com.Connection = conn;
com.Parameters.AddWithValue("@id1", Convert.ToInt32(Label1.Text.ToString()));
int id1 = Convert.ToInt32(com.ExecuteScalar());
query = "INSERT INTO [nazar sanji] VALUES(@id,@rate,@id1)";
com.CommandText = query;
com.Connection = conn;
com.Parameters.AddWithValue("@rate", title);
com.Parameters.AddWithValue("@id", id);
com.Parameters.AddWithValue("@id1", id1);
تو این خط:
com.Parameters.AddWithValue("@id1", Convert.ToInt32(Label1.Text.ToString()));
این error رو میده:Input string was not in a correct format.