Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Deleting a Row from Datatable and from Database
CMC - 29 Apr 2006 11:23 PM - 2 messages
Hi, I've a Datagridview binded with a Datatable. With this code: DataTable.rows.remove(current_datarow) DataAdapter.update(datatable) .... I manage to delete the row from the DataTable, it disapears from the DataGridView, but it doesn't delete it from he database (after updating the ...
Score Built-In JavaScript-Rendering Functions
Alex Maghen - 29 Apr 2006 9:15 PM - 4 messages
Hi. What's the most elegant way, in ASP.NET 2.0, to cause certain client-side things to happen without writing my own JavaScript? Here are some of the things I'd like to be able to do... * When I'm finished doing stuff in Page_Load(), I'd like the cause the page ...
Score Urgent:Newbie:Autoincrement violates foreign key con1straints
al - 29 Apr 2006 5:39 PM - 9 messages
Hi, I'm reading an xml file into a dataset and entering the data into an SQL server express database. I've got an employee table (empid as primary key) and an employee photo table (empid as foreign key) My xml file contains an employee element and multiple employee photo ...
Score DATAGRID PROBLEM
Savas Ates - 29 Apr 2006 11:32 AM - 2 messages
First When I Bind my datagrid It returns --Unisex-- value for my GENDER_NAME field. When I click Edit , Write UNI to update UNÝSEX value and Click Update button i catch UPDATE TBL_GENDER SET GENDER_NAME='Unisex' WHERE GENDER_ID=1 ...
Score Read cvs File Fails
rob - 29 Apr 2006 7:39 AM - 7 messages
I am using Odbc to read cvs files. Unfortunately, some cvs files are not formated correctly (out of my control). One particular problem is that a quote within an item is not put in double quotes, i.e. the file ...
Score DataTable, SqlDataAdaptor and updating deleted rows (v1.1)
Chris Chilvers - 29 Apr 2006 6:25 AM - 1 message
Here was a scenareo I came across recently. I was using a table adaptor to handle syncing the changes from a client machine to a server. These would run stored procedures on the sql server to update the data as depending on certian ...
Score VB 2005 & SQL
Tony K - 29 Apr 2006 4:34 AM - 2 messages
I am trying to write a VB.NET 2005 app using a similar setup of the infamous Northwind DB.  I am using SQL 2005 Express on my laptop and will eventually upgrade to SQL 2005. My tables consists of: ...
Score Calling DB2 Stored Procedure with Parameters
jdhavo - 28 Apr 2006 2:03 PM - 1 message
Has anyone ever called a DB2 stored procedure using the .Net OleDbDataAdapter and passed parameters to the stored procedure? Can you give an example? Thanks in advance. ...
Score How do I create a stand alone Dataset by ADO.NET?
Zoo - 28 Apr 2006 8:48 AM - 4 messages
Hi,All. I have the code written below which runs on VB6 and ADO. And I want migrate this onto VB.NET 2003 and ADO.NET. Could anybody give me a sample? Dim Rs As New ADODB.RecordSet With Rs ...
Score Develop your own Accounting software using Microsoft technologies
ammulu - 28 Apr 2006 3:30 AM - 1 message
Hi All, New title for Mastering Web Application Development. All secrets of developing an Accounting Software for the web revealed. Title: "Develop your own Web Accounting Application using ASP.Net" Price: $19.90 Pages: 300 ISBN:81-901331-3-6 ...
Score DataSet changes schema of XML file.
MaLec - 28 Apr 2006 2:21 AM - 1 message
I’d like to use the DataSet as the container for the XML files conforming to some schema. The problem is, that the operation of reading the XML file into the DataSet having its schema and then writing it back to the file makes it ...
Score Populating typed datasets WITHOUT tableadapters
Chris Smedley - 28 Apr 2006 12:21 AM - 16 messages
Typed datasets are great, but in one respect, the move to use table adapters is a double edge sword. What I would like to be able to is to use the old fashion ds.tables() components to be able to iterate through each of the tables in  the typed ...
Score Adding collumn collation to a table in a data set
Fiddelm3742 - 27 Apr 2006 7:11 PM - 3 messages
So, here's my new issue.  When I add data from my external datafile to my data table in my dataset I get an error on one of my columns because it thinks i have duplicate values (happens to be my PK of my table) in this ...
Score Changing from DropDown to DropDownList
Marty - 27 Apr 2006 6:27 PM - 3 messages
Why does my field not save when I change the control from DropDown to DropDownList? I used the data from wizard. Thanks. ...
Score Strongly Typed ConnectionString keeps disappearing
Aziz - 27 Apr 2006 3:53 PM - 4 messages
VB 2003, Access 2000 I have been using strongly typed Datasets/database connections, it works fine Now, I've added a OpenFileDialog functionality to my program so the user can select the database file. I've added & strCon &  to this code (it's a Global variable): ...
Score combobox binding problem
Fanor - 27 Apr 2006 2:34 PM - 4 messages
I have a combo box bound to a binding source wich is bound to a table. For some reason the selectedvalue of the combo box doesn't show the correctt value of the row the first time the form is showed. When I move to the next ...
Score heirarchical recordsets
steven scaife - 27 Apr 2006 1:19 PM - 2 messages
I am converting my ASP sites to asp.net, one of the sites uses heirachical recordsets and i was wondering what the equivelant is in ado.net Also if there any sites with examples that i can study regards ...
Score !!!HELP!!!! Errore while debugging a solution
Marco - 27 Apr 2006 1:16 PM - 1 message
Hi, I've create a simple solution into my pc that read some data from an Access DB and send them via WebServer to another DB. When I try to include a WebService into my solution and run it in debug ...
Score How to open files automatically after download?
ad - 27 Apr 2006 11:56 AM - 7 messages
I used the codes below to send a Excel file form Web Server to client. The file is save to client's disk after download. How can I open the file automatically after saving it? //////////////////////////////////////////////////////////////////////////////////////////////////////////////     MemoryStream sm= new MemoryStream(); ...
Score Using Visual Studio & datagrid to select from sql server view
gfarrell - 27 Apr 2006 6:36 AM - 1 message
Hi, I noticed another post similar to this, however I could not get my issue solved. I am using a datagrid, dataset and dataadapter to retrieve data from a database view. I have done this successfully with tables and also ...
Score vb_2005_rowfilter_mit_den_10_letzten_datens=E4tzen
Georg - 27 Apr 2006 4:11 AM - 3 messages
hallo leute ich hoffe ihr könnt mir weiterhelfen. ich möchte (muss) einen rowfilter bauen für die letzten 10 datensätze meiner datenbank. wie kann ich das hinbekommen? grüße georg ...
Score framed
barret bonden - 27 Apr 2006 1:43 AM - 5 messages
A client of mine has a young man who has written a web app (a CRM in dot.net 1.1) using many frames .it looks good , but is hard to maintain, passing, as it does, parameters from one frame to the next. These parameters allow the ...
Score ExecuteReader returns closed DataReader
PIEBALD - 26 Apr 2006 6:04 PM - 3 messages
Using .net 2 and Sql Server 2005, I am intermittently getting the exception: Invalid attempt to FieldCount when reader is closed. What I don't understand is how the DataReader could be closed when it was just created by ExecuteReader. ...
Score foreach behavior changed in Framework 2.0
Rich Wood - 26 Apr 2006 5:26 PM - 3 messages
I have the following code in a C# project: DataView dv = new DataView( dsModels.Tables[_INDVARS_TABLE_NAME], "", "", DataViewRowState.CurrentRows); foreach ( DataRowView drv in dv)      drv.Row.Delete(); This code worked fine in VS 2003 (Framework 1.1). However in VS 2005 ...
Score problem with no rows being returned - but rows are there
Marina Levit [MVP] - 26 Apr 2006 5:13 PM - 23 messages
Hi, It seems that this issue is occurring at several client sites, though never in house. At some point, some (all?) queries run by our software start returning no rows. But the rows are there in the database - and restarting IIS (this is a ...
Score Problems Using datasetObject.DefaultView for filtering and sorting.
Gary Rynearson - 26 Apr 2006 4:41 PM - 3 messages
I am using c# and VS2003 (.Net v1.1). I am trying to filter and / or sort a dataset and print out the results as shown below.  I have seen several examples of using the DefaultView for the table, but the results were sent to a UI control's datasource property. ...
Score Access 'Database In Use' Problems (also posted in microsoft.public.access)
ChrisM - 26 Apr 2006 11:17 AM - 1 message
Hi, Apologies for posting the same message in 2 different newsgroups, but I didn't know about this one until after I had already posted in the Access NG. Any complaints to rubbish***@junkyRubbish.com  ;-) Anyway... I have a dotNet, C# application with about 10 users (Windows Forms, not ASP) ...
Score Conenctivity to Interbase Database
SSUK - 26 Apr 2006 11:10 AM - 7 messages
Greetings to all. How can we Perform database operations on INTERBASE using MS .NET 2005? We want to Insert few records on an existing INTERBASE Database using MS.NET ,how it’s possible ? Thanks for your support & time. ...
Score Transactions isn't rolled back, when using connecction pooling
Lars Berg - 26 Apr 2006 9:36 AM - 4 messages
I have a asp.net (1.1) Web Application. Connection pooling is on From that webapplication I execute this SQL with a commandtimeout of 10 seconds "BEGIN TRAN UPDATE XYZ set column1 = '3PU' where iid = 1234 WAITFOR DELAY '00:00:15 ...
Score Saving Changes To DataSet in memory (without updating Database)
Aziz - 26 Apr 2006 9:27 AM - 3 messages
Hello I have a system where a customer can order a metallic alloy product that is made from a variety of base metals. Every time the customer adds an alloy to their shopping list the system works out how much base metals are needed are deducts the relevant amount from the ...
Score DataNavigator AddNew problem
marknotgeorge - 26 Apr 2006 9:26 AM - 1 message
I have a form in my c# application for adding the details for a car (it's a car restoration database). This form has a DataNavigator, and it also has a GroupBox which has controls to allow the user to add images to the database. This groupbox ...
Score Gridview returns old value of gridview.rows.count!
MC - 25 Apr 2006 11:38 PM - 2 messages
I have a label that shows the number of records returned by my gridview.  So after gridview ondatabound event I check to see if the gridview.rows.count > 0, and if true then show row count in label but ...
Score Create empty datatable from SQL Server table?
David Tilman - 25 Apr 2006 10:54 PM - 2 messages
I'm using C# in Visual Studio 2003 and would like to create an empty datatable in my dataset based on a SQL Server table. I basically want to use the metadata of the SQL Server table without loading any data into my ...
Score Getting Datarow from BindingSource
Andrew Oliner - 25 Apr 2006 10:08 PM - 3 messages
What's the best way to edit the Datarow which is referenced by BindingSource.Current? ...
Score Addnew creating two records?
Andrew Oliner - 25 Apr 2006 10:05 PM - 3 messages
Hi, I have a SQL Server 2000 database with an Identity Column called IssueNum which auto-increments each time a new record is created. I'm using the ADO.net 2.0 tools, a BindingSource and a BindingNavigator. When I click on the AddNew button on the Binding Navigator, it adds two ...
Score Compare Datarows
Toco - 25 Apr 2006 6:37 PM - 3 messages
Hello.  I have in dataset, two datatables.  Each table has only two columns.  What I wish to do is to compare 1st table to see if the datarow can be found in 2nd table.  For example, lets say we are comparing student last name and ...
Score CommandBehavior.SingleRow
Justin - 25 Apr 2006 6:07 PM - 2 messages
As far as performance is concerned, is it more efficient to set SqlCommand.ExecuteReader(CommandBehavior.SingleRow) when you are only dealing with single row? Thanks ...
Score Excell
Charles A. Lackman - 25 Apr 2006 5:59 PM - 1 message
Hello, I have opened an excel file into a .net application and any trying to determine if column 1 is a checkbox or not.  Spreadsheet column 1 has both Text and Checkboxes.  This is what I have tried to far with no success: ...
Score DbCommand against Oracle fails with string parameters
doug.setzer - 25 Apr 2006 5:47 PM - 3 messages
I have this code: Dim cmd As DbCommand = Me.Factory.CreateCommand()    '** this is a valid OracleFactory object Dim param As DbParameter = Nothing Dim sql As String = "" sql = "SELECT ard.*" & Environment.NewLine & _     "FROM MyTable ard" & Environment.NewLine & _ ...
Score ADO.NET and Excel
rguarnieri - 25 Apr 2006 5:33 PM - 3 messages
Hi!!, I need to populate an excel sheet with a query, some people says that I can use CopyFromRecordset to do that but I need to add a reference to an ADODB.Recordset, my question is, le ADODB library is ...
Score ContextSwitchDeadlock
OldButStillLearning - 25 Apr 2006 4:21 PM - 5 messages
Hello, I am getting this "ContextSwitchDeadlock" error message pop up in situations where I am doing a Data Reader loop, where I am processing about 40,000 records.  For each record read via the data reader, I am creating ...
Score Converting between RowViews & Rows
Ant - 25 Apr 2006 2:45 PM - 3 messages
Hi, I'd like to use a typed row to iterate through a DatarowView array. I've used a view for its FindRows method. How (or where) can I cast this so that the rows & rowViews will work together. I've tried converting them in various places without success: ...
Score How to find out the "GUID" of installed assembly?
Alvaro E. Gonzalez - 25 Apr 2006 2:23 PM - 5 messages
Hi; How to find out the "GUID" of installed assembly? Tks. Alvaro ...
Score Dynamic dataset filter
rpoole - 25 Apr 2006 11:53 AM - 1 message
Situation: Vb .net windows application SQL 2000 Database I have a flat "customer" table on a database and wish to design an application which behaves similar to itunes, so that the table can be filtered. For example instead of "genre" I want a list of "customer ...
Score Architecture question
Pavils Jurjans - 25 Apr 2006 11:24 AM - 1 message
Hello, I've come to a question, that seems to be more architecture-oriented, but it also has some performance issues. So, I have the class that is sort of "master" of operation - the applications would first instantiate this master class, and then all the work will be ...
Score Two DropDownList controls inside one DataGrid cell
glenn - 25 Apr 2006 11:22 AM - 2 messages
Hi folks, I have two code test samples that I am trying out.  I want to have two dropdownlist controls.  The first ddl is databound with a list of company names.  The second ddl is databound with a list of contact names that reside ...
Score Access File Lock
Geoff Murley - 25 Apr 2006 11:01 AM - 5 messages
I am trying to run a simple VB.NET application using an Access 2000 database as the OLEDB datasource directly from a CD.  I have set the Locking mode = read.  When I autorun the application from the CD I get the error message ...
Score Displaying data from 2 tables in one datagridview
Lars E. - 25 Apr 2006 8:53 AM - 4 messages
Hi all. i am trying to display contents from 2 tables in one datagridview. It is not possible for me to do a join, so i have to combine 2 datatables to be able to show data from both tables. ...
Score Dataset converting date field accross time zones...
Subrata - 25 Apr 2006 5:44 AM - 5 messages
I need help wrt to the dataset converting the date (time) when passed from a web server to a client, both on different time zones. Lets assume that the Web Server is in NYC(EST). The client is in SFO(PST). ...
Score SQLSummit.com middleware lists: .NET data providers, ODBC drivers, OLE DB providers, XQuery engines,
Ken North - 24 Apr 2006 11:03 PM - 1 message
There's been an update to the middleware lists at SQLSummit.com, including the list of .NET data providers. The JDBC and ODBC driver lists have been partitioned for faster web page loading. The pages are in alphabetical order by vendor, author or project name. ...
Score odbc & stream & excel file
rob - 24 Apr 2006 6:56 PM - 2 messages
I have to read a csv file. In order to avoid all the hassle with the parsing (some items are in quotes, others are not, some have quotes/comas in the items themselves, etc) I simply use odbc. The code ...
Score table versioning
Zen - 24 Apr 2006 6:07 PM - 3 messages
Hi, Since I don't know which group would be a right newsgroup to post for this problem and most likely that it would be involved with expertise coming from residents of different  newsgroups, hope multiple-group posting is ok. ...
Score Converting XMLDatadocument for dataset
srinivas - 24 Apr 2006 6:03 PM - 2 messages
Hi, I have to pass XML data to a procedure. I'm having xml data in XMLDataDocument datatype. Now i want to use this XMLDataDocument as an input to the dataset inside the procedure. But dataset.ReadXML accpets only Textreader/Stream/XMLReader. ...
Score DataSet Xml Generation Does Not Honor Format of Supplied Schema
Garrek - 24 Apr 2006 4:14 PM - 1 message
I'm having a problem in which the .Net 2.0 DataSet does not properly nest Xml upon output when using a supplied schema. I've created an Xml schema that I wish to push into a DataSet.  My code then ...
Score DataGrid Update Issue
thebison - 24 Apr 2006 4:06 PM - 1 message
Hi all, I hope someone can help with this relatively simple problem. I am building a timesheet application using ASP.NET C# with Visual Studio 2003.As it is only a protoype application, my database has been made in MSDE. ...
Score Copy a DataTable
roger.cantillo - 24 Apr 2006 3:19 PM - 5 messages
Hi, I'm running code that creates a new datatable based on filtered datatable.  My code uses the Select method to filter the data and loops throw each row to copy its contents to the new datatable.  My question ...
Score .NET Provider for DB2 8.2.1
Rusty - 24 Apr 2006 2:30 PM - 3 messages
Hi, I need to access a DB2 8.2.1 server on AIX64.  Normally we access SQL Server, but I'd like to go directly to the DB2 server with a web service if possible. 1) is there an IBM .net data provider?  if yes, is this the way to go? ...
Score Listbox / Combobox with multiple fields as displaymember
Sergio Torres - 24 Apr 2006 1:14 PM - 6 messages
I need to populate a combobox and/or a listbox with several fields as displaymember. Both controls allow only one field as displaymember. I need the display member to look like this (the columns should be left aligned), where each columns represents a field in the underlying datatable: ...
Score SQL XML Bulk Load VB Web Service Error
Andy Hunt - 24 Apr 2006 12:30 PM - 1 message
Hi, I am having a problem with SQLXML Bulk Load inside of a web service ( also inside of a basic aspx page).   I have a WebMethod in a web service that makes a call to bulk load.  This works perfectly on my local test machine (it ...
Score Get SQL statement in a catch(SqlException)
martijndemunnik - 24 Apr 2006 11:42 AM - 7 messages
I'm debugging an application using log4net. When a SQL statement fails it is logged. One of the messages is Line 1: Incorrect syntax near ')'. but I'm not sure which SQL command is executed. Can I get the complete ...
Score add row in binded datagridview
Clamara - 24 Apr 2006 10:56 AM - 4 messages
Hi, help me please for this issue: I have a master-details form binded to "Order" and "OrderDetails" A datagriedview is binded with the details. I want to fill the datagridview with a result of a query with fields that ...
Score Updating Row value when PK is known
Aziz - 24 Apr 2006 9:21 AM - 7 messages
I am using VB.NET 2003 I have a simple Dataset DataTable (call it StockLevels) such as this: BaseMetalCode (PK)        BaseMetalInStock Ag                                   1000 ...
Score Evaluating a condition in a string
Satya - 24 Apr 2006 7:27 AM - 3 messages
Hi All, I have a scenario as below. I have a data row like AcctNum    CheckNum    Amt    Payee        Date 9999999    125699    10370.25    ABCD...XYZ    04/24/06 ...
Score Catching exception of System.Data.OleDb.OleDbException type
Nits - 24 Apr 2006 4:32 AM - 6 messages
Hello All, I wanted to know what kind of exceptions will be catched in the class type of System.Data.OleDb.OleDbException I was expecting the database constraints violations errors will fall into this type of exception handling, but it doesnt seem so. And if it cannot catch ...
Score returning SCOPE_IDENTITY() in Insert command with C# DataSets
Gus M - 23 Apr 2006 11:53 PM - 7 messages
Hi, I've got a bit of a problem, and from what I've read on here it should be very easy but I just can't get it to work. I've got a dataset of my table, and using a tableadapter I've created a ...
Score VB.NET create JET database without ADOX
Dan Hinsley - 23 Apr 2006 10:50 PM - 7 messages
I'm converting an app over to VS 2005, and am trying to get rid of all the external references possible.  I use JET to create a database. Before I used the ADOX.Catalog function to do this.  I assume that ...
Score DataBound DropDown List
thebison - 23 Apr 2006 4:34 PM - 2 messages
Hi all, I hope someone can help with this relatively simple problem. I am building a timesheet application using ASP.NET C# with Visual Studio 2003.As it is only a protoype application, my database has been made in MSDE. ...
Score Select where in
Sreppohcdoow - 23 Apr 2006 3:32 PM - 6 messages
Is there a way to select to find multiple conditions? I.e., in SQL, you can typically SELECT from myTable where someColumn in ('x','y','z') instead of passing in explicit strings, I'd like to pass in an array of ...
Score Impersonation with VB.net 2.0 and SQL 2000 help needed
Backwards - 23 Apr 2006 3:26 AM - 6 messages
Hey everybody I'm having a little trouble getting access to a few commands in our 65 odd SQL databases. Have had a chat to our DBA's and they wont give my windows account access and they also wont give me a SQL login in order to run these ...
Next »