Textbox don't show numeric datas only character one...

Hi!

I have these code and when I make filter its show me data in my textbox (only character one. Not numeric one). How can I resolv it please?

This is the structure of my database:

Name Data Type

First_name Varchar(30)

Code numeric(18,0)

{

string connectionString = @"Data Source=localhost\sqlexpress;Initial Catalog=master;Integrated Security=True";

SqlConnection sqlCon = new SqlConnection(connectionString);

sqlCon.Open();

string commandString = "select first_name, code from company where code='" + codesearch.Text + "'";

SqlCommand sqlCmd = new SqlCommand(commandString, sqlCon);

SqlDataReader read = sqlCmd.ExecuteReader();

while (read.Read())

{

showfirstname.Text = read["first_name"].ToString();// Here it's right

showcode.Text = read["code"].ToString();// The problem it's here

}

sqlCon.Close();

}

3 Replies

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

Anupam Singh12y ago
Accepted answer
Your code looks fine. do you have any null values in Code column?
if yes the it might be cause of it.

else you should try debugging..
Vulpes12y ago
As Code is a numeric column, it shouldn't be enclosed in sinqle quotes in the where clause of your select query. So, try instead:

string commandString = "select first_name, code from company where code = " + codesearch.Text;
Ranjit Powar12y ago
What is the error?