Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Connection Pool problem
sk.rasheedfarhan - 23 Dec 2006 3:59 PM - 3 messages
Hi, I have troubles with a threaded application on W2003 server. It seems to leave open connections behind time to time, it sums to hundreds over a day (the application make thousands). It is using the SQLOLEDB provider, MDAC 2.82.1830.0, SQL Server 8.00.2039 (SP4), ...
Score Master Detail InsertCommand
Santi - 22 Dec 2006 8:45 PM - 1 message
Hi, I am developing an application that accesses a Foxpro database (.dbf files) with two tables, the master table (customers) has a field (id) which is primary key. The detail table (orders) has a primary key formed by the fields: customerid, orderid. The order id is a not ...
Score Move DataRow to other DataTable
Darren - 22 Dec 2006 6:34 PM - 5 messages
I'm trying to move a row from one table to another.  I get the error message that the row already belongs to another table even though I have removed it from the table. I'm trying to avoid recreating the row for performance reasons. ...
Score Update Command gives "Must Declare scalar variable "@P7CYCELDAY""
craig - 22 Dec 2006 2:52 PM - 3 messages
This is driving me nuts!  I've got a form that is giving me fits.  I've done the same thing that I've done on dozens of other forms.  When the data adaptor update command is executed I get the "Must declare scalar variable ...
Score Xquery
Mukesh - 22 Dec 2006 12:28 PM - 4 messages
hi all I want to do some modification in  my xmldata in xmldata column . <root> <DateOfBirth>12/22/1988 </DateOfBirth> <Gender> 1 </Gender> <Country>Bolivia </Country> ...
Score DBConcurrencyException With ON DELETE CASCADE
Andrea Caldarone - 22 Dec 2006 9:39 AM - 2 messages
Hi all, in my SQL Server 2005 database I've two tables linked by the classic relationship PrimaryKey->ForeignKey, I've added the clause "ON DELETE CASCADE" to the ForeignKey constraint, so when I delete a record in the ...
Score Transaction processing
Dwight - 21 Dec 2006 5:30 PM - 5 messages
A couple of questions regarding transaction processing. management for SELECT statements? Does it make sense to use transaction management for a single UPDATE or INSERT statements? Thanks ...
Score beginner: types of database applications in .NET?
R.A.M. - 21 Dec 2006 4:19 PM - 3 messages
Hello, I am learning .NET and I am interesting in programming database applications using web forms. Could you tell me please what kind of database applications are implemented in .NET technology? Thank you very much! /RAM/ ...
Score Connection Leak.
sk.rasheedfarhan - 21 Dec 2006 4:08 PM - 6 messages
Hi, I have troubles with a threaded application on W2003 server. It seems to leave open connections behind time to time, it sums to hundreds over a day (the application make thousands). It is using the SQLOLEDB provider, MDAC 2.82.1830.0, SQL Server 8.00.2039 (SP4), ...
Score Table Adapter for multiple tables?
offwhite - 21 Dec 2006 4:01 PM - 17 messages
I would like to create a Table Adapter which can work with multiple tables.  Ideally it would still work with the configuration wizard.  I have tried to add a query which joins 2 tables, but then it does not ...
Score Using ADO.Net to create an excel file.
jjd - 21 Dec 2006 1:08 PM - 8 messages
Hi All, Hope someone can help me or guide me in the right direction. I will received random excel files from a user that I want to copy and rename as "backup of...". I then want to take the original file, delete ...
Score how cab Db notify an insert in the table to the application...
Sugandh Jain - 21 Dec 2006 11:58 AM - 5 messages
Hi, We have the following scenario. the application works in a multi user environment. we have a screen opened by user1, which shows data from several tables. it fetches and populates the data as it is opened. Now, there is action done by user2, which inserts or updates the records in ...
Score fetching values returned by Stored Procedure by columnName and not Index...
Sugandh Jain - 21 Dec 2006 11:41 AM - 7 messages
Hi, We have a stored procedure, that returns the set of rows of companies... Following is the query in it. Select    PMCompanyID AS [COMPANYID] , TC.NAME AS [COMPANYNAME] , TC.ShortName AS [SHORTNAME]   From PM_Company AS PMC ...
Score cascade update across datasets
KShvats - 21 Dec 2006 11:31 AM - 2 messages
Hey there, I have 2 datasets, each containing a couple of tables. After saving 1st DS to database, some of rows primary keys are replaced by those generated by the DB. I need to be able to update the 2nd DS tables with ...
Score Parent - Child relationship (part 3)
Andrea Caldarone - 21 Dec 2006 11:29 AM - 1 message
Hi all, this seems the never ending story... Well now I've my parent - child relationship up and working in insert, update and delete. But sometimes an unhandled exception rises when I try to add some child row to the child ...
Score Filtering the view of a dataset
Mikaël_PLOUHINEC - 21 Dec 2006 10:06 AM - 2 messages
Hello, I have a dataset with 2 DataTables : Groups and Persons. I make a relation between this 2 DataTables using one DataColumn in each datatable. Finally I use this dataset in a dataGrid. So I would like to have a display like : ...
Score ADO.NET oracle UROWID mapping
gabe - 20 Dec 2006 9:24 PM - 1 message
We would like to overload an OracleStored procedure, where in one instance the procedure would take a string for ROWID. The other would take a UROWID. Is this possible? What does a UROWID translate to in ADO.NET? Thanks, Gabe ...
Score Use OleDB DB2 provider type without extra software?
ajmastrean - 20 Dec 2006 8:42 PM - 5 messages
I recently realized that I need IBM's iSeries Access installed to use Provider=IBMDA400.DataSource.1 in an OleDB connection string. Is there any .NET 2.0 class or dll that provides DB2 data access without any other software installs besides the .NET 2.0 Framework? Or, ...
Score Help with ADO.net message "Failure creating file"
Gordon - 20 Dec 2006 6:10 PM - 3 messages
Hi ; Assuming: Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &   sPath & ";Persist Security Info=False"   Dim Conn As OleDbConnection = New OleDbConnection(connString) If Conn.State = ConnectionState.Closed Then             Conn.Open() ...
Score ReadXml from resources
ray well - 20 Dec 2006 5:39 PM - 2 messages
i saved the state of a data set and table via     MyDs.WriteXmlSchema("MyDs.xsd")     MyDs.WriteXml("MyDs.xml") i was able to read them back in and display the info in the database by ...
Score Is the following question possible to do in .Net
Vinay Bhushan - 20 Dec 2006 2:59 PM - 3 messages
Child Dataset {          i int;          j string; } Master Dataset {        i int;        j String; ...
Score Null values creating problem
arun@greettech.com - 20 Dec 2006 2:58 PM - 3 messages
Hi I have a table having Null values for some columns. When ever I read it  through a data reader, like Convert.ToInt32(dr("Column")) I am getting some error. 1.How to handle this situation, especially with integer nulls ...
Score Parent - Child relationship (part 2)
Andrea Caldarone - 20 Dec 2006 2:55 PM - 6 messages
Hi all, so I've my parent - child relationship, that works fine with select, insert and update. But I've some trouble with the delete, probably I'm missing something. My delete sub has theese stpes: 1) delete a row from the parent datatable ...
Score OleDbConnectionString / Vista
Dr. Patrick Havel - 20 Dec 2006 2:36 PM - 2 messages
Hello *, in my VC++ program I use the following code to create a connection object: "m_sCreateString.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s.mdb;Persist Security Info=True;",m_sPfad);"   // Connection Object erstellen   hr = m_pConn.CreateInstance(__uuidof(Connection));" ...
Score Very Stuck Newbie
Oh-its-all-gone-wrong - 20 Dec 2006 1:55 PM - 2 messages
Hi There, I have a demo application which im trying to run which use`s a remote webservice. When i try and run the App its telling me i need to change the webconfig. Its saying i need proxy Authentification. Could anybody possibly ...
Score What is the difference between myDataSet.Tables[0] and myDataSet.Tables["myTable"] ??
zhivago - 20 Dec 2006 10:54 AM - 11 messages
I figured both would behave identical:     myDataSet.Tables[0] and     myDataSet.Tables["myTable"] What's the difference? ...
Score SqlBulkCopy
mUraliDharan - 20 Dec 2006 6:44 AM - 2 messages
can any one tell me how to tranfer data from and to sqlCE(.SDF) and SQLSERVER using SQLBULKCOPY ...
Score Data Application Blocks output parameters problem
darko - 19 Dec 2006 7:50 PM - 1 message
Hi, can anyone help me with the problem extracting output parameter from Data Application Blocks, SQLHelper.ExecuteDataset command, here is my code SqlParameter[] theParamaters = null; SqlParameter paramOut = new SqlParameter(); ....... ....... ...... paramOut.ParameterName="@isTopSelect"; paramOut.Direction=ParameterDirection.Output; paramOut.SqlDbType=SqlDbType.Bit; ...
Score querying a datatable or dataview for dups
Roy - 19 Dec 2006 7:25 PM - 3 messages
Hi all, Is there a way to query a datatable or dataview for duplicate rows? RowFilter property is very limited and only can be used as where clause, but how a query like this can be implemented: select familyName from Names group by familyName having count(*) > 1 ...
Score JDBC connection for DBF files
deepak.n.l - 19 Dec 2006 5:59 PM - 2 messages
I am not able to connect to DBF files: I am getting this following error: DBF Driver Driver not found! java.sql.SQLException: No suitable driver I am using Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); and the code that I am using to connect is: ...
Score Organize colmun order
Andrea Caldarone - 19 Dec 2006 2:48 PM - 1 message
Hi all, I've a DataTable with some columns: ColA, ColB, ColC. Theese columns are created by the FillSchema method of the sqldataAdapter wich fills the table. At runtime I add a DataColumn, this one is added at the end of the columns ...
Score Can not view schema within VS2005
Geary - 19 Dec 2006 2:18 PM - 2 messages
I am developing an ASP.NET website using VS2005.  I am trying to access data from a remote sqlserver 2005 database, created and maintained by our inhouse dba.  We are both fairly new to both of these products. ...
Score SqlTransactions vs. transactions in the SQL code
urig - 19 Dec 2006 11:17 AM - 2 messages
I'm having a discussion with my team leader concerning the use of SqlTransactions. We work on an ASP.Net 1.1 website. Up until now we've been using SqlTransactions in our business logic layer to combine several data access layers method ...
Score SqlDependency Only firing event once
Synced - 19 Dec 2006 3:08 AM - 3 messages
Hey gang. I am just learning the SqlDependency class for the first time. I am really thankful for this class I believe. I thought I was going to have to do SQL CLR Trigger that called my WebService. Anyways, I am using the SqlDependency.OnChange event and its working great ...
Score Transaction scope with different layers.
Jay Balapa - 18 Dec 2006 9:17 PM - 1 message
Hello, I have a Inspection table and History table. If I change barcode in Inspection and then have history table also need to be updated. Problem is I use a seperate Datalayer and BusinessLayer. BusinessLayer will need to call DataLayer. Can this following code work ...
Score SQLCommand, CommandTimeout property
Doug - 18 Dec 2006 8:48 PM - 1 message
I'm trying to recreate a timeout in sql - on development - by creating a long running query and setting the command timeout property of the SqlCommand object to 1 so that the query automatically times out. It's not working.  I watch the clock and the process is obviously ...
Score SQL Server 2005 compact/everywhere
Julian - 18 Dec 2006 8:42 PM - 5 messages
Hi Has the release version been issued yet or is the November ctp still the latest version? As I understood a version was due to be released in December but could not find it on the MS site. If so, what is the download url? ...
Score ADO.NET and the OUTPUT Clause
Mike Mertes - 18 Dec 2006 6:40 PM - 19 messages
Hi all, What's the easiest way to retrieve a single value (post insert identity fetch) from an output clause in a stored procedure? For instance: @CREATE PROCEDURE sp_Insert @Var1 int @Var2 int AS INSERT INTO tbl1 (Fld1, Fld2) OUTPUT INSERTED.RecordID ...
Score defaultview is empty, although no filter is set
Isa - 18 Dec 2006 6:06 PM - 11 messages
Hi Newsgroup, I have a problem with the RowFilter. When I check my datatable in the debugger, I get the following result: table1.Rows.Count     3 table1.DefaultView.RowFilter     "" table1.DefaultView.RowStateFilter    Unchanged | Added | ModifiedCurrent ...
Score Parent -Child relationship
Andrea Caldarone - 18 Dec 2006 4:32 PM - 16 messages
Hi all, In my project (VB.Net 2003) I've plenty tables linked each other via DataRelation, for example let's analyze this couple: Parent Table [Clienti] Child Table [Indirizzi] theese two tables exist in a SQL Server 2005 Database, and theese are their ...
Score DataAdapter.Update
Erol - 18 Dec 2006 2:28 PM - 7 messages
I've got two rows added to my datatable that I need to commit to the database. I begin a transaction on my connection and attempt to update both rows as one transaction to the database. My first record is successful, but my second row fails due to a business ...
Score mixed mode (SQL Server) and password in connection string
R.A.M. - 18 Dec 2006 3:39 AM - 2 messages
Hello, I use mixed mode in my SQL Server 2005 Express Edition. I added connection string to my web.config: <add name="MIMProjekty" connectionString="Data Source=.\SQLEXPRESS;AttachDBFileName=|DataDirectory|\MIMProjekty.mdf;Initial Catalog=MIMProjekty;uid=sa;pwd=sqlserver" providerName="System.Data.SqlClient" /> ...
Score DbCommand and using statement
offwhite - 18 Dec 2006 12:38 AM - 2 messages
I would like some feedback on the following code snippet.  It is using the Data Access Application Block where db is a Database object.  What I want to know is how I should be using the "using" statement to scope ...
Score menu
nil - 17 Dec 2006 12:16 PM - 9 messages
Hello Everyone .......i created menu using Css and HTML code..but i want it to display submenu when mouse is over on the horizontal strip...but it's not working and either it show all the menu or not when the page is loaded......so what should i do? ...
Next »