all groups > dotnet ado.net > july 2004 > threads for thursday july 15
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 31
Using C# to get schema???
Posted by ªL©ú©v at 7/15/2004 10:44:56 PM
Dear All:
How to retrieve the schema of a *.mdb file by using C# ??
Thanks a lot..
Andrew
... more >>
Delete Filing
Posted by Keith at 7/15/2004 7:13:49 PM
I am testing my Data Access Layer. I have stored procedures developed for
all the CRUD. I am creatng records without a problem. When I go to delete
them, I get an error:
System.Data.SqlClient.SqlException: Procedure 'sp_Document_DeleteCommand'
expects parameter '@Original_DocumentID', which... more >>
How to derive a class from DataRow?
Posted by Lei Jiang at 7/15/2004 6:28:11 PM
It seems a DataRow can only be created from
DataTable.NewRow()/NewRowArray()/NewRowFromBuilder() method. If I want to
derive a class from DataRow, how can I create it?
In MSDN, the NewRowFromBuilder() seems could do this, but the method is
marked as internal use.
... more >>
is there a Java-implementation of the DataSet-Class?
Posted by Lorenz Kahl at 7/15/2004 6:14:13 PM
Hi there,
to me it seems like everything in .NET is based upon XML and web
services for the sake of interoperability. But does the use of XML also
automatically result in platform independent solutions?
What if I have a distributed application which uses the class DataSet to
represent da... more >>
How to databind a combo that has it's items entered through the IDE?
Posted by PeterZ at 7/15/2004 3:37:06 PM
Hi,
Win Forms question.
Got a comboBox (myComboBox) with it's items set through the collection
editor in the IDE. These are:
No
Yes
Not Applicable
I also have a strongly typed dataSet (myDataSet) with a table (myTable), one
of the columns is called HEROIN_ADDICT, it may contain... more >>
Image Field and "Object must implement IConvertible"
Posted by Thomas at 7/15/2004 3:28:10 PM
I want to push a file into an Image field in SQL Server, however I keep
getting a "Object must implement IConvertible" error. Firstly, I have
noticed that all of the examples on the net only sample an Update and not an
Insert. Secondly, I want to be able to use a stored procedure, but for this
e... more >>
sqlbulkcopy with FIRE_TRIGGERS?
Posted by Zwyatt at 7/15/2004 3:15:01 PM
I am copying a large amount of data into SqlServer using the new SqlBulkCopy class with Whidbey. It works fine.
But -- the insert trigger on the table that SqlBulkCopy is sending data to is not running. If I insert with a regular INSERT query the trigger fires...but if I do the insert with SqlB... more >>
DataSet Problem
Posted by Roshawn at 7/15/2004 3:11:18 PM
Hi,
I am using a dataset for a web application. The dataset contains 10 items
when the Products.aspx is loaded. Only 10 items will be shown at a time on
this page. On the page there is a label control placed inside a repeater
control (along with other controls). This label displays the prod... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Sql Stored Procedure Updates
Posted by Masahiro Ito at 7/15/2004 2:27:26 PM
I have fairly typical Stored Procedure that should be updating a table,
but is not. It isn't giving any errors, and is quite mystery. It
doesn't change the row in the database (db currently has null values in
the OCN and Switch, this Primary Key NPANXX 416402 should be having all
these val... more >>
Databinding Bible (REPOST FROM m.p.d.f.WindowsForms.Databinding)
Posted by a at 7/15/2004 12:00:56 PM
What is 'The Reference Book' on VB.NET databinding?
Kevin
... more >>
Linkage to MS Office...
Posted by The Goulds at 7/15/2004 11:35:02 AM
Can you link .net framework objects inside an MS Office App, say the rich
text box within an Access database?
Thanks!
... more >>
running multiple scripts
Posted by G. Dean Blake at 7/15/2004 11:06:17 AM
I have to develop a program to convert a database to a new version. This
entails reading old tables, masaging the data, deleting old tables and their
relationships, adding new tables with new relationships, ets.
More than just executing sql with dataadapters, it seems I also need to
execute m... more >>
Help - datareader connectoin conflict?
Posted by crypkeyprogrammer NO[at]SPAM yahoo.com at 7/15/2004 10:31:51 AM
I have setup up a datareader, and when I try to loop through the
datareader, each time my application tries to run another query, the
following exception occurs:
there is already an open datareader associated with this connection
which must be closed first
The datareader and the query are b... more >>
DataColumn.Expression IsNull
Posted by AndyG at 7/15/2004 4:55:29 AM
Need to return a calculated column in a dataset that indicates whether another column contains a dbnull value. Note this data does not come from any sort of datasource in which I could perform such a calculation.
I initially thought Id be able to use the IsNull function but this appears to be bad... more >>
ado.net2.0 async execution
Posted by arnold park at 7/15/2004 3:39:19 AM
Hi I have a question about ado.net 2.0 beta framework.
I heard async command execution very powerful.
But in my case, most of DataAccess Logics are in com+
Layer. And async execution causes some kind of thread
switching.
When it comes to COM+, i think That can be a problem.
what do you think... more >>
Setting the RowFilter of DataView to perform Case Insensitve filter
Posted by kbalusu NO[at]SPAM yahoo.com at 7/15/2004 3:21:08 AM
Hi,
Is there anyway to filter a dataview in a case-insensitive way. The
DataView's RowFilter doesn't support the "LOWER" function. Is there a
way with out setting the DataSet.CaseSensitive property.
TIA,
K Balusu... more >>
OleDBConnection.Close() does not release MS Access database
Posted by Evgeny Zoldin at 7/15/2004 12:12:46 AM
Hi ALL,
I do in C# the following:
bool DoSomething(){
OleDbConnection conn = new OleDbConnection( "... connection string to
MS_Access.mdb ... ");
/* do what I need using OleDbDataAdapter, DataTable etc... */
conn.Close();
GC.Collect(); // !!!!! - gives no effect for ... more >>
|