Alias Name and Datatable in C#RSS

• • Reply
  Asp.net king

  Member

  15 Points

  146 Posts

  Alias Name and Datatable in C#

  Dec 22, 2016 11:35 PM|Asp.net king|LINK

  i use the following stored procedure in SQL :

  select sum(credit) as x from table1 as CC 
  inner join table2 as C on C.CID=CC.CID
  where CC.EN='123' and CC.Sem='20171'

  I create a data table in visual studio and i got this error : Column 'x' does not belong to table .

      public DataTable GetL(string EN,string Sem)
      {
          SqlDataAdapter da = new SqlDataAdapter("getload", conn);
          da.SelectCommand.CommandType = CommandType.StoredProcedure;
          da.SelectCommand.Parameters.AddWithValue("@EN", EN);
          da.SelectCommand.Parameters.AddWithValue("@Sem", Sem);
          DataTable dt = new DataTable();
          da.Fill(dt);
          return dt;
  
      }

   DataTable DC = DA.GetL(sem.Text, Convert.ToString(Session["EN"]));
   Label2.Text = DT.Rows[0]["x"].ToString();

  the problem is the alias name x, the data table and SQL query is running well. Any help ?

  “First, solve the problem. Then, write the code.”
  (John Johnson)
• • Reply
  Zhi Lv - MSF...

  All-Star

  45431 Points

  7008 Posts

  Microsoft

  Re: Alias Name and Datatable in C#

  Dec 23, 2016 05:45 AM|Zhi Lv - MSFT|LINK

  Hi asp.net King,

  asp.net King

  Column 'x' does not belong to table .

  You can debug the columns property in datatable to find out what the column name is.

  For example:

  This is my store procedure:

  SELECT SUM(UnitPrice) as x from [Order Details] as cc
  inner join Orders as c on c.OrderID=cc.OrderID
  where CC.ProductID=@ProductID
  
  

  The GetL() and Page_Load():

  public DataTable GetL() 
          {
              int id = 11;
              SqlDataAdapter da = new SqlDataAdapter("OrderDetail", ConfigurationManager.ConnectionStrings["NorthwindConnectionString1"].ConnectionString);
              da.SelectCommand.CommandType = CommandType.StoredProcedure;
              da.SelectCommand.Parameters.AddWithValue("@ProductID", id);
              DataTable dt = new DataTable();
              da.Fill(dt);
              return dt;
  }
  
  protected void Page_Load(object sender, EventArgs e)
          {
              if (!IsPostBack)
              {
                  DataTable dt = GetL();                
                  var a = dt.Rows[0]["x"].ToString();
                  var b = dt.Columns;
                  GridView1.DataSource = dt;
                  GridView1.DataBind();
              }
  }
  

  When I debug the Columns the result is:

  

  You can see the column’s name is displayed

  Best regards,
  Dillion

   

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.