Error in Asp.net

ronak chittora

using System.Data.OleDb;

public partial class _Default : System.Web.UI.Page

{

public OleDbConnection oledbcon;

protected void Page_Load(object sender, EventArgs e)

{

String constr;

constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='C:\\Student.mdb'; Persist Security Info=False";

oledbcon = new OleDbConnection(constr);

oledbcon.Open();

}

protected void Button1_Click(object sender, EventArgs e)

{

String sqlstr;

String sname;

String percentage;

String id;

id = TextBox1.Text;

sname = TextBox3.Text;

percentage =TextBox2.Text;

OleDbCommand cmd;

sqlstr = "insert into stud values('id','sname','percentage')";

//sqlstr = "select * from stud";

cmd = new OleDbCommand(sqlstr);

cmd.Connection = oledbcon;

cmd.ExecuteNonQuery();

//cmd.ExecuteReader();

Response.Write("data saved successfully");

}

in ms Acess07

id(P.K.)as number

sname as text

percentage as text

Error::Data type mismatch in criteria expression.(at line cmd.executenonquery())

whether we have to convert string to number?? and if yes then how to do it??

2 Replies

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

Sanjeeb Lenka13y ago
Accepted answer
Hi,
i modified your code try this one.

protected void Button1_Click(object sender, EventArgs e)
    {
String sqlstr;
        String sname;
        String percentage;
        int id;
        id = Convert.ToInt32(TextBox1.Text);
        sname = TextBox3.Text;
        percentage = TextBox2.Text;
        OleDbCommand cmd;
        sqlstr = "insert into stud (id,sname,percentage) values("+id+",'"+sname+"','"+percentage+"')";
        cmd = new OleDbCommand(sqlstr, oledbcon);
        cmd.ExecuteNonQuery();
        Response.Write("data saved successfully");
}
ronak chittora13y ago
IF I WANT TO STORE A IMAGE INTO DB IN MS-ACCESS ONLY THEN...? USING IMAGEUPLOADER
THEN USING SAME CODE WHAT ALL SHOULD BE ADDED SO THaT I CAN DO IT?