How can we find a Field data types from DataReader/Dataset/Datatable in VB.net ??? For example code in VB6 where rstRecName is a recordset and j...

Vanny

05-22-2007 07:08 AM
Vanny

iTechArt Group - Custom Software Development and Offshore outsourcing Company http://www.itechart.com/ Offshore custom software development company...

VB

05-22-2007 06:10 AM
VB

Hi all, me again with a newbie question. I have this DataGridView with columns binding to a table, and then a column with checkboxes that is not...

mfrsousa

05-22-2007 01:41 AM
mfrsousa

I am using VS 2005 and a MS Access 2003 DB. In VS I use the server explorer to drag and drop tables and existing queries into the dataset...

JJT

05-21-2007 01:20 PM
JJT

Hopefully someone has experience with this type of error handling. First off I'm using VS 2005 with the 2.0 fx. I used the designer to create my...

Ryan

05-21-2007 12:59 PM
Ryan

Hello, I'm using a lot of threads, each one using it's own instance of my TableAdapter, Connection and DataTables. But all of them will access the...

rfw68

05-21-2007 12:51 PM
Jim Rand

Hi i'm using Enterprise Library for .NET Framework 2.0 january 2006 - i really like it but, i have a problem with transactions i'm trying to save 2...

fredd00

05-21-2007 12:15 PM
fredd00

Hello ! I read any articles about locking so far, but I am not able to make a solution for my project. (I really want pessimistic locking - no such...

aaapaul

05-21-2007 12:02 PM
Cor Ligthert [MVP]

Can anyone give me a simple bit of code to run on my website offering a download to excel facility from a SQL stored procedure? I know how to get the...

NeilR

05-21-2007 11:54 AM
NeilR

Hi Everyone: This problem has been plaguing me for three days, and I can’t for the life of me find a logical reason why this problem occurs. My...

Mark

05-21-2007 11:10 AM
Mark

What's the alternative to the following? void m_BindingSource_AddingNew(object sender, AddingNewEventArgs e) { MyTypedDataSet.TypedTableRow newRow =...

RipT

05-21-2007 10:35 AM
RipT

(Sorry about multi-posting this to "microsoft.public.dotnet.languages.csharp") Hi there, Does anyone know why the "ColumnChanged" event isn't fired...

Mark Chambers

05-21-2007 10:31 AM
Mark Chambers

Hey ya, Using .NET 2.0 and SqlCommandBuilder, say I have a customer row, with an address and name fields. I need 2 different clients to be able to...

KShvats

05-21-2007 09:19 AM
Kerry Moorman

Hi There, I am using the SQLHelper class and have implemented runsp, executescalar, executedataset, and executereader. I am using connection...

sljones@dodo.com.au

05-20-2007 11:56 PM
sljones@dodo.com.au

For those who are interested, I've just released a trial version of a .NET Provider for XML. Based on the successful, QueryADataset SQL engine...

Adrian Moore

05-20-2007 09:37 PM
Adrian Moore

I want to use asp.net & mysql. I am trying to download mysql db and tools from www.mysql.com but i can find everything what I need. Can somebody...

Toni

05-20-2007 01:56 PM
Mark Rae

Hi EveryBody: I made web site using asp.net 2.0 Vb.Net. The project depends on database in the local machine. The web site has • Create User...

Husam

05-20-2007 01:13 PM
Husam

Hi there, Can anyone explain the following (very) simple scenario. 1) I make an exact copy of my "DataSet" and delete one record from a given table...

Mark Chambers

05-19-2007 06:41 PM
Mark Chambers

Hello, I have a DataGridView, bound to a typed DataTable (without any TableAdapter etc.). The values of that DataTable are changed in a second thread...

rfw68

05-18-2007 03:17 AM
rfw68

Hi, I get errors when I try the following expression in my strongly typed dataset: "Sum(Parent.Child(Relation1).Value)" The error I get...

Carl

05-18-2007 01:27 AM
Carl

Hello, I wanna list my stocks in a web page according to search result, this listing must be in a (3 columns and unlimited size) table, what I wanna...

Peggy

05-17-2007 11:55 AM
Peggy

Simple problem. If the company is null, replace it with last name and first name: /* Replace null companies with last and first names */ DataView dv...

Jim Rand

05-17-2007 08:52 AM
Jim Rand

Hello, I have a (typed) dataset for some tables in a sql-server express. Well, loading the datas with Fill and sending changes to the sql server...

rfw68

05-17-2007 05:13 AM
WenYuan Wang [MSFT]

"Frans Bouma " <perseus.usenetNOSPAM (AT) xs4all (DOT) nl> wrote Perhaps this is a normal Dutch word ;-) -- Miha Markic RightHand .NET consulting...

Deanna

05-17-2007 02:20 AM
Miha Markic

Hello, I have the situation that many users on the same db , table have access and make changes. Ok for this there is optimistic concurrency. So I...

Rolf Welskes

05-16-2007 07:45 PM
Mary Chipman [MSFT]

I have a form called frmSales which has three datagridviews on it which are linked to a Cinema.mdb database using SQL. The first datagridview...

Catnip

05-16-2007 01:08 AM
Catnip

Hi I am having trouble with a Cinema System I am creating in VB.NET. I have a form called frmSales which has three datagridviews on it which are...

Catnip

05-16-2007 01:07 AM
Catnip

Hi,all I met one problem of connecting Access database in asp.net web program. I use ODBC link to Access, the connection string...

Randy

05-15-2007 08:32 PM
Randy

Hi I created an xsd file by assign a sample xml file to the xsd.exe tool I opened the xsd file in the vs 2005(designer) and saw that the...

Nay

05-15-2007 12:31 PM
Nay

We have a web application that calls a business/data layer to do database updates. There is a lot of coordination in the web page to handle id's...

Jay Drozd

05-15-2007 11:10 AM
Jay Drozd

Hi, Since there *appears* to be no 64-bit support for any data source other than SQL Server (and I wouldn't use OleDb to interface with SQL Server...

Mark Rae

05-15-2007 04:58 AM
Mark Rae

the sp_help command doesn't return descriptions as far as I can tell. Any other ideas? -- thanks -...

DavidThi808

05-15-2007 04:56 AM
WenYuan Wang [MSFT]

Hi, I have a problem to call a stored function with a C# application. I have tested the function directly on Oracle Server and the function is well...

Gandalf

05-15-2007 03:56 AM
Gandalf

I'm using OleDbDataAdapter to update records to the Access database. Refer to the "Introduction to Data Concurrency in ADO.NET" topic in MSDN: "The...

pedestrian

05-14-2007 04:35 PM
pedestrian via DotNetMonster.com

Hi, I'm using DataTable.Merge() to merge values from a source DT into a destination DT which are in seperate Datasets. The source DT has columns...

eran

05-14-2007 10:43 AM
Manish Bafna

Hi, I need to transfer data from a .dat file to different tables in SQL DB. After the transfer i need to rename the .dat file appending ...

Rocksie R

05-14-2007 07:12 AM
Rocksie R

Hi,all I met a strange problem, I connected to access database using oledb connection, connection string...

Randy

05-14-2007 03:01 AM
Randy

Hi, I am using an Access DB and a datareader to retrieve a memo field. When I execute the following code the datareader only ever returns the first...

Jason James

05-14-2007 02:17 AM
Jason James

Hello, I have the following: a form, a datasource, in the form I have tabs, menus, listboxes, a datagridView and textboxes. All is bound to the...

Rolf Welskes

05-14-2007 01:35 AM
WenYuan Wang [MSFT]

Excellent articles/material for web application (ASP.Net). Complete reference available all in one place. You should visit following URL for vast...

micke.hale@gmail.com

05-13-2007 08:48 AM
micke.hale@gmail.com

Hi I have a vb.net app that opens an access database runs several sql action queries on the tables and closes the db. This is done every few...

John

05-13-2007 01:12 AM
Mark

Is there a way to query an in-memory dataset with sql or can you only work with the individual table through DataTable.Select()? How can you go...

deciacco

05-12-2007 09:00 AM
Adrian Moore

I have a TypedDataSet whose source tables live on a SQL Server. The DataTables in the TypedDataSet have lots of customized TableAdapters to execute...

michael

05-12-2007 08:43 AM
michael

Do somebody know how to connect to CFront 3.01 from a Windows Mobile, Using Visual Basic .net 2003 ? or a tool data acces to Cfront?

Miguel Arenas

05-11-2007 04:30 PM
Miguel Arenas

Is it possible to do a Group By in the Select method of the DataTable object?

Doug

05-11-2007 03:14 PM
Teemu Keiski

Hi, I am wondering how I could populate the ampty table in the database from the DataSet or DataTable. So far I am using SqlBulkCopy. Is there any...

Lubomir

05-11-2007 12:34 PM
William \(Bill\) Vaughn

VS2005 C# 2.0 I'm using ADO.NET and the Jet 4.0 OLE DB provider to append a row to an Excel spreadsheet. I have a data table of type...

Jim Walsh

05-11-2007 12:08 PM
Jim Walsh

Hi, I have a stored procedure, for example like the following: Public static void MyProc() { using ( SqlConnection conn = new...

Lubomir

05-11-2007 10:27 AM
Lubomir

Hi everybody, In last month I'm experiencing a very strange problem and I think it's linked to ado.net. My team and I developed a lot of...

emanuele.falchero@gmail.com

05-11-2007 02:52 AM
emanuele.falchero@gmail.com

I am having problems with the table adapter not updating (inserting a new record) the sql server table if I open the form with out any records...

Brooke

05-11-2007 02:03 AM
Miha Markic