C# DAL.Connection类代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› c#›C#教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中DAL.Connection类的典型用法代码示例。如果您正苦于以下问题：C# Connection类的具体用法？C# Connection怎么用？C# Connection使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

Connection类属于DAL命名空间，在下文中一共展示了Connection类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: createProjectTable

        public void createProjectTable(string tablename)
        {
            Connection cs = new Connection();
            SqlConnection con = cs.CreateConnection();

            try
            {
                String quary = "CREATE TABLE " + tablename +
                            "("
                            + "username varchar(255),"
                            + "name varchar(255),"
                            + "assaignedwork varchar(255),"
                            + "duedate varchar(255))";

                SqlCommand cmd = new SqlCommand(quary, con);
                cmd.ExecuteNonQuery();
                MessageBox.Show("Table Created");
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            con.Close();
        }

开发者ID:，项目名称:，代码行数:25，代码来源:

示例2: showResult

        public string[,] showResult(string tablename)
        {
            Connection cs = new Connection();
            SqlConnection con = cs.CreateConnection();
            String[,] info = new String[100,5];
            try
            {

                String quary = "select * from "+tablename+"";
                SqlCommand cmd = new SqlCommand(quary, con);
                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    for (int i = 0; reader.Read();i++ )
                    {
                        info[i,0] = reader["username"].ToString();
                        info[i,1] = reader["name"].ToString();
                        info[i,2] = reader["assaignedwork"].ToString();
                        info[i,3] = reader["duedate"].ToString();
                        info[i,4] = reader["status"].ToString();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            con.Close();

            return info;
        }

开发者ID:，项目名称:，代码行数:31，代码来源:

示例3: showingData

        public string[] showingData(string username,int flag)
        {
            Connection cs = new Connection();
            SqlConnection con = cs.CreateConnection();
            string query = "Select * from tbl_profile where name like '%" + username + "%'";
            SqlCommand com = new SqlCommand(query, con);

            SqlDataReader reader = com.ExecuteReader();
            for (int i = 1; reader.Read(); i++)
            {
                name[i] = reader[1].ToString();
                uname[i] = reader[0].ToString();
            }
            reader.Close();
            con.Close();
            if (flag == 1)
            {
                return name;
            }

            else
            {
                return uname;
            }
        }

开发者ID:，项目名称:，代码行数:25，代码来源:

示例4: projectInfo

        public string[] projectInfo(string projectName)
        {
            Connection cs = new Connection();
            SqlConnection con = cs.CreateConnection();
            String[] info=new String[8];
            try
            {

                String quary = "select * from tbl_project where project='" + projectName + "'";
                SqlCommand cmd = new SqlCommand(quary, con);
                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    reader.Read();
                    for (int i = 0; i < 8; i++)
                    {
                        info[i] = reader[i].ToString();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            con.Close();

            return info;
        }

开发者ID:，项目名称:，代码行数:28，代码来源:

示例5: InsertTyLeTinh

 //==============Insert========================
 public int InsertTyLeTinh(Entities.TyLeTinh input)
 {
     int bg = 0;
     try
     {
         con = new Connection();
         cn = con.openConnection();
         cmd = new SqlCommand("exec sp_TyLeTinh @ThaoTac,@MaTyLeTinh,@SoTien,@NgayNhap,@GhiChu,@Deleted", cn);
         cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "insert";
         //set
         cmd.Parameters.Add("MaTyLeTinh", SqlDbType.VarChar).Value = input.MaTyLeTinh;
         cmd.Parameters.Add("SoTien", SqlDbType.Float).Value = input.SoTien;
         cmd.Parameters.Add("NgayNhap", SqlDbType.DateTime).Value = input.NgayNhap;
         cmd.Parameters.Add("GhiChu", SqlDbType.NVarChar).Value = input.GhiChu;
         cmd.Parameters.Add("Deleted", SqlDbType.Bit).Value = input.Deleted;
         bg = cmd.ExecuteNonQuery();
     }
     catch (Exception)
     {
         bg = 0;
     }
     finally
     {
         cmd.Connection.Dispose();
         cn.Close();
         con.closeConnection();
     }
     if (bg == 0)
         return bg;
     return bg;
 }

开发者ID:mrk29vn，项目名称:vna-accounting，代码行数:32，代码来源:TyLeTinh.cs

示例6: Insert

        /// <summary>
        /// Insert
        /// </summary>
        /// <param name="item"></param>
        /// <returns></returns>
        public int Insert(Entities.KhuyenMaiSoLuong item)
        {
            int rt = 0;
            try
            {
                conn = new Connection();
                SqlConnection cn = conn.openConnection();
                string sql = "exec sp_InsertKMSL @Id,@MaHangHoa,@TenHangHoa,@NgayBatDau,@NgayKetThuc,@SoLuong,@GiaBanBuon,@GiaBanLe";
                SqlCommand cmd = new SqlCommand(sql, cn);
                cmd.Parameters.Add("Id", SqlDbType.Int).Value = 0;
                cmd.Parameters.Add("MaHangHoa", SqlDbType.VarChar, 50).Value = item.MaHangHoa;
                cmd.Parameters.Add("TenHangHoa", SqlDbType.NVarChar, 200).Value = item.TenHangHoa;
                cmd.Parameters.Add("NgayBatDau", SqlDbType.DateTime).Value = item.NgayBatDau;
                cmd.Parameters.Add("NgayKetThuc", SqlDbType.DateTime).Value = item.NgayKetThuc;
                cmd.Parameters.Add("SoLuong", SqlDbType.Float).Value = item.SoLuong;
                cmd.Parameters.Add("GiaBanBuon", SqlDbType.Float).Value = item.GiaBanBuon;
                cmd.Parameters.Add("GiaBanLe", SqlDbType.Float).Value = item.GiaBanLe;
                rt = cmd.ExecuteNonQuery();
            }
            catch
            {
                rt = 0;
            }

            return rt;
        }

开发者ID:mrk29vn，项目名称:vna-accounting，代码行数:31，代码来源:KhuyenMaiSoLuong.cs

示例7: projectDisplay

        public string[] projectDisplay(string username)
        {
            Connection cs = new Connection();
            SqlConnection con = cs.CreateConnection();
            int counter=0;
            String[] info=new String[10];
            try
            {

                //1st Person
                String quary = "select * from tbl_project where people1username='" + username + "'";
                SqlCommand cmd = new SqlCommand(quary, con);
                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        info[counter++] = reader["project"].ToString();

                    }
                }

                //2nd person
                quary = "select * from tbl_project where people2username='" + username + "'";
                cmd = new SqlCommand(quary, con);
                using (SqlDataReader reader1 = cmd.ExecuteReader())
                {
                    while (reader1.Read())
                    {
                        info[counter++] = reader1["project"].ToString();
                    }
                }

                //3rd person
                quary = "select * from tbl_project where people3username='" + username + "'";
                cmd = new SqlCommand(quary, con);
                using (SqlDataReader reader2 = cmd.ExecuteReader())
                {
                    while (reader2.Read())
                    {
                        info[counter++] = reader2["project"].ToString();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            con.Close();

               return info;
        }

开发者ID:，项目名称:，代码行数:52，代码来源:

示例8: SelectTheoDieuKien_GiaVon

 //==============Select========================
 /// <summary>
 /// SelectTheoDieuKien_GiaVon:
 /// - Select_GIAVON
 /// - Insert_GIAVON
 /// - Update_TheoMaKhoVaMaHangHoa_GIAVON
 /// - Delete_TheoMaKhoVaMaHangHoa_GIAVON
 /// </summary>
 /// <param name="thaotac"></param>
 /// <param name="set"></param>
 /// <param name="filter"></param>
 /// <returns></returns>
 public Entities.GiaVon[] SelectTheoDieuKien_GiaVon(string thaotac, Entities.GiaVon set, Entities.GiaVon filter)
 {
     Entities.GiaVon[] list = null;
     try
     {
         con = new Connection();
         cn = con.openConnection();
         cmd = new SqlCommand("exec sp_GiaVon @ThaoTac,@MaKho,@MaHangHoa,@SoLuong,@Gia,@MaKhok,@MaHangHoak,@SoLuongk,@Giak", cn);
         cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = thaotac;
         //set
         cmd.Parameters.Add("MaKho", SqlDbType.NVarChar).Value = set.MaKho;
         cmd.Parameters.Add("MaHangHoa", SqlDbType.NVarChar).Value = set.MaHangHoa;
         cmd.Parameters.Add("SoLuong", SqlDbType.NVarChar).Value = set.SoLuong;
         cmd.Parameters.Add("Gia", SqlDbType.NVarChar).Value = set.Gia;
         //filter
         cmd.Parameters.Add("MaKhok", SqlDbType.NVarChar).Value = filter.MaKho;
         cmd.Parameters.Add("MaHangHoak", SqlDbType.NVarChar).Value = filter.MaHangHoa;
         cmd.Parameters.Add("SoLuongk", SqlDbType.NVarChar).Value = filter.SoLuong;
         cmd.Parameters.Add("Giak", SqlDbType.NVarChar).Value = filter.Gia;
         dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
         arr = new ArrayList();
         while (dr.Read())
         {
             int sl;
             float g;
             Entities.GiaVon row = new Entities.GiaVon
                                       {
                                           MaKho = dr["MaKho"].ToString(),
                                           MaHangHoa = dr["MaHangHoa"].ToString(),
                                           SoLuong = int.TryParse(dr["SoLuong"].ToString(), out sl) ? sl : 0,
                                           Gia = float.TryParse(dr["Gia"].ToString(), out g) ? g : 0
                                       };
             arr.Add(row);
         }
         int n = arr.Count;
         if (n == 0) list = null;
         list = new Entities.GiaVon[n];
         for (int i = 0; i < n; i++)
         {
             list[i] = (Entities.GiaVon)arr[i];
         }
     }
     catch (Exception ex)
     { string s = ex.Message.ToString(); list = null; }
     finally
     {
         cmd.Connection.Dispose();
         cn.Close();
         con.closeConnection();
     }
     return list;
 }

开发者ID:mrk29vn，项目名称:vna-accounting，代码行数:64，代码来源:GiaVon.cs

示例9: SelectDiemThuongKhachHang

 //==============Select========================
 public Entities.DiemThuongKhachHang[] SelectDiemThuongKhachHang(Entities.DiemThuongKhachHang input)
 {
     Entities.DiemThuongKhachHang[] list = null;
     try
     {
         con = new Connection();
         cn = con.openConnection();
         cmd = new SqlCommand("exec sp_DiemThuongKhachHang @ThaoTac,@MaDiemThuongKhachHang,@MaKhachHang,@TenKhachHang,@TongDiem,@DiemDaDung,@DiemConLai,@GhiChu,@Deleted", cn);
         cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = input.ThaoTac;
         //set
         cmd.Parameters.Add("MaDiemThuongKhachHang", SqlDbType.VarChar).Value = input.MaDiemThuongKhachHang;
         cmd.Parameters.Add("MaKhachHang", SqlDbType.VarChar).Value = input.MaKhachHang;
         cmd.Parameters.Add("TenKhachHang", SqlDbType.NVarChar).Value = input.TenKhachHang;
         cmd.Parameters.Add("TongDiem", SqlDbType.Int).Value = input.TongDiem;
         cmd.Parameters.Add("DiemDaDung", SqlDbType.Int).Value = input.DiemDaDung;
         cmd.Parameters.Add("DiemConLai", SqlDbType.Int).Value = input.DiemConLai;
         cmd.Parameters.Add("GhiChu", SqlDbType.NVarChar).Value = input.GhiChu;
         cmd.Parameters.Add("Deleted", SqlDbType.Bit).Value = input.Deleted;
         dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
         arr = new ArrayList();
         while (dr.Read())
         {
             Entities.DiemThuongKhachHang row = new Entities.DiemThuongKhachHang();
             row.MaDiemThuongKhachHang = dr["MaDiemThuongKhachHang"].ToString();
             row.MaKhachHang = dr["MaKhachHang"].ToString();
             row.TenKhachHang = dr["TenKhachHang"].ToString();
             row.TongDiem = int.Parse(dr["TongDiem"].ToString());
             row.DiemDaDung = int.Parse(dr["DiemDaDung"].ToString());
             row.DiemConLai = int.Parse(dr["DiemConLai"].ToString());
             row.GhiChu = dr["GhiChu"].ToString();
             row.Deleted = bool.Parse(dr["Deleted"].ToString());
             arr.Add(row);
         }
         int n = arr.Count;
         if (n == 0) list = null;
         list = new Entities.DiemThuongKhachHang[n];
         for (int i = 0; i < n; i++)
         {
             list[i] = (Entities.DiemThuongKhachHang)arr[i];
         }
     }
     catch (Exception ex)
     { string s = ex.Message.ToString(); list = null; }
     finally
     {
         cmd.Connection.Dispose();
         cn.Close();
         con.closeConnection();
     }
     return list;
 }

开发者ID:mrk29vn，项目名称:vna-accounting，代码行数:52，代码来源:DiemThuongKhachHang.cs

示例10: SelectChiTietTheGiamGia

 //==============Select========================
 public Entities.ChiTietTheGiamGia[] SelectChiTietTheGiamGia(Entities.ChiTietTheGiamGia input)
 {
     Entities.ChiTietTheGiamGia[] list = null;
     try
     {
         con = new Connection();
         cn = con.openConnection();
         cmd = new SqlCommand("exec sp_ChiTietTheGiamGia @ThaoTac,@MaTheGiamGia,@MaKhachHang,@TenKhachHang,@GiaTriThe,@NgayThu,@MaPhieuThu,@Deleted", cn);
         cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = input.ThaoTac;
         //set
         cmd.Parameters.Add("MaTheGiamGia", SqlDbType.VarChar).Value = input.MaTheGiamGia;
         cmd.Parameters.Add("MaKhachHang", SqlDbType.VarChar).Value = input.MaKhachHang;
         cmd.Parameters.Add("TenKhachHang", SqlDbType.NVarChar).Value = input.TenKhachHang;
         cmd.Parameters.Add("GiaTriThe", SqlDbType.Float).Value = input.GiaTriThe;
         cmd.Parameters.Add("NgayThu", SqlDbType.DateTime).Value = input.NgayThu;
         cmd.Parameters.Add("MaPhieuThu", SqlDbType.VarChar).Value = input.MaPhieuThu;
         cmd.Parameters.Add("Deleted", SqlDbType.Bit).Value = input.Deleted;
         dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
         arr = new ArrayList();
         while (dr.Read())
         {
             Entities.ChiTietTheGiamGia row = new Entities.ChiTietTheGiamGia();
             row.MaTheGiamGia = dr["MaTheGiamGia"].ToString();
             row.MaKhachHang = dr["MaKhachHang"].ToString();
             row.TenKhachHang = dr["TenKhachHang"].ToString();
             row.GiaTriThe = float.Parse(dr["GiaTriThe"].ToString());
             row.NgayThu = DateTime.Parse(dr["NgayThu"].ToString());
             row.MaPhieuThu = dr["MaPhieuThu"].ToString();
             row.Deleted = bool.Parse(dr["Deleted"].ToString());
             arr.Add(row);
         }
         int n = arr.Count;
         if (n == 0) list = null;
         list = new Entities.ChiTietTheGiamGia[n];
         for (int i = 0; i < n; i++)
         {
             list[i] = (Entities.ChiTietTheGiamGia)arr[i];
         }
     }
     catch (Exception ex)
     { string s = ex.Message.ToString(); list = null; }
     finally
     {
         cmd.Connection.Dispose();
         cn.Close();
         con.closeConnection();
     }
     return list;
 }

开发者ID:mrk29vn，项目名称:vna-accounting，代码行数:50，代码来源:ChiTietTheGiamGia.cs

示例11: noOfList

        public int noOfList(string tablename)
        {
            Connection cs = new Connection();
            SqlConnection con = cs.CreateConnection();

            int rows = 0;

            String query = "select * from " + tablename + "";
            SqlCommand cmd = new SqlCommand(query, con);
            SqlDataReader reader = cmd.ExecuteReader();
            DataTable dt = new DataTable();
            dt.Load(reader);
            rows = dt.Rows.Count;

            return rows;
        }

开发者ID:，项目名称:，代码行数:16，代码来源:

示例12: SelectTyLeTinh

 //==============Select========================
 public Entities.TyLeTinh[] SelectTyLeTinh()
 {
     Entities.TyLeTinh[] list = null;
     try
     {
         con = new Connection();
         cn = con.openConnection();
         cmd = new SqlCommand("exec sp_TyLeTinh @ThaoTac,@MaTyLeTinh,@SoTien,@NgayNhap,@GhiChu,@Deleted", cn);
         cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "select";
         Entities.TyLeTinh input = new Entities.TyLeTinh();
         //set
         cmd.Parameters.Add("MaTyLeTinh", SqlDbType.VarChar).Value = input.MaTyLeTinh;
         cmd.Parameters.Add("SoTien", SqlDbType.Float).Value = input.SoTien;
         cmd.Parameters.Add("NgayNhap", SqlDbType.DateTime).Value = input.NgayNhap;
         cmd.Parameters.Add("GhiChu", SqlDbType.NVarChar).Value = input.GhiChu;
         cmd.Parameters.Add("Deleted", SqlDbType.Bit).Value = input.Deleted;
         dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
         arr = new ArrayList();
         while (dr.Read())
         {
             Entities.TyLeTinh row = new Entities.TyLeTinh();
             row.MaTyLeTinh = dr["MaTyLeTinh"].ToString();
             row.SoTien = double.Parse(dr["SoTien"].ToString());
             row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString());
             row.GhiChu = dr["GhiChu"].ToString();
             row.Deleted = bool.Parse(dr["Deleted"].ToString());
             arr.Add(row);
         }
         int n = arr.Count;
         if (n == 0) list = null;
         list = new Entities.TyLeTinh[n];
         for (int i = 0; i < n; i++)
         {
             list[i] = (Entities.TyLeTinh)arr[i];
         }
     }
     catch (Exception ex)
     { string s = ex.Message.ToString(); list = null; }
     finally
     {
         cmd.Connection.Dispose();
         cn.Close();
         con.closeConnection();
     }
     return list;
 }

开发者ID:mrk29vn，项目名称:vna-accounting，代码行数:47，代码来源:TyLeTinh.cs

示例13: getInfo

        public string[] getInfo(string projectname)
        {
            Connection cs = new Connection();
            SqlConnection con = cs.CreateConnection();
            String[] info=new String[8];
            String quary;
            SqlCommand com;

            try
            {

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

开发者ID:，项目名称:，代码行数:17，代码来源:

示例14: Delete

        /// <summary>
        /// Delete
        /// </summary>
        /// <param name="item"></param>
        /// <returns></returns>
        public int Delete(Entities.KhuyenMaiSoLuong item)
        {
            int rt = 0;
            try
            {
                conn = new Connection();
                SqlConnection cn = conn.openConnection();
                string sql = "exec sp_DeleteKMSL @MaHangHoa";
                SqlCommand cmd = new SqlCommand(sql, cn);
                cmd.Parameters.Add("MaHangHoa", SqlDbType.VarChar, 50).Value = item.MaHangHoa;
                rt = cmd.ExecuteNonQuery();
            }
            catch
            {
                rt = 0;
            }

            return rt;
        }

开发者ID:mrk29vn，项目名称:vna-accounting，代码行数:24，代码来源:KhuyenMaiSoLuong.cs

示例15: editPassword

        public void editPassword(string username, string password)
        {
            Connection cs = new Connection();
            SqlConnection con = cs.CreateConnection();

            try
            {
                String query = "UPDATE tbl_authenticate SET password='" + password +  "'where username='" + username + "'";

                SqlCommand cmd = new SqlCommand(query, con);
                cmd.ExecuteNonQuery();

                con.Close();
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

开发者ID:，项目名称:，代码行数:20，代码来源:

示例16: updateProject

        public void updateProject(string name, string description, string user1, string name1, string user2, string name2, string user3, string name3, string projectname)
        {
            Connection cs = new Connection();
            SqlConnection con = cs.CreateConnection();

            try
            {
                String query = "UPDATE tbl_project SET project='" + name + "',projectdescription='" + description + "',people1username='" + user1 + "',people1name='" + name1 + "',people2username='" + user2 + "',people2name='" + name2 + "',people3username='" + user3 + "',people3name='" + name3 + "'where project='" + projectname + "'";

                SqlCommand cmd = new SqlCommand(query, con);
                cmd.ExecuteNonQuery();

               // MessageBox.Show(name+" "+description+" "+user1+" "+name1+" "+user2+" "+name2+" "+user3+" "+name3+" Edited!!!!");
                con.Close();
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

开发者ID:，项目名称:，代码行数:21，代码来源:

示例17: LoginConnection

        public Boolean LoginConnection(string userName, string password)
        {
            Connection cs = new Connection();
            SqlConnection con = cs.CreateConnection();

            int rows = 0;
            string uName = userName;
            string pass = password;

            String query = "select * from tbl_authenticate where username='" + uName + "' and password='" + pass + "'";
            SqlCommand cmd = new SqlCommand(query, con);
            SqlDataReader reader = cmd.ExecuteReader();
            DataTable dt = new DataTable();
            dt.Load(reader);
            rows = dt.Rows.Count;

            if (rows > 0)
                return true;
            else
                return false;
        }

开发者ID:，项目名称:，代码行数:21，代码来源:

示例18: editInfo

        public string editInfo(string username, string name,  string designation, string email, string phoneno, string address,string dob,string gender)
        {
            Connection cs = new Connection();
            SqlConnection con = cs.CreateConnection();

            try
            {
                String query = "UPDATE tbl_profile SET name='" + name + "',username='" + username + "',designation='" + designation + "',email='" + email + "',phoneno='" + phoneno + "',address='" + address + "',dateofbirth='" + dob + "',gender='" + gender + "'where username='" + username + "'";

                SqlCommand cmd = new SqlCommand(query, con);
                cmd.ExecuteNonQuery();

                con.Close();
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            return username;
        }

开发者ID:，项目名称:，代码行数:21，代码来源:

示例19: updateTable

        public void updateTable(string oldname, string newname)
        {
            Connection cs = new Connection();
            SqlConnection con = cs.CreateConnection();

            //try
            //{
            String query = "sp_rename '" + oldname +
                    "','" + newname + "'";

                SqlCommand cmd = new SqlCommand(query, con);
                cmd.ExecuteNonQuery();

                MessageBox.Show(oldname + " "+" Edited");
                con.Close();
            //}

            //catch (Exception ex)
            //{
                //MessageBox.Show(ex.Message);
            //}
        }

开发者ID:，项目名称:，代码行数:22，代码来源:

示例20: addToDo

        public void addToDo(string username, string name, string todo, string date, string table)
        {
            Connection cs = new Connection();
            SqlConnection con = cs.CreateConnection();

            try
            {

                String query = "INSERT INTO "+table+" VALUES('" + username + "','" + name + "','" + todo + "','" + date + "','" + "false" +  "')";

                SqlCommand cmd = new SqlCommand(query, con);
                cmd.ExecuteNonQuery();
                MessageBox.Show("Assaigned Work Added!!!");
                con.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            con.Close();
        }

开发者ID:，项目名称:，代码行数:22，代码来源:

注：本文中的DAL.Connection类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# DAL.DALConexao类代码示例发布时间：2022-05-24

C# DAL.ConexionDb类代码示例发布时间：2022-05-24

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：19133|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9973|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8317|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8686|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8627|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9643|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8611|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7991|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8642|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7527|2022-11-06

客服电话

电子邮件

C# DAL.Connection类代码示例

示例1: createProjectTable

示例2: showResult

示例3: showingData

示例4: projectInfo

示例5: InsertTyLeTinh

示例6: Insert

示例7: projectDisplay

示例8: SelectTheoDieuKien_GiaVon

示例9: SelectDiemThuongKhachHang

示例10: SelectChiTietTheGiamGia

示例11: noOfList

示例12: SelectTyLeTinh

示例13: getInfo

示例14: Delete

示例15: editPassword

示例16: updateProject

示例17: LoginConnection

示例18: editInfo

示例19: updateTable

示例20: addToDo

请发表评论

全部评论

上一篇：

下一篇：

solegalli/feature-selection-for-machine-

nauzethc/ghost-material: Material Design

sussillo/hfopt-matlab: A parallel, cpu-b

win7系统重装系统初始设置的操作方法

Stericson/RootTools: RootTools Library

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053