Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score O/R Mapper for dotnet
Klaus Hebsgaard - 11 Feb 2006 9:13 AM - 18 messages
Has anyone in her got experience with O/R Mappers for dotnet? Some of the requiriments could be -Enterprise level -Caching strategi -Stability -oracle support I have been looking at the following: [link] [link] ...
Score Manipulating Records
Radi Radichev - 11 Feb 2006 8:25 AM - 3 messages
Hi All! How can i delete or insert a record without using the bindingNavigator control? I can move through the records with the binding source but i can't find out how to delete and insert records.... Any tips? Thanks! ...
Score Data Set Changes and Image importing
Radi Radichev - 11 Feb 2006 8:25 AM - 20 messages
Hi! I'm trying to check in the OnFormClosing event if the dataset has changes that are still not commited and if yes to display a dialog box showing a question if the user wants to save tha changes or not. I test it with ...
Score No Answers In MSDE Group, Trying Here DB Access From Server Explorer
pvdg42 - 10 Feb 2006 10:29 PM - 10 messages
Not sure if this is a MSDE or Visual Studio issue, but here goes: I have MSDE and SQL Server GUI tools installed (GUI from Developer Edition) to support database app development with Visual Studio .NET 2003 (VS 2003). I have the sample databases installed (pubs, North, etc.) via an executable ...
Score data view row filter and SQL commands like DATEDIFF?
Brian Henry - 10 Feb 2006 8:19 PM - 2 messages
Can you use sql server commands like this dv.RowFilter = "datediff(d, OrderDate, getdate()) >= 2850 " in a row filter? or will i have to do it another way? thanks! ...
Score Non-mapped column set to NULL during Fill.
Alex Kosov - 10 Feb 2006 10:19 AM - 3 messages
Hello. I call myOleDbDataAdapter.Fill(myTypedDataset, "MyTableName"); after i set value of column not mentioned in DataAdapter. myTypedDataset.MyTable.Guid = Guid.NewGuid().ToString(); this column is not included into any key or relation. after i fill dataset again. myOleDbDataAdapter.Fill(myTypedDataset, "MyTableName"); ...
Score SQL Select Satement Problem
washoetech - 10 Feb 2006 5:38 AM - 6 messages
Hello, I have an sql statement problem that I hope one of you could help me with. For a little backgorund info, I have two tables in my SQL Server 2000 database.  One table has distinct part numbers and descriptions.  The other ...
Score parent child relationship
Ant - 10 Feb 2006 5:16 AM - 5 messages
Hi, I'm just learning how to create a 1 to M with ADO.NET. I've created this little test app. A user selects a company name from the list, then clicks a button containing the code below. The code is meant to ...
Score Error updating AutoNumber field in MS Access
sek - 10 Feb 2006 3:06 AM - 2 messages
Hi Folks, I am using Access and OleDb in ADO.NET in my application. Basically, my app allows users to view the db and add new rows to it using DataGrid control. My unique field in the table is a AutoNumber field. ...
Score Building dynamic sql query with deafult characters
Hari - 9 Feb 2006 7:04 PM - 5 messages
Hi All, What is the good way to handle a string which contains characters like single quote (') or square bracket with LIKE ([]), while building a SQL statement. Right now iam searching these characters in the string and adding the escape chars for that. ...
Score How to connect to MSDE with C#
aboutjav.com - 9 Feb 2006 6:35 PM - 4 messages
Hi, I am new with ADO.net and MSDE. I work with SQL server, but our project requires an export to MSDE. Currently, my connection string is DbConn = new OleDbConnection("Provider=SQLOLEDB.1;Data Source="+strSqlServerName+"; Initial Catalog="+strSqlServerDbName+"; uid="+m_strDbUserName+";pwd="+m_strDbPassword); ...
Score Updating Access database
Radi Radichev - 9 Feb 2006 6:32 PM - 18 messages
Hi! I have a Typed Dataset dsPersonal1 and i try to update the database after i edit a row in a datagrid bound to the dataset. Afret I execute personalDataAdapter1.Update(dsPersonal1) the dataset is updated but not the actual database.Can anyone tell me what am I doing wrong? I'm usinf Visual ...
Score Advice on possible concurrency issue
Rick - 9 Feb 2006 5:59 PM - 2 messages
I have a table TableB which holds references to table TableA. I have one process Process2, invoked by another process Process1, that deletes all records in both tables and then repopulates them, all in a single transaction. It then notifies Process1, which in turn reads the new data. ...
Score Internet - Intranet Data Dilema
asdf - 9 Feb 2006 4:07 PM - 6 messages
Hi, Currently, I have one database for Intranet clients on the server behind the firewall. But I was asked to allow the extranet users to access the same data. From the security perspective what is the best way to make that data ...
Score Can I discover which columns have changed for a DataRow in a DataT
dice - 9 Feb 2006 3:37 PM - 3 messages
I have a table that will not allow some values to be altered if the tuple being updated meets certain requirements. I have a stored procedure that individually updates each value in a tuple if the relevant parameter is not null (all parameters default to null exept the ...
Score Joining two tables on different databases
Ant - 9 Feb 2006 11:15 AM - 2 messages
Hi, I need to join two tables in a 1 to 1 relationship. The tables are on two seperate databases. How can I do this? Thanks in advance for any ideas Ant ...
Score Slow response binding to datagrid
Ant - 9 Feb 2006 7:05 AM - 3 messages
Hi, I'm using a text box's text changed event to autocomplete a datagrid as the user types in the search value ('A' returns many, 'Ax' returns fewer etc). The first few letters typed in take a while to populate the datagrid. Once ...
Score Inserting regional settings specific data into sql server
Niketa Mahana - 9 Feb 2006 4:46 AM - 15 messages
Hi, We are in the process of making product in windows forms that is localized presently for all european countries.We are supposed to support all eastern and western european date , time and number formats.However we are currently facing a problem that say a user in Italy uses our product and user's ...
Score Error Codes From Oracle
tim.romanowski - 9 Feb 2006 12:34 AM - 2 messages
Hello, I am having a wierd problem.  I am using an OleDBCommand to insert a new row into a table on an Oracle 10g database. My Code looks like this bool result = ( command.ExecuteNonQuery( statement ) > 0 ); last night the Oracle Database was hung due to some issues with the ...
Score Are there any DbCommandBuilder implementation examples?
Jim Hartzell - 8 Feb 2006 9:09 PM - 3 messages
Are there any examples of how to correctly implement a class inheriting from DbCommandBuilder?  I have not been able to find any examples showing best practices for doing this. I would like to implement a custom command builder class similar to ...
Score XML ADO Approach
pitdog - 8 Feb 2006 8:16 PM - 6 messages
Hello, I am faced with a problem that may be simple to you. However I am stuck as to how to approach it. I have a table with employee information. This table needs to be dumped to an xml file in  specific format. To be ...
Score Kinda new and having trouble with SQL stored procedure
timpera2501 - 8 Feb 2006 7:34 PM - 3 messages
I am a bit of a newb to .NET and C#, and I've been trying to make a data access class that will act as a buffer between my other classes and my SQL database.  However, the data it's returning is wrong and I'm confused as to ...
Score Enabling Constraints
nbohana - 8 Feb 2006 5:25 PM - 2 messages
I am getting a message when I issue a 'FILL' command. The message is: 'Failed to enable cinstraints'.  I am not sure what this means, can someone explain what I have done wrong. ...
Score McAfee VirusScan 8.0 & (ADO).Net
Martin - 8 Feb 2006 3:12 PM - 2 messages
Hi, I've got a spurious problem that occurs when I'm running McAfee AntiVirus 8.0, but works fine when that is not running (& I'm disconnected from the network) My application is written in VB.Net, using .Net Framework 1.1 (with hotfix ...
Score multiple inserts or updates
brian_harris - 8 Feb 2006 3:04 PM - 6 messages
Hello, I have two different, but related questions. 1) In .net or ADO is there a way to make an insert by just passing new parameters to string.  I am doing multiple inserts where the only difference is values being inserted.  In unmanged code I could use sprintf to have my ...
Score How can I use InsertCommand, UpdateCommand?
Doru Roman - 8 Feb 2006 1:35 PM - 4 messages
Hi, I am new to .NET and I created a data adapter which generated the SelectCommnad, UpdateCommand, DeleteCommand and InsertCommand through the wizard. But what do I do with them? How do I use them, what are the methods to trigger an Insert, a Select, an Update or a Delete? Can someone explain ...
Score Compare 2 DataTables to update RowState
anyMouse - 8 Feb 2006 1:01 PM - 5 messages
I have the following scenario, and would appreciate some advice on the best approach to give the results I require: Simple example: ------------------------ 2 Datasets, the second cloned from the first: dsOriginal.Tables[0] has 2 rows (string, boolean) row 1: red, true ...
Score Reading database schema, identity fields are added automatically
Jaime Stuardo - 8 Feb 2006 11:54 AM - 2 messages
Hi all... I have an XSD file that contains some tables and some relations. Let's focus on a table named "Role". This table has one primary key, named "RoleId", a foreign key named "ApplicationId" and 3 more normal fields, summing 5 fields ...
Score new role?
Fox - 8 Feb 2006 9:28 AM - 2 messages
Hi such a question What SQL Server 2005 security principal replaces database roles? fox ...
Score DataAdapter.Update not working
Craig Hoy - 8 Feb 2006 5:31 AM - 5 messages
I have been trying to get DataAdapter.Update(DataSet) to update a SQL Server database. I have not been getting any errors but there is no records in the database when I check Enterprise Manager. Could someone please help! *** Sent via Developersdex [link] *** ...
Score Is there any way to get database schema in generic way?
Young Jin - 8 Feb 2006 12:48 AM - 2 messages
I'm writing code that provides generic view(vendor independent) to the client about table list, primary key or view. Almost all connections are made via vendor's .NET provider. I researched and found that OleDbConnection.GetOleDbSchemaTable() can make it. But I only make connection via .NET provider, so it's ...
Score ADOX VS2005 DN 2.0
GW - 7 Feb 2006 10:21 PM - 5 messages
Used the function below as part of creating access mdb in DN 1.1 (VS2003) In VS2005 it provides a "Warning: Return type of function 'GFO_CatSet' is not CLS-compliant." Suggestions? (This project has to stick with Access mdb) Public Function GFO_CatSet( ByVal sPathDbName As String)  As ADOX.Catalog ...
Score Filling a dataset with a stored proc
Ant - 7 Feb 2006 10:08 PM - 3 messages
Hi, I'm returning rows from a search done using a sp & one input parameter. Therefore I am using a command to return the result set. These need to go into a dataset in order for it to be bound to a data grid. I received two ...
Score Saving data from datagridview
Bob Simoneau - 7 Feb 2006 9:47 PM - 2 messages
I have a access database with one table, which two columns.  The columns are name which is text, and present which is a boolean.  I create a new windows application, and include the table using wizard.  I then drop the table onto ...
Score Dataset in ADO.Net 2.0 VS 2005
jamesbond - 7 Feb 2006 9:18 PM - 2 messages
I am new to .Net. I have three master tables which has many to many relations. I need to create a data grid view in windows form application.(Windows application now web). I am little bit confused how can I create a data set and grid that will let me inser a new relation ...
Score SQL Server Management Studio - not preserving identities during import
Eric - 7 Feb 2006 8:34 PM - 2 messages
I want to copy my local database to a remote server hosted by a thrid party company. I started by creating all the tables using creation scripts made by SSMS. Then I connected to the target database, and used Tasks, Import to copy my local data to the remote database. I made sure ...
Score Query inside of Access Database
pradeep - 7 Feb 2006 8:15 PM - 10 messages
I want to programmatically call a query, which is inside the Access Database. Either in C# or VB.NET. I dont' watn to write the query in the code. Rather would call a query inside the access db. Thanks ...
Score Encoded Confusion
Sean - 7 Feb 2006 7:58 PM - 6 messages
Baiscally I have Nvar data in a database and I want to populate a datgridview in french. I understand the basics of globalization and have done a bit but not on the data level. Can anyone point me to the right resources to start understanding this ...
Score How to adjust the order of column in a DtatTable
ad - 7 Feb 2006 7:48 PM - 2 messages
I use the new feature of TableAdapter. When I add a column in the designer, it appear in the last column. I can't find out how to adjust it's order. How can I do ? ...
Score Query analyser unicode wonder.(sql 2005)
jens Jensen - 7 Feb 2006 7:14 PM - 3 messages
Hello, It is possible to configure query analyser to output the result of a query to a file. The problem is that the file is saved with with unicode chars. I want my file to be ANSI . How can i do this? ...
Score Heterogeneous oledb queries
Santi - 7 Feb 2006 7:07 PM - 1 message
Hi, I have two foxpro databases in two ".dbc" files. I am able to send queries to both separately from ado.net code but the point is I need to send queries with tables from both databases. How can I do that? ...
Score DataGrid - Edit, Update, Delete
drakuu - 7 Feb 2006 6:26 PM - 3 messages
Hello there, I have DataGrid with some records and I would like to edit it right in the datagrid using the built in commands. I can't figure out a way to pass to the SQL query the record ID which ...
Score How to Fill Typed DataSet
Axel Dahmen - 7 Feb 2006 6:10 PM - 2 messages
Hi, this might be a stupid question... I've created a typed DataSet containing two tables and a ForeignKeyConstraint. Now I want to Fill that DataSet from database using a SELECT command retrieving rows for both tables. However, when I use SqlDataAdapter.Fill() none or only the first table are ...
Score ADO.NET 2.0 strongly typed datasets - how to override the connectionstring?
Jacobus Terhorst - 7 Feb 2006 6:02 PM - 2 messages
I am using strongly typed datasets in ADO.NET 2.0. How can I override the connectionstring? ...
Score ork_with_Informix
Bea Marín - 7 Feb 2006 3:49 PM - 2 messages
Hi all, I have problems with CommandBuilder in NET Framework 2.0. I am trying to update a table in Informix IDS 9.40 (client SDK 2.90 TC4, the last one) using a dataadapter and a commandbuilder (vb.net). In NET Framework ...
Score MDAC
John Kortis - 7 Feb 2006 3:32 PM - 2 messages
Hooking To SQL Server 2005 on Itanium 64, What MDAC and providers do I need My applications will run all on a 32 bit Windows Server 2003 machine? thanks ...
Score Help with connecting to FoxPro please
Burak Gunay - 7 Feb 2006 3:29 PM - 4 messages
Hello, I am trying to connect to a visual fox pro table from my asp.net page. I dragged an odbc connection and set it to a visual fox pro driver file dsn pointing to "mydocuments" folder. Here is the connection string ...
Score parent-child and comboboxcolumn
pax - 7 Feb 2006 2:50 PM - 5 messages
Hi NG! Is there any way to have a ComboBoxColumn display a different set of values for each different row in a DataGridView? What I mean is, given the following situation, ParentTable parent_id (1) ......... active_child_id_fk (3) parent_id (2) ......... active_child_id_fk (4) ...
Score First time Performance Problem
sendtobiren - 7 Feb 2006 11:45 AM - 2 messages
Hi All, We are having a web application. When we call our application first time, it takes lots of time and afterwords it takes less time. I am clear about the concept how .aspx page is called in .net framework ...
Score Help. Determine PrimaryKey Column from sqlDataReader
SMS_Dev_Dept - 7 Feb 2006 11:00 AM - 2 messages
Hi, I have an open and active sqlDataReader object and would like to determine which of the fields is the PrimaryKey (if present). I intend to use this to create generic DataTable objects in a library by passing in a sqlDataReader object, and the library returns a DataTable object ...
Score Pb with DataAdapter.Fill
bp - 7 Feb 2006 8:40 AM - 2 messages
Hi I'm trying to make a component to manage database access. One task of this component is to create a database if it does not exist. To minimize queries's count, I want to do database creation when DataAdapter.Fill fails (and if the ...
Score Cannot open database requested in login <DBName>. Login fails.
AL - 7 Feb 2006 7:36 AM - 2 messages
Hi I have 1 web service posting data to a SQL server 2000 database and a separate ASP.NET web site reading data from the same database. Both use the same SQL user and password to connect to SQL. The web service is windows ...
Score ADO.NET 2.0 - Get the value current record using the DataGridView
Phil Williams - 7 Feb 2006 3:57 AM - 4 messages
Hello, I have a Contacts DataGridView that is bound to the TblContactsBindingSource. The Grid contains a list of contacts including the contacts name (Column 2 or "ContactName") I would like to get the value of the current "ContactName". What is the easiest way to do this? ...
Score Populating a datagrid
Ant - 7 Feb 2006 12:11 AM - 9 messages
Hi, I have a datagrid on a WinForm which I need to poulate with a search result set. The search is done with a parameter to a sp so I'm guessing the data grid can't be bound to a design time Dataset. I have no idea where to start with ...
Score Basic Binding and Filtering Problem
Dok - 6 Feb 2006 11:58 PM - 7 messages
I'm caught in a Catch-22 position with a fairly basic ADO.Net problem. I have bound a data adapter called "DateTableDataAdapter" to a simple Microsoft Access table called "DateTable" with a couple of datetime columns, a memo column called Synopsis, a text column called Title with unique values and ...
Score BindingSource TableAdapter Position
Giovanni - 6 Feb 2006 9:30 PM - 1 message
Hi All,      I need help with the following:  I am using a BindingSource and TableAdapter to display information on the screen.  The table key is displayed using a databound combobox which, when the selection changes, all ...
Score convert comma delimited text to access mdb
jj - 6 Feb 2006 3:36 PM - 5 messages
I have this comma delimited text file. I want to convert it in one sweep to an access DB (mdb) format. I used the following code but it takes forever to convert. Is there a faster way? string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ...
Score how to displays the procedures currently running at startup on sql sql server 2000 ?
zoltix - 6 Feb 2006 11:46 AM - 2 messages
how to displays the procedures currently running at startup on sql sql server 2000 ? *** Sent via Developersdex [link] *** ...
Score App.config string <> strongly typed ds
Nickl - 6 Feb 2006 10:49 AM - 3 messages
I would like to use strongly typed datasets (I think), but find the following limitation; When configuring the Dataadpter with the wizard (VS2003) a connection object is generated for me. I want to use a connection object based on a string in the App.Config file, but when I attempt to do this by ...
Score Databinding DropDownList and Label
Paul Aspinall - 6 Feb 2006 9:37 AM - 2 messages
Hi I'm using a FormView control. In my EditTemplate, I have bound to a DropDownList. This works fine, by having the key in my primary table, which is looked up via the binding to my DDL using the DataSourceID etc.. ...
Score Stored Procedure query slow in debug configuration.
Bojan Kuhar - 6 Feb 2006 9:10 AM - 4 messages
I have an old and proven stored procedure that takes on average 0.2 seconds to execute. I always develop and perfom all measurements using VS .NET debug configuration. This SP has always performed the same being called from Query ...
Score SQL Server 2000 and Sql Server 2005 on same machine
Dan, Wascus - 6 Feb 2006 4:54 AM - 6 messages
Hi Gurus, Is it ok to install both SQL 2000 and SQL 2005 on the same system without any problem. We just want to have some ideas before implementing it. Thanks for any help you can provide. Dan ...
Score Filling a data grid with a Datareader
Ant - 6 Feb 2006 3:15 AM - 5 messages
Hi, I'm using a SP with one input parameter to return query results to a Datareader. I then want to add the rows in the data reader into a data grid. Can you 'bind'  a datareader to a data grid? If not, how would do it? ...
Score "No value specified for some required parameters"
Andrea Raimondi - 5 Feb 2006 8:38 PM - 10 messages
D'oh! I'm feeling this is related to ADO.NET and maybe you can help here. Please, don't hide behind "Microsofties don't know pascal" because this is a very framework issue rather than Delphi. This is the code: ...
Score Oracle ADO.NET classes ??
Mark - 5 Feb 2006 7:37 PM - 4 messages
I'm confused ... I've read in a number of places that in VS2005, ADO.NET contains Oracle specific classes under the System.Data namespace (actually this was supposed to be available for the v1.1 framework). But I don't see ...
Score Typed Datasets - GetChildRows (Bug or am I doing something wrong?)
Gidion - 5 Feb 2006 4:53 PM - 4 messages
Hi everybody! I've stumbled across a funny behaviour of a typed dataset in a new application of mine. Some how the generated code gives me a Invalid Cast Exception. I've reproduced the behaviour as follows. I've created a database "test160106", I've created the table "Parent" with ...
Score Forms Authentication with SQL Server
thebison - 5 Feb 2006 4:12 PM - 2 messages
Hi everyone, Quick question, I'm creating a Timesheet Application with ASP.NET C# in Visual Studio 2003. The database has been built using MSDE. I have followed the MSDN libraries guide to creating forms based authentication from [link] ...
Score [Net1.1SP1][OledbCommand]
Andrea Raimondi - 5 Feb 2006 9:33 AM - 3 messages
Hello. I'm doing a WebService using ASP.NET with an Access database. Nothing really fancy, I just want to try and see what I can get to. Using an Access database(no please, don't tell me that MS is pushing ...
Score Accessing dynamically created components in C#
drakuu - 5 Feb 2006 7:54 AM - 3 messages
All, I created dynamically part of a table and its components such as text boxes etc... As you can see in the example below I created txtAddress textbox... Everything works perfectly until the point where I need to save the ...
Score CheckBoxes in DataGrid
drakuu - 5 Feb 2006 7:42 AM - 2 messages
Hi guys, I created DataGrid with few checkboxes. I want to bind the checkboxes and check them if they match a string in a database. An if statement would look something like this: if (dataRowChb["AddressTypeCode"].ToString() == "u") checkbox1.checked ...
Next »