اضافه ، حذف ، ویرایش

**NIIT** · 5th November 2011 10:02 PM

برنامه ای در مورد ویرایش ، حذف و ویرایش یک لیست بکار میره

این در مورد کدهای مربوط به database

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Data.SqlClient;



namespace WindowsFormsApplication1

{

    class database

    {

        SqlConnection objconnection = new SqlConnection("");//@"Data Source=.\SQLEXPRESS;AttachDbFilename=G:\mabani\c#\khodam\base\WindowsFormsApplication1\WindowsFormsApplication1\student.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"

        SqlCommand objcommand = new SqlCommand();

        public void add(string TableName, string values)

        {

            objcommand.CommandText = "insert into " + TableName + " values(" + values + ")";//

            objcommand.Connection = objconnection;

            objconnection.Open();

            objcommand.ExecuteNonQuery();

            objconnection.Close();

        }

        public void delete(string TableName, long values)

        {

            objcommand.CommandText = "DELETE FROM " + TableName + " WHERE code=" + values;

            objcommand.Connection = objconnection;

            objconnection.Open();

            objcommand.ExecuteNonQuery();

            objconnection.Close();

        }

        public void edit(string TableName, string values,long where)

        {

            objconnection.Open();

            objcommand.Connection = objconnection;

            objcommand.CommandText = " update " + TableName + " set " + values + "where" + where;

            objcommand.ExecuteNonQuery();

            objconnection.Close();

        }

    }

}

فراخونی :

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 WindowsFormsApplication1

{

    

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void but_add_Click(object sender, EventArgs e)

        {

            database data = new database();

            data.add("Table1", (textBox1.Text +textBox2 .Text + "',N'" + textBox4.Text + "',N'" + textBox3.Text));

        }



        private void but_delete_Click(object sender, EventArgs e)

        {

            database data = new database();

            data.delete("Table1", long.Parse(textBox3.Text));

        }



        private void but_edit_Click(object sender, EventArgs e)

        {

            database data = new database();

            data.edit("Table1", textBox1.Text + "',N'" + textBox4.Text , long.Parse(textBox2.Text));

        }



        private void but_show_Click(object sender, EventArgs e)

        {

           /* objconnection.Open();

            objcommand.Connection = objconnection;

            objcommand.CommandText = "select * from table1";

            objcommand.ExecuteNonQuery();

            da = new SqlDataAdapter(objcommand);

            dt = new DataTable();

            da.Fill(dt);

            objconnection.Close();

            dataGridView1.DataSource=dt;*/

        }



        private void Form1_Load(object sender, EventArgs e)

        {



        }       

    }

}