tag:blogger.com,1999:blog-46602882042226911412024-02-06T18:40:29.663-08:00vinCshapvinC#http://www.blogger.com/profile/16945371078538999564noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4660288204222691141.post-1959577845309609002011-10-07T11:42:00.000-07:002011-10-07T11:42:29.994-07:00SQL Server(2005) With Data Add, Delete, Update and GridView<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEif6uanFcDV34ZcwZ47EMvZHItaRmhiWI6rsqzBePpewP6Kkp7ug59w1TjTovoTepmfMBRnrcwNjnHEBXwMi1DzMpe8XDjw59afc5Kx0-1n3ZydkhcxzK3feZqWx1Vv4QkAPARzXGrAi4__/s1600/DataBase.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="101" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEif6uanFcDV34ZcwZ47EMvZHItaRmhiWI6rsqzBePpewP6Kkp7ug59w1TjTovoTepmfMBRnrcwNjnHEBXwMi1DzMpe8XDjw59afc5Kx0-1n3ZydkhcxzK3feZqWx1Vv4QkAPARzXGrAi4__/s320/DataBase.JPG" width="320" /></a></div><span style="color: #0c343d; font-size: small;"><u><b>Form1.cs</b></u></span><br />
<br />
using System;<br />
using System.Data;<br />
using System.Windows.Forms;<br />
<br />
namespace GridView<br />
{<br />
public partial class GridView : Form<br />
{<br />
Form1DataHandler callForm1DataHandler = new Form1DataHandler();<br />
public GridView()<br />
{<br />
InitializeComponent();<br />
}<br />
<br />
private void btnAdd_Click(object sender, EventArgs e)<br />
{<br />
string id = txbID.Text;<br />
string name = txbName.Text;<br />
string contact = txbContact.Text;<br />
string department = txbDepartment.Text;<br />
callForm1DataHandler.AddData(id, name, contact, department);<br />
ClearText();<br />
}<br />
<br />
private void btnView_Click(object sender, EventArgs e)<br />
{<br />
DataSet dataset = new DataSet();<br />
dataGridView1.Refresh();<br />
dataset = callForm1DataHandler.BindData();<br />
dataGridView1.DataSource = dataset.Tables[0];<br />
}<br />
<br />
private void btnUpdate_Click(object sender, EventArgs e)<br />
{<br />
string id = txbID.Text;<br />
string name = txbName.Text;<br />
string contact = txbContact.Text;<br />
string department = txbDepartment.Text;<br />
callForm1DataHandler.UpDate(id, name, contact, department);<br />
ClearText();<br />
}<br />
private void ClearText()<br />
{<br />
txbContact.Clear();<br />
txbDepartment.Clear();<br />
txbID.Clear();<br />
txbName.Clear();<br />
}<br />
<br />
private void txbID_KeyUp(object sender, KeyEventArgs e)<br />
{<br />
<br />
if (e.KeyValue == 13) // ENTER KET EVENT CAPTURING<br />
{<br />
string id = txbID.Text;<br />
DataSet fillText = new DataSet();<br />
fillText = callForm1DataHandler.CheckText(id);<br />
if (fillText != null)<br />
{ <br />
txbName.Text = fillText.Tables[0].Rows[0][1].ToString();<br />
txbContact.Text = fillText.Tables[0].Rows[0][2].ToString(); <br />
txbDepartment.Text = fillText.Tables[0].Rows[0][3].ToString();<br />
}<br />
}<br />
}<br />
<br />
private void btnDelet_Click(object sender, EventArgs e)<br />
{<br />
string id = txbID.Text;<br />
callForm1DataHandler.Delet(id);<br />
ClearText();<br />
}<br />
}<br />
}<br />
<br />
<br />
<br />
<span style="color: #274e13; font-size: small;"><u><b>Form1DataHandler.cs</b></u></span><br />
<br />
<br />
using System.Data;<br />
<br />
namespace GridView<br />
{<br />
class Form1DataHandler : DataBaseHandler<br />
{<br />
public void AddData(string id,string name,string contact,string department)<br />
{ <br />
string quary="INSERT INTO client VALUES('"+id+"','"+name+"','"+contact+"','"+department+"')";<br />
ExecuteQuary(quary); <br />
}<br />
<br />
public DataSet BindData()<br />
{<br />
string quary1 = "SELECT * FROM client";<br />
DataSet bindDataSet = new DataSet();<br />
bindDataSet = GetData(quary1);<br />
return bindDataSet;<br />
}<br />
<br />
public void UpDate(string id, string name, string contact, string department)<br />
{<br />
string quary = "UPDATE client SET NAME='" + name + "',CONTACT='" + contact + "',DEPARTMENT='" + department + "' WHERE ID='"+id+"'";<br />
ExecuteQuary(quary); <br />
}<br />
<br />
public void Delet(string id)<br />
{<br />
string quary = "DELETE FROM vin WHERE ID='" + id + "'";<br />
ExecuteQuary(quary); <br />
}<br />
<br />
public DataSet CheckText(string id)<br />
{ <br />
string quary2 = "SELECT * FROM client WHERE ID='"+id+"'";<br />
DataSet checkData = new DataSet();<br />
checkData = GetData(quary2);<br />
return checkData;<br />
}<br />
}<br />
}<br />
<br />
<br />
<br />
<span style="color: #274e13; font-size: small;"><u><b>DataBaseHandler.cs</b></u></span><br />
<br />
<br />
using System;<br />
using System.Data;<br />
using System.Data.SqlClient;<br />
<br />
namespace GridView<br />
{<br />
class DataBaseHandler<br />
{<br />
SqlConnection connection = new SqlConnection("Data Source =VINDANA-PC; database=vin; User =sa;Password=vinx");<br />
SqlCommand command = null;<br />
SqlDataAdapter adapter = null;<br />
public void ExecuteQuary(string quary)<br />
{<br />
try<br />
{<br />
if (connection.State == ConnectionState.Closed)<br />
{<br />
connection.Open();<br />
command = new SqlCommand();<br />
}<br />
command.CommandText = quary;<br />
command.Connection = connection;<br />
command.ExecuteNonQuery();<br />
connection.Close();<br />
}<br />
catch (Exception)<br />
{<br />
<br />
}<br />
}<br />
public DataSet GetData(string quary)<br />
{<br />
if (connection.State == ConnectionState.Closed)<br />
{<br />
connection.Open();<br />
adapter = new SqlDataAdapter(quary, connection);<br />
}<br />
DataSet getDataSet = new DataSet();<br />
adapter.Fill(getDataSet);<br />
connection.Close();<br />
return getDataSet;<br />
}<br />
}<br />
}vinC#http://www.blogger.com/profile/16945371078538999564noreply@blogger.com5tag:blogger.com,1999:blog-4660288204222691141.post-24466258859861184812011-10-05T09:00:00.000-07:002011-10-05T09:00:44.993-07:00UPDATE DROP DOWNusing System;<br />
using System.Collections.Generic;<br />
using System.Linq;<br />
using System.Text;<br />
using System.Data;<br />
using System.Data.SqlClient;<br />
<br />
namespace UpdateDropDown<br />
{<br />
class Employee<br />
{<br />
<br />
SqlConnection sqlcon = null;<br />
SqlDataAdapter Adptr = null;<br />
<br />
public Employee() {<br />
<br />
}<br />
<br />
private void connectDB() {<br />
string constr = "Data Source=VINDANA-PC;Initial Catalog=W3School;Persist Security Info=True;User ID=sa;Password=saranga";<br />
sqlcon = new SqlConnection(constr);<br />
sqlcon.Open();<br />
}<br />
<br />
public DataTable updateDropDown() {<br />
<br />
connectDB();<br />
Adptr = new SqlDataAdapter("SELECT Emp_Id,Emp_Name FROM Employee", sqlcon);<br />
DataSet ds = new DataSet();<br />
DataTable dt = new DataTable();<br />
Adptr.Fill(dt);<br />
sqlcon.Close();<br />
<br />
return dt;<br />
<br />
}<br />
<br />
public DataTable display(int id) {<br />
connectDB();<br />
<br />
Adptr = new SqlDataAdapter("SELECT * FROM Employee where Emp_Id= '" + id + " ' ", sqlcon);<br />
DataSet ds = new DataSet();<br />
DataTable dt = new DataTable();<br />
Adptr.Fill(dt);<br />
sqlcon.Close();<br />
<br />
return dt;<br />
}<br />
<br />
}<br />
}<br />
<br />
<br />
<br />
using System;<br />
using System.Collections.Generic;<br />
using System.Linq;<br />
using System.Text;<br />
using System.Data.SqlClient;<br />
using System.Data;<br />
<br />
namespace UpdateDropDown<br />
{<br />
class Department<br />
{<br />
<br />
SqlConnection sqlcon = null;<br />
SqlDataAdapter Adptr = null;<br />
<br />
public Department() {<br />
<br />
}<br />
<br />
<br />
private void connectDB()<br />
{<br />
string constr = "Data Source=.;Initial Catalog=W3School;Persist Security Info=True;User ID=sa;Password=saranga";<br />
sqlcon = new SqlConnection(constr);<br />
sqlcon.Open();<br />
}<br />
<br />
public DataTable depData(int id) {<br />
connectDB();<br />
Adptr = new SqlDataAdapter("SELECT * FROM Department where Dep_Id= '" + id + " ' ", sqlcon);<br />
DataSet ds = new DataSet();<br />
DataTable dt = new DataTable();<br />
Adptr.Fill(dt);<br />
sqlcon.Close();<br />
<br />
return dt;<br />
}<br />
<br />
}<br />
}<br />
<br />
<br />
<br />
using System;<br />
using System.Collections.Generic;<br />
using System.ComponentModel;<br />
using System.Data;<br />
using System.Drawing;<br />
using System.Linq;<br />
using System.Text;<br />
using System.Windows.Forms;<br />
using System.Data.SqlClient;<br />
<br />
namespace UpdateDropDown<br />
{<br />
public partial class Form1 : Form<br />
{<br />
<br />
int ID;<br />
string str;<br />
public Form1()<br />
{<br />
InitializeComponent();<br />
<br />
loadComboBox();<br />
<br />
<br />
}<br />
<br />
public void loadComboBox()<br />
{<br />
Employee emp = new Employee();<br />
DataTable dt = emp.updateDropDown();<br />
comboBox1.DataSource = dt;<br />
comboBox1.DisplayMember = "Emp_Id";<br />
comboBox1.ValueMember = "Emp_Id";<br />
<br />
<br />
}<br />
<br />
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)<br />
{<br />
<br />
}<br />
<br />
private void btnsubmit_Click(object sender, EventArgs e)<br />
{<br />
Employee em = new Employee();<br />
ID = Int16.Parse(comboBox1.SelectedValue.ToString());<br />
<br />
//MessageBox.Show(ID.ToString());<br />
DataTable dt = em.display(ID);<br />
<br />
txtName.Text = dt.Rows[0].ItemArray.GetValue(1).ToString();<br />
txtAge.Text = dt.Rows[0].ItemArray.GetValue(2).ToString();<br />
txtDepId.Text = dt.Rows[0].ItemArray.GetValue(3).ToString();<br />
int depid = Int16.Parse(txtDepId.Text);<br />
//MessageBox.Show(depid.ToString());<br />
Department dep = new Department();<br />
DataTable dt2 = dep.depData(depid);<br />
txtDepName.Text = dt2.Rows[0].ItemArray.GetValue(1).ToString();<br />
<br />
}<br />
<br />
private void Form1_Load(object sender, EventArgs e)<br />
{<br />
<br />
}<br />
<br />
}<br />
}vinC#http://www.blogger.com/profile/16945371078538999564noreply@blogger.com0