Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score xml xsd filling question
NS - 4 Nov 2006 4:32 PM - 2 messages
Hello, I have a XSD that looks like this: <xs:schema id="FlowInfo" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified"> <xs:element name="FlowInfoRoot"> ...
Score How to change TableAdapter CommandText at runtime
SWheaties - 4 Nov 2006 3:14 AM - 3 messages
I have a GridView, which is bound to an ObjectDataSource.  The ObjectDataSource.TypeName points to a TableAdapter, and the SelectMethod points to one of the methods.  My goal is to be able to change the SQL statement at runtime so I don't have to write a ...
Score #temp table not recognized when sqlcommand has parameters
Rich - 3 Nov 2006 10:13 PM - 2 messages
Dim da As New SqlDataAdapter("select * into #temp1 from tbl1 where ID = 9", conn) conn.open da.selectcommand.commandtext = "select * from #temp1" Dim dr As SqlDataReader = da.selectcommand.executereader works OK ---- But Dim da As New SqlDataAdapter("select * into #temp1 from tbl1 where ID = ...
Score System.Data.OracleClient.OracleException: ORA-01041
luke_airig - 3 Nov 2006 9:31 PM - 3 messages
..NET Framework version: 1.1.4322.2032 Oracle 9i version: 9.2.0.5.0 I am a developer supporting a C# .NET application accessing an Oracle 9i database using Microsoft's System.Data.OracleClient.dll with a 2003/2/21 file timestamp. ...
Score FilterExpression with sub-select
David - 3 Nov 2006 8:32 PM - 2 messages
I have the following code to set a SqlDataSource FilterExpression and it is giving me an error "Syntax error: Missing operand after 'CompanyID' operator."  Can anyone tell me what is wrong?  I do have the operator IN. Thanks. ...
Score can ado.net query a #temp table in sql server?
Rich - 3 Nov 2006 6:42 PM - 4 messages
Hello, If I say this: Dim cmd As New SqlCommand("select top 10 * from tbl1, conn) conn.Open() Dim reader As SqlDataReader = cmd.ExecuteReader() everything is OK.  But if I try this: Dim cmd As New SqlCommand conn.Open() ...
Score UnInspected Items Report!!
Jay Balapa - 3 Nov 2006 5:17 PM - 4 messages
Hello, I have two tables- TBLINSPECTION with the following fields- BARCODE  ITEMTYPE PASS DATEINSPECTED 1000                    x         YES  01/12/2006 ...
Score Getting Error -3016 from ODP.Net
Terry - 3 Nov 2006 4:11 PM - 1 message
All: I'm attempting to write a value into a Blob. The database is Oracle 8.0.6, and I've installed the ODAC 9.2.0.7.0. I'm calling this from an ASP.Net v1.1 web service. ...
Score Problem with transaction error
Chukkalove - 3 Nov 2006 3:00 PM - 2 messages
{"Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction.  The Transaction property of the command has not been initialized." } I am noob sqlserver user of 2 days. We're migrating to sql server server ...
Score Transaction not created. Do i need to configure my database?
Chukkalove - 3 Nov 2006 2:36 PM - 2 messages
In the following edited code sample my transaction instance is being returned as null after Connection.BeginTransaction(); The database server Im using at the moment is an evaluation version of SQL Server 2005 while Im waiting for the real one to be delivered. ...
Score RE: Internal connection fatal error
Ananth - 3 Nov 2006 12:50 PM - 1 message
Hi All I am also facing the same problem " Internal connection fatal error" . Angel Saenz-Badillos do you have any update. how to resolve this. Thanks Ananth.G From [link] Posted via DevelopmentNow.com Groups [link] ...
Score Server Explorer Components?
ARTMIC - 3 Nov 2006 1:38 AM - 3 messages
Hello, how can i change the default controls that appear on a webform when i drag a table or field from the Server Explorer? I have some 3rd party components that i wish to use instead of the default grids/edits that VS2005 ships with... ...
Score Paging recordsets in ado.net
crbd98@yahoo.com - 3 Nov 2006 12:47 AM - 8 messages
Hello All, I am porting a ado application to ADO.NET and facing some challenges. In particular, we have some client side views that need to display large recordsets in a grid. The approach uses a server side cursor combined with a  predefined cache size that accomodates to allow for ...
Score database name in SqlException?
bdgreen - 2 Nov 2006 11:07 PM - 5 messages
Hi, I searched around in SqlException, but couldn't find the name of the database in question after catching a SqlException. It isn't SqlException.Server, which has the database *server* name.  Anyone know where I can find the database name? ...
Score SQL CLR and errors
Smokey Grindle - 2 Nov 2006 8:51 PM - 1 message
I have a SQL CLR .NET stored procedure, I need to report back an error code if something goes wrong, how would I do that in SQL CLR? I know RAISE ERROR in T-SQL but is there a specific way to do it in SQL CLR Procedures? Also ...
Score Excel Range to DataTable and Vice Versa?
TCook - 2 Nov 2006 6:46 PM - 4 messages
Hey All, Using a range object, is there a quick way to blast the data into a datatable? For example, using a range object, one can dump the data to an array.  Is there a way to do something similar with a range object and a datatable? ...
Score Tableadapter insert return value
J055 - 2 Nov 2006 5:31 PM - 2 messages
Hi When I do an insert using the update(datatable) method I can get the new identity but when I do an insert directly with the Insert method I can only get the record count because the InsertCommand uses ExecuteNonQuery. ...
Score Tableadapter insert return value
J055 - 2 Nov 2006 5:28 PM - 1 message
Hi When I do an insert using the update(datatable) method I can get the new identity but when I do an insert directly with the Insert method I can only get the record count becuase the InsertCommand uses ExecuteNonQuery. ...
Score This row already belongs to another table
rmontgomery429 - 2 Nov 2006 4:41 PM - 4 messages
Hello all,      I am using strongly typed datasets for my data access. They work fine except for when I try to insert a new row in a table to get the next unique id. I have a table for emails. It has columns like ...
Score Binding.Format not alway being called
Joe - 2 Nov 2006 4:28 PM - 3 messages
I have a DataBind() method which binds my controls to my business object. There are times we changes the object without closing the screen and call DataBind() again. DataBind() calls DataBindings.Clear() and each control which I bind to before I reset the bindings. ...
Score dataadapter.Update() multiple table update strategies
jarb - 2 Nov 2006 1:00 AM - 4 messages
Im not sure how to proceed on this one... I have a dataset with one table being populated by a complex join from several tables. Basically a fancy SELECT statement. Designer doesn't support generating a dataset from a query like this (right?) so I hand created the dataset and the ...
Score error when adding column to datatable: There is no row at position
svbridget - 1 Nov 2006 11:30 PM - 5 messages
Since upgrading to the 2.0 framework I am getting an error that was not present in 1.1.  I have a grid that is bound to a DataView, which was initialized with a DataTable.  I set up the initial rows & cols in the ...
Score What's causing ADO error: "Concurrency violation: the DeleteCommand affected 0 records"
sherifffruitfly - 1 Nov 2006 11:06 PM - 4 messages
Hi, I'm deleting a bunch of records from my DB, and they actually DO get deleted (as I verify by looking afterwards). But then I get the exception in the subject line. Isn't it weird that all of the correct ...
Score Could not find a property named '... ' on the type specified by the DataObjectTypeName property in O
Anabela Silva - 1 Nov 2006 7:08 PM - 3 messages
To anyone who has experienced this problem! Could not find a property named '... ' on the type specified by the DataObjectTypeName property in ObjectDataSource '...' I've been looking at forums about the problem that devellopers have in using ObjectDataSource when trying to update or delete a record. ...
Score Readonly Datatable
Charles Zhang - 1 Nov 2006 6:11 PM - 10 messages
I have a "static" datatable in a class and the datatable is loaded by the type constructor. I want to make the datatable as read only, is it possible without using events to rollback the changes? Thanks Charles Zhang ...
Score DropDownList Refuses To Show New SelectedValue
Nathan Sokalski - 1 Nov 2006 5:18 PM - 4 messages
I have a webform that contains a DropDownList. When the user selects a new value and I click the submit button, the previously selected SelectedValue property is used in my code. This is obviously preventing me from updating my database, or even allowing the user to do anything that involves the ...
Score DataViewRowState filter not working
CNHS - 1 Nov 2006 4:38 PM - 3 messages
I am trying to compare the original value of a specified column to its new modified value, using the DataViewRowState filter. However, both the original value and the new value are returning the new value. Can anyone figure out what I am doing wrong? ...
Score Cannot find custom tool 'MSDataSetGenerator' on this system
ianvink@gmail.com - 1 Nov 2006 5:55 AM - 3 messages
After installing VS2005.net 's SP1 Beta, I get this error when trying to edit dataset XSDs Cannot find custom tool 'MSDataSetGenerator' on this system I also lost all my Custom Tools in the Tools / Custom Tools menu. Any idea how to get them back? ...
Score Beautiful women, aged clones, and Ultimate Fighting Championship
baseballswim - 1 Nov 2006 12:23 AM - 1 message
Friend, I'm always looking for good and intelligent individuals like you to visit my website, [link] , and it has pictures of beautiful women, information about aged clones, and a link to Ultimate Fighting Championship, a very good show. ...
Score insert initial row in dataset
MarkAurit - 31 Oct 2006 11:10 PM - 2 messages
I have a DataSet I will be writing out to an excel file, and first Id like to insert (at the top) names of the Columns.  I want to put the names in an xml file to make them easily configurable, so I was wondering if it was possible ...
Score Query Analizer vs ADONET
Patriot - 31 Oct 2006 8:17 PM - 10 messages
I have a stored procedure. If I run it using Query Analizer, it takes no time to return the result (max 2 records, 7 columns and approx. 15 bytes/record) However, If I execute it from ASPNET Code (see below), it takes approx. ...
Score Tip on filling DataSet in C#
Martin Arvidsson - 31 Oct 2006 7:18 PM - 2 messages
Hi all gurus out there! When i use the Wizard to create some fields from a table it creates, the dataset, bindingsource and tableadapter. Now for the problem. When i open that form in my program, it automaticly fills the dataset with all the records in the table. In this case there is ...
Score ado vs oledb
Jon Paal - 31 Oct 2006 7:15 PM - 8 messages
what is the difference between oleDB and ADO.net provider  ? ...
Score DataGridView, taking the user back to the last selected row
Sam Carleton - 31 Oct 2006 5:42 PM - 1 message
I have a DataGridView control that is set up as FullRowSelect & MultiSelect.  Each line in the grid is part of a group of lines.  There are times when the user should not be aloud to click on a line of ...
Score Load dataset faster? 45K items in 18 seconds too slow
Chris Bordeman - 31 Oct 2006 5:19 PM - 5 messages
Hi.  I'm using a table adapter to load a table of 45,000 items, is taking 18 seconds, which is waaaay too slow, esp. since this will grow to many times that size very quickly. I'm currently using a TableAdapeter.  Is there a quicker way to load a ...
Score Oracle connection string
adodotnet20 - 31 Oct 2006 5:17 PM - 2 messages
Hi, I'm trying to connect to Oracle. I'm using the Microsoft OLE DB provider with this connection string: "Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;" How do I specify a server name and a port (I don't have Oracle on my ...
Score Data Paging: How To?
George Shubin - 31 Oct 2006 4:31 PM - 10 messages
I'm working on a windows app in VS2003 whose SQL2005 data has outgrown expectations.  The main data entry form has a grid full of records with a few identifying fields to select from.  As each line on the grid is ...
Score Issue select across multiple SQL Server Databases
twahl - 31 Oct 2006 4:15 PM - 2 messages
This may be a dumb question but... I have an instance of SQL Server 2005 that contains two databases call them DB_A and DB_B.  Is it possibel to issue a query where I am joining a table from DB_A to a table in DB_B? ...
Score Using Transaction Scope
AnikSol - 31 Oct 2006 2:53 PM - 3 messages
Hi, VB 2005 Prof, SQL server 2005, Windows application - I am using transaction scope and within this scope I am passing multiple SQL statements to the command.text On executing, all is well. But noticed that in case there is SQL server time out, then the transaction ...
Score BMB.CurrentChanged gets fired just once or twice?!
Leon_Amirreza - 31 Oct 2006 2:27 PM - 1 message
I have installed a hanlder for this event: this.BindingContext[dataSetCurriculumsCourses, "TableInstitutes"].CurrentChanged ..... void FormCurriculumsCoursesInstitutes_CurrentItemChanged(object sender, EventArgs e) { this.Text += "1"; } at runtime just "11" will appeare in the title bar of the form no matter how many time the current record is changed. ...
Score Strange error when querying FoxPro dbase
Nadav Popplewell - 31 Oct 2006 9:56 AM - 5 messages
Hi Everybody, I've got a dotnet application (1.1) that works with a foxpro dbase (using the oledb provider for FoxPro 8.0). Most of the code works, But I've run across a strange problem: When I run the following sql statement: ...
Score Join Tables in 2 SQL Server Databases
TigerMan - 31 Oct 2006 7:27 AM - 4 messages
Hi, Is there any way I could do a join across 2 tables in 2 separate databases? I want to be able to set the connection string on both databases in vb.net then do a join query in code on the tables in the databases ...
Score Transactions and Scope_Identity
Joe Fallon - 31 Oct 2006 2:31 AM - 3 messages
I use code like this to Insert a row into a table which has an Identity. Notice that a running transaction is passed in to the method as the variable tr. The insert command runs and then next command is SELECT ...
Score problem adding connection in vs 2005 sql 2005 express
djc - 30 Oct 2006 10:32 PM - 3 messages
win xp sp2, vs 2005, sql express 2005 I am having a problem adding a connection (server explorer -> data connections -> add connection) I choose MS SQL Server as the data source, and .net framework data provider for sql server as data provider, then I select my computer name from the ...
Score Regenerate datasets
Earl - 30 Oct 2006 8:49 PM - 3 messages
How do other "regenerate a dataset" and when that term is used, what does it mean? Telling the designer to "generate" a dataset results in a NEW file, which you then have to jerk around to fit into the old structure. An easier ...
Score Checking for Nulls
Vayse - 30 Oct 2006 4:23 PM - 3 messages
Hi Using VB.net 2005. In my xsd file, I set the Null value for a field called Description to "X".However, when I fill the datatable from the access database, if there is nothing in the Description field, it is still ...
Score ASMX not showing webmethod that should return a dataset
Michael Reinhart - 30 Oct 2006 3:41 PM - 8 messages
Hi all... I'm fairly new to buildling web services in .NET 2.0.  Using VB.NET (2005), I'm doing something like this in a webmethod: - instantiating a 3rd party business object (QuickBooks customers actually) - iterating through the collection and adding rows to a DataTable in a DataSet ...
Score Books for database oriented windows applications
adodotnet20 - 30 Oct 2006 4:00 AM - 6 messages
Hi, I need to create an application in C# that will be fairly simple from a UI prospective and that will be able to retrieve some information from a db. The overall look and feel should be nice but not too ...
Score Many-to-many (two parent) databinding
Earl - 30 Oct 2006 2:57 AM - 1 message
Done a lot of reading on this issue, including the post by Bill Ryan, and was wondering if this is as good as it gets. I have quite a few many-to-many relationships in an app I'm currently ...
Score SQLSummit .NET data provider list (other data access middleware lists)
knorth - 29 Oct 2006 8:12 AM - 1 message
The middleware lists at SQLSummit.com includes recent updates to the list of .NET data providers. List of ADO.NET data providers (48 listed) [link] OLE DB providers [link] ...
Score VB 2005 Insert records into multiple tables
AnikSol - 29 Oct 2006 6:14 AM - 5 messages
Hi All, Not sure if this is the right forum to post this! VB 2005 Prof, SQL server 2005, Windows application Scenario: In a winform application, using SQL server authentication method (not windows authentication), we have a text/binary file containing multiple ...
Next »