Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Indexes for Foreign Key Constraints?
Joel Lyons - 9 Nov 2007 10:51 PM - 6 messages
I read recently in an ADO.NET book that I should create indexes on foreign key constraints if they will commonly be used when joining.  I can't remember where, but I could swear that I had read somewhere else that ...
Score Re: KB928365 and 'Internal .Net Framework Data Provider error 6' issue with .NET 2.0 on databases wi
Carlos Mendonça - 9 Nov 2007 2:08 PM - 2 messages
I'm posting the stack trace we've captured. Please reply below if you have captured something different. System.InvalidOperationException: Internal .Net Framework Data Provider error 6.    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)    at ...
Score What is the best way to connect to a cube?
David Thielen - 9 Nov 2007 12:45 AM - 2 messages
Hi; 1) Is there a url that discusses the best way to do this using ADO.NET (and pretending it's a SQL database)? 2) Is there a url that shows the best way to access it as a cube taking full ...
Score On TransactionScope and TableAdapter
Ajit - 8 Nov 2007 6:08 PM - 1 message
Hi,    We are developing a WCF service using .NET 3.0. The target platform : Win XP,SP 2.0 In the data access layer, we use ADO .NET to connect to the SQL Express database.Data access layer is implemented as typed datasets with tableadapter ...
Score RE: Error while connecting remote SQL server
Vene - 8 Nov 2007 2:48 AM - 1 message
I understand your frustration, I have the same problem and I did what you did and the problem still there .......A connection was successfully established with the server, but then an error occurred during the pre-login handshake.  When connecting to SQL Server ...
Score Problems adding a calculated field to an existing dataset.
B. Chernick - 7 Nov 2007 7:34 PM - 4 messages
I'm doing a project in Winforms VB/Dot 2.0.  I have an existing xsd.  What I would like to do is add a calculated field to a table.  This column would simply be a concatenation of 2 other fields, both fixed length char ...
Score command.CommandText and parameters
skneife - 7 Nov 2007 5:11 PM - 2 messages
What is the way for getting the sqlQuery with all params replacementfrom a command ? DbCommand command; SqlParameter sqlParam = new SqlParameter("@param1", "value1"); SqlParameter sqlParam = new SqlParameter("@param1", "value2"); command.CommandText=sqlQuery; What is the propertoie that provide the sqlQuery string but with all ...
Score tableadapter configuration fails with stored procedures and temp t
MarcG - 7 Nov 2007 3:25 PM - 4 messages
This issue was raised in posts from 2005 to 2007. The Feedback article dated 2005 at ... https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=106244&wa=wsignin1.0 provides a workaround that leaves a maintenance headache. I have experienced ...
Score select a slice of records from a position
skneife - 7 Nov 2007 10:02 AM - 2 messages
I need to get a range of records from a specific position like Limit start,numberOfRecords in mySql: Example a table with columns name and age: id      name    age 1       John     20 ...
Score A few different questions...
Michael Bray - 7 Nov 2007 2:06 AM - 5 messages
I'm trying to import a large dataset (300,000 lines of delimited text) into a SQL database with ADO.NET.  I've run into a few issues - Performance - the inserts ran very fast for the first 50,000 records or so, ...
Score is it possible to mark my CLR function as UNSAFE in code or visual studio anywhere so that wehn vs d
DR - 7 Nov 2007 12:47 AM - 4 messages
is it possible to mark my CLR function as UNSAFE in code or visual studio anywhere so that wehn vs deploys, it creates unsafe assembly? (instead of me having to manualy deploy in tsql!) ...
Score ADOMD.NET 9 and Analysis Services 2000
qalexis - 6 Nov 2007 8:05 PM - 1 message
Hi, i need help. I am using ADOMD.NET 9 to connect with AS2000 and AS2005, and the connections to both work fine. However something rare happen. If i add a counter "Current Connections" of AS in the Performance tool, with AS2005 all ...
Score Saving a (whole) datatable in SQL Server 2000
Pipo - 6 Nov 2007 7:24 PM - 3 messages
Hi, I would like to save (and load) an entire datatable into SQL Server 2000. Is this possible and has someone has some sample (code) for me? tia, Pipo ...
Score Saving a whole datatable to SQL server 2000
Pipo - 6 Nov 2007 7:18 PM - 6 messages
Hi, I am looking for some sample (code) on how to save a complete datatable into SQl server 2000. I want to save the datatable (filled with datarows and values) and later on I need to load it back again. ...
Score Large VB ADO.NET Recordset Import into Excel
CerfurMark - 6 Nov 2007 7:17 PM - 8 messages
If I use Excel to open an Excel file with 61K records, they appear instantly. If I fill an ADO.NET recordset in Visual Basic with 61K records, it fills almost immediately.  But if I bind the dataset to a ListObject in Excel in ...
Score What's difference between creating Web Application and Web Site
william - 6 Nov 2007 5:20 PM - 4 messages
Hi, There are two ways to create web-based application or web service, from VS start page, click on File and New, two options you can choose, one is Projects which leads you to create ASP.NET Web Application or ASP.NET Web ...
Score How start identity field at 100
Cirene - 6 Nov 2007 3:47 PM - 13 messages
I have a table with the PK field defined as an identity field with the increment of 1.  How do I START the calculations at 100, rather than 1? ...
Score Working with multiple typed datasets under same transaction
bz - 6 Nov 2007 3:33 PM - 3 messages
Hi, I have two typed datasets I use on the same form. Each contains some TableAdapters and corresponding data tables. The TableAdapters contains, beside default Fill methods (to populate the DataTable) some queries which returns scalar or some action queries  (insert / delete) ...
Score Better way for dropdownlists
Madison - 6 Nov 2007 2:09 PM - 6 messages
Hi there, I'm using framework 2 with web application project,  one of my page have 5 dropdownlist and one gridview. The dropdownlists data are stored in SQL Server (data may grow more in the future) 1. sector (about 4 items) ...
Score How to get data from one cell in a control during button click event
LM - 5 Nov 2007 8:53 PM - 1 message
I try to get one (string) value from DetailsView or GridView control during button event. Controls own insert or select buttons are a bit too low on the screen to be useful. I use VB LM ...
Score tablenames
Martijn Mulder - 5 Nov 2007 7:52 PM - 3 messages
After I Open(ed) an OleDbConnection, I need the names of the Tables right away. How? (in C# or in VB) ...
Score Closing a connection BEFORe command execution has completed
Amir Tohidi - 5 Nov 2007 4:14 PM - 4 messages
Hi What happens in the above scenario? Does the query still continue executing on the Databas server or is it immmediately terminated and resources released (including locks). If this is not recommended, then what is the recommended approach for terminating command's execution. ...
Score Time out Expire (asp.net)
Hakkim sulthan - 5 Nov 2007 3:32 PM - 4 messages
iam calling a stored precedure from my program, the process is to bring the datas in tree structure so the data is heavy , when i tried to bring more datas its says "(Network Error (tcp_error) A communication error occurred: " i try to increase the connection & command time out still ...
Score How to insert data into wider table
LM - 5 Nov 2007 11:51 AM - 1 message
There are two tables. First with fields "ProductID, ProductName and Price", in other table there is also "NumberOItems". How can I do this. Is it an extra field in sql query. Here is my other code.    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As ...
Score Add Records
Jonathan Wood - 5 Nov 2007 1:48 AM - 7 messages
Well, I spent about 45 minutes trying to find a simple example that shows how to add records to a SQL database from C# code. All I can find is databound stuff, or examples working with Access and who knows what. ...
Score Importing Data
Jonathan Wood - 5 Nov 2007 12:25 AM - 9 messages
I'm new to SQL stuff. All I have is MS SQL Express that came with Visual Studio 2005, and SQL Server Management Studio Express, which I downloaded and installed. I've created a new table, and I have a comma-delimited text file of data I ...
Score How to GROUP SELECT WITH some value and WITHOUT some other?
Lloyd Dupont - 4 Nov 2007 1:17 PM - 2 messages
I have a table Customer =========== INT (Identity), Varchar(50), Varchar(50), Varchar(50) ============ ID, City, FirstName, LastName ================= 1    Brisbane    Jon    Smith 2    Brisbane    Allan    Parker ...
Score Keeping a OdbcConnection Open
Paul - 4 Nov 2007 2:44 AM - 2 messages
I am dealing with an AS400 DB2 system and am running into some query execution timeouts. It seems like every time you Open the initial connection the query can take over 1 min to return results. Once the connection is open ...
Next »