Link to home
Start Free TrialLog in
Avatar of Alomiry
Alomiry

asked on

i got double value in database

Hello,

when i insert the value from my form and check the database i found double value Why?

My code Behind:

 SqlCommand query = cnn.CreateCommand();

            query.CommandText = "INSERT INTO [Hotel] ([Type],[Rates],[Name],[City],[Street],[ZipCode],[Country],[BulidingNumber],[ContactFullName],[PhoneNumber],[FaxNumber],[Website],[Email],[Hotel_description],[Check_in],[Check_out],[Distance_center],[Distance_train],[Distance_beach],[FacilitiesDescription],[ServiceDescription],[Terms_condition],[Policy]) VALUES ('" + AddType + "','" + AddRates + "','" + AddHotelName + "','" + AddCity + "','" + AddStreet + "','" + AddZipCode + "','" + AddCountry + "','" + AddBuildingNo + "','" + AddContactName + "','" + AddPhone + "','" + AddFax + "','" + AddWebsite + "','" + AddEmail + "','" + AddHotelDescription + "','" + AddCheckIn + "','" + AddCheckOut + "','" + AddDistanceCenter + "','" + AddDistanceTrain + "','" + AddDistanceBeach + "','" + AddFacilities + "','" + AddService + "','" + AddTerms + "','" + AddPolicy + "'); SELECT SCOPE_IDENTITY();";

            decimal hotelid = (decimal)query.ExecuteScalar();


            query.CommandText = "INSERT INTO [Room_type] ([Hotels_id],[Name]) VALUES ('" + hotelid.ToString() + "','" + AddRoomName + "');";

            query.CommandText += "INSERT INTO [Room_type] ([Hotels_id],[Name]) VALUES ('" + hotelid.ToString() + "','" + AddRoomName2 + "')";

            query.ExecuteNonQuery();
             
             SqlDataReader reader = query.ExecuteReader();



            reader.Close();
ASKER CERTIFIED SOLUTION
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Alomiry
Alomiry

ASKER

yes i have Hotel ID

it's working now when i remove :
      query.ExecuteNonQuery();

but it's ok to remove it and when we have to use ExecuteNonQuery();


Best regards
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Alomiry

ASKER

Perfect .

Best Regards
Avatar of Alomiry

ASKER

Perfect Soultion