مشکل در ارتباط با پایگاه داده

        SqlConnection con = new SqlConnection();
             con.ConnectionString = @"Data  Source=.\SQLEXPRESS;Attachdbfilename=|DataDirectory|\sdb.mdf; integrated  security=true;user instance=true";
            con.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandText = "INSERT into tbl_ozv(No,Name) values ('" + textBox1.Text + "','" + textBox2.Text+ "' )";
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable dt = new DataTable();
            da.Fill(dt);
            MessageBox.Show("Save");
            con.Close();

   da.Fill(dt);

SqlCommand com = new SqlCommand("insert into kala (kalaname,code,tedad,saloon#,esm,famil,moshtari#,date)"
                        + " values ('" + nametxt.Text + "' , '" + Convert.ToInt32(kalatxt.Text) + "' , '" + Convert.ToInt32(tedadtxt.Text) + "' ,"
                        + "'" + Convert.ToInt32(comboBox1.Text) + "' , '" + esmtxt.Text + "' , '" + familtxt.Text + "' ,"
                        + "'" + Convert.ToInt32(moshtaritxt.Text) + "' , '" + datetxt.Text + "') ", conn);
                        com.Connection.Open();
                        com.ExecuteNonQuery();
                        com.Connection.Close();

 SqlConnection conn = new SqlConnection("server=localhost;database=anbar;integrated security=true");

SqlDataAdapter sda = new SqlDataAdapter("select kalaname'نام كالا',code'کد كالا',tedad'تعداد كالا',saloon#'شماره سالن'"
            + " ,esm'نام مشتري',famil'نام خانوادگی',moshtari#'کد مشتري',date'تاريخ ورود' from kala", conn);
            DataSet ds = new DataSet();
            sda.Fill(ds, "kala");
            DataView dv = new DataView();
            dv.Table = ds.Tables["kala"];
            dataGridView1.DataSource = dv;

  SqlConnection con = new SqlConnection();
            con.ConnectionString = @"Data Source=.\SQLEXPRESS;Attachdbfilename=|DataDirectory|\aharesdb.mdf; integrated security=true;user instance=true";
            con.Open();
            if (textBox1.Text != "")
            {
                SqlCommand cmd = new SqlCommand("insert into member (no,name,f3,f4,f5,f6,f7,f8,date,f9,cap,capa,addC,add,alc)"
                            + " values ('" + textBox1.Text + "' , '" + textBox2.Text + "' , '" + textBox3.Text + "' ,"
                        + "'" + comboBox1.Text + "' , '" + comboBox2.Text + "' , '" +  textBox6.Text + "' ,"
                        + "'" + comboBox3.Text + "' , '" + comboBox4.Text + "' , '" + maskedTextBox1.Text + "' , '" + textBox10.Text + "' , '"
                        + textBox11.Text + "' , '" + textBox12.Text + "' , '" + textBox13.Text + "' , '" 
                        + textBox14.Text + "' , '" + textBox15.Text + "' , '" + textBox4.Text + "') ", con);
                
                cmd.ExecuteNonQuery();
                cmd.Connection.Close();
                MessageBox.Show("با موفقیت ثبت گردید");
            }
            else { MessageBox.Show("لطفا فيلد های ستاره دار را به دقت وارد نماييد"); }

        private void btnAddSave_Click(object sender, EventArgs e)
        {
            String query = "Select * From mytable";
            da = new OleDbDataAdapter(query, con);
            OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
            OleDbCommand cmd = cb.GetInsertCommand();
            con.Open();
            cmd.Parameters[0].Value = txtProNet1Code.Text;
            cmd.Parameters[1].Value = txtname.Text;
            cmd.Parameters[2].Value = txtfamily.Text;
            cmd.ExecuteNonQuery();
            con.Close();
            
        }

[LEFT]using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace SOC
{
    public class ClsDL_User
    {
        public SqlDataAdapter User_da;
        public DataSet User_ds;
        private SqlCommand User_cmd_ins;
        private SqlCommand User_cmd_sel;
        private SqlCommand User_cmd_del;
        private SqlCommand User_cmd_upd;

        public ClsDL_User()
        {
            #region SQL COMMAND & SQL DATA ADAPTER

            User_da = new SqlDataAdapter();
            User_cmd_sel = new SqlCommand();
            User_cmd_ins = new SqlCommand();
            User_cmd_del = new SqlCommand();
            User_cmd_upd = new SqlCommand();

            #endregion

            #region DATASET

            User_ds = new DataSet();
            User_ds.Tables.Add("User");

            #endregion

            #region SELECT PART

            User_cmd_sel.Connection = SQLCon.Con;
            User_cmd_sel.CommandText = "Usr_User_Select";
            User_cmd_sel.CommandType = System.Data.CommandType.StoredProcedure;
            User_cmd_sel.Parameters.Add("@FullList", SqlDbType.Bit, 1);
            User_da.SelectCommand = User_cmd_sel;

            #endregion

            #region INSERT PART

            User_cmd_ins.Connection = SQLCon.Con;
            User_cmd_ins.CommandText = "Usr_User_Insert";
            User_cmd_ins.CommandType = CommandType.StoredProcedure;

            User_cmd_ins.Parameters.Add("@User_Username", SqlDbType.NVarChar, 50, "User_Username");
            User_cmd_ins.Parameters.Add("@User_Password", SqlDbType.NVarChar, 50, "User_Password");
            User_cmd_ins.Parameters.Add("@User_Description", SqlDbType.NVarChar, 300, "User_Description");
            User_cmd_ins.Parameters.Add("@IDF_LookAndFeel", SqlDbType.TinyInt, 1, "IDF_LookAndFeel");
            User_cmd_ins.Parameters.Add("@IDF_Persons", SqlDbType.Decimal, 18, "IDF_Persons");
            User_cmd_ins.Parameters.Add("@User_IsActive", SqlDbType.Bit, 1, "User_IsActive");
            User_cmd_ins.Parameters.Add("@User_IsAdmin", SqlDbType.Bit, 1, "User_IsAdmin");
            User_cmd_ins.Parameters.Add("@IDF_User", SqlDbType.Decimal, 18, "IDF_User");
            User_cmd_ins.Parameters.Add("@SystemIP", SqlDbType.NVarChar, 15, "SystemIP");
            User_cmd_ins.Parameters.Add("@Log_Year", SqlDbType.Int, 4, "Log_Year");
            User_cmd_ins.Parameters.Add("@Log_Mon", SqlDbType.TinyInt, 1, "Log_Mon");
            User_cmd_ins.Parameters.Add("@Log_Day", SqlDbType.TinyInt, 1, "Log_Day");
            User_cmd_ins.Parameters.Add("@Log_Time", SqlDbType.NVarChar, 8, "Log_Time");

            User_da.InsertCommand = User_cmd_ins;
            System.Data.SqlClient.SqlParameter myParm = User_da.InsertCommand.Parameters.Add("@ID_User", SqlDbType.Decimal, 18, "ID_User");
            myParm.Direction = ParameterDirection.Output;

            #endregion

            #region DELETE PART

            User_cmd_del.Connection = SQLCon.Con;
            User_cmd_del.CommandText = "Usr_User_Delete";
            User_cmd_del.CommandType = System.Data.CommandType.StoredProcedure;
            User_cmd_del.Parameters.Add("@ID_User", System.Data.SqlDbType.Decimal, 18, "ID_User");
            User_cmd_del.Parameters.Add("@IDF_User", SqlDbType.Decimal, 18, "IDF_User");
            User_cmd_del.Parameters.Add("@SystemIP", SqlDbType.NVarChar, 15, "SystemIP");
            User_cmd_del.Parameters.Add("@Log_Year", SqlDbType.Int, 4, "Log_Year");
            User_cmd_del.Parameters.Add("@Log_Mon", SqlDbType.TinyInt, 1, "Log_Mon");
            User_cmd_del.Parameters.Add("@Log_Day", SqlDbType.TinyInt, 1, "Log_Day");
            User_cmd_del.Parameters.Add("@Log_Time", SqlDbType.NVarChar, 8, "Log_Time");
            User_da.DeleteCommand = User_cmd_del;

            #endregion

            #region UPDATE PART

            User_cmd_upd.Connection = SQLCon.Con;
            User_cmd_upd.CommandText = "Usr_User_Update";
            User_cmd_upd.CommandType = CommandType.StoredProcedure;

            User_cmd_upd.Parameters.Add("@ID_User", SqlDbType.Decimal, 18, "ID_User");
            User_cmd_upd.Parameters.Add("@User_Username", SqlDbType.NVarChar, 50, "User_Username");
            User_cmd_upd.Parameters.Add("@User_Password", SqlDbType.NVarChar, 50, "User_Password");
            User_cmd_upd.Parameters.Add("@User_Description", SqlDbType.NVarChar, 300, "User_Description");
            User_cmd_upd.Parameters.Add("@IDF_LookAndFeel", SqlDbType.TinyInt, 1, "IDF_LookAndFeel");
            User_cmd_upd.Parameters.Add("@User_IsActive", SqlDbType.Bit, 1, "User_IsActive");
            User_cmd_upd.Parameters.Add("@User_IsAdmin", SqlDbType.Bit, 1, "User_IsAdmin");
            //User_cmd_upd.Parameters.Add("IDF_Persons", SqlDbType.Decimal, 18, "IDF_Persons");
            User_cmd_upd.Parameters.Add("@IDF_User", SqlDbType.Decimal, 18, "IDF_User");
            User_cmd_upd.Parameters.Add("@SystemIP", SqlDbType.NVarChar, 15, "SystemIP");
            User_cmd_upd.Parameters.Add("@Log_Year", SqlDbType.Int, 4, "Log_Year");
            User_cmd_upd.Parameters.Add("@Log_Mon", SqlDbType.TinyInt, 1, "Log_Mon");
            User_cmd_upd.Parameters.Add("@Log_Day", SqlDbType.TinyInt, 1, "Log_Day");
            User_cmd_upd.Parameters.Add("@Log_Time", SqlDbType.NVarChar, 8, "Log_Time");

            User_da.UpdateCommand = User_cmd_upd;

            #endregion


        }

        public void User_Select(bool FullList)
        {
            lock (SQLCon.Con)
            {
                this.User_ds.Tables["User"].Clear();
                this.User_cmd_sel.Parameters["@FullList"].Value = FullList;
                this.User_da.Fill(this.User_ds, "User");
            }
        }


    }
}
[/LEFT]