Is it possible somehow to get a DataView from a DataSet that can get distict rows from the DataSet? -- ----------------------------------- Ken Varn Senior Software Engineer Diebold Inc. EmailID = varnk Domain = Diebold.com ----------------------------------- ...more >>

For no apparent reason, simple select queries are returning what look to be Chinese characters. At first, everything looks fine (correct & english), until you get halfway through the result set. At that point, all results are unreadable. This problem is consistent, but unpredictable. ie. same ...more >>

I'm trying to write a page in vb.net/asp.net using an ODBC connection. Using server explorer I can get to my connection. When I attempt to connect through my code in a web browser I get the following error: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no d...more >>

I am commiting changes to several existing records which have been changed using a DataSet. In my table I have a field called "rank", which has a unique constraint on it. The first record has a rank of 1, the second a rank of 2. My update causes the two ranks to reverse so that the first recor...more >>

I have 2 listbox binded to 2 datasource, one for the granted Roles & the other to display all roles.. i set the DisplayMember to "RoleName" & valueMemeber to "RoleID". I have 2 button to copy between 2 listbox.. how could i move the item from one to another and update datasource??? listbox1...more >>

We have this issue on one of our pages and we can not figure out what is happning. This sp (SQL2000) runs in less than a second on SQL. However, once app is deployed problems are happening. I also tried to connect to same database that deployed app is pointing to from my local development a...more >>

I have a function with the following code, I have written this function with the example provided in the documentation provided with OracleClient. The called stored procedure functions perfectly, I have tested it manually with success, but when I try to use the function, I get the error "Obje...more >>

Hi I would like to know if we can call a Dot Net web service from Oracle 9i Stored Procedure. If Yes, how can one do it? Regards, Prashant....more >>

In my windows application i use adapter which mean each user control i load have to open and close connection and this make my application pretty slow.. I'm trying to create singleton Connection Component which can be accessed visually and not set every Sqlcommand in adapter throught code.. ...more >>

Hi All, I have a "lovely" access database as my datasource. The table 4 columns (of data types Number, Date/Time, Text, Text) and a number column is the primary key. I am using the command builder in ODBC objects to generate the INSERT, UPDATE and DELETE commands. The INSERT command gen...more >>

Hello: Is there any way in the new ado.net 2.0 to create a connection string using a dialog from the application? It was possible using the classic ado objects. Is there some similar thing here? Thanks. ...more >>

Hello Everyone, I have a Dataset with 3 tables in it. I use DataSet.WriteXML(path, WriteXmlSchema) to save the dataset and its schema as a file, which executes correctly, but in addition to the main file 'WriteXml' create a .xsd file, containing description of the namespace and 2 of the att...more >>

Hi ! At first, sorry by my bad english ... I need to develop a windows form app. This application must be as agnostic (in database terms) as possible. The application must run against SQL Server 2000, Oracle and/or DB2. I need to implement some kind of paging due to that several queries ma...more >>

I'm reading schema into dataset. Schema has a table definition and a few constraint definitions. The problem is that when I write xml schema back, it doesn't have any constrain definition, but only table definition. It looks like when ReadXmlSchema happens it didn't get constrain definition. ...more >>

I think you should be able to call stored procedures like you do any other method. Maybe using the proxy stub pattern like you do for web services would work. This would allow type safe compile time checking and save programmers a lot of redudant work. ...more >>

I have a textbox on my Winform that is data bound to a floating-point element. It's displaying the number out to like 9 digits. Since I'm not "handing" the textbox the value using ".ToString("f3")" I'm at a loss for how to control the formatting. Is there a simple way to accomplish this? ...more >>

Hello, I have a dataview which contains 10,000 rows and I have to apply a huge rowfilter string which contains values for two columns each containing some 10,000 values, So its like dv.RowFilter = "A IN (1,2,.....) AND B IN (0.12,0.34,....)" Any solution please? Regards, Rohit ...more >>

I have a datatable that I'm displaying in a Winform Datagrid via a DataView, and I want the user to be able to right-click on any of the rows and select a "copy row" command from a context menu. Then I need to make the copy happen. I've got the context menu up and responding appropriately,...more >>

Hi, How can I use OracleCommand.ExecuteScalar method to have the value returned from a PLSQL stored procedure? I think there are some techniques with PLSQL code that I am missing. Thank you, Alan ...more >>

I noticed when using the WriteXml method that it doesn't include expression columns. Is there some way to get these written too? Thanks, Joe ...more >>

Hi everyone, I have a C# application that is using SqlDataAdapter and SqlCommandBuilder for performing updates to a single table in a SQL 7 database. For the most part, everything works just fine. I recently hit a very strange issue, where it seems that not all columns are being updated aga...more >>

I'm working on upgrading a VB3 app that reads a text file line by line, and executes inserts or updates to an Access database. Because of speed issues, I recently moved from using OleDb objects and an Access database to a SQL Server database, and using SQLCommands and SQLParameters to insert an...more >>

I decided to try using relations and untyped datasets for syncing a datagrid (child records)with a combobox (parent rows). Also put in stuff I thought I needed to set up dataviews for filtering. Now the ds won't load objects (tables) it seems like. I took out the tablemappings and schema actions ...more >>

Folks, Loads of O/R Mappers out there - trouble is, most of them only support dynamically created SQL queries. For various reasons, I CANNOT use queries directly, but I need to use pre-existing stored procs to retrieve, insert, update and delete data from our SQL Server 2000 databases. Any...more >>

Hi all, I'm building a data mapper class where each property of the class maps a column in the database (guess this is formally called by Fowler in PoEAA a Data Mapper or an Active Record pattern). Ok the problem is I have several columns in the User table which have Foreign Key constraints...more >>

What is the best way to do this? I have access to a readonly sql database with information about people - first, last, address & social security number, etc and I want to display this information in a vb.net datagrid. That part I have down and I use a dataadapter to populate my dataset, etc etc...more >>

Hi, I'm using DbConnection.GetSchema(DbMetaDataCollectionNames.DataSourceInformation) to get information from the current data provider. I would like to generate appropriate parameter names for the current database. This code will be used with multiple databases (some unknown at this time)...more >>

Hi guys! I've bound some TextBoxes with a DataSet in my code. Now I'm in doubt about how to handle empty values as DBNull.Value. If I erase all textbox's content and call DataAdpater.Update, the system commit in my SQL Server an empty value. Could you give some tips to commit those values...more >>

Hello, First of all, sorry because of my poor english. I am having a weird problem that I don=B4t know how to solve. I am not sure even if it is a problem within the OS or the .NET Framework. The platform is a Tablet PC device running XP. AFAIK it has installed .NET 1=2E1 SP 1. Depending...more >>

We are developing a .net database driven application. The application is already quite complex and uses at time aprox. 150 data tables stored in the MSSQL 2000 database server. Our application has multiple modules. Some customers already use some modules while we currently developing more mo...more >>

Hello I'm trying to compare two strings: 1. retrieved from custom xmlplaceholder (Microsoft CMS): zrodlo = fact.Placeholders["kategoria2"] as XmlPlaceholder; esc_kat2 = Server.HtmlEncode(zrodlo.XmlAsString); esc_kat2 = esc_kat2.Replace("<",""); esc_kat2 = esc_kat2.Replace(">...more >>

Hi, I create a small Employee Application with VB.NET. I have used MS Access 2003 as database. I want to access to MS Access 2003 via remote connection but I don't know how to build the remote connection to database. I have small server that has an IP address 193.168.0.10. Than I have 3 PC...more >>

Hi, I've got a problem with displaying texts with turkish characters. There is a website administration system, which is developed using ASP (VBScript) and ADO. This system is being used for inserting product informations in to a ms-sql database. There is another webbased application, w...more >>

Dear All, I would like to know the best practice to insert or update multiple DataSet or DataTable into SQL database by using begintrans. I think DataAdapter.Update method does not support BeginTransaction method to update more than one DataSet within one SqlConnection. Will it be perfo...more >>

I am trying to figure out what the internal mechanism is where a dataadapter's update method tells whether to execute the updatecommand vs the insertcommand. I have a datatable that has a new row in it that I've created and when I do the update on it, it is trying to shoot out a sql update co...more >>

Hi, The sql returns value since i select primary key (cannot be null), but when i try to bind with combo box i get following error.. i cant see data. Iam using ODBC connection from asp.net to talk to DB2 database. Any help gurus System.Data.Odbc.OdbcException: NO_DATA - no error informatio...more >>

Hi there, not sure what't the difference between these two. How to configurate these setting for long-run sql. Need help. Thanks ...more >>

This is just bugging me... We store our database on SQL Server 2000 with service pack 4 installed on it. When a user is using the app we developed, if they are a local admin it works perfectly fine... If they are not a local admin, the app throws an exception with the message "Table does not h...more >>

I've the following scenario, a web page that dispaly a GridView using SqlDataSource define thus: <asp:SqlDataSource ID="BoardTypes" runat="server" ConnectionString='<%$ ConnectionStrings:ConnectionString %>' SelectCommand="SELECT BoardTypes.BoardTypeId, BoardTypes.BoardTypeName, BoardTypes....more >>

I've the following scenario, a web page that dispaly a GridView using SqlDataSource define thus: <asp:SqlDataSource ID="BoardTypes" runat="server" ConnectionString='<%$ ConnectionStrings:ConnectionString %>' SelectCommand="SELECT BoardTypes.BoardTypeId, BoardTypes.BoardTypeName, BoardTypes....more >>

Hi , I would like to know when does DBConcurrencyException exactly occur. What i want is to catch data concurrecy conflicts in a multi user environment. I know how to do it in classic ADO by using UpdateBatch method which throws a Hresult = DB_E_CONCURRENCYVIOLATION.After this you can set...more >>

Hi all, I have an asp.net application that is going to be hit by a lot of users and we want to minimize the # of database connection opens and closes. Here's what I'm thinking I can do. I want to declare a connection object in the global.asax file as public shared and open it once (in the ...more >>

Hi All, I have the following code: SqlCommand sqlCmd = new SqlCommand(sqlStatment, dbConn); sqlCmd.Parameters.AddWithValue("@Name", name); sqlCmd.Parameters.AddWithValue("@Surname", surname); If surname is NULL I get the following error message: Parameterized Query xyz expects paramete...more >>

Im using the following code to sort columns in a data set: ds.Tables[0].DefaultView.Sort However, datetime fields pulled from the database are sorted as strings and thus incorrectly. How do I sort the datetime fields properly? Thanks. ...more >>

Hi How is vs 2005 rc compared to beta2, stability wise? Is it worth moving from beta2 to rc or should I wait for final? I just want to start developing a stable (enough) db app as soon as possible. Thanks Regards ...more >>

requirment: scaling out data access to increase overall system capacity while decreasing individual request execution time, without server clusters <-- is that possible?? a bit trade off in idv. request execution time is acceptable if the whole system would scale. expensive server cluster ...more >>

In my C# project.. I have Sql Database with data of 700 MB... I'm redesign tables and relations and need to retrieve my data in the new tables.. I'm using SqlAdapter to Get old tables in my dataset then use the GetChildRows()... insert new records in the new tables. Here is the code which ...more >>

In MS ADO.NET Core Reference by David Sceppa, he mentioned that we need to call the Merge() method of the original DataSet with a parameter which is the Changes-Only DataSet after the update to make sure that the original DataSet understand that we already submitted these records to the data...more >>

Here is the task that I wanna achieve. I have 2 tables with a parent-child relationship in a dataset. Let's say the tables are orders orderdetails. I try to use DataViewManager in a datagrid so that I can navigate between them. Here is some special requirments: when the user is in orders,...more >>

I have been programming for one year in .NET and using ADO.Net, i've used several techniques to develop my data access layer in my applications, but i've found that none of these has been appropiate. My question is there any place where i can find a model to follow in my data access layer de...more >>

i have an aspx form in wich i have a textbox. i have a validation function on this textbox in wich i want to set the focus back to this text box if validation returned false the syntax is : document.getElementById("MyTextBoxName").setfocus; But the focus is always going to the next control...more >>

I might be having a dumb moment but ..... I have an excel vba app with a worksheet (Sheet1) containing a QueryTable to a remote MSAccess database I wish to use VBA to programatically refresh this data every so often (say 5 minutes) and then to locally analyze the data at the client side so...more >>

Hi there, Currently my web service is limited to 256 characters, I would like to make this longer. Should I make the field of Memo type and only use POST to pass the data to the web service? Are there any concerns I need to be aware of before allowing lengthy fields? Thanks loa...more >>

I don't understand this error. This form was working, and I decided I wanted to put a datagrid to show child records of contacts at companies. But I can't get the dgrid to work. THEN my sql string began having this weird invalidcast problem. I am NOT trying to cast, and the datatype I am sending ...more >>

I get HINTS from the documentation that I should be able to use these with ADO.NET as if they were stored procedures, but haven't found any clear guidance so far on actually how to go about doing that. There seem to be some differences between the way you do it for Access vs. how you do it for...more >>

Okay, I have been at this for 2-3 days now and all over the internet. I have found many people with near identical to similar issues and no solutions. I am fairly certain about what is not the problem and strong suspicion of what is. What I need now is a solution. I have a fairly comp...more >>

Greetings, all. I'm looking at some of the existing ORM tools to see if they might help me create a reusable solution to this problem. I want to be able to copy a record and all of its foreign key related records from one physical DB to another, but I also need to be able to modify the IDs of ...more >>

Hello, I'm using a SqlDataReader to return results from a stored procedure where I cursor through rows to flatten out my data. For example, instead of returning all Customers and then all Orders, I return a consolidated result set, with columns named like this: Customer1_OrderName, Cust...more >>

Hi everybody This is my code Public Function UpdateData(ByVal MyDataSet As DataSet) As Boolean Dim ODBC_Adapter As OdbcDataAdapter ODBC_Adapter = New OdbcDataAdapter(Me.ODBC_SelectCommand, ODBC_Connection) ' ODBC_Adapter.SelectCommand.Connection = Me.ODBC_Connection ' ODBC_Adapter....more >>

We are developing an asp.net web application. When we drag and drop the sql connection object to the form we set the in the dynamic properties connection string to use the connection string in the web.config file. Works Great except everytime we need drag and drop a new data adapter on the fo...more >>

Hi, Can somebody tell me where can I find in the msdn site info about database design patterns when working with C# and SQL 2k Thanks Jose Luis...more >>

Hi, I need to select some rows from a dbf file and do some processesing for each one. After processing each row, I need to update some field on it. There is no column or combination of columns that can be used as row identifier. Can this be done in ado.net ? How ? Regards...more >>

Hello, I have a pretty difficult question about a hard-to-explain issue (I hope my English would be good enough to make you understand). The environment beside the problem itself may also be important, so I'm gonna explain a little the whole idea and then go back to the issue and my questio...more >>

I'm used to work with SQL Server. Now I have to connect to Oracle, and it went all well so far, but... We have a table with a field containing the euro-sign (charactercode 128 from codepage 1252). If we retrieve the value of this field using MSDAORA.1, the result is correct. It also works fin...more >>

I have an ASP page that has an aspx page within an iFram on this asp page. Once the user has filled in the form (within the aspx page) I need to redirect the user back to the orginating page (an asp page) within the iframe. Can anyone help me with this. ...more >>

I currently have 3 servers, a dev server running Server 1 ..Net framework version 1.1 Win 2k3 standard edtion CMS 2002 Server 2 ..Net framework version 1.1 Win 2k3 standard edtion CMS 2002 Server 3 ..Net framework version 1.1 Win 2k3 standard edtion SP1 CMS 2002 On it i'm runn...more >>

and Close() it too? Thanks ...more >>

Hi all, is it possible to insert a expression column into DataTable.Columns? I do not want to add to the end of the position of the DataTable.Columns. Any advise will be appreciated. Jimmy ...more >>

Hello: VB.NET 2003 Windows App SQL 2k Backend Typed DataSet I have a bound TextBox to a Money column in SQL Server 2k. When the dataset loads, it shows 4 decimals. The data type in the schema designer is Decimal. I realy don't care which type I use but I realy do need it to show 2 d...more >>