// dbCmd.Parameters.Add(new SqlParameter("@CusName", data.CusName)); public static void Insert(tbBrandInfo tbBrand) { string q = "insert into [tbBrands]([Name],[Logo],[Ord],[Lang]) values(@Name,@Logo,@Ord,@Lang))"; SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = q; cmd.Connection = GetConnection(); cmd.Parameters.Add(new SqlParameter("@Name", tbBrand.Name)); cmd.Parameters.Add(new SqlParameter("@Logo", tbBrand.Logo)); cmd.Parameters.Add(new SqlParameter("@Ord", tbBrand.Ord)); cmd.Parameters.Add(new SqlParameter("@Lang", tbBrand.Lang)); ExecuteNonQuery(cmd); }
public static void Update(tbBrandInfo tbBrand) { string q = "update [tbBrands] set [Name] = @Name,[Logo] = @Logo,[Ord] = @Ord,[Lang] = @Lang where [Id] = Id "; SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = q; cmd.Connection = GetConnection(); cmd.Parameters.Add(new SqlParameter("@Name", tbBrand.Name)); cmd.Parameters.Add(new SqlParameter("@Logo", tbBrand.Logo)); cmd.Parameters.Add(new SqlParameter("@Ord", tbBrand.Ord)); cmd.Parameters.Add(new SqlParameter("@Lang", tbBrand.Lang)); cmd.Parameters.Add(new SqlParameter("@Id", tbBrand.Id)); ExecuteNonQuery(cmd); }
protected void grvUser_ItemCommand(object source, DataGridCommandEventArgs e) { Id = int.Parse(e.CommandArgument.ToString()); switch (e.CommandName) { case "Edit": DataTable dt = BrandsController.GetByColumn("Id", Id.ToString()); txtName.Text = dt.Rows[0]["Name"].ToString(); txtLogo.Text = dt.Rows[0]["Logo"].ToString(); txtOrd.Text = dt.Rows[0]["Ord"].ToString(); txtLang.Text = dt.Rows[0]["Lang"].ToString(); break; case "Delete": tbBrandInfo obj = new tbBrandInfo(); obj.Id = Id; BrandsController.Delete(obj); _LoadBrand(); break; } }
public static void Delete(tbBrandInfo obj) { string q = "Delete from tbBrands where Id=" + obj.Id; ExecuteNonQuery(q); }
public static DataTable GetBy_Id(tbBrandInfo tbBrand) { string str = "select * from [tbBrands] where [Id]=" + tbBrand.Id; return(GetData(str)); }