using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.Odbc;
namespace Username
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
}
private void textBox3_TextChanged(object sender, EventArgs e)
{
}
private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" && textBox2.Text == "" && textBox3.Text == "")
MessageBox.Show("Plz Specify the UserName & Password","ERROR",MessageBoxButtons.OKCancel,MessageBoxIcon.Error);
else if (textBox2.Text == "" && textBox3.Text == "")
MessageBox.Show("Plz Specify the Password", "ERROR", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
else if (textBox3.Text == "")
MessageBox.Show("Plz RE Enter the Password", "ERROR", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
else
{
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Samples\\login.mdb";
String uname, pass;
uname = textBox1.Text;
//System.Windows.Forms.MessageBox.Show(uname);
pass = textBox2.Text;
OleDbConnection myConnection = new OleDbConnection(connectionString);
myConnection.Open();
int i=107;
string query = "insert into EMPLOYEE_TABLE (ID,UserName,Password) VALUES (118,@uname,@pass)";
//string query = "insert into LOGIN_TABLE (ID,UserName,Password) VALUES (i,'uname',' pass')";
i++;
OleDbCommand myCommand = new OleDbCommand();
myCommand.CommandText = query;
myCommand.Connection = myConnection;
myCommand.ExecuteNonQuery();
myConnection.Close();
System.Windows.Forms.MessageBox.Show("User Account Succefully Created", "Caption", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
}
}
}
}
views:
47answers:
1
+2
A:
You're almost there, but you need to fill the parameters that you created in your query:
OleDbCommand myCommand = new OleDbCommand();
myCommand.CommandText = query;
//TODO: Review the datatypes and lengths for these parameters
OleDbParameter myParm = myCommand.Parameters.Add("@uname", OleDbType.VarChar, 50);
myParm.Value = textBox1.Text;
myParm = myCommand.Parameters.Add("@pass", OleDbType.VarChar, 50);
myParm.Value = textBox2.Text;
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
See this MSDN article for more information about command parameters.
Prutswonder
2010-07-30 11:50:28
hello thanks for u r answer but when i copy this code i get an error as ExecuteNonQuery:Connection property has not been initialized what is the actual problem there?
santhosh s samaka
2010-07-31 05:33:31
You're right, the sample didn't include opening the connection. Now it does. :-)
Prutswonder
2010-08-01 10:17:58