C# Connectivity with MySql Server..
for Note's and Assignment call and Message : 9810301034 and email on g9_sharma@yahoo.com
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApplication2
{
public partial class WelcomeForm : Form
{
SqlConnection
cnn;
SqlCommand
cmd;
SqlDataReader
dr;
public
WelcomeForm()
{
InitializeComponent();
cnn = new
SqlConnection("Data
Source=CORE2DUO-PC; initial catalog=storeKeeping; Integrated
security=SSPI");
}
private
void button1_Click(object
sender, EventArgs e)
{
if
(cnn.State != ConnectionState.Open)
cnn.Open();
cmd = new
SqlCommand("insert
into Users values('" + textBox1.Text + "','"+
textBox2.Text + "','"+comboBox1.Text+"')", cnn);
int
v=cmd.ExecuteNonQuery();
if
(v != 0)
MessageBox.Show("User Created...");
else
MessageBox.Show("Alreay Exist...");
if
(cnn.State != ConnectionState.Closed)
cnn.Close();
}
private
void WelcomeForm_Load(object
sender, EventArgs e)
{
// TODO:
This line of code loads data into the 'storeKeepingDataSet.Users' table. You
can move, or remove it, as needed.
this.usersTableAdapter.Fill(this.storeKeepingDataSet.Users);
}
private
void tabPage2_Click(object
sender, EventArgs e)
{
}
private
void button2_Click(object
sender, EventArgs e)
{
if
(cnn.State != ConnectionState.Open)
cnn.Open();
cmd = new
SqlCommand("delete
from Users where UName='"+comboBox3.Text.Trim()+"'", cnn);
int
v=cmd.ExecuteNonQuery();
if
(v!=0)
MessageBox.Show("Account Deleted...");
else
MessageBox.Show("Account is Not EXIST...");
if
(cnn.State != ConnectionState.Closed)
cnn.Close();
}
private
void comboBox3_SelectedIndexChanged(object sender, EventArgs
e)
{
}
private
void button3_Click(object
sender, EventArgs e)
{
if
(cnn.State != ConnectionState.Open)
cnn.Open();
cmd = new
SqlCommand("select
UName from Users", cnn);
dr = cmd.ExecuteReader();
comboBox3.Items.Clear();
while
(dr.HasRows)
{
if
(dr.Read())
comboBox3.Items.Add(dr.GetValue(0).ToString());
else
break;
}
comboBox3.Text =
comboBox3.Items[0].ToString();
if
(cnn.State != ConnectionState.Closed)
cnn.Close();
dr.Close();
}
private
void button5_Click(object
sender, EventArgs e)
{
comboBox5.Text = "...User Name...";
textBox4.Text = "";
comboBox2.Text = "User";
}
private
void button6_Click(object
sender, EventArgs e)
{
Application.Exit();
}
private
void button7_Click(object
sender, EventArgs e)
{
Application.Exit();
}
private
void button8_Click(object
sender, EventArgs e)
{
comboBox3.Text = "...User Name...";
}
private
void button4_Click(object
sender, EventArgs e)
{
if
(cnn.State != ConnectionState.Open)
cnn.Open();
cmd = new
SqlCommand("UPDATE
Users set UPassword='" + textBox4.Text +
"',
Grade = '" +comboBox2.Text +
"'
where UName= '"+ comboBox5.Text +"'",
cnn);
int
v = cmd.ExecuteNonQuery();
if (v != 0)
MessageBox.Show("User Edit...");
else
MessageBox.Show("Not Edit...");
if
(cnn.State != ConnectionState.Closed)
cnn.Close();
}
private
void button10_Click(object
sender, EventArgs e)
{
textBox1.Text = "";
textBox2.Text = "";
comboBox1.Text = "User";
}
private
void button11_Click(object
sender, EventArgs e)
{
}
private
void label4_Click(object
sender, EventArgs e)
{
}
private
void button12_Click(object
sender, EventArgs e)
{
if
(cnn.State != ConnectionState.Open)
cnn.Open();
cmd = new
SqlCommand("select
UName from Users", cnn);
if(dr!=null)
if
(dr.IsClosed == false)
dr.Close();
dr = cmd.ExecuteReader();
comboBox5.Items.Clear();
while
(dr.HasRows)
{
if
(dr.Read())
comboBox5.Items.Add(dr.GetValue(0).ToString());
else
break;
}
comboBox5.Text =
comboBox5.Items[0].ToString();
if
(cnn.State != ConnectionState.Closed)
cnn.Close();
dr.Close();
}
private
void button13_Click(object
sender, EventArgs e)
{
Application.Exit();
}
private
void comboBox5_SelectedIndexChanged(object sender, EventArgs
e)
{
if
(cnn.State != ConnectionState.Open)
cnn.Open();
cmd = new
SqlCommand("select
* from Users where UName='"+comboBox5.Text+"'",
cnn);
if
(dr != null)
if
(dr.IsClosed == false)
dr.Close();
dr = cmd.ExecuteReader();
if
(dr.HasRows)
{
if
(dr.Read())
{
textBox4.Text =
dr.GetValue(1).ToString();
comboBox2.Text =
dr.GetValue(2).ToString();
}
}
if
(cnn.State != ConnectionState.Closed)
cnn.Close();
dr.Close();
}
private
void textBox5_TextChanged(object sender, EventArgs
e)
{
}
private
void label9_Click(object
sender, EventArgs e)
{
}
private
void tabPage4_Click(object
sender, EventArgs e)
{
}
private void
button11_Click_1(object sender, EventArgs e)
{
if
(cnn.State != ConnectionState.Open)
cnn.Open();
SqlDataAdapter
da=new SqlDataAdapter("Select * from Users",cnn);
DataSet
ds = new DataSet();
da.Fill(ds, "Users");
dataGridView2.DataSource = ds;
dataGridView2.DataMember =
ds.Tables[0].ToString();
if
(cnn.State != ConnectionState.Closed)
cnn.Close();
}
private void
tabPage3_Click(object sender, EventArgs e)
{
}
}
}
for Note's and Assignment call and Message : 9810301034 and email on g9_sharma@yahoo.com
for Note's and Assignment call and Message : 9810301034 and email on g9_sharma@yahoo.com
Comments