Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Re: Datagrid Column Width
SanBoloni - 2 Dec 2006 12:45 AM - 1 message
I 've find this useful information in aol for the community of [link] Get it *'getting a credit card with no credit' ([link])*. One other 1 *'creditcard' ([link])* site you can find here again it's best aboutc *'www chase credit cards' ([link])*. Here about *'what is the best credit card for me' ([link])* -- SanBoloni ------------------------------------------------------------------------ SanBoloni's Profile: [link] View this thread: [link] ...
Score retrieving BLOB from Oracle
matt - 1 Dec 2006 9:55 PM - 10 messages
hello, im doing my first ASP.NET app that inserts & retrieves files from Oracle (no need for a discussion on *that*!). i learned first-hand of the somewhat awkward technique for inserting binary data into an Oracle BLOB column via ADO.NET. since my files are ...
Score Sample search module
Hemang - 1 Dec 2006 7:11 PM - 2 messages
Hello I have a windows form where I want to put a search button (easy part), which opens another form, and lets the user search records by first name, last name, city etc. and when the user clicks on the record and selects ok, ...
Score Help
Erencan SAÐIROÐLU - 1 Dec 2006 6:40 PM - 2 messages
Hi Folks, I use a datatable. I've passed DBNull.Value to a integer field. And i update it with dataadapter. It's raise an exception like "@p2 parameter not supplied". I catch sql statement with sql profiler so i see that the integer field's ...
Score Advice requested for SQLCE MDI app
Garry - 1 Dec 2006 6:13 AM - 6 messages
I am rebuilding/rewriting a VB6 desktop application in VB.NET. As a strategy, I am loading a complete SQLCE database file into a DataSet, manipulating the data in various tables and 'pouring' the data including any changes, back to the database file when the user closes the app. ...
Score DataView
Charles A. Lackman - 1 Dec 2006 1:31 AM - 4 messages
Hello, I have Two Tables in a dataset (Table1 and Table2).  I have created a relationship (MyRelationship) and created a View (MyView) from them.  I am able to  display the data the way I want but I am trying to setup a search ...
Score Adding images to the database
Earl - 1 Dec 2006 12:09 AM - 5 messages
Looking for an idea here. I've got a .Net app connecting to SQL2005 where I allow users to add pictures to the database. But I don't want them adding gigantic images, so I'm looking for an idea on how to control how big of an ...
Score RowChanged or RowUpdated
Jason James - 30 Nov 2006 9:12 PM - 5 messages
Hi, I am trying to figure out if I should be using the RowChanged event of my tableAdapter or a RowUpdated event of a dataAdapter? I have used  data connection to my database file to create a typed dataset and table adapters to allow me to load and save data to my ...
Score API instead of osql
David Thielen - 30 Nov 2006 7:03 PM - 24 messages
Hi; I have a script I use to create a database. At present our code calls osql to run it. Is there a .NET API to do this instead? That way I get an exception if there is a problem and can display it. ...
Score Sorting the Table.DefaultView
Joe - 30 Nov 2006 6:32 PM - 4 messages
I noticed that strings don't sort correctly when they contain numbers. For example: Series: 0 Series: 100 Series: 101 Series: 101 Series: 102 Series: 11 Series: 110 Series: 112 Series: 113 Series: 128 Series: 13 Series: 130 Is there anyway to provide a custom sort? I believe string.Compare() does a ...
Score AutoIncrementSeed CHANGES after DataSet.Fill
Trygve Lorentzen - 30 Nov 2006 9:33 AM - 7 messages
Hi, this was one of a numerous really annoying issues when moving from .NET 1.1 to .NET 2. After I fill my DataSet with values from the database it sets all AutoIncrementSeed values automatically to the next number in the sequence. I ...
Score Why does insert command not work in a transaction?
Dan V. - 29 Nov 2006 11:06 PM - 5 messages
Why does the insert command not work in a transaction?  I am using OleDb with MS Access and ADO.Net and VS 2003.net I create the connection and dataadapter initially in a function and return them so I can reuse them ...
Score DataGridView bound to TypedDataSet - Update causes Concurrency Violation
rmgalante - 29 Nov 2006 9:45 PM - 6 messages
I have a Windows Forms Application with a DataGridView which is bound to a typed DataSet. For reasons specific to the application, I add a record to the database table when a button is clicked on the form. This button creates a record with default values so the user only has to ...
Score Generate a database from XSD?
Brad Navarro - 29 Nov 2006 7:53 PM - 3 messages
Hello, Does anyone know if it is possible with .NET to load an XSD file and use that as a database schema template to generate a new database?  I had hoped I could load the XSD file into a System.Data.Dataset object, ...
Score Multiple Tables SELECT command with Microsoft Access 2003
matthew.macdonald-wallace - 29 Nov 2006 6:35 PM - 3 messages
Hi all, For various reasons I am accessing data from an access database with multiple tables.  I am unable to upgrade to SQL Server (even the express edition), so I have to do this in access. At the moment, my sql statement is as follows: ...
Score DataTable joins
J055 - 29 Nov 2006 6:06 PM - 4 messages
Hi I have two different DataTables populated with rows from separate queries. They both share the same column ID. I would like to create a new DataTable where the rows in both tables match, i.e. like using an SQL inner join. ...
Score dataView of a single columns ???
jobs - 29 Nov 2006 5:19 PM - 4 messages
I have a asp.net gridview that I want to send a single column to a stored procedure as an XML string .. the code produces an xml document with all the columns. I only want to send a column called "RatePlanId" ...
Score BindingSource Problem
HLong - 29 Nov 2006 3:20 PM - 3 messages
Hi, I am trying to setup an App to access and edit data on the Northwind database.  I have a DataGridView, a BindingNavigator, a DataSet and a BindingSource on a form. On load, I set the BindingSource.DataSource=DataSet, ...
Score Calling an Oracle Stored Procedure
Carol K - 29 Nov 2006 2:13 PM - 2 messages
When I call a stored procedure from my app, I recieve the following message ORA-06550: line1, Column 7: PLS-00801: internal error [22503] The code is ... OracleCommand^ UserPassCmd = gcnew OracleCommand("UNIX_PACK.VERIFY_ID(log_name, inuserpasswd, inapplid, outuserid, outuserpasswd, outrc, outmess)",NestConnection); ...
Score multiple users connecting to access database at the same time
yunusgulsen@gmail.com - 29 Nov 2006 9:37 AM - 1 message
hi; i have an application which has a table like this table customer ---------------------- id : autonumber name : text surname : text table email ---------------- id cutomerid: (id in table customer) number email : text when it is used by only 1 person there is no problem ...
Score TableAdapters and HasChanges
JJ - 29 Nov 2006 3:52 AM - 2 messages
I am really confused about TableAdapters, Datasets in general.  I have added them to my Windows Form simply by dragging fields onto my form. Now, when the user presses the Cancel button, and I want to determine that something has changed, ie, If Me.MYDataSet.HasChanges = False, ...
Score Does anyone know? Please Read [Third Attempt]
DaBrain - 29 Nov 2006 2:04 AM - 1 message
If you got the answer, thank you so much. OK I have to ask this question again as I know it can’t be that difficult, nor is it that rare. So a lot of people are doing something ...
Score VS 2005 datatable.copy NoNullAllowedException
MikeS - 28 Nov 2006 10:00 PM - 5 messages
I am getting a NoNullAllowedException when I try to add a datatable to a dataset by using dataset.tables.add(datatableOld.copy()).  I checked the AllowDBNull property on the column of datatableOld that was throwing the exception and it is set to "true".  I am not sure why I am getting this ...
Score Inserting Records Best Practice
Mario G. - 28 Nov 2006 9:13 PM - 12 messages
Could anyone point me in the right direction for the best way to insert a record into a SQL database using ADO.NET with 150+ columns? 1.  DataReader + SqlCommand.CommandText + Insert statement 2.  DataReader + SqlCommand.Paramerterized Query + Stored Procedure ...
Score SqlException
Roy - 28 Nov 2006 7:07 PM - 2 messages
I have the following code to open a database. Since I don't have the db as specified in the connectionString, the connection.Open() will throw an SqlException. My question is why it opens the "SqlException occured" dialog before it goes to the catch block? Is there a setting to turn the dialog off? ...
Score DataTable/DataSet in Business Object Class
manoj241176 - 28 Nov 2006 5:18 PM - 2 messages
Hi,    I am implementing Business object, but while implementing this I want to have DataTable or DataSet as part of Business Object. For example, I want to bind controls directly to these Business Objects. So please suggest me how can I achieve this?? ...
Score including odp.net dlls in an msi
Abhinav - 28 Nov 2006 4:20 PM - 3 messages
Hi, I have a C# Desktop application that uses ODP.NET as the data provider.  I want to find out if there is a way to include ODP.NET dlls along with the application MSI.  Just including the Oracle.DataAccess.dll within the msi ...
Score Problem adding aggregate datacolumn to datatable
Trygve Lorentzen - 28 Nov 2006 8:47 AM - 4 messages
Hi, I've tried with: dsAESWS.Tables["aes"].Columns.Add("F35_GROSSWEIGHT_TOTAL", typeof(decimal),"Sum(Child(dsAES_aes-aes_packages).F35_GROSSWEIGHT)"); dsAESWS.Tables["aes"].Columns.Add("F35_GROSSWEIGHT_TOTAL", typeof(decimal),"Sum(Child(dsAES_aes-aes_packages.F35_GROSSWEIGHT))"); Both give me an exception like this: syntax error in aggregate argument: Expecting a single column argument with ...
Score DataSet Question -- Simple Concept? Beginner to 3-Tier asp.net
Rangy - 28 Nov 2006 12:48 AM - 4 messages
Hi, I am trying to be a thorough coder and create an app in layers.  I can do it using the sqldatasource but I really want to try creating the app with tiers....thus.... If I use VS2005 to create a typed data set, I see that I can allow VS ...
Score Inserting Formatted text including images into SQL 2005 using ASP.
pmn - 27 Nov 2006 4:02 AM - 2 messages
Hi, Im trying to develope a web application that could be used for stroing data such as formated text including pictures . the text should be inserted in word documents,html or xml. please does any one can help me ? in other words i want to develope somethings like a NEWS WEB SITE that every ...
Score Internal connection error
Agnes - 26 Nov 2006 12:09 PM - 8 messages
I found that when I fill over 10,000 records to a dataset, there will be an error "Internal Connection error". Please help. ...
Next »