|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 December 2007 January 2008 February 2008 March 2008 April 2008 |
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 Reading Excel into a dataset Posted by sutphinwb NO[at]SPAM npt.nuwc.navy.mil at 4/15/2004 9:31:00 PM I've been reading excel worksheets into a dataset using the following
prose
OleDbDataAdapter myCommand =
new OleDbDataAdapter(
"SELECT * FROM [MySheet$]",
@"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data Source=" + input_file +
@";Extended Properties=""Excel 8.0;IMEX=1""");
The ...more >>
Implementing a DataReader : where to store the result from DB ? Posted by Craig Kenisston at 4/15/2004 9:04:40 PM
Hi,
I'm working in the implementation of a little .net provider for a propietary
database format.
I've studied the .Net provider sample that is in the vs.net help, as well as
other providers a bit.
There is a class in the sample to store the result from the database :
public c...more >>
Advanced Dataset Merge Question Posted by TomC at 4/15/2004 6:36:03 PM I have two datasets from different databases that I would like to perform a left outer join on and bind the result to a datagrid. I am attempting this buy merging the datasets into one dataset. I would like the shemas to merge but what is happening is that the table from dataset "b" is copied into d...more >>
Cannot find Oracle data client Posted by bclegg at 4/15/2004 4:41:37 PM Hi,
I am running Dot Net 7.1.3088 on top of framework 1.1.4322
I cannot find the system.data.oracleclient namespace.
I tried running the 'Managed Provider for Oracle ' oracle_net.msi.
This ran OK but still no client namespace.
Any ideas?
thanks
Bob
...more >>
Images into SQL Server Posted by Steve Peterson at 4/15/2004 12:11:52 PM Hi
I was hoping that someone could point me in the direction of some articles
on how to get images into a SQL Server database. I have an ASP.NET app
where I need to let the users upload images to the server (that's no
problem),
but then I need to get the uploaded image into a table in SQL ...more >>
Newbie asks about DataSet HasChanges Posted by Mika M at 4/15/2004 12:04:00 PM Hello!
My application has MainMenu containing MenuItem 'mnuSave' and ToolBar
containing ToolBarButton 'tbbSave'.
When users has edited DataGrid or any of the TextBoxes on the windows form,
then ds.HasChanges (ds=DataSet) will be 'True', then I want set ...
mnuSave.Enabled = ds.HasChanges
...more >>
Generate Dataset Error: 'string' does not contain a definition for 'Convert' Posted by tropical_jam NO[at]SPAM yahoo.com at 4/15/2004 11:08:43 AM I have a strongly typed dataset that contains a table that links to a
complex type in another dataset. One, and only one of the fields, in
the complex type has a minOccurs = 0. When I go to the dataset that
has the datatable that references the complex type, click generate
dataset, and compile I...more >>
dumb previous question - repost Posted by Rich at 4/15/2004 10:26:32 AM After thinking about it a bit, my previous question was
kinda lame (can I fill an Access table with sql adapter -
of course not). I meant to ask if I could bulk copy data
from a sql adapter table to an oledbAdapter table.
Where I am not clear however is if one dataset can contain
a sql t...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Dates added to times in Access database Posted by Steve via .NET 247 at 4/15/2004 9:37:51 AM I have been trying to update dates and times in an access database using VB .NET.
I use the parse and format events of a data binding to set the required format for the field. This works fine for dates but when I store times I get the current date inserted as well.
The parse and format events ...more >>
How to Reset RAISEERROR in nested sps Posted by Mart via .NET 247 at 4/15/2004 9:37:39 AM (Type your message here)
I am calling an sp from ADO=2ENET, and almost everything is fine=
:-)=2E The ADO=2ENet code has a try catch block for SqlException=2E=
The sp calls another sp, which may call RAISERROR under a=
certain condition=2E When this happens the top level sp reads the=
cod...more >>
can I fill an Access tbl with sqlsrv Adapter? Posted by Rich at 4/15/2004 8:17:01 AM Hello,
Is it possible to have 2 tables in a dataset where each
table is from a different source? tbl1 is from sql server
and tbl2 is from Access? Then is it possible to fill the
Access table with the data from the sqlserver table? Like
if I use an adapter to fill the sql table can I us...more >>
Filling a DataSet from a positionally delimited flat file Posted by billym at 4/15/2004 8:13:19 AM An article in the The Code Project entitled "A simple architecture to read
arbitrarily formatted flat files into ADO DataSets" had the following
comment:
"There are Ole Providers to read formatted flat files into DataSets, but
ever wondered about importing data from files which are not simply ...more >>
Getting a list of SQL servers on a network Posted by M K at 4/15/2004 7:21:07 AM I want to have a lookup window in my app so that users can select the SQL server the app is going to connect to. What's the best way to do this?...more >>
Connection Problems Posted by Sunil Sabir at 4/15/2004 4:51:04 AM Dear All
I am having a problem trying to establish a connection with SQL Server using ASP.net page. I am using Server Explore
to establish a connection. The connection is perfectly established if I use Northwind or pubs Database. But I am unabl
to establish a connection if I make my own d...more >>
Parent-Child relations in a dataset Posted by Mark G at 4/15/2004 3:26:04 AM I'm facing the following problem
The dataset contains two tables (parent-child), and both tables have auto-incrementing column (SID)
I succeed to insert a row into the parent table (in the dataset and in the db), but when I try to get the value of the SID (from the dataset, before updating the dat...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |