CommandText Property has been not Initialized , Error [duplicate]

Question

I am Getting the error while executing the code, CommandText Property has been not initialized

  public DataTable Mappingdataload(string name)
        {
            try
            {
                string spname = "";
                switch (name.ToLower())
                {
                    case "student":
                        spname = "RetrieveStudent";
                        break;
                    case "organization":
                        spname = "RetrieveOrganization";
                        break;
                }
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = SQLConClass.GetSQLConnection();
                cmd.CommandText = spname;
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(cmd);
                DataTable dataTable = new DataTable();
                sqlDataAdapter.Fill(dataTable);
                return dataTable;
            }
            catch (Exception)
            {
                throw;
            }
        }

If throw; is the only thing you do in a catch you might as well get rid of the whole try/catch. — rene
– rene, Commented Dec 25, 2018 at 10:40

Derviş Kayımbaşıoğlu · Accepted Answer · 2018-12-24 18:27:21Z

0

you are getting this error because command text is not initialized :)

It is always better to first make connection and then create command. check the code below.

var conn = SQLConClass.GetSQLConnection();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = spname;
cmd.CommandType = CommandType.StoredProcedure;

also better to use it like this:

using (var conn = SQLConClass.GetSQLConnection())
using (SqlCommand cmd = conn.CreateCommand())
{ 
     cmd.CommandText = spname;
     cmd.CommandType = CommandType.StoredProcedure;
     using (var reader = cmd.ExecuteReader())
     { 
          ....
     }
}

answered Dec 24, 2018 at 18:27

Derviş Kayımbaşıoğlu

30.9k4 gold badges55 silver badges79 bronze badges

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

Collectives™ on Stack Overflow

CommandText Property has been not Initialized , Error [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related