Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score acessing data from other system on a network
a.mustaq@gmail.com - 6 Jan 2007 6:50 AM - 3 messages
Hi,                                      I have installed sql server in my ...
Score Remove partial duplicates from dataset
Gene.Averett - 5 Jan 2007 11:14 PM - 4 messages
I perform a query on a MySQL database and return a dataset. the data looks like: TaskID         TaskName 201                 Orca ...
Score Value property does not appear in the parameters editor
Steve - 5 Jan 2007 6:29 PM - 1 message
Hello fellow coders! I'm working with typed datasets / tableadapters in VS.NET 2005 with SQL server for the backend. My tableadapters are configured to use stored procedures. My stored procedures have a @debug parameter which when set to 1, causes PRINT statements to be executed to aid in debugging the ...
Score Value property does not appear in the parameters editor
Steve - 5 Jan 2007 6:28 PM - 1 message
Hello fellow coders! I'm working with typed datasets / tableadapters in VS.NET 2005 with SQL server for the backend. My tableadapters are configured to use stored procedures. My stored procedures have a @debug parameter which when set to 1, causes PRINT statements to be executed to aid in debugging the ...
Score DataGrid Methods
John - 5 Jan 2007 6:05 PM - 5 messages
I created a connection, adapter, and a dataset using a .mdb, then filling in at runtime; OleDbDataAdapter1.Fill(DataSet11) I also created a DataGrid and bound it by changing the DataSource property to 'DataSet11.MainTable'. My Goal is to modify the data in the rows and also add new rows with new ...
Score ODBC
marcmc - 5 Jan 2007 5:12 PM - 3 messages
Hey, What do people/gurus think of ODBC connections to databases? The beauty of .net is it allows the database to only be connected to for the length of time you need it. This is great for classes like SQLClient and ...
Score spawning a seperate process for a long running stored procedure from vb.net??
jobs - 5 Jan 2007 4:16 PM - 1 message
Im writing an SSIS script task using VB.NET. I'd like to be able to initiate an oracle stored procedure call for a process that will run for 8 hours, but I don't want my process to wait for it finish. In ...
Score multiple entries in a parameter
T McDonald - 5 Jan 2007 2:13 PM - 2 messages
I have a question with how to accomplish the following. I generate a list of values from a text/XML file. I would like to then filter a query on a SQL table with that data similar to the following: ...
Score ADO.NET's WriteXML have difference behaviour between .NET 1.1 and .NET 2.0
ABC - 5 Jan 2007 6:06 AM - 1 message
I have a dataset which contains two tables, one is master and another is child table with a relation join between tables. When I use DataSet.WriteXML in .NET 2.0, it shows as: <aDataSet>     <MasterTable ID="1" ............... /> ...
Score ADO.NET's WriteXML has BUG!!
ABC - 5 Jan 2007 4:49 AM - 4 messages
I have a dataset which contains two tables, one is master and another is child table with a relation join between tables. When I use DataSet.WriteXML, it shows as: <aDataSet>     <MasterTable ID="1" ............... /> ...
Score saving ad-hoc sqlserver scripts via Visual Studio
Fred Exley - 4 Jan 2007 8:57 PM - 9 messages
I come from an Oracle background, where one can, in addition to having stored procedures in the db, load and run text files containing sql DDL or DML commands.  But I can't seem to find an equivalent in VS2005.  I can ...
Score DataGrid only sets HasChanges to true if another row is selected
John Sitka - 4 Jan 2007 8:06 PM - 7 messages
Hi, I have a datagrid that has as it's datasource a filtered datview of the underlying datatable. The datagrid is set to read only. When the row header column is clicked it fills a series of textboxes, datapickers etc positioned ...
Score Urgent Help!!!
dinoo - 4 Jan 2007 3:36 PM - 3 messages
I would appreciate if some one can help me here. We have a webserver where we have multiple asp.net web applications running. All the applications previously using Oracle 9 database. Now the database has been modified to Oracle 10g. ...
Score Failover Partner SQL 2005 Only?
senfo - 4 Jan 2007 2:33 PM - 3 messages
I recently ran across the "Failover Partner" attribute that can be assigned in the connection string and I was wondering if it worked with SQL 2000 servers, as well as SQL 2005.  I was reading this article ([link]) and there is no ...
Score Checkboxes in a datagrid
arun@greettech.com - 4 Jan 2007 1:26 PM - 2 messages
I have a GridView with a a checkbox as below. <asp:TemplateField> <ItemTemplate> <asp:CheckBox  ID="CheckBox1" runat="server" AutoPostBack="true" checked='<%# Eval("BooleanField1") %>' OnCheckedChanged="CheckBox1_CheckedChanged"  /> </ItemTemplate> </asp:TemplateField> ...
Score ADO.NET Beginner: error connecting to DB2
Philip - 4 Jan 2007 9:23 AM - 2 messages
Hi all, I am trying to create a connection to DB2 in ADO.NET but I get the following error: format of the initialization string does not conform to specification starting at index 136 << It's really strange, I have a quite straightforward connectionstring (from ...
Score Best practice Multiuser Program - locking
aaapaul - 4 Jan 2007 7:08 AM - 17 messages
Best practice Multiuser Program - locking I have to develop an application with Visual Studio .NET 2005 and SQL Server 2005 (ADO.NET). There is a sql-server table called "Orders" with primary key ordernr. If a user calls "Edit Order Nr XY" in the program the datarow xy should ...
Score Typed Dataset - Basic Question
divisortheory - 4 Jan 2007 6:34 AM - 3 messages
I used the Designer to generate Typed Dataset classes for every table in a database I'm using.  In one particular table, I use a numeric Autonumber column as the primary key, 1 text column specifying a friendly name, and some other miscellaneous columns.  Given a string ...
Score Adding records through batch Webservice call
Tomasz - 3 Jan 2007 11:15 PM - 11 messages
Hello everyone, I am either missing something, or it is actually not so straight forward. How do I add batch of records through single Webservice call? - Important requirement, newly added records have ids and some other values assigned on the server side, so they have to be reconciled (merged back). ...
Score invoke .net data provider connection string wizard at runtime c#
Jack Wasserstein - 3 Jan 2007 11:15 PM - 2 messages
Is it possible to invoke this wizard at runtime? I got a nice answer for the ado wizard, but I also need this one to connect to a sql 2005 express server and database. Any help would be greatly appreciated. ...
Score Concurrency Violation
Dustin Davis - 3 Jan 2007 6:34 PM - 15 messages
When the following subroutine executes I get a concurrency violation. I'm not sure why. Can someone help provide a clue for me? (drvZones is a DataRowView) ...
Score Error when connecting to SQLExpress
Earl - 3 Jan 2007 3:56 PM - 9 messages
I have an issue that is totally baffling me. When I use a program I've written to connect to SQLExpress (and a given database), all works well on my development system and on a laptop that I tested with. However, I have ...
Score DataTable search performance
Larry Smith - 3 Jan 2007 3:50 PM - 3 messages
Hi there, Can anyone comment on the performance issues of "DataTable.Select()" vs "DataView.Find()" (or "DataView.FindRows()"). I have to conduct repeated searches using the same index and I'm not sure which to rely on. From what I've read, "DataTable.Select()" doesn't rely on indexes so using a ...
Score Select Statements
TheDude5B - 3 Jan 2007 11:30 AM - 5 messages
Hi, I have two tables. One table contains the information about the object, and then the other table contains the objects ID and then the ID of where this object is allocated to. table one Object: ObjectID, ObjectName. table two Allocated: siteID, ObjectID. ...
Score DataSet.WriteXML is difference between .NET 1.1 and .NET 2.0?
ABC - 3 Jan 2007 10:26 AM - 1 message
I have old program written in .NET 1.1 which output a XML file similar as : <?xml version="1.0" standalone="yes"?> <EDIDatasSet xmlns="http://tempuri.org/EDIDatasSet.xsd">   <Booking ID="xxx" LastUpDate="2006-11-29T16:20:16.7170000+08:00" ...
Score general function to insert a DATE correctly
pamelafluente - 3 Jan 2007 8:17 AM - 21 messages
Hi I have to insert dates into some Access and SQL Databases. I need to be general as the target computer might be in any country. -------- - For access I wrote the follow:     Function Date_ACCESS(ByVal Data As Date) As String ...
Score Check for existence of server
Earl - 3 Jan 2007 6:12 AM - 4 messages
Is there any sort of check that can be done to see if a particular instance of SQL Server is present? I already call a method to check for connection --  if no connection, I have the user re-enter server settings (server name and ...
Score invoke ado connection wizard at runtime C#
Jack Wasserstein - 3 Jan 2007 4:49 AM - 9 messages
Is it possible to invoke this wizard at runtime, using c#, if so how? ...
Score Refreshing a DataList
Nathan Sokalski - 3 Jan 2007 4:21 AM - 2 messages
I have a DataList control that I want users to be able to sort the data in by clicking 1 of 3 buttons. The function I have created to do this is as follows: Private Sub SortPoems(ByVal sortby As String) ...
Score Copy a database table into another using ado.net
kkizer - 2 Jan 2007 10:44 PM - 5 messages
I need help! Here is what i have going. I have a cobal database that i connect with using a DSN/ODBC (the source data) and i have a Sql 2000 database that i am trying to copy the data to. I have a DTS package ...
Score Code works with OLEDB but Not with SQL2000
Gordon - 2 Jan 2007 9:21 PM - 4 messages
Hi ; I am trying to create several Excel sheets using SQL 2000 views like so: Select * INTO [Excel 8.0;Database="C:\spreadSheets\aNew.xls"] FROM [aView]. When I try and execute this in my app I get the following - Specified owner ...
Score VB.net and ASP.Net Typed Datasets
Rick Vooys - 2 Jan 2007 8:10 PM - 17 messages
Quick background, we are upgrading our old Access Application. We have upgraded the "backend" or data layer to SQL Server 2005. Currently we have the previous Access frontend linked via ODBC and are working on creating a new Frontend. The frontend only needs to be accessed via the company ...
Score BindingSource.EndEdit - Not updating underlying data source
Dustin Davis - 2 Jan 2007 5:52 PM - 13 messages
I'm having problems updating a dataset. I call the following method to add a new record: Me.drvZone = Me.ZonesBindingSource.AddNew() Then when I'm done filling in the form, I call: Me.ZonesBindingSource.EndEdit() Me.ZonesTableAdapter.Update(Me.DsZones) ...
Score nvarchar(max) and corresponding SqlDbType
Dmitriy Melikov - 2 Jan 2007 4:36 PM - 3 messages
Hi All, I am using nvarchar(max) as a parameter for a stored procedure in a SQL Server 2005 database. What is the corresponding SqlDbType in this case? System.Data.SqlDbType.NVarChar is limited to 4,000 characters. MSDN says, "Explicitly set the object when working with strings longer than ...
Score DataRow Question
Goofy - 2 Jan 2007 3:09 PM - 6 messages
Hi, I have a row in a dataset table which is nullable ( and also on the sql backend ), but how can I set it to a null. if I try Myrow.myDate = nothing when I test the row, I get   "#12:00AM" why ?? ...
Score Textchange event
nil - 2 Jan 2007 11:18 AM - 3 messages
Hi everyone... can anyone tell me how to fire textchange event of textbox that is in datagrid...as on the basis of that i wana fetch data from the database.if you can provide code snippet or any link than i'll be ...
Score Retrieving specific entries in .mdb
John - 2 Jan 2007 5:00 AM - 11 messages
I am attempting to retrieve records from an .mdb file.  But can only retrieve the first entries of the table using the code below.  How would I code to get any entry I desired (2nd entry, 4th entry, etc.) ? ...
Score DataAdapter fails to update the server database
Jack Wasserstein - 2 Jan 2007 2:43 AM - 12 messages
I am probably missing something obvious, but I cant seem to get this to work. I have been reading several posts and trying different combinations, but the gist is that the server database never gets updated with the changed dataset. ...
Next »