I'm using vb.net, but if you only have a c# answer, feel free to offer it!. Anyway, I have a DataTable and a DataView which is a subset I have ID'd to be deleted from that DataTable. I tried looping through the DataView and deleting rows like this: Dim dvAuto As New DataView ...more >>

Since Microsoft removed the original thread from this newsgroup... here it is again. Just to add some comments: we are MSDN Universal Subscribers and didn't get support from Microsoft. We are being ignored for almost 5 months. We have tested Microsoft .Net Framework 2.0 Beta 2 and the probl...more >>

I require a report (in Excel) using data stored in Excel whcih uses the PIVOT/TRANSFORM SQL function. I've attempted this in ADO as unfortunately the Pivot Table function in Excel doesn't appear to be able to support my complex calculation (Sum(AVE)/Sum(Amt)) My connection string etc works...more >>

Hi, how can I get properties in ADO.Net? I read about it in the OleDB documentation (Chapter 14: properties) but I can not find out how to get them in .Net using an OleDBConnection. Any ideas? I searched "everywhere" but without success. Currently, I'm trying to get the information from the ...more >>

After restarting my SQl Server instance my ASP.net applicaions running on Windows 2000 are unable to connect to the SQL Server. My asp appplications are still able to connect The connection string I am using is user id=sa;pwd=????;data source=????;persist security info=False;initial ca...more >>

Deserializing SqlExceptions on Windows XP (SP2) originating from a Windows Server 2003 SP1 machine is problemetic. It may generate the following exception: Exception: System.Runtime.Serialization.SerializationException Message: Member name 'System.Data.SqlClient.SqlError server' not foun...more >>

i have a query containing inner joins....i use it to populate my truegrid. which better way of executing my query? make a view of it or make a stored procedure of it? im using a dataset and dataadapter to populate a datatable to be bind as the datasource of my truegrid. can you suggest a be...more >>

Hi Using Windows.Forms in ADO.NET in VB.NET 2003. I have 3 dataviews of the same datatable in a dataset, each a subset of the datatable by means of rowfilter. for example: Me.dv1 = New DataView(myDataTable) Me.cm1 = Me.BindingContext(Me.dv1) Me.dv1.RowFilter = "Actions LIKE '%(1)%' AND ...more >>

Hi, I have 2 Datasets with 20 tables. Ones called Surveys and the other SingleSurveys. Surveys contains ALL survey data (IE SurveyID = 1,2,3,4,5......). All tables have related ID field (IE SurveyID on each table) I need to copy over to SingleSurveys only one survey data (IE SurveyID ...more >>

Hi ! I have problem to extract data from a DB when there is a filed "Varchar" with more or equal to 1000chars ! I don't understand why ! I add parameters like: prmOleDb = New OleDbParameter() prmOleDb.Direction = oParam.Direction ...more >>

Hi All Using VB.net 2003 and ADO.Net with MS Access 2003 database I want to retrieve records grouped by time, but grouped within 1/2 hour increments The program is for a gym membership and I display graphs of the number of sign-ins by members over the day The gym uses this info to rost...more >>

I am trying to create a dataset with multiple records that hold identical data by merging a dataset with itself. I don't think this will work and I am looking for other solutions. For example, a dataset has a parent table called CATEGORY and a child table called ITEMS. There is a primary ke...more >>

I'm developeing a small app based on the Visual Studio Beta 2 and the DataGridView. I'm trying to add a new row to a datatable programmatically and I keep getting a strange error about not being able to use the '=' operator between a System.DateTime and System.Double. I do not have a double ...more >>

The date in my application is in mm/dd/yyyy format which i use in query to access data from a mini system on network having data in yyyy/mm/dd format.How can i change my date into yyyy/mm/dd format in query to get the result.Or tell me any other solution other than changing the Date Format of my...more >>

im updating a header and detail table with an update constraint. sqlcmd1 is used to update header, sqlcmd2 is for detail. both cmd runs in one sqltransaction. my problem is my second sqlcmd catches a constraint error when updating the detail table. is it because my record in the header table ...more >>

Hi There I am having trouble with the DataRowView.RowFilter I am giving subscribers to an asp.NET application the ability to search through a large group of historical records based on a "Subject" field. They have a textbox (txtSubjectCriteria) within which they enter search criteria an...more >>

Hi, I have a little application coded with .net 1.1, my problem is that this application worked fine in W2000. But the client change to XP, and from that get this error. This problem show when try to read from a table of Access XP. Anybody knows why this happen now and not with W2000 ??? T...more >>

I have a vb.net program that runs summary commands on columns of a data table. So eg I have a couple of lines of code: MyValue= DataTable.compute(computestring, Nothing) where eg computestring="MAX(" & columnname & ")" Occasionally it happens that the column is full of DBNull.Value val...more >>

Hi. Does anybody know how to perform complex calculations using the DataColumn.Expression property? Specifically, I'm trying to calculate the difference between a DateTime column and the current date: DateTime.Now.Subtract(certainDate).TotalDays Is there a way to integrate custom functions...more >>

Hi, Can anyone please point me to a definitive mapping of SQL Server 2000 datatypes to C# datatypes? I'm currently using the mapping below, but I'm sure some aren't correct... BigInt, int Binary, object Bit, bool Char, string DateTime, DateTime Decimal, decimal Float, float ??? ...more >>

Hello, I have following problem. I have dataSet with two tables, containing data about some people and a relation describing connections between these people: People: Id Name Contacts: Id IdFriend This is many - to - many relation, every person can have many friends and every person...more >>

I am trying to update a backend Access DB once a user make a change in the datagrid as follows: private void dgrdResource_CurrentCellChanged(object sender, System.EventArgs e) { int curColumn = dgrdResource.CurrentCell.ColumnNumber; int curRowIndex = dgrdResource.CurrentCell.RowNumber; s...more >>

I'm getting this error message when I run the code snipped below: {"ORA-06550: line 1, column 18:\nPLS-00306: wrong number or types of arguments in call to 'TEST'\nORA-06550: line 1, column 7:\nPL/SQL: Statement ignored\n" } The stored procedure contains a function: FUNCTION test ( pPerio...more >>

Hello, I am displaying one row in a datagrid, and i made its height larger than the datagrid height because it contains long descriptions, so a vertical scroll bar appears but with no cursor on it to let me move down the grid. How can i have access to the datagrid scrollbar? or what else ca...more >>

Hello, If i execute the code below, i change the row height of my datagrid to be able to display datatable1. But then i want to display datatable2 in the datagrid using the default row heights. How do i switch back to the default datagrid row heights? thank you. Code: cy is the row...more >>

Trying to return a value on INSERT using ASP.NET with System.Data.OracleClient. Errors on Execute statement. From other articles I have tried using variable name like :p1 and also tried wrapping in anonymous block BEGIN...;END; Dim sSQL As String Dim nOrderNumber As Integer Dim cmd As N...more >>

I have a program that is inserting one row into a table. When I get done with the update, the inserted row is in the DataTable twice, although it is only in the database once. For the reasons discussed in the summary, I am using the user-written method below to update the dataset, rather th...more >>

Hi, Environment = .NET 1.1, & ADO.NET, MS Sql I am trying to create a database and populate it with data. If there are no errors, then it works well. How ever, if there are any errors, I want to drop the database. To drop the database I use the sql command 'Drop Database MyDatabaseName'...more >>

Hi, Is there a way to make the standard PrintDialog to use visual styles on all it's tabs? I'm trying to make my application totally for XP visual styles. = P But the first tab is shown on standard visual style. = ( Thanks, Katty ...more >>

Why would this string of XML (when loaded into a DataSet) not produce a DataTable with 2 columns? I am getting a DataTable with just one column (ProductName). When I try to access the second column in the DataTable (ds.Tables(0).Columns(1)), I get "Cannot find column 1". By the way, there ...more >>

Hello all, I am wondering how to clear the connection pools from C# program, because my program everytime it runs , it needs 70 connections... so whenever my project fails i wanted to reset connection pools, or else after 3 to 4 runs, i am getting an error "The timeout period elapsed prior to ob...more >>

Is there a way to interrogate a database for expected Stored Procedure parameters without using OleDbCommandBuilder.DeriveParameters() ? Thanks. ...more >>

Hello All, I'm getting this error on a ASP .NET apps: Index 2 is not non-negative and below total rows count. Line 443: Line 444: Dim ParentTableView As New DataView(DsSellers1.Tables("SELLERS")) Line 445: Dim CurrentRowView As DataRowView = ParentTableView(Me.cboSellers...more >>

Dear all, I have exeecuting the following code : Dim m_Cmd As New OleDb.OleDbCommand(sSql, Con) Con.Open() Dim m_OldbReader As OleDb.OleDbDataReader m_OldbReader = m_Cmd.ExecuteReader(CommandBehavior.CloseConnection) Running this I have an OLDBException error saying : "No value given ...more >>

The title may not reflect what I exactly want to acheive, but what I want to do ultimately is to map columns between 2 data tables. One already has data and the other has schema but no data. And I want to transfer the data to the empty one(Of course, those two datatable has different column name...more >>

Hi Trying to sort out how to implement the use of connection strings with our new .Net Data Acces Layer(DAL). 2 solutions have been propoesed. Both suggest storing the connecion string in the machine.config file. The DAL uses SQLCleint namespace. At this stage there is only one SQL data store(...more >>

Hello. I have two tables in a dataset which have both been updated, i am aware that i cannot use the commandbuilder to update tow tables with a join, and i obviously get referential integrity errors when i try to update them one at a time. I am aware i need to roll my own update routine: has ...more >>

Hello, I have a problem with parameters in OleDbCommand in Access 2000 database. For example this code works and updates the row: OleDbCommand comm = new OleDbCommand("UPDATE DataTable SET ContactID = 'Marcin', Test = 'just a test' WHERE RowID = @RowID ;", this.databaseConnection); comm...more >>

Hi, to concat two columns in Access I can use + or &. If I use + the NULL pushes through, so I want to use &. Example: SELECT Firstname & ' ' & Lastname AS Name ... Problem: The OleDbCommand object doesn't accepts & in a SQL statement, only + is allowed. But now I get empty data if Fir...more >>

Hello, I have a problem with my application. I use c# to connect to an sql server. I noticed that after the first connection, my server keeps at least one connection always opened although I close all my connections in finnaly block Thanks ...more >>

Does anybody know how to get the actual number or rows returned when using the StartRecord and MaxRecords parameters with the SQLDataAdapter.Fill()? Since the whole resultset is returned from SQL Server it would be nice to access this information. And appending SELECT @@ROWCOUNT to the origin...more >>

I created strongly typed dataset objects by configuring data adapters using the VS.2003 wizard. All the tables have primary keys; some have multi-column primary keys. Some of the tables have FindBy... methods, such as FindByValue_name (where Value_name is the name of the primary key field), o...more >>

I have a typed dataset with three tables, one master and to child. This is a contact management app, so I pull all of an organization contacts and associated details into the set. (Anywhere from 1 to 100 contacts and their associated detail). My form is bound to the dataset using VS2003 form d...more >>

I have been using .NET for three years. We are currently using VS .NET 2003 and SQL Server 2000. Whenever I have needed to update data I normally created a SqlCommand object, assigned it the appropriate string (depending upon whether it is a stored procedure or not) and executed it. However...more >>

If you try to create a typed dataset with a table named Locale, the dataset generator fails to create a unique name (like by using an underscore) and instead gives you the following compile-time error: Property or indexer 'xxx.Locale' cannot be assigned to -- it is read only You can resolve t...more >>

Hi Friends, I want to open and read a pdf file from disk And save this content of pdf file into .txt file. In short I want to convert content of pdf into .txt formate and save this text file on desk. Thanks. Alex. ...more >>

Hey there, I've been looking around for awhile now on how to do this and haven't been able to really find a clear answer. I have a stored procedure that inserts a new entry into a SQL 2000 table. The Stored Procedure(SP) accepts an ID that has been declared as a UNIQUEIDENTIFIER in the SP,...more >>

Is it possible to insert a datacolumn into an existing datatable at a particular location? Example, I've got a datatable with 4 columns. I want to add another column at index 0. I'd end up with 5 columns, columns(0) would be my new datacolumn. Thanks, Todd ...more >>

Hello all, I need something in VB.NET that monitor changes in a database (any DB or even an XML file or something). I can make something that checks every 5 seconds, but maybe there is a better solution like an event is fired from ado.net. I do not have to make changes or something, but nee...more >>

Hello, I want to display a single row in a datagrid. but this row has 28 attributes and some of them are brief descriptions(2 to 3 lines). To display data nicely i want my grid to enlarge in height and not in width, so columns have a constant width where the title fits in and cells of the r...more >>

Hello, I have a problem with calling INSERT command. It throws everytime a SQL exception, even though the syntax is proper. At the begining I've tried using OleDbCommand, and it worked for 2 tables, but it doesn't work for third final one. These are really easy tables, so I'm really shocked...more >>

Hi, How can I detect all SQL Server, and show all server name in a combo box in vb.net ? Thank you very much Regards ...more >>