Inserting text box data in access database

Dear friends'

Thank's to Satyapriya Nayak & Mindcracker Network who have got special interest in my question.
but it's my apology i should mentioned more detail about my question.Now i am repeating with more detail.

I can't inserting text box data in access database in asp.net in visual studio.net. at vb.net plate form.What coding behind the Button1 to insert data in data base on Default.aspx at design tab.

Waiting for you kind reply.

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm5.aspx.cs" Inherits="Gridview.WebForm5" %>

    Untitled Page



using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;
namespace Gridview
{
    public partial class WebForm5 : System.Web.UI.Page
    {
        OleDbConnection con;
        OleDbCommand com;
        string str;

        protected void Button1_Click(object sender, EventArgs e)
        {
            con = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = c:\\mydb.mdb");
            con.Open();
            str = "insert into emp values('" + TextBox1.Text + "')";
            com = new OleDbCommand(str, con);
            com.ExecuteNonQuery();
            con.Close();
            Response.Write("Inserted");

        }
    }
}

1 Reply

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

Satyapriya Nayak13y ago
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm5.aspx.cs" Inherits="Gridview.WebForm5" %>

    Untitled Page












using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;
namespace Gridview
{
    public partial class WebForm5 : System.Web.UI.Page
    {
        OleDbConnection con;
        OleDbCommand com;
        string str;

        protected void Button1_Click(object sender, EventArgs e)
        {
            con = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = c:\\mydb.mdb");
            con.Open();
            str = "insert into emp values('" + TextBox1.Text + "')";
            com = new OleDbCommand(str, con);
            com.ExecuteNonQuery();
            con.Close();
            Response.Write("Inserted");

        }
    }
}