How to implement two methods in a single call?

Prasad Bhagat

10y942.NET

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.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vivek Kumar10y ago
Rahul Chavan solution is looking good
0
Rahul Chavan10y ago
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

0
Prasad Bhagat10y ago
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
0
Rahul Chavan10y ago
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.
+1
Prasad Bhagat10y ago
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
0
Suresh M10y ago
return the result of first method and execute the second one or use Asynchronous Programming with Async and Await
0