all groups > dotnet ado.net > september 2007 > threads for september 8 - 14, 2007
Filter by week: 1 2 3 4 5
Problem with XML vs Dataset
Posted by Ariana at 9/14/2007 9:02:29 PM
Hello,
I have a problem and I'm hoping it will ring a bell with someone here. :)
In my ASP.NET website, I have a custom calendar control which highlights
ranges of dates based on a data source, and also allows a new date range to
be selected. To select a new range, the user clicks on the f... more >>
is there some per-process-limit on memory in .net processes? is there any way to increase it? i keep getting System.OutOfMemoryException when my box h
Posted by Daniel at 9/14/2007 8:36:41 PM
is there some per-process-limit on memory in .net processes? is there any
way to increase it? i keep getting System.OutOfMemoryException when my box
has 8 gigs of unused memory.
... more >>
Large update SQL command works on old slow servers but times out on super fast one!
Posted by steve NO[at]SPAM orchardprofessional.com at 9/14/2007 11:33:59 AM
Hi all,
I have a problem in that I have written a .Net 2 application for a
customer that performs significant amounts of manipulation - 250,000
records manipulated and updated with combination of update and select
into commands.
The issue is that it works fine on my old slow development 200... more >>
Newbie Helo - Datarow.EndEdit
Posted by Daniel Jeffrey at 9/14/2007 12:00:00 AM
Can someone please help me.
I have created a simple form.
3 Controls - ID, Firstname and Lastname.
I have added a SqlDataadapter, Dataset etc etc.
When I call Fill(Dataset) it all works fine.
I can edit the values on the screen but when I post nothing happens unless I
call EndEdit.
... more >>
Autonumber Issue With Access 2007 Database/ADO.NET
Posted by Jeff Gaines at 9/13/2007 6:07:38 AM
I thought this may help other people learning ADO.NET.
Having, I thought, got a sufficient grip to 'go live' I set up an app
using Access 2007 and ADO.NET. During testing everything worked except my
'AddRecord' function, which kept complaining of a duplicate entry in an
indexed field. Aft... more >>
Passing parameter to store SQL procedure ???
Posted by calderara at 9/12/2007 6:20:00 AM
Dear all,
I am passing parameters to store procedure without any troubles but
parameters list are less than 10 parameters, still manageable.
But we have a situation where we do not know for instance the number of
variable my final customer would like to monitor and store to database.
It c... more >>
dataset help
Posted by AVL at 9/12/2007 5:30:05 AM
hi,
i need help on setting datatype of a table's column at runtime..
i'm loading a dataset from an xml file...
after loading, i want to set the datatype of one of the column as int32..
how can i acheive it..
is there any way to set the datatypes of the columns before loading the data
from x... more >>
Select and update
Posted by Alejandro at 9/12/2007 12:00:00 AM
Hi all,
I'd like to do something that was very easy with ADO in VB6. I'd like to do
a selection in one table and be able to search on the group of registers,
update or even insert one new.
This is possible to do in ADO .NET? How?
Thank you in advance.
Alejandro
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
New columns in database -> added to the DataSet automatically.
Posted by Trygve Lorentzen at 9/12/2007 12:00:00 AM
Hi,
I do a "select * from tablename" in my dataadapter. In most cases this is
fine because all those columns are also defined in the strongly typed
dataset I'm working with. However, if I add a few new columns or want to use
the dataadapter to fill a different dataset where not all columns ... more >>
Requirements to Run ADO.NET Application
Posted by Jonathan Wood at 9/11/2007 2:08:46 PM
I'm grappling with understanding some ADO.NET issues. I'd appreciate any
help.
If I write a .NET Windows application that uses ADO.NET, what needs to be
distributed with my application in order for it to run for Customers using
Windows Vista?
I understood ADO.NET is included with the .NE... more >>
Does the password in the ConnectionString travel encrypted?
Posted by seguso at 9/11/2007 10:28:35 AM
Hello,
I have a very simple question I could find nothing about.
When, in a .NET application, I connect to a database with a
ConnectionString like "database=foo; server=220.40.231.2; uid = root;
persist security info= false; pwd=blabla", does my root password
travel in clear-text?
AFAIU,... more >>
Single Quote In A Text Field
Posted by Jeff Gaines at 9/10/2007 2:51:18 PM
In my efforts at learning ADO.NET I have discovered that it balks at text
fields with single quote marks embedded. The field in question comprises
notes that can contain anything, it is stored as a memo field in Access.
I tried to wrap the whole field in double quotes without success, it st... more >>
SqlException and Violation of PRIMARY KEY constraint
Posted by Max2006 at 9/10/2007 1:06:26 PM
Hi,
At this point I check the SqlException.Message to check for the "PRIMARY
KEY" errors.
Can I use SqlException.ErrorCode to do the job? I have
ErrorCode=-2146232060 for primary key errors. Can I assume that the error
code -2146232060 and primary key error are always associated togethe... more >>
how to get the id of the inserted datarow?
Posted by Norbert_P=FCrringer at 9/10/2007 5:51:13 AM
Hello there,
after inserting a row, I want to return the id of the inserted row.
This id could be a number or a string (e.g. GUID values). The database
could be SQL Server, Oracle, MySQL or Access. Is there a database
independent way to return the ID of the inserted data row?
My way does on... more >>
Storing decimals to Pervasive SQL database
Posted by Hans van de Laar at 9/10/2007 2:38:27 AM
Within an VB.net application I'm trying to store decimal values to a
Pervasive SQL table. The decimal values comes from a xml file and is
looking something like:
<Grade1>6.65</Grade1>
<Grade2>6.66</Grade2>
<Grade3>6.0</Grade3>
When I look for the results in the database I find 665, 666 and ... more >>
Enterprise library connection string
Posted by Rick Mavrovik at 9/10/2007 12:00:00 AM
Hi,
I need to connect to a database the connection string of which is determined
at runtime.
I am using Enterprise Library 3.0 for data access. How can I connect to a
database
at runtime, without hardcoding the connection string in the web.config.
Please help!!
Thanks.
Rick
... more >>
Large MySQL SQL File -> ASP.NET Database
Posted by Jonathan Wood at 9/9/2007 10:12:03 AM
Greetings,
I have backed up a MySQL database from a PHP site. This backup is in the
form of a large (55MB) SQL file.
Can anyone tell me how I can convert it to an ASP.NET database?
The file is too large for cut and paste and it appears the SQL content is
not fully compatible with Micros... more >>
|