Search results for query: *

Hi All, Does anyone know any methodology to create direct print-out from datagridview. From googling what i found is that it's quite complex process. Is there any package available to dot the same (i.e. nugget package). I have datagridview populated from database and I want to make PDF print of...

Hi sorry for late response. Initially when I started to use 150.1400.0 it was buggy in a sense that sometimes it won't even show the drop location. Like once I select it from the toolbox it wont' draw the reporting area. Then i uninstalled and reinstalled previous versions. Didn't work either...

Okay after lot of study and online searches I am very happy to find solution. Thanks JMC for giving me direction as I have to do a "SUB-QUERY" to pull-out the results. Final (correct) query is as below. SELECT sin.Prod_ID, sin.Prod_Name, sin.Bought, ISNULL(sout.SOLD,0) as [Sold]...

Okay really thanks for this idea. Gonna check it. Summary will be "Prod ID, Prod Name, Date, Expiry, Stockin Units, Stockout Units, Re-Order, Current Stock". Thanks for valuable ideas. Gonna put them in action.

Okay here is the deal. I want to get the "Current stock" information which will be result from stockin and stockout. There is some quantity purchased (stockin) and then some quantities sold (for each item) saved in (stockout). To get "Current stock position" I need to sum the stockin quantity...

My target is to get "Purchase Cost" from "Stockin table" and "Sales Price along with Invoice Number" from the "Stockout table". These are completely different tables except for the product ID and Name columns. Yes I made mistake of not properly defining the schema and of not reinforcing "FOREIGN...

Thanks for the response. Would really appreciate if you can guide me how to make the change easily in my current schema as I really want to get it done asap. Any help is appreciated.

Hi All, I am have three tables in my database i.e. Stockin, Stockout and Products. Below is their detailed schema. CREATE TABLE [dbo].[Products]( [Id] [int] IDENTITY(1,1) NOT NULL, [Prod_ID] [varchar](10) NOT NULL, [Prod_Name] [varchar](150) NOT NULL, [Re_Order] [float] NOT NULL...

Well now that is solved as well. ONLY issue was that my tables in SQL were NOT having identity (1,1) clause. When i updated that, everything got fixed.

Oh Okay. Thanks a lot. So I was using wrong Collection type. I have now re-declared it to global list (my original intent) and happily it is getting passed. My last issue is I am having error related to ID field as I am getting error that values passed to ID field can't be NULL. Though my target...

Hi Skydiver, Yeah that bracket was missing by mistake while pasting my code. I'm totally surprised to see that when I'm debugging the code, the stockout or stockin list is getting populated properly but once I reach the part where I need to do the bulk-insert and I check debugger it shows...

0 I am trying to populate my database column with name "StockInTable" using Dapper Plus nugget package. My stockin file is as below. class Stockin { [Key] public int ID { get; set; } public DateTime Date { get; set; } public string Sup_ID { get; set; } public string Sup_Name...

Thanks for suggestion. Should I immediately move to WPF? I am still in initial stages and it's not a huge project to make changes.

Apologies for such a broad question but actually I never worked with Excel import so wanted some head start. With some googling I got some ideas and will try to develop initial input processing module to handle input data. Then if i got some issues will come back here. But what I've seen in...

Hi All. I am working on a project where I need to carry out below steps. 1. Import data from Excel and display using datagridview 2. Create local database in the application - Windows .Net form application 3. Convert the loaded data into SQL format (SQL readable format) 4. Store the data in...

Well guess well..... After lot of struggle I finally got the version "Microsoft.ReportingServices.ReportViewerControl.Winforms 150.1400.0" working for me. Very happy that the annoying issues are solved and now my reporting is working fine. Gonna save this configuration to avoid future issues. :cool:

Well I know many guys (in different industries) who are using SAP ERP systems and none of them had any major issues which are "buggy-type" as is the case with some of MS solutions. Of course being a pure MS user (I use Windows only) there are many good things but the whole MS stuff seems bloated...

Thank you Jmc and Sheepings. Is crystal report for free? I couldn't find suitable information by searching. If free then I think this should be better than MS stuff as SAP seems to be more professional company.

Hi all, I am getting stuck with report viewer in Visual Studio 2019. I already have installed report designer and is working perfectly fine but whenever I try to install the "Report Viewer" from Nuget packages, it always either crashed or fails to load properly and show any report. Any permanent...