how to insert username and password into database with connection in c# please give me reply sir

Here is an example I googled to find out:

<%@ Page Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script language="C#" runat="server">

void Page_Load (Object sender, EventArgs e)

OleDbConnection objConnection = null;
OleDbCommand objCmd = null;
String strConnection, strSQL;

strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
// strConnection += @"Data Source=C:\Northwind.mdb";
strConnection += @"Data Source="+MapPath("EmployeeDatabase.mdb");

// Create and open the connection object
objConnection = new OleDbConnection(strConnection);
objConnection.ConnectionString = strConnection;


// set the SQL string
strSQL = "INSERT INTO Employee (FirstName , LastName ) " +
"VALUES ( 'Beth' , 'Hart' )";

// Create the Command and set its properties
objCmd = new OleDbCommand(strSQL, objConnection);

// execute the command

lblStatus.Text = "Command run";



<h2>Using SQL directly</h2>
<asp:Label id="lblStatus" runat="server"/>

Here is the link to the page where I got the information this website has great tutorials and examples for future reference.


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.