How to implement two methods in a single call?

Question

Dear All am writing two methods using c#.they are initially in my first method was saves the phone number into database and return the id or phone number and status . if the status is ok then i want to call my second method . my second method was simply storing a message into database with refrence of first method id or phone number into other table .please give me some idea .how can i call these methods.give me any examples .. am using simple c#sql server.

Rahul Chavan · Answer

Create a Stored Procedure add Insert trigger. In trigger write the data to new table. -or- You can use @@Rowcount to check number of rows / records inserted in the table. If it is 1 then you can add the vale in message table if value is 0 then you should write error.

Vivek Kumar · Answer

Rahul Chavan solution is looking good

Rahul Chavan · Answer

Hi Prasad int numberOfRowsAffected=0; String conString=ConfigurationManager.ConnectionStrings[myDatabaseConnectionString].ToString(); SqlConnection conn = new SqlConnection(conString); //Call stored Procedure SqlCommand cmd = new SqlCommand(insertIMEIdata conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(@IMEINbr SqlDbType.NVarChar).Value = inputParameter; conn.Open(); //numberOfRowsAffected variable will have number of rows affected numberOfRowsAffected=cmd.ExecuteNonQuery(); //Call to your Second Method-Write your Code conn.Close(); Stored Procedure Code: CREATE Procedure insertIMEIdata @IMEINbr nvarchar(50) AS insert into IMEIdata (IMEI) values (@IMEINbr) GO

Prasad Bhagat · Answer

Dear Rahul here i have two tables one is Master table thats having only two parameters like Id IMEI with the first method am saving the IMEI number into data table . and now am giving some result set with sucuss message and id or imei number  once the first method was completed client was received response as a ok then i want to call second method now i have a second table 2 parameters .with 2 parameters. one is from reference from 1st method and other one is data . this is my scenario. please help me .. how can i call these two methods.. and second method does not returns anything

Prasad Bhagat · Answer

Dear Suresh  am Posting my code here please help to call these 2 methods using such way.. method 1: public Resulset InsertIMEI(string imei) { Resulset result = new Resulset(); SqlConnection con = newSqlConnection(ConfigurationManager.ConnectionStrings[dbconnection].ConnectionString); SqlCommand cmd = new SqlCommand(InsertIMEI con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@IMEI imei); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0] != null) { result.StatusInd = Convert.ToInt32(ds.Tables[0].Rows[0][StatusInd].ToString()); result.StatusMsg = ds.Tables[0].Rows[0][StatusMsg].ToString(); result.ID=Convert.ToInt32(ds.Tables[0].Rows[0][Id].ToString()); } return result; } method 2: public void IsertImeIData(int IMEI string Data) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[dbconnection].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand(InsertIMEIData con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@IMEIID IMEI); cmd.Parameters.AddWithValue(@Data Data); cmd.executenonquery(); con.Close(); } so i want to call these two methods .please help me

Suresh M · Answer

return the result of first method and execute the second one or use Asynchronous Programming with Async and Await