| datatable select unusual syntax problem (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I'm trying to identify a col in sql that is empty when calling the select method of a datatable. For example: For Each irow In dsspship.Tables(0).Select("(qrange e qrange s) 0 and len(pubcode) 0") This doesn't work if a row's qrange e qrange s is greater than 0, I get the row, even though pubcode is empty. When I change it: For Each irow In dsspship.Tables(0).Select("(qrange e qrange s) 0 and len(... |
|
| earn easy money from home (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I found this on a bulletin board and decided to try it. A little while back, I was browsing through newsgroups and came across an article similar to this that said you could make thousands of dollars within weeks with only an initial investment of 6.00 So I thought, "Yeah right, this must be a scam", but like most of us, I was curious, so I kept reading. Anyway, it said that you send 1.00 to each ... |
|
| Connection Pool Problems (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, This is actually a question about ADO but in the context of the Microsoft Data Access Block. So, if I am posting this in the wrong place...excuse me in advance and someone point me in the right direction. Ever since upgrading to VSStudio.NET 2003, I keep getting these errors after executing a few of my transactions from within the IDE. Timeout expired. The timeout period elapsed prior to ob... |
|
| MySQL and SQL Server (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi! As anyone been using both MySQL and SQL server? What's the difference of the two regarding performance, stability, maintenance? MySQL (MyOLEDB Provider) lacked transactions last time I used it. MySQL has supported transactions for 3.5 years now. In a benchmark by eWEEK, MySQL 4.0.1 and Oracle 9i beat SQL Server 2000 Enterprise Edition by a factor of 3: http://www.eweek.com/article2/0,4149,293,... |
|
| DataTable.Reset() vs DataTable.RejectChange() (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Anyone can tell me the difference between DataTable.Reset() and DataTable.RejectChanges()? |
|
| Can I use addrow in a dataset to retrieve autoincrementing keyfield (7 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| In ADO.NET Core Reference they give an example of the savings in code of adding a row using a dataset rather than a datatable: ds.Customers.AddCustomersRow("ALFKI", "Alfreds Futterkiste") If you are adding a row that has an autoincrementing integer as its keyfield, can the integer be retrieved, as it is with an addhandler using tables and rows? polynomial5d |
|
| Need Help ASAP - Willing to Pay (6 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I have a time critical function I need assistance with. You should be familiar with windows forms, ADO.NET and MS Word Automation. If you are interested please email me at kjmnospamhereplease@charter.net remove the nospamhereplease Thanks.... |
|
| How to determine a running SQL Server (6 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi! I am writing a database application in C#. So I want to know if the server is running. At this moment it takes a long time till i get an answer (exception). How can i proof it fast? Thanks, Michael |
|
| Concurrency violation with Access database (5 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Using the ado.net code below to write records in an Access database, the first three records update correctly but the last three all cause a "Concurrency violation" error. I know that there are 6 records in the Access database. Any ideas on what I'm doing wrong? Rick Lederman, rick@soaringsoftware.com.removethisantispam OLEDBConnectionString "Provider Microsoft.Jet.OLEDB.4.0;Data Source " & sCData... |
|
| Sum of column in a datatable (5 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Can anyone tell me how i can get the sum of a datatable coloumn?? I tried to use the Sum("ColumnName") but this does not work. I want to sum this value and place the result in a label. |
|
| Datasets, Datatables and SQL commands (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I wanted to ask how i could run a stored procedure against my dataset. At present i am using a datareader to fill the values of my combobox from my database. As i have created a dataset with all my databse tables, it makes more sense to run my SQL command against the dataset. Does anyone have any examples of how i could run parameter commands against a dataset? Also i want to filter my datatab... |
|
| MSDE and Calculated Field? (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a table of values... i.e. [id, qty, price] I can create a view with an amount, i.e... [id, qty, price, qty*price] I want another column that maintains the balance... i.e. [id, qty, price, qty*price, balance] A little more info... this is for a stock trading simulation. The initial balance will be $100,000... each trade needs to decrement (for a BUY) or increment (for a SELL) the balance. I ... |
|
| Chicken or Egg: SQL vs Strongly Typed DataSet (9 replies) |
| microsoft.public.dotnet.framework.adonet |
| I'm still trying to figure out the best way to approach this problem: I have to create a (SQL server) database and tables within C# code (Ado.net) and then create a strongly typed dataset from that table... Or is the reverse possible? It would seem that there's enough info in a strongly typed dataset to create the database/tables. I haven't seen this mentioned in books on ADO.net, possibly because... |
|
| MS Access (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I have worked with Stored procedures in SQL and now I am trying to figure out how to do the same or similar in MS Access. I created a simple query which is asking for the user to enter the first character of the last name. When I run this in Access, I get the prompt which ask me to enter the first character of the last name. I works just fine. Now when I attempt to run this query from a C# ... |
|
| Data View - explanation (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Couold you please point me to some web sites where I could find more about Data Views and how to use them? Thanks |
|
| Dataview not updating Dataset (6 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I am writing a program using a Dataview to populate a Datagrid (using Tablestyles for formating columns for display). Everything displays fine but any changes made to the grid are reflected in the Dataview (confirmed using Dataview.Listchanged event) but not in the Dataset (confirmed using the Datatable.RowDeleted event it never fires when I delete a row). Even though I call the Datatable.AcceptCh... |
|
| Execute a View from ADO.NET:Failed to enable constraints... (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi Everybody I have a Problem getting Data out of a View...I always get: "Failed to enable constraints. One or more rows contain values violating non null, unique, or foreign key constraints. " I have no Idea what the error might be... my view: SELECT DISTINCT dbo.tb Verkaeufer.ver Nummer, dbo.tb Verkaeufer.ver GueltigBis, dbo.tb Verkaeufer.ver AenderungDurch, dbo.tb Verkaeufer.ver Name1, dbo.tb V... |
|
| Weird DataSet Problem (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have been working through this Microsoft support article http://support.microsoft.com/default.aspx?scid kb%3Ben us%3B310350. I have adapted it slight in that I am not using in the context of a web service. However whenever I make a change to the data via a bound DataGrid the GetChanges method does not seem to work. If I add/delete a row, it works fine. Also the Merge method does not appear t... |
|
| data view sort question (5 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| in asp.net i allow the user to sort a dataview which is bound to a grid. similar to this: dvMyData.Sort "Department, Salary DESC" This works fine. I also build a CSV file so the user can download the data. My problem occurs when i build the CSV file. I walk through each row using a data table and code like this: For i 0 To dt.Rows.Count 1 ... I'm puzzled why the data in the data table isn't sorted... |
|
| colum limitation (6 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| hi, I got a problem. I just want to know why. I use Data adapter configuration wizard to build a strongly typed data adapter. But it always fails to generate data adapter. Since the table has more than one hundred columns, is this reason ? Because when I select less than 100 columns, it will be ok to generate the data adapter. So my guess is that 100 is the upper bound. Please confirm my guess if ... |
|
| Validating in a datagrid (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi All I'm trying to validate some values in a datagrid so that if the user does not fill in all required fields the focus remains in the row until they complete the requirements or cancel the entry. Presently I'm using the DataRowChangeEventArgs to check the columns for the required values and then ending the edit and rejecting the changes if they fail. However they are not restrained in the reco... |
|
| OleDB Error: Data Type Mismatch (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| help. Deploying a .Net Application using ADO and MS Access (Jet 4.0) and MDAC 2.8. Get error: OleDbError .... Data type mismatch in criteria expression ... The application works fine in the development machine: OS: Windows 2000 Pro Jet 4.0 (msjet40.dll Vers. 4.0.7328.0; odbcjt32.dll Vers. 4.00.6200.0) MDAC 2.8 The error occurs in the test machine: OS: Windows XP Jet 4.0(msjet40.dll Vers. 4.0.4431.... |
|
| how to select by a binary column? (9 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I have a binary column in a .NET (C#) in memory DataTable, and I wish to make a selection based (among others) on this column. It's easy to do such a thing on eg MS SQL, but I want to do it in .NET's in memory data. I tried to format the byte array in many ways (including the 0x0001 format of MS SQL, but also 000 0001, {000 001}, [000 001], with or without quotes, but no way worked. Any ide... |
|
| DataGrid and DataSet information (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have 2 parents tables (example : Car and Road). That Car can use n Roads and Road can be use by n Cars. In that case, I need a middle table because it is a n to n relation. So we had a Link Car Road table with the primary key of Road and Car as foreign key in Link Car Road. So if I want to design a form to show the car informations with all the road corresponding to that car, I need to use a... |
|
| ado .net datatable .select method syntax, recognized functions, etc (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| You can use trim() inside a datatable .select but it is not recognized in t sql; on the other hand, ltrim() is recognized in t sql but not in a datatable .select; therefore, inside vb .net, this works: For Each irow In dsspship .Tables(0).Select("(qrange e qrange s) 0 and len(trim(pubcode)) 0") whereas this doesn't: For Each irow In dsspship .Tables(0).Select("(qrange e qrange s) 0 and len(ltrim(p... |
|
