Inserting Values to Database

[rekhasc]

Front end: Asp.net
Code: C#
Backend:Msaccess

i am doing project on loan, i have to insert the customer values to the database, its showing errors in cmd.executenonquery,


public partial class _Default : System.Web.UI.Page
{
OleDbConnection con;
OleDbCommand cmd;

protected void Page_Load(object sender, EventArgs e)
{
con=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; user id= Admin ; password=; Data Source=D:\\Webloanmonitor\\loan.mdb");

}
protected void Button1_Click(object sender, EventArgs e)
{
int i;
string str;
str = "insert into LoanApplication values('" +txtfullname+ "','" +txtfather+ "','" +txtdob+ "','" +txtage+ "','" +RadioButtonList1+ "','" +txteducation+ "','" +ddlistmartial+ "','" + txtmobile + "','" +txtphone+ "','" +txtemail+ "','" +txtresidential+ "','" +txtpermanent+ "')";
cmd = new OleDbCommand(str,con);
try
{
con.Open();
i = cmd.ExecuteNonQuery();
con.Close();
if (i > 0)
{
Response.Redirect("EmploymentDetails.aspx");
}
}
catch (Exception ex)
{
Response.Write("error" + ex);
}

}
}

this is my code , please help me;
i also tried this
insert into LoanApplication(fullname,father,dob.......)Values( '"+txtfullname+'",...........)

[deric]

What is the error message?
Try to transfer this line: cmd = new OleDbCommand(str,con);
after the line con.Open();

By the way, use CODE tags around your code. Please read the guidelines on the right.. Thanks.

[rekhasc]

hi...
the error is data type mismatch



Please Enter ProperlySystem.Data.OleDb.OleDbException: Data type mismatch in criteria expression. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at _Default.Button1_Click(Object sender, EventArgs e) in d:\Webloanmonitor\Default.aspx.cs:line 32

here i am attaching my proj, this code is in default.aspx.cs

[rekhasc]

hi..
thanx for your reply...
i corrected that error but its showing new errors

ERROR: OVERFLOW at

Please Enter Properly::System.Data.OleDb.OleDbException: Overflow at System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at _Default.Button1_Click(Object sender, EventArgs e) in d:\Webloanmonitor\Default.aspx.cs:line 31

[deric]

It seems that some of the values that you provided in your insert statement exceed the allowable value or range of the datatype of your table's column.

Try to do the following:
1. Step trace your code if the values in the insert statement is correct. You can Response.Write(str); to display the final value of str, which is holding your insert statement.

2. Place the name of the columns on your insert.
Like, "Insert Into Table (column1) Values (value1)".
With this, there will be consistency in your code and it will be easier to debug or maintain.

3. For number values, try to not enclose it with single quotes.
Like, instead of "Insert Into Table (numberColumn) Values ('100')", use "Insert Into Table (numberColumn) Values (100)"


Try that and let me know what happens.