Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Oracle ODP.NET stored procedure help needed (PLEASE)
dave - 12 Aug 2006 2:50 PM - 7 messages
I am using asp.net 2.0 and the latest 10.x odp.net driver to execute an update stored procedure in Oracle 9.x. I have been getting the following intermittent error ORA-06502: PL/SQL: numeric or value error ...
Score Using queries in a table adaptor?
Michael D. Reed - 11 Aug 2006 11:16 PM - 9 messages
I have a data set called “ProductDataSet.xsd” that include several tables one called [Drive Packages] with 14 columns and several rows of data.  The table adaptor attached to this is a table adapter called “Drive Package ...
Score Executing query with group by and aggregate on a dataset
sudarsan1980 - 11 Aug 2006 9:18 PM - 2 messages
i have a dataset which pull all the info into a table , now i want to use queries based on that table. as an example in the following  query it has both aggregate and group by . is there a way i can execute such a statement on the dataset and ...
Score ContextSwitchDeadlock was detected
v.maggs - 11 Aug 2006 7:01 PM - 1 message
Folks,     I am connecting to an Oracle 8.1.7.4.1 database and executing a stored procedure, Change_Results. The code works great but soon after my VB2005 app starts, I get this message: ContextSwitchDeadlock was detected. ...
Score Using Strongly Typed Datasets
ctilly - 11 Aug 2006 6:23 PM - 4 messages
I am interested in using strong typed datasets, but I am having some difficulty with some things and was hoping for a little clarification. I am using VS 2005 (.net 2) and I start off by creating a Dataset to my ...
Score DataBind() Causes Connection Pool to overflow?
dwhalen - 11 Aug 2006 4:49 PM - 2 messages
Hello all. I have been debugging with a Connection pool overflow issue, and I'm seeing something very unusual. Using performance monitor, I am tracking the number of Current Pooled Connections.  The number stays fairly low as I connect to the database, ...
Score Cannot remove Unique key from Typed DataTable.
arthernan - 11 Aug 2006 4:24 PM - 2 messages
For some strange reason, which has the hairs of a bug. I created a new column on a DataTable which I first had placed in my dataset from the server explorer table. After I finished I realized that unknowingly I ...
Score The ConnectionString property has not been initialized.
archuleta37 - 11 Aug 2006 4:13 PM - 6 messages
My debugger is saying that the ConnectionString property has not been initialized. when I try to open the connection. My goal is to loop through an arraylist of objects (OrderModel) and insert a record each time. What am I missing here? ...
Score Assign Null to textbox after deleting its content
Arend Jan - 11 Aug 2006 10:19 AM - 2 messages
Hi, I have a form in which the tableadapter gets its data from an access table. Suppose I want to delete a clients phone number. I select the text in the phone number field, and press delete. The field is now empty. ...
Score ASP.NET Forms Authentication and ATLAS control problem
ashish - 11 Aug 2006 9:06 AM - 1 message
Hello, I am using Forms Authentication in ASP.NET 2.0 website. I have also implemented UIP Application Blocks. On one page I have used ATLAS Cascading Dropdown. The page looses session and redirects to login page on click of any link on the page. ...
Score Auto number generator
Rino - 11 Aug 2006 6:28 AM - 6 messages
Greetings, I am having problem with the following codes for some reason and I cannot figure it out where the problem is. However, what I'm trying to achive is to have a auto number generator for my quote form, so ...
Score SQL SERVER 2005 Data Type convertion to VB.NET 2.0
Flavio - 11 Aug 2006 12:22 AM - 4 messages
Hi guys, what i'm trying to do is to create a Dynamic class generator  based on tables from a sql2005 database. To get the list of Colums from a specific table i Use: "select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'TableName'" ...
Score Web method request returning incorrect resultset FOR CONCURRENT USERS
rao - 10 Aug 2006 11:34 PM - 1 message
I have a C# Web Service with several Web methods. If I try to access a method that returns a dataset based on a specific criteria and another user tries to access the same method with a different criteria and we ...
Score BindingNavigatorDeleteItem
kvenkatu - 10 Aug 2006 11:10 PM - 1 message
Hello, I am trying to delete a row from a datagrid using BindingNavigator delete iterm. I added the following code in BindingNavigatorDeleteItem_Click(). This code only deletes the record from the datagrid, it does not delete from the database table. Private Sub BindingNavigatorDeleteItem_Click(ByVal sender As ...
Score BindingNavigatorDeleteItem
kvenkatu - 10 Aug 2006 11:10 PM - 3 messages
Hello, I am trying to delete a row from a datagrid using BindingNavigator delete iterm. I added the following code in BindingNavigatorDeleteItem_Click(). This code only deletes the record from the datagrid, it does not delete from the database table. Private Sub BindingNavigatorDeleteItem_Click(ByVal sender As ...
Score Get modified colums only
Chris Karcher - 10 Aug 2006 9:46 PM - 6 messages
Is there a way to get only the modified columns of the rows in a DataSet? When calling DataSet.GetChanges() I'm getting the entire row, whereas I just want the columns that have been changed.  Is this possible? ...
Score Database Design
MasterChief - 10 Aug 2006 9:22 PM - 2 messages
I am trying to make a document/training website. What I would like is for somebody to click on a job on the left, have it display all the programs/software that are available for that job and then once the ...
Score ASP.NET with Datasets
nashak - 10 Aug 2006 8:17 PM - 5 messages
Hello, ASP.NET pages are disconnected html pages i.e once page is sent to the browser, that is it. Let's say that I have a datagrid on my page and I have used a dataset to fill this grid only during the first visit to the page. My page ...
Score SqlDataAdapter.Fill exception in Release but not Debug Mode
TLentine - 10 Aug 2006 7:40 PM - 3 messages
I apologize in advance for the lengthy post, but any help or insight would be greatly appreciated! I've been having a problem with the SqlDataAdapter's Fill method while attempting to fill a dataset with the results of a query I execute against a ...
Score Simple design Question
sklett - 10 Aug 2006 7:07 PM - 2 messages
I'm redesigning my application to use ADO.net and this is also resulting in a schema redesign - FUN! I have a fairly newbie design question; I have a table called Tbl_ProductInfo and it has fields like this:     ProductTypeID ...
Score HowTo Delete related rows
sjoshi - 10 Aug 2006 4:28 PM - 3 messages
Hello All I have a DataSet with tables Customers, Orders related by CustomerID coln. Now Orders has a field "FixIt", if this is set to true, I need to delete that row. The possible scenarios are: 1. Customer_1       Order_1 false ...
Score DBHelper.GetConnection
mc - 10 Aug 2006 3:39 PM - 3 messages
I have a class (shown below) used to save me retyping the Connection initialization code and other handy things, the Code Review tool in Ms Visual Studio is telling me that the I should "Change 'GetConnection' to a property if appropriate" ...
Score system.IO.File.Exists doesn't working for file that is outside my virtual directory
Max - 10 Aug 2006 2:57 PM - 1 message
hi i have file browser control to select any file and a button to upload file on my web page now when i select any file. now on click of upload button i have check that file exist or no ...
Score Auto tab in Datagrid onKeyUp
Jay - 10 Aug 2006 1:31 PM - 1 message
When editing a datagrid (datagrid1) I need to automatically tab from one textbox to the next (txt1, txt2, etc.) onKepUp.  I have found lots of client script (java) to do this in other control, however, not in a datagrid.  So ...
Score Debugging SP's
Ant - 10 Aug 2006 12:30 PM - 3 messages
Hi, I'm using VS2003 I'd like to step into a stored proc by setting a breakpoint on a line in the SP design page. I have enabled SQL debugging in the configuration properties, but it still won't break at the break point. Do I need to do anything else? I ...
Score Goldilocks and the Three Stooges
Earl - 10 Aug 2006 5:11 AM - 1 message
I ripped out the connection objects created when I created typed datasets on two forms. Went thru and cleaned up all the code to give the data adapters their connection for each of the commands. Did a search for any hardwired ...
Score This sure is cornfusing ... connection woes
Earl - 10 Aug 2006 1:36 AM - 7 messages
SQL2005. New installation as a named instance on a local machine. Attached a database previously designed in SQL2000. My app calls for this database using integrated security. With SQL2000, no problems connecting and executing code against the db, including stored procedures. ...
Score Tip: How to use the OleDbLiteral enumeration
Vamsidhar - 10 Aug 2006 12:53 AM - 1 message
I think I've finally found a way to put the OleDbLiteral enum to good use. Wanted to share it just so it may save someone a little time :-)     //     //OleDbConnection connection     // ...
Score send listbox items to report
Rino - 9 Aug 2006 9:55 PM - 1 message
Greetings, I am looking for someone that could help me with the following situation. I have a listbox on the form that contains x amount of rows that user populates. I'd like to move all those rows to report in MS Access. Row ...
Score Transactions with configured TableAdapters
Shimon Sim - 9 Aug 2006 7:49 PM - 7 messages
Hi I followed some walkthrough for creating Typed Dataset and TableAdapters. One thing I can't figure out is how to use transactions with generated Table Adapters. Any ideas? Thanks, Shimon ...
Score Sql injection and data adapters
jeff.ranney - 9 Aug 2006 6:59 PM - 5 messages
Hi all. My question, basically,  is: if I do this, am I open to a sql injection attack? DataAdapter.SelectCommand = new SqlCommand("SELECT * FROM Users WHERE UserId = 1",ConnectionObject)  //Let's assume for a moment that that sql string is not dynamically constructed and not susceptible..  I am ...
Score DataTable and Select
Thomas Kehl - 9 Aug 2006 6:48 PM - 4 messages
Hello. I have a DataTable which contains two columns (BEZEICH and PERSON_L). BEZEICH is of the type string and PERSON_L of the type byte[] (Property DataType of the columns). Now, I have to do a select on this Table. I try it ...
Score DB2 - OLEDB
Jim Heavey - 9 Aug 2006 6:48 PM - 2 messages
I create a ".UDL" file on my desktop.  I double click the ICON and supplied the connection information so that I could connect to DB2,  I test the connectiion and I get a message that the connection was successful.  Now when ...
Score System.Transaction performance with non SQL 2005
Peter Meinl - 9 Aug 2006 5:56 PM - 2 messages
Our customer will use transactions against single SQL Server 2000, 2005 and AS400 databases (no distributed transactions). I am evaluating using TransactionScope vs. SqlTransaction. Some internet posts say that with non SQL Server 2005 databases TransactionScope will always use the slower distributed model using MSDTC. ...
Score DataSet en MS Access
Foef - 9 Aug 2006 4:19 PM - 6 messages
Hi, I'm using Visual Studio .NET 2005 and .Net framework 2.0 I have a DataSet with data from an MS Access database table. In the MS Access database is a tablefield with a Display Control. This Display Control is set as Combo Box. ...
Score Cannot close OleDBdatareader/Connection on Sybase
Fassa - 9 Aug 2006 4:10 PM - 2 messages
Hi All, I've written this simple bit of code:     Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click         Dim sybaseconn As OleDbConnection ...
Score Change FormView.ChangeMode to Edit after Insert
J055 - 9 Aug 2006 3:31 PM - 2 messages
Hi I'd like to do the following with the FormView/ObjectDataSource but not sure of the best approach. 1. Change the FormView mode to Edit if a valid QueryString ID exists or Insert mode if it doesn't 2. If in Insert mode then when the form is posted it should get the new ID ...
Score System.Net.Sockets.SocketException: No connection could be made because the target machine actively
daz_oldham - 9 Aug 2006 12:50 PM - 1 message
Hi I have what I believe an ADO.net problem with my ASP.net (c# 2.0) application. Background: Originally developed with VS2005 on an XP box with SQL Server 2005 and running on Windows 2000 with SQL 2000.   I am only ...
Score 2.0: ExecuteScalar returns null
RAM - 9 Aug 2006 11:09 AM - 7 messages
Hello, I am learning .NET 2.0. I am trying to call a stored procedure: SqlCommand cmd = new SqlCommand(); cmd.CommandText = "NextDocumentNumber"; cmd.Transaction = t; cmd.Connection = c; int n = (int)cmd.ExecuteScalar();    // here problem The problem is that ExecuteScalar returns null although executed in SQL ...
Score select performance, datatables or mssql2000 ?
Danny M - 9 Aug 2006 8:47 AM - 2 messages
I am making a pre- cluster tool. At the moment i am using a datatable to read the databases. With help of some rules i find the records that could be double records. I am using datatable.select to find the records a rules find and i add ...
Score ado.net / execute reader / sp question
Gary Howlett - 9 Aug 2006 7:56 AM - 2 messages
Hi, I have a stored procedure which has a couple of input parameters and out parameters as below... If in C# .Net2.0 using SQL ADO.NET if I use ExecuteReader I get the results of the user table but if in the code i use ...
Score NamedPipes error
Earl - 9 Aug 2006 3:53 AM - 5 messages
I have an app that connects fine to a SQL Server 2000 install using TCP/IP only. When I tried to connect my app to the same database on a new SQL 2005 installation today on a client's laptop, I got a "Named Pipes provider" ...
Score Strongly DataSet with multiple DataTables filled?
Erik Funkenbusch - 9 Aug 2006 1:12 AM - 3 messages
..NET 2.0 VS 2005 I've got a remote database behind a firewall, I need to create a web service that returns a dataset populated with multiple DataTables (so I don't have to make several expensive soap calls). ...
Score Transform DataTables
Alex - 8 Aug 2006 9:44 PM - 4 messages
I need to transform a data table that would eventually be exported, E.g.     The original table is as follows:  ID     fName     lName                                                     1     Alex         Smith ...
Score ExecuteReader question
Gary Howlett - 8 Aug 2006 8:31 PM - 1 message
Hi, I have a stored procedure which has a couple of input parameters and out parameters as below... If in C# .Net2.0 using SQL ADO.NET if I use ExecuteReader I get the results of the user table but if in the code i use ...
Score Adding ENUM column into a table (C#.NET)
John Carret - 8 Aug 2006 4:44 PM - 5 messages
I need users to be able to edit the database file created by my application in MS Access and I need to ensure they will enter suitable data only to prevent possible future errors. That's why I need to use ENUM typed columns. I don't know where the problem might be but I'm not able to ...
Score no value given for one or more parameters
cashdeskmac - 8 Aug 2006 4:18 PM - 3 messages
Hi, I know there are a couple of other posts regarding this matter, but I am using the simplest of statements, yet the get the above error.  My code looks like this: OleDbCommand cmd = new OleDbCommand ("SELECT Name FROM Employees", Conn); ...
Score Requesting SqlBulkCopy Advice
myusenetaccount - 8 Aug 2006 3:42 PM - 2 messages
Hello all, I'm looking for a bit of SqlBulkCopy advice for a web application that appends large amounts of data into an existing SQL Server table. SqlBulkCopy seems to be an excellent API for the task and it would ...
Score Transaction Timeout
Dominik Amon - 8 Aug 2006 3:21 PM - 1 message
Hi there! i have a strange problem, when using TransactionScope in .net 2.0. I get an TransactionException with a timeout after a while, about half an hour. But i set the Timeout manually to three hours. Here is the stacktrace: ...
Score Update DataSet definiton from Server Explorer
TheMaxx - 8 Aug 2006 3:15 PM - 3 messages
I use typed DataSet (drag'n drop from server Explorer from SQL Server 2000). Each time i modify a table i need to update the Dataset. I do it by deleting and adding a table again from Server Explorer.  As ...
Score web.config appSettings Store value with & character
Max - 8 Aug 2006 1:22 PM - 3 messages
hi i have stored my connction string in web.config as we do usually. code of web.confing is given below. check the password field contain "&" character. now when i run my application it gives error because value of ConnectionString is breaked ...
Score Multiple Values To Oracle Parametter Object (IN)
timburda - 8 Aug 2006 1:18 PM - 4 messages
Here is the scenario: I am looking to execute the following query: SELECT  * FROM     TBL_USER WHERE  USER_ID IN ( 1,2,3,4) Now, since in-line SQL is rightfully frowed upon, I am attempting to ...
Score Creating Access DB without ADOX
John Carret - 8 Aug 2006 8:27 AM - 10 messages
Is it possible to create a new Access database file without ADOX? I have to store an empty MDB file for further use now and I'd like to get rid of it. It would be great to create new database files when I need them. I do not like the fact I have to store ...
Score How to get cursor as return value of oracle function back with ole
Kent Liu - 8 Aug 2006 7:04 AM - 5 messages
I am using System.Data.Oledb, I have oracle function that return the result as REF Cursor: CREATE OR REPLACE PACKAGE GET_EMPLOYEES AS TYPE T_CURSOR IS REF CURSOR; FUNCTION GetEmployees (userID_in IN VARCHAR2 := NULL) RETURN T_CURSOR; ....... How to get the result back ? ...
Score How to fomat table columns as attributes rather than elements
moondaddy - 8 Aug 2006 6:32 AM - 6 messages
I'm new to .net 2.0 and I want to create a dataset using the designer where the table columns are attributes rather than elements.  I could do this before in 1.1 but I dont see how in 2.0.  Please advise. ...
Score Dates get rounded when passed to Sql Server with time component
Stanley Omega - 8 Aug 2006 1:50 AM - 3 messages
Hello, I needed to get the last day in the month. I used a very basic formula which essentially subtracted 3 seconds from the 1st day of the following month. This gave me a string like "#7/31/2006 11:59:57PM". ...
Score OracleDataAdapter.Fill throwing "Index out of Range" error
dalaeth - 8 Aug 2006 1:42 AM - 1 message
I have searched Google high and low and haven't found anything that works.  Here's my problem, hopefully someone will be able to help! I'm using 1.1 Framework, and ODP.NET 9.5.0.7 on a Windows 2003 Server. ...
Score HELP!!! DOGS IN CHINA
Cookie - 8 Aug 2006 1:19 AM - 1 message
This picture outs tears in your eye...:'(:'( [link] [link] [link] ...
Score HELP!!! DOGS IN CHINA
Cookie - 8 Aug 2006 1:19 AM - 2 messages
This picture outs tears in your eye...:'(:'( [link] [link] [link] ...
Score Dataset from dynamic sql
John - 7 Aug 2006 10:32 PM - 4 messages
I'd like to create a typed dataset based on a db-defined structure (ie defined in records in the db, not in metadata!) I tried a stored procedure (SQL Server 2005) that's creating some dynamic sql based on the queried structure, something like: ...
Score Retrieve a list of parameters for an MS Access SPROC/Stored Proced
Nate. - 7 Aug 2006 8:31 PM - 3 messages
Since System.Data.GetOleDbSchemaTable does not support the querying of SPROC parameters in MDAC 2.7, does anybody know of a work-around? Does anybody know of a specific SQL query that can return the details of sproc parameters? ...
Score ANN: VistaDB 3.0 world's first managed SQL database for .NET and Compact Framework
VistaDB - 7 Aug 2006 8:07 PM - 1 message
VistaDB 3 CTP has been released as the world's first fully managed SQL database engine for Microsoft .NET, Compact Framework, Windows Vista and Mono. Unlike the new SQL Everywhere, .NET developers can use VistaDB 3.0 to build 100% managed WinForms and ASP.NET database applications that run on desktops, mobile devices and web servers. VistaDB's small 600KB assembly includes a built-in ADO.NET Provider, which means that VistaDB can be embedded into any .NET application. VistaDB 3.0 also makes mobile development and deployment easy since the same VistaDB 3.0 assembly will run on all mobile devices. Read more: [link] ...
Score On the 15th Day of The Israeli Aggression : A total of 958 deaths since the beginning of the war....
LEBANON - 7 Aug 2006 7:25 PM - 1 message
On the 15th Day of The Israeli Aggression : A total of 958 deaths since the beginning of the war, over 3,369 wounded, 915,762 Displaced, and the world is still silent! THIS IS THE LEAST WE COULD DO FOR : LEBANON! Look at those pictures [link][link][link][link][link][link][link][link][link][link][link][link][link][link][link] Tell your friends about what is going on! ...
Score Re-Sorting DataTables
MR - 7 Aug 2006 7:14 PM - 3 messages
How can I re-sort a the rows in a data table? Here is the example: I read a data set that is sorted by probability. Then some algorithm recalculates the probability field in each record.. As a result of the new ...
Score DB2 Connection
Jim Heavey - 7 Aug 2006 7:03 PM - 1 message
I am working with the connection strings for DB2 for the first time.  I went to ConnectionStrings.com and got the sample formats for ODBC and OLEDB.  They are as follows: ODBC: driver={IBM DB2 ODBC DRIVER};Database=myDbName;hostname=myServerName;port=myPortNum;protocol=TCPIP; uid=myUserName; pwd=myPwd ...
Score formatting dates in queries
ZenRhapsody - 7 Aug 2006 5:12 PM - 8 messages
BACKGROUND INFO: I'm using the common DbConnection object in my application because the user can have data hosted in Excel, Access, SQL Server, or Oracle.  I'm using the common   DbProviderFactories.GetFactory(providerName); to get the appropriate factory object for creating a specific connection ...
Score oracle with visual studio 2005
realin - 7 Aug 2006 4:46 PM - 2 messages
hey guyzz !! actually i had installed Microsoft visual studio 2005 along with Oracle 9i enterprise edition, jus wanted to know how can i connect it thru VS when i makin a project in c #. when i put a namespace using.System.data. ?? ...
Score Pass GUID parameter
sjoshi - 7 Aug 2006 4:01 PM - 2 messages
Hello All I'm using OraOLEDB.Oracle provider for accessing Oracle. Now I have a column of GUID type that is stored as RAW in Oracle. How do I pass value/type for that parameter. ?? I was using the  type of the ...
Score SQLCE DataAdpater.Update says updated but hasn't
Mike - 7 Aug 2006 3:45 PM - 8 messages
Hi, I have an application running on a Windows Mobile 5.0 device and am using the following code to update tables in a SQL Server Mobile database . For some tables, the following code works fine but for others the database does ...
Score machine.config and DbProviderFactories + gacutil registration
xor_eax_eax - 7 Aug 2006 3:38 PM - 1 message
I didn't find any answer to this, can you help me on this, it appears that there is no magic api or command in order to add provider into DbProviderFactories without changing the machine.config file. If so, is it dangerous to chang the machine.config with System.Configuration? ...
Score Using SqlBulkCopy with System.Transactions namespace
Michael Vanhoutte - 7 Aug 2006 3:30 PM - 4 messages
The MSDN document [link] explicitely states that it is possible to use the SqlBulkCopy class with a transaction created using the classes in the System.Transactions-namespace. However, I notice that the SqlBulkCopy ...
Score Using Count with a DataTable help!
VTOcin - 7 Aug 2006 3:04 PM - 1 message
Hi, I'm trying to convert my old VB6 code to VB2005. I was using a MDB database and a SQL statement to do a GROUP BY COUNT. I have been struggling to find a clear and simple VB2005 example on how to do that ...
Score System.InvalidCastException
mbarb5ne - 7 Aug 2006 2:42 PM - 2 messages
Newbie with this stuff. Trying to start small and just read a line in from a database to see what happens.  Not even really trying to do anything with it yet.  When I try to read in the return statement using GetString, I get a ...
Score Cool Interview Questions Link
softwareakash - 7 Aug 2006 2:31 PM - 1 message
Hi all Are you appearing in any dot net interview I found a very useful link for Interview question in Microsoft technologies. It helped me a lot in Interview preperations :) Here is the link [link] ...
Score SqlBulkCopy class problem - Computed Columns
Sri - 7 Aug 2006 2:26 PM - 2 messages
While using SqlBulkCopy to insert data into a table which has a compupted column it fails, throwing an error about not being able to insert data into a computed column which is understandable, The only way you can insert data ...
Score Insert 3 Gb binary file to oracle blob using Ado.net oracleclient
kapatel - 7 Aug 2006 1:30 PM - 2 messages
I was trying to insert 3Gb binary file to oracle 10g BLOB Field using ADO.Net The application uses  Oracle Transaction . Now I have tried to read the file using following code (C#) string filePath = aFilePath ; FileStream fls = new ...
Score Customize MSDataSetGenerator in VS.NET 2005
Dirk - 7 Aug 2006 12:39 PM - 1 message
Hello, I make heavy use of the Typed DataSet feature in VS.NET 2005. My problem is that I have to support MSSQL and ORACLE databases, but the Code generated by Visual Studio is vendor-specific. I read a lot of ...
Score VS 2003 & SQL 2005 Data Adapter Error
Dave Griffiths - 7 Aug 2006 9:40 AM - 7 messages
Hi All Very new to ADO.Net & SQL When I create a data adapter to SQL 2005 server I get the meassages. Generated SELECT Command Generated TABLE Mappings Error creating INSERT command Error creating UPDATE command Error creating DELETE command  ...
Score ANN: VistaDB 3.0 world's first managed SQL database for .NET and C
Anthony Carrabino - 7 Aug 2006 5:22 AM - 3 messages
VistaDB 3 CTP has been released as the world's first fully managed SQL database engine for Microsoft .NET, Compact Framework, Windows Vista and Mono. Unlike the new SQL Everywhere, .NET developers can use VistaDB 3.0 to build 100% managed WinForms and ASP.NET database applications that run on ...
Score Oracle.NET problem
christof - 6 Aug 2006 8:04 PM - 1 message
I wish to make a backup, with host copy operation but got problems with double backslash \\ occuring in my OracleCommand, got always exception "Invalid SQL", here's my command (.txt only as example): OracleCommand oraCmdCopy = new OracleCommand(String.Format("host copy ...
Score Saving indeterminate value of CheckBox cell into an Access database
nvx - 6 Aug 2006 7:21 PM - 1 message
Is it possible to save an indeterminate value of a DataGridViewCheckBoxCell cell into an Access database? If so, how? I can't seem to find a way... Thanks for any information. With regards nvx ...
Score Connecting forms
harrypotter - 6 Aug 2006 1:26 PM - 2 messages
I'm a new comer to the vb.net field. & I'm looking for some help on these questions. 01)  Is there any limit to the number of form which can add to a certain project ? 02)  I want to know how to connect a number of forms, like 1, 2, 3, 4 ...
Score sp_foreign_keys_rowset
Patrick - 6 Aug 2006 8:53 AM - 2 messages
sp_foreign_keys_rowset Does anyone know how to call this from csharp? I've profiled that the correct sql is going to the server (and it runs in QA) but ADO will not return a DataReader when I know there are results. ...
Next »