I've got a web app that sends a request to a WCF service. The WCF service gets a LINQ resultset (anon. ilist) and sends that in reply, back to the web app. In order to get it working quickly, inside the WCF app, i'm using copytodatatable and sending it to my web app in a DataSet. My web app then takes the DataSet and writes it to xml, ...
I need to Export DataSet to Excel, Exporting it is not the main issue, When I am using the Same Exported Excel File using following Connection String CS = "provider=Microsoft.Jet.OLEDB.4.0; " & _ "data source=" + FilePath + ";Extended Properties=Excel 8.0;" It gives me an error message saying External Table is not i...
Hi everyone, I have a legacy dot net application (now migrated to .net 2.0). We need to convert this application to silverlight. Problem here is the datalayer. All the methods from the datalayer return datasets. The entire web application is using datasets for databinding. Now the questions are: Can I use the same datasets for silv...
Hello - I am fighting a recalcitrant VS2008 DataSet designer, it seems. I have been trying to do what seems to be a simple 2-table dataset solution, where one table is simply the textual meaning for an integer value stored in the other table. Basic data design 101. Table1 CharField1 CharField2 IntForeignKeyField1 etc Table2 IntPrima...
Hi, I was struggling moving to Wpf,I am just stuck while trying out databinding to a lsitview.I want to databind a listview to a dataset(dataset because the data i want to display in columns belongs to different tables).I am attaching a sample code that i am trying with.It works alright but the listliew only shows one row.What could be w...
Hi, whenever I convert a DatSet into an XML with DataSet.GetXml, any null value is ignored, so, where i expect this: <value1>a</value1> <value2></value2> <value3>c</value3> I get this instead: <value1>a</value1> <value3>c</value3> Any quick and dirty way to handle this? Thanks EDIT: I think a solution would be using WriteXml. Coul...
Hi, I'm tring to get a string from a DataSet without using GetXml. I'm using WriteXml, instead. How to use it to get a string? Thanks ...
I fill the dataGrid by binding a dataSet to the grid, with aDataGridView.dataSource = aDataSet.aTableName, when I trace the code after using this function, all of the column indexes are reset to 0, what can I do? how can I find new real indexes? can I use a different function? I tried this code I found here, but it's not working: this.d...
Are there any best practices pertaining to the number of tables used in a dataset? In a relational database, all tables eventually relate, so how specific or broad should I be when creating my datasets? Ex: If I have a dataset for product orders, should I also include the products tables, as well as the customers tables that the orders ...
Hi guru I am using the latest version of MySQL connector to .NET and Visual Studio 2008. I dragged and dropped all tables from the MYSQL database to VS 2008 dataset GUI successfully. When I was going to add a new stored procedure to the dataset, Visual Studio environment just refused doing so. Is there any solutions around this? Than...
I have two dataset questions. If I change any cell in a dataset, how I can update this change in a database without using an SQL update query? How can I see dataset contents in debug mode (to see the data)? ...
Hi there ! I'm working v.s 2008 with c#. I have a xsd file and i m writing a method in that DataSet's .cs file which is return a datatable. also i'm using a report wizard. And i want to my report using that methods. how can i give my method to my report as a reference? ...
I am using Xceed's Datagrid, bound to a dataset. I want to update the database when the datagrid's RowEditEnd is called. The problem is that in order to avoid concurrency violations when updating, I have to clear the dataset after update and refill it, like this: public void UpdateDatabaseFromDataSet() { adapter.Update(exampleDataSe...
How do I compare values of one data set from another. 1st dataset["proper records"](coming from sqlserver, with column name [id],[subsNumber]), 2nd dataset["proper and inproper records"](coming from progress database, with diffrent coulums except 1 which is[subsNumber]). how do I go and make another dataset which has all the [subsNumbe...
Possible Duplicate: Update DataSet, How ? Exact duplicate of : Update DataSet, How ? I have DataGridView that Connect to Dataset. if I change Cell in the DataGridView, whay the DataBase not change ? only the dataset change, How I can change the DataBase too ? thank's in advance ...
I have designed a class with sqlClient.SqlCommand wrappers to implement such functionality as automatic retries on timeout, Async (thread safety), error logging, and some sql server functions like WhoAmI. I've used some strongly typed datasets mainly for display purposes only, but I'd like to have the same database functionality that I ...
I'm using DataSet to connect my C# program with SQL database. I want one of the columns to be an enumeration and I want it to act as an enum in my code. How can I do this? ...
Hello All, I have a tree view control which I have to bind a dataset with multiple data tables in it, and have relations between them. can you suggest how can I do that, I have tried many ways but none of them proved useful... Thanks ...
Hi folks Today's problem in my code is kind of strange, and I could not reproduce it yet. I'm working with a typed dataset (created with the designer) and I'm looping over all rows in a datatable. Sometimes (!), when finding via primary key, the returned row is not equal to the one from the enumerator. This is some code I wrote to repr...
I have this code so I can grab the values ind the dataset before i bind it. can't get the dirctcast to work dim ds as new dataset("Mytable") gridView.DataSource = ds Dim dataRow As DataRowView = DirectCast(ds.Tables.Item("MyTable").Rows(), DataRowView) Dim ID_Equipamento As String = dataRow("ID_Equ...