bluechris87
New member
- Joined
- Jul 17, 2016
- Messages
- 3
- Programming Experience
- Beginner
i try to insert from 2 textboxes to my Database but something gets wrong
C#:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OleDb;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
String connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Database1.mdb";
OleDbConnection conn;
public Form1()
{
InitializeComponent();
conn = new OleDbConnection(connectionstring);
}
private void label1_Click(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
try
{
conn.Open();
OleDbCommand cmd1 = conn.CreateCommand();
cmd1.CommandText = "Insert into Table1(user,u_pass) values(?,?)";
OleDbParameter p1 = new OleDbParameter();
OleDbParameter p2 = new OleDbParameter();
cmd1.Parameters.Add(p1);
cmd1.Parameters.Add(p2);
p1.Value = textBox1.Text.ToString();
p2.Value = textBox2.Text.ToString();
OleDbDataReader reader = cmd1.ExecuteReader();
MessageBox.Show("Hello " + textBox1.Text.ToString());
this.Hide();
reader.Close();
conn.Close();
}
catch
{
MessageBox.Show("no result");
}
}
}
}