You must Sign In to post a response.
  • Category: .NET

    Sqlhelper

    how to execute sqlcommand in sqlhelper class for examble

    scmdIQD = new SqlCommand("spI_quote_detail");

    scmdIQD.CommandType = CommandType.StoredProcedure;
    scmdIQD.Parameters.Add(new SqlParameter("@quote_id", hfCurrentQuoteID.Value));
    scmdIQD.Parameters.Add(new SqlParameter("@quote_item_type", "P"));
    scmdIQD.Parameters.Add(new SqlParameter("@quote_item_id", product_id));

    please anybody knows tell me
  • #508289
    SqlHelper.ExcuteNonQuery(sqlconn,CommandType.StoredProcedure,"ProcedureName",SqlParam)

  • #508301
    try like this


    scmdIQD.ExecuteNonQuery(DataAccess.ConnectionString, CommandType.StoredProcedure, "spI_quote_detail", new SqlParameter("@quote_id", hfCurrentQuoteID.Value), new SqlParameter("@quote_item_type", "P"), new SqlParameter("@quote_item_id", product_id));

    Thanks!
    Regards,
    Narendra

  • #508305
    use the

    scmdIQD.ExecuteNonQuery()


    methods

  • #508471
    Hi Ananta,Narendra Reddy vajrala i'm using sqlhelper class
    Regards
    Arun

  • #510356
    do u tried that query?
    Thanks!
    Regards,
    Narendra


  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.