Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score help with async = true scenario
Colin Robinson - 14 Jan 2006 10:49 PM - 4 messages
Appologies for cross posting this but languages.vb may not be the correct place to have asked in hindsight. Im creating a dotnet windows form app that will run a given TSL script across a domain of sql servers with the same login credentials(for this ...
Score Updating tables -- what am I missing?
eagle - 14 Jan 2006 7:00 PM - 5 messages
This is my code, and nothing appears to happen.  The dataset has 3 rows, I do an insert, and the dataset still has 3 rows.  What am I missing or doing wrong?  There is nothing wrong with the query, or the connection, and I get ...
Score Updating sql from a dataset
et - 14 Jan 2006 4:50 PM - 2 messages
Okay, I've got my dataset, I've made updates to it, now how do I  update sql from the revised dataset? ...
Score Express Editions licensing question
Jesús López - 14 Jan 2006 9:36 AM - 2 messages
I konw Visual Studio Express Editions Visual Designers do not work with SQL Server remote instances. But Are you violating the licence agreement if you change the connection string in the configuration file to point to a remote SQL Server instance when you deploy your application? ...
Score TableAdapter
ObjectiFly - 13 Jan 2006 10:45 PM - 1 message
I have an SQL table with an ID field that I set in the Stored Procedure and pass it back as an OUT parameter.  In VS.2003 I used to say myID = (int)tableName.InsertCommand[@myID].Value; With the TableAdapter - I haven't figured out how to do it.  I've read some ...
Score CompareValidator for dates > than today
tshad - 13 Jan 2006 8:48 PM - 2 messages
I am trying to check the date of my field to check if it is greater that today, but I am getting an error. I am using :         <asp:CompareValidator runat="server"          ControlToCompare="RequestedStartDate" ...
Score How bind textbox to parameter for insert (2005)
VB Programmer - 13 Jan 2006 7:51 PM - 1 message
Using ASP.NET 2.0.  I have a custom form to create a new user. I've created the datasource as the following: <asp:SqlDataSource ID="dsrcUsers" runat="server" ConnectionString="<%$ ConnectionStrings:MyMainDatabase %>"         SelectCommand="SELECT * FROM [MyUsers]" InsertCommand="INSERT INTO ...
Score Images inline with blog contents - HOW??
Neo Geshel - 13 Jan 2006 7:31 PM - 9 messages
I am seeking to hand-roll my own blog in ASP.NET 2.0 and SQLExpress 2005. Why? Because I can. Because I will gain experience. The one thing that has me stumped at square one is inline images. That ...
Score db errors
param - 13 Jan 2006 4:27 PM - 13 messages
Hi all, my asp.net web app will a couple of times a day throw the following error. The user closes out, goes back in and all is good. Any ideas on where I can start debugging? System.Web.HttpException: Error executing child request for ...
Score Viewing ExecuteQuery String
jim_adams - 13 Jan 2006 3:37 PM - 3 messages
Given a technique similar to the following, instead of actually executing the Stored Procedure, I need the resulting SQL command string written to a file and then manually executed in Query Analyzer. Dim objSqlConn As New SqlClient.SqlConnection Dim objSqlDA As New SqlClient.SqlDataAdapter ...
Score SqlDataAdapter.Fill hung, throttles cpu, and never returns?
David - 13 Jan 2006 3:03 PM - 1 message
SqlConnection c = null; try {      c = new SqlConnection("Server=x;Database=y;Integrated Security=SSPI");      SqlCommand cmd = new SqlCommand("sp_helpdb", c);      SqlDataAdapter da = new SqlDataAdapter(cmd);      DataTable dt = new DataTable(); ...
Score how to create xml schema object in asp.net 2.0?
dotnw - 13 Jan 2006 2:03 PM - 1 message
How do you use/access a strongly typed data set object (based on an xml schema) in asp.net 2.0? In asp.net 1.x, when I dragged a stored procedure on to an xml schema file, I right clicked on it, and selected the "generate dataset" ...
Score Can we filter columns in a dataset ?
Chak - 13 Jan 2006 10:07 AM - 7 messages
Just as we use RowFilter, to choose a subset of rows , i wish to get s subset of the columns. The workaround i could think of was to read the DataTable again with only required columns eg - SELECT COL1 FROM DT1 where ...
Score Help on reading data ?
serge calderara - 13 Jan 2006 9:13 AM - 2 messages
Dear all I am building an asp.net application wich collect data from an SQL server database. Those data in this database can be huge with the time. Actually, I am retriving those data through store procedure return in a ...
Score Reports
Ilya Dyoshin - 13 Jan 2006 5:54 AM - 4 messages
Hi all! I'm writting a simpe application. User enters an SQL query, and he receives the query result in report like table. I have a question: can I solve this problem with Crystal Report? If so, some code somples would be greate. For example I'd appreciate ...
Score Chosing a Hetrogeneous Oracle/.Net stack
jack - 13 Jan 2006 4:48 AM - 3 messages
I am currently architecting .NET Application for an Enterpise Level client. The customer has a natural Oracle bias. I think that Oracle is a great DBMS too. Probably still better thatn SQL Server. Having said that I have a bias against hetrogenoeuous stacks (ie Oracle ...
Score using smalldatetime to ONLY store date
Brian Mitchell - 13 Jan 2006 12:50 AM - 2 messages
When using the smalldatetime data type in a SQL database, how do I prevent the field from storing the time? All I want in the field is the date, but is keeps adding 12:00:00 AM at the end of the field. ...
Score Related tables for grids in vs 2005
Magnus Blomberg - 12 Jan 2006 8:47 PM - 4 messages
Hello! I'm quite new to VS 2005, and tries to connect several controls at my form. I thought this should be simple without writing code, but I can't get it to work. I have one dataset with two related tables. ...
Score DataAdapter update not including all parameters
kwgainey - 12 Jan 2006 7:16 PM - 7 messages
Hi folks, I have some code which takes a datatable, makes some changes to the rows, and uses the dataadapter.update(datatable) command to write the changes back to the db.  When I look at the changed rows in the ...
Score Mapping in ADO.NET 2 Dataset Designer
A.M-SG - 12 Jan 2006 6:21 PM - 4 messages
Hi, Where is the mapping designer in VS2005 DataSet designer? I cannot find it! Thank you, Alan ...
Score ADO.NET 2.0 and Insert Parameters of Byte()
Brian Mitchell - 12 Jan 2006 5:09 PM - 1 message
Hello, I am using the new SqlDataSource object with VS 2005 and I guess I am using it incorrectly. I need to know how to set the value of an InsertParameter equal to a Byte() array I have. Originally I had the parameters listed in the InsertQuery (from the ...
Score Help on Updated data info ????
serge calderara - 12 Jan 2006 4:31 PM - 2 messages
Dear all, I ma building an ASP.NET 1.1 application which collects data from an SQL server database. My customer use an internet browser to read particular information from SQL server. A remote system is periodically updating tables. Is there a way to informeds ...
Score Orphaned Oracle database sessions with OracleDataAdapter
Tom Wells - 12 Jan 2006 2:47 PM - 3 messages
I just discovered that my ASP.NET applications are leaving huge numbers of orphaned sessions on the Oracle server even though I issue a close() command to the connection in the dispose of all of my classes.  Below is an example ...
Score .LDB File not being deleted after oledbconnection.close being call
Chris McNear - 12 Jan 2006 2:47 PM - 4 messages
I have seen a thread similar to this problem earlier in this thread unfortuantely did not really see a solution.  My problem is as follows. I am opening a connection to an access database performing some operations and the closing (typical use)  I notice however that upon calling the ...
Score Transferring functionality to 2.0 site
VB Programmer - 12 Jan 2006 2:08 PM - 1 message
I have a fully functioning Access based ASP.NET 1.1 shopping cart that I created. I want to create a brand NEW 2.0 shopping cart "version" of this 1.1 project. How do you recommend I do this so that the 1.1 version remains untouched? ...
Score Save data from control to datasource
Magnus Blomberg - 12 Jan 2006 1:24 PM - 2 messages
Hi there! I am trying to use simple binding to enter text in a textbox and save it to the datasource. When I enter text in the textbox and press a save button, this text is not saved, because the datasource don't think the row has been changed. ...
Score Confusion in Dispose() and Nothing ?
Rahul Arora - 12 Jan 2006 10:39 AM - 5 messages
Hi!..All, I have a great confusion about the Dispose() method and Nothing. Can anybody tell me in detail how the two method work? what will happen to my object after i dispose it? will i be able to use it ? and what after ...
Score Populate Strongly Typed Dataset - without "Configure Data Adapter"
itinsley - 12 Jan 2006 6:31 AM - 4 messages
Hello I have begrudgingly decided to use Strongly Typed Datasets but hate the code that is generated by dragging and dropping ADO.Net controls and using Configure Data Adapter and letting the 'Wizard' build my SQL, for the following reasons: ...
Score ADO and parent/child/grandchildren
Jeremiah Harbottle - 11 Jan 2006 10:58 PM - 2 messages
Hi, Using VC to write a small app that displays data extracted from a database into a typed DataSet. That all works fine. I have three tables - Parent, Child, and then each record in the Child table also has children. ...
Score How to detect hidden rows?
Benton - 11 Jan 2006 6:05 PM - 3 messages
Hi there, Is there a way to know if a DataRow is hidden by an active DefaultView.Filter of its DataTable? In other words, is there any way to know if a specific DataRow will be iterated too ("visible") when iterating ...
Score How do you create a Datatable with a non-unique index on a column?
Kevin - 11 Jan 2006 5:05 PM - 1 message
Hi I have a strongly typed datatable which has a column that I perform a search.  To speed it up I would like to add an index to it, however this column contains duplicate values.  Is there anyway I can add it? ...
Score prerequisites for distributing application with access backend
booboojr - 11 Jan 2006 5:03 PM - 1 message
I have developed an c# desktop application that uses access as the backend.  I would like to install this application on computers with win2k and XP. What are the prerequisites for the computers that I intend to install the ...
Score Closing connections
tshad - 11 Jan 2006 2:30 PM - 8 messages
I have been misunderstanding the closing of the connection. If I have set CommandBehavior.CloseConnection, I thought that connection would be closed when you had read through the dataread.  As a matter of fact I found that if I had it set, I couldn't seem to get to the next results, if ...
Score Data designers in console apps
Ant - 11 Jan 2006 11:52 AM - 1 message
Hi, I'm writing a console application & notice that the data designers are not available from the toolbox as per usual, seeing as though there is no design mode. Is there a way to load the data designers so as to use them or must I ...
Score Convert Recordset->DataSet losing hidden columns
Ian Harding - 11 Jan 2006 10:29 AM - 1 message
I have some code that uses the OleDbDataAdapter.Fill method to convert an ADO Recordset to an ADO.NET DataSet.  In some cases the DataSet is edited - values changed, rows inserted, or deleted - then converted back to a Recordset to update the database. ...
Score Parameter placeholders in SQL queries
Massimo - 11 Jan 2006 12:08 AM - 5 messages
I'm trying to write some DB-independent code using ADO.NET 2.0 and the System.Data.Common.DbX classes, as suggested before; but I'm encountering another weird problem. Here's some code (let's assume the provider name and the connection string ...
Score Calculated Fields in Strongly Typed DataSets?
Tore - 10 Jan 2006 11:48 PM - 5 messages
We have an XSD schema/object graph that for the most part reflects our database.  I'm running into an issue where this granularity doesn't always match the need for using data from multiple datatables.  For example, I have ...
Score Selecting between varchar and nvarchar
ad - 10 Jan 2006 11:39 PM - 6 messages
When we design a string field, we can use varchar and nvarchar. There are some field which will have Chinese word. I will use varchar if the field is just English character or digital. and use nvarchar if the field may contain Chinese word. ...
Score Crystal Report on the fly
Ilya Dyoshin - 10 Jan 2006 10:54 PM - 2 messages
Hi All! I'm writting a solution. A part of it contains a code for dynamically create DataSet. Is there a possibility to create on the fly although reports, based on the DataSets on the fly (to print data from those ...
Score Reading a file with StreamReader and displaying its contents
Chumley Walrus - 10 Jan 2006 9:15 PM - 3 messages
I'm trying to read a text file on my aspx page, but when I do the following, I get a line that just says "System.IO.StreamReader " at the point of where I want the file's contents to be displayed: ...
Score View Excel Document in VB.Net Form
Linda U - 10 Jan 2006 8:00 PM - 14 messages
I am trying to view an excel document on a windows form.  I am using a webbrowser control as suggested in past topics and I am able to display the document fine.  The problem I'm having is that an excel shell is ...
Score Storage Question
clsmith66 - 10 Jan 2006 7:48 PM - 2 messages
I need to store html formated email for a client in a SQL Server 2000 database.  First off, is it possible, and if so, can any one help with finding the best way to save and retrieve it? Any help would be greatly appreciated. ...
Score ADO.net Code contest
bdwest - 10 Jan 2006 7:48 PM - 35 messages
I am sponsoring a contest to see if someone can come up with ADO.net code to insert records into a MS Access 2003 database faster than ADODB methods (MS ActiveX Data Object 2.x library).  My experiece has shown that I can write ...
Score Removing elements from a typed dataset
Ayoa - 10 Jan 2006 5:58 PM - 2 messages
I have the following code whose purpose is to take 2 typed datasets (of type DSAccounts )  & remove all elements of one from the other. and return what is left. However I am getting the error message "The given datarow is not in the ...
Score (C#/2.0) ORA-01036 Error When Upd/Ins/Del from Gridview
David R. Longnecker - 10 Jan 2006 5:56 PM - 11 messages
I'm migrating existing ASP 3.0 web applications to C#/2.0 and have run into an error that has stumped me.  The Gridview is designed to replace an old-fashioned loop through a database that writes out textboxes of user ...
Score DB Connections Remain Open After Application Requests Close
EagleRed@HighFlyingBirds.com - 10 Jan 2006 5:06 PM - 9 messages
I have written several ASP.NET applications and web services that open ADO.NET connections.  I rigorously follow the following programming construct. SqlConnection sqlConn; try {    ...     sqlConn.Open();    ... } catch(Exception err) { } finally {    if (sqlConn.State == ConnectionState.Open) ...
Score Forms Authentication stopped working for .htm/.doc extensions in 2.0!!
Jay Balapa - 10 Jan 2006 4:49 PM - 1 message
Hello, I posted this under security and there were no replies. We have a website running ASP.Net 1.1 using forms authentication and even protects .htm/.doc files. We have associated such files to ASP.Net in Application Settings. ...
Score Sql Sevrer not updated after copying DataRows
Brandon Olson - 10 Jan 2006 4:12 PM - 5 messages
Hello all, I am trying to import a tab delimited text file with 80 columns and 1700 records into a SQLExpress database using vb.net.  Here's how I am doing it: Dim i as Integer = 0 ' Counter Dim da as New OleDbDataAdapter("SELECT * FROM [format1.txt]", ...
Score Getting values out of the datatablereader
kaushas - 10 Jan 2006 3:46 PM - 2 messages
This should be a no brainer but I not sure what is going on. I must be missing something  (VS2005, C#, ADO .Net 2.0) Here are the steps 1. Created a DataTableReader from an existing dataset (used in the combox) ...
Score open new page when download PDF/help
bbulsara23 - 10 Jan 2006 1:15 PM - 5 messages
Hi, this has been asked so many times before but I cannot get an answer that works. So I'm asking again. I am using .Net 1.1 on a Windows XP Pro. What I want is for the browser to display a PDF "inline" in the browser ...
Score Simulate UpdateBatch in .Net 2.0
Steven - 10 Jan 2006 9:30 AM - 1 message
All, We are converting a large vb6 application towards .Net2.0. Because of the scale of the application we are doing an automatic conversion, total code coverage upgrade. The problem we keep kicking into is the updatebatch of a recordset. ...
Score TableAdapter Garbage
Mark Olbert - 10 Jan 2006 4:21 AM - 21 messages
First, a brief flame: I am quite upset with Microsoft for destroying, hiding or constraining a lot of very useful features in the .NET Framework v2 that used to be in v1.1. Guys, I really don't appreciate you making me learn a bunch of stuff in order to do tasks that were >>solved ...
Score adapter.fill and progress bar
Rain County - 10 Jan 2006 1:50 AM - 13 messages
When I initialize my app, I put up a "splash" screen with a progress bar while the app fills its datasets.  The fill takes longer sometimes than it does other times.  Is there anyway to measure/determine the progress of the ...
Score Weird IDbCommand.Parameters[] design?
Massimo - 10 Jan 2006 12:26 AM - 3 messages
I'm trying to build a DB-independent application using Visual Studio 2005 and the .NET Framework 2.0; I'm not using stored procedures, so I'd like the application to not rely upon a specific DBMS. I created a Factory class which instantiates DB-specific classes, and ...
Score Cannot perform '=' operation
burtamus - 9 Jan 2006 11:12 PM - 5 messages
I have a simple App set up for testing. I read in a CSV file into a DataTable. Then I cycle thru integers from 100,000 to 99,999,999 and use the following to see if that number exists in my DataTable: ...
Score Close - No Dispose - Memory Leak?
darren.pruitt - 9 Jan 2006 9:43 PM - 13 messages
I am working with a large legacy ASP.NET application that does not (in my opinion) properly close or dispose of its ADO.NET objects (connections, commands, transactions, etc.).  The web site is under heavy load so database objects are being created like mad. ...
Score SQLDataAdapter.Update exception reporting
Feng - 9 Jan 2006 9:11 PM - 3 messages
I am trying to use some code example from MSDN like the following: Try SqlDataAdapter1.Update(DataSet1User21, _   "Shippers") PopulateGridFromDB() Catch ex As Exception ... But for some reason it doesn't work for me this way. Each time an error ...
Score How to create a dataset from XML for use in Crystal Reports
Kirk - 9 Jan 2006 8:49 PM - 6 messages
Hello, I have an app that reads & writes to XML files.  I now would like to create some reports using Crystal Reports, and the usual way I do this is by creating a dataset in Visual Studio & inserting the fields ...
Score SQL Server visual design tool
kcamhi - 9 Jan 2006 7:57 PM - 4 messages
Sorry for the beginner question... But are there tools in SQL Server or 3rd party tools (for converting Access users) that are: 1. Like the Access "relationships" tool -- that lets you see all your tables and drag and drop relationships ...
Score custom field in DataTable for listbox binding
wesbird - 9 Jan 2006 7:05 PM - 4 messages
Hi:   I have a dialog in WinForm with 2 list box, source and destination, and 4 buttons, add, add all, remove and remove all. So user can add single/all items in source list box to destination one. so as remove and remove all ...
Score VS2005 - random SQL
William Buchanan - 9 Jan 2006 5:08 PM - 7 messages
Hi folks I want to make an app which will run any SQL entered by a user on any db. How can I do this using the new data features? In VS 2003 I could have dragged an SQL connection etc onto my form, but this ...
Score properties.settings from other project
SimonV - 9 Jan 2006 4:07 PM - 3 messages
Hi, How can I use a connectionstring (or an other setting) that's set in an other project in the same solution? I've already referenced the other project .Properties, but that doesn't seem to be sufficent. I'm using c# 2005 ...
Score DataSet Designer not generating classes
Roy - 9 Jan 2006 3:41 PM - 2 messages
I'm attempting to generate a TableAdapter for a stored procedure in my Sql Server 2000 data source. DataSet Designer generates most of the TableAdapters ok, but for several of them, DataSet Designer does not generate all the classes. For example, The ...
Score Cast exception error
Kajal - 9 Jan 2006 12:35 PM - 1 message
Hi, Can anyone pls help me, I am getting Cast  error as follows: "System.InvalidCastException: Specified cast is not valid. at System.Convert.ToInt32(Object value) at System.Data.Common.Int32Storage.Set(Int32 record, Object value) at System.Data.DataColumn.set_Item(Int32 record, Object value)Couldn't ...
Score Update problem with decimal value
Andre Botelho - 9 Jan 2006 10:45 AM - 10 messages
Hi there... I am trying to update a dataset with a decimal value (precision 9, scale 4). This is the column in the XML file generated by the DataSet <PERC_DESCONTO>23.0402</PERC_DESCONTO> As you can see the value is 23.0402 but when I update this dataset the ...
Score DataView RowFilter with dates (add n days to date)
Kjetil Klaussen - 9 Jan 2006 8:34 AM - 1 message
Hi, I have a DataView containing (among other things) two columns called DATE (DateTime) and EXPIREINDAYS (Int32). Is it possible to filter rows from the DataView based on whether rows are expired or not? The way I’ve tried to do ...
Score DateTime parameter keeps seeing string even though not passed
jonefer - 9 Jan 2006 7:05 AM - 6 messages
I have code that works fine if there is a date to feed the parameter... if there isn't... It seems as though I've trapped the parameter from even presenting itself with: If Len(sGROUP) <> 0 And Len(sSGR) <> 0 And FROMdt <> "" Then... ...
Score finding data in dataset
VB Programmer - 9 Jan 2006 4:45 AM - 4 messages
I am using VB.NET 2005. I just filled a dataset from an XML webservice. Here is a snippet of the data.... <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1"> ...
Score Where do I search Archived Listings for this NewsGroup
N G Sanya - 9 Jan 2006 4:24 AM - 2 messages
Where do I search Archived Listings for this NewsGroup. Is there a web enabled version ? In specific I am looking for a posting done on 2004/5/30 ...
Score Clarification of an example
jonefer - 9 Jan 2006 2:01 AM - 4 messages
The following example from "MURACH's VB.NET database programming with ADO.NET" seems to be missing something: particularly a type for ('As Vendor'?? ) Maybe someone can help clarify what I need to make this work. This example demonstrates how to create a VendorDB class with the following ...
Score DataTable and DataGridView
Ilya Dyoshin - 8 Jan 2006 5:35 PM - 9 messages
There is a problem: I'm writting a client for use with various ODBC drivers. There is a function: System::Data::DataTable ^buildTable(System::String ^sqlQuery) which builds new instance of DataTable based on the results of sqlQuery. The table name is "noname". ...
Score Newbee - upgrade from vb6-ado to .net ado
Frank - 8 Jan 2006 12:46 PM - 5 messages
Hi, in the vb6 version of ado it was possible to navigate through the recordset by using .movenext etc. Is this still possible using .net ado in the same way as the vb6 version? Thanks, Frank ...
Score VS 2005 Pro and VWD
Andrew Robinson - 8 Jan 2006 12:03 AM - 3 messages
My main dev machine has WinXp and VS2005 (pro). 1. I need to install VWD so that I can do some instruction on this. Any issues with both on the same machine. Installation order? 2. Does VWD support the idea of Solutions? I coun't figure out how to create ...
Next »