manhthaodn

My database with the following table: ITDetail Table: [Click Here](http://i.imgur.com/WcwRI.jpg) InvTrans Table: [Click Here](http://i.imgur.com/hPnlz.jpg) Currency Table: [Click Here](http://i.imgur.com/YUNxC.jpg) Database Relationship: [Click Here](http://i.imgur.com/CTCdo.jpg) I need to build a report with the time parameter (use the procedure; [Click Here](http://i.imgur.com/PwVYX.jpg)) with the following requirements: 1. MaterialID, Art, Color, Width is taken from the …

Hi all, To perform the delete data from Product table by ProductID of Adventure Works database needs to use delete cascade. Has anyone done this yet? Can provide for me examples to do it? Thanks a lot!

Hi, I want to create a procedure to delete Production.Product table by ProductID in AdvetureWorks Database. How to do it? Because Table Product's too many relationship :( THANKS!

Hi, I have load data method as follows: public List<SalesOrderHeader> Load_SaleOrderRelatedInfo() { try { using (var context = new AdventureWorksEntities()) { return context.SalesOrderHeaders.Include("SalesOrderDetails").OrderBy(so => so.SalesOrderNumber).ToList(); } } catch (Exception ex) { throw ex; } } and method for data binding: public static DataTable Binding_SaleOrderInfoRelated() { using (var services = new …

My project using the Entity Framework (Linq to Entities). In DTO layer, I use POCO Entity. I used Eager Loading to load data (Include Method) as follows: public IList<Order> Get_OrderWithOrderDetails(int orderID) { using (var db = new NorthwindEntities()) { db.ContextOptions.LazyLoadingEnabled = false; var query = from o in db.Orders.Include("Customer").Include("Order_Details") where …

For the purpose of synchronizing data in sql server, such as: **1. Synchronize data between servers and client 2. When loss of internet, the client can still work based on the data required to run on the client. 3. When have the internet connection, data from workstations to be synchronized …

Hi, I have voidmain() function in Program.cs [STAThread] static void Main(string[] args) { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); frmMain main = new frmMain(); MainTool.frmmain = main; if (args != null && args.Length > 0) { Application.Run(new frmMain(args[0].ToString())); } else { Application.Run(main); } } In that: MainTool.frmmain = main; Assign frmmain variable of MainTool …

I'm having an error: ***object reference not set to an instance of an object*** in my project. This is file open method (is Excel file) public void OpenFile(string strPath) { try { InitPOList(MainTool.GetPOList(MainTool.ReadDataFile(strPath))); EnableButtons_2(); //Tool.SaveSetting("LastFile", ofdFileToOpen.FileName); } catch (Exception e) { MessageBox.Show(e.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } Such a constructor …

How to open excel file with the program when the user selected program to open excel? I have a software to process data in excel file (*.xls, *.xlsx). My software loaded excel file to process by selecting the path to excel file. For convenience than I intend to add choices …

I am implementing programs for the purpose of processing data from excel file. When package to install my program (use visual studio setup project). I am having a problem as follows. 1. How do you install the program, the program's icon is added to context menu (Eg: when I right …

Below is my code to convert from decimal to binary: [CODE]#include "stdafx.h" typedef struct tamNode { int Into; struct tamNode *Next; }Node; typedef struct { Node *Head; Node *Tail; }List; void createList(List &l) { l.Head = NULL; l.Tail = NULL; } Node* createNode(int x) { Node *p; p = new …

I'm having problems with the progress bar in my project :( [U]Introduction[/U]: I made a small program to send notice via email to each member in a list (Excel file - sequential reading user name of account in excel file will be made ​​by the program)and the attached file corresponding …

For the purpose of control and improvement program. I need to catch the Exception. I don't know what to do below: 1. Control exception what set in the program and send notice to the developer (via Email) Best Regards!

I'm building a C # application on Visual.NET. Now, After packing program to deployment. When users use the program, if have internet connection, the program will automatically send mail notification to me. To do that I do like? Thanks!

Here is the link to download my database with sample data (Management Inventory): [url]http://www.mediafire.com/?9o5ycrqot2risa8[/url] I am making a query to access redundant or missing quatity of material. [B]Report[/B] MatId CusMatName TDK NTK XTK ... . . . . . . . . with: TDK: [CODE]select detail.MatId as ID_Nhap, SUM(Quantity) as …

I have 3 tables: A, B, C. How to insert 100000 rows into table B, while inserting have data is the random data are taken from Table A and C Thanks for help!!!!