本文介绍了查询不会从asp.net网站将数据插入数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

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

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");
        }


    }
}

推荐答案


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

09-05 12:38
查看更多