Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #region AddRoom
- public bool AddRoom()
- {
- SqlConnection con=new SqlConnection(@"server=DESKTOP-MS05MM5\SQLEXPRESS;Integrated Security=True;Database=abc")
- SqlCommand cmd = new SqlCommand("uspaddroom",con);
- SqlParameter p1=cmd.Parameters.Add("@RoomName",SqlDbType.VarChar,30);
- SqlParameter p2=cmd.Parameters.Add("@RoomType",SqlDbType.VarChar,30);
- SqlParameter p3=cmd.Parameters.Add("@City",SqlDbType.VarChar,30);
- SqlParameter p4=cmd.Parameters.Add("@Location",SqlDbType.VarChar,30);
- SqlParameter p5=cmd.Parameters.Add("@Block",SqlDbType.VarChar,30);
- SqlParameter p6=cmd.Parameters.Add("@Address",SqlDbType.VarChar,50);
- SqlParameter p7=cmd.Parameters.Add("@CoordinatorName",SqlDbType.VarChar,30);
- SqlParameter p8=cmd.Parameters.Add("@SeatingCapacity",SqlDbType.Int);
- SqlParameter p9=cmd.Parameters.Add("@TableType",SqlDbType.VarChar,30);
- SqlParameter p10=cmd.Parameters.Add("@NoOfMachines",SqlDbType.Int);
- SqlParameter p11=cmd.Parameters.Add("@Facilities",SqlDbType.VarChar,30);
- SqlParameter p12=cmd.Parameters.Add("@Remarks",SqlDbType.VarChar,30);
- SqlParameter p13=cmd.Parameters.Add("@NoOfParticipants",SqlDbType.VarChar,30);
- }
Add Comment
Please, Sign In to add comment