Hello, I have a some TextBox bind to Access database via DataAdapter and DataSet. I'd like not allow edition, edition will be available via an "Edit" button. Is there an another way than change the ReadOnly property of these TextBox to false (because the background color change) to not all...more >>

Hi: Is there any standard way to ask for the data types on a data base: Something like: SELECT * FROM INFORMATION_SCHEMA.DATA_TYPES to get something like: char, int, image, varchar, money.... So later I can do something like: CREATE TABLE NewTable (NewField _Field_Type_...more >>

Hello, I am querying an Oracle database using the Microsoft Oracle Data Provider for .NET and I am seeing significant performance penalties when I us parameter based queries rather than pure text dynamic SQL. Below is an actual query that demonstrates the problem - the first query, which emb...more >>

How do I insert a NULL value inside an INSERT statement in an SQL Server database? Thank you, Dino -- ------------------------------------------------------------------------- FIGHT BACK AGAINST SPAM! Download Spam Inspector, the Award Winning Anti-Spam Filter http://mail.gi...more >>

Hi, what will be the place to store connection string properties (server name and db)? .Net know offers other good alternatives to the registry. MTIA, Grawsha...more >>

Hello, Would someone out there point me to a place where I can get a good understanding of when to use which IsolationLevel in SqlConnection.BeginTransaction()? I read it from a couple of places but none gave me some sort of guidelines when to use which. At this point, I do my datalayer read...more >>

I have problem to get return valude from my stored procedures. For example, if I insert a polygon and want to get the return primaty key genrated by @@IDENTITY, I have my stored procedure here: REATE PROCEDURE dbo.sp_Add_Polygon_i @Name as varchar(30) , @Area as float, @Prima...more >>

I have a set of variables (varies in type) which I will need to take and make "SQL-safe", that is, if the variable is a string i need it to be converted to 'string' and if it's a bool then it should be coverted to 0 or 1 etc etc.. The reason for this is that I need to build a query dynamicly a...more >>

Since upgrading to .Net Framework 1.1 I can no longer connect to my local sql server using a sql connection string that contains the actual server name (Error: SQL Server does not exist or Access Denied). If I use (local) or localhost as the server name then the connection is made. Does anyone k...more >>

Please, i need to develop an webservice wich deploy a method that must do lots of validation on a database. What can i do? 1. Create an Stored Procedure and inside of it validate everything and return a error code to method and to user or 2. Create lots of Stored Procedures wich one valida...more >>

I'm sure this has been discussed here many times before, but I just can't seem to find a thread with information regarding this. In a connection to an Oracle database using the MS OleDB Provider for Oracle, I used to be able to see Database Diagrams, Tables, Synonyms, Views, Stored Procedures,...more >>

Help!!!!!!! Does anyone know where I can find documentation on how to pass parameters to an access query from a Web page using VB.net code? Any Examples, etc would help! Thanks in Advance Lea...more >>

Dear Group, I have a C# client connecting to a remote mySql database and I'm getting the following exception: Unhandled Exception: System.Data.SqlClient.SqlException: SQL Server does not exi st or access denied. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransac...more >>

Hello! I have a following problem. I have a dataset with many tables, with master-detail relations. I want to display in a DataGrid a view, that is composed from many columns from many tables (ie. Col1, Col2 from Table1 and Col2, Col3 from Table3 ). I don't want to use a navigation featur...more >>

I have found that I am unable to read the parms until after I do a close on the DataReader. Is that accurate? In the instance where you are executing a procedure which returns multiple answer sets, would this still be true? So if I wanted to get the return value for each of the answer set...more >>

Can any one point to a code in which a dataset is populated with a collection....more >>

Hi, How can I connect to an access database located over a remote server through internet? Is it possible if updating a remote database is done in background and application doesn't affect by delay in accessing remote Server? Best Regards, Wasim...more >>

I would like my ComboBox to display the 'CustomerName' value but it should store the 'CustomerID' value whenever it is assigned to the DataTable.LoadDataRow. Also, I need to trap the 'CustomerID'value in the ComboBox_SelectedIndexChanged Event whenever that event is fired. Thanks! ...more >>