|
More site info...
ADO.NET DataSet | Forum profile
|
|
Forum profile page for ADO.NET DataSet on http://msdn.microsoft.com.
This report page is the aggregated overview from a single forum: ADO.NET DataSet, located on the Message Board at http://msdn.microsoft.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "ADO.NET DataSet" on the Message Board at http://msdn.microsoft.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on ADO.NET DataSet:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
33
|
175
|
418
|
|
Post:
|
58
|
295
|
752
|
|
|
ADO.NET DataSet Posting activity graph:
|
Top authors during last week:
user's latest post:
Error on a Simple Delete Query
Published (2009-11-30 21:24:00)
Looks like you are talking about Access database. did you check your Enforce Referential Integrity and Cascade Delete Related Records ?
user's latest post:
Create Access 2003 tables from...
Published (2009-11-27 06:52:00)
Hi Tekito, For using "select into", you can refer to this thread, http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/7deeffe4-7b64-431c-8e5e-5d350db32a59 Does this work for you? If you have any questions or concerns, please update the thread and we will have a further discussion. Best Regards Yichun Feng
user's latest post:
LINQ - Full outter join on many...
Published (2009-11-29 18:50:00)
Something more like this is what I am working with. Each Dictionary represents the results from a query preformed previously. Not sure if it is easier to keep them in "Enumerable?" form or as a Dictionary. // Key - acct# , Value - amount Dictionary< int , int > foo1 = new Dictionary< int , int >(); // predicted total Dictionary< int , int > foo2 = new Dictionary< int , int...
user's latest post:
DataSet - when the view you want...
Published (2009-11-26 00:34:00)
If you need to transform on both the read (SELECT) and write (INSERT, UPDATE, and/or DELETE), I'd recommend learning how to write stored procedures. Write a stored procedure for each DML (SELECT, INSERT, UPDATE, DELETE) you need to support and configure the adapter to use them.
user's latest post:
How to refresh XSD file when...
Published (2009-11-25 02:25:00)
Hi guys, I found out that this could be done by selecting "Configure" in the dataset designer. Then in the TableAdapter configuration wizard, just modify the select query. Add/delete the columns that you added/deleted in the actual database. After clicking "Finish", the data tables are re-generated and so are the other commands. I hope this helps, even if it's just a tidbit of information. Btw,...
user's latest post:
Custom conversions for DataSet...
Published (2009-11-28 22:36:00)
You don't say where the data in the untyped DataSet comes from, but if you can change the DataType from string to double before you put data into it, then your Merge will work. Unfortunately, after the DataTable contains data, you can't change a column's DataType. Is this something you can do or is putting the data into the DataTable what defines your DataTypes?
user's latest post:
How to insert dataset into...
Published (2009-11-24 08:52:00)
Hii Bonnie, * instead of looping whole dataset for state . we can set the the dataAdapter's one property as below. * dataAdapter.AcceptChangesDuringFill = false; * This will tells the adapter that whatever rows added into dataset, its rowstate as default added. * We can use dataAdapter.AcceptChangesDuringUpdate = false; as an when required according to scenario. Proposed As Answer by BonnieB MVP Tuesday, November 24, 2009 4:31 PM...
user's latest post:
doubt
Published (2009-11-26 09:41:00)
this code is for Populatedropdownstate public void PopulateDropDownListState() { string sql = "select * from states"; SqlCommand cmd = new SqlCommand(); conn.Open(); DataTable ds = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); cmd.Connection = conn; cmd.CommandType = CommandType.Text; ...
|
|
|
|
Latest active threads on ADO.NET DataSet::
Started 1 day, 20 hours ago (2009-11-30 21:24:00)
by JohnFL
Looks like you are talking about Access database. did you check your Enforce Referential Integrity and Cascade Delete Related Records ?
Started 2 days, 20 hours ago (2009-11-29 20:29:00)
by Lasha34
Hello how can i save this converted time
If m_DataSet.HasChanges() Then
Dim data_adapter As SqlDataAdapter
Dim Command_Builder As SqlCommandBuilder
Conn = New SqlConnection(ConnectionString)
strSQL = "SELECT id,comment,CONVERT( varchar(35), tb1.Time1, 108) As Time1,description FROM dbo.tb1"...
Started 3 days, 9 hours ago (2009-11-29 08:05:00)
by Rajdip
Hi, I am getting expected raws after creating below query in access 2007 database (*.mdb). But when I am trying to execute it from Visual Studio DataSetDesinger DataTableAdaptor it dose not returns any raw. Kindly help. SELECT Salary.SalaryMonth, EmployeeMaster.EmployeeCode, EmployeeMaster.LastName, EmployeeMaster.FirstName, EmployeeMaster.MiddleName, Salary.LTA, ...
Started 3 days, 2 hours ago (2009-11-29 15:01:00)
by Florian Reischl
Hi
I'm not sure if I got you, but you can create a full outer join with several "from" clauses:
List< int > foo1 = new List< int > { 1, 2, 3 };
List< int > foo2 = new List< int > { 4, 5, 6 };
var bar = from i1 in foo1
from i2 in foo2
select new { Foo1I = i1, Foo2I = i2 };
bar.ToList()
.ForEach(item => Console.WriteLine( ...
Started 3 days ago (2009-11-29 17:03:00)
by zakir.hossain
The answer is select id, name from company where id = ? This syntax is for MS Access data files.
Started 6 days, 17 hours ago (2009-11-25 23:53:00)
by BinaryCoder
> How do you go about handling data that needs to be "transformed" as it is put into the dataset Here are the three ways this is commonly done. I can't tell exactly from your post, but it sounds like you already know some of this. 1. You could specify SQL queries in your application instead of tables. 2. You could define VIEW objects in the SQL database. For the most part, views behave ...
Started 6 days, 23 hours ago (2009-11-25 17:52:00)
by Maciej Pakulski
Do both tables have the same primary keys??
Started 3 days, 23 hours ago (2009-11-28 17:34:00)
by JohnFL
First you need to create the relationship between your Parent & Child Table (i'm using Northwind Database)
' Add the relationships between Categories-Products
mds.Relations.Add( New DataRelation( "relCatProd" , _
mds.Tables( "Categories" ).Columns( "CategoryID" ), _
mds.Tables( "Products" ).Columns( "CategoryID" ), True ))
Then you can ...
Started 4 days ago (2009-11-28 17:10:00)
by JohnFL
can we see some code please? Have you tried
Table1.Columns(2).AllowDBNull = true ;
Started 5 days, 10 hours ago (2009-11-27 06:52:00)
by Yichun_Feng
Hi Tekito,
For using "select into", you can refer to this thread,
http://social. msdn.microsoft.com/Forums/en-US/adod otnetdataproviders/thread/7deeffe4-7b64-431c-8e5e- 5d350db32a59
Does this work for you? If you have any questions or concerns, please update the thread and we will have a further discussion.
Best Regards
Yichun Feng...
|
|
Hot threads for last week on ADO.NET DataSet::
Started 6 days, 17 hours ago (2009-11-25 23:53:00)
by BinaryCoder
> How do you go about handling data that needs to be "transformed" as it is put into the dataset Here are the three ways this is commonly done. I can't tell exactly from your post, but it sounds like you already know some of this. 1. You could specify SQL queries in your application instead of tables. 2. You could define VIEW objects in the SQL database. For the most part, views behave ...
Started 2 days, 20 hours ago (2009-11-29 20:29:00)
by Lasha34
Hello how can i save this converted time
If m_DataSet.HasChanges() Then
Dim data_adapter As SqlDataAdapter
Dim Command_Builder As SqlCommandBuilder
Conn = New SqlConnection(ConnectionString)
strSQL = "SELECT id,comment,CONVERT( varchar(35), tb1.Time1, 108) As Time1,description FROM dbo.tb1"...
Started 2 weeks, 5 days ago (2009-11-13 00:57:00)
by BonnieB
The problem is that your DataTable has no changes. The .Fill() methods leaves the DataSet in an unchanged state. Since you're filling the exact same DataSet/Table in both of your .Fill() calls, there is nothing for the .Update() method to update. IOW, each row in the DataTable must have a RowState of Added in order for the .Update() to insert the data. What you probably want to do is fill a ...
Started 6 days, 8 hours ago (2009-11-26 08:35:00)
by Michael Aspengren - MSFT
I have only briefly looked at this code. To me it seems that the first time you select there is no 'value' in the dropdownlist. So the first time you call PopulateDropDownListStates it is called with a string of "" (empty) The second time a value has been set so then it works. Check if the DropDownList1.SelectedItem.Value contains anything before calling the method. //Michael
Started 1 week ago (2009-11-25 05:18:00)
by Maciej Pakulski
Hi,
If it comes to the query, I found a small error. It should look like:
var query =
ds.Tables[0].AsEnumerable()
.Count(a => a.Field< string >( "State" ) == "CA" );
Best Regards Marked As Answer by Scott_Chang 7 hours 6 minutes ago
Started 6 days ago (2009-11-26 16:32:00)
by Martin Honnen
It simply means that mapping of XML elements to table columns does not work if you have two elements of the same name as you can't have two columns of the same name in the same table.
Started 1 week ago (2009-11-24 21:25:00)
by Jean Grey
Hi guys, I found out that this could be done by selecting "Configure" in the dataset designer. Then in the TableAdapter configuration wizard, just modify the select query. Add/delete the columns that you added/deleted in the actual database. After clicking "Finish", the data tables are re-generated and so are the other commands. I hope this helps, even if it's just a tidbit of information. Btw...
Started 1 week, 2 days ago (2009-11-23 07:33:00)
by Yichun_Feng
Hi Jonathan,
How do you view the data in the mdf file. If you don’t have SQL Server Management Studio, you can add the mdf in the Server Explorer . ( Click View in the main menu -> Server Explorer )
If you are sure that means the inserting is not successful, you can try to use this sample,
1. using System.Data.OleDb;
2. public class...
Started 3 days, 2 hours ago (2009-11-29 15:01:00)
by Florian Reischl
Hi
I'm not sure if I got you, but you can create a full outer join with several "from" clauses:
List< int > foo1 = new List< int > { 1, 2, 3 };
List< int > foo2 = new List< int > { 4, 5, 6 };
var bar = from i1 in foo1
from i2 in foo2
select new { Foo1I = i1, Foo2I = i2 };
bar.ToList()
.ForEach(item => Console.WriteLine( ...
Started 6 days, 23 hours ago (2009-11-25 17:52:00)
by Maciej Pakulski
Do both tables have the same primary keys??
|
|
Size: 212 bytes
