I have an AFTER INSERT trigger on my MSSQL 2008 database table. Using SSMS, I can insert and the trigger fires and all is fine. If I use my...

SnapDive

07-07-2010 09:16 PM
SnapDive

when i am retrieving data from excel sheet using data adapter the first row of the excel is missing in the dataset From...

RAHUL

06-22-2010 01:28 AM
RAHUL

Hi. How does Linq to Entities deal with schemas? Say I have two schemas in SQL Server, Notes and Tasks. Both schemas have a table with the same...

RBScheer

06-16-2010 09:39 PM
RBScheer

Hello; I've got a problem where DataSet.Merge is causing duplicate records, and then throwing a constraint failure exception because of...

Derrick

06-03-2010 01:30 AM
Richard Cooke

I have a stored proc that returns multiple result sets. I have created a partial class on my Linq-to-SQL DataContext so I can get...

SnapDive

06-02-2010 12:03 PM
Patrice

I originally posted this to the dotnet.language.vb ng by mistake. Really belongs here. using vs 2008 I have a MS SQL stored procedure that uses #...

Keith G Hicks

06-01-2010 09:18 AM
sloan

I got an error when I run a LINQ query "LINQ to Entities does not recognize the method 'Double Abs(Double)' method, and this method cannot be...

Roy

05-29-2010 03:23 AM
Miha Markic

What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft...

nntp@microsoft.com

05-28-2010 12:02 PM
nntp@microsoft.com

I've got some code written for an Access/Jet database which I am now trying to get to work with SQL Server. The following syntax does not appear to...

Phil

05-26-2010 10:29 AM
Phil

What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft...

nntp@microsoft.com

05-21-2010 02:43 AM
nntp@microsoft.com

Which was good working with the ADO.Connection object. How me to find out the dbtable's field type? (Text or Memo) for the Access DB. How to examin...

Ivan Abramov

05-20-2010 01:58 AM
Ivan Abramov

Have a sql server table (with only read permission) Now i have create a blank access table with the same structure(fields and an have formated each...

gssitaly via DotNetMonster.com

05-19-2010 04:27 PM
gssitaly via DotNetMonster.com

Have a sql server table (with only read permission) Now i have create a blank access table with the same structure(fields and an have formated each...

gssitaly via DotNetMonster.com

05-19-2010 04:27 PM
gssitaly via DotNetMonster.com

Have a sql server table (with only read permission) Now i have create a blank access table with the same structure(fields and an have formated each...

gssitaly via DotNetMonster.com

05-19-2010 04:27 PM
gssitaly via DotNetMonster.com

I am receiving an error message when trying to connect to a SQL CE 3.5 database: "Unable to load the native components of SQL Server Compact...

Sergio Torres

05-19-2010 08:14 AM
sloan

I'm new to C#. I noticied that if I bind a formview to an SQL table, when I click update all fields are updated, and not only those that are visible...

Gaspar

05-17-2010 06:00 AM
Gaspar

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

05-15-2010 06:35 AM
sindhu Mayappa

Hi I had a winform db app in fw 1.1 which loaded pretty quickly. I have rewritten same app in fw 3.65 but it takes a long time to load. The...

John

05-14-2010 01:33 AM
Michel Posseth [MCP]

Is there a documents which outlines best practicies when coding ado .net with sql server? Thanks in advance

RG

05-04-2010 03:39 PM
RG

Here is a LINQ that works but takes over three minutes to execute: var customerOrders = from customer in dc.Customers join order in dc.Orders...

Siegfried Heintze

05-04-2010 03:30 PM
vanderghast

Hi everyone, Does somebody knows what should be installed on Windows mobile to get ADO components working? I have a problem with Windows mobile 5.0,...

Jamal Samedov

05-04-2010 07:50 AM
Jamal Samedov

Hi All, Is there any way to get rid of the hundreds of CS1591 'Missing XML comment for publicly visible type or member' warnings on...

Corey Wirun

05-03-2010 12:05 PM
Mark Kamoski

I finally figured out how to implement a doubly nested one-to-many query on the northwind database using LINQ. Wow! Printing out all the Customers...

Siegfried Heintze

05-03-2010 10:01 AM
Martin Honnen

Hi. I have WebService that reads data from Access2000 db and returns untyped datasets. As I see there is no difference between Text and Memo fields...

Ivan Abramov

04-30-2010 05:56 AM
Ivan Abramov

Hi, I have an issue with filling datatables from ADO.Recordset. May be somebody had an experience or clue with this behavior, please, share your...

Jamal Samedov

04-28-2010 05:25 AM
Jamal Samedov

I have a long running sql transaction ~10 minutes, ~20000 records deleted/inserted. Everything is fine but at the very end when...

serg

04-27-2010 01:09 PM
Haseeb Khan

Hi all, I am doing a windows mobile project that uses ASP.NET web services. Web service returns dataset-s that are pulled from database and later...

Milo

04-27-2010 05:49 AM
Jamal Samedov

Is there any way to specify an initial filter for the ObjectSet properties of an ObjectContext ? I have the situation where I know at the time of...

gerry

04-26-2010 05:29 PM
gerry

Hi. I'm kinda new with ADO .NET. I'm having trouble saving edit and delete changes back to the data source. Adding new record is fine. Only edits...

rarahim

04-23-2010 11:34 AM
rarahim

I use ADO.NET Entity Data Model to generate code. I have two stored procedures with complex logic. They return tabular records that are...

Roy

04-20-2010 04:51 PM
Mike Schuch

Hello, AFAIK SQL Server Compact is easy to deploy and has support for Entity Framework. So if the requirement is to use a database but avoid...

Gislain

04-19-2010 06:36 AM
Patrice

Hi, Is it possible to use EF with XML file instead of SGBDR ? Best regard Gislain

Gislain

04-15-2010 09:11 AM
Gislain

We need some help on the recommended process to log users that open Word and Excel through Terminal Services. Are there any reporting tools with...

Jeff

04-14-2010 04:18 PM
Jeff

I was afraid of that. I have Visual Studio 2008 Standard Edition. I just tried to download and execute both "the download LINQPad.exe" and "the...

Siegfried Heintze

04-11-2010 10:56 PM
Joe Albahari

Atendiendo a las peticiones de los usuarios finales y distribuidores, estamos encantados de confirmar que el apoyo WBFS se incluirán en Wiikey...

wiikeyfusion

04-07-2010 08:43 AM
wiikeyfusion

If I have a thread that running a long query, is it possible for a different thread to cancel the query? I am using SQL Server and C#. I have tried...

Big Daddy

04-05-2010 04:35 AM
Dawid £aziñski

"Gregory A. Beamer" <NoSpamMgbworld (AT) comcast (DOT) netNoSpamM> kirjoitti viestissä:26F96CC8-F290-4523-854B-9549121815B6 (AT) microsoft (DOT)...

John

04-02-2010 01:42 AM
Risse

Hello, My question is quite straightforward: How do I get the parent row of a deleted (child) row. If I use the method "GetParentRow" of the child...

WiZZiX

03-25-2010 03:18 AM
Vincent

I'm an experienced programmer with limited database development. Most of my database work involves using query strings or stored procedures or to...

Jonathan Wood

03-23-2010 10:20 PM
LovalvoB

I've been trying to write a Data Provider over some custom data that we have. I've managed to write them in the past (connection, command, etc) and...

LovalvoB

03-23-2010 09:39 PM
LovalvoB

Hi I am using below code to automatically generate commands via command builder. QuerySt = "SELECT <fiedl list> FROM ..." CompanyAdapter = New...

John

03-23-2010 12:34 PM
Reece Laurie

Hi. I can't unserstand how startRecord works; i think there is a problem. I'm using maxrecord=5. If i put zero 0, the dataset is filled with all...

merco

03-22-2010 03:29 AM
merco

Hi Is it possible to check in .net; 1. If sql server 2008 express is installed on a machine? 2. The name of sql server 2008 express instance or...

John

03-20-2010 06:45 PM
Michael Coles

Hi I have a winform app with sql server backend. How can I create a deployment package which when run by the end user does the following; 1....

John

03-19-2010 03:12 PM
kevinp

On 17/03/2010 in message <6015D9B1-AC9B-40C3-B9E2-4F1BBEFFD390 (AT) microsoft (DOT) com> Gregory A. Beamer wrote: I've gone for a master lease...

Jeff Gaines

03-17-2010 05:03 PM
Jeff Gaines

Hi I added a setup project to a winform vb.net app which otherwise builds fine. Once the setup project is added to the solution, however, the build...

John

03-16-2010 04:56 AM
Cor Ligthert[MVP]

We have a business layer which is compiled as a dll and used across several linked websites. Some of the website pages have search panels with a...

NeilR

03-12-2010 04:36 AM
NeilR

Hi I am running below statement repeatedly with different SQL; QuerySt = "SELECT * FROM ... " CompanyAdapter = New OleDbDataAdapter(QuerySt,...

John

03-11-2010 11:21 AM
John

Hi, the asp.net app have to communicate with MSSQL and IB DBs. Because IB is ours desktop ERP/Delphi and MSSQL is web (aspnet). IB is 3rd comp. .net...

Paulo

03-10-2010 07:33 PM
Paulo

DBTYP.NET Studio 2010 - Database Comparison Suite Released Vienna, Austria - March 8, 2010 Today, BYPsoft announced the availability of DBTYP.NET...

03-10-2010 01:16 PM