| Groups | Blog | Home |
|
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 Refreshing a referenced dataset Posted by David D. McCrory at 2/16/2004 5:10:13 PM I have a typed dataset that was created from a referenced dataset. I have
made changes to the XSD file and want to propegate the changes to my typed
dataset. I have tried deleting the typed dataset and then adding it back,
but it still has the old structure. Can someone help me with this?
...more >>
beginning on dataset Posted by francois at 2/16/2004 4:22:40 PM Dear commnunity,
I need to access my datas in many different ways and i was thinking first to
execute lots of Sql statement to get all the pieces of information I need.
Indeed I do not need to only read records but more getting information like
in a data analysis or data mining approach.
Bu...more >>
How do I receive change events for my connection? Posted by Moogy at 2/16/2004 4:18:14 PM I'm using SqlConnection from ADO.NET, building Datasets, and allowing the
clients to manipulate the data using the Datagrid, and then commit the
changes.
I was wondering; is there any way to receive messages through my connection
that another client has updated a 'watched' table? That way if ...more >>
Re: CommandBuilder question Posted by William Ryan eMVP at 2/16/2004 3:00:42 PM
"William Ryan eMVP <dotnetguru@comcast.nospam.net> wrote in message news:...
> The commandbuilder infers everything from the SQL Statement. So whatever
> the statement was used in the Select statement will be used in the
> Insert/delete/Update respectively
> "Sébastien" <igpnet@hotmail.com> w...more >>
How to select the month from a date like 2004/2/16 ??? Posted by Gene at 2/16/2004 2:19:14 PM For example, the database value is datatime,
I only want to select the corresponding month from the date value,
is it possible to do so?
...more >>
MDAC 2.7 SP1 Failure Posted by Francois Magnin at 2/16/2004 1:28:03 PM Hello,
I am trying to install MDAC 2.7 SP1 (required for .Net 2003) and I keep on
getting the following error:
"INF Install Failure. Reason - Access is denied", although I am logged on as
administrator.
Win Version: 2000 sp3
Any idea?
Thanks in advance
Francois
...more >>
Detecting Changes in Datagrid? Posted by Moogy at 2/16/2004 1:06:21 PM How can I detect when changes are been made in the Datagrid? I don't see
any event for this, and the control obviously knows when changes have been
made...
I currently have it hooked into a Dataset.
Thanks!
Moogy
...more >>
Too many oracle connections by using Oracle DAL Posted by Bahl at 2/16/2004 12:56:10 PM H
I am using Microsoft Application Datablock for Oracle to connect to my oracle data store
I am facing a weird problem, everytime we connect to oracle via asp .net oracle connection by DAL is not dropped thus creating endless connections to oracle
What exactly could be going wrong
Please sug...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
trying to open connection through OLEDB for MYSQL Posted by chris at 2/16/2004 12:42:17 PM Hello,
I am trying to open a connectionstring for MYSQL through OLEDB.
I installed : OLE DB Provider for MySQL (MyOLEDB)
Updated 11/02/00
Versie : v.3.0
My database is a remote Database (on another server) so i think i have to
give the ip adres and then the name of the database
I tried se...more >>
CommandBuilder question Posted by Sébastien at 2/16/2004 11:10:46 AM I build a DataTable manually by using a DataAdapter.Fill with one database
Table as parameter. I add it to the DataSet manually. I add a new column in
this DataTable and copy the Primary key value in the new field (looping with
a For statement). I create a CommandBuilder for this DataTable.
Qu...more >>
Reaching columns -in C#.net- in queries with multiple tables with the same column name Posted by ed-it NO[at]SPAM euronet.nl at 2/16/2004 9:49:34 AM Hello,
I'm migrating my C#.net application from a MS Access-database to SQL
Server 2000. Now I found a problem.
In my code I use a lot (and I mean a lot) of queries with multiple
tables and some tables have columns with the same names ("id", "name"
etc). For example:
SELECT a.id, b.id FR...more >>
Can someone help explain this... Posted by Jonathan Schafer at 2/16/2004 9:47:15 AM Here is my query, that is built dynamically and executed in a C# console
program using ADO.NET...
"SELECT IPCode, CCID " +
"FROM dbo.Retailer_040211_10109307 (NOLOCK) " +
"WHERE CCID IS NOT NULL AND IPCode NOT IN " +
"(SELECT IPCode FROM dbo.Retailer_040211_10109307_WorkArea (NOLOCK))";...more >>
Problem Reading Values From A Column Posted by anonymous at 2/16/2004 8:21:09 AM Hi, I used below code to retrieve data from an Excel file
'Code to open the file here
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\CoopMetrics\test.xls';Extended Properties=Excel 8.0;
'Now using the OledbDataAdapter you can query t...more >>
Uploading Text Files To DB Using ADO.NET Posted by Anonymous at 2/16/2004 7:51:06 AM Is there a way of uploading text files with columns of data (eg., column one is Account Number, column two is Amount) to the Database using ADO.NET? Eg. I want to do something similar to below code that I do with Excel
'Code to open the file here
Dim strConn As String = "P...more >>
Selecting data from multiple DataTables in a DataSet Posted by mscirri NO[at]SPAM osmose.com at 2/16/2004 5:58:05 AM Using VB.NET:
I have a DataSet object(dsTempTables) with 3 DataTable
objects(dtHeader, dtPole, dtRemarks). I need to be able to select
data from multiple tables in a way like with old ADO (Select
table1.name, table2.ID from table1 Inner Join....) where you could
return a specific set of data...more >>
Unicode problem (displaying japanese text correctly) Posted by rob NO[at]SPAM saikosounds.com at 2/16/2004 4:14:48 AM Hello all
I have a SQL Server database and I'm experiening terrible problems in
displaying japanese language text stored in the db in my
ado.net/asp.net application. The relevant columns in the db are all
nvarchar (thus unicode).After pulling the data and using the
ToString() method alone alw...more >>
SQL INSERT Question Posted by Ralph at 2/16/2004 12:31:23 AM vb.net 2003 Coding..........
Dim SQL As String =
"INSERT INTO worktable ( hostname ) " & _
"SELECT [ftpimport].[hostname] " & _
"FROM ftpimport " & _
"GROUP BY [ftpimport].[hostname] " & _
"HAVING (((Count(ftpimport.hostname)) > " & Hits & "));"
******** Coding for 1st attempt************...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |