all groups > dotnet ado.net > september 2003 > threads for sunday september 21
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Direct Access Dataset
Posted by Simon at 9/21/2003 11:09:16 PM
Guys,
I am after a way to directly access a value in a table in
a dataset. For example, if I want row 6, and column 3,
can I do something like:
DataSet1.Tables[0].Rows[6].Columns[3]
All documentation I've read requires the dataset to be
iterated, but this will add to the overhe... more >>
Concatenation of Columns with string seperater?
Posted by What-a-Tool at 9/21/2003 9:13:16 PM
Have 2 columns in a DataTable:
Home Team
Away Team
I want to concatenate them into 1 column (New Data Column) with a "vs."
between them.
I can combine the 2 rows with this format:
dcGame.Expression = "Home + ' ' + Guest"
but I can't get the ".vs" in there no matter what I try.
Could some... more >>
System.types->OleDbTypes
Posted by Konrad at 9/21/2003 6:17:48 PM
Hi
How to find appropriate OleDbTypes
for System.Types.
Thanks
Konrad
... more >>
Strange Update Problem - NullReferenceException INSIDE of Update Method!
Posted by John Saunders at 9/21/2003 5:24:15 PM
I'm writing a program which is meant to write Event Log entries into a SQL
Server database. I'm using a SqlDataAdapter with stored procedures generated
by the Configure Data Adapter wizard. I'm using the strongly-typed dataset
this generated for me (EntryDS). The one table is EventLogEntries, so ... more >>
Transaction across different connections.
Posted by Tim Marsden at 9/21/2003 3:31:36 PM
Hi,
I wish to update several databases using both OLEDB and SQLClient data
providers with in same procedure. I am using VB.NET and ADO,NET. I want all
updates to succeed, or Rollback them all. How can I achieve this using ADO
Transactions.
Tim
... more >>
Output param trouble w/ data access block
Posted by Kurt Mang at 9/21/2003 3:11:23 PM
Sorry - previous post sent on mistake.
Anyways, I can't get the output parameter value back when
I use the DAL application block v. 2.0.
I pass an enumerated value instead of the index value to
the parameter array ("params") for better readability.
THE CODE:
===
Dim params(2) As SqlPa... more >>
Output param trouble w/ Data Access Application Block
Posted by Kurt Mang at 9/21/2003 3:05:32 PM
Hey all --
I'm having a heck of a time getting the MS data access
application block to return an output parameter for me.
I've tried pretty much everything at this point.
THE CODE:
Dim params(13) As SqlParameter params =
SR.SqlHelperParameterCache.GetSpParameterSet
("p_Member_InsertU... more >>
how to verify the data set filling the right data table
Posted by Hello at 9/21/2003 3:21:41 AM
Hi all,
I am now writing 1 stored procedure(sp) which execute
other 2 sp, therefore result of 2 data set and 2 dataset
tables. But how can I ensure the right dataset filling
the right tables so that .net crystal report can access
the table's result to generate report.
Please help me, it... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|