Does anyone know how I get can to the column alias in a datatable? here is an example of what I need to do. Query: select Column1 as , Column2 as ...

mohaaron@gmail.com

01-04-2008 02:20 AM
Miha Markic

I have a numeric field. Users will modify it by adding a value to it. But I'm a little concerned about the unlikely event where two users...

Jonathan Wood

01-04-2008 12:01 AM
Cor Ligthert[MVP]

Does anyone have references for using linq with INFORMATION_SCHEMA? In other words, setting up a DataContext so that one can use linq to query...

Mark Olbert

01-03-2008 01:02 PM
Mark Olbert

I am having some problems updating and inserting some SQL tables using a SqlDataAdapter and Stored Procedure. The stored procedure works...

SQLGuptaSybase

01-03-2008 05:56 AM
Cor Ligthert [MVP]

Hi All, This is hopefully a stupid question. I have a page with a details view that is bound to an object datasource. The datasource pulls back a...

Matt MacDonald

01-03-2008 05:39 AM
Cor Ligthert [MVP]

Hi VS2008. I have a table in an access database. How can I fill a list box with a column from the table? Thanks Regards

John

01-02-2008 03:25 PM
dgcarter1949@googlemail.com

I suggest reading my whitepaper on connecting. See...

shivaranjaniadimulam21@gmail.com

01-02-2008 02:22 PM
isha

When I run below sample code I get the error message "attempted to read write protected memory. This is often an indication that other memory is...

nyoussef

01-02-2008 01:34 AM
nyoussef

I'm using the ASP.NET membership routines but had to create some of my own tables to store additional user information (profiles won't work for...

Jonathan Wood

12-31-2007 05:16 PM
Jonathan Wood

Does MS SQL support LIMIT? I'd like to implement paging at the query level. Examples of this in a book I have involve temporary tables and the like....

Jonathan Wood

12-31-2007 05:12 PM
Jonathan Wood

Hi group, I've a question about calling stored procedures in LINQ queries. Here's my scenario: I have some CLR user-defined functions in a SQL...

Tekton

12-31-2007 11:03 AM
Cowboy \(Gregory A. Beamer\)

Scenario : In a single webform, I have bill data(master data like billno,date,remarks.. ) and bill details(multiple entries in a grid like item...

Esha

12-29-2007 07:35 PM
Milosz Skalecki [MCAD]

Dear all, I need to design an smart client application that can run on mulitple and plugable backend like MS SQL, Oracle or MySQL. Also the smart...

KA Kueh

12-29-2007 03:32 PM
William Vaughn

Hi; We are designing a web application where multiple companies can use it. We want to give every company access to their data, and only their data....

David Thielen

12-29-2007 03:26 PM
William Vaughn

Hi EveryBody: I have probelm that I hung with for three weeks, My problem is I want to read Binary data from database. I will told you what I did...

Husam

12-26-2007 03:22 PM
Raghu

When a DataTable is filled using something such as a DataAdapter, what values are assigned to each of the DataColumns' DataType property for...

Nathan Sokalski

12-26-2007 03:45 AM

I have used data binding in the past, but always with my own biz objects, not with a Data Adapter. I am now using the Microsoft SQL Embedded in this...

sam

12-25-2007 08:39 AM
sam

I would appreciate any comments on the following code--particularly criticism that is constructive. It is some of my first data-layer code. I felt...

Jonathan Wood

12-25-2007 02:47 AM
Miha Markic

Hi I have the below XML file. How can I read each tag and its attribute in vb.net? Many Thanks Regards

John

12-25-2007 02:36 AM
Cor Ligthert[MVP]

I have a TypedDataSet. Within it there is a QueriesTableAdapter with a bunch of Queries(stored procedures that perform updates & deletes). I need...

michael

12-24-2007 02:48 PM
michael

Hello, I have the following code to connect and query a dbf file. string cnn = @"Driver={Microsoft dBASE...

Henok Girma

12-24-2007 02:03 PM
John Saunders [MVP]

I'm working on some code that is to generate a complete DataSet given a database connection (for now only Sql). I use GetSchema on the connection to...

obiwanjacobi

12-23-2007 12:34 AM
obiwanjacobi

I'm using OleDb to connect with an Access Database. I have anywhere from 10 to over 100 records that I need to either INSERT if the PK doesn't exist...

Terry Olsen

12-21-2007 12:16 AM
Terry Olsen

I want to store some application-wide data in my database. The table that stores this will store the different data in each field, and there will...

Jonathan Wood

12-20-2007 06:41 PM
Jonathan Wood

"Ed Prochak" <edprochak (AT) gmail (DOT) com> wrote Then please explain why MS has spent a trillion $ developing LINQ. Sql Server say hello to Mr....

Steve Dassin

12-20-2007 02:29 PM
Steve Dassin

Hi, I have an server application written in .net 1.1 and I want to develop a client in .net 2.0, but when I am trying to pass a DataSet from...

buraga.sandu@gmail.com

12-20-2007 10:36 AM
buraga.sandu@gmail.com

Hi, I have two tables related to eachother, and one table has an expression-based column that states "SUM(Child.Price)". Am I able to adjust the...

benji

12-19-2007 12:13 PM
Cor Ligthert[MVP]

How to read MySQL data table from MS SQL? http://www.alvas.net - Audio tools for C# and VB.Net developers + Christmas discount

Alexander Vasilevsky

12-19-2007 10:23 AM
Cowboy \(Gregory A. Beamer\)

Hi, I have a textbox bounded thru a bindingsource to a dataset. In the dataset the bounded column allows nulls, but if i try to delete the value from...

Emil

12-19-2007 09:37 AM
Emil

How can I modify the Select statement after the Update statement in sqldataadapter ADO 2.0? (add columns) -- Igor

Igor

12-19-2007 12:44 AM
Igor

Hi, I'm using VS2008, and the dataset designer to access my SQL Server 2005 DB. I can insert a row into a table and then call the adapter to update....

benji

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

I have a DataTable with many rows. I use WriteXml to emit to an XmlWriter with an underlying StringWriter to put the final output into a string. I...

coconet

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

Is there a way to Export a Table to XML from SQL Server express ? Thanks for help. Sam

skneife@gmail.com

12-18-2007 10:53 PM
Cor Ligthert[MVP]

I am working on my first VS2008 project and using DataSet's, which I am not super familar with. I have a user table in the data set that has a first...

Cartoper

12-18-2007 10:49 PM
Cor Ligthert[MVP]

Hi, I'm trying to write a data layer for to persist regularly occuring stats to a database using ADO.NET by collecting a few records then updating...

Some Bloke

12-18-2007 06:44 AM
Some Bloke

Hello, I'm having trouble with schema-bound XML output from a dataset, in .NET 2.0. Here's an example bit of XML I'm trying to create using...

sunstormlabs@gmail.com

12-18-2007 03:47 AM
varsha.dhankani@gmail.com

I have come across an issue with XSD.exe code generation (in /dataset mode, version 2.0.50727.1432), relating to namespaces. Specifically, certain...

Marc Durdin

12-18-2007 01:51 AM
WenYuan Wang [MSFT]

Davey Simmons has bad teeth. Why doesn't he brush? Michael Lalonde saw a movie made by an axe murderer in Tokalue Michael Lalonde went swimming with...

Mike Lalonde

12-16-2007 07:56 PM
wilson.smith9@gmail.com

I've finally decided to port a Win32 application written in Delphi to C#. The program used an embedded database (DBISAM) that handled multiple...

Bruce

12-16-2007 02:21 PM
William Vaughn

Hi 1. I am filling the dataset in my form load method as; Me.MyTableAdapter.Fill(Me.MyDataSet.Clients). What about the records that other users...

John

12-16-2007 02:09 PM
William Vaughn

I have a GridView with a ButtonField. In the RowCommand I need to use the value of one of the fields used in that row. I am having trouble doing...

Nathan Sokalski

12-15-2007 06:03 AM
Phil H

Hi I have received below from someone. ..- .-. . | -.-- --- ..- | .- -. | .. -.. .. --- - | This has nothing to do with dot net but I thought a...

John

12-14-2007 10:47 AM
John

Hi, I have let's say, about 10,000 rows in a DataTable. I am looping with foreach on each row and need to update each and every row with new...

Asaf

12-13-2007 10:49 PM
Cor Ligthert[MVP]

I am using ENTLIB2.0; VS2005; and SQLServer Express on a standalone machine. Additionally we are using TransactionScope and are receiving an...

tbannon@deloitte.com

12-13-2007 06:51 PM
olja d

So, VS2008 is now available (http://www.asp.net/). One thing I'm now wondering about is how much sense LINQ makes. I've been reading of all the...

Jonathan Wood

12-13-2007 05:09 PM
Keith P

Hello, I have a question: I have 2 dropdownlists and I'd like to cascade them. In the begining they show 2 different columns of the same table. Once...

Lucas Genea

12-13-2007 05:02 PM
Lucas Genea

Hi All, I have a database with collation on Sql Server 2005, for this collation i have to use SQLOLEDB provider in my C# application because of...

Adam Right

12-13-2007 12:18 PM
Adam Right

How gets SQL-code from MS Accesss? http://www.alvas.net - Audio tools for C# and VB.Net developers + Christmas discount

Alexander Vasilevsky

12-13-2007 11:22 AM
Miha Markic

Hi I am developing a Sql Server 2005 database and using ADO.Net to access it in VC++ 2005. Is there some way of defining many-to-many...

Manjree Garg

12-13-2007 03:15 AM
WenYuan Wang [MSFT]

I have a .NET 2.0 DataTable with a ColumnChanging event. There is code in the event that tests ProposedValue and if it is "a" then the value I want...

coconet

12-13-2007 01:45 AM
WenYuan Wang [MSFT]