I've developed an ASP.NET application to work with SQL Server 2005, using an Application Role. All seemed to work fine at first, until I started...

Jason Barnett

Today 02:09 PM
Jason Barnett

With SQL Server, I can create a connection string to a remote server using an IP address such as: "Data Source=190.190.200.100,1433;..." where 1433...

Ron Fluegge

Today 12:59 PM
Moksud

Hello Everybody, I want to get next autonumber(indentity) value for row to be inserted in a table within a transaction of MS Access, In VB6, I can do...

Guramrit Singh

Today 07:48 AM
Patrice

許多性能å•�題和安全性您的計算機é€*æˆ�惡æ„�病毒，最好的辦法å°�付，這是得到承èª�和防病毒在計算機上安è£�æ›´æ–° æ...

antivirus gratis

02-01-2010 06:34 PM
antivirus gratis

Hello, I want to run a script with the ExecuteNonQuery method of a Microsoft.SqlServer.Management.Common.ServerConnection instance It seems that...

Fred

01-31-2010 11:38 PM
Fred

I have set pause to microsecund. I have Microsoft Development Environment 2002 (ver.7.0.9466) and .NET Framework 1.0 (ver 1.0.3705) and Stopwatch...

alfa

01-31-2010 05:57 PM
Alexey Smirnov

Hi all, I try to generate a little application to export Data to an excel sheet. First it looks really nice, because it's write the data to the...

Andre Grumbach

01-29-2010 02:21 PM
Miro

hi, i want to write a function which will check if the table exists in the database or not. the thing i want this function to work in any...

Vishal Dattani

01-26-2010 10:02 AM
VIDHI DATTANI

"Gregory A. Beamer" wrote: Thanks for the link. I searched high and low and could not find an article on how to deal with an identity column...

John Brown

01-25-2010 12:30 PM
John Brown

Hi All, Im new to Oracle. I have a Rowtype and i want to Loop through that Rowtype without mentioning the Column name. My code as below...

FB

01-20-2010 10:09 AM
FB

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...

Mia

01-19-2010 10:35 AM
Mia

This has probably been asked and answered, so, I apologize if so. Please point me to any links that might already answer this, if so... We have a...

ToHellWithUGA

01-18-2010 07:36 AM
John Brown

Many computer problems are caused by viruses and malware your computer. The best and easiest way to correct this is to use recognized antivirus...

antivirus gratis

01-16-2010 08:08 PM
antivirus gratis

I'm learning about Entity Framework (both 3.5 and beta 4.0) but cannot seem to find anything on the web explaining how to manage ACID-ic properties...

Geoff

01-13-2010 05:18 PM
Jesse Houwing

"Gregory A. Beamer" <NoSpamMgbworld (AT) comcast (DOT) netNoSpamM> wrote Hmm - maybe... Need a proof reader / technical editor...? ;-) --

Fanor P.

01-11-2010 11:01 AM
Paul

Hello, everyone I use Access2003 create a database such as db1.mdb. without set login password. My web application can access it well But after I...

haiwen

01-11-2010 09:42 AM
Mark Rae [MVP]

"Gregory A. Beamer" <NoSpamMgbworld (AT) comcast (DOT) netNoSpamM> wrote Indeed. I favour the using (...) structure, but that's nothing more than...

JohnE

01-07-2010 05:37 PM
Mark Rae [MVP]

http://www.dogbreedss.org/puppy-names.htm structural diseases health disorders of dogs - causes, symptoms and...

Dino M. Buljubasic

01-07-2010 08:44 AM
switrm

Are there any other .net data providers for the entity framework, other than SQL Server? I am looking for an ODBC and MS Access driver that will...

eg

01-05-2010 11:13 AM
Mary Chipman [MSFT]

Try this string AFilterExpression="Firstname like '" + txtName.Text + "'"; mydst.Tables.DefaultView.RowFilter = AFilterExpression; -- Abdul Sami

I want to use like query with dataview.

01-02-2010 08:36 AM
Abdul Sami

Hello Everybody, I want to connect to sql server in readonly mode so that any DML/DDL query cannot be executed. It's possible in Access Database...

Guramrit Singh

12-31-2009 09:07 AM
Mark Rae [MVP]

http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the above web page, but basically, its a very ambitious project...

Mia

12-21-2009 05:55 PM
Blanche Starinski

Hi, I need to develop a system of batching up a load of outstanding orders based on how many people we have working and how many hours, etc.. The...

JohnnyD

12-18-2009 03:51 PM
JohnnyD

Jason Wilson (wilsonj (AT) ausrad (DOT) com) writes: Having seen the procedure, I am not surprised that it runs slowly. I am more surprised that it...

Jason Wilson

12-16-2009 10:39 AM
sloan

I have the following code: Dim strSubmittalRatesSQL = "select distinct v.," & _ "(select MAX() FROM (" & _ "select top 50 percent ((t1.-t1.)/t1.)*100...

Paul Blevins

12-15-2009 10:52 AM
Nathan Sokalski

I have a project that has been upgraded from .Net 1.1 to 2.0 and I cannot get the UpdateRowSource.FirstReturnedRecord of the InsertCommand to...

tommaso gobbato

12-14-2009 04:48 AM
tommaso gobbato

Hi all, sorry for my bad english. Is it possible to create an association between two tables the reside in different models? Thanks Bye

Tirzan

12-11-2009 08:58 AM
Tirzan

I have a query that returns a datatable in C# from Oracle. I have done everything to make sure the queries column is a integer, but for some reason...

John G

12-11-2009 05:58 AM
Paul

Greetings, To clear the air, I am a hardware guy and not a software guy by nature. However, need to learn some basics quickly. We have a Sql...

Chris

12-09-2009 03:52 PM
Chris

I understand the ColumnMappings mechanism, but I have a problem with this kind of request : "SELECT c.*, o.* FROM Customers AS c INNER JOIN Orders AS...

Michel Jallet

12-09-2009 04:20 AM
Michel Jallet

I have a query that returns a datatable in C# from Oracle. I have done everything to make sure the queries column is a integer, but for some reason...

John G

12-03-2009 04:40 PM
John G

I have a query that returns a datatable in C# from Oracle. I have done everything to make sure the queries column is a integer, but for some reason...

John G

12-03-2009 04:40 PM
John G

Hi all, having a DataReader populater with an Excel file, how can add a column with a fixed value to it? For example, having DbDataReader dr =...

Luigi

12-03-2009 08:44 AM
Mark Rae [MVP]

Hey there.. Plz... I'm having this huge doubt... I have a datagridview which is bound with a dataset with data from SQL server. After the grid is...

Christiano

11-27-2009 12:37 AM
Cor Ligthert[MVP]

Hi, I'm a VB6 programmer (over 12 years). I've experience in ADO (SQL200X, Oracle, Access), but not in .NET. Can you suggest me any type of...

Antonio Liberal

11-24-2009 04:27 PM
Cleo Baines Hafsteder

Beverly Hills Locksmith Company 1-310-925-1720 24/7 Locksmith San Fernando Valley 1-818-386-1022 24/7 Locksmith Los Angeles Hollywood...

lifeine

11-24-2009 04:26 PM
Cleo Baines Hafsteder

The database I use is SQL Server 2005. The user to login database is 'PG_TestUser', it has 'dbo' schema, and it has datareader and datawriter...

George Shui

11-24-2009 01:46 AM
SM

Doing some testing with Entity Framework, I have been able to get POCOs to save using the public Properties. Now I am trying to switch from...

tobiwan_kenobi

11-23-2009 05:35 PM
tobiwan_kenobi

There appears to be a very serious bug in the BindingContext's position handling code. When a BindingContext object is based on a DataView, and a new...

Mark Olbert

11-23-2009 01:34 PM
johnyxx

Greetings, I have a datagridview which is created progmatically and all but two of the columns (both DataGridViewCheckBoxColumns) are bound columns...

Rob W

11-22-2009 05:51 PM
Rob W

I have two objects with different types (Order and OrderDetails for example). I retrieve them seperately through edmx data model so they were...

Roy

11-20-2009 11:17 AM
Roy

On Tue, 17 Nov 2009 07:18:28 -0800, "Gregory A. Beamer" <NoSpamMgbworld (AT) comcast (DOT) netNoSpamM> wrote: Thanks for the cogent reply, Greg. I...

Eric

11-18-2009 01:50 PM
Patrice

Hi, Very new to Silverlight and am having a bit of difficulty. Hopefully I can explain this correctly! I have a databound accordion. In each of my...

Daniel

11-18-2009 11:33 AM
Daniel

IBM's ADO.NET provider extends the MS System classes and, while overriding some of the implementation, in a lot of cases relies on the MS...

Reece Laurie

11-18-2009 06:14 AM
Colbert Zhou [MSFT]

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on...

Mia

11-17-2009 11:09 AM
Mia

The question of how to import a text file into the database table has been asked many times. The code that suits me was given by Paul Clement is the...

AT

11-14-2009 09:09 PM
Leonid

Does SqlReader.GetBytes() reliably always return the total number of bytes in a varbinary column ? // establish sqlReader using ( sqlReader...

John Grandy

11-13-2009 04:35 PM
John Grandy

Hi, is there a way how to connect to SQL Server from Windows Forms, when Windows Authentication Mode is set and client (application) runs on a...

Lubos Hladik

11-11-2009 04:40 PM
CSharpner

Hi, I'm trying to configure a TableAdapter with an SQL statement fo the form: Select * from SomeTable where ID IN "1,2,3,4"; Can I do this with a...

Terry Wahl

11-07-2009 12:24 AM
William Vaughn \(MVP\)

Imagine there is a DB table: col1 col2 col3 --------------------- 1 A 10 1 B 11 1 C 12 2 D ...

Chris

11-03-2009 07:19 AM
go