| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I have a FormView control with the following templates:
EmptyDataTemplate
ItemTemplate
EditItemTemplate
InsertItemTemplate
I am not using Paging,...
Nathan Sokalski
|
08-26-2007 04:26 PM
Nathan Sokalski  | 0 | 8 |
| | | Hi;
This is using the Microsoft Oracle ADO.NET classes.
Two questions on this. The first is - is there a way to call a stored
procedure, including...
=?Utf-8?B?RGF2aWQgVGhpZWxlbg==?=
|
08-26-2007 04:08 PM
=?Utf-8?B?RGF2aWQgVGhpZWxlbg==?= | 8 | 9 |
| | | I have two fields in the Datatable that I am using as my DataSource that I
need to multiply together before displaying them. Here is the...
Nathan Sokalski
|
08-25-2007 08:11 PM
Alvin Bruney [MVP] | 5 | 6 |
| | | Hi,
Using VS2005, SQL Server 2005.
The SqlError.Class property always seems to be 0 when retrieving
informational messages via the...
Stephen Ahn
|
08-23-2007 12:38 PM
Mary Chipman [MSFT] | 1 | 6 |
| | | Hi Folks,
I am having a problem reading an existing typed datatable. I am sure that I
have over looked something simple but I am not seeing the...
=?Utf-8?B?R3JheWJhbmU=?=
|
08-23-2007 11:45 AM
William Vaughn | 1 | 9 |
| | | Hi
I am successfully filling my DataSet with data using an adaptor. Prior to
calling Fill(), I regsiter handler for the ColumnChanging event of...
=?Utf-8?B?QW1pciBUb2hpZGk=?=
|
08-23-2007 10:12 AM
=?Utf-8?B?QW1pciBUb2hpZGk=?= | 1 | 5 |
| | | Take the following xml file (test.xml):
<SourceData>
<Transaction>
<ID>11</ID>
<Transaction>Insurance Loan...
duane.roelands@gmail.com
|
08-23-2007 07:45 AM
Adrian Moore | 3 | 9 |
| | | Hi,
I am beginer in ADO.Net, have such a problem.
I want to search for a row of a table or query then update data of this row.
With which ADO.net...
Nhan
|
08-23-2007 05:56 AM
Petar Atanasov | 4 | 5 |
| | | Hi!
I have an application where the client call the server over .net remoting
(tcp).
The final code to be called looks something like this:
Public...
Johan Karlsson
|
08-23-2007 04:56 AM
Johan Karlsson | 1 | 8 |
| | | I am using Merge Replication between SQL Mobile clients and SQL
Server
2000. This all works over an https connection using IIS 6.0.
This works...
JB
|
08-22-2007 09:59 AM
JB | 0 | 10 |
| | | hello,
i have a big datable of a bunch of stuff. i am interested in getting
row counts that match certain criteria.
currently i do this by creating...
SpaceMarine
|
08-22-2007 02:41 AM
Miha Markic | 5 | 8 |
| | | Carlos,
To explain what acceptchanges does.
It is probably one of the most confusing words Microsoft ever made for a
method. (We see your problem...
Cor Ligthert[MVP]
|
08-21-2007 11:17 PM
Cor Ligthert[MVP] | 0 | 9 |
| | | I have an application that saves a bunch of data in XML files that come from
typed datasets.
So, I have something like this:
MyTypedDs ...
=?Utf-8?B?RGF2aWQ=?=
|
08-21-2007 08:42 PM
=?Utf-8?B?TWFuaXNoIEJhZm5h?= | 3 | 11 |
| | | Hi,
I'm have a dataset with only few tables. But each table is fairly big ( due
to design constraints).
Now I have a flag which needs to be set...
Gobinath
|
08-21-2007 03:16 PM
Miha Markic | 1 | 10 |
| | | C a r l o s,
Don't call AcceptChanges on the datarow.
Kerry Moorman
"C a r l o s A n t o n i o >" wrote:
=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=
|
08-21-2007 01:36 PM
=?Utf-8?B?S2VycnkgTW9vcm1hbg==?= | 0 | 6 |
| | | Remove the calls to AcceptChanges(), both on the row and the table. It's
only needed after the Update(), and even then, it's...
Steve
|
08-21-2007 01:31 PM
Steve | 0 | 5 |
| | | Hi,
I am using the following to update some rows in a dataset, I wonder
why the data is no updated in the SQL table. Am I missing anything?
Please...
sweetpotatop@yahoo.com
|
08-21-2007 01:22 PM
sweetpotatop@yahoo.com | 3 | 10 |
| | | Hi,
I want to read the data\content of my .accdt and .accfl files using the
oledb provider of .net 2.0
i've used the below connection string...but...
=?Utf-8?B?QVZM?=
|
08-21-2007 09:49 AM
Paul Clement | 1 | 7 |
| | | We have started experiencing "System.InvalidOperationException: Internal
..Net Framework Data Provider error 6" exceptions from our Visual Studio...
Jody Gelowitz
|
08-21-2007 09:46 AM
Jody Gelowitz | 1 | 8 |
| | | Hello,
I want to use C# to select a random number from MS Access database
table.
<SELECT TOP 1 userID FROM users ORDER BY NEWID()> seem to work...
dungdang
|
08-21-2007 09:44 AM
Paul Clement | 1 | 8 |
| | | I have a form with master/child tables. I Deleted a row in the child table
with datarow.Delete and tried to save the change to the database. Because...
=?Utf-8?B?SsO2cmdlbg==?=
|
08-21-2007 09:00 AM
=?Utf-8?B?SsO2cmdlbg==?= | 2 | 8 |
| | | Why using an IIF in a DataTable.Select(IIF("column1=zz",
"column2","column3")); is in invalid context ?
What is the way for using an IIF in a...
sam
|
08-20-2007 12:55 PM
Sheng Jiang[MVP] | 3 | 10 |
| | | I've got a datatable with 3 columns:
-A string
-A datetime
-An expression-based column
I want the expression based column to be a representation of...
=?Utf-8?B?YmVuamk=?=
|
08-20-2007 03:43 AM
Miha Markic | 5 | 6 |
| | | HI,
I am trying to reading a .csv file from a remote desktop.
the connection string that i am using is as follows:
strConn = "Provider=MS...
simran2102@gmail.com
|
08-20-2007 12:25 AM
simran2102@gmail.com | 2 | 5 |
| | | I use this for selecting rows that match a specific case:
DataRow foundRows =
dSet.Tables.Select(IIF("column1="+DBNull.Value,...
sam
|
08-19-2007 10:33 PM
DaveP | 1 | 11 |
| | | Hello,
Thank you for your help.
When I browse the internet, I only find examples on how to restore an entire
database.
What I try to achieve is to...
Michel Vanderbeke
|
08-19-2007 05:24 PM
William Vaughn | 1 | 7 |
| | | I have names in a data collection the include apostrophes like O'Hare. When
I use a simple VC#/ADO.NET approach with an SQL INSERT statement...
Carl Thomas
|
08-19-2007 05:23 PM
William Vaughn | 13 | 14 |
| | | I've see references to this utility, but have been unable to find it in
either my SQL Express installation or my VC# ORCAS installation. Where...
Carl Thomas
|
08-19-2007 04:40 PM
Carl Thomas | 3 | 6 |
| | | Hi EveryBody:
Whey when I use the following code trying to inser my data to database it
did not work:
Dim mydatasource As New...
=?Utf-8?B?SHVzYW0=?=
|
08-18-2007 12:34 PM
Tim Van Wassenhove | 2 | 8 |
| | | Hi all, we need to be able to connect to an Excel in a remote server
via ADO.NET.
We have a component that makes queries to that excel a retrieves...
jcotroneo@gmail.com
|
08-18-2007 03:36 AM
=?Utf-8?B?QnJhdWxpbyBEaWV6?= | 1 | 15 |
| | | Hello,
I have a program, running in several places, using SQLEXPRESS as database.
The different places are stand-alone, and not connected to a...
Michel Vanderbeke
|
08-17-2007 10:53 AM
William Vaughn | 3 | 14 |
| | | Hi all,
I am having table containing 2 columns and 3 rows.
Col1 contains interger valye. I have records with record1 having 2 in
col1, record2...
Archana
|
08-17-2007 07:55 AM
Archana | 3 | 7 |
| | | Please i'm new in VB.net and i'm designing a Cinema booking and purchase
system..I need to load the seat ID from the database into an...
Fabiyi Olawale
|
08-17-2007 06:50 AM
=?Utf-8?B?R3Jpbm5pbmcgQ3Jvdw==?= | 4 | 10 |
| | | Hi,
I'm running into a problem with the double-quote character while i'm
reading a delimited text file. I've set the file delimiter to the...
maz
|
08-17-2007 04:49 AM
maz | 0 | 7 |
| | | Hi,
I am using vs .net 2005, .net frameworks v3.0, vc++ 2005, on vista
I am trying to write a c++ app to call a sql stored procedure.
the following...
=?Utf-8?B?Qm95ZA==?=
|
08-16-2007 09:02 PM
=?Utf-8?B?U2VyZ2V5IFBvYmVyZXpvdnNraXk=?= | 1 | 8 |
| | | I've followed the wizard to create a dataset. This datset has two tables, one
master, and one child. I've also had the wizard create stored procedres...
=?Utf-8?B?RnJlZCBHb29kcnVtIC0gQWxlbWFyY2sgQ29ycC4=?=
|
08-16-2007 08:23 PM
=?Utf-8?B?RnJlZCBHb29kcnVtIC0gQWxlbWFyY2sgQ29ycC4= | 0 | 13 |
| | | No need to respond at this point. I just saw a matching post further down the
list. I will try their solution.
"Fred Goodrum - Alemarck Corp." wrote:
=?Utf-8?B?RnJlZCBHb29kcnVtIC0gQWxlbWFyY2sgQ29ycC4=?=
|
08-16-2007 08:19 PM
=?Utf-8?B?RnJlZCBHb29kcnVtIC0gQWxlbWFyY2sgQ29ycC4= | 0 | 7 |
| | | I'm going through several books on ASP.NET database programming. They all
make it look so easy. But it just never seems to work for me.
So I created...
Jonathan Wood
|
08-16-2007 08:08 PM
=?Utf-8?B?QnJhdWxpbyBEaWV6?= | 2 | 11 |
| | | Hi - i'm using an OleDBDataReader to get results from a stored procedure and
it is hanging on the Close() call on the Data Reader. When I do a Sql...
=?Utf-8?B?TWFyaw==?=
|
08-16-2007 08:06 PM
=?Utf-8?B?TWFyaw==?= | 2 | 9 |
| | | I tried to create a new strongly-typed dataset that inherited from an
existing one, but I was not able to. There were methods that were created...
=?Utf-8?B?aG93YXJkd0Bub3NwYW0ubm9zcGFt?=
|
08-16-2007 07:55 PM
=?Utf-8?B?aG93YXJkd0Bub3NwYW0ubm9zcGFt?= | 0 | 8 |
| | | Does VS2005 create the dataset.xsd first and then use MSDataSetGenerator to
create the dataset.designer.vb or a portion of the dataset.designer.vb?
=?Utf-8?B?UGV0ZXI=?=
|
08-16-2007 07:52 PM
=?Utf-8?B?UGV0ZXI=?= | 0 | 8 |
| | | Hi, I am trying to execute an INSERT INTO query, but the debugger says
me that there is a syntax error, which I cannot figure out:
Public Shared...
SiD`
|
08-16-2007 07:51 PM
=?Utf-8?B?VG9tIEdhcnRo?= | 10 | 17 |
| | | OK here is my experience of trying to write some code to do something
really basic - insert a record into SQL server.
For various reasons I want to...
James
|
08-16-2007 03:37 PM
James | 0 | 6 |
| | | In a new system based on .Net 2.0 I have some tech goal like database
independence and the use of typed datasets. So I'm looking for some material
on...
=?Utf-8?B?TWF4IEFuZHLDqSBCw7xuZGNoZW4=?=
|
08-16-2007 07:46 AM
mark.troester@datadirect.com | 2 | 10 |
| | | I'm trying to implement something here that seems like it aught to work, but
is not. I've done some extensive searching around the web, and have...
=?Utf-8?B?Smlt?=
|
08-15-2007 01:06 PM
=?Utf-8?B?Smlt?= | 0 | 10 |
| | | Hi,
I have a table in SQL Server 2005 that has a primary key along with unique
constraint on two columns. When I create a TableAdapter for the...
=?Utf-8?B?VGVycnkgV2FobA==?=
|
08-15-2007 12:28 PM
=?Utf-8?B?VGVycnkgV2FobA==?= | 0 | 5 |
| | | Hi all,
I am connecting to DB2 Database using OleDB provider. While fetching the
data I am getting this error:
System.Data.OleDb.OleDbException: No...
Ashish Sheth
|
08-15-2007 12:05 PM
Wander Mahet | 3 | 22 |
| | | I'm trying to upgrade old code in .NET 1.0 to use the data access
application block (June 2005 version).
I'm trying to do this:
SqlCommand custCMD =...
TJ
|
08-15-2007 08:29 AM
TJ | 1 | 9 |
| | | I'm new to SQL Server and seem to have a lot of problems with my connection
string not working. I finally got it working on one system but then...
Jonathan Wood
|
08-15-2007 12:08 AM
Jonathan Wood | 2 | 7 |
| | | Hi,
I'm working with the dataset designer, which, via its wizard can generate
both a fill method and one to return a datatable. So I can use these...
=?Utf-8?B?YmVuamk=?=
|
08-14-2007 03:14 PM
=?Utf-8?B?YmVuamk=?= | 4 | 7 |
