本文介绍了查询不会从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网站将数据插入数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!