| Oledb Jet (6 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello All, In using SQLClient I can add a record in a table and retrieve the Autonumber Primary Key field of the record added in a single parameter query by declaring the parameter as an Output parameter. How can I retrieve the autonumber primary key added using System.Data.Oledb when the provider is Jet? Any help would be greatly appreciated. Sal Sarhangi |
|
| Efficient find in dataset (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Can I set up a primary key on a dataset after it has been populated like after the query has been run? I'm trying to do a look up on a dataset, but I believe that using the find method is more efficient than looping thru the dataset. Is this correct? Generally speaking? Regards, Alvin Bruney Got DotNet? Get it here http://home.networkip.net/dotnet/tidbits/default.htm |
|
| is there TreeListView like control bound to DataSet? (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| . |
|
| SELECT satements multi values return in ADO.NET + VB.NET (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, If i do something like "SELECT ID,NAME,ADDRESS FROM MEMBERLIST WHERE MEMBERID @MEMBERID" in languages like PHP and FoxPro you can have that returned as an array, do I have to use a datareader to get the data even if it is a scaler result? or can you also have it returned as an array from a executescaler? thanks! |
|
| Programming Excel Effiviently - HELP! (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| My head is exploding with the 500 different ways shown on Microsoft's site to program Excel (Office) Can anyone offer the best solution to the following: I want to program a couple of Excel reports for both Mac Users and PC users and have them access from a web site. These users not only have different platforms (Mac and PC) but many have different versions of Excel (XP, 2002, 2003, 2000). What do... |
|
| Access or SQL CE? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| How does SQL CE compare to Access databases on a PocketPC? I have done simple operations such as opening the Northwind Order Details table (2155 records) using both Access and SQL CE on my iPaq and Access can open the table 1 second, where SQL CE takes 6 seconds the first time and then 10 seconds anytime afterwards. I am using the Query Ananlyzer on the iPaq for SQL CE and a custom app for the Acc... |
|
| insert failes (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I'm tring to insert a new row to a table but it seems that it failes (I think) because the values of the new Row are null. here is the defenition of the table, I suspect that my problem is in the defenition. create table aa.dbo.Tasks ( ID int primary key identity(1,1), Done bit, TaskGroup varchar(30), Subject varchar(40), Initiator int, Resource int, Note varchar(200) ) Do I need to define default... |
|
| Newbie Question regarding XML and Datasets (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello everyone, I will try to keep this as brief as possible. I have 1 data connection and 1 data adapter in my project. The connection is to a dBase file directory using the Microsoft dbase VFP driver (it's light years faster than the dbase only driver). I have three separate commands dsSelectCustomerInfo, dsSelectCustomerBalance, dsSelectTransactions. I have used the SQL command builder in the I... |
|
| SQL Connection String on a NON-standard TPC/IP Port (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Anybody know how to connect to a SQL server with a port installed on a port other than 1433? Thanks, Jim |
|
| SQL script execution (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| is there anyway to execute a saved .SQL script file through ADO.net? I want to automate database creation based on a SQL script I can easily edit... Thanks |
|
| async (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| How do I play a prompt async? Do I have to use a QA to do that? Using just the prompt class doesn't appear to play async and there doesn't appear to be an async property on the prompt object. Reggie |
|
| Dumb question about strongly typed datasets (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Okay, I am sure this is right in front of my nose, but I cannot figure out how to do this... I have a strongly typed dataset (STDS) generated by xsd in CSharp. I have the code in place to populate the various tables (7 of them) with datarows. How do I now update this back to the database? Do I need 7 SqlDataAdapters, each one with the appropriate Command members? If so, where can I get the 7 SELEC... |
|
| Writing DataGrid data back to the database. (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am having some real troubles with this. I have a database that is using a oleDbAdapter to load a DataSet that shows up on a grid. I modify the text in the grid then run the following code. bool b dataSet11.HasChanges(); dataSet11.AcceptChanges(); int x dAdapt.Update(dataSet11); Single stepping through the code I find that b is true so the dataSet has changed. But x gets returned as a Zero saying... |
|
| looking for extremely simple examples (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Once again at my wonderful job i've been given the task of "come teach your fellow idiot coworkers the skills you have" I write software for a company in chicago. I use visual basic on asp.net type platform. Recently i learned a little bit on database access and would like to knw more so that i can pass along the knowledge to my coworkers who do not possess this information. the trouble is that my... |
|
| CHEWSTAN@nyc.rr.com (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| CHEWSTAN@nyc.rr.com |
|
| Data Adapter for XML (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Does anyone know of a data adapter that supports XML? I have a small database that is just an xml file and would like to be able to run simple sql statements against it. Does anyone know how this can be done? |
|
| Datatable.select BUG? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I am trying to select rows from datatable using datatable.select("GLNO '23345' and amount 200") GLNO is a STRING and amount double. each time the method fetched different number of rows. I have tried giving sort expression & dataviewrowsate too,but still it BUGS. It fetches 8 rows sometimes but most of the times fetches 2,6, 4 rows, I am not able to notice any pattern in the rows also. Has any... |
|
| convert datetime type to string type in a dataset? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I want to convert a dateTime column in my dataset to the string type column and the data in this column should look like same. Can someone show me how to do this? Thanks in advance. tom |
|
| Complex Reporting Tool Required (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Cross post on recommendation I need to find a reporting tool that allows me to do most everything (aside from form design) via code. I've tried ComponentOne and Crystal, but neither seems to like giving me absolute control over creating sub reports on the fly, and manually populating field values. I understand that I should be able to pass either a dataset or XML structure to the report engine, bu... |
|
| Table name req'd for adapter.update ? (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I was trying to find out why a Sql Server table was not getting updated. It was being updated by a stored proc invoked from a web service. th SQLAdapter.update call returned 0, but no errors. I checked a lot of stuff and found that if I specified the table name in the update call : SqlAdapter1.update(ods,"VISITS") Everything works nicely. All my adapters have an explicitly named datatable, ... |
|
| Crystal Report Database Connection (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hallo, I like to display and print my database data with the help of (.NET)CrystalReport. So far so good. Can anybody tell me what to do in order to change the absolute database path to a relative one. As far as I know, (.NET)CrystalReport can only handle absolute path connections?! By the way, is there any way to display non database data like an array of CMyClass Objects? Thanks for any help Alf... |
|
| Concurrency question (9 replies) |
| microsoft.public.dotnet.framework.adonet |
| Here's the basic problem pertaining to the question to come. Using Access Database with the following tables Customers CustomerID (primary key) Customer name,address,phone Orders OrderID (primary key) CustomerID (referential key) Order Data OrderDetails OrderDetailID (Primary key) OrderID (referential key) Order Details Ok, on my data windows form for order entry the first thing that is required i... |
|
| Complex SQL Statement (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| I thought I might post this to see if there is a pro that can help me. Here's what I want to do: I have two tables ('tblPositions', 'tblTrades') A relationship exists at tblPositions.ID tblTrades.PositionID I need to pull only one record from each relation set (the one with the most recent TradeDate value) from the tblTrades table I need to sort the retrieved records by TradeDate DESC Here is the ... |
|
| ADO Command - .Properties("XSL").Value = XSL_FILE (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I used to have the following code in VB/ADO when using a FOR XML clause in SQL Server. Is there a .Net/ADO.Net counterpart? ' Set strm New ADODB.Stream ' With strm ' .LineSeparator adCRLF ' .Mode adModeRead ' .Type adTypeText ' .Open ' End With ' ' Set cmd New ADODB.Command ' With cmd ' .CommandType adCmdText ' .CommandText sQry ' ' Set cn GetConnection(, m sServerName, "SynergySystem", m sSQLLogi... |
|
| Passing a wildcard character to SQL Server (8 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hello, Using ADO.NET, I am invoking a SQL Adapter's fill method. One of the parameters is a date. Most of the time, the date will be an empty string. The Web Service method always appends a '%' to the end of the string, so that most of the time, a "%" is used as the (smallDatetime) parameter. SQL/SOAP complains that the string does not look like a date. Well, no it doesn't, but that is the point o... |
|
