Hi; We have a select that does work on Oracle, but does not work when going through the OracleConnection ADO.NET connector. One column name is 28 chars long and the other is 30 so they should be ok. Does the connector count table + column name length when we do table.column in the selec...more >>

Transactions with .NET 2.0. If I code this in C# method: Customer objCust = new Customer(); using(TransactionScope scope=new TransactionScope()) { objCust.UpdateData(); // updates customer record via stored procedure with a standard excutenonquery scope.Complete(); } ...more >>

Hi all, I have a TableAdapter with a connection to an SQL Server database that uses stored procedures to insert and update records. Problems occur when I attempt to insert unicode (Chinese) characters in the database; all that comes through is question marks. The parameter to insert the string...more >>

I have a program that has hand written database connections and DataGridView that connects to my database on sql server using computer's name .this works fine locally BUT problem occures when running my app on local area network causes this exception " Application attempted to perform an ope...more >>

Hi All, I'm working on reporting (web) application for my company that displays order information. It has approximately 15 - 20 different filter options so that various departments can extract data they need to view. I'm using a normalized, relational MSSQL 2005 database, which contains 37 ...more >>

I'm new to mobile app development so I'm going through Glen Gordon's on-demand webcast series "Mobile Web Development with ASP.Net 2.0" Using VS2005 I created a mobile app, a connection to Northwind and a dataset named "Orders". Then in a button click code block: dim ta as new OrdersTable...more >>

Afternoon all, Just after confirmation that I can read from an oracle ref_cursor using the Microsoft data connector supplied with Visual Studio 2005 rather that having to get oracles latest ODP offering. Reading other posts here it seems to imply I can but I just need someone to tell me strai...more >>

Hi Everyone! I work in a company that has developed several VB.Net Web applications. Currently we use SourceGear's Vault for source control and versioning for the application files. One area that have been left behind a little bit is the version control on database level. Our typical installa...more >>

Not sure where to post this, so will start here... I am developing an web application that my company will host. The data back end on the web wil be SQL server. For each customer that subscribes to our product, I need to build a data bridge from their in-house legacy data to our SQL server. I ...more >>

Hi to all, I've a sqlserver 2005 database and an application developed with vb.net 2005. To manage data I used typed datasets created by the wizard. Now I need to change the data type of a db field from interger to floating. When I change the data type the dataset is not updated and I' m not abl...more >>

Hi I have some data in a access database and some in a sqldatabase. Both us the same index. I can connect to both and display the results. However now I would like to pick 2 columns from each and show the 4 columns in one table. Can anyone show me how to do that? Thanks Torben ...more >>

I am currently reevaluating how I do look ups and searches. What is the best method for handling forms where user can search by different criteria. Example, A member form allows users to look up a member by either SSN, Lastname + firstname (whole or partial), all active or inactive or by an ...more >>

Hello Developers, I have a DataGridView and BindingNavigator controls bound to a BindingSource control. User can delete a record using different methods: by pressing the DEL key, pressing BindingNavigator Delete button. I may also want to add some other methods calling BindingSource.Remove...more >>

Hi, I developed several NET applications with SQL server and Access databases, and I feel really stupid asking this question, but everytime I used SQL database name in connection strings or I used a connection string with placeholders for Access databases, and I constructed the real path to M...more >>

This is an example of Inserting and Retrieving data from xml file. http://www.hanusoftware.com private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here if(!IsPostBack) { BindGrid(); } } private void BindG...more >>

Is there a way to use a DataAdapter to retrieve data via an SQL function? I have done what I need to do using a stored procedure that returns a 1x1 table, but it seems like it would be much cleaner if the single value returned by a function could be obtained. Maybe there is some mechanism ...more >>

I do not really understand this concept if it is a concept. I've heard of it in relation to MCF, but it seems that it is refered to as if it is more of a concept. Can any one explain what a DataContract is or where i can find a definition, not just and example of where it is used? Thank You...more >>

Hi all, i am using sqlbulkcopy to insert content to table, how will i get total rows inserted into table without using any eventing. and is it possible to do bulk copy from sql table to csv file? thanks in advance. ...more >>

Using .NET 2 with the above. Instead of doing Database myDB= DatabaseFactory.CreateDatabase("myDBNameDefinedInConfigFile"); to connect to an Oracle 10g database How can I programatically set the UserID and password (which I take from the User Interface) at run time?...more >>

I have been connecting to MS-Access database using Jet 4.0 from C#.NET. My application works finely on my computer on which I've made the application. But I observed a strange behavior. When I run my application on other computer that is installed .NET Framework, I get the following error "Sy...more >>

I'm trying to write an all-purpose program that will: 1. list all the servers on the network. 2. list all the databases on any one server once it is clicked. 3. list all the tables in a database once it is clicked. 4. list all the columns in a table once it is clicked. The first step I ...more >>

Dear all, I am buidling application where most of my back end database is SQL server. Now I have a set of customer requesting for instance to use mySQL instead of SQL server. They are many programming language as many database product, so knowing them all is quite impossible. Its better t...more >>

do release builds have the same amount of info in exceptions? e.g. will exceptions cought in release builds contain stack trace etc.? ...more >>

'System.DBNull' is a 'type', which is not valid in the given context If dr["OfficeName"] is not an object then what is it? It is certainly not a string because it hasn't yet been cast as one. private void PopulateControls() { //If this is in AddMode then the table will be empty if (_d...more >>

Dear All, I have problem on inserting a record to database..Although it looked easy.. i have caught up with following issue .. please go ahead and help me to find solution I Need to insert records to a data base,for which i am using Typed dataSet.(I used DataSet Designer to create one) Then ...more >>

how to force a .net application to use .net 2.0 ? this windows service is about 4 years old and im pretty sure is using .net 1.x runtime. Is there soem setting in the installer that says to use .net 2.0 instead of .net 1.0? this windows service is developed in visual studio 2002 ...more >>

Hi all, I have troublem to get parameters output to return value back. I'm using SQLdatasource and stored procedure to get information and delete row from gridview. I don't have any problems get information and display but when I want to delete some row from gridview and return parameters out...more >>

Hello Developers, What I am trying to accomplish may seem trivial: simple data entry form with DataRowView, BindingNavigator and several bound TextBoxes, DataRowView in read-only mode. When the user modifies data through one of the TextBoxes and then attempts to change the curren...more >>

How do you get the actual value of a timestamp from a SQL Server 2000 database table using VB.Net? My recordset is returning a "System.Byte[]" Type. How can I convert it into something usable?...more >>

What's the best way of having a .NET application interact with SQL server without compromising security? Here's my issue: Let's say you want a user to be able to read, write, and delete records from a SQL Server table. It's simple enough to give the user logon credentials on SQL Server allo...more >>

Can only help me please - this might not be easy to explain but I will try. I have a class that updates the database for the program. I want to use a transaction but I am having issues. I have a function called TableExists (Below) that you will see checks to see if the table already exist...more >>

Hello Developers, I have a problem I really do not how to correctly handle. Very simple scenario: DataGridView bound to BindingSource, BindingNavigator attached, BindingSource bound to a DataTable, let's say, with just one column. Also, I have a TextBox bound to my BindingS...more >>

Hallo to all I'm on dot net framework 1.1 I have a data table populated with about 300k records I have a serious performance issue filtering the data table using data table select methode (I can not use find on the rows collection because I search for non PK values) there should be a way to...more >>

Hi all, I want to load content into datatable which are in CSV file format. What i am doing is reading one text file which is in csv format into string. Later on i want this string to be in datatable. Can i bind strring content to datatable? Please help me asap. thanks in advance....more >>

is a reader automaticaly disposed if the connection it is associated with is closed? what will happen if an app: while true open connection open reader close connection end while ...more >>

Hi, I'm using Microsoft Data Block's SQLHelper to insert record in a DB. As a parameter to the function I pass a stored procedure and all the stored procedure parameters I need to use transaction to do this, but my problem is that I have to insert information across 4 databases,...more >>

i seem to be having memory issues, will deplying a release build instead of a debug build help with memory usage of my .net process? ...more >>

I am somewhat of a newbie to .NET development and my SqlClient dataset throws the following runtime error when trying to update rows in a SQL Server table: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column informat...more >>

Hello, is it possible to generate a typed dataset from a xsd-file? Background: I want to write a export-function for some data stored in a database. For this I got a standardized interface description as a xsd and xml file. Is there a possibility to generate a typed dataset trought a as...more >>

Hello, I have a problem and I'm hoping it will ring a bell with someone here. :) In my ASP.NET website, I have a custom calendar control which highlights ranges of dates based on a data source, and also allows a new date range to be selected. To select a new range, the user clicks on the f...more >>

is there some per-process-limit on memory in .net processes? is there any way to increase it? i keep getting System.OutOfMemoryException when my box has 8 gigs of unused memory. ...more >>

Hi all, I have a problem in that I have written a .Net 2 application for a customer that performs significant amounts of manipulation - 250,000 records manipulated and updated with combination of update and select into commands. The issue is that it works fine on my old slow development 200...more >>

Can someone please help me. I have created a simple form. 3 Controls - ID, Firstname and Lastname. I have added a SqlDataadapter, Dataset etc etc. When I call Fill(Dataset) it all works fine. I can edit the values on the screen but when I post nothing happens unless I call EndEdit. ...more >>

I thought this may help other people learning ADO.NET. Having, I thought, got a sufficient grip to 'go live' I set up an app using Access 2007 and ADO.NET. During testing everything worked except my 'AddRecord' function, which kept complaining of a duplicate entry in an indexed field. Aft...more >>

Dear all, I am passing parameters to store procedure without any troubles but parameters list are less than 10 parameters, still manageable. But we have a situation where we do not know for instance the number of variable my final customer would like to monitor and store to database. It c...more >>

hi, i need help on setting datatype of a table's column at runtime.. i'm loading a dataset from an xml file... after loading, i want to set the datatype of one of the column as int32.. how can i acheive it.. is there any way to set the datatypes of the columns before loading the data from x...more >>

Hi all, I'd like to do something that was very easy with ADO in VB6. I'd like to do a selection in one table and be able to search on the group of registers, update or even insert one new. This is possible to do in ADO .NET? How? Thank you in advance. Alejandro ...more >>

Hi, I do a "select * from tablename" in my dataadapter. In most cases this is fine because all those columns are also defined in the strongly typed dataset I'm working with. However, if I add a few new columns or want to use the dataadapter to fill a different dataset where not all columns ...more >>

I'm grappling with understanding some ADO.NET issues. I'd appreciate any help. If I write a .NET Windows application that uses ADO.NET, what needs to be distributed with my application in order for it to run for Customers using Windows Vista? I understood ADO.NET is included with the .NE...more >>

Hello, I have a very simple question I could find nothing about. When, in a .NET application, I connect to a database with a ConnectionString like "database=foo; server=220.40.231.2; uid = root; persist security info= false; pwd=blabla", does my root password travel in clear-text? AFAIU,...more >>