On my dev PC the website that i wrote auto creates a word document and it auto-opens in my webbrowser. Whenever i visit the site with another PC the website ask if the user wants to download the .doc document of open it. Why is this and how can i make sure it opens in the browser only. my c...more >>

Hi How to create typed DataSet with relations from a database. Is it possible with VS.NET 2003 or there is a tool doing this? Thanks Konrad ...more >>

I have posted a query before on this particular issue but no one had ever heard of this issue, and I find it difficult to swallow as well, but this is what is happening. When a read an Oracle table and I have a column which has the exact same value in the first row and the second row, the second ...more >>

I was assigned to a project where the main database is XML files instead of RDBMS. One of my primary responsibilities is to create Crystal Reports using ..Net. We are having performance issues when we open and view reports. The reason is because Crystal Report that uses XML as a data source pull...more >>

I am using VS.net 2003 with SQL Server 2000 as the backend in a desktop application. My question has to do with constraints. The books seem to indicate that the best place to place a constraint is at the table level in SQL Server 2000. Maybe so but if there is no way to get data into SQL Ser...more >>

Hi all, I have written a simple Web Application that displays a query result onto a page using the ASP DataGrid. To Digress ======= Development information about the page is as follows 1. The database used is SqlServer 2000. 2. A Stored Procedure is dragged onto the page from the Server E...more >>

I have two tables in my sql database with the same structure. One table has 5 records and the other has 1 record. I want to take the 5 records into 1 dataset, and the 1 record into another dataset, merge into the data into one dataset (the first) and update the table with 5 records so now it has ...more >>

In a Typed Dataset, is there a way on the xs:keyref tag that I can specify how to handle null child objects? For example, if I have an Invoice table, where a ClientID key is used to create a reference to a Clients Table by it's ID Column. On the Clients table I have a Name element. In the cal...more >>

I am writing a fairly large database application for the first time, and am finding it difficult to decide on how to create the data access layer. I have tried reading as much as I can find about them on MSDN, but have found conflicting views, and am now really quite confused. For example, I am u...more >>

Hi there, Does any body know where can I find a good Scheduler components (for appointment scheduling) for .NET.? I'm developing a scheduling application and I need to either build one from scratch, which I have no idea how to do that, or get a prebuild scheduler component that I can just i...more >>

If you have two dataTables and a dataRelation how would you get the row count of the dataRelation? Lets use the obligatory simpleton example - A strongly typed dataset with an Authors and Books table and a dataRelation between the two. ie: myDataSet.Authors myDataSet.Books myDataSet.relBo...more >>

Hi, I am using .Net Framework 1.0 with Oracle. I am using the Oracle provided data provider 'Oracle.DataAccess.Client' and I am using the parameterized queries. Now I want to use the Microsoft provided data provider 'System.Data.OracleClient' for Oracle, but when I change the reference in my ...more >>

Hi, I am using .Net Framework 1.0 with Oracle. I am using the Oracle provided data provider 'Oracle.DataAccess.Client' and I am using the parameterized queries. Now I want to use the Microsoft provided data provider 'System.Data.OracleClient' for Oracle, but when I change the reference in my ...more >>

I was wondering, does the dataadapter populates the whole DataSet objects with all the rows retrieved from the Select Command (eg.SELECT * FROM Customer) . Means, will this slow down the process if there is 10,000 records or more. ...more >>

Hi I have textbox in VB.Net that is bound to a Date/Time field in an Access database. The date in Access database only has the date and no time. When you load the dataset into the VB.Net application though, 12:00 time shows up. I realize this is the default but time is meaningless to our a...more >>

Hi, why is this error exist? there is already an open datareader associated with this connection which must be closed first does the reader running on a server side cursor ? can't it work in a disconnected fashion? what should i do in order to run disconnected or when i want to make ...more >>

My Program needs to insert about 6 Mio records into a large table on SQL Server 2000 which already has 2 or 3 Mio records. It uses a DataAdapter to insert 100 records at a time. About every 2 or 3 hours, the DataAdapter.Update fails with a timeout exeption (SqlException "Timeout expried. th...more >>

Hi, I am new to vb.net and have a question. I created a dataform using the .NET wizard. When I click the "Addnew" command a new row is added but the bound textbox fields do not clear to allow user to enter the new fields values. Am I missing something? the form does display and allow user to...more >>

Hello, I can't filter integer column in DataView I have one TextBox that I retreive the value and one ComboBox where I select column; When column is string (LastName) everything working very well, but when I select integer type (AccountNumber) generate an excpetion: System.Data.EvaluateExcep...more >>

I am manually creating a datatable in memory, creating columns etc for it and then populating it by importing data from files and various databases. Once I have the datatable in memory (which consists of around 10000 records) I need to be able to perform queries on it. I'm not talking about me...more >>

how to check a textbox.text is number? 52532590235320953535355...more >>