| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
|  | I know how to call Update stored procs from LINQ.
How do I return one or multiple cursors from a stored proc in LINQ?
--
Arne Garvander
(I program...
Arne Garvander
|
05-13-2009 07:06 AM
Patrice | 1 | 27 |
|  | I have a few SQL scripts that need to be executed on an Oracle DB server.
They each contain multiple SQL statements that contain ALTER TABLEs,...
sp00nyG
|
05-12-2009 02:49 PM
Ray | 2 | 49 |
|  | Hi.
I use Sql server 2005 and have a table in the database that looks something
like this.
Orderline
Id | Text | SeqNo
1 Text1 1001
2 ...
Kai
|
05-12-2009 01:45 AM
Kai | 0 | 26 |
|  | Every LINQ example I have seen returns an IQuerable<T> . I am expecting a
single discret value or a miss match. How do I retrieve a single record...
Arne Garvander
|
05-12-2009 12:14 AM
Cor Ligthert[MVP] | 1 | 27 |
|  | Is there a way in ADO.NET to get a list of system DSNs on a machine
similar to calling the ODBC API SQLDataSources()?
Thanks in advance for any help.
nltoft
|
05-11-2009 07:52 PM
nltoft | 0 | 25 |
|  | Hi,
I have a web server on a SBS 2003 box, and SQL server running on
seperate Windows Server 2003 box.
I want to impersonate the current user when...
misterhodes@googlemail.com
|
05-11-2009 04:02 AM
misterhodes@googlemail.com | 0 | 31 |
|  | How to show all rows in the datagridview from a collection? When I try to
populate the datagridview from a list(of T) collection, I can see many...
Vanny
|
05-09-2009 01:05 AM
Cor Ligthert[MVP] | 4 | 36 |
|  | Trying to write a routine to take bytes from a text field and put them into a
file.
I am using VS 2003 and SQL 2005. I created a table called...
Hotwheels
|
05-07-2009 11:29 AM
Cor Ligthert[MVP] | 9 | 32 |
|  | My stored procedure has several input parameters, all of which have
default values. In Query Analyzer you can of course run the procedure,
providing...
Zamdrist
|
05-07-2009 11:17 AM
William Vaughn \(MVP\) | 2 | 25 |
|  | I've got an application that makes a connection to a database, using a
connection string stored in the application configuration...
Jason Barnett
|
05-06-2009 02:40 PM
Jason Barnett | 0 | 22 |
|  | I am wanting to know the most effecient way of converting a datrow to a
hashtable.
Many thanks if you can help
Kind Regards
Tony
Tony Yates
|
05-06-2009 01:15 PM
mark | 6 | 37 |
|  | I've been unable to find any information on this:
If I create a SqlTransaction object with a using block, is calling Rollback
completely necessary...
Jonathan Wood
|
05-06-2009 10:03 AM
Jonathan Wood | 2 | 33 |
|  | Hi,
I have a MS Access Tables with over 40 tables, some tables have only 10 row
and some of the tables have around 2000 row. All the table have same...
Niyazi
|
05-06-2009 12:07 AM
Niyazi | 1 | 26 |
|  | I'm experiencing a strange issue with a .NET service I've written that
uses Entity Framework. It creates a new Client entity in my SQL2005
database,...
David Keaveny
|
05-01-2009 06:38 AM
Mark | 1 | 38 |
|  | Is there a wizard that creates (insert, update and delete) stored procedures
for tables (Entity Framework).
As tables are modified, their stored...
Russ Sherlock
|
05-01-2009 05:06 AM
Mark | 1 | 20 |
|  | I added an ADO.NET Data Service to my ASP.NET website and changed the
DataService class name to the class name from my ADO.NET Entity Data Model
but...
Ben M
|
04-30-2009 02:11 PM
Ben M | 0 | 24 |
|  | I have an annoying and, thus far, untraceable error in a large VB.net app I
have developed.
My problem started several months ago while using...
taffholter
|
04-28-2009 12:41 PM
Jesse Houwing | 2 | 18 |
|  | We have a VB.NET desktop app which is installed on 20 workstations and
connects to a SQL 2000 database on a std W2K3 domain. Recently we have
started...
Geoff
|
04-28-2009 12:24 PM
Cor Ligthert[MVP] | 9 | 24 |
|  | Good afternoon all.
I am using an ODBC Adapter (Acomba) and have setup a system DSN. I am using
C# to use a connection string such as DSN=Acomba...
Simon
|
04-28-2009 11:13 AM
Simon | 0 | 17 |
|  | Hi,
I'm having trouble updating an Oracle database table using SqlDataSource and
a Gridview when I include a date field. It works fine without the...
Mike J.
|
04-28-2009 09:53 AM
Mike J. | 0 | 20 |
|  | Hi there,
I have a form with a couple of tabs on in and I'm filling the form from a
dataset with the fill method. I am using a currency manager for...
Manuel Canas
|
04-26-2009 03:07 AM
Lalit Dwivedi, Cybage, Pune | 6 | 55 |
|  | I have a DataTable with a column named "MyColumn (Something)". When I use the
following code to select the column with a value of "abc"
string...
Roy
|
04-25-2009 03:11 PM
Srinidhi | 3 | 21 |
|  | Hi
I have a SQL table that has a field "Customer_Id". This is a bigint and it
is an Identity field with an auto increment of 1. The other fields...
Roy Thompson
|
04-25-2009 03:04 PM
Srinidhi | 2 | 25 |
|  | I have an ADO.NET Entity Framework generated query which seemed a bit
slow, so I ran SQL Profiler and confirmed that the query was taking
12-13...
Dereck
|
04-24-2009 04:20 PM
Travis75 | 2 | 35 |
|  | Hello Everybody,
I now am building a solution based on VSTOv3, to build a word document to
access Dynamics CRM Data view, and print out the...
Philippe
|
04-24-2009 11:52 AM
Philippe | 2 | 20 |
|  | Frans,
Couple of quick clarifications. I am using MS provider for oracle and
ODP.NET.
Thanks,
Ram
Ram
|
04-24-2009 09:55 AM
rod | 9 | 38 |
|  | I am using vb.Net 2008, SQL Server Compact 3.5, and a DataGridView control. This is an occassionally connected application. I am populating the...
Michael P
|
04-23-2009 12:33 PM
ChrisC | 4 | 49 |
|  | When i have an entity in my database that has a '/' in the key field entitys
that exist beneath it have malformed href attributes for...
jonathonP
|
04-21-2009 10:16 AM
jonathonP | 0 | 19 |
|  | Hi,
I'm trying to convert a code from 'linq to sql' to 'linq to entities' and
I'm facing the problem when I'm trying to substract two datetime...
Trebor
|
04-21-2009 09:37 AM
Trebor | 0 | 13 |
|  | I stumbled into a rather strange problem:
private void Fetch()
{
using (SqlConnection connection =...
Jonny Bergdahl
|
04-21-2009 04:20 AM
Jialiang Ge [MSFT] | 17 | 80 |
|  | No but you can use @Family, however it is nothing more then ?.
Like you wrote being the unnamed placeholder that are distinguished by...
RICK
|
04-20-2009 04:28 PM
Cor Ligthert[MVP] | 6 | 18 |
|  | Hi,
I'd like some advise on the following.
I'd like to construct a dynamic query using parameters like:
SELECT @Param1 = Field1, @Param2 = Field2...
Martin
|
04-20-2009 03:36 PM
Martin | 0 | 17 |
|  | Trying to teach myself ADO.NET. Here is the most simple example of a hand
coded use of ADO.NET I could find
(from a SAMS book)
The Access.MDB is...
barret bonden
|
04-20-2009 01:44 PM
barret bonden | 2 | 15 |
|  | We have a problem with our Windows Service that uses SQLDependency. It has
been crashing and not going through any of my exception management...
Andrew Teece
|
04-20-2009 12:08 PM
Kenny Nguyen | 9 | 50 |
|  | I need to persist some data to SQL Server, but I can't for the life of me
figure out why I'm getting an error with each attempt.
The code I'm using...
AlBruAn
|
04-20-2009 11:49 AM
AlBruAn | 4 | 17 |
|  | Hi,
We've just tried to release an app that uses JET to access data on
Excel 2003. Unfortunately we've discovered that our test server was at
SP1...
JimLad
|
04-20-2009 10:23 AM
sloan | 10 | 94 |
|  | Not a real problem, application runs, but weird thing :
the column order in the dataset (at design time) for a tableadapter,
is not the same order...
Screaming Eagles 101
|
04-20-2009 08:24 AM
Cowboy \(Gregory A. Beamer\) | 1 | 42 |
|  | Okay, I give up: how and when does the partial method <table>::OnLoaded() get called within LINQ to SQL? I should think a query...
Mark Olbert
|
04-19-2009 08:36 PM
Lingzhi Sun [MSFT] | 2 | 38 |
|  | In the following code you will note a select statement that says "SELECT *
FROM WebQry_List". The MS Access query needs a single parameter passed to...
RICK
|
04-18-2009 09:30 AM
RICK | 6 | 21 |
|  | I've been browing some of the .Net framework code with reflector and
I notice that defaults values for dates are often initialize with...
Aeden Jameson
|
04-17-2009 02:30 AM
aeden.jameson@gmail.com | 2 | 29 |
|  | Just a newbie question: we are referencing an ado.net dataservice in our
application. When we are debugging and watching the service reference...
CGatto
|
04-16-2009 07:59 AM
CGatto | 2 | 37 |
|  | What are the disadvantages of unsafe build option when the code contains
no unsafe code? why is it not enabled by default?
--
Using Opera's...
DR
|
04-15-2009 04:31 PM
Bill Yanaire | 2 | 41 |
|  | Hi,
I'm writing a web application using Scott Mitchell's Data Access Tutorials
as my principal guide.
In my BLL I'm trying to write a AddGiftItem...
Tamer Ibrahim
|
04-15-2009 09:28 AM
NitRaGs | 2 | 52 |
|  | I'm using a SqlCommandBuilder to construct an insert command using the
GetInsertCommand().
The command builder doesn't change the parameter's...
Darren
|
04-14-2009 12:56 PM
Darren | 3 | 36 |
|  | Hi;
I do the call:
using (OdbcConnection conn = new OdbcConnection("Driver={Microsoft
dBase Driver...
David Thielen
|
04-14-2009 01:52 AM
Lingzhi Sun [MSFT] | 1 | 40 |
|  | Not needing disconnected data, and still somewhat fluent in DAO/ADO I've
played with both in .NET. Can't seem to be able to add a record; too much...
barret bonden
|
04-13-2009 11:39 PM
Cor Ligthert[MVP] | 5 | 33 |
|  | SqlConnection.Open() uses which provider by default ? ( in the case that
no provider is specified in the connection string )
Thanks.
John A Grandy
|
04-13-2009 06:57 PM
John A Grandy | 1 | 35 |
|  | Hi
Are there any code generators that help reduce the code that needs to be
written for an ado.net/winform app? Any recommendations would...
John
|
04-13-2009 11:40 AM
gillardg | 6 | 44 |
|  | Hi
I have VS2008 installed. I now need VS2003 to open and old project. Is it OK
to install VS2003 when VS2008 is already installed on the...
John
|
04-13-2009 10:13 AM
Alex O. | 4 | 64 |
|  | Ok, this is driving me crazy. Just getting started with Entity Framework
and Linq to Entities. I have a simple three table example:
Cases (has...
CGatto
|
04-11-2009 05:01 PM
CGatto | 0 | 31 |