Using SQL Server 2008 I created a Stored Procedure called MyStoreProc and it runs fine from the Management Tools. In VB.Net 2008 I created a new dataset and a new TableAdaptor. In this table adapter I created a new Query called FillByGrid and selected the Stored Procedure. Previewed data and it previewed correctly. On a form I create...
Please help out newbie. I am reading mothly sales statistics for last two years from stored procedure, display it on asp.net site and it works just fine. Problem is with products that are not sold often I need to figure out which months do not have any sales. In that case I need to put zero in table cell and move to next row in dataset. ...
Hello, My first post here with 2 questions. Question 1 I am new to SSRS environment and have been looking to get architectural information to explain me how rdl is processed and rendered. For e.g. all datasets executed and resultsets cached, then all tables rendered... etc. So if someone has any link that would give me an overview, i...
I have a lightweight data-basey kind of thing. Functionally, I'd like to read and write tables out to disk(plus maybe some other info in the future). I chose to use the DataSet object, paired with the DataGridView control for the IO. The DataSet object can serialize out to disk and back again via the handle XML read/write functions. H...
I need to create an dataset from excel. Currently I am doing it by following way :- Go through each worksheet in workbook, get each cells value..and create datatable for each worksheet..and create a dataset for given workbook. But we change the extension of an excel file to .xml(a.xls -> a.xml)..and create dataset out of this xml (this...
How to cast System.Data.Linq.Table to System.Data.DataTable DemoDBDataContext context = new DemoDBDataContext(); DataSet ds = new DataSet(); var query = context.Customers; ds.Tables[0] = query; How to do that? the assignment ds.Tables[0] = query; It throws Property or indexer 'Sys...
Hi...I have some old code that was using Subsonic 1.x and want to migrate to 3. Some of my old methods used to return a Dataset using the old Subsonic Query object and then just calling ExecuteDataset(). I still need to support those methods, since they're called by other code...however, I can't find anywhere how to to a code query with...
Xml help using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Xml; namespace xmlBase { public class xmlBase { public string XmlFileName { set; get; } ...
We have a third party application that accept calls using an XML RPC mechanism for calling stored procs. We send a ZIP-compressed dataset containing multiple tables with a bunch of update/delete/insert using this mechanism. On the other end, a CLR sproc decompress the data and gets the dataset. Then, the following code gets executed: ...
Hi, This is a problem that my friend asked over the phone. The C# 3.5 program he has written is filling a Dataset from a Patient Master table which has 350,000 records. It uses the Microsoft ADO.NET driver for Oracle. The ExecuteQuery method takes over 30 seconds to fill the dataset. However, the same query (fetching about 20K records) ...
I Want to print out the number of tables in a Typed dataset along with the number of fields associated with each table and the key fields { primary,foreign}. How to get this information using LINQ? ...
I have a dataset named DocumentDataSet along with a class named Document. When the dataset is serialized, I need it to have it root named "Document" because I'm communicating with a 3rd party webservice. I though of defining the attribute XmlRoot in the partial class of the dataset, but I cannot add a duplicate of XmlRoot since it is a...
Hope I chose the correct forum. I have a dataset object with one table that comes to me from a common custom component's GetDS method. I need to pass XML to another process (chunked as byte array). I have it all working but the XML is missing some attributes that the consuming process expects. I create a dataset object and can control ...
I am working on WCF with DataSet.xsd in a C# application. Could you please tell me how to do Update and Delete? ...
Hi, I am looking for architecture like as follows: Database --> DataSet --> DataContext(Linq)/ ORM Entity --> GUI Application I want to fetch data from database and keep into DataSet so if database id disconnect my application doesn't affect. But DataSet is not supporting Object-Relational-Mapping (ORM) Model. I am interested in ...
DataContext/Entity Model always read data from Database. is there any way DataContext/Entity Model will read the data from DataSet. Thanks ...
I first want to add a database column in DataColumn..and then i have to add datacoloumn in datatable.. please guide me; SqlDataAdapter d2 = new SqlDataAdapter("select MARK_PARTA from exam_cyctstmarkdet",con); DataColumn c = new DataColumn(); c.ColumnName = "parta"; c.DataType = System.Type.GetType("System.Int32");...
I'm about to develop databse server app; I have decided not to use typed dataset/dataset, except in the DAL, (so I'm not asking the question whether to use dataset or custom objects). Populating my custom objects with data requiers an interaction with DataSet in the DAL. I have seen a reasonable way of using typed dataset for this purp...
Hi all, I am new to python and programming, I am looking for a code, or a sample code that can have a predefined set of hex values and that can find the 3 used values within to generate a certain value. lets say I have a value of : 0x50158A51 this is a 4 byte (32 bit) hex value now i need to find the values which when added or subt...
I inherited a giant dataset that my profiler notes that the InitClass method takes over 5 seconds to load. This is generated code so, other than removing unneeded datatables etc... is there anything I can do to improve the performance of this method? This is in VB.NET EDIT The profiler says that 99% of the time is spent inside the m...