How do I reach a specific column of sqldatareader in C#

Question

I am writing a method which will call a stored procedure. This stored Procedure will return a dataset which contains an attributes. I need to change the value of one particular attribute. My code is something like this.

try
        {               
            cmdPendingStatus.CommandType = CommandType.StoredProcedure;
            SqlDataReader pendingStatusList;
            List<string> lstPendingRequestId = new List<string>();
            try
            {
                conn.Open();
                pendingStatusList = cmdPendingStatus.ExecuteReader();
                if (pendingStatusList.HasRows)
                {
                    while (pendingStatusList.Read())
                    {
                        lstPendingRequestId.Add(pendingStatusList.GetString(0));
                    }

                }
            }

After this point i am stuck. After I add the Sqldatareader to list, Next what I want to do is reach to the element at Row 1 column 4. Please help me. — TARUN SINHA
– TARUN SINHA, Commented Feb 3, 2016 at 6:12

Vic · Accepted Answer · 2016-02-03 06:16:37Z

1

cmdPendingStatus.CommandType=CommandType.StoredProcedure;
SqlDataReader pendingStatusList;
List<string> lstPendingRequestId = new List<string>();

try
{
  conn.Open();
  pendingStatusList = cmdPendingStatus.ExecuteReader();
  if (pendingStatusList.HasRows)
  {
    while (pendingStatusList.Read())
    {
      if(condition here)
      {
        lstPendingRequestId.add("NEW VALUE")
      }
      else
      {
        lstPendingRequestId.Add(pendingStatusList.GetString(0));
      }
    }
  }
}

hope this will help you

answered Feb 3, 2016 at 6:16

Vic

5371 gold badge7 silver badges28 bronze badges

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

Comments

Raki · Accepted Answer · 2016-02-03 06:11:14Z

0

Column name to be specified within pendingStatusList["ColumnName"]

  try
            {
                conn.Open();
                pendingStatusList = cmdPendingStatus.ExecuteReader();
                if (pendingStatusList.HasRows)
                {
                    while (pendingStatusList.Read())
                    {
                        lstPendingRequestId.Add(pendingStatusList["ColumnName"]);
                    }

                }
            }

answered Feb 3, 2016 at 6:11

Raki

5354 silver badges13 bronze badges

7 Comments

TARUN SINHA Over a year ago

No what I need to do is retrieve the whole table in the list and from there on I need to change the specified row column entry and then insert into another table.

Raki Over a year ago

u need to store entire table in an object ? or u need to store as table

Raki Over a year ago

you can use the following code to store into a table DataTable datable1 = new DataTable(); datatable1.Load(cmdPendingStatus.ExecuteReader());

TARUN SINHA Over a year ago

I have another stored procedure to store the values returned by passing the values to the stored procedure one by one in another table.

Raki Over a year ago

Is the result of 1st stored procedure has multiple columns ?

|

Vivek Verma · Accepted Answer · 2016-02-03 06:14:32Z

0

You can't change an attribute in ExecuteReader but you can read a value like this:

var value = Reader[1];

You can always change the value of var and write another stored procedure to save changes if that is what you want to do.

answered Feb 3, 2016 at 6:14

Vivek Verma

3333 silver badges15 bronze badges

Comments

TARUN SINHA · Accepted Answer · 2016-02-09 06:25:56Z

0

try
{
     DataSet dsStatusPending = new DataSet();
     StoredProcedure cmdPendingStatus = new StoredProcedure();
     cmdPendingStatus.ProcName = "sp_Name";
     dsStatusPending = DbManager.ExecuteDataSet(cmdPendingStatus);
     if (dsStatusPending.Tables[0].Rows.Count > 0)
     {
          foreach (DataRow rowToInsert in dsStatusPending.Tables[0].Rows)
          {                  
              if (rowToInsert["ColumnName"] != System.DBNull.Value && rowToInsert["ColumnName"].ToString().ToUpper() == "I")
              {
                   //User Defined Code Goes Here
              }
           }
      }

This is how I got to the specific column.

answered Feb 9, 2016 at 6:25

TARUN SINHA

166 bronze badges

Collectives™ on Stack Overflow

How do I reach a specific column of sqldatareader in C#

4 Answers 4

Comments

7 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

7 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related