Dataset to Database
Hello, I'm working with framework 2.0. I have a dataset with many rows that were entered by the user and I need to write them to the database. What is the right way to do it? TY ...
dataset
Looking for solution to persist rows sequence in a database table that allow efficient reordering at runtime
I have a database table. There is a field name "Sequence" that indicate sequence when user presents the rows in report or grid visually. When the rows are retrieved and presented in a grid, there are few UI gadget that allow user to reorder the rows arbitrary. The new sequence will be persist in database table when user commit the cha...
Load parts of an XML file into a DataSet
Hi,I have a DataSet with some Datatables and I am saving this DataSet as XML file (C#) ..is there any way to load only some parts of this XML file into the DataSet when I start my program instead of loading all the file ? ...
C# SQL Data Adapter Fill on existing typed Dataset
I have an option to choose between local based data storing (xml file) or SQL Server based. I already created a long time ago a typed dataset for my application to save data local in the xml file. Now, I have a bool that changes between Server based version and local version. If true my application get the data from the SQL Server. I'm...
How to convert a DataSet object into an ObjectContext (Entity Framework) object on the fly?
Hi all, I have an existing SQL Server database, where I store data from large specific log files (often 100 MB and more), one per database. After some analysis, the database is deleted again. From the database, I have created both a Entity Framework Model and a DataSet Model via the Visual Studio designers. The DataSet is only for bulk...
dynamically updating a datagrid from a XML file c# 3.5
I have a datagrid that is populated via XML file when the form loads. Everything is working great but I would like the datagrid to update dynamically when a new order is received (Separate class receives a data stream and updates the file). Im looking for suggestions on how this should be done. (ie using a timer update every second, ...
C# SQL Data Adapter System.Data.StrongTypingException
I get my data from SQL to Dataset with Fill. It's just one table with two columns (CategoryId (int) and CategoryName (varchar)). When I look at my dataset after fill method, CategoryId Columns seems to be correct. But in the CategoryName I have a *System.Data.StrongTypingExceptio*n. What could that mean? Any Ideas? ...
Selecting item from set given distribution
I have a set of X items such as {blower, mower, stove} and each item has a certain percentage of times it should be selected from the overall set {blower=25%,mower=25%,stove=75%} along with a certain distribution that these items should follow (blower should be selected more at the beginning of selection and stove more at the end). We ar...
DataReader, DataAdapter & DataSet - When to use?
I want to know when i have to use these ADO.NET Components???can anyone brief it with an example??? ...
Class design when working with dataset
If you have to retrieve data from a database and bring this dataset to the client, and then allow the user to manipulate the data in various ways before updating the database again, what is a good class design for this if the data tables will not have a 1:1 relationship with the class objects? Here are some I came up with: Just manipu...
Mark row as deleted in dataTable on UserDeletingRow
I have a datatable bound to a winforms dataGridView via a BindingSourceControl. I want to be able handle the UserDeletingRow event from the dataGridView and mark the row in my dataTable as deleted. I need to then be able to retrieve the rows marked as deleted from the datatable so that I can delete them from my database when a Save butto...
Viewstate in a .ashx Handler?
I've got a handler (list.ashx for example) that has a method that retrieves a large dataset, then grabs only the records that will be shown on any given "page" of data. We are allowing the users to do sorting on these results. So, on any given page run, I will be retrieving a dataset that I just got a few seconds/minutes ago, but reord...
ASP.NET - dynamically creating database connection in datasets
I am currently using datasets for my data access layer. I currently store the connection string in the web.config file. I need the ability to change the connection to another database before any queries are processed. Is there an event that is triggered or a base class that can be modified that intercepts the process of retrieving the...
DBNull values on an ASP.NET MVC view
I am writing a simple ASP.NET MVC web app. At this point, I am just trying to display a strongly typed DataSet on the automatically generated view. However, some of the values in the DataSet are null and cause exceptions. I am wondering how this simple scenario is handled by others. It seems excessive to sanitize all the values in the ...
Binding Programatically Generated Datasets To Report Viewer
Today I researched about reportviewer to use it in my project. As I see the samples and tutorials in the web, We should create an dataset file to Solution Explorer and bind it to report viewer to show data. However I want to create dataset programatically like sample code below. And I want to bind it. Dim ds As New DataSet DB_Gateway...
How to insert line breaks dbunit dataset.
How to insert line break in dbunit dataset? Like this: <user id="1" story="first line second line third line"/> If I do it in this way field story in db appears divided by spaces only but I need a line break. ...
Making a DataSet from another DataSet
Hi folks I have a client-server project (small project for companies in C#) and the server has a DataSet with some tables (there is no Database for some reasons so we save the DataSet as an XML file). when the clients connect to the server, the server should send some informations to the client depends on his privileges and some clients ...
"(Empty)" text "literally" instead of "" in datacolumn from visual studio
Hi folks. I've always have a problem with big datasets created through the dataset designer in visual studio (2005). When the dataset many tables with many columns, the columns defined like "(Empty)" in the NULL VALUE property starts showing the text "(Empty)" literally. Is anyone aware of this? or is just me? Thanks in advance. ...
c# Counter requires 2 button clicks to update
Hi, I have a problem that has been bugging me all day. In my code I have the following: private int rowCount { get { return (int)ViewState["rowCount"]; } set { ViewState["rowCount"] = value; } } and a button event protected void addRow_Click(object sender, EventArgs e) { rowCount = rowCount + 1;...
How to return table name from stored procedure in dataset.
I used a dataset to store 15 tables that I need at the time of loading. When i filled all the tables using stored procedure it returns me all the table but name of the table doesn't comes as that of actual table name in a database. It takes all the table with table name as Table1, Table2, Table3... I want them to be with the name as t...