[afridi2129]

hi... i want to read typename column from database... but it gives an error of data type miss match...

in database TID is number , and typename is text...prgram should read the textbox1's value and then search for that TID in database ..and according to that tid will read typename... this is the relation..

whenever i try to read a number it happens specially in autonumbers if any one have any tutorial then plz paste a link... thanx....

 private void button1_Click_1(object sender, EventArgs e)
		{
			OleDbConnection conn = new OleDbConnection("Provider=Microsoft.jet.OLEDB.4.0;Data source=data.mdb");

			try
			{
				conn.Open();
			}
			catch (OleDbException ex)
			{
				Console.WriteLine("ERROR: {0}", ex.Message);
			}

			string str = "select TypeName from CandieType where TID='" + textBox1.Text + "'";

			OleDbCommand command = new OleDbCommand(str, conn);
			OleDbDataReader reader = command.ExecuteReader();

			while (reader.Read())
			{

				textBox3.Text = reader["TypeName"].ToString();

			}
			reader.Close();

			try
			{
				conn.Close();
			}
			catch (OleDbException ex)
			{
				Console.WriteLine("ERROR: {0}", ex.Message);
			}
		}

[dklingman]

it's because you are searching TID as a string value

TID='2' is a string

make is so that it is

TID=2 NOTICE NO QUOTES


that's why you're getting data type mismatch error because it's a string instead of a number

This post has been edited by dklingman: 16 January 2009 - 07:03 AM

[afridi2129]

thanx for reply but still error...
i tried this as u said..

string str = "select TypeName from CandieType where TID= " + texbox1.Text + "'";

but error
Syntax error in string in query expression 'TID= 2''.

then i tried to convert like this

string str = "select TypeName from CandieType where TID= " + Convert.ToInt64(textBox1.Text) + "'";

but still same Syntax error in string in query expression 'TID= 2''.

[dklingman]

look at your code you still have a single quote at the end of the sql statement

[afridi2129]

ooopsssssss...sorry Sir...

it works...thanxxxxx alot...

[dklingman]

not a problem and any time

[Jayman]

Modified title to be more descriptive of the problem.