Invalid Column Error

Hi,

  Krishna, check with DB table , might be you have different name for AccountNo coloumn bcz in your code there is some minor changes only which is i have done ,rest your code works fine,
 
            string sqlconn = "Data Source=.\\SQLEXPRESS;Initial Catalog=bank;Integrated Security=True";
  SqlConnection conn = new SqlConnection(sqlconn);
  try
  {
  SqlDataReader dr;
  conn.Open();

  string commandtext = "SELECT AccountNo,Balance FROM Bank_Account1";
  SqlCommand cmd = new SqlCommand(commandtext, conn);

  dr = cmd.ExecuteReader();
  while (dr.Read())
  {
  MessageBox.Show(dr[0].ToString());
  MessageBox.Show(dr[1].ToString());
  }
  dr.Close();
  }
  catch (Exception ex)
  {
  MessageBox.Show(ex.Message.ToString());
  }
  finally
  {
  conn.Close();
  }