| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I read recently in an ADO.NET book that I should create indexes on foreign
key constraints if they will commonly be used when joining. I...
Joel Lyons
|
11-14-2007 12:18 AM
Cor Ligthert[MVP]  | 5 | 11 |
| | | Hello,
New to ADO.NET so apologies in advance for repeating what I am sure
has been asked been before. I have read that a data reader is much
like a...
rbrowning1958
|
11-12-2007 02:03 PM
William Vaughn | 1 | 11 |
| | | Hi,
I would like to save (and load) an entire datatable into SQL Server 2000.
Is this possible and has someone has some sample (code) for...
Pipo
|
11-12-2007 01:52 PM
William Vaughn | 2 | 8 |
| | | Hi there,
I'm using framework 2 with web application project, one of my page have 5
dropdownlist and one gridview. The dropdownlists data are...
Madison
|
11-12-2007 05:41 AM
WenYuan Wang [MSFT] | 5 | 12 |
| | | about "SqlDependency changes for RTM", in
http://blogs.msdn.com/dataaccess/archive/2005/09/27/474447.aspx,
Sushil Chordia wrote:
"Push Model to...
JX
|
11-12-2007 01:05 AM
JX | 0 | 12 |
| | | Hi;
1) Is there a url that discusses the best way to do this using ADO.NET (and
pretending it's a SQL database)?
2) Is there a url that shows the...
David Thielen
|
11-09-2007 04:48 AM
WenYuan Wang [MSFT] | 1 | 10 |
| | | Hi,
I have two typed datasets I use on the same form. Each contains some
TableAdapters and corresponding data tables. The TableAdapters
contains,...
bz
|
11-08-2007 04:56 PM
bz | 2 | 16 |
| | | I have a table with the PK field defined as an identity field with the
increment of 1. How do I START the calculations at 100, rather than 1?
Cirene
|
11-08-2007 12:51 PM
Cor Ligthert[MVP] | 12 | 20 |
| | | Hi,
I am looking for some sample (code) on how to save a complete datatable into
SQl server 2000.
I want to save the datatable (filled with datarows...
Pipo
|
11-08-2007 12:35 PM
William Vaughn | 5 | 16 |
| | | I'm trying to import a large dataset (300,000 lines of delimited text) into
a SQL database with ADO.NET. I've run into a few issues -
Performance -...
Michael Bray
|
11-08-2007 12:31 PM
William Vaughn | 4 | 16 |
| | | Hi
What happens in the above scenario? Does the query still continue executing
on the Databas server or is it immmediately terminated and resources...
Amir Tohidi
|
11-08-2007 12:28 PM
William Vaughn | 3 | 18 |
| | | Hi,
We are developing a WCF service using .NET 3.0.
The target platform : Win XP,SP 2.0
In the data access layer, we use ADO .NET to connect to...
Ajit
|
11-08-2007 12:08 PM
Ajit | 0 | 11 |
| | | What is the way for getting the sqlQuery with all params
replacementfrom a command ?
DbCommand command;
SqlParameter sqlParam = new...
skneife@gmail.com
|
11-08-2007 07:51 AM
pipo | 1 | 12 |
| | | Hi,
There are two ways to create web-based application or web service, from VS
start page, click on File and New, two options you can choose, one...
william
|
11-07-2007 11:44 PM
Cor Ligthert[MVP] | 3 | 13 |
| | | I need to get a range of records from a specific position like Limit
start,numberOfRecords in mySql:
Example a table with columns name and age:
id ...
skneife@gmail.com
|
11-07-2007 06:42 AM
Kerry Moorman | 1 | 13 |
| | | I am dealing with an AS400 DB2 system and am running into some query
execution timeouts. It seems like every time you Open the initial connection
the...
Paul
|
11-07-2007 02:06 AM
Miha Markic | 1 | 14 |
| | | Hi, i need help.
I am using ADOMD.NET 9 to connect with AS2000 and AS2005, and the
connections to both work fine. However something rare happen. If...
qalexis
|
11-06-2007 02:05 PM
qalexis | 0 | 8 |
| | | After I Open(ed) an OleDbConnection, I need the names of the Tables
right away. How? (in C# or in VB)
Martijn Mulder
|
11-05-2007 08:52 PM
Andrew Faust | 2 | 12 |
| | | Well, I spent about 45 minutes trying to find a simple example that shows
how to add records to a SQL database from C# code.
All I can find is...
Jonathan Wood
|
11-05-2007 06:17 PM
William Vaughn | 6 | 17 |
| | | I try to get one (string) value from DetailsView or GridView control
during button event. Controls own insert or select buttons are a bit
too low on...
LM
|
11-05-2007 02:53 PM
LM | 0 | 9 |
| | | Hello, friends,
We have an app in c#.net 2003. There is a dataSet. Its data are populated to
a customized list in a loop (NO data binding, now and...
Andrew
|
11-05-2007 12:41 PM
William \(Bill\) Vaughn | 6 | 11 |
| | | iam calling a stored precedure from my program, the process is to bring
the datas in tree structure so the data is heavy , when i tried to bring
more...
Hakkim sulthan
|
11-05-2007 12:37 PM
Patrice | 3 | 10 |
| | | Hi
I have an ADO.NET 2.0 command object. i am trying to set the CommandTimeout
property.
Whatever value I try get ignored and the property remains...
Amir Tohidi
|
11-05-2007 08:25 AM
Amir Tohidi | 2 | 13 |
| | | There are two tables. First with fields "ProductID, ProductName and
Price", in other table there is also "NumberOItems".
How can I do this. Is it an...
LM
|
11-05-2007 05:51 AM
LM | 0 | 10 |
| | | Indeed it works nicely.
Thanks very much Frans!
"Frans Bouma " <perseus.usenetNOSPAM (AT) xs4all (DOT) nl> wrote
Lloyd Dupont
|
11-04-2007 07:33 AM
Lloyd Dupont | 2 | 8 |
| | | I have a table
Customer
===========
INT (Identity), Varchar(50), Varchar(50), Varchar(50)
============
ID, City, FirstName,...
Lloyd Dupont
|
11-04-2007 07:23 AM
Lloyd Dupont | 1 | 11 |
| | | When I call BindingSource.EndEdit on one of the BindingSources of my
application, it correctly finishes the addition of the new row but
surprisingly...
Samuel García
|
11-03-2007 03:11 PM
Samuel García | 0 | 11 |
| | | I'm making changes to a small, portable, single-user database
application I wrote a couple of years back built around a muli-table
Access database...
Frnak McKenney
|
11-03-2007 01:37 PM
William Vaughn | 7 | 8 |
| | | Oct 31, 2007
Hi all
Sorry for repeating my previous posting. I am new to VB Net.
Q1. Which provider should be preferred when defining a...
Mike TI
|
11-03-2007 05:21 AM
Cor Ligthert[MVP] | 3 | 11 |
| | | Hello.
I'm an old VB6 programmer who would like to distribute an .exe with the
simplest method possible, and that's not working.
I have an...
Beth
|
11-02-2007 05:34 PM
William Vaughn | 5 | 12 |
| | | How to debug sql 2005 on remote machine. I am administrator on both my dev
machine and remote sql server machine.
I get this error when i try to...
DR
|
11-02-2007 04:05 PM
DR | 0 | 16 |
| | | I am trying to come up with a generic way of generating an insert statement
widh command builer then additional parameter to the insert command so I...
ted185
|
11-02-2007 12:59 PM
William Vaughn | 1 | 10 |
| | | Hi
I am fairly proficient in vb6 and vb.net but I am baffled by generics. What
are generics about and can I make use of them in my winform vb.net...
John
|
11-02-2007 06:19 AM
Armin Zingler | 12 | 20 |
| | | We have a several vb.net apps, that were recently upgraded from Framework
1.1 to Framework 2.0. Randomly these apps have started throwing the...
Rick
|
11-02-2007 05:00 AM
WenYuan Wang [MSFT] | 7 | 16 |
| | | http://www.itechart.com/
DotNetNuke development services for DNN include:
· Product Design and Analysis
· Prototyping
· Incremental Development...
VB
|
11-02-2007 04:57 AM
VB | 0 | 14 |
| | | We develop software used by banks and financial planners throughout
Australia.
On one particular site (out of thousands) we are getting an...
mjwills1@optusnet.com.au
|
11-02-2007 12:25 AM
mjwills1@optusnet.com.au | 0 | 11 |
| | | The GetSchema documentation hurts, specifically:
"Understanding the Provider-Specific Schema Collections"...
uncaged
|
11-01-2007 03:07 PM
DRB | 4 | 30 |
| | | I have an application that allows the user to enter any number of (SQL
Server) select statements in a text box, execute the "script" and work...
TBQ
|
11-01-2007 02:41 PM
TBQ | 0 | 13 |
| | | Fastest way to move XML document into and back out of CLR function
In SQL Server 2005 and Visual Studio 2005, what is the fastest way to pass
an xml...
DR
|
11-01-2007 12:21 PM
William Vaughn | 1 | 7 |
| | | Oct 30, 2007
Hi all
Using VB.Net 2005 & SQL 2005.
I tried to use a database on my local PC and a remote database.
Now is there a way I can make...
Mike TI
|
11-01-2007 01:01 AM
Cor Ligthert[MVP] | 6 | 10 |
| | | Hi
Using SQLServer2005, connecting via sql server authentication.
In the Instance I created a database (MyDatabase) and a Login.
In MyDatabase I...
AReel
|
10-31-2007 11:10 AM
Mary Chipman [MSFT] | 1 | 9 |
| | | Ok, bear with me. This is a bit lengthy. This roughly explains a real-life
legacy data structure problem I’m having.
Assume a SQL Server 2000...
B. Chernick
|
10-31-2007 08:08 AM
B. Chernick | 11 | 19 |
| | | is there anything like XmlDocument.ImportNode but for SQL Server XQuery?
DR
|
10-30-2007 06:01 PM
DR | 0 | 14 |
| | | How is fastest way to construct an XML node then a bunch of slow xquery
modify statements?
This SQL Server 2005 logic is rather slow to simply add a...
DR
|
10-30-2007 03:54 PM
DR | 0 | 10 |
| | | I'm trying to use FillSchema to get the results schema for a stored
procedure that, simplified, does this:
CREATE PROCEDURE SomeProc
@Flag ...
Caitlin
|
10-30-2007 11:22 AM
Caitlin | 0 | 7 |
| | | I am using the same code to query different databases, one SQL 2005 and the
other SQL 2000. The query contains a date paremeter...
HMike
|
10-30-2007 03:57 AM
Miha Markic | 7 | 12 |
| | | hi,
is web service good solution for accesing (havily) database (remote or not)?
that looks slow, any other methods for secure connection? SOme of...
Andy
|
10-30-2007 03:55 AM
Miha Markic | 10 | 15 |
| | | hi, pls can someone help me out. its very urgent i get the solution today. i
have a webservice that i use to retrieve new record from a database,...
Toyin
|
10-30-2007 02:33 AM
Toyin | 8 | 9 |
| | | (Reposted from Winforms forum. Not sure where this belongs.)
I'm writing a Winforms project in VB/Dot Net 2.0 and I'm having some trouble
handling...
B. Chernick
|
10-29-2007 12:58 PM
Cor Ligthert[MVP] | 3 | 11 |
| | | Hi EveryBody:
What is the data type that I have to use when I want to save mix data in
database for example photos,music,text fiel,doc file and...
Husam
|
10-29-2007 12:18 PM
William Vaughn | 2 | 11 |
