Invalid column

[Paresh1462]

i got error : Invalid column name 'A1009'.

        chk1 = "select Sno from Student where SID = "+ @smemno.Text.ToString();
        
        SqlCommand ck1 = new SqlCommand(chk1, cn);
        
        v11 = (string)ck1.ExecuteScalar();

what should i do?

[Not Active]

Paresh1462 wrote:

what should i do?

Realize that we are not looking over your shoulder. Give an accurate description of the conditions, your problem, expected outcome and what you have tried. Without knowing your database structure or what it is populated with how can we tell what column A1009 means?

---

I know the language. I've read a book. - _Madmatt

[GenJerDan]

chk1 = "select Sno from Student where SID = '"+ @smemno.Text.ToString()+"'";

will probably fix it, but as Mark said, more details would help tremendously.

There is water at the bottom of the ocean. My Mu[sic] My Films My Windows Programs, etc.

[Pete OHanlon]

For a start, I would look to change your code to mitigate the chance that you will be left wide open to a Sql Injection attack[^]. Secondly, I would look to Dispose of my SqlCommand object. Wrapping it in a nice using statement will do the trick.

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

[Wendelius]

As already pointed out, use parameters: SqlParameter[^]. But if you still for some reason want to use literals in SQL statements, add apostrophes when you're adding texts to the statement:

chk1 = "select Sno from Student where SID = '"+ @smemno.Text.ToString() + "'";

The need to optimize rises from a bad design.My articles[^]