Data type miss match

Question

0.00/5 (No votes)

See more:

my code is :

C#

int a = Convert.ToInt32(textBox1.Text);
            int b = Convert.ToInt32(textBox2.Text);
            try
            {
                //String typ = "1BHK";
                string str = "select propno,owner,address,phoneno,price,status,dimension,type from property where price between '" + a + "' and '" + b + "'";
                OleDbDataAdapter DAap = new OleDbDataAdapter(str, connString);
                DataSet DS = new DataSet();
                DAap.Fill(DS, "Property");
                DataTable DT = DS.Tables[0];
                dataGridView1.DataSource = DT;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString(), "Real Estate...       ", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }

it showing error as datatype missmatch in criteria expression in database price is a number type.

Posted 5-Oct-13 2:23am

Raghavendra M

Updated 5-Oct-13 2:57am

ridoy

v3

Add a Solution

5 solutions

Solution 2

Shouldn't it be like this?

string str = "select propno,owner,address,phoneno,price,status,dimension,type from property where price between " + a + " and " + b;

P.S.: It's recommended to use Store Procedures instead of forming c# string queries. They are exposed to SQL Injection.

Posted 5-Oct-13 2:36am

Manas Bhardwaj

Comments

Raghavendra M 5-Oct-13 8:57am

i am using MSAccess database

Raghavendra M 5-Oct-13 8:59am

It is showing error as ;expected .

Solution 3

Try this,

//Make sure both have numeric value
string a = Convert.ToString(textBox1.Text);
string b = Convert.ToString(textBox2.Text);
try
{
    //String typ = "1BHK";
    string str = "select propno,owner,address,phoneno,price,status,dimension,type from property where price between " + a + " and " + b ;

    OleDbDataAdapter DAap = new OleDbDataAdapter(str, connString);
    DataSet DS = new DataSet();
    DAap.Fill(DS, "Property");
    DataTable DT = DS.Tables[0];
    dataGridView1.DataSource = DT;
}
catch (Exception ex)
{
    MessageBox.Show(ex.Message.ToString(), "Real Estate...       ", MessageBoxButtons.OK, MessageBoxIcon.Error);
}

Posted 5-Oct-13 3:12am

Padam Agrawal

Solution 4

What is the datatype of price ?

Please check if it is same as of a and b or vice versa.

Regards.

Posted 5-Oct-13 3:29am

ananta1

Solution 1

Change the coloumn from number data type to int in the Database table

Posted 5-Oct-13 2:32am

Naresh1277

Comments

Raghavendra M 5-Oct-13 9:00am

no i m using MSAccess database , Number is the only type

Naresh1277 5-Oct-13 12:26pm

have you checked on msdn site?

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ranesh M Raj · Accepted Answer · 2013-10-05T05:08:00

Solution 5

C#

string str = "select propno,owner,address,phoneno,price,status,dimension,type from property where price between " + a + " and " + b + " ";

Posted 5-Oct-13 5:08am

Ranesh M Raj

Comments

Raghavendra M 12-Oct-13 10:44am

Thank u . . , i got it . .

Data type miss match

5 solutions

Solution 2

Solution 3

Solution 4

Solution 5

Solution 1

Add your solution here

Preview 0

Data type miss match

5 solutions

Solution 2

Solution 3

Solution 4

Solution 5

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us