Error out parameter must be assigned before control leave cu

ahmed elbarbary

Problem
Error out parameter must be assigned before control leave current method .
function GetInsertStatmentText below return full insert statement as below

INSERT INTO master_table(id, branch_id, name, address, phone) VALUES(@id, @branch_id, @name, @address, @phone);

in out paramter i need to return

@id, @branch_id, @name, @address, @phone

when i add out parameter to function i get error :

Error out parameter must be assigned before control leave current method

How to solve this error please ?

What I have tried:

public static string GetInsertStatmentText(string JsonData,out sqp)
{
string Insert = "";
JObject jo = JObject.Parse(JsonData);
JToken m = jo["master"];
string connectionstring = "Server=AHMEDSALAH-PC\\SQL2014;Database=Atum;User Id=sa;Password=abc123;"; //change connection string
using (SqlConnection connection = new SqlConnection(connectionstring))
{
using (SqlCommand command = new SqlCommand(JsonHelper.GetInsertStatement(m), connection))
{
connection.Open();
List lsp = JsonHelper.GetSqlParams(jo["master"]);
foreach (SqlParameter sqp in lsp)
command.Parameters.Add(sqp);
Insert = command.CommandText;
}
}
return Insert;
}

3 Replies

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

Amit Gupta7y ago
Check this out
Updated:
public static string GetInsertStatmentText(string JsonData, out SqlParameterCollection sqps)
        {
            string Insert = "";
            JObject jo = JObject.Parse(JsonData);
            JToken m = jo["master"];
            sqps=null;
            string connectionstring = "Server=AHMEDSALAH-PC\\SQL2014;Database=Atum;User Id=sa;Password=abc123;"; //change connection string
            using (SqlConnection connection = new SqlConnection(connectionstring))
            {
                using (SqlCommand command = new SqlCommand(JsonHelper.GetInsertStatement(m), connection))
                {
                    connection.Open();
                    List lsp = JsonHelper.GetSqlParams(jo["master"]);
                    foreach (SqlParameter sqp in lsp)
                        command.Parameters.Add(sqp);
                    Insert = command.CommandText;

                 sqps=command.Parameters;
                }
            }
            return Insert;

        }
+1
ahmed elbarbary7y ago
this is give me error
sqps=command.Parameter.ToArray();
0
Amit Gupta7y ago
You haven't declared the class (yellow highlighted) and avoid using the same variable name, the error is you must assign value to parameter sqp before leaving the function
public static string GetInsertStatmentText(string JsonData,out  sqp)
        {
            string Insert = "";
            JObject jo = JObject.Parse(JsonData);
            JToken m = jo["master"];
            string connectionstring = "Server=AHMEDSALAH-PC\\SQL2014;Database=Atum;User Id=sa;Password=abc123;"; //change connection string
            using (SqlConnection connection = new SqlConnection(connectionstring))
            {
                using (SqlCommand command = new SqlCommand(JsonHelper.GetInsertStatement(m), connection))
                {
                    connection.Open();
                    List lsp = JsonHelper.GetSqlParams(jo["master"]);
                    foreach (SqlParameter sqp in lsp)
                        command.Parameters.Add(sqp);
                    Insert = command.CommandText;
                }
            }
            return Insert;

        }
Doing so will remove your issue.
I think you want to achieve the following
public static string GetInsertStatmentText(string JsonData,out SqlParameter[] sqps)
        {
            string Insert = "";
            JObject jo = JObject.Parse(JsonData);
            JToken m = jo["master"];
            sqps=null;
            string connectionstring = "Server=AHMEDSALAH-PC\\SQL2014;Database=Atum;User Id=sa;Password=abc123;"; //change connection string
            using (SqlConnection connection = new SqlConnection(connectionstring))
            {
                using (SqlCommand command = new SqlCommand(JsonHelper.GetInsertStatement(m), connection))
                {
                    connection.Open();
                    List lsp = JsonHelper.GetSqlParams(jo["master"]);
                    foreach (SqlParameter sqp in lsp)
                        command.Parameters.Add(sqp);
                    Insert = command.CommandText;

                 sqps=command.Parameter.ToArray();
                }
            }
            return Insert;

        }
I am not with my system right now, rectify if any syntax error. Hope you got the point

Good Luck!
0