Hi All, I'm new to ASP.NET and have a basic question. If someone is willing to lay it out for me in an easy way to understand, I have a huge list of tasks I'm willing to pay to get completed... please help. Quick background... I've got three books on ASP.NET web app development. If I foll...more >>

How to fire a query on tables from multiple data sources? For example: ORACLE database contains Employee table: EmpID, EmpName SQL Server Contains EmployeeSalary table: EmpID, Salary I want to fire a query to select EmpID, EmpName, Salary from the above 2 tables residing on different d...more >>

Greets I have sucessfully created a sql database and vb.net program locally connecting to my local server. (I used visual studio 2003) I would like to send the database along with the compiled vb.net code to the user. The problem is the users machine and msde server are going to have dif...more >>

I don't understand the following error message. Why is there no accessible arguments when Intellisense allowed it? An unhandled exception of type System.Reflection.AmbiguousMatchException occurred in Microsoft.visualbasic.dll No accessible overloaded 'SqlHelp.ExecuteNonQuery' is most speci...more >>

Hi all, I'm developer that use VB .NET to develop my application. After I get all data from database and fill those data to dataset object and then I use dataview to filter and bind data with controls on my Form. In the database table consist of default value and general value that represe...more >>

I am attempting to select data from Database A into Database B (both Access Databases) by placing the selected data into a Dataset and then inserting it into the 2nd DB. I can select the data, fill the dataset, create the Adapter commands for insert update delete, but the update is not succes...more >>

Hi Guys, We are making use of SQL2K DB installed on W2003 server for the first time. We bumped into a whole lot of security related issues, that we managed to solve, and we have one (hopefully) last outstanding problem keeping us in the dark. We have some ASP.Net code that is trying to access ...more >>

Hi all, I really, need your expertise. I have an image field in an MSDE 2000 SP3 database. So far I can save images but can not clear them without deleting the entire record. Can anyone show me how to clear an image field using VB .Net 2003 Thank you for all your help...more >>

I've got a SELECT statement that, when run in the Enterprise Manager, works great. However, when I use that same statement in a SelectCommand.CommandText string, I get the following error. Can anyone tell me what I need to look for? Failed to enable constraints. One or more rows contain values v...more >>

The DataAdapter.Update method returns an int to indicate how many rows were successfully updated but if I set the UpdateCommand to a stored procedure how do I hook it up to return the correct value and so that ADO.NET can recognize when it fails and call RejectChanges on the rows that couldn't...more >>

Hi all, My .NET application needs to know if the currently logged on user has rights enough to create global tables, indexes, stored procedures, views, etc in the current database. The program runs through routines that create all these tables and we have to make sure there is sufficient...more >>

Hi all! I have a form, which populates a couple of text boxes when a user id is entered and a button is hit. I need to know how to save the text in the text boxes back to the database. Also how do you count the number of records as bindingcontext doesn't seem to work in ASP.NET Thank...more >>

Hi there, We have a web application handling thousands of requests per seconds reading sql server data which is heavily updated. We are generally experiencing no performance problems. On some occasions we get an increase of the traffic of about 15% for short periods. In this case we observ...more >>

Using ADO.Net to connect to Oracle 8i using OracleClient managed provider. Learnt that OracleClient data provider does not support ODBC escape syntax for calling SPs or Functions. For example CommandText = "{?=Call Function_NAME(?,?...)}". OracleClient does not populate the Parameter Colle...more >>

Due to business rules, I cannot do a standard SQL-Update. I actually need to delete and then insert. How can I handle this, when the OleDbDataadapter only supports a single UpdateCommand? The data sources are Access, Visual FoxPro 8.0, and SQL Server (thus my needs for OleDb). Thanks....more >>

Hi there, I just wanted to know wheter any row locking takes place when we are reading data with a sqlDataReader. I know that within stored procedures and triggers the default is Row locking. Is it the same with a datareader? Thanks ...more >>

I have a dataview in which the sort property will not sort the dataview. Here's is a simple scenario similar to what I am doing: Class Foo Private Function Retrieve() As DataView ' Returns a DataView with 2 columns and 3 rows Dim ADOHelper As New DAL.ADOHelper Return ADOHelper....more >>

Hi. In my application i need to read tables that saved as .txt files with values delimited by ',' into DataTable object. Please tell me what is good way to do it? *-----------------------* Posted at: www.GroupSrv.com *-----------------------*...more >>

Hello, I was wondering if anyone knows how to manipulate datasets at runtime with different functions. I have a dataset that returns a collection of data, but I want to manipulate that data into another dataset that would generate a chart. Here is an Example of what I mean: ds1 has fou...more >>

Hi everyone, I intermittently get a timeout error raised from a loop in which I am iterating through records with a SqlDataReader in order to build a Hashtable. The command object has its CommandTimeout property set to 0, so it should never 'time out', but every once in a while it will, and o...more >>

Hello eveyone, I have the below code which is trying to load an Excel file into a DataSet, however it errors at the oAdapter.Fill(ds); line with An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll. Can anyone spot the a reason why. or help with thi...more >>

All, I am writing a form field application for user data with firstname, middlename, lastname, department. I have written an Add/Edit Stored Procedure in SQL 2000 which checks if an ID exists, if so it backs up existing and updates, then is supposed to return the ID back and a status ID, if...more >>

Hi I am having getting Oracle error ORA-06512 when my .NET serviced component tries to participate in a COM+ transaction. I am using System.Data.OracleClient with VS.NET 2003 (i.e. Framework 1.1) on Windows 2000 SP3 and Oracle 9.2.0.4. If I change my code to use System.Data.OleDB then ev...more >>

Hi again, So, my previous problem was solved but unfortunately, the solution has introduced another problem that I can't figure out. I'm beginning to think that the idea of reusable code might be more trouble than it's worth in this case. To recap: I have a class library that I'm usin...more >>

I am developing a windows forms application which takes its data from an SQL server database where all the primary keys are uniqueidentifier fields. I am creating strongly typed datasets and populating them using the Fill method. My problem is how to generate guids when inserting rows into th...more >>

I have a couple of questions about how the ds.Update, AcceptChanges, RejectChanges work. I have a dataset with 8 tables. I perform a ds.Update separately for each one of these tables. Most of these tables are not related. 1. Should I be calling ds.AcceptChanges right after the call to ds.U...more >>

Hello there, I hope this is the right newsgroup to post this question... Let's say I have a 3-tier .net app: tier 1: sql server 2000 tier 2: win app client tier 3: a web service delivering data from t1 to t2 using a DataSet. The data transferred is of about 65.000 rows. This is...more >>