Member Avatar for alicepriya

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

  • 2 Contributors
  • 1 Reply
  • 110 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by sourceskill
Member Avatar for sourceskill

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;

objConnection.Open();

// 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
objCmd.ExecuteNonQuery();

lblStatus.Text = "Command run";

}

</script>

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

Here is the link to the page where I got the information http://www.java2s.com/Code/ASP/ADO.net-Database/InsertdatatodatabaseusingSQLC.htm this website has great tutorials and examples for future reference.

NPatterson

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.