Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score how to create a typed dataset with multiple tables?
fredd00 - 16 Dec 2006 7:38 PM - 5 messages
Hi I have a stored proc that returns 2  record set (tables) i have 1 select that returns the error id and error message and 1 select for the data when i drop the stored procedure on the designer of the DataSet I only ...
Score How to realize a C# page that give back an image instead of an html page
Etantonio - 16 Dec 2006 10:42 AM - 2 messages
Good morning, I have a static html page where I want to load image that day to day are in a different path, to achieve this I would want that the link point to a c# page where I create dinamically the new url, but how I can arrange a c# page that ...
Score "CREATE DATABASE permission denied in database 'master'. Could not attach file..."
R.A.M. - 16 Dec 2006 8:28 AM - 4 messages
Hello, I am learning .NET 3.0. I am writing application using MIMProjekty SQL Server 2005 database. At C# command (identifiers are in Polish language):     SqlConnection Po³±czenie = new SqlConnection(ConfigurationManager.ConnectionStrings["MIMProjekty"].ConnectionString);     Po³±czenie.Open(); ...
Score Execute msdb.dbo.sp_help_job using ado.net
liberty - 15 Dec 2006 7:55 PM - 1 message
I am running VS 2003 with backend of sql server 2000 sp3. As a non sa user from sql server query analyzer , excel ms query and crystal reports I can run the stored procedure msdb.dbo.sp_help_job and get the expected result. ...
Score SQLCacheDependency and ASP.NET dbo privladges
Smokey Grindle - 15 Dec 2006 7:44 PM - 3 messages
didnt know if this went in ado.net or ASP.net, so had to cross post... I have a ASP.NET site running on my "web" server named "web" and its running a site that has a SqlCacheDependency on it and is looking for changes in my ...
Score Simulating temp tables for mdb?
Edwin Knoppert - 15 Dec 2006 3:43 PM - 3 messages
I'm trying to work out a temp table situation for oledb>mdb stuff. I simulate this using a transaction > rollback in a class (+disposed implemented and such). But i can not get me a 2nd instance, it gives me a already open connection ...
Score Read/Write MaxLength and AllowDBNull in System.Data.DataColumn with Access
Giorgio - 15 Dec 2006 3:09 PM - 1 message
Hi,     I've an Access db and I'm using the following provider: PROVIDER=Microsoft.Jet.OLEDB.4.0 I need to make an administration tool to create and change table properties, so I need to read MaxLength and AllowDBNull properties from ...
Score DataBind GridView to a DataViewManager in ASP.NET
ack95 - 14 Dec 2006 8:17 PM - 1 message
Simply question How can I DataBind() a DataViewManager to a GridView in ASP.NET? Question in Detail We have a DataSet with relational DataTables (total of 5).  We are generating emails with user specific data, so instead of going back to ...
Score write fields from multiple tables together
sonja - 14 Dec 2006 4:54 PM - 3 messages
Hello, i want to write fields from multiple tables from one dataset back into a new dataset. How can i do this? Thanks for any Help ...
Score Slow performance with iSeries and ADO.NET
Prodevelop - 14 Dec 2006 4:13 PM - 3 messages
Hi, we have a .NET 2.0 app that uses DB2 in iSeries. There're some performance issues with this, because the response average time is about 400ms returning only few rows. Using stored procedures or calling RPG programs is even slower ...
Score Installing an application in local network!, Help Please
rguarnieri - 14 Dec 2006 3:35 PM - 2 messages
Hi!, I'm trying to install an vb.net 2005 application I know that I need to use mscorcfg.msc to configure my application but I don't know how to do it. I have my .exe and some .dlls, I need to put ...
Score disposing the database object??
Venkatesh - 14 Dec 2006 10:03 AM - 6 messages
Hi.. i am using the Data Access Application Block of the Enterprise library 2.0. In the code, i have used: Database db= DatabaseFactory.CreateDatabase (); int intRowID; try { string strQuery= "select row_id from Users where login_name='" + strUserName.Trim() + "'"; intRowID = Convert.ToInt32 (db.ExecuteScalar(CommandType.Text ,strQuery)); ...
Score AddOutParamter Method, Enterprise Library
Sugandh Jain - 14 Dec 2006 6:46 AM - 1 message
// // Summary: // Adds a new Out System.Data.Common.DbParameter object to the given command. // // Parameters: // command: // The command to add the out parameter. // // name: // The name of the parameter. // // dbType: // One of the System.Data.DbType values. // // size: // The maximum size of the data within the column. ...
Score How to redify the connection Error
Krishna - 14 Dec 2006 6:35 AM - 2 messages
Hi,    I developed one solution using .net 2005 and sql server 2005.The sql server acess to the management studio and server default settings is local and remote connection.But I run the application it's display the following ...
Score ExecuteDataSet, Reader, non query and...
Sugandh Jain - 14 Dec 2006 6:15 AM - 2 messages
Hi, Could you tell me which of the sql commands execute commands to be used for best in the situation I am in. I will call a SP, which will return A SINGLE ROW with the details of the ID, ...
Score Relation between 2 table
Seth Bourne - 14 Dec 2006 12:34 AM - 4 messages
Lets say i've 2 table. Order and OrderDetail. Order table is contain OrderNo(PK), OrderName. orderDetail contain orderDetailID(PK), OrderNo(FK), item and qty. and i had finish related the two of table in dataset. Is it possible that ...
Score .Net 2.0 Autogenerate update command parameters from a disconnected datatable
david00001 - 13 Dec 2006 10:43 PM - 4 messages
I am trying to find code to generate the command parameters for updating a datatable (of changes received from UI layer) in a middle layer object. I want to use  a dataadaptor to do the update. I can easily generate the update, insert and delete sqls for the ...
Score Extending TableAdapters for Transactions in VB.Net
Hawk - 13 Dec 2006 7:51 PM - 4 messages
Ok, I have searched and searched with no luck trying to find a solid example written in VB.Net on how to extend a tableadapter “Typed Dataset” within the partial class to expose a transaction that can be used in my Asp.net pages.  ...
Score What I want in ADO.NET 3.0
David Thielen - 13 Dec 2006 6:42 PM - 7 messages
Hi; I think the following would be a gigantic help for a lot of people (all being standard calls so we do not have to write selects on a per vendor basis): 1. Enumerate servers works for all ADO.NET clients (ie - it's a required ...
Score STRANGE: inserting byte() array in ntext column
Jorge Ribeiro - 13 Dec 2006 6:37 PM - 1 message
hello i've an application that constructs a xml file and writes it into a stream then i write the content of that memory stream into a byte array i then invoke a store procedure that has as one of it's parameters a NText ...
Score Merging DataTables
JT - 13 Dec 2006 6:36 PM - 3 messages
Hi, I am trying to simulate a join on two datatables using the merge method as part of exploring a possible migration from CRXI reporting (where you can report off of multi-table datasets) to SQL Reporting (where you cannot).  The ...
Score CommandTimeout
Andrew Robinson - 13 Dec 2006 5:24 PM - 5 messages
Is there any way to set the CommandTimeout within the connection string as opposed to setting the property on the SQL Command Object which defaults to 30 seconds. Please note that I am not talking about the connection timeout property that ...
Score Trouble deleting DataRow in DataSet
Hardy Wang - 13 Dec 2006 5:11 PM - 3 messages
Hi all, I have a DataSet with 3 rows in Table[0], I need to delete some rows based on condition. If I use following code             int count = dsResult.Tables[0].Rows.Count; ...
Score OleDbParameter vs. manually SQL Statement to Insert mass date from host
pRumpf - 13 Dec 2006 4:57 PM - 6 messages
Hi I translate an prior application written in Clipper to C#.... The Application reads Cobol Files (EBCDIC, BCD numbers....) and inserts the data into a rdbms. This part is no problm to realize in C#. The original App. create SQL Statements as string/text and execute them ...
Score MS Access 'already opened exclusively' error
Jared - 13 Dec 2006 4:37 PM - 12 messages
I have three machines running the same C# app, all accessing the same MDB file, which is shared on one of the machines.  All machines have the same version of MDAC (2.8).  The database does not use Access ...
Score SqlDataSource.FilteExpression "!=" does not work?
Assimalyst - 13 Dec 2006 10:06 AM - 2 messages
Hi, I have a SQlDataSource that binds to a GridView. I am using a parameterized FilterExpression to filter the results. If i use MyField = '{0}' it works fine. But i need to do MyField != '{0}'. This breaks with an error: 'Cannot interpret token '!' at ...
Score Can connect to SQL 2005 via VPN with .NET 1.1, but cannot with .NET 2.0
janezcas - 13 Dec 2006 8:31 AM - 1 message
Hello, I have some problems when connecting to the SQL Server 2005 via VPN connection after the application has migrated from .NET 1.1 to .NET 2.0. The architecture of the application is the following: ..NET 2.0 application (Windows forms) is installed on the client ...
Score Typed Datasets with ComboBox
gordigor - 12 Dec 2006 9:30 PM - 2 messages
I am sure this is going to be obvious, but I can't see it. I have a strong typed dataset called "Clients" with two columns: ClientName , ClientCode. I want to attach a ComboBox to this dataset. Here is the ...
Score Modify a Binding Source
Jean Dophin - 12 Dec 2006 6:53 PM - 4 messages
I wonder if I can modify the bindingsource to dispaly specific field from a table rather than displaying the whole table.  Here is what I am talking about.  I am using a commercial grid to display my data. I don't have any ...
Score Direct Data Access - Best Practice?
Saubz - 12 Dec 2006 5:12 PM - 5 messages
Hello.  I currently use a lot of direct data access in ASP - I really don't like disconnected for some reason.  What I'm wondering is if the method I use is acceptable or if there is a better way.  This is the basic code I use ...
Score Sql 2005 and User Defined Data types
Steve B. - 12 Dec 2006 4:38 PM - 5 messages
Hi, I've a sql 2005 db with one column of a user defined type (a custom CLR type). How can I deal with UDT in DataSets ? VS throw an error when trying to design a DS with the custom type... is ...
Score Oracle connection errors with Enterprise Library 2.0
ajmastrean - 12 Dec 2006 4:08 PM - 1 message
Folks, I would have put this in the oracle group, but all my oracle products are working fine... I have the Enterprise Library 2.0 (January 2006), C# .NET, and an Oracle database. I am trying to query the database using the Data ...
Score Refreshing a disconnected table
Warren Sirota - 12 Dec 2006 4:01 PM - 1 message
Hi, I've got a global in-memory table which is kind of a control table for a lot of threads within one application. I read the table from a database at the start of my app, then I dynamically assign values to a number of ...
Score ms sql server 2005 not seen in server explorer - can't see any SQL Servers
ray well - 12 Dec 2006 3:50 PM - 9 messages
i had just posted the following: --------------------------------- i have ms sql server 2005 installed on my system (installed when i installed 2005) and it is running(i can see it is running as a service), but it does not show up in server explorer. i never had a need to use it till now so i ...
Score Re: Converting from System.Web.Mail to System.Net.Mail
Spam Catcher - 12 Dec 2006 3:46 PM - 1 message
73g2000cwn.googlegroups.com: He does have a point ... Remoting is another example. ...
Score ms sql server 2005 not seen in server explorer
ray well - 12 Dec 2006 3:13 PM - 1 message
hi, i have ms sql server 2005 installed on my system (installed when i installed 2005) and it is running(i can see it is running as a service), but it does not show up in server explorer. i never had a need to use it till now so i ...
Score How do I copy customers from an ODBC to an OLEDB
Tony Girgenti - 12 Dec 2006 1:57 PM - 10 messages
Hello. I'm trying to copy customers from an "ODBC connection to QuickBooks" to an "Access MDB" table called "QB CUSTOMERS". The first thing i do is delete the customers from the Access table using an SQL String as "DELETE FROM [QB CUSTOMERS]".  That works OK. ...
Score Item has already been added. Key in dictionary
avital - 12 Dec 2006 1:56 PM - 1 message
Hi, When inserting a new item i get the following error: Item has already been added. Key in dictionary: 'Cellular'  Key being added: 'Cellular' As far as I know you get that error if you enter the parameter more ...
Score Problem with datareaders in transactions
CD - 12 Dec 2006 8:55 AM - 2 messages
Hello All, I am having problems using a datareaders within a transaction. I have attached a stripped down version of my code that exposes the problem. The problem occurs when I commit the transaction. I get an exception "There is already an open DataReader associated with this Command which ...
Score Converting from System.Web.Mail to System.Net.Mail
Nathan Sokalski - 12 Dec 2006 7:39 AM - 2 messages
I am moving an application that involves sending email from 1.1 to 2.0. I am attempting to convert the email-sending code from System.Web.Mail to System.Net.Mail. I think I have most of this accomplished, but I am trying ...
Score System.AccessViolationException
amper amper - 12 Dec 2006 7:02 AM - 2 messages
Why? please tell me if you know System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.    at System.Data.Common.UnsafeNativeMethods.IRowset.GetData(IntPtr hRow, IntPtr hAccessor, IntPtr pData) ...
Score Want to make some extra cash on the side? LEGIT!
TT - 12 Dec 2006 6:03 AM - 1 message
<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> I was just told about this fabulous program today, you make money for doing relatively nothing! <BR>any people have been getting ...
Score Primary Key, Identity Column - Problem adding row to strongly typed data table - "Column 'ShipmentID
stephanieschipper - 12 Dec 2006 2:14 AM - 1 message
All, I am using a strongly typed data table generated from a SQL Server data table that uses a primary key field ShipmentID that is also an identity column. The problem seems to be that the auto-generated code below: ...
Score ARITHABORT + IF Statement + Label Causing SqlException
craig.wagner - 12 Dec 2006 1:01 AM - 1 message
I had a heck of a time coming up with a subject for this one. I don't know if this is an ADO.NET or SQL Server issue, it's a pretty gray area as far as I'm concerned. ...
Score ADO.NET not exposing maxlength even though the data exists
PCRmike - 11 Dec 2006 8:35 PM - 4 messages
I have been trying to understand why the maxLength column is not populated when a datatable is populated using the SqlClient.SqlDataAdapter.Fill() command. I do not know why it requires another round trip to the server via fillschema() when the data is ...
Score Has anyone had any luck in creating a strongly typed dataset in visual basic 2005 express?
C a r l o s A n t o n i o - 11 Dec 2006 6:17 PM - 2 messages
Hello all, I've seen this ASP.NET tutorial: "Creating a data access layer". It worked prefectly well in asp.net and vb.net 2005.  Now, i want to do the same with VB 2005 Express Edition, but connected to an Oracle Database. ...
Score Can't Run Application Outside of Development Folder
Tony Van - 11 Dec 2006 5:07 PM - 3 messages
I rewrote an existing VB6 app in .NET as a learning tool. Works good. The problem is, it won't run in any folder except the folder that it was build in.  I get an unhanded exception error telling me it couldn't load a form because it couldn't find ...
Score DataAdapter changes insert-command at Update
Patrick - 11 Dec 2006 4:14 PM - 4 messages
Hello I try to do the following thing: SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM test",new SqlConnection(this.ConnectionString)); adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(adapter); SqlCommand insertCommand= cmdBuilder.GetInsertCommand(true); cmdBuilder.DataAdapter.InsertCommand = insertCommand; insertCommand.CommandText = insertCommand.CommandText.Replace("@mydbinteger", "33"); ...
Score Anonymous User AND NT Authentication Works On Localhost But Not On
Dan Sikorsky - 11 Dec 2006 3:15 PM - 2 messages
I have localhost directory security Anonymous User and NT Authentication both checked. Anonymous Users can get to my web page and NT Autheticated Users can pass in the logonname where I can read it in my web page. However, on the actual web server, I can't reproduce this. Either I can ...
Score Differences between OleDB and IBM.Data DB2 connection
ajmastrean - 11 Dec 2006 2:59 PM - 2 messages
Folks, What are the differences in terms of functionality and performance regarding connections to a DB2 database using the OleDB provider < IBMDA400.DataSource.1 > versus an ADO.NET or IBM provided class like < IBM.Data.DB2.iSeries >. ...
Score master/details & UpdateCommand problem
Peter Demeyer - 11 Dec 2006 2:54 PM - 1 message
I have a simple database with 3 tables: customers(id, name) articles(id, description) sales(customerID, articleID, date) and one view called articles_and_sales: SELECT * FROM articles, sales WHERE sales.articleID=article.ID Customer names should appear in a combobox Articles.description and sales.date must appear in one datagridview and ...
Score Delete a row from Excel via ADO.NET
Jan Lorenz - 11 Dec 2006 8:00 AM - 5 messages
Hi, I have a ADO.NET - Connection to an Excel file. UPDATE and INSERT works fine. Now I want to DELETE lines, but it doesn't works (I get an error message "Deleting data in a linked table is not supported by this ISAM."). ...
Score mdb & vb.net
John - 10 Dec 2006 6:37 AM - 12 messages
How do I input and retrieve data from tables in an .mdb file? I use vb.net ...
Next »