In my ASP.Net application, validation rule demands that user has to select one of the option buton(...WebControls.RadioButton). I am doing these kind of validations in the server side when the user clicks on the update button(...webControls.Button). My problem is how to display this message to t...more >>

Dear Experts I got one technical question on using ListBox. I don't know how to solve it, please help. Scenario I placed a ListBox on the Form and I would like to allow my users to do multiple selection. After users select the item(s), I want to collect all the corresponding "SelectValue"(s)(Se...more >>

I am using proprietary ODBC driver to connect to legacy stytem. Should I use System.Data.Oledb or System.Data.Odbc data objects ? Thanks for your thoughts. Johnson Smith ...more >>

Hi, I have one databound-control for which I set the DataBinding properties at design-time as follows : the Text-property of a label-control 'lblProductname' is bound to the field "Productname" in a DataSet named DsProducts1.Products and I have another databound-control for which I...more >>

I am sure there is something elementary I am leaving out, and by this question I am revealing myself as the newbie I am. I have a typed dataset that contains a table named "Orders". When a user enters a new order, I create an OrdersRow object, then I call my table's Add method, passing in the...more >>

Hi, I'm currently investigating what new cool features ASP.NET 2.0 will bring. When I use a GridView and a SQLDatasource like this: <asp:gridview id="GridView" runat="server" font-size="8pt" backcolor="White" allowpaging="True" datasourceid="SqlDataSource" allowsorting="True" borderco...more >>

I have been studying ASP.NET using Visual Studio.NET 2003. I would like to try using MSDE but haven't yet found a good source of documentation regarding how to implement it. Does anyone know of a good source for documentation/tutorials? ...more >>

Hi, I have a strange problem I am trying to understand. I have a piece of code that looks like: Dim SourceDS as dataset Dim ResultDS as dataset SourceDS = RetrieveData() ResultDS = ProcessData( SourceDS) .... When I run this code I occasionally get the wrong information in the ...more >>

Hello All, I have page name MyPage.aspx it has Custom control. fine. and a textbox taking date fine. a button which is used to filter the MyPage.aspx against the date input = into textbox. but when I click the button it is not working. nor debug the page load = event of that page. only t...more >>

Hi there I have a column of type Money in a database table, the column is not mandatory and so allows nulls...in my code when i try to insert into that table, i check if the user has entered a value for the money column and if not, i pass in a sqlparameter with a value of DBNull.Value Howeve...more >>

Hello all! I am writing an application that connects to an Oracle 9i database using OracleClient managed provider. There's a table with a field of NVARCHAR2 type, named TEXT, and another field of VARCHAR2 type, named COMMENT. The application do insert text values into both fields correctly,...more >>

That's great to know... But why is it giving me this error for items that are supposed to be excluded from the project??? Annoying! >=| ...more >>

I am running an sproc that runs in 2-3 sec using query analyzer, but takes just under 5 min using .net data providers (I've used SqlClient, OleDb, and Data block v2 t-sql statement executed from QA RptInvRoyalty 126, '2/1/2004', '2/29/2004 ..net code System.Data.SqlClient.SqlComm...more >>

Hello NG! In a DataSet I have the tables A, B und C. Table B is related to A with DeleteRule=Cascade Table C is related to A with DeleteRule=None This way an exception is thrown, if you try to remove a Row in A and there are depending ChildRows in C. But ChildRows in B are already removed b...more >>

I am writing a simple Windows Forms Application that accesses an Access database. In the form I instantiate a DataTable object. I then read the contents of a single table in the Access file into this DataTable. This works as expected. Next, I instantiate another DataTable and use the .Clo...more >>

I use follow code to insert a large xml into oracle database. The data is inserted, however shows as "¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿.. xmlRawDom.Load("D:\testActual.xml" dataString = xmlRawDom.OuterXm Dim AE As New System.Text.ASCIIEncodin ...more >>

Got an architectural question re .Net. Potential client wants to build a c#.net app with the following reqs. Multiple users in a central office running the app as well as up to 20 remote users going against the same data. 95% of the time they will have a DSL line connecting the remote office...more >>

Hi, I know, i'm repeating this question again. Please accept my apologize, unable to understand clearly. Need to have some inputs in my routine. I'VE A DEADLINE AND I'M STUCK !!!!! :( I'm retrieving Data from Paradox database using (odbc), manipulating and saving in access for report genera...more >>

Hi- I need to make an interface to edit Technical Data records. Table looks like this: Tbl_Tech_Specs [ TSID(pk) ] [ SpecName ] [ SpecValue ] So if there were 2 records; 2 "Voltage" "5v" 8 "Width" "11 in." I would like the user to be able to swap the values of 8 w/...more >>

Hi, After the following code the errorIcon displayed in column 3 of the datagrid bound to MyDatatable is gone, but the tooltip with the errormessage is still there ? How do I erase the tooltip ? Is this a bug ? Any workaround ? 'Following line set the errorIcon & errorMessage MyDatatable....more >>

Is there a way ti find out if there are error during DataAdapter.Update method call? -- Ruslan Shlain nAlliance Corporation www.nAlliance.com ...more >>

Hello, I'm using VS.NET 2003 to create a data framework for my applications. An application can request data about a customer, edit it and save it back to the database (SQL 2000). Some applications edit a lot of the data or create new rows (sometimes >100.000 rows). It takes the DataAdapter very...more >>

I've coded a page that uploads a file to a directory on the server. I'm now thinking it would be more convenient for this project if the file was placed in a field in my SQL Server DB. Can anyone give me an insight on how I might go about doing this please? Thanks, Andrew ...more >>

We are experiencing a problem in using the Microsoft .Net Data Provider Fo Oracle. For certain more complex SQL queries it does not return the correc number of rows. The behaviour can take two forms 1 the DataReader returns no rows back to the calling program, on th database one fetch has been d...more >>

Hi all, Trying to relate copy's of two tables in another dataset so I can loop through MainDS Basically i'm trying to copy the two datatables and then put them in a global dataset. I then need to loop through the dataset. so how do I relate and copy two datatables into one dat...more >>

Hi All, I would like to know if there is any upper limit on the number of rows that a datatable can contain? Thanks in advance. ~ Kapil ...more >>

A little problem I am having and its driving me nuts. I have a datatable and I am adding a column to it on the fly. Then based on some other fields i add or not add a value to that column for each row. When I do update statement on DataAdapter I get "Specified cast is not valid". The DB column ...more >>

I have a sproc on sql server that I am calling from an asp.net app using the data application block v2 method ExecuteDataSet. The sproc returns data that is bound to a datagrid. The problem is that the command times out when being called through .net but only takes 1-3 sec when run from query analyz...more >>

I know this sounds strange but I am at a loss. I am calling a simple funtion that opens a connection to a SQL Server 2000 database and executes an Insert Statement. private void AddMinimunWageStipen(string payrollid,double amount) { System.Data.SqlClient.SqlConnection cn = null; System....more >>

I am building an app that requires related data (parent/child) to be displayed and updated via text boxes. I related the data in the DataSet XML designer. The parent info is a contacts table with addresses, etc. The child info is a locations table which has a foreign key referencing the contact I...more >>

Hi, I got a problem. I don't know how to solve it. I have two columns, NetEach and Rate. Then I create an expression Column, Total, like this Table1.Columns.Add("Total", GetType(Decimal), "NetEach * Rate") i.e. Total = NetEach * Rate So if NetEach = 10, and Rate = 0.1299, then Total = ...more >>

vb.net oracledataadapter connection Error: OCI.DLL ...more >>

anybody ever get this error and knows how i can troubleshoot it? i get it at various times when accessing the database - no pattern to the types of database operations can be found. thx. ...more >>

I'm developing an application in C#. The application consist of a data layer which must be capable of using mysql, mssql and access for data storage. I started using OleDb with interfaces like IdbConnection to achive this. Everything worked fine until i came at the issue of locking. I found out ...more >>

How do i set the default value of a datatable column to zero. At the moment it is displaying a null Does anyone know how this is done thank you ...more >>

New user of SQL Everything is on the same machine My error is close to the bottom After reading it today, I can see there is a problem with 2 dbases 'PUBS' and 'Master' There are also some comments from the group: ---microsoft.public.sqlserver.odbc-- subject: Permission Denied -- Thanks for h...more >>

Hello everybody, we are currently working on a Oracle 9i Project with the ADO.NET Framework version 1.0. We have multiple tables in this database which are linked together by a shared primary key. The relationship among these tsbles is always 1:1, so each row in a table has a corresponding row ...more >>

I have a question about validating user input, which the user can enter in a DataGrid. I use the rowchanging event of the DataTable to which the DataGrid is bound. In this rowchanging event-handler, I check the column data of the row, and if not correct, my own exception is thrown I’m having prob...more >>

Hallo How can I programatically Compact and Repair an Access Database in VB.NET Nigel......more >>

Hi All, I'm looking for an Ideal and best logic towards open a database connection to SQL server 2000 from an ASPX pages. I have desinged an Intranet application. But I don't know that I have applied an ideal logic to open a connection from my application. Below is the details of m...more >>