查询不会从asp.net网站将数据插入数据库 [英] Query doesnt insert data into database from asp.net website

问题描述

这是我的代码。任何人都可以说是什么错误？

Here is my code.Can anyone say what is the error??

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.OleDb;



namespace gasbooking
{
    public partial class WebForm1 : System.Web.UI.Page
    {
             protected void Page_Load(object sender, EventArgs e)
        {
           
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            try
            {

                OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Arunkumar\Documents\Visual Studio 2012\Projects\reg.accdb");
                
                ClientScript.RegisterStartupScript(GetType(), "alert", "alert('connection opened')", true);
                 OleDbCommand cmd = new OleDbCommand("insert into userdetails values(@Distributor,@LPG_ID,@Username,@E-Mail ID,@Password,@MBL_NO,@AadharNO,@Address,@PINCODE)",con  );
                cmd.Parameters.AddWithValue("Distributor",DropDownList2.SelectedValue );
                cmd.Parameters.AddWithValue("LPG_ID",TextBox1 .Text );
                cmd.Parameters.AddWithValue("UserName",TextBox2 .Text );
                cmd.Parameters.AddWithValue("E-Mail ID",TextBox3 .Text );
                cmd.Parameters.AddWithValue("Password",TextBox8 .Text );
                cmd.Parameters.AddWithValue("MBL_NO",TextBox4 .Text );
                cmd.Parameters.AddWithValue("AadharNO",TextBox5 .Text );
                cmd.Parameters.AddWithValue("Address",TextBox6 .Text);
                cmd.Parameters.AddWithValue("PINCODE",TextBox7 .Text );
                int i =cmd.ExecuteNonQuery();

                if (i > 0)
                {
                    ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Registered successfully')", true);
                }
                else
                {
                    ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Data Not Inserted')", true);
                }
                
                Response.Redirect("login.aspx");
            }
            catch (Exception ex)
            {
                ex.ToString();
            }
            
                  }
        protected void Button2_Click(object sender, EventArgs e)
        {
            Page.Response.Redirect(Page.Request.Url.ToString(), true);
        }

        protected void Button3_Click(object sender, EventArgs e)
        {
            Response.Redirect("Login.aspx");
        }

       
    }
}

推荐答案

我怀疑它是名称电子邮件ID 。



我猜你使用的是OleDb和ACE引擎你正在使用Access。你需要小心参数。



0）OleDb并不真正使用参数名称，所以你不能不按顺序使用这些参数。 br />
1）您可能需要列出列名;并非所有RDBM都允许您将其删除。

I suspect it's the name E-Mail ID.

I'm guessing by your use of OleDb and the ACE engine that you're using Access. You need to be careful with parameters with those.

0) OleDb doesn't really use parameter names, so you can't use the parameters out of order.
1) You may need to list the column names; not all RDBMs allow you to leave it out.

这篇关于查询不会从asp.net网站将数据插入数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！