Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Find a row - and CurrencyManager
jwitt - 18 Mar 2006 11:13 PM - 2 messages
Ref: WinXP, .NET 1.1, C# I have a form with TextBoxes bound to a DataTable. Is there a way to find a row in the DataTable by a string (matching data in a column), and then have the row appear in the TextBoxes? I assume I ...
Score Microsoft .Net Pet Shop 4
theWizard1 - 18 Mar 2006 7:47 PM - 1 message
Downloaded Microsoft .Net Pet Shop 4 and cannot get connection to work.  Also, now getting the following error.  Unable to launch Visual Studio's Localhost Web Server, port '2327' in use ...
Score subset of the fields stored in a dataset
labrynth - 18 Mar 2006 6:06 PM - 4 messages
I have recently started coding in .net technologies. Here is what I want to do - I have a dataset that consists of all the rows and columns of a table (say emp). I also have a datagrid control on my windows form. ...
Score MS Access - Connection Pooling?
MilanB - 18 Mar 2006 5:22 PM - 5 messages
Hello, Does the same rule valid for OleDbConnection for MS Access, as it is a case with SQL Server, to open connection, and close it immediatly after usage? Or for MS Access, connection sould be opened during whole application run? ...
Score Is it possible to include SELECT in Access OleDbCommand - Update?
MilanB - 18 Mar 2006 5:16 PM - 2 messages
Hello, Is it possible to include Select statement after Update statement in OleDbDataAdapter - UpdateCommand, like it is possible in SQL Server For Example UPDATE    myUnit SET              InstitutionID = @InstitutionID ...
Score Web.config: connection strings
R.A.M. - 18 Mar 2006 5:12 PM - 3 messages
Hello, I am beginner. Could you help me please how to connect to SQL Sever using connection string in Web.config? I have:     <configuration>     <appSettings/>     <connectionStrings> ...
Score ¤ China ZhongZhan Aids Mei Mei
enlamasperm - 18 Mar 2006 5:01 PM - 1 message
Killer! [link] el***@digi-art.de ...
Score ¤ China ZhongZhan Aids Mei Mei
enlamasperm - 18 Mar 2006 5:01 PM - 1 message
Killer! [link] el***@digi-art.de ...
Score ¤ China ZhongZhan Aids Mei Mei
enlamasperm - 18 Mar 2006 4:20 PM - 1 message
Killer! [link] el***@digi-art.de ...
Score ¤ China ZhongZhan Aids Mei Mei
enlamasperm - 18 Mar 2006 4:20 PM - 1 message
Killer! [link] el***@digi-art.de ...
Score errors when I try to create a Dataset
Mesut - 18 Mar 2006 3:24 PM - 1 message
Hi There, I create some tables in myproject and I try to make a dataset. I select Add Dattasource, It walks trough me some screens and at the end I choose the table 'Tracking'.  But the system gives me and error. This ...
Score Loading data faster?
Arsalan - 18 Mar 2006 8:39 AM - 3 messages
Well, the problem is when i run the application 1st time, it takes time fill the dataset, whereas if i run the application second time, it fills dataset faster. How do I make it faster on the 1st time ? ...
Score TransactionScope cannot process big files (too many connections op
BF - 17 Mar 2006 10:35 PM - 2 messages
I use OO application architecture. I have data access object for every dartabase tables. Each DataAccess object corresponding to one record in table. When I insert a record, I call this DataAccess object for this table and run it's Insert method. This method will open connection, insert record ...
Score ARGH! Help with UPDATECOMMAND
Rico - 17 Mar 2006 7:54 PM - 2 messages
Hello, Well, I guess I obviously don't fully understand the updatecommand.  I thought the when you create a DA, that the accompanying update command would only modify the records that had changed.  I'm grabbing three records that ...
Score C# to VB
Mike - 17 Mar 2006 7:08 PM - 6 messages
Have a C# example for async delegate and need to convert to VB. Have everthing figured out except one statement. LoadDataSetHandler dl = (LoadDataSetHandler)                 ((AsyncResult)ar).AsyncDelegate; ...
Score modifying data source from datagridview
Mochuelo - 17 Mar 2006 7:00 PM - 2 messages
Hi, I have Visual Studio 2005 and SQL Server 2005. I am new to this database (although I've used others for years). First I'm just trying simple things, like inserting a DataGridView in my form that, being linked to a table in my database server, will allow me to visualize, ...
Score Transaction and Connection Timeout
Michael X - 17 Mar 2006 6:53 PM - 3 messages
We are running a lot of unit tests for the product which is built on .NET 1.1 with ADO.NET, and SQL server 2000. Recently some unit test encount this error: "System.Data.SqlClient.SqlException : Timeout expired. The timeout period ...
Score how to Copy/Clone a derived DataTable
Mark - 17 Mar 2006 6:32 PM - 2 messages
I would like to add a few properties and methods to an ADO.NET DataTable. So the normal thing would be to derive a class: Public Class MyTable     Inherits DataTable     Private This As That ...
Score Imports namespace
Mike - 17 Mar 2006 6:07 PM - 4 messages
I'm trying to import a namespace that I created in another project and cannot get it to show up in the Imports list. The project has been added to the current solution (which that shouldn't matter anyways) and ...
Score Import of MSDTC transaction failed: Result Code = 0x8004d00e
BF - 17 Mar 2006 5:01 PM - 3 messages
After I used TransactionScope in my C# application to update multiple tables in 2 databases on the same SQL 2000 server. I got error "Import of MSDTC transaction failed: Result Code = 0x8004d00e". This problem happens only after I deployed this application to our Windows ...
Score What would be the best way to physically sort the contents of a DataTable?
Maxwell2006 - 17 Mar 2006 4:50 PM - 5 messages
Hi, What would be the most efficient way to physically sort the contents of a DataTable? Of course dsCashReceipts.CashReceiptOutBalList.DefaultView.Sort doesn't work, because I need to phusically sort the DataTable. Thank you, Max ...
Score from ODBC to ADO
A - 17 Mar 2006 4:16 PM - 1 message
Hello I have a ODBC DSN connexion to a SQL DB and I need to use its parameters to open a ADO connexion, but I can get only the database name (not the user and the password). Does anybody knows how to do it (I really need to use a SqlConnexion) ? ...
Score output or inputoutput?
Brent - 17 Mar 2006 3:06 PM - 2 messages
When specifying the parameter direction for sqlserver should you use inputoutput or ouput if your not going to passing anything into the parameter? In 99% of the cases where i use output params; i don't pass anything into them. I know sql server output params are really input/output ...
Score Trouble connecting to Oracle DB"
jens Jensen - 17 Mar 2006 8:51 AM - 3 messages
exception: "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater." fails at connection.Open(); (connection is  System.Data.OracleClient.OracleConnection) What i'm i missing? many thanks in advance JJ ...
Score DataReader Concept
A.J - 17 Mar 2006 6:34 AM - 2 messages
Why DataReader is being called "type safe read only, forward only rowset"? ...
Score using 2 sql commands in 1 string?
Lewis - 17 Mar 2006 12:36 AM - 7 messages
I am using SQL server express 2005 and sending the string as an SQL text query from C# 2005. Perhaps I am missing something, but when I use UPDATE    SomLast_num SET              CUST_NUM = CUST_NUM + 1 ...
Score 2.0 ObjectDataSource : number rows returned
John A Grandy - 17 Mar 2006 12:07 AM - 1 message
In ADO.NET 2.0 , does the ObjectDataSource provide a method or property to return the number of rows returned ? ...
Score Cleaning the connection pooling in ADO.NET 1.1
PikeStrider - 16 Mar 2006 11:52 PM - 2 messages
Sometimes connections in the pool become invalid. This could happen when sql server is restarted, but the application isn't. The following method seems to work quite well to "clean" the connection pool. Is there some obvious thing I am overlooking? ...
Score Best practice for n-tier data access in .NET 2.0 .
Paul Aspinall - 16 Mar 2006 11:41 PM - 2 messages
Hi I've previously constucted my .NET 1.1 data access, via a Data Access Layer (DAL), that was all in code. Now that I have access to the DataSet control in .NET 2.0, I'm looking for opinions or pointers into how to implement a DAL under .NET 2.0. Is it best ...
Score Best practice for n-tier data access in .NET 2.0
Paul Aspinall - 16 Mar 2006 10:42 PM - 4 messages
Hi I've previously constucted my .NET 1.1 data access, via a Data Access Layer (DAL), that was all in code. Now that I have access to the DataSet control in .NET 2.0, I'm looking for opinions or pointers into how to implement a DAL under .NET 2.0. Is it best ...
Score SQL 2005 Connection
Steven - 16 Mar 2006 8:51 PM - 3 messages
I am new to VS2005 and I am creating a VB.NET app that connects to SQL Server 2005 using ADO.NET.  When I try my connection I get: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, ...
Score SQLDataAdapter problem framing dates
grondaia - 16 Mar 2006 8:45 PM - 2 messages
I am using a SQLDataAdaper to update data into a database  Im setting the updatecommand to a stored procedure and creating all the paramaters.  All seems to create correctly, however the sql command that is passed to the database is framing all the dates with double ...
Score Does DbConnection.Dispose() call Close()?
David Thielen - 16 Mar 2006 8:31 PM - 3 messages
Hi; If I do using (DbConnection conn = ...) { ... code ... } That will call dispose when it exits the using. Does that dispose call Close (if the connection is open) and will it do so even on an exception? Reading the docs I assume it does, but I can't find anywhere that it says absolutely ...
Score DAAB with Oracle ref cursors
Dmitry - 16 Mar 2006 7:49 PM - 3 messages
Hi, Can anybody send me an example of calling an Oracle stored procedure which returns a ref cursor using Enterprise Library DAAB? More precisely, I need to know how to call both procedures: PROCEDURE GET_USER_BYID( P_USER_ID_IN IN NUMBER, cur_OUT OUT REF CURSOR) ...
Score Non descript error filling dataset?
Rico - 16 Mar 2006 7:48 PM - 2 messages
Hello, This week seems like one thing after another!  I am running some simple code to fill a dataset and keep getting the error "An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll" with no ...
Score Microsoft ADO.NET (Core Reference) published May 15, 2002 - covers what version of ADO.NET?
Lulu - 16 Mar 2006 7:30 PM - 3 messages
Microsoft ADO.NET (Core Reference) published May 15, 2002 - covers what version of ADO.NET? I cannot seem to find it mentioned specifically in the book itself. ...
Score porting sql stored procedures between db2 and sql server
Steve Richter - 16 Mar 2006 6:30 PM - 3 messages
Would appreciate some help settling a friendly argument :) What is the degree of difficulty of porting an sql procedure from a db2 database application to a sql server database application? The following statement, is it accurate: "...DB2 UDB for iSeries, and the broader DB2 UDB Family's support of ...
Score Parameter has no default value
Eniac0 - 16 Mar 2006 5:39 PM - 5 messages
Hi, I've searched the groups a lot before posting. Even tho a lot of people posted with the same error, none of the solution worked for me. Here's what not working. I am going to post the whole function on .net ...
Score new error - Column is read only
Rico - 16 Mar 2006 5:19 PM - 5 messages
I have some code that was previously working, taking items from one window and adding them to another.  I changed some code around to only add the dataset tables if no tables exist rather than running a try catch.  I ...
Score Saving DateTime to Sql Server 2005
Andy - 16 Mar 2006 4:41 PM - 7 messages
Hi all, I've noticed that Sql Server seems to truncate the ticks if you save a ..Net 2.0 DateTime to Sql server. This is messing up my unit tests; any idea how i can mimic the truncating that Sql server does? ...
Score Import of MSDTC transaction failed: XACT_E_NOTRANSACTION
Lynne - 16 Mar 2006 4:21 PM - 4 messages
I'm running Visual Studio 2005 on a Windows XP machine connecting to a SQL Server 2000 database on my local machine.  I recently added some transaction  processing logic to my application using the TransactionScope object.  While ...
Score How to implement required field validation
מיכאל קריבוס - 16 Mar 2006 3:39 PM - 3 messages
What is the choices I have to implement the field required issue, meaning, When a user missed a field an error message should be displayed. ...
Score System.Data.Oracle missing in my System.Data namespace!
jens Jensen - 16 Mar 2006 2:43 PM - 3 messages
I'm using VS 2005  team  . What i'm missing? ...
Score DataGridView validation to underlying DataSource
Pieter - 16 Mar 2006 1:45 PM - 3 messages
Hi, I'm using a DataGridView with a DataGridViewCheckBoxColumn. When the users checks or unchecks the checkbox, some actions have to happen in the underlying DataSource and other objects. But the underlying DataSource gets only the new value (True or False) on the moment the users leaves the cell ...
Score Where do I put my Database relation in DATABASE level or in PROGRAM LEVEL?
Mesut Demir - 16 Mar 2006 1:04 PM - 5 messages
My it's a stup question but : I'm starting to learn VB.NET. I have some basic skills. I'm from Mainframe world and I have same question to make my DATABASES (tables and relation) I would like to make ask my question by example. Let's say I'm a ...
Score How to change the ConnectionString for an auto generated typed dataset in a separate dll ???
mateo - 16 Mar 2006 12:46 PM - 2 messages
So here i've made a typed dataset in vs2005 by picking some tables in the server explorer. It generated a typed dataset with everything inside it ok. Now i've decided to put this newly created dataset in a ...
Score DataTable - Byte[] Field updating.
MilanB - 16 Mar 2006 11:09 AM - 1 message
Hello I have DataTable. dataTable has base64Binary field that I use to store byte[]. Everything works fine except one thing. If I change only this field value, and than call dataAdapterUpdate, then event:   RowUpdated is not fired. If I change any other field, this event is fired normaly and everything ...
Score What's Faster: DataTable.Select or GetChildRows
Ryan K - 16 Mar 2006 8:52 AM - 5 messages
Hi, I have a DataSet that contains a Master and a Child DataTable. If I need to repeatedly get child DataRows from the child DataTable, what is quickest? Option A:     Use DataTable.Select. Option B:     Use GetChildRows on a DataRow in the Master DataTable. ...
Score RefreshLink
Asim Tozlu - 16 Mar 2006 8:41 AM - 3 messages
Hi NG, i have two MS Access-Database. The tables from database a are link to database B. How i can refresh the links when i move a database to another place. thanks greetings from berlin asim ...
Score Typed DataSet - why compile to dll?
deko - 16 Mar 2006 4:14 AM - 3 messages
I understand that I can generate a strongly typed DataSet using the XSD.exe tool provided with the .NET Framework SDK.  I also understand that I can compile the class generated by the xsd tool into a dll.  ( ...
Score Common API for all ADO .NET clients
David Thielen - 16 Mar 2006 12:08 AM - 1 message
Hi; Based on everyone's feedback here (thank you, thank you), I have decided to create a facade that provides a common API for any ADO .NET client. Be warned, the code I have up now is just working. No comments, no unit tests, ...
Score NVARCHAR specific methods
VC - 16 Mar 2006 12:06 AM - 2 messages
Hi, I have a C#.NET test application that connects to a Sybase backend database which has a table with a field type NVARCHAR (100). This has some ASIAN characters stored in it. The data was loaded using BCP and shows up fine ...
Score Recommended Driver/Assembly to Access Oracle from DotNet Framework 2.0
Chris Fink - 15 Mar 2006 9:30 PM - 1 message
I am using framework 2.0 and need to access Oracle 8i, 9i, and 10g databases from my environment.  What is the recommended "driver" to access Oracle?  Is it provided in the framework or should I download from Oracle (ODP.NET, ...
Score Reference if Table Name or Column Name already exists in DataSet?
Rico - 15 Mar 2006 8:47 PM - 1 message
Hello, I have a dataAdapter and a DataSet that I'm using on a form.  When I first create the DA, I use the FillSchema, I add an auto increment column, then fill the DS with data.  I have the DS set as a global variable because I ...
Score Locking an Access table
Roy - 15 Mar 2006 8:36 PM - 6 messages
Hi all, For locking a record in a table I had to add a boolean column to the table and toggle it when a user accesses that  record. Now I need to lock the table so users cannot access that table at all. Is ...
Score Getting AutoNum field from updated db table via data adapter
Rico - 15 Mar 2006 7:46 PM - 4 messages
Hello, I have a dataset that has an Orders table and an Order details table.  There is a datarelation between the two, but the information inside the dataset isn't actual order history, it's orders that I'm about to receive, and the ...
Score Framework Path?
jminond - 15 Mar 2006 2:05 PM - 4 messages
I heard and am loooking for a patch for the 1.1 framework, that would allow it to serialize and deserialize v 2.0 types succesfully, so that 1.1 and 2.0 apps can work even in remoting scenarios. ...
Score Add a column in dataset
Joe - 15 Mar 2006 12:16 PM - 3 messages
Dear all, I get a result from the sql server and return a dataset after i get the dataset, i want to add a column to the dataset the column is boolean and all rows are true, how to do that ...
Score Default Values in INSERT stmt
sme@nospam.nospam - 15 Mar 2006 11:35 AM - 1 message
I need to create a stored procedure that would execute an insert statement into a table of the database. Suppose that the table has several columns of various data types. Some of the columns are NULLable with default values, some of the columns are NOT ...
Score Scrolling through DataTables
Tim Gee - 15 Mar 2006 11:10 AM - 3 messages
Hi I am looking at C# and Ado.Net database development, however I come from a Delphi background, but I’m getting there. Once I have retrieved my data from Sql Server I have a DataTable with all the DataRows in it, I can use find to locate a specific record (using the ...
Score How can i use OpenSchema?
realjacky - 15 Mar 2006 7:37 AM - 2 messages
i would like to find the primary key of a table and i write it, but it doesnt work String *aaa[] = {String::Empty,String::Empty,tablename}; rs = connection->OpenSchema(ADODB::SchemaEnum::adSchemaPrimaryKeys,aaa,String::Empty); Is there any problems? ...
Score Are there any problems with ADO.NET on Novell Network
Phil Williams - 15 Mar 2006 3:55 AM - 1 message
Hello people, Does anybody know of any issues regarding running a VB.NET 2005 app connecting and using a mySQL 2005 database across a Novell network? Thanks in advance ...
Score Databinding problem
Ant - 15 Mar 2006 1:20 AM - 1 message
Hi, this is not a one to many question but a many to one problem: If I have 'one category can have many products but one product can only fit into one category',  the relationship 'namespace' would be: Categories.CategoriesProducts.ProductFields ...
Score Get Oracle database schema information using ODP.NET
Tony - 14 Mar 2006 10:49 PM - 2 messages
Does anyone know how to retrieve database schema information (tables, columns, indexes, etc) using Oracle's ODP.NET provider. It does not support the OracleConnection.GetSchema() method. I don't want to have to use another provider such as OleDB or MS's ...
Score Parent-Child Insertion, SQLTransaction, and Foreign Key error
Mansoor Siddiqui - 14 Mar 2006 8:56 PM - 4 messages
Hi, I have an application that was working fine since last two months but all of a sudden it stopped working!!! This is what I do in my code: (1) Open the connection (2) Start the transaction and get the SQLTransaction object ...
Score vb.net 2003
Leo - 14 Mar 2006 8:38 PM - 2 messages
Hello, I am creating a vb.net windows application, and I am trying to connect to a SQL 200 server database. I need some information on accessing the SQL database that I created. I already have the tables created (ex. USERS, ASSET, ...
Score Create WebServices with Word
Federico - 14 Mar 2006 4:44 PM - 7 messages
Hi I want to create a Web Services where I receive a Template DOT word a file XML and with these I create a Document that a I'll Send as Dime Attachment. <WebMethod()> _         Public Function CreateDimeWord(ByVal DotName As String, ByVal ...
Score DataRow Rowstate and drag and drop
John Sitka - 14 Mar 2006 4:42 PM - 5 messages
crosspost but I have a feeling W.G. Ryan may know a trick. windowsforms 1.1 Hi, I'm displaying a datagrid when the user enters (highlights) a certain text cell on a row it does a lookup of possible matches. ...
Score Default SQLExpress connectionString
Rob Williams - 14 Mar 2006 3:40 PM - 6 messages
In 2.0 when I access the ConnectionStringSettingsCollecion using the integer index rather than declaratively using the key of the configuration element I get a SQLExpress connection string which I haven't defined myself at the reference zero. E.g. ...
Score datagrid
A.J - 14 Mar 2006 2:53 PM - 4 messages
hi ppl, while going through the threads i came to know tat we can populate the datagrid with xml.Is this mean tat we can populate dr with XML of any format.(This concept is bit new for me;could you please explain wat ...
Score Persist Changes made in class property to dataset
Duane - 14 Mar 2006 2:32 PM - 5 messages
I create a class with object properties. Then, iterate through the rows of a dataset and equate select columns to the properties in the class as follows. foreach(DataRow r in this.ds.table) {     Item item = new Item(); ...
Score Fill a strong typed dataset from 2 tables
nieurig - 14 Mar 2006 2:01 PM - 8 messages
Hello folks, i am searching at this forum, but i don't found a solution. I try to fill two tables of a strong typed dataset by ONE call of fill-Method of the dataadapter. Is there any possibily to do this? ...
Score newbie: using xsd.exe
deko - 14 Mar 2006 8:58 AM - 10 messages
I've seen the examples on msdn, but still having trouble with xsd.exe What I want to do:  use the command line to create a typed dataset .dll that I can add to my VS05 project I assume all I need to do is run these two commands: ...
Score c# - How to bind a many to one
Ant - 14 Mar 2006 8:50 AM - 1 message
Hi, I’m displaying Products & their categories on a form. (1 category can have many products). I want to bind the controls to the Binding context so that I can use a currency manager to navigate through the rows. Navigation will be ...
Score DbProvider GetFactory exception with system.data.sqlclient
lk - 14 Mar 2006 12:51 AM - 3 messages
I received an exception when I tried to use provider name "system.data.sqlclient" to create a db factory. DbProviderFactory dbFactory = DbProviderFactories.GetFactory("system.data.sqlclient"); The exception message is:- "Unable to find the requested .Net Framework Data Provider.  It may not be ...
Score Export or import from an MS Access DB
Peter - 14 Mar 2006 12:48 AM - 6 messages
Hi, Generally,a database will become bigger and bigger day after day. Some time I want to take some records from the main DB to compose a small DB, in another time I may want to get the small DB back to the main DB.I call these ...
Score Inserting Record Problem
thebison - 13 Mar 2006 9:07 PM - 6 messages
Hi all, I hope someone can help with this relatively simple problem. I am building a timesheet application using ASP.NET C# with Visual Studio 2003.As it is only a protoype application, my database has been made in MSDE. ...
Score Insert to DB from Datagrid
Robert Bevington - 13 Mar 2006 9:02 PM - 5 messages
Hi everyone, I have succesfully populated a datagrid with data from an XML file. Now I want to insert the data into a SQL database table. The database table might be new and empty, or it might already contain data. What's the best ...
Score Unspecifed Error !!!! HELP - This is painful
Dan - 13 Mar 2006 6:27 PM - 3 messages
This is the most excruciating error I have ever had to deal with in 10 years of programming with Visual Basic.  I am getting an error albeit intermittent most of the time, but I am now getting it consistently on one of my aspx pages. ...
Score Pre-filtering datasets
Sam - 13 Mar 2006 4:57 PM - 3 messages
I am having a very difficult time with the fill statement for datasets.  The fill will always obtain all records.  I have a master-detail structure in my forms and it's ridiculous to see that loading all the records in the detail ...
Score i have a question about rename table through ADOX with C++
realjacky - 13 Mar 2006 3:37 PM - 1 message
i have find some code on web : Dim cn As ADODB.Connection Dim t As Table Set cn = New ADODB.Connection cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;data Source=C:\biblio.mdb" Dim cat As ADOX.Catalog Set cat = New ADOX.Catalog ...
Score databinding problem
A.J - 13 Mar 2006 3:29 PM - 7 messages
There is a : 1.DataGrid: Columns-->firstName,LastName,EMail,PhoneNumber 2.GroupBox: controls-->4 TextBoxes(firstName,LastName,EMail,PhoneNumber) 3.Both DataGrid and GroupBox are binded to the same datasource(Dataset) and Share the same BINDINGCONTEXT ie on clicking a record in the ...
Score TableAdaptors: Why a good solution?
Claus Konrad - 13 Mar 2006 2:14 PM - 4 messages
Being an old rat in this game, I've come to discover some "unpleasent" features of the newer version of .NET (2.0). The tableadaptors contains an embedded connectionstring that is only available through global connectionstorage! I see the benefit in being able to encrypt the connectionstorage, I do however NOT see the benefit in the notion of "global" connectionstrings. Why would I want to "share" my own connectionstring with every other application installed on my PC? Being global - I assume that it is available to every body by using the .....ConfigurationManager.ConnectionStrings["some name"].ConnectionString construct? ...
Score DataAccessApplicationBlock without stored procedures?
David Thielen - 13 Mar 2006 2:57 AM - 12 messages
Hi; Are there examples somewhere of how to do an insert, update, select, & delete without any stored procedures? ...
Score Enterprise Library - DataAccessApplicationBlock - MySql/DB2
David Thielen - 13 Mar 2006 2:51 AM - 6 messages
Hi; Is there an example somewhere for using the DataAccessApplicationBlock with DB2 and/or MySql? Preferably using native drivers rather than OleDbClient ...
Score Why dataview does not improve datatable.select in .net 2.0
Julie Lerman - 12 Mar 2006 10:07 PM - 1 message
I have code that I am running in .NET 1.1 and .NET 2.0. I do a datatable.select (repeat 3 times) then create a dataview with the field I am selecting on as the primary key and then try the datatable.select ...
Score Questions about DataTable constraints
deko - 12 Mar 2006 7:51 PM - 1 message
Some general questions about constraints in ADO.NET DataTables... Here is an example from MSDN: [link] private void CreateConstraint(DataSet dataSet,     string table1, string table2, string column1, string column2) ...
Score DataTable primary key - unique and no nulls by default?
deko - 12 Mar 2006 6:51 PM - 7 messages
When I define a DataTable's primary key, do I need to set it as unique and to disallow nulls?    project_ID.Unique = true;    project_ID.AllowDBNull = false; Or is this all that's necessary:    tblProject.PrimaryKey = new DataColumn[] { ...
Score MS Access - Get new Autonumber value after DataAdapter.Update
MilanB - 12 Mar 2006 6:29 PM - 10 messages
Hello I have MS Access table with autonumber PK field I insert record and perform dataAdapter.Update(table). Now I need to know value of AutoNumbered field. Do I have to refresh whole table, by doing = table.Clear(); - dataAdapter.Fill(table); ...
Score DataColumn.DataType = GetType(System.Object)?
Conceptor - 12 Mar 2006 3:13 PM - 2 messages
Hi all, [VS2003, Framework 1.1]   I have a grid binded to a DataTable that needs to hold an object reference for each DataRow in a column. I could simply add a custom column in the grid or try to insert the references directly inside the DataRows.  The ...
Score relationship in typed dataset
Efi - 12 Mar 2006 2:17 PM - 2 messages
we have a typed dataset with 2 tables - parent and child with relation and foreign key constraint. after adding 1 parent row to the parent table with 1 related(!) child row to the child table we have the following problem that never occured in VS2003: ...
Score error while exporting data of Outlook to sqlserver
peeyush - 12 Mar 2006 10:42 AM - 3 messages
I am desgning an application in VB.Net and Sqlserver for exporting data of Outlook to sqlserver. I am facing an error on command.executenonquery() line. the error being encountered is: An unhandled exception of type 'System.Data.SqlClient.SqlException' ...
Score how to call a sqlserver proc to get back a dataset?
Fred Exley - 12 Mar 2006 9:03 AM - 3 messages
Here's the sqlserver procedure: ------------------------------------------------------------------------ ALTER PROCEDURE monte_monte.Proc_Ingrs /* ( @parameter1 int = 5, @parameter2 datatype OUTPUT ) */ @dsSQLOutputCursor cursor varying OUTPUT AS /* SET NOCOUNT ON */ SET @dsSQLOutputCursor = CURSOR FOR SELECT NDB_No, FDGRP_CD, DESCRIPTION, USED FROM tblIngredients WHERE FdGrp_Cd = '0400' OPEN @dsSQLOutputCursor RETURN ...
Score Deleting from typed DataSet - why DBNull error?
deko - 12 Mar 2006 7:26 AM - 1 message
I've set up a DataTable (dtPrj) like this:    DataTable tblProject = database.Tables.Add("TableProject");    DataColumn project_ID = tblProject.Columns.Add("Project_ID", typeof(Int32));    project_ID.AllowDBNull = false;    project_ID.Unique = true;    project_ID.AutoIncrement = true; ...
Next »