I have been trying to get DataAdapter.Update(DataSet) to update a SQL Server database. I have not been getting any errors but there is no records in the database when I check Enterprise Manager. Could someone please help! *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hello, It is possible to configure query analyser to output the result of a query to a file. The problem is that the file is saved with with unicode chars. I want my file to be ANSI . How can i do this? Many thanks in advance JJ ...more >>

Hi, this might be a stupid question... I've created a typed DataSet containing two tables and a ForeignKeyConstraint. Now I want to Fill that DataSet from database using a SELECT command retrieving rows for both tables. However, when I use SqlDataAdapter.Fill() none or only the first tabl...more >>

I'm writing code that provides generic view(vendor independent) to the client about table list, primary key or view. Almost all connections are made via vendor's .NET provider. I researched and found that OleDbConnection.GetOleDbSchemaTable() can make it. But I only make connection via .NET pr...more >>

I have a access database with one table, which two columns. The columns are name which is text, and present which is a boolean. I create a new windows application, and include the table using wizard. I then drop the table onto my main form. VB creates a tableadapter, bindingsource, datagri...more >>

Used the function below as part of creating access mdb in DN 1.1 (VS2003) In VS2005 it provides a "Warning: Return type of function 'GFO_CatSet' is not CLS-compliant." Suggestions? (This project has to stick with Access mdb) Public Function GFO_CatSet( ByVal sPathDbName As String) As A...more >>

Hi, I'm returning rows from a search done using a sp & one input parameter. Therefore I am using a command to return the result set. These need to go into a dataset in order for it to be bound to a data grid. I received two ways to do it from this discussion group but neither work for me. The...more >>

I am new to .Net. I have three master tables which has many to many relations. I need to create a data grid view in windows form application.(Windows application now web). I am little bit confused how can I create a data set and grid that will let me inser a new relation ship and using the data ...more >>

I want to copy my local database to a remote server hosted by a thrid party company. I started by creating all the tables using creation scripts made by SSMS. Then I connected to the target database, and used Tasks, Import to copy my local data to the remote database. I made sure to select the I...more >>

I want to programmatically call a query, which is inside the Access Database. Either in C# or VB.NET. I dont' watn to write the query in the code. Rather would call a query inside the access db. Thanks ...more >>

I am using strongly typed datasets in ADO.NET 2.0. How can I override the connectionstring? ...more >>

Baiscally I have Nvar data in a database and I want to populate a datgridview in french. I understand the basics of globalization and have done a bit but not on the data level. Can anyone point me to the right resources to start understanding this concept of language translation of data....more >>

Hooking To SQL Server 2005 on Itanium 64, What MDAC and providers do I need My applications will run all on a 32 bit Windows Server 2003 machine? thanks ...more >>

Hello there, I have DataGrid with some records and I would like to edit it right in the datagrid using the built in commands. I can't figure out a way to pass to the SQL query the record ID which I'm editing. SELECT: SelectCommand="SELECT ProviderID, AddressID, Address, Address2, City, Stat...more >>

Hi all, I have problems with CommandBuilder in NET Framework 2.0. I am trying to update a table in Informix IDS 9.40 (client SDK 2.90 TC4, the last one) using a dataadapter and a commandbuilder (vb.net). In NET Framework 1.1 my code works OK, but now I am migrating to Visual Studio 2005 a...more >>

Hello, I am trying to connect to a visual fox pro table from my asp.net page. I dragged an odbc connection and set it to a visual fox pro driver file dsn pointing to "mydocuments" folder. Here is the connection string SourceDB=3Dc:\Documents and Settings\bgunay\My Documents;P...more >>

Hi All, We are having a web application. When we call our application first time, it takes lots of time and afterwords it takes less time. I am clear about the concept how .aspx page is called in .net framework first time. It generates page level dll and then gives output to the user. Is...more >>

Hi, I have an open and active sqlDataReader object and would like to determine which of the fields is the PrimaryKey (if present). I intend to use this to create generic DataTable objects in a library by passing in a sqlDataReader object, and the library returns a DataTable object from the ...more >>

Hi I'm trying to make a component to manage database access. One task of this component is to create a database if it does not exist. To minimize queries's count, I want to do database creation when DataAdapter.Fill fails (and if the database doesn't exist). So I wrote the following code :...more >>

Hello, I have a Contacts DataGridView that is bound to the TblContactsBindingSource. The Grid contains a list of contacts including the contacts name (Column 2 or "ContactName") I would like to get the value of the current "ContactName". What is the easiest way to do this? Thanks in...more >>

Hi I have 1 web service posting data to a SQL server 2000 database and a separate ASP.NET web site reading data from the same database. Both use the same SQL user and password to connect to SQL. The web service is windows authenticated for a single user and has impersonate set to true. (It ...more >>

Hi, I have a datagrid on a WinForm which I need to poulate with a search result set. The search is done with a parameter to a sp so I'm guessing the data grid can't be bound to a design time Dataset. I have no idea where to start with this. I have created a datareader which holds all the...more >>

I'm caught in a Catch-22 position with a fairly basic ADO.Net problem. I have bound a data adapter called "DateTableDataAdapter" to a simple Microsoft Access table called "DateTable" with a couple of datetime columns, a memo column called Synopsis, a text column called Title with unique values...more >>

I have this comma delimited text file. I want to convert it in one sweep to an access DB (mdb) format. I used the following code but it takes forever to convert. Is there a faster way? string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strAppPath + "\\mydb.mdb"; OleDbConnecti...more >>

how to displays the procedures currently running at startup on sql sql server 2000 ? *** Sent via Developersdex http://www.developersdex.com ***...more >>

I would like to use strongly typed datasets (I think), but find the following limitation; When configuring the Dataadpter with the wizard (VS2003) a connection object is generated for me. I want to use a connection object based on a string in the App.Config file, but when I attempt to do this ...more >>

I have an old and proven stored procedure that takes on average 0.2 seconds to execute. I always develop and perfom all measurements using VS .NET debug configuration. This SP has always performed the same being called from Query Analyzer, Enterprize manager or VB.NET code. Recently I've d...more >>

Hi Gurus, Is it ok to install both SQL 2000 and SQL 2005 on the same system without any problem. We just want to have some ideas before implementing it. Thanks for any help you can provide. Dan ...more >>

D'oh! I'm feeling this is related to ADO.NET and maybe you can help here. Please, don't hide behind "Microsofties don't know pascal" because this is a very framework issue rather than Delphi. This is the code: procedure TFaqService.AddItem(Q,A : String); var OleDBParam : OleDBParameter; ...more >>

Hi, I'm using a SP with one input parameter to return query results to a Datareader. I then want to add the rows in the data reader into a data grid. Can you 'bind' a datareader to a data grid? If not, how would do it? The data grid will be read only. What is the best approach for this? ...more >>

I'm confused ... I've read in a number of places that in VS2005, ADO.NET contains Oracle specific classes under the System.Data namespace (actually this was supposed to be available for the v1.1 framework). But I don't see the Oracle stuff in the Object Browser. I see: System.Data.Common...more >>

Hi everybody! I've stumbled across a funny behaviour of a typed dataset in a new application of mine. Some how the generated code gives me a Invalid Cast Exception. I've reproduced the behaviour as follows. I've created a database "test160106", I've created the table "Parent" with two ...more >>

Hi everyone, Quick question, I'm creating a Timesheet Application with ASP.NET C# in Visual Studio 2003. The database has been built using MSDE. I have followed the MSDN libraries guide to creating forms based authentication from http://msdn.microsoft.com/library/default.asp?url=/library/en...more >>

Hi all, I have some questions in regard to ASP.net and ADO.net. Is it resource extensive, to open a connection in Session_Start method in global.asax [and close when session stops] or to open connection whenever I need it? I intend to open 2 db connection to 2 sql servers. Cheers ...more >>

Hello. I'm doing a WebService using ASP.NET with an Access database. Nothing really fancy, I just want to try and see what I can get to. Using an Access database(no please, don't tell me that MS is pushing towards MSDE, since I'm going to have a hoster so no luck with it). I'm trying to u...more >>

All, I created dynamically part of a table and its components such as text boxes etc... As you can see in the example below I created txtAddress textbox... Everything works perfectly until the point where I need to save the textbox input (normally I would use txtAddress.Text). But in my btnC...more >>

Hi guys, I created DataGrid with few checkboxes. I want to bind the checkboxes and check them if they match a string in a database. An if statement would look something like this: if (dataRowChb["AddressTypeCode"].ToString() == "u") checkbox1.checked = true Now how would I do it in datagri...more >>

The DataTable WriteXml produces different xml based on whether the table is part of a dataset or not. This means that anybody consuming the xml has to read it differently because it ends up with different root nodes based on the circumstances. Is there a way to prevent this? This is VERY an...more >>

Hi, As a relative newbie to SQL Server/ASP.NET I'm hoping someone here can help with my problem. I'm developing a timesheet application in ASP.NET C# using Visual Studio 2003 with a database built in MSDE. One of my forms needs to return a simple list of resources from my database. I have fol...more >>

Is there any way to determine the cause of an OleDbException? For instance. for "No value given for one or more required parameters." is there a way to determine which parameter is missing? Or for the "Data type mismatch in criteria expression", to determine which parameter is causing the pro...more >>

say i have a dataset called dv and i have a boolean value i want to filter by "b_DoesWork" while the column name in the data view that i want to filter on is called "Works" how would i filter this since the rowfilter is a string? i tried dv.rowfilter = "Works = " & b_DoesWork and get e...more >>

Let me say preemptively I've read up on this and searched postings here and haven't found an answer. Connection pooling doesn't provide a way to close all connections in the pool, short of exiting the process. This seems to me to be a designed-in leak. I can think of a few scenarios where ...more >>

Hello, .... Dim DA As SqlDataAdapter, DS As DataSet, curPos As Integer Dim cmdSel, cmdIns, cmdDel As SqlCommand .... DA = New SqlDataAdapter() .... -----------------------this part works fine-------------------- conn1.Open() strSqlDel = "Delete From tbl1 Where rowID = 10" cmdDel = New SqlC...more >>

Does anyone have experience creating a formula generator and storing the formula in a database for re-use? I want to give my end user the ability to create custom formulas. The end user would create the formulas in a grid selecting fields and controls to use in the formulas. The problem I am ...more >>

Hi, I am using VS2003. When using the design enviroment to create a data Adapter wth a single table, no problems but... I used a data adapter to join three 1 to 1 tables. First thing I noticed is that it immediately cross joins all the tables(?) . I had to manually create the joins w...more >>

I have 2 forms Form1 has a datagrid with read-only data. Form 2 is for editing/inserting/deleting the data on Form 1. It shows many of the same fields that are on Form 1, but via a different Proc and dataset than on Form 1 (so I think this excludes the currency manager). This arrangement i...more >>

I have a stored procedure that I pass some XML in as a parameter. I am using the OracleCommand object and when I execute the ExecuteReader method I get the following error: Internal .Net Framework Data Provider error 30. Stack trace: at System.Data.ProviderBase.DbBuffer.Validate(Int32...more >>

Having worked through an example (I'm novice status), it seems that this is less efficient than using hierarchical recordsets in normal ADO. Can one still use hierarchical recordsets (using the SHAPE command) in ADO.NET? ...more >>

Two questions relating to this: 1 - Do I require SQL Server 2005 or can this work with SQL Server 2000? 2 - My ASP.NET book says that I require MDAC 9.0. My registry setting says that I'm using 2.8 but I can't find where I can download an update from. Thanks if you can help with either of ...more >>

I am in the process of writing an ADO.NET 2.0 Data Provider but I'm finding the lack of documentation is making the process rather slow. Can anyone suggest any sources of information? Thanks, Mark ...more >>

Data: A line (row) containing multiple fields (columns) Requirement: 1: Allow new lines to be inserted at any point 2: Allow deletion of any line 3: Keep the lines in the correct order Examples: When given a table with three lines: Line 1 Line 2 Line 3 1: An insert after Lin...more >>

I am using a DataSet generated using VS2003 .xsd files direct from db tables. I then add some DataRelations to the DataSet programatically. I am running into the following problem: any time I call GetChildRows() using a particular DataRelation the parent column becomes ReadOnly. All subse...more >>

Hi I am currently working on a portal for an online university. The portal allows students, teachers, and administrators to access information, and perform certain tasks based on roles. We are currently developping tools for managing quizzes, assignments, news. What I realize if we have man...more >>

Newbie Warning! There, out with the full disclosure. I have a datatable with a variable "CreationDate" of type TimeStamp. I'm trying to learning Data Binding, when I drag the table onto my Windows Form (2.0) and try to compile, I get an error about incompatible type conversions. What...more >>

Hi, I have an SP that inserts some data including an ntext field for large strings (4 M chars) When executed, ExecuteNonQuery returns -1, but the insertion occurs with all but the ntext field populated correctly, the ntext field is blank. The string is an xml fragment. Any ideas? R...more >>

Dear all, I want to create a crystal report like the following format, but don't know how to do this Date Expenditure 01-Jan 1832 02-Jan 39933 ..... 31-Jan 35355 Total:252353 (this is not repeated items!!) 01-Feb ...more >>

hi. im at wits end! my update command isnt working properly. im able to edit and delete data successfully with the same command builder, but when i add a new row and update, i get an "affected zero records" message. Dim cb2 As New OleDb.OleDbCommandBuilder(da2) dv.AllowNew =...more >>

What is the fastest method to filter a dataview? ...more >>

Hi there, I am getting this exception "Deleted row information cannot be accessed through the row" when trying to update a datatable with an adapter: mAdapter.Update(mTable); <== exception here After struggling with this for hours, I am now looking for a more generic answer, i.e., ...more >>

First of all, I apologize if I'm not posting this in the appropriate group. This is my first time using these Newsgroups, so I'm trying to find my way around. That said, this is my problem: I have a stored procedure I'm calling from Visual Studio 2005. The query works just fine in query analyz...more >>

Hi there, I have this method to search a DataView: public int FindIndex(string columnName, object key) { index = -1; foreach (DataRowView drv in table.DefaultView) { if (drv[columnName].Equals(key)) { index = i; break; } i++; } return in...more >>

I'm wanting to save and retreive text from a multiline textbox which I've been told can become extremely large and I'm not sure how this is to be done(c#). I'm guessing SqlServers Text type is ok and some kind of chunking of the lines in the textbox. Any pointers will be greatly appreciate...more >>

I receive the following error when trying to update a table after editing. System.InvalidOperationException was unhandled Message="Update requires a valid UpdateCommand when passed DataRow collection with modified rows." Source="System.Data" Here is the code: Private Sub SaveItem_Click...more >>

* Plateform: .Net 2.0 * Question: Is ado.net the solution? If so, what should I be looking into? * Data: schedule containing: 1 to n properties collection of lines line containing: 1 to n properties * Data Source: An engine that needs to take the saving of the data to keep a vers...more >>

Help: I am trying to use a datatable reader to loop through a datatable but I get the following error message when I try: System.InvalidOperationException was unhandled Message="DataTableReader is invalid for current DataTable 'CABG_Transfer_to_Raw'." Source="System.Data" This is th...more >>

We have an app under development processing data from com port events. There can be multiple com ports all sending data back to this one method on one instance of a class “ld”. This method gets a db object associated speciffically with THAT com port. The db objects wrap a datatable and ...more >>

Hi, I'm in the process of parameterising the SQL SELECT statements in my ASP.NET application so that I don't directly include user input in the SQL (to protect against SQL Injection attacks). I've run into a problem with a statement which has a CONTAINS clause, which seems to result from para...more >>

Is it possible to serialize an ADO.NET 1.0 dataset to xml and then to deserialize it back to an ADO.NET 2.0 dataset ? And visa versa ? Is this functionality supported for the Compact Framework also ? Best regards Kay-Christian Wessel ...more >>

hi, how do I get output parameters from sql 2005 query using the entlib 2,0? I noticed the dbcommandwrapper is not there anymore. thanks xisco ...more >>