Dear All I have department table which contain dept_id and dept_Name. On employee form in combo box i wont to select dept_Name in the combo box but i...

Murtaza

12-12-2007 11:46 PM
Murtaza

I am new to C# and using VS2008 and SQL 2005. For doing some exercises I have made the following code: string name = tstxtName.Text +...

Globetrotter

12-12-2007 03:09 PM
Globetrotter

Is there a built-in method in ADO.NET for reading a T-SQL script from a file and executing it step-by-step as though it were in a stored procedure?

Harlan Messinger

12-12-2007 01:16 PM
William Vaughn

I'm trying to execute two queries on a database asynchronously by using the ..NET 2.0 APM. I've created a test harness which executes two queries...

JumpingMattFlash

12-12-2007 11:35 AM
William Vaughn

Greetings, Hope u r in the best of Health and Spirits!!!!!!!!!! This is Naveen from CSI Consulting with regards to Job Opportunity...

netxure@gmail.com

12-12-2007 11:23 AM
netxure@gmail.com

Which books on 3.5 recommend? http://www.alvas.net - Audio tools for C# and VB.Net developers + Christmas discount

Alexander Vasilevsky

12-11-2007 11:48 AM
William Vaughn

I have written a small programm using vb.net. i used a dataset wich contain only one table. fields are bounded to table of dataset. I want to add new...

Murtaza

12-11-2007 03:46 AM
Murtaza

Hi all, I have some existing code that updates the database by creating a SqlCommand and SqlTransaction: public class GroupMapper { public static...

haroldsphsu@gmail.com

12-10-2007 01:10 PM
haroldsphsu@gmail.com

This issue was raised in posts from 2005 to 2007. The Feedback article dated 2005 at...

MarcG

12-10-2007 08:59 AM
jcohen68@gmail.com

We do a FOR XML query using SQLXMLReader.ExecuteXMLReader() method. The results is obtained in a XMLReader. We then load XMlDocument using...

Debasish Pramanik

12-10-2007 05:57 AM
Andrew Brook

I am looking for a SQL reference quick card that a allow in one page to know the function list of the langage. Does anyone know that ? sam

skneife@gmail.com

12-09-2007 04:29 PM
news.sbcglobal.net

Using Microsoft Development Environment 2002 v7.0.9466. In a C# ASP .Net project, we have some typed datasets defined. (inherit...

Mike

12-09-2007 07:10 AM
Scott M.

I developed my ASP.NET 2.0 web app using SQL Express. Now I'm moving it to production. On my web server I attached the SQL Express mdf database to...

Cirene

12-07-2007 09:38 AM
W.G. Ryan

Hi, I have a typed dataset that is based on a SQL view, so I have added a stored procedure to save the data (that the TableAdapater found and...

Brian

12-07-2007 09:36 AM
W.G. Ryan

I'm still trying to get a handle on ASP.NET and ADO.NET. Since there is a bit of code involved in executing a procedure, I thought I'd stick it in...

Jonathan Wood

12-06-2007 11:18 PM
Cor Ligthert[MVP]

Wowo cool thanks for the tip Fans. It is good to no the "internals" of how it works. I tried various approaches and in the end reverted to using a...

R. K. Wijayaratne

12-06-2007 09:30 PM
R. K. Wijayaratne

Okay, so based on previous discussions, I got the message I'm better off using a DataSet over a DataReader object when I want a method to return...

Jonathan Wood

12-06-2007 08:15 PM
Jonathan Wood

I need to check if a table in SQLServer 2005 is made up of one of the LOB columns :image, ntext, text, varchar(max), nvarchar(max), varbinary(max),...

sjoshi

12-06-2007 04:59 PM
William Vaughn

I am attempting to get the data that was bound to an item in a Repeater control for use in the ItemDataBound event. Here is the code I am using...

Nathan Sokalski

12-06-2007 02:45 PM
Milosz Skalecki [MCAD]

Hi ng, when I use ADO.NET 2.0 System.Data.Common.DbProviderFactories-Class to enumerate the providers it get: Odbc Data Provider OleDb Data...

Chuck Vance

12-06-2007 01:12 PM
Mary Chipman [MSFT]

I've seen this message a lot in the groups but I haven't found a solution for it yet. Our setup is SQL Server 2000 on a Windows Server 2003 cluster....

salonen@gmail.com

12-06-2007 12:38 PM
William \(Bill\) Vaughn

Using .Net Framework v1.1. I have found a couple of XML strings that cause an InvalidCastException when passed to the ReadXml() method of a typed...

MikeOtown

12-06-2007 11:15 AM
MikeOtown

I added some rows in Data table say 1000 rows from which 10 rows are invalid and to perform update in batch, set UpdateBatchSize property of...

Zeeshan Gulzar

12-06-2007 09:11 AM
Zeeshan Gulzar

I wrap two updates from different tableadapters in a transactionscope. They are connected to the same databese. By runing the program I get an...

tim

12-05-2007 08:19 PM
nhminh76

I'm using ASP.NET membership but need to store some additional data associated with users in my own database tables. (Profiles don't look like a good...

Jonathan Wood

12-05-2007 04:47 PM
Jonathan Wood

Hello to all, I would like to inserts/delete some records from a table and Update the DataAdapter at the end of all the operations. The problem is...

Dimitris Milonas

12-05-2007 02:48 PM
Dimitris Milonas

we have a VB application that we updated on a customer's machine. The customer has SQL 2005 Express (they had MSDE and we had the same error so we...

Darin

12-05-2007 01:45 PM
William Vaughn

Hello ng, I try to read a BLOB (HugeBlob) field from oracle 10g database. (dotnet-framework 1.1, 2.0) 1.) I have no chances to install / register...

Chuck Vance

12-05-2007 01:19 PM
Chuck Vance

Hi, Please find the requirement below and answer ASAP with updated resume and contact...

ronald.holzwart@gmail.com

12-05-2007 12:57 PM
W.G. Ryan

Hi I am developing an app in vb.net 2008 with sql server 2000 backend. I also need disconnected version of the app for laptop users who would...

John

12-05-2007 12:47 PM
W.G. Ryan

Hi Help a newbie!!! I am trying to copy the content of a datatable (dt) into an Access table. It seems the datatable has the data I want, and when...

Cyrille Armand

12-05-2007 12:40 PM
W.G. Ryan

hello,when i try to insert a dataSet record into another database table, what i see in the table is null values. i have test this dataset and it...

Toyin

12-05-2007 12:36 PM
W.G. Ryan

I like the new TableAdapter in .net 2005 but is there a designer-based mechanism that populates a DataSet's multiple DataTables from a...

Dick

12-05-2007 12:50 AM
S K

I am looking at Linq2Sql in VS2008 and have run into a couple of things : <Short Version> 1 - Linq To Sql designer has problems with multi-level...

gerry

12-04-2007 03:30 AM
WenYuan Wang [MSFT]

On Dec 2, 11:05 pm, Sören Nils Kuklau <chucker23n+use... (AT) gmail (DOT) com> wrote: Hi, In any case, you must have a SQL "SELECT" query, right...

coolCoder

12-04-2007 03:01 AM
coolCoder

Sören Nils Kuklau, You could use nullable types for the properties you are moving possible null values to. But code for nullable types is at least...

Kerry Moorman

12-03-2007 06:46 PM
Scott M.

Soren, Any reason that you don't want to use the defaults from the Server? You need real hug data to let that be the bottleneck at disks today. Cor

Cor Ligthert[MVP]

12-03-2007 12:00 PM
Cor Ligthert[MVP]

Hi What are the vb.bet equivalents of the following; 1. Scripting.FileSystemObject ie a method to read text files 2. Dlookup...

John

12-03-2007 11:57 AM
Cor Ligthert[MVP]

I went through the VB2005 UI and create a DataSet and I create a DataAdapter with the set of queries that I want to be able to run. One of my...

OldButStillLearning

12-03-2007 10:49 AM
OldButStillLearning

Hello, I have an ASP.NET web application that connects with a Informix 10.x data base using the Informix .NET Provider developed by IBM. Does...

Farelli

12-03-2007 10:28 AM
Farelli

How about not looping through the rows in the first place and just querying the DataTable using the select method? "Sören Nils Kuklau"...

Scott M.

12-02-2007 04:47 PM
Scott M.

2 months I had first page organic results and they delivered on every key term I wanted so here they are...

ekqhqg32

12-02-2007 06:34 AM
ekqhqg32

I'm sure this has been answered before, but I couldn't find the right search terms. We've all seen how a single SqlConnection can only serve one...

JonOfAllTrades

12-01-2007 03:40 PM
JonOfAllTrades

Hello folks, i am searching at this forum, but i don't found a solution. I try to fill two tables of a strong typed dataset by ONE call of...

nieurig

12-01-2007 11:24 AM
Ivailo

When working with the SQL CLR, should I be using "using" when referring to the "context connection"?

Scott M.

11-30-2007 04:27 PM
Scott M.

I have a static function in a class, everytime I call this function, I am creating a SQLconnection, open it, use it, and null it, All my functions...

Sylvie

11-30-2007 03:55 PM
JonOfAllTrades

I have a book called "Hitchhiker's Guide to Visual Studio and SQL Server". It has a chapter on using dataAdapters, and another chapter on using...

HONOREDANCESTOR@yahoo.com

11-30-2007 01:05 PM
Jim Rand

Hello, I'm a novice in .Net development (switched after 10 years Delphi). I've created a small test app with a Dataset in it. The Dataset contains a...

Harry Leboeuf

11-29-2007 09:28 PM
WenYuan Wang [MSFT]

I'm new to SQL stuff. All I have is MS SQL Express that came with Visual Studio 2005, and SQL Server Management Studio Express, which I...

Jonathan Wood

11-29-2007 07:11 PM
Jonathan Wood

How do you consume the result of a SQLCLR stored procedure when it returns a SQLDataRow? Thanks.

Scott M.

11-29-2007 06:32 PM
Scott M.