Do most RDBMSs know that they have their data in time zone X (whatever that is) but adjust to the time zone of a client that connects to them and return dates adjusted to that client's time zone? Does ADO.Net communicate client time zone info to the server as part of a database connection? ...more >>

When i get a dataset from db, and I check the dc.DataType.Name value of a column, it gives me "String" for that particular column. How do i know if that String is a Varchar or nVarchar? Thanks. ...more >>

Hi, I am new, I have a c# app that uses a mdb file for holding statistics, these stats are dumped into the mdb from one process every minute, and obtained from another process periodically ( at the users call) which then returns the stats. Do I have to worry that there will be an access prob...more >>

Hi , I have a dataset that was populated via ReadXml where the source xml contains nested tables. When I write the dataset back out with WriteXml I get the same hierarchical ( nested ) document structure as was present in the source document ( as expected ). I have a situation where I need the...more >>

Hi Can anybody tell me if there has been any significant improvement in the speed that rows from a dataset in a client can be transferred i.e. updated, to a database on a Server? The reason I ask is that using VS2003 I have created a dataset via a table in on the Server, added several hundr...more >>

I have just stumbled upon this fact. My scenario is the following: >From a web browser i click a button which fires of a call to retrieve data from a table in Oracle. In the same call, i do another retrieve using the same connection object. The second retrieve crashes becuase there is no passw...more >>

HI everyone, i'm so stress out because something so simple but i can't figure out how to do it. I have a dataset name ds (typed dataset), side that ds contains a table name Employee. ds.Tables["Emploee"].Columns["City_Fk"] ex.say this table contains 50 records, and 10 records has City_Fk = ...more >>

Hi, I am executing a set of semicoln sperated commands through ExecuteNonQuery, the query length is about 10000 characters comprising of 200 repeated command (identical command operating on different record ids). Each time the ExecuteNonQuery is called the memory is increasing by few mega bytes....more >>

I posted this on the msdn forums but wasn't having any luck. I am using Visual C#, .Net 2.0, and SQL Server Express (soon to be ported to SQL Server). I have a dataset, binding source, and table adapter used in a form. I am binding the controls to the binding source. I use the SqlCommand m...more >>

Hi, all: We have a Windows application that make operations against an Oracle database. The business logic components are in the server and are accesible from the client interface trought a WebService. The business logic components call the data access layer components and obtain the results....more >>

Is there a trick to keeping a Typed DataSet in sync with the underlying database other than either manually making the changes or deleting and adding the table back? For example, I've created a Typed DataSet with about 10 tables, each table has between 1 and 10 TableAdapters. Now, weeks la...more >>

i am doing online cinema reservation project, and i have this problem in the Reservation Process, i want the user to always experiance a Fresh version of the Seats avaiable for him to book, the problem is divided into 2 parts : first how to make sure that the seats avaiable to him is the lates...more >>

I have install e SQLServer 2005 in another machine with a specific instance. The server name is Server1 and the instance name is MyDatabase. When I wnat to add a new ODBC datasource, I enter Server1\MyDatabase as server in the Wizard, but it say that "The server does not exist" How can I c...more >>

First - English not so good. I need a list of all database servers in my domain and I use code like DataTable table = DbProviderFactories.GetFactoryClasses(); foreach (DataRow row in DbProviderFactories.GetFactoryClasses().Rows) { DbProviderFac...more >>

In SQL 2005 management studio, when you open a large table the grid displays the rows in the grid asynchronously, you can manipulate the result grid while all the records are being loaded...Anyone know how to achieve this in VB.NET or C# ? ...more >>

I installed SQLserver express as well as VS2005 Standard. I know the database server is functioning correctly since I can manipulate it with the sqlserver express tools. However when I try to connect to the server in VS either programatically or through the server tools I get the same unfortun...more >>

Hi Everyone! I'm in need of help again! I'm just wondering if WinForm DataGrid can have Excel like AutoFilter? Here's an example: http://www.dotnetforce.com/Content.aspx?t=a&n=210 But again, this only in ASP.NET DataGrid. Does anyone know the easiet way to implement this feature in WinFo...more >>

Hi, I have an integer rowcounter column in a Table and I want to incremented it after AddRow. AutoInc is not possible, because I want to change it later. RowChanged doesn't seem to be the right place. Is there any OnAfterInsert like in Delphi? Thanks Friedhelm Drecktrah ...more >>

We're taking our VB 6 application, which uses RDO and moving it to .Net 2.0. We're doing this by recreating each form from the ground up, not using the upgrade wizard. Our application has about 200 forms and our database has over 150 tables and about 400 stored procedures. So, it's rather co...more >>

Hi, In my company we are currently using ODBC and i would like them to switch over to ADO.NET 2.0. Unfortunatly i can not find a document with any good reasons. I know that datasets, datareaders, ... are more userfriendly but how about performance is it proven to be resonably faster? Are th...more >>

Hi, I am using SqlDataAdapter and i want to do just the delete update to delete child table and after that i want to do the InsertCommand and etc... So how can i choose to do Insert Or Update or Delete not with DataAdapter.Update method.. Thanks, Yossi ...more >>

Is possible to connect to SQL 2005 from ADO.NET 1.1? I need to migrate our system from SQL Server 2000 to SQL 2005 duo license politics in our client company. I need to know if is possible to connect to SQL Server 2005 using ..NET Framework 1.1 (ADO.NET) or i need to migrate our application to...more >>

Hi, I am having problems connecting to a local SQLServer2000 database using ADO.NET. I am using a 3rd party assembly which I have no control over, and the database connection string is hardcoded into the application (nice). The connection string looks like this: "UID=john;password=johnspas...more >>

Pretty straight forward question, right? I'm asking because this is one of the recommendations I'm getting from VSTS code analysis. My problem is that I have a pattern of code sprinkled throughout much of my business layer where data access code calls static methods that, in turn, call stor...more >>

Hi All! I would like to make my WinForm DataGrid control so that user could easily edit the items in the **related table**. For instance, I have customers table and it has one-to-many relationship with the customerType table. I would like the WinForm DataGrid to display a column with "Cu...more >>

I have been trying to figure out a way to convert System.Transactions.Transaction.Current to System.Data.Common.DbTransaction with no luck so far. Is this even possible? I am using the Enterprise Library, and several of their calls take in a transaction, but it is of type DbTransaction. I ha...more >>

Hello, does anyone have any opinions on data access functionality ? What is the best way to use the data access components inside of Visual Studio? Do we drag and drop the components on the screen and link them to the database, creating a dataset etc…? Or is it more efficient and fast...more >>

Any clue to why this newRow call sets "programSelected" to null no matter what I have tried? Further explanation, this function resides in a form2 which I have been able to give access to form1's (MainWindowReference's) public or internal elements. Also "programSelected" is an internal glob...more >>

Hi, I am developing a web application in ASP.NEt (VB.net) which runs on SQL server as a backend database. I want to create a standalone database creation utility (not web based). The database creation utility should be a standalone EXE file which can be executed to create a new database, obviou...more >>

Hi, all I have developed my asp.net application in Visual Studio 2005 IDE. It is well known that the Visual Studio 2005 IDE is based on framework.20, but I want to know, whether it is feasible to use framework1.1 to build my application under VS2005 environment? If possible, how to do it? ...more >>

I have a RowFilter which is doing a not in (). The not in contains 600 items for a single column. For example RowFilter = "ADate not in (600 DateTimes)". This takes several seconds to run. Is there a better way to handle this? ...more >>

Hi Is there a way to create lookup columns in tables in the typed datasets? Like CityTable ---------- CityID CityName Employee -------- EmployeeID EmployeeName City -> foreign key to CityTable.CityID CityName -> lookup column, will get the value from CityTable according the Cit...more >>

I have a datagrid which enables paging and the data is displayed in it when user selects an item from a drop down list. The code for populating data into the Datagrid is contained in the DropDownList1_SelectedIndexChanged event handler. The Datagrid can only display 10 rows at a time. When ...more >>

Hi How can I determine whether my code is ran from within the sql server or not? I want to write a block of code which opens a connection to the DB - using a context connection if it resides in the SQL process and regualr if it is not. How could it be done? Thanks saar ...more >>

I have an xml file where the top level units have the form <a> <a1>1</a1> <a2>1</a2> <a2>2</a2> </a> where there can be any number of <a2> elements (at least one) in each <a> element. This should generate a two table data set with an "a" table and an "a2" table. If I declare a2...more >>

Hi All, I'm working on an distributable application that will have to connect to a remote sql server over the internet and would like to find out what will be the best way to implement this type of a connection. I've been googling for hours now and can't find a straight answer as to what i...more >>

I have made a Data Repository Class that holds all the Methods for the Objects that i use in my System such as Order,Client,etc Example for what i want to do: In the Client Class I want to inherite from the "DataRepository Class" **ONLY** the methods that is related to the Client such as GetC...more >>

I am having a problem saving an image with the same name it originally = had. I have two similar versions of my code, one in which I close the = FileStream used to open the original image before saving, the other in = which I close the FileStream afterwards, although both return the same = error...more >>

Hi I am having some trouble using ado.net and was hoping someone could help me understand what i've messed up. I am currently using ado.net from inside a C# asp.net project but i've also tried to do the same thing with just C# and ado.net and it gives me the same grief. OleDbConnection cn = n...more >>

hello, when i create a diagram of class, ya you it a means of launching an automatic creation of a base of data being pressed on this diagram?? thank you ...more >>

I have a DataTable with three columns "UniqueID", "A" and "B". Rather than pass updates like: <DataTable UniqueID=1 A="data.." B="data.."/> The application gets XML from a 3rd party and they want to economically send data packets over the network like so: <DataTable UniqueID=1 A="...more >>

Hi, I have a DBF table that I can access using from VisualStudio 2005 via ODBC OdbcConnection conn; string connectionString = @"Dsn=Pliki programu dBase;defaultdir=c:\DBFFiles;driverid=533;maxbuffersize=2048;pagetimeout=5"; conn = new OdbcConnection(connectionString); conn.Open(); I ca...more >>

From the help Dim dataSet As DataSet = New DataSet("Suppliers") Why name the dataset? Why not just use Dim dataSet As DataSet = New DataSet() Thanks Vayse ...more >>

Lets say I create a databound Form with the datasource config wizard. It has a Dataset -> TestDataSet, and two table adapters. When the form loads, I have code like so Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.Permiss...more >>

For some customer we plan a Sql Server Migration but in our test all the application build with .NET 1.1 don't access the new SQL Server 2005. We have tested the creation in a VS2003 a new connection to the SQL server 2005 database but allso this connection fail. From the same machine if we u...more >>

Working on Asp.net with access database backend,a serious Question in the Class design phase, for accessing the database; Which is Better to make a Connection Class that handles all the ADO Connections for all the other Objects, OR Just make a Connection Module to handle the Database Acce...more >>

I've been having trouble getting a byte array back as a datatable column with this code: Public Class RegisteredCustomerVerify ''' ----------------------------------------------------------------------------- ''' <summary> ''' Friend Function ValidEmail ''' Pass plaintext emai...more >>

I fell like a Dufuss... Going from VB6 to VB.net and it's like walking all over again... I think I'm at the crawl point (: I'm using VB.net and opening a MS Access db. Then displaying the info into a Data Grid. So far I can manage to do that. What I'm trying to do now is to have two Com...more >>

I am getting a 'SQL Server does not exist or access denied. ' error when trying to access a SQL Server Database from my local machine. I have the code on the web server and it is working fine. My connection string is fine and I am able to log into SQL Server via Enterprise manager ok. Th...more >>

Hi, I have a dataGridView databinded to a dataSet. The Rows are in a specific order and I want to swap the selected row with the row below it. I have a RowNum (int) Field in the database. How can I do this? Thanks, Friedhelm Drecktrah...more >>

Hi; I have the following code: DataTable table = DbProviderFactories.GetFactoryClasses(); foreach (DataRow row in DbProviderFactories.GetFactoryClasses().Rows) DbProviderFactory providerFactory = DbProviderFactories.GetFactory(row); The DbProviderFactories.GetFactory(row) throws an exceptio...more >>

Hi, I have a form with four Combo whose DataSource and DisplayMember is the same. The problem is that when I select a value from a combo all other combo start displaying same value. I have not used any BindingContextManager on the form. (I am using C#) Thanks ...more >>

Hi, As a workaround to my problem with the microsoft oracle provider (see my recent post in this same group) I am considering switching to Oracle's own ODP.NET. When I go to download it, I can download either version 9i or 10g. Should I be using the latest version (10.1) regardless of da...more >>

System: ASP.NET app, .NET 1.1, developed on VS.NET2003. Windows Server 2003 Std. with SP1, IIS6.0 Problem: The app is a invoicing system, a lot of numbers are displayed as currency, like $200.00. These numbers are formated in the code using either {0:C}, or ..ToString("C"). Occasional...more >>

Hi, I have an asp.net application which intermittently throws the following exception trying to open an oracle connection System.NullReferenceException: Object reference not set to an instance of an object. System.Data.OracleClient at System.Data.OracleClient.DBObjectPool.GetObject(Ob...more >>

Need some troubleshooting guidance on this one as I am stumped as to where or what to look at next. I have a VS2005 strongly typed dataset with a TableAdapter using SQL2000 stored procedures for select, insert, update and delete. The Select command works fine. When I call the TableAdapter...more >>

We would like ADO.NET 2.0 but don't want to upgrade to VS2005 yet. We would like this for automatic failover in the connection string in ADO.NET 2.0 for database mirroring. Does anyone know if we can upgrade to ADO.NET 2.0 without upgrading Visual Studio and how to go about doing this?...more >>

hi, this is something very basic that i am trying to get done here. i want to update and insert record to the database using a dataadapter which would use Update and insert stored procs. this is easy and i can handle that, but for inserts my stored proc returns a RowId which is generated in...more >>

Hi, Sorry about this, but I'm having a brainstorm here. I'm returning a DataSet from a SQL Server database via a stored procedure, and need to sort the data by a dynamically chosen set of fields. The DataSet is then used for various tasks, but is *not* used as the DataSource of e.g. a DataG...more >>