I've got the following stored procedure Create procedure psfoo () AS select * from tbA select * from tbB I'm then accessing the data this way : Sql Command mySqlCommand = new SqlCommand("psfoo" , DbConnection) DataSet ds = new DataSet(); mySqlCommand.CommandType = CommandType.StoredProcedure; SqlDataAdapter mySqlD...
I would like to copy a whole TClientDataSet instance into another so I can recover any changes made in the original one. I've tried to saveToStream, to copy the data property but in all cases I loose the fields configurations (displayLabel, size, etc.) Is there a way to do what I'm trying? ...
Hi I am using a dataset and in that dataset I have a table adapter. In my table adapters I have used stored procedures as queries. If I use the following lines to insert form data using my table adapter, is it safe against SQL injection? Thanks. UserDataSetTableAdapters.UserInformationTableAdapter myFactory = new TestProject.UserData...
Hello. I am just learning C# through Visual Studio 2008? I was wondering what exactly is the correlation between dabases, datasets and binding sources? As well, what is the function of the table adapter? ...
Can anyone give me any pointers to resources detailing the structures and algorithms used "under the hood" of the .NET DataSet class? I'm currently working in a language that doesn't have an implementation of a generic in-memory data structure like the DataSet class. I may end up having to build one myself (but not as extensive!), but ...
SQLServer int field. Value sometimes null. DataAdapter fills dataset OK and can display data in DatagridView OK. When trying to retrieve the data programmatically from the dataset the Dataset field retrieval code throws a StronglyTypedException error. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public int curr_read...
Hello! I am using OleDbDataAdapter to fill a table in the DataSet. The problem is that select sql statement is very complex (using left joins to get data from numerous tables) and OleDbCommandBuilder can't write an insert/update statement for me. I was wondering what is the best course of action here? There aren't that many columns in ...
Ive been asking a lot of Javascript questions, i guess i just have to learn it, but for the moment, i have this scenario, can anybody fill the gaps for me, its like: Dtabase Table Maps' fields: Map_ID, Coordinates, MarkerTitle, MarkerField. Code Behind: Dim myTableAdapter As New myDatasetTableAdapters.tblMapsTableAdapters Dim myTable...
I cannot see the magnifying glass next to my Dataset anymore. Is there a way to re-enable it? ...
Hi I cannot view DataSet file in designer mode in VS 2005. When I try to it another solution it is ok but in one of my project solution I cant. The projects are c# class library projects in a solution file. Is there any suggestion? Thanks for your help. ...
Hi, I have a weird problem where the "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." error sometimes pops up when I am trying to build my project. The line in question throwing the error was auto-generated code in the designer file for the dataset. To find out the ...
I used SPRY about a year ago to experiment with the fact that you could essentially load a "dataset" into Javascript/browser, and act upon that to bind to form fields like textboxes, combo dropdowns etc. I really have been trying to find something really simple to allow me (a coder) to write the backend code to get the data, and my part...
I have some data I want to work with. Two string and two numbers and I have say 8000 rows of data. Is a dataset the best option here to use, or could I use a struct and have a list of structs? Would there be much performance difference between the list and the dataset? ...
Hi, How scalable are datasets? Team member wants to use datasets for data retrieval and manipulation, use the built in data integrity etc. to use the object to perform data updates etc. Our system is expected to scale to millions of users. Everything that I have read is against dataset's in an enterprise environment, am I wrong here ...
I have a dataset being returned by a stored proc and one of the items in it can potentially be null. I'm trying to convert each row in the dataset to a strongly typed object but I can't seem to cast the null value properly. I've created a mock up of my scenario as follows: DataSet ds = new DataSet(); ds.Tables.Add(new DataTable()); ds....
ds.WriteXml(strXmlTestCasePath, XmlWriteMode.IgnoreSchema); ds is a dataset. I want to add an extra line or extra information into this XML. How do I do it? ...
Newbie to .NET data apps here, coming from a Visual Foxpro background. I'm planning on an ASP.NET and/or Silverlight UI, and maybe some WPF client stuff too on our LAN too, so I want to craft a data access layer that can support all these front ends. My data will be in SQL server. I have already made a test run of pushing the data from...
I have a DataSet defined and designed in visual studio. Who knows of a tool to generate tables in SQL Server to match the dataset. ...
I am a little bit confused about Dataset compared to ORM (NHibernate or Spring.Net). From my understanding the ORM sits between the application layer and the database layer. It will generate the SQL commands for the application layer. Is this the same as what Dataset does? What is the difference between the Dataset and ORM? What are the ...
I have a Form (Compact Framework, actually) with a few fields, a date and a string, among other things. Both TextBox controls are bound to properties in a BindindSource. The BindindSource has a DataSet as its DataSource property, and the DataMember is a table in a SQL CE database. When I want to add a new row, I call bindingSource.AddN...