eror in this query

selvi subramanian

12y1.4k

my design

style="font-weight: 700; font-style: italic; font-family: Arial, Helvetica, sans-serif">
	AutoPostBack="True">

my code is

protected void TextBox1_TextChanged(object sender, EventArgs e)

{

con = new SqlConnection("Data Source=SELVI-PC\\SQLEXPRESS;Initial Catalog=bramandam;Persist Security Info=True;Integrated Security=True");

string sq = "select min(numbr) from noo where numbr=numbr";

ds = mvl.GETDS(sq);

foreach (DataRow dr in ds.Tables[0].Rows)

{

TextBox2.Text = dr["numbr"].ToString();

}

my error is

Server Error in '/Birmandam' Application.

Column 'numbr' does not belong to table Table.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Column 'numbr' does not belong to table Table.

Source Error:

Line 103:      foreach (DataRow dr in ds.Tables[0].Rows) Line 104:      { Line 105:          TextBox2.Text = dr["numbr"].ToString(); Line 106:      } Line 107:   }

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhabani Prasad12y ago
1-string sq = "select min(numbr) from noo where numbr=numbr"; 2-TextBox2.Text = dr["numbr"].ToString(); In point 1 U use numbr as column name but in point u use numbr as table name so error due to the above case so try to put correct table name here below dr["numbr"].ToString();
Jignesh Trivedi12y ago
hi,
try with the code
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
con = new SqlConnection("Data Source=SELVI-PC\\SQLEXPRESS;Initial Catalog=bramandam;Persist Security Info=True;Integrated Security=True");
string sq = "select min(numbr) as numbr from noo where numbr=numbr";
ds = mvl.GETDS(sq);
foreach (DataRow dr in ds.Tables[0].Rows)
{
TextBox2.Text = dr["numbr"].ToString();
}
}
hope this will help you.
Anupam Singh12y ago
according to query {select min(numbr) from noo where numbr=numbr } , there must be a numbr column in table noo. but your table noo doesnt have any numbr column.