Guest User

Untitled

a guest
Oct 31st, 2018
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. #region AddRoom
  2. public bool AddRoom()
  3. {
  4. SqlConnection con=new SqlConnection(@"server=DESKTOP-MS05MM5\SQLEXPRESS;Integrated Security=True;Database=abc")
  5. SqlCommand cmd = new SqlCommand("uspaddroom",con);
  6. SqlParameter p1=cmd.Parameters.Add("@RoomName",SqlDbType.VarChar,30);
  7. SqlParameter p2=cmd.Parameters.Add("@RoomType",SqlDbType.VarChar,30);
  8. SqlParameter p3=cmd.Parameters.Add("@City",SqlDbType.VarChar,30);
  9. SqlParameter p4=cmd.Parameters.Add("@Location",SqlDbType.VarChar,30);
  10. SqlParameter p5=cmd.Parameters.Add("@Block",SqlDbType.VarChar,30);
  11. SqlParameter p6=cmd.Parameters.Add("@Address",SqlDbType.VarChar,50);
  12. SqlParameter p7=cmd.Parameters.Add("@CoordinatorName",SqlDbType.VarChar,30);
  13. SqlParameter p8=cmd.Parameters.Add("@SeatingCapacity",SqlDbType.Int);
  14. SqlParameter p9=cmd.Parameters.Add("@TableType",SqlDbType.VarChar,30);
  15. SqlParameter p10=cmd.Parameters.Add("@NoOfMachines",SqlDbType.Int);
  16. SqlParameter p11=cmd.Parameters.Add("@Facilities",SqlDbType.VarChar,30);
  17. SqlParameter p12=cmd.Parameters.Add("@Remarks",SqlDbType.VarChar,30);
  18. SqlParameter p13=cmd.Parameters.Add("@NoOfParticipants",SqlDbType.VarChar,30);
  19.  
  20. }
Add Comment
Please, Sign In to add comment