Invalid Column Error

Question

I am a beginner of ADO.net. When i try to retrieve a column data by giving a condition an exception is raised saying that the AccountNo is invalid.Could u please help me out. My table name is Bank_Account1 with three columns
AccountNo-int type with IsIncrement-true
Name-varchar(20)
Age-int
Balance-float
The code is Uploaded in a zip file

Thank You

Soft Corner · Answer

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 AccountNoBalance 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(); }

krishna · Answer

Hi Srikant Thankx a lot!!! :).it is working.i have given space in the column name in the table definition.

krishna · Answer

Hi Arshad Thankx a lot!!! :).it is working

Arshad · Answer

Hi You are using the cmd.ExecuteNonQuery(); with datareader you should use the cmd.ExecuteReader();. Regards Arshad.