Member Avatar for prasri2007

i am using access db plz tell me how to insert data from database. m using visual studio 2010.

  • 4 Contributors
  • 5 Replies
  • 151 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by samacoba
Member Avatar for s_sridhar

It contains the HTML and VB.net code that makes up thepage. It's important to note that the VB.Net code is placed within the page_load event. This just means that every time the page is requested the page_load event is raised or run and the code we've written is executed. The C# equivalent must be similar too...

<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data.Oledb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim Connection As OledbConnection
        Connection = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;" & _
                                     "Data Source=C:\Inetpub\wwwroot\code\Customers.mdb")
        Connection.Open()
        Dim Command As OleDbCommand
        Command = New OleDbCommand("INSERT INTO tblCustomers(FirstName, LastName)" & _
        " VALUES ('Michael', 'Wall')", Connection)
        Command.ExecuteNonQuery()        
        Connection.Close()
               
        Label1.Text="Record Inserted"
    End Sub
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Insert Record into MS Access Database</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:label ID=label1 runat="server" />
    </div>
    </form>
</body>
</html>
Edited by s_sridhar because: n/a
Member Avatar for kvprajapati

i am using access db plz tell me how to insert data from database. m using visual studio 2010.

Firstly, tell us the name of database product you are using. Secondly, learn the ADO.NET class library through this library you can perform any database actions.

Member Avatar for prasri2007

Thanx for your help.
Sir,i have a problem that how i can insert through web application means by using textbox buttons etc.
If you can plz provide me with sample coding.

Member Avatar for samacoba

Try this code,it inserts one parameter(txtName.Text) into table"tblTble",for all paramemters(OleDbProvider uses "?" to represent SQL Prameters)the analogy is the same,also Note this goes under the Button(Insert) click event...Try reading more about the DataAdapter Object from MSDN website...Hope this helps you

string myConstr = "@YourConnectionString;
string InsertQrt ="Insert Into tblTable(Name) Values(?)";
OleDbConnection myConnection = new OleDbConnection(myConstr);
OleDbDataAdapter myAdapter = new OleDbDataAdapter();
myConnection.Open();
myAdapter.InsertCommand = new OleDbCommand(InsertQry, myConnection);
myAdapter.InsertCommand.Parameters.Add(new OleDbParameter("?",txtName.Text));
myConnection.Close();

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.