Insert a variable into SQL database

Question

Am a newbie to webservices and SQL. i have developed a webservice that inserts into a SQL database. below is my code.

 public class balanceEnquiry : System.Web.Services.WebService
 {
    [WebMethod(MessageName = "CheckBalance")]//To Check Balance......
    [System.Web.Services.Protocols.SoapDocumentMethodAttribute(Action = "CheckBalance", RequestNamespace = "http://www.zain.com/", ResponseNamespace = "http://www.zain.com/", Use = System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle = System.Web.Services.Protocols.SoapParameterStyle.Wrapped)]
    public string CheckBalance(string AccountNumber, string msisdn, string pin)
    {
        ValidationAPIClient client = new ValidationAPIClient();

        //validate sub by pin
        //fetch MAI by msisdn
        //validate pin

I want to insert the msisdn entered by the user into my database. and also the response from a partner API to my webservice is as below

 return validateAccountResultItem.responseExtraData;

I want to insert the 2 in my database. How will i write my insert statement. Below is what i have been doing

cmd.CommandText = string.Format("INSERT INTO MSSG(REFERENCE_ID, TIMESTAMP, DEST_MSISDN, MESSAGE, TYPE, HOSTIP) VALUES ('1234567890', SYSDATE,'91976707759','TESTMESSAGE','0',(SELECT HOSTIP FROM SMPP_TRANSMITTER WHERE STATUS = 1 AND ROWNUM = 1))");

Instead of hardcoding the DEST_MSISDN and MESSAGE columns, i want them to be the string entered by the user and validateAccountResultItem.responseExtraData respectively.

jazzytomato · Accepted Answer · 2014-11-13 13:13:12Z

1

cmd.CommandText = string.Format("INSERT INTO MSSG(REFERENCE_ID, TIMESTAMP, DEST_MSISDN, MESSAGE, TYPE, HOSTIP) VALUES ('1234567890', SYSDATE,@DEST_MSISDN,@MESSAGE,'0',(SELECT HOSTIP FROM SMPP_TRANSMITTER WHERE STATUS = 1 AND ROWNUM = 1))");

String destMsisdn, message;

//**todo** here, retrieve user input in those two variables


cmd.Parameters.AddWithValue("@DEST_MSISDN", destMsisdn);
cmd.Parameters.AddWithValue("@MESSAGE", message);

answered Nov 13, 2014 at 13:13

jazzytomato

7,2593 gold badges33 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert a variable into SQL database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related