all groups > dotnet ado.net > april 2008 > threads for april 1 - 7, 2008
Filter by week: 1 2 3 4 5
Call Dispose on OleDbCommand?
Posted by JohnMSyrasoft at 4/7/2008 12:49:02 PM
1. Should you explicitly call Dispose on OleDb objects like OleDbCommand or
OleDbConnection?
2. In VB.NET for the keyword USING (as in "Using cn As New
OleDbConnection(...)...")
Should you explicitly call the Close method on the OleDbConnection object or
will the object be closed and d... more >>
OutOfMemoryException using .NewRow
Posted by TexasAggie96 at 4/7/2008 7:09:46 AM
I am dealing with a very large amount of data add it to a dataset
using DataTable.Rows.Add. When creating the new row using .NewRow I
get an OutOfMemoryException at around row 4 million plus. I know
that
this is a very large number of rows, but I have 4 GB of Ram and the
Task Manager shows th... more >>
How to fill a listview from LINQ query
Posted by Dean Slindee at 4/6/2008 8:28:25 PM
Currently using a legacy Winform listview, that is filled by a function from
datatable(0) in a dataset. This works fine as the datatable has column
headers and data rows that correspond to listview headers and listview rows.
Would like to use Linq to SQL to populate the same legacy WinForm l... more >>
Add column using Dataset Designer => hosed project
Posted by Molon Labe at 4/5/2008 12:36:01 PM
Context:
VS2008
SQL Server Compact 3.5 database
Problem:
I used the Dataset Designer to add a column to a table (right click on table
in designer, Add->Column).
How do I update the database to correspond with this change?
I tried locating the database in my Server Explorer and addin... more >>
How to Update an existing schema on a typed dataset
Posted by socamb at 4/4/2008 6:11:00 AM
I need to do what seemes a simple task, but i am stuck. I have a
column in my database i need to change from 7 chars to 10 chars. I
have a number of strongly typed datasets in my system that use this
table.
I attempted to edit the xsd file in the designer and changed the 7 to
a 10.
But... more >>
Replacement for dataadapter
Posted by Harsha at 4/4/2008 5:22:36 AM
Hi Experts,
I am having new problem again.
This is regarding SqlDataAdapter fill method performance. Even though
its discussed several times my problem is little different.
I had migrated one VB6 application to .Net 2.0. In VB6 application
they were using RecordSet.
Like,
--------------... more >>
Databinding to a listview
Posted by Ant at 4/4/2008 5:11:00 AM
Hi,
I'm trying to populate a list box using a dataset. The data set is tested
fine to have data in it but when I run the app, the listbox does not get
populated. Below is what I'm doing:
Class1 myclass = new Class1();
myclass.Server = "LAPTOP";
myclass.DB = "Northwind";
... more >>
Where to: Questions About EDM and CSDL
Posted by CharlesRCaplan@gmail.com at 4/3/2008 2:21:56 PM
We are about to start serious design on a new app here. I would like
to use the Entity Framework stuff that's new in Framework 3.5 and
since it's not even officially released yet, I'm sure to have some
questions. So my question is
"microsoft.public.dotnet.framework.adonet" the best group to ask
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to read sequentially from a random point in a large Xml File. (200 - 2000 MB)
Posted by Schwartzberg at 4/3/2008 1:02:00 PM
Hello
Have a huge XML file with multitudes of "LogEntry" nodes / text
lines.
A small sample of this xml/text content is below.
The file could be anywhere between 200 to 2000 MB.
My questions comes in two parts.
(A)
I would like a solution (or ideas for it), in C#, -- to randomly
access ... more >>
Question to the generals in this newsgroup including MSFT's
Posted by Cor Ligthert[MVP] at 4/3/2008 7:15:57 AM
Is this a FrameWork.ADONET or a LINQ newsgroup?
As I see so many non LINQ to ADONET questions answered at the moment.
Cor... more >>
Reading a text field
Posted by Josh at 4/2/2008 4:58:02 PM
How do I get the data out of an MS-SQL Text field efficiently
A simple "SELECT [FieldName] FROM [Table]" unfortunately returns a truncated
version of the fields contents ( which actually contains an entire book ).
I know that your not supposed to do a simple select, but my Google-Fu is
wea... more >>
SQL 2005 Error connecting to SQL2000
Posted by Ant at 4/2/2008 3:20:00 AM
Hi,
I'm connecting to an SQL2000 Server, it runs a very slow SP that takes
around two minutes. I've set the command & connection timeout to handle this.
It used to work fine but now I get a seemingly unrelated error. I can connect
remotely to do simple queries & LINQ queries but the SP doesn'... more >>
Linq SubmitChanges and DataLoadOptions
Posted by Chuck P at 4/1/2008 1:34:01 PM
I have some code that has a DataLoadOption to load Master/Detail records.
When I update the Master table, the object gets returned but the Details
records are not loaded. Is their a work around for this?
using (MyDataContext dc = new MyDataContext())
{
... more >>
linq combined query
Posted by Chuck P at 4/1/2008 10:05:01 AM
I tried to make some complex linq queries easier to read by pulling some of
the queries out.
This works fine:
var qAllJobDescriptions = from j in dc.Jobs
select j;
var qAllOracleJobCodes = from o in dc.OracleJobCodes
... more >>
|