How to tell if a timeout exception occures

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Strongly typed dataset, sorted by dataview, how to get dataset's row index from dataview? Hello everyone, here's my problem! I'm using the .NET framework v1.1... I've created a strongly-typed dataset class (using XML), and I've instantiated it twice. The first instance is used to hold a mainframe-generated text file. The second instance is used to hold the results from a database query. Unfortunately, the text file uses a combination primary key of (branch ID, account number). However, my database has no need for branch ID- it's driven purely by account number. Of course, I've used SQL to sort my database query by account number. To sort the file's dataset, I set up the DataSet.DataTable.DefaultView.Sort = "account ASC". But in my main loop, the DataRow returned by using DataSet.DataTable.DefaultView[i].Row has lost all of the strongly-typed features that I had gained by defining an XSD class. Is there a method/property that I've missed, which will allow me to walk the objects "backwards" from the DefaultView[i] in order to get the actual source row (with strong typing) from the DataSet? Here's a sample of the structure/main loop and what I'd like to do.: public class otherClass{ //this class belongs to the database operations private MyStronglyTypedDataset dsDatabase; private int iIndex; public bool matchFound(String strAccount) { //loop based on iIndex++ to find match in dsDatabase } public MyStronglyTypedDataset.tblRow foundRow {get...} public void compareXMLds(MyStronglyTypedDataset.tblRow sourceRow) { //compares dsDatabase.mytable.Rows[iIndex] with sourceRow, //and generates report } } public class MainClass { //this is for linking the TextFile's class with the database's class MyStronglyTypedDataset ds = loadTextFileClass.resultingDataSet; for (int i=0; i<(ds.tbl.Count); i++) { //what I need is inside the asterisks below if otherClass.matchFound(ds.mytable.DefaultView[i][mykey].ToString()) otherClass.compareXMLds(**ds.mytable[i]**) } } There must be something in ADO.NET that keeps a link between the DataView's row and the underlying DataTable's row- how do I get to it? I'm wishing for something like: MyStronglyTypedDataset.tblRow sourceRow = ds.mytable.DefaultView[i].getSourceRowBack; It has crossed my mind to create a "temporary" sorted text file based off of the source file... but I'd rather not go that route- it reminds me of my Pascal days! Thanks! -Thomas H Tag: How to tell if a timeout exception occures Tag: 125872
  - 2
    - Datagrid aggregation in each cell Hi, I have a search page which will display the results in a datagrid. The grid's nature is, except the first column, every cell in every row is an aggregate value. The grid will always have the same number of rows and columns no matter what the search criteria is. It's only the values in the cells that change. I'm rewriting the existing application; At present they have the entire calculation is done in the stored procedure and the result of the stored procedure is simply displayed to the user. This approach timesout most of the time. Here's a sample datagrid I'm trying to achieve: CITY ERRORS FAILURES Austin 10 25 Boston 23 2 Chicago 13 16 No City Mentioned 2 3 Total 48 46 Please note there may be different kind of Errors and different kind of Failures. We aggregate all Errors and Failures display the total errors and total failures respectively against each city. In the present DB model, they have a separate table for the city, a table for the event names -(Errors and/or Failures) and a transaction table that links those two tables with the station code and event code. My question is, how much and what can we do in the stored procedure, and what can we do in ADO.NET for the above case? If my question doesn't make sense, please let me know I'll try to rephrase it. Thank you. Tag: How to tell if a timeout exception occures Tag: 125869
  - 3
    - Simple TransactionScope problem, please help This problem is so simple I am surprised it's happening. When I run the following code: using (TransactionScope ts = new TransactionScope()) { SqlConnection conn = new SqlConnection(@"integrated security=SSPI;data source=WSDEV\GODS;initial catalog=MOSES"); conn.Open(); } It waits at conn.Open(); for over 1 minute and return error message "The transaction has already been implicitly or explicitly committed or aborted.". If I comment out TransactionScope line, it works without any problems. So the connection string is correct. Can anybody point out what's happening here? Thanks a lot. Tag: How to tell if a timeout exception occures Tag: 125864
  - 4
    - setting dataset datarelation from database Hi, I want to set my dataset's datarelations based on the relationships from a database. I've read about people doing this, and since the dataset.readxmlschema() is just looking for a xmlreader, I provide that with sqlcommand.executexmlreader(). I also tried casting it to (xmltextreader) since that's what the method really returns, to no avail. I'm hoping someone can tell me what's wrong. I had a query I initially used: select top 1 Brands.*, Models.*, ModelTypes.*, Types.*, Audio.*, Video.*, IRCommands.*, IRTime.*, IRFreqRepeat.*, Groups.*, FileNames.* from Brands (nolock) join Models (nolock) on (Brands.ID = Models.Brand) join ModelTypes (nolock) on (Models.ID = ModelTypes.Model) join Types (nolock) on (ModelTypes.Type = Types.ID) join Audio (nolock) on (Models.Audio = Audio.ID) join Video (nolock) on (Models.Video = Video.ID) join IRCommands (nolock) on (Models.ID = IRCommands.Model) join IRTime (nolock) on (IRCommands.Time = IRTime.Time) join IRFreqRepeat on (IRCommands.FreqRepeat = IRFreqRepeat.ID) join Groups (nolock) on (IRCommands.[Group] = Groups.ID) join FileNames on (IRCommands.FileName = FileNames.ID) for xml auto, xmldata It returned the first four relationships correctly, but I read online that it uses the order of the tables in the query, not the join relationships. The relationships were plugged into the dataset, but the 5th relationship was between Types and Audio, the 6th was between Audio and Video, and so forth, which was incorrect. Okay, fine. So, I switched to using 'for xml explicit, xmldata' but now the relationships are gone. If I run the query in sql query analyzer, I see the schema at the top of the xml that's returned, along with the data, but there aren't any relationships in the schema, nor are there any in the dataset. I'm wondering if I need to switch to using xml view with annotated xdr or xsd schema? Here's the code I'm using (I've also tried creating a SQLXML 3.0 SP 3 sqlxmlcommand, and using that, but the datarelations are still missing): SqlConnection _conn = new SqlConnection(connstr); _conn.Open(); SqlCommand comm = new SqlCommand(spGetIRCommandSchema, _conn); // sql xml 3.0 SP 3 didn't return datarelations either, tried no root tag and tried "root" //SqlXmlCommand comm = new SqlXmlCommand(xmlConnStr); //comm.RootTag = "root"; //comm.CommandType = SqlXmlCommandType.Sql; //comm.CommandText = "exec dbo.spGetIRCommandSchema"; comm.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); XmlReader rdr; // sql xml 3.0 SP 3 didn't return datarelations either, with both //SqlXmlCommand comm = database.CreateSQLXMLCommand("root", SqlXmlCommandType.Sql, "exec dbo.spGetIRCommandSchema"); SqlCommand comm = database.CreateCommand("spGetIRCommandSchema", null); rdr = comm.ExecuteXmlReader(); ds.ReadXmlSchema(rdr); rdr.Close(); // also tried ReadXmlSchema() followed by ReadXml() that I read was required to get the data, but that made no difference either... //rdr = (XmlTextReader)comm.ExecuteXmlReader(); //ds.ReadXml(rdr, XmlReadMode.ReadSchema); //rdr.Close(); Here's an excerpt of the new query using for xml explicit, xmldata: CREATE PROCEDURE spGetIRCommandSchema AS select distinct 1 as Tag, NULL as Parent, Brands.ID as [Brands!1!ID!id], Brands.[Name] as [Brands!1!Name], Brands.Manufacturer as [Brands!1!Manufacturer], Brands.WebSite as [Brands!1!WebSite], Brands.Address1 as [Brands!1!Address1], Brands.Address2 as [Brands!1!Address2], Brands.City as [Brands!1!City], Brands.State as [Brands!1!State], Brands.PostalCode as [Brands!1!PostalCode], Brands.Country as [Brands!1!Country], NULL as [Models!2!ID], NULL as [Models!2!Name], NULL as [Models!2!Brand!idref], NULL as [Models!2!Audio], NULL as [Models!2!Video], NULL as [Models!2!IsEditable], NULL as [Audio!3!ID], NULL as [Audio!3!Name], NULL as [Video!4!ID], NULL as [Video!4!Name], NULL as [IRCommands!5!Name], NULL as [IRCommands!5!Model], NULL as [IRCommands!5!Content], NULL as [IRCommands!5!Time], NULL as [IRCommands!5!FreqRepeat], NULL as [IRCommands!5!Group], NULL as [IRCommands!5!FileName], NULL as [IRCommands!5!IsEditable], NULL as [IRTime!6!ID], NULL as [IRTime!6!Time], NULL as [IRTime!6!OnTime], NULL as [IRTime!6!OffTime], NULL as [IRFreqRepeat!7!ID], NULL as [IRFreqRepeat!7!CarrierNumber], NULL as [IRFreqRepeat!7!RepeatPoint], NULL as [Groups!8!ID], NULL as [Groups!8!Name], NULL as [FileNames!9!ID], NULL as [FileNames!9!Name], NULL as [ModelTypes!10!Model], NULL as [ModelTypes!10!Type], NULL as [Types!11!ID], NULL as [Types!11!Name] >From Brands UNION ALL select distinct 2 as Tag, 1 as Parent, Brands.ID, NULL, NULL, . . . Types.ID, Types.Name from Brands join Models on (Brands.ID = Models.Brand) join Audio on (Models.Audio = Audio.ID) join Video on (Models.Video = Video.ID) join IRCommands on (Models.ID = IRCommands.Model) join IRTime on (IRCommands.Time = IRTime.Time) join IRFreqRepeat on (IRCommands.FreqRepeat = IRFreqRepeat.ID) join Groups on (IRCommands.[Group] = Groups.ID) join FileNames on (IRCommands.FileName = FileNames.ID) join ModelTypes on (Models.ID = ModelTypes.Model) join Types on (ModelTypes.Type = Types.ID) ORDER BY [Brands!1!ID!id], [Models!2!ID], [Audio!3!ID], [Video!4!ID], [IRCommands!5!Model], [IRCommands!5!Name], [IRCommands!5!Time], [IRTime!6!Time], [IRCommands!5!FreqRepeat], [IRFreqRepeat!7!ID], [IRCommands!5!Group], [Groups!8!ID], [IRCommands!5!FileName], [FileNames!9!ID], [ModelTypes!10!Model], [ModelTypes!10!Type], [Types!11!ID] FOR XML EXPLICIT, XMLDATA Here's an excerpt of the schema the query produces (from query analyzer): <Schema name="Schema1" xmlns="urn:schemas-microsoft-com:xml-data" xmlns:dt="urn:schemas-microsoft-com:datatypes"> <ElementType name="Brands" content="mixed" model="open"> <AttributeType name="ID" dt:type="id"/> <AttributeType name="Name" dt:type="string"/> <AttributeType name="Manufacturer" dt:type="string"/> <AttributeType name="WebSite" dt:type="string"/> <AttributeType name="Address1" dt:type="string"/> <AttributeType name="Address2" dt:type="string"/> <AttributeType name="City" dt:type="string"/> <AttributeType name="State" dt:type="string"/> <AttributeType name="PostalCode" dt:type="string"/> <AttributeType name="Country" dt:type="string"/> <attribute type="ID"/> <attribute type="Name"/> <attribute type="Manufacturer"/> <attribute type="WebSite"/> <attribute type="Address1"/> <attribute type="Address2"/> <attribute type="City"/> <attribute type="State"/> <attribute type="PostalCode"/> <attribute type="Country"/> </ElementType> <ElementType name="Models" content="mixed" model="open"> <AttributeType name="ID" dt:type="i4"/> <AttributeType name="Name" dt:type="string"/> <AttributeType name="Brand" dt:type="idref"/> <AttributeType name="Audio" dt:type="ui1"/> <AttributeType name="Video" dt:type="ui1"/> <AttributeType name="IsEditable" dt:type="boolean"/> <attribute type="ID"/> <attribute type="Name"/> <attribute type="Brand"/> <attribute type="Audio"/> <attribute type="Video"/> <attribute type="IsEditable"/> </ElementType> . . . and here's an excerpt of one part of the data: <Brands xmlns="x-schema:#Schema1" ID="1" Name="Elan"> <Models ID="2" Name="SomeModel" Brand="1" Audio="0" Video="0" IsEditable="0"> <Audio ID="0" Name="No"/> <Video ID="0" Name="No"/> <IRCommands Name="*, 0" Model="2" Content="00:00:01" Time="3" FreqRepeat="4" Group="1" FileName="15" IsEditable="0"> <IRTime ID="1" Time="3" OnTime="115" OffTime="1123"/> <IRTime ID="2" Time="3" OnTime="115" OffTime="1234"/> <IRTime ID="3" Time="3" OnTime="115" OffTime="15234"/> <IRFreqRepeat ID="4" CarrierNumber="46" RepeatPoint="0"/> <Groups ID="1" Name="Normal"/> <FileNames ID="15" Name="SomeModelFile.irf"/> </IRCommands> <ModelTypes Model="2" Type="4"/> <Types ID="4" Name="System Controller"/> <ModelTypes Model="2" Type="5"/> <Types ID="5" Name="Controller"/> <ModelTypes Model="2" Type="13"/> <Types ID="13" Name="Video Controller"/> . . . Thanks in advance for any help, -------------------------------- From: Steve Fortner Tag: How to tell if a timeout exception occures Tag: 125858
  - 5
    - Handling UNICODE in DB Hi All, I am looking for some samples/documentation that will help me in understanding the steps involved to Insert UNICODE (International) strings into a Sybase database and also retrieving the same in a C# application. Any pointers will be appreciated. Thanks for your time. ~V Tag: How to tell if a timeout exception occures Tag: 125856
  - 6
    - How to use TransactionScope to roll back changes except for one ta I need to roll back database activities from Business Object level. I need to roll back changes in all other tables except ProcessError table where I logged my process errors. I need to do this business object level transactions in many places and the application structure is very complicate. So I don't have much way to know what tables or databases I am updating from the business object layer. I just want to roll back database changes except for ProcessError table. Can TransactionScope help me to for this? Thanks a lot. Tag: How to tell if a timeout exception occures Tag: 125854
  - 7
    - VB.NET/ EXCEPTIONAL OPPORTUNITY/ IN OMNI GROUP tgugger@sbcglobal.net 419-537-9447 .NET/ CAREER POSITION/ IN A solid well established company (Non Consulting) has several openings for .NET developers. Our client is expanding their IS department due to substantial growth over the last few years. This is a career position with excellent opportunity for advancement. Our client is located several miles North of Fort Wayne, Indiana. Besides the normal benefits, the company has a strong bonus program. In addition to .NET one must also have experience with MS SQL. This position requires several years of .NET experience. The company not only requires IS skills, but seeks out people with excellent character who can be team players. Vision for Job: The Individual will be responsible for hands-on development using Visual Studio .NET 1.0, 1.1 or 2.0, SQL Server, and SQL Reporting Services. The position will involve the design, coding and testing of application software system. If you are interested and qualified, answer the five questions below. Email answers WITH a resume to: tgugger@sbcglobal.net. 1.. .NET Experience -----------------yrs 2.. MS SQL Experience -------------yrs 3.. Citizenship Status ----------------yrs 4.. Availability ------------------------ 5.. Salary requirements --------------K + Benefits + Bonus Tag: How to tell if a timeout exception occures Tag: 125852
  - 8
    - .NET Data Provider/OLEDB Is it possible or does anyone know of a tool that will let me expose a .NET Data Provider as an OLEDB DataSource. I am writing a custom .NET Data Provider for a custom database, in itself a much easier task than writing an OLEDB Provider. However unless I am mistaken I won't get all the functionality of an OLEDB datasource such as being able to appear in the Server Explorer in Visual Studio.NET or the ODBC Datasources pane in windows. In addition to all the other things that OLEDB/ODBC datasources can do. Any advice or help would be greatly appreciated. Colin Tag: How to tell if a timeout exception occures Tag: 125849
  - 9
    - Update Data Source from Data Table I am using VB.Net and I have been trying to store record changes to a SQL Server table from changes made to a data table by using the data adabpter's update command, but I am having no luck. The user will make changes to the data table by entries in unbound text boxes & then displayed in a data grid, and this works fine. By this process the user will change multiple records in the Data Table. When the user accepts his entries he will hit a button that will store the changes to the SQL Server table. If i understand the Data Adapter Update command, it will update all the modified rows in the specified data table in the Source table. I can do this if i want to specify & update just one row. But am having trouble when multiple rows were changed and need updating. Just about all the examples in the books & help files suggest just one record at a time being updated & those changes being made in bound controls. So any suggestions in how to proceede? Thanks Gary Tag: How to tell if a timeout exception occures Tag: 125848
  - 10
    - Web Setup msi Hi, I am trying to exclude a web folder from being included in my web setup project. I have selected "Content Files from ..." and clicked on ExcludeFilter. In this ExcludeFilter I added images\*.gif but they are still being included with project. What am I doing wrong? Thanks, J Tag: How to tell if a timeout exception occures Tag: 125846
  - 11
    - Oracle Rollback causing error with .NET 1.1 Hi, I am calling a DBMS_Transaction.ReadWrite(); and later Rollback; from an Oracle Stored Procedure. When I call this stored procedure with from an ASP.NET page, using OracleClient.dll version 1.0.3.000 i get NO ERROR, but when i use OracleClient.dll version 1.0.5.000 i get this ERROR; "ORA-02074: cannot ROLLBACK in a distributed transaction". Following is my configuration: Windows XP, IIS 5.1 VS 2003, .NET framework 1.1 Oracle 9i Release 2 I have googled, tried searching MSDN but no one has given specific resolution of the said issue although they say it is an issue :P. Any insight will be most welcome ... Tag: How to tell if a timeout exception occures Tag: 125844
  - 12
    - Retrieve only changed values from a DataRow ? - I need to find the columnNames of values that has Changed in a certain DataRow, and I can't quite figure out how to do it right ... The following does seems a little clumsy, and does not work right either. Anybody knows how to do it? private IList<string> GetChangedFieldsColumnNames(DataRow row) { List<string> result = new List<string>(); if(row != null) { switch(row.RowState) { case DataRowState.Detached: break; case DataRowState.Modified: case DataRowState.Added: foreach(DataColumn column in row.Table.Columns) { try { object originalValue = row[column, DataRowVersion.Original]; object newValue = row[column, DataRowVersion.Current]; if(originalValue != newValue) { result.Add(column.ColumnName); } } catch(VersionNotFoundException) { } } break; case DataRowState.Deleted: case DataRowState.Unchanged: break; } } return result.ToArray(); } Tag: How to tell if a timeout exception occures Tag: 125843
  - 13
    - instant client + odp.net hello I need a version of the instant client with odp.net. Is that anyhow possible and with files are necessary? my applikation needs oraops10.dll thanks. roger -- ------------------------------------- Roger Bruhin Infosystem AG Bronschhoferstrasse 31 CH-9500 Wil SG Tag: How to tell if a timeout exception occures Tag: 125842
  - 14
    - How do i bind to a collection This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C641EE.DC40BD50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I know how to bind to a property in a class like this : this.BindingContext.Add(Class1.PropertyName, dataview, "Name"); Now i have a data Relation which can return muliple rows. Here is the = construct CurrencyManager cm =3D (CurrencyManager)this.BindingContext[dataview, = "StudentsWithLastNameX"]; while( cm.Position < cm.Count) { this.BindingContext.Add(Class1.Stutdents, dataview, "FirstName"); = <-------- I want to add binding to FirstName with a collection instead = of property. cm.Position ++; } Can anyone suggest how do go about doing this? Thanks Vivek ------=_NextPart_000_0006_01C641EE.DC40BD50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>I know how to bind to a property in a = class like=20 this :</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial color=3D#008000=20 size=3D2>this.BindingContext.Add(Class1.PropertyName, dataview,=20 "Name");</FONT></DIV> <DIV><FONT face=3DArial color=3D#008000 size=3D2></FONT> </DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Now i have a data Relation which can = return muliple=20 rows. Here is the construct</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>CurrencyManager cm =3D=20 (CurrencyManager)this.BindingContext[dataview,=20 "StudentsWithLastNameX"];</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>while( cm.Position < = cm.Count)</FONT></DIV> <DIV><FONT face=3DArial size=3D2>{</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    <FONT=20 color=3D#ff0000>this.BindingContext.Add(Class1.Stutdents, dataview,=20 "FirstName");</FONT>   <STRONG><-------- I want to add = binding to=20 FirstName with a collection instead of property.</STRONG></FONT></DIV> <DIV><FONT face=3DArial size=3D2>    cm.Position = ++;</FONT></DIV> <DIV><FONT face=3DArial size=3D2>}</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Can anyone suggest how do go about = doing=20 this?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Vivek</FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C641EE.DC40BD50-- Tag: How to tell if a timeout exception occures Tag: 125825
  - 15
    - How to retrieve TimeSpan from typed DataSet? I keep getting an InvalidCast exception when trying to do this: DataRow row = dtP.Rows.Find(projectID); bakInterval = new TimeSpan(); bakInterval = (TimeSpan)row[colBI]; //colBI is a string const Error Message: "Specified cast is not valid". As far as I know, the rowBI column is in fact a TimeSpan. Below is how the dtP table is created. The last line shows colBI created as a TimeSpan type. DataTable tblProject = database.Tables.Add("TableProject"); DataColumn project_ID = tblProject.Columns.Add("Project_ID", typeof(Int32)); project_ID.AllowDBNull = false; project_ID.Unique = true; project_ID.AutoIncrement = true; project_ID.AutoIncrementSeed = 1; project_ID.AutoIncrementStep = 1; tblProject.PrimaryKey = new DataColumn[] { tblProject.Columns[0] }; tblProject.Columns.Add("ProjectName", typeof(string)); tblProject.Columns.Add("BackupInterval", typeof(TimeSpan)); I can cast ProjectName to a string, and Project_ID to an int, but I can't cast BackupInterval to a TimeSpan. What am I doing wrong? Thanks in advance. Tag: How to tell if a timeout exception occures Tag: 125819
  - 16
    - Parameters --____YQDEHJGDEEXNVAEPSDFB____ Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Why should we use the parameter object when it seems like duplicated code. = The info is described in SQL Server as int, varchar, etc. so why do we = have to redundantly use the parameter object when inserting a record = rather than passing the parameter in an SQL query insert code? Just = curious??? --____YQDEHJGDEEXNVAEPSDFB____ Content-Type: multipart/related; boundary="____BUYAVGJDUGVQCUVJQAVX____" --____BUYAVGJDUGVQCUVJQAVX____ Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1"= > <META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR></HEAD> <BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma"> <DIV>Why should we use the parameter object when it seems like duplicated = code.  The info is described in SQL Server as int, varchar, etc. so = why do we have to redundantly use the parameter object when inserting a = record rather than passing the parameter in an SQL query insert code? = Just curious???</DIV></BODY></HTML> --____BUYAVGJDUGVQCUVJQAVX____-- --____YQDEHJGDEEXNVAEPSDFB____-- Tag: How to tell if a timeout exception occures Tag: 125808
  - 17
    - not associated with a trusted sql connection Hi in my page i am getting the following error Message "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection." String This only happens in ASP.net and doesn't happen in windows applications how can i stop it from happening. regards Tag: How to tell if a timeout exception occures Tag: 125806
  - 18
    - Is this a Bug in Visual Studio 2005?? Try the following in VS 2005: Add a SQLCommand object to a Windows Form Set the connection to the Northwind Database Change the "CommandType" to "StoredProcedure" In the "CommandText" property, select "CustOrderHist" from the combobox. The "Parameters" collection property does not get populated. Clear the "CommandText" property and press Enter. Manually type in "CustOrderHist" in the "CommandText" property and press Enter. The "Parameters" collection now gets populated correctly. Why doesn't the Parameters collection get populated when a stored proc is chosen from the combo box? Is this a bug or am I missing something? Cheers, Larry. Tag: How to tell if a timeout exception occures Tag: 125805
  - 19
    - Using SqlTransaction with MSSQL Trans? Hello all, I got seven sp's that uses transactions: BEGIN TRAN ... ROLLBACK TRAN ... COMMIT >From ado.net I need to execute all of these using transaction: SqlTransaction tran = conn.BeginTransaction() ... tran.Commit() ... tran.Rollback() Q: will a commit in sp's be rollbacked by ado.net's rollback? i.e. do ado.net and mssql use the same transactions-counter? Tag: How to tell if a timeout exception occures Tag: 125803
  - 20
    - NUNIT vs VSTS ?? Which is better ? Hi, I am trying to figure out best testing tool for my project. I have narrowed down my requirements to two tools NUNIT and VSTS unit. But I have used neither and I have to use only one of them. Hence can someone who has used them before share his/her experience on them so that I can get a better idea and make a proper choice ? Any link or suggestions are also welcome. Thanks and Regards, Parag MTS,Persistent Systems Private Limited Tag: How to tell if a timeout exception occures Tag: 125792
  - 21
    - Column 'Column' does not belong to table 'Table' Hello I have a dataset which is successfully being filled. However whenever i try to access a givewn row of one of the tables in the dataset i get the error "Column 'ContactId' does not belong to table 'SalesAgent'" Except that it does and if i use an ordinal reference i can access the value of the column. If i print the schema sure enough the column is called ContactId. I have also noticed that if i hover the cursor over the contactrow i can access a treeview which lists all columns in the contactrow and then tells me that none of them belong to table salesagent. This was a conversion from 1.1 to 2.0. Any ideas? Thanks Lenny Tag: How to tell if a timeout exception occures Tag: 125791
  - 22
    - How can cancel a validator I am use a RequiredFieldValidator to valid a Text box, and there are two Buttons on the forms, one for OK and one for Cancel, both are Asp.Net controls. When a user press Cancel to cancel the input, the RequiredFieldValidator also require user must enter the value. How can I do? Tag: How to tell if a timeout exception occures Tag: 125789
  - 23
    - c# - AcceptChanges - What's it used for? Hi, Can anybody tell me when you would use DataSet.AcceptChanges. If you use it, then all the new records are reset to be seen as original records (unchanged), and hence cannot be updated into the datasource. Therefore I've been using the update method which does both Accet changes (rebuilds the row numbers in the data table) & saves to datasource. I can understand RejectChanges as this would discard new rows before the update, but why AcceptChanges? When would you use it? Thanks for any ideas on this Ant Tag: How to tell if a timeout exception occures Tag: 125787
  - 24
    - Moving data from Access to SQL Server using ADO.NET Hi, I was looking for long time for a fast and reliable way to upload Access table into an empty SQL Server table. Finaly I came with a way that seems to be working fine but I'd like to get confirmation from this group that there are no hidden problem going that way. In short I used system.data.OledbConnection with Jet provider to get DataReader to the Access source and fed the system.data.SqlClient.BulkCopy object with that reader to bulk upload the changes. Here is a sample code: Can someone point out if this method will work in "all" cases ? What are the hidden problems I should expect ? Thanks, Einat using System; using System.Text; using System.Data; using System.Data.SqlClient; using System.Data.OleDb; using System.Runtime.InteropServices; namespace AccessDataTransfer { class Program { static void Main(string[] args) { String Sourcedb = "c:\\1.mdb"; String DestConnectionStr = "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=gil2"; String TableName = "Foo"; if (args.Length >= 1) { if (args[0] == "/?") { PrintHelp(); return; } Sourcedb = args[0]; } if (args.Length >= 2) { DestConnectionStr = args[1]; } if (args.Length >= 3) { TableName = args[2]; } TransferTableData( Sourcedb, DestConnectionStr, TableName ); } // // Transfer data deom Access table to SQL server table. The table is asummed to be created on the sql server side. // // static void TransferTableData( String AccessSourcedb, String DestinationConnectionStr, String TableName ) { int Start = GetTickCount(); //Connection to the destination // SqlConnection DestConnection = new SqlConnection(DestinationConnectionStr); DestConnection.Open(); SqlCommand Cmd = DestConnection.CreateCommand(); //Connection to source // OleDbConnection OledbSrcConnection = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + AccessSourcedb); OledbSrcConnection.Open(); // Reader to source // OleDbCommand OleDbCommand = new OleDbCommand("SELECT * FROM " + TableName); OleDbCommand.Connection = OledbSrcConnection; OleDbDataReader OleDbDataReader = OleDbCommand.ExecuteReader(); //bulk upload to destination // SqlBulkCopy bulkCopy = new SqlBulkCopy(DestConnection, System.Data.SqlClient.SqlBulkCopyOptions.KeepIdentity,null); bulkCopy.BulkCopyTimeout = 100000000; bulkCopy.DestinationTableName = TableName; bulkCopy.WriteToServer(OleDbDataReader); int End = GetTickCount(); Console.WriteLine("all rows were uploaded in {0} miliseconds", End - Start); } [DllImportAttribute("kernel32.dll", SetLastError = true)] private static extern int GetTickCount(); static private void PrintHelp() { System.Console.WriteLine("AccessDartaTransfer.exe <AccessSourcefile> <SQL server connection string> <TableDef to transfer>"); } } } Tag: How to tell if a timeout exception occures Tag: 125778
  - 25
    - What's up with the VS.NET 2005 Dataset Designer? Why has the VS.NET 2005 dataset designer changed so much from the 2003 designer? The 2003 designer gave you so much more power over the way the dataset was represented in XML. It seems like the designer has gone to a much more Database-centric approach, rather than an XML-centric approach. While I can understand a need for this for users who use datasets as way to work with remote databases, we typically use datasets as convenient ways to store structured data on the local disk (using the ReadXml and WriteXml commands on the dataset). In our case, a traditional database is never involved. As a result it is very nice to have control over how the XML is stored. It seems like all this control has been removed or hidden from the VS.NET 2005 dataset designer. Here's what I've found: - You can no longer define if columns are stored as elements or attributes. It seems to default to elements (which result in larger XML files) - Nested elements/tables are cumbersome. You can define a nested table as a DataRelation but it requires a common key between the two tables. Seems like a foreign key in the child element is repetitive and a waste of space. In the 2003 designer you could just drag a child table unto a parent table and be done with it. - I always liked the ability to set the table primary key and have the Dataset code generator create a function called "FindByXXXX". VS.NET 2005 doesn't seem to do this when you use a dataset generated by the 2005 designer. Is there a way within VS.NET 2005 to get these features back? The 2005 XSD designer seems to still have all this, but I can't seem to find a way to convert the XSD file into a dataset. In 2003 you could right click the screen and select "Generate Dataset". Where has all this gone???? -alpha Tag: How to tell if a timeout exception occures Tag: 125777
- Next
  - 1
    - login routine with information returned from database Hi i am creating a login routine that i have overloaded and wondered how i could return some data back to my program or even if i am going about the right way of achieving what i want to do. The function takes some parameters the server name, the database, the username and the stored procedure name the other overloaded function takes the same parameters plus a password and two optional parameters for the username and password input parameters for the stored proc defaulted at @username and @password. Then the function opens a data reader using cmd.executereader if the datareader has rows then it returns true if not it returns false. It is meant to be a generic login dll for use in my apps either windows or asp. Sometimes i may need to return the full name of the user or one or two other parameters how could i do this i was thinking about having some public property's but i am unsure of how to go about setting them. I keep getting an error invalid attempt to read when no data is present. When i call dr.hasrows does this then empty my datareader i remember from my course manual that a datareader is readonly forward only? Is this a good way of doing things or have i got the idea mixed up The code is below, by the way i am coming from a predominately ASP background into .net so i know little of it really Public Overloads Function LoginCheck(ByVal Username As String, ByVal Password As String, _ ByVal Server As String, ByVal DBName As String, ByVal StoredProc As String, ByVal numReturns As Integer, Optional _ ByVal Param1 As String = "@Username", Optional ByVal Param2 As String = "@Password") As Boolean Dim conn As SqlConnection = Nothing Dim dr As SqlDataReader = Nothing Dim cmd As New SqlCommand Dim P1 As New SqlParameter(Param1, SqlDbType.VarChar) Dim P2 As New SqlParameter(Param2, SqlDbType.VarChar) Try conn = New SqlConnection("data source=" & Server & "; integrated security=true; initial catalog = " & DBName) cmd.CommandText = (StoredProc) cmd.CommandType = CommandType.StoredProcedure cmd.Connection = conn 'set up the paramaters P1.Value = Username P1.Direction = ParameterDirection.Input P2.Value = Password P2.Direction = ParameterDirection.Input cmd.Parameters.Add(P1) cmd.Parameters.Add(P2) conn.Open() dr = cmd.ExecuteReader If dr.HasRows Then Select Case numReturns Case 0 'do nothing Case 1 Return1 = dr("Fullname").ToString Case 2 End Select Return True Else Return False End If Catch ex As Exception Console.WriteLine(ex.Message) If Not dr Is Nothing Then dr.Close() End If If Not conn Is Nothing Then conn.Close() End If Finally If Not dr Is Nothing Then dr.Close() End If If Not conn Is Nothing Then conn.Close() End If End Try End Function Dim m_Return1 As String Public Property Return1() As String Get Return m_Return1 End Get Set(ByVal Value As String) m_Return1 = Value End Set End Property Tag: How to tell if a timeout exception occures Tag: 125765
  - 2
    - Data Validation and Import Strategy I would appreciate some input and advice on the following situation. I have a number of data files which I need to place the data into my database. Much of the data in the files are, of course, related and I need to validate the data before putting it into the database. An additional requirement is that I need to report what lines in these files are incorrect and kick those out with a reason. My idea is to do the following. Create a data set of the database schema, verify the data by attempting to load the data into those tables, and report any errors. Then, import the correct data into the database using bulk copy. In .net 1.1 it seemed that DataSet/DataTable couldn't handle large amounts of data, and I heard that .net 2.0 has fixed this. So, perhaps I can load all of the data into the DataSet at once, else, I can either commit data to the database X amount at a time. OR, I could validate the data, and remove the data from the DataSet. Then import all the data into the database that is valid. Does anyone see a problem with this or have a better solution? Thanks. Tag: How to tell if a timeout exception occures Tag: 125756
  - 3
    - DataBound ListBox selects first item I am fairly new at developing, but have decided to implement an application that uses a comboBox to populate a listbox, Both comboBox and ListBox are DataBound. For example: if a type of car is selected in the comboBox the list box will show that type and the user can then select from the listbox which car to look at. The problem occurs in the listBox, it selects the first item in the listbox, on Form load. I assume the selectedIndex changes while it is populating. I have tried setting the SelectedIndex to -1, but it does not appear to make any difference. Is there a way to stop the selection automatically, so that the user can make the selection. Thank you for your time Tag: How to tell if a timeout exception occures Tag: 125750
  - 4
    - SQL Syntax error I have something like that SqlCommand cmd = new SqlCommand(sqlText, connection); SqlDataReader data = cmd.Execute(); while (data.Read()) { ..do my stuff } When sqlText is invalid the error does not occur on cmd.Execute (as I would expect) but on data.Read(). Is it the correct DotNet behaviour or some stupid setup on my PC? Thanks MH Tag: How to tell if a timeout exception occures Tag: 125744
  - 5
    - Problem with ODP.Net and TNSNames I am using asp.net (Framework 1.1) with Oracle 9i and ODP.Net version 9.2.0.401. I am developing using a local copy of IIS version 5.1. When I use a connection string to connect to Oracle utilising a data source in my TNSNames.ora file initially everything is fine and I can connect without any problem. After about 2 minutes as I move from page to page and requery the database I seem to loose the connection with the error "ORA-12154: TNS:could not resolve service name". I am using the following line in my web.config file to create the connection string:- <add key="Main.ConnectionString" value="data source=dev.ora;User Id=xxxx;Password=xxxx;persist security info=false;Pooling=true;Connection Lifetime=120;Min Pool Size=0;Incr Pool Size=1;Decr Pool Size=1;Max Pool Size=20;"/> Interestingly if I change this to the relevant data source entry within my TNSNames file:- <add key="Main.ConnectionString" value="data source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxx)(PORT=xxxx)))(CONNECT_DATA =(SERVICE_NAME = dev.xxx.xxx.xx)) );User Id=xxxx;Password=xxxx;Pooling=true;Connection Lifetime=120;Min Pool Size=0;Incr Pool Size=1;Decr Pool Size=1;Max Pool Size=20;"/> Then I do not have any problems. I would prefer to use TNSNames rather than entering the datasource directly. Has anyone any ideas why I loose the connection? Tag: How to tell if a timeout exception occures Tag: 125743
  - 6
    - newbie: why does DataSet AutoIncrement advance by 2? I create a DataSet called database and add a table to it as shown below. Why does the AutoIncrement value advance by 2 every time I add a record? How do I get it to advance by 1? DataTable tblProject = database.Tables.Add("TableProject"); DataColumn project_ID = tblProject.Columns.Add("Project_ID", typeof(Int32)); project_ID.AllowDBNull = false; project_ID.Unique = true; project_ID.AutoIncrement = true; project_ID.AutoIncrementSeed = 1; project_ID.AutoIncrementStep = 1; tblProject.PrimaryKey = new DataColumn[] { tblProject.Columns[0] }; //other columns added here... Tag: How to tell if a timeout exception occures Tag: 125738
  - 7
    - Internal .Net Framework Data Provider error 12 Hi NG, i use the oldedbExecuteReader Method on an Access DB and get a System.InvalidOperationException with the message :"Internal .Net Framework Data Provider error 12" Do anybody now what the framework will tell me ? I cant't find a desciption of the error. The error ocurs sometimes and somitimes not. Thanks Maik Tag: How to tell if a timeout exception occures Tag: 125737
  - 8
    - .net and DB Data layer : Best Practice I am converting an app. from PHP to .net. I know that you can create an xsd and then have the system generate code to load data into a dataset. I assume that you use this and an a data adapter to talk to the DB. However, is this the "optimal" or recommended way to add, update, etc. information? Or should one create code to accept the data and then pass it to a stored procedure? I do not dislike the adapter way, but I can see that it could introduce problems and the programmer can loose control which may cause errors or data integrity violations. Comments? Thanks Tag: How to tell if a timeout exception occures Tag: 125728
  - 9
    - Sychronize Key between Database and Dataset on Insert Hi, I'm sure this has been asked many times before, but I haven't had a lot luck finding an answer; not googling the question right. So I apologize before hand. I have a TableAdapter whose insert command uses a store procedure. When I call TableAdapter.Update() passing in the table the database gets updated, but the primary key in of the DataTable doesn't match the one in the database. I've read some responses about selecting the "Refresh Dataset" option under Advanced Options in the Dataset Designer, but I only see that option when using a SQL statement and not a stored procedure. I prefer to ues the stored procedures. Is there an option I can configure on the TableAdapter that I missed? What's the simplient way to handle this? Cheers, Aeden Tag: How to tell if a timeout exception occures Tag: 125724
  - 10
    - Search button to filter a Dataset 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. I have a 'View Resources' page, the purpose of which is to show all employees, taken from that table in the database. This works fine, up to a point. I have a DataGrid, which is done with a DataSet and a DataAdapter. I now want the user to be able to 'filter' the DataGrid, using a text box for input, and a 'search' button. I have tried different ways of doing this but can't get it to work. I imagine that it is achieved by running some kind of different SQL statement (with a % LIKE % operator) in the btnSearch_Click method, and re-binding the Data Grid after the filter has finished. So for example the user could enter 'John' in the 'First Name' text box and click 'search', and the Data Grid would refresh accordingly with all records LIKE 'John'. My Page_Load code looks like this currently ------------------------------------------------------------------------- this.sqlDataAdapter1.Fill(this.dsResources1); DataGrid1.DataBind(); sqlConnection2.Close(); this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.GridPageIndexChanged); -------------------------------------------------------------------------------------------- Hope someone can help, I'm sure the btnSearch_Click method is where I need to put the code. Thanks in advance, Al Tag: How to tell if a timeout exception occures Tag: 125717
  - 11
    - OutOfMemoryException on DataTables Hi, In my application I have text(flat) file as input and I have to generate an XML file. The maximum input text file size can be 900MB and gererated xml may result 2+ GB. Based on the first column value from the text file, the row will be moved to any of those 23 DataTable which are created onfly. For eg. 01;- data for Table 1- 02;- data for Table 2- 03;- data for Table 3- 04;- data for Table 4- 04;- data for Table 4- 04;- data for Table 4- 04;- data for Table 4- 04;- data for Table 4- Based on the child relation, I have to create XML node, after stripping the parent-child relation column. I am using XmlTextWriter to write the xml data, which are fetched from tables based on select with different condition. The server uses 2GB RAM memory When the application process a 500MB file, it throws OutOfMemoryException. In the task manager, the utilised memory when the system throws OutOfMemoryException is 2.15 GB. But in my desktop, for the surprise, the system has 512 MB and when I load several application, the process memory reached 1GB without any OutOfMemoryException issues. Can you one help me in this regard. Thanks in advance With Regards venkatg Tag: How to tell if a timeout exception occures Tag: 125710
  - 12
    - GridView and reader source Hi, I can give a DataTable to gridview and in one line data are displayed int the gridview using : dgvEmployee.DataSource = myDataTable.; When I use a dataReader instead, do "dgvEmployee.DataSource = myReader;", nothing is displayed in the gridview. Does that mean that GridView dosnt or can not bind to a data reader Thanks for your help Tag: How to tell if a timeout exception occures Tag: 125708
  - 13
    - DataAdapter + DataRow + Inserting a record ########################################################################### private void btnAdd_Click(object sender, System.EventArgs e) { OleDbConnection con = new OleDbConnection(str); con.Open(); string qry = "select * from t_contact"; OleDbDataAdapter da = new OleDbDataAdapter(qry,con); DataSet ds = new DataSet(); da.Fill(ds,"t_contact"); DataTable dt = new DataTable(); dt = ds.Tables["t_contact"]; DataRow dr ; dr = dt.NewRow(); dr["FirstName"] = txtFirstName.Text; dr["LastName"] = txtLastName.Text; dr["E-Mail"] = txtEMail.Text; dr["PhoneNumber"] = txtPhoneNumber.Text; ds.Tables["t_contact"].Rows.Add(dr); textBox2.Text = ds.GetXml(); da.Update(ds,"t_contact"); } ########################################################################### __________________________________________________________ here e-mail is the primary key.Unable to insert record in the database. __________________________________________________________ The error coming is : System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement. at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) at Contact_new.Form1.btnAdd_Click(Object sender, EventArgs e) in c:\documents and settings\administrator\my documents\visual studio projects\projects\contact_new\form1.cs:line 234 Tag: How to tell if a timeout exception occures Tag: 125701
  - 14
    - Typed datasets 3-tier application We are in the middle of a project that requires both a web GUI and web services. We have elected to go with a 3-tier (data, business, presentation) model using typed datasets as the data layer. We are not using either the sql data source or the object data source on the page, just rolling our own, old school style. The customer(s) will are all business partners with reliable and fast connects and there is no expectation of ever having a consumer direct option. We are posting this since we have been unable to find any real examples of this type of implementation and are looking for help in poking / filling the holes. Who knows you may be looking for an example, so here goes..... Data Layer Straight vs2005 generated typed datasets for all updatable data access. For read only reporting and display data access we will use untyped datasets. We have not had much success with data readers so we will shy away from them if possible. You can generate a strongly typed dataset so we won't bore you with the details. Business layer Accepts requests from pres layer or web service layer and interacts with the data layer. Any necessary validation, conditional enforcement, or other business logic is checked / applied. In many cases this is just a pass through if we have done a good job with required fields, getting and setting nulls for value types, and client side validation. In others, especially calls from the web services, there will be a bit of processing going on in the Biz obj. This layer is not creating a business object from the typed dataset, only interacting with the datasets as they pass through. Presentation layer Is "Aware" of the typed datasets, but has no idea where they come from, and is limited to reading data from them and plugging data into them. All data access must go through the biz layer, even if just a pass through or simple lookup. The pages are smart enough to do most of the required field checking and input validation, however any conditional biz logic or other complex enforcement is left to the biz object. We are currently storing the typed datasets in the viewstate. As mentioned before the users all have reliable connectivity. We don't load any data that we are not willing to put on the page so there are no data security issues. All of our updatable datasets are dealing with 1 or 2 rows data so they don't really bloat the viewstate all that badly. We have implemented several pages and so far it seems to be working. The typed dataset is living up to the billing of reducing both design and run time errors due to the increased use of intellisense. The performance so far is great and we are already reaping the benefits of reusable code blocks, both in the data and biz layers. So there it is - shoot it down before it multiplies. We think we are on the right track - but since we built the track - what else would we think? I would be glad to provide some code samples upon request Thanks in advance. Tag: How to tell if a timeout exception occures Tag: 125697
  - 15
    - Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information Hi, I have data access tier designed in such a way, just by changnging application settings, same lines of code is made to work with both MS SQL Server or MS Access. Code works fine with MS SQL Server. however while executing following code lines on MS Acess ds = new DataSet(); oAdapter.SelectCommand.CommandText = this.SelectCommand; oAdapter.SelectCommand.Connection = oConn; if (idbType == (int) ApplicationConstants.DBType.SQLServer) { oAdapter.DeleteCommand = sqlCommandBuilder.GetDeleteCommand(); oAdapter.InsertCommand = sqlCommandBuilder.GetInsertCommand(); oAdapter.UpdateCommand = sqlCommandBuilder.GetUpdateCommand(); } else if (idbType == (int) ApplicationConstants.DBType.Access) { oAdapter.DeleteCommand = oleCommandBuilder.GetDeleteCommand(); oAdapter.InsertCommand = oleCommandBuilder.GetInsertCommand(); oAdapter.UpdateCommand = oleCommandBuilder.GetUpdateCommand(); } return oAdapter.Fill(ds); It throws out the following error System.InvalidOperationException was unhandled Message="Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information." But i have defined primary keys on all tables in Access databasel, just like what i have in MS Sql database. Just to avoid this error i can not use explict Insert, Delete or Update command for Adapter as the same lines of code (above) has to work with 15 diff tables. Any suggestions to this? Thanks & Regards Ganesh Tag: How to tell if a timeout exception occures Tag: 125691
  - 16
    - Problem in database updation through Adapter in VB.Net.. Hi Friends, I am new to .Net. So I don't know much. I am facing a problem in updating database through ADO.Net I am creating the dataset and there is no problem in the updation and deletion or insertion in the dataset but when I am updating the database through adaptor error occures (Coloured Red). For ref the code follows: Code: Imports System.Data.OleDb Module Module1 Private Const s As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Rabi\Database\DBTest-1.mdb;Persist Security Info=False" Public Con As OleDb.OleDbConnection Public adopt As OleDb.OleDbDataAdapter Public ds As DataSet Public sql As String Dim cmdDel As New OleDb.OleDbCommand, sDelSql As String Dim cmdIns As New OleDb.OleDbCommand, sInsSql As String Dim cmdUpd As New OleDb.OleDbCommand, sUpdSql As String Dim Param As New OleDb.OleDbParameter Public Sub Display(ByRef Table As DataTable) Dim row As DataRow Dim col As DataColumn Dim i, j As Integer For i = 0 To Table.Rows.Count - 1 row = Table.Rows(i) Select Case row.RowState Case DataRowState.Deleted Console.WriteLine("[Deleted]") Case DataRowState.Modified Console.WriteLine("[Modified]") Case DataRowState.Added Console.WriteLine("[Added]") Case DataRowState.Unchanged Console.WriteLine("[Unchanged]") End Select For j = 0 To Table.Columns.Count - 1 If row.RowState <> DataRowState.Deleted Then Console.WriteLine("{0}", row.Item(j)) End If Next Console.WriteLine() Next End Sub Public Sub Main() Try Con = New OleDb.OleDbConnection(s) sql = "Select * from Artist" adopt = New OleDbDataAdapter(sql, Con) ds = New DataSet Catch ex As Exception Console.WriteLine(ex.ToString) Console.ReadLine() End Try sDelSql = "Delete From Artist Where Id = ?" cmdDel.Connection = Con cmdDel.CommandText = sDelSql Param = cmdDel.Parameters.Add("Id", OleDb.OleDbType.Integer) Param.SourceColumn = "@ID" Param.SourceVersion = DataRowVersion.Original adopt.DeleteCommand = cmdDel sUpdSql = "Update Artist Set Name = ? Where Id = ?" cmdUpd.Connection = Con cmdUpd.CommandText = sUpdSql Param = cmdUpd.Parameters.Add("Name", OleDb.OleDbType.Char) Param.SourceColumn = "@Name" Param.SourceVersion = DataRowVersion.Current Param = cmdUpd.Parameters.Add("Id", OleDb.OleDbType.Integer) Param.SourceColumn = "@Id" Param.SourceVersion = DataRowVersion.Original adopt.UpdateCommand = cmdUpd sInsSql = "Insert Into Artist (Id,Name) Values(?,?)" cmdIns.Connection = Con cmdIns.CommandText = sInsSql Param = cmdIns.Parameters.Add("Id", OleDb.OleDbType.Integer) Param.SourceColumn = "@Id" Param.SourceVersion = DataRowVersion.Current Param = cmdIns.Parameters.Add("Name", OleDb.OleDbType.Char) Param.SourceColumn = "@Name" Param.SourceVersion = DataRowVersion.Current adopt.UpdateCommand = cmdIns Try Con.Open() If Con.State = ConnectionState.Open Then adopt.MissingSchemaAction = MissingSchemaAction.AddWithKey adopt.Fill(ds, "Artist") Con.Close() Dim Tables As DataTableCollection Dim Table As DataTable Dim Cols As DataColumnCollection Dim Col As DataColumn Dim Rows As DataRowCollection Dim Row As DataRow Tables = ds.Tables Table = Tables("Artist") Rows = Table.Rows Cols = Table.Columns Console.WriteLine("Original Table Looks Like") Display(Table) Console.ReadLine() Console.WriteLine("Id 1 delete") Rows.Find(1).Delete() Console.WriteLine("deleted") Display(Table) Console.ReadLine() Console.WriteLine("Id 2 Modify") Row = Rows.Find(2) Row.BeginEdit() Row("Name") = "Mantu" Row.EndEdit() Console.WriteLine("Updated") Display(Table) Console.ReadLine() Console.WriteLine("Id 1 Add") Row = Table.NewRow Row("Id") = 4 Row("Name") = "Deepak" Rows.Add(Row) Console.WriteLine("Added") Display(Table) Console.ReadLine() Con.Open() adopt.Update(ds, "Artist") Console.WriteLine("Done") End If Catch ex As Exception Console.WriteLine(ex.ToString) Console.ReadLine() End Try End Sub End Module The Exact error what I got is : "System.Data.OleDb.OleDbException: Parameter ?_1 has no default value. at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) at ADONetTest.Module1.Main() in D:\Rabi\DotNetPrac\ADONetTest\ADONetTest\Module1.vb:line 176" This String is generated by "Ex.ToString" Tag: How to tell if a timeout exception occures Tag: 125689
  - 17
    - Problem in database updation through Adapter in VB.Net.. Hi Friends, I am new to .Net. So I don't know much. I am facing a problem in updating database through ADO.Net I am creating the dataset and there is no problem in the updation and deletion or insertion in the dataset but when I am updating the database through adaptor error occures (Coloured Red). For ref the code follows: Code: Imports System.Data.OleDb Module Module1 Private Const s As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Rabi\Database\DBTest-1.mdb;Persist Security Info=False" Public Con As OleDb.OleDbConnection Public adopt As OleDb.OleDbDataAdapter Public ds As DataSet Public sql As String Dim cmdDel As New OleDb.OleDbCommand, sDelSql As String Dim cmdIns As New OleDb.OleDbCommand, sInsSql As String Dim cmdUpd As New OleDb.OleDbCommand, sUpdSql As String Dim Param As New OleDb.OleDbParameter Public Sub Display(ByRef Table As DataTable) Dim row As DataRow Dim col As DataColumn Dim i, j As Integer For i = 0 To Table.Rows.Count - 1 row = Table.Rows(i) Select Case row.RowState Case DataRowState.Deleted Console.WriteLine("[Deleted]") Case DataRowState.Modified Console.WriteLine("[Modified]") Case DataRowState.Added Console.WriteLine("[Added]") Case DataRowState.Unchanged Console.WriteLine("[Unchanged]") End Select For j = 0 To Table.Columns.Count - 1 If row.RowState <> DataRowState.Deleted Then Console.WriteLine("{0}", row.Item(j)) End If Next Console.WriteLine() Next End Sub Public Sub Main() Try Con = New OleDb.OleDbConnection(s) sql = "Select * from Artist" adopt = New OleDbDataAdapter(sql, Con) ds = New DataSet Catch ex As Exception Console.WriteLine(ex.ToString) Console.ReadLine() End Try sDelSql = "Delete From Artist Where Id = ?" cmdDel.Connection = Con cmdDel.CommandText = sDelSql Param = cmdDel.Parameters.Add("Id", OleDb.OleDbType.Integer) Param.SourceColumn = "@ID" Param.SourceVersion = DataRowVersion.Original adopt.DeleteCommand = cmdDel sUpdSql = "Update Artist Set Name = ? Where Id = ?" cmdUpd.Connection = Con cmdUpd.CommandText = sUpdSql Param = cmdUpd.Parameters.Add("Name", OleDb.OleDbType.Char) Param.SourceColumn = "@Name" Param.SourceVersion = DataRowVersion.Current Param = cmdUpd.Parameters.Add("Id", OleDb.OleDbType.Integer) Param.SourceColumn = "@Id" Param.SourceVersion = DataRowVersion.Original adopt.UpdateCommand = cmdUpd sInsSql = "Insert Into Artist (Id,Name) Values(?,?)" cmdIns.Connection = Con cmdIns.CommandText = sInsSql Param = cmdIns.Parameters.Add("Id", OleDb.OleDbType.Integer) Param.SourceColumn = "@Id" Param.SourceVersion = DataRowVersion.Current Param = cmdIns.Parameters.Add("Name", OleDb.OleDbType.Char) Param.SourceColumn = "@Name" Param.SourceVersion = DataRowVersion.Current adopt.UpdateCommand = cmdIns Try Con.Open() If Con.State = ConnectionState.Open Then adopt.MissingSchemaAction = MissingSchemaAction.AddWithKey adopt.Fill(ds, "Artist") Con.Close() Dim Tables As DataTableCollection Dim Table As DataTable Dim Cols As DataColumnCollection Dim Col As DataColumn Dim Rows As DataRowCollection Dim Row As DataRow Tables = ds.Tables Table = Tables("Artist") Rows = Table.Rows Cols = Table.Columns Console.WriteLine("Original Table Looks Like") Display(Table) Console.ReadLine() Console.WriteLine("Id 1 delete") Rows.Find(1).Delete() Console.WriteLine("deleted") Display(Table) Console.ReadLine() Console.WriteLine("Id 2 Modify") Row = Rows.Find(2) Row.BeginEdit() Row("Name") = "Mantu" Row.EndEdit() Console.WriteLine("Updated") Display(Table) Console.ReadLine() Console.WriteLine("Id 1 Add") Row = Table.NewRow Row("Id") = 4 Row("Name") = "Deepak" Rows.Add(Row) Console.WriteLine("Added") Display(Table) Console.ReadLine() Con.Open() adopt.Update(ds, "Artist") Console.WriteLine("Done") End If Catch ex As Exception Console.WriteLine(ex.ToString) Console.ReadLine() End Try End Sub End Module The Exact error what I got is : "System.Data.OleDb.OleDbException: Parameter ?_1 has no default value. at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) at ADONetTest.Module1.Main() in D:\Rabi\DotNetPrac\ADONetTest\ADONetTest\Module1.vb:line 176" This String is generated by "Ex.ToString" Tag: How to tell if a timeout exception occures Tag: 125688
  - 18
    - Problem with ADO.NET and dao pia in the same project I have a wierd problem working with ADO.NET and DAO PIA in the same project - it seems that ADO.NET is causing the DAO objects to be destructed. Once I open ADO.NET connection, the DAO objecucts seems destructed (at least thier native part) and I get Unhandled Exception: System.Runtime.InteropServices.COMException (0x800A0D5C): O bject invalid or no longer set. The funny thing about it is that it happened only in release build when run outside of the VS 2005 IDE. The repro code is below. Any idea how to work around this problem ? Thanks, Einat using System; using System.Text; using dao; using System.Data; using System.Data.SqlClient; using System.Runtime.InteropServices; namespace AccessDataTransfer { class Program { static void Main(string[] args) { String Sourcedbstr = "c:\\1.mdb"; String DestConnectionStr = @"Data Source=localhost;Integrated Security=SSPI;Initial Catalog=pubs"; String TableName = "Foo"; //dao connection dao.DBEngineClass engineClass = new DBEngineClass(); dao.Workspace workSpace = engineClass.CreateWorkspace("WorkSpace", "Admin", "", WorkspaceTypeEnum.dbUseJet); dao.Database Sourcedb = workSpace.OpenDatabase(Sourcedbstr, Type.Missing, true, null); dao.Recordset SourceRecordSet = Sourcedb.OpenRecordset(TableName, Type.Missing, Type.Missing, Type.Missing); //ADO.NET connection that invalidate the DAO objects SqlConnection DestConnection = new SqlConnection(DestConnectionStr); DestConnection.Open(); Now manipulate dao object and fails TableDef tblDef = Sourcedb.TableDefs[TableName]; //fails here } } } Tag: How to tell if a timeout exception occures Tag: 125687
  - 19
    - Bypass ADO Hi all, out of curiosity, is there a way to bypass ADO completely and talk directly to SQL Server? Do I have to step in the unmanaged world or can I still achieve it from C#? Thanks, Lorenzo Tag: How to tell if a timeout exception occures Tag: 125681
  - 20
    - Using Widows Authentication and accesssing SQL with SQL Authentication Hi I am working on an application with .NET 2005 and SQL server 2000. I am using windows authentication for my web application authentication and trying to connect to the SQL server with SQL authentication credentials. My web.config reads as follows: web application Authentication: <authentication mode="Windows" /> <authorization> <allow users="*" />   </authorization> <identity impersonate="true" /> SQL Authentication: <connectionStrings> <add name="DevDBConnection" connectionString="Server=MyServer;database=MyDB;uid=MyUser;pwd=MyPwd;" providerName="System.Data.SqlClient" /> </connectionStrings> MY IIS directory security is set to "Integrated Windows authentication". I am validating the user againt the Active Directory for authentication and reading the user details and groups which works fine. But trying to open a connection object fails. I am getting a "{"Cannot open database requested in login 'MyDB'. Login fails.\r\nLogin failed for user 'MyUser'."}" I have tried searching for a solution to my best, but could not solve this problem. I hope some one might have come accross the same problem ahd looking forward for your help. Thanks, Valar Tag: How to tell if a timeout exception occures Tag: 125676
  - 21
    - tranferring data from Access to SQL Server Express I created a VB.Net 1.1 application that iterates through all the tables in any basic Access 2000 database passed to it and generates the same table structure in a SQL Server Express database. The structure is created fine (with minor data conversions from one to the other, e.g. yes/no --> bit, memo --> text, etc). My problem now is transferring the data over from Access to SQL Server. I thought it would be a fairly straight forward process, but I don't think I thought it through that well, unless I am missing something. I currently have the code retrieving a DataTable object from Access one at a time. The only way I can think of now to get the data into SQL Server is to create a DataAdapter for each table in SQL Server and create an InsertCommand for each of adapters. This will involve iterating through all the columns of each table, determing their data types and length, and then adding the parameters. Is this what I have to do, or is there a shorter method? Perhaps dump the Access table to a file and then use bulk import utility (bcp) for example??? Hmmm... Thanks for any help, Marcus *** Please respond to this group. I do not check this email address *** Tag: How to tell if a timeout exception occures Tag: 125675
  - 22
    - Strongly Typed Dataset (1.1) and DataRelation for Navigation Only I am trying to create a strongly typed dataset in .NET 1.1 and am having a problem with adding relations via the design time XSD editor. When you generate a relation at runtime, you have the option of specifying "createConstriants". Normally I would want to have constraints on a relationship, but I am working on a dataset where I only need it for navigation. I can't create a relation with the designer that does not enforce them. Any one know how to do this? Thanks, Eric Marvets MVP - Developer Security Tag: How to tell if a timeout exception occures Tag: 125656
  - 23
    - ORA-01460: unimplemented or unreasonable conversion requested Hi All, We are currently getting a following error ORA-01460: unimplemented or unreasonable conversion requested When we try to insert a double-byte character from our ASP.Net application through ODP.Net version 9. We have our server setting for UTF 8 encoding. This works when we insert diretly through a query or executing the stored proc with the same value using the backend. But the above error is trigerred when we try to do the insert through the ODP Parameter. The Datatype we tried include NVarchar2 and Varchar2. Note: We have made this work by passing datatype as NClob. Like to more information about this error and how to solve it? Regards, Syed. Tag: How to tell if a timeout exception occures Tag: 125649
  - 24
    - Must declare the scalar variable "@" - paramaterized sqlclient insert - HELP!! Below is my code, the error occurs when it is executed. I don't quite understand it; What am I doing wrong? Sub insertADRecords(ByVal oEntry As SearchResult) Dim iIndex1 As Integer Dim strSql, strDN, strProxyAdd, strProxy(), strMyString As String, rowsAffected As Integer strSql = "INSERT INTO Tradoc.dbo.CurrAD (objclass, cn, mailnickname, targetAddress, proxyAddresses, displayname, givenName,initials,sn,title,telephoneNumber,company,department,physicalDeliveryOfficeName,l,st,postalcode, co,adspath) VALUES (@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@))" Dim sqlCMD As SqlClient.SqlCommand = New SqlCommand(strSql, sqlConnection) 'sqlCMD.Connection() = sqlConnection sqlCMD.CommandType = CommandType.Text writeLog(strSql) 'Dim oResult As SearchResult Dim item, strtemp As String sqlCMD.Parameters.Add(New SqlParameter("@objclass", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@cn", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@mailnickname", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@targetAddress", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@proxyAddresses", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@displayName", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@givenName", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@initials", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@sn", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@title", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@telephoneNumber", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@company", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@department", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@physicalDeliveryOfficeName", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@l", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@st", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@postalcode", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@co", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@adspath", SqlDbType.VarChar, 400)) '*********************************************************** sqlCMD.Parameters("@objclass").Value = "contact" Try sqlCMD.Parameters("@cn").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("cn")(0)))) Catch ex As Exception sqlCMD.Parameters("@cn").Value = "" End Try Try sqlCMD.Parameters("@mailnickname").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("mailnickname")(0)))) Catch ex As Exception sqlCMD.Parameters("@targetAddress").Value = "" End Try Try sqlCMD.Parameters("@targetAddress").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("targetAddress")(0)))) Catch ex As Exception sqlCMD.Parameters("@targetAddress").Value = "" End Try Try sqlCMD.Parameters("@proxyAddresses").Value() = Convert.ToString(oEntry.Properties("proxyAddresses")(0)) Catch ex As Exception sqlCMD.Parameters("@proxyAddresses").Value() = "" End Try Try sqlCMD.Parameters("@displayName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("displayName")(0)))) Catch ex As Exception sqlCMD.Parameters("@displayName").Value() = "" End Try Try sqlCMD.Parameters("@givenName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("givenName")(0)))) Catch ex As Exception sqlCMD.Parameters("@givenName").Value = "" End Try Try sqlCMD.Parameters("@initials").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("initials")(0)))) Catch ex As Exception sqlCMD.Parameters("@initials").Value = "" End Try Try sqlCMD.Parameters("@sn").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("sn")(0)))) Catch ex As Exception sqlCMD.Parameters("@sn").Value = "" End Try Try sqlCMD.Parameters("@title").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("title")(0)))) Catch ex As Exception sqlCMD.Parameters("@title").Value = "" End Try Try sqlCMD.Parameters("@telephoneNumber").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("telephoneNumber")(0)))) Catch ex As Exception sqlCMD.Parameters("@telephoneNumber").Value = "" End Try Try sqlCMD.Parameters("@company").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("company")(0)))) Catch ex As Exception sqlCMD.Parameters("@company").Value = "" End Try Try sqlCMD.Parameters("@department").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("department")(0)))) Catch ex As Exception sqlCMD.Parameters("@department").Value = "" End Try Try sqlCMD.Parameters("@physicalDeliveryOfficeName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("physicalDeliveryOfficeName")(0)))) Catch ex As Exception sqlCMD.Parameters("@physicalDeliveryOfficeName").Value = "" End Try Try sqlCMD.Parameters("@l").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("l")(0)))) Catch ex As Exception sqlCMD.Parameters("@l").Value = "" End Try Try sqlCMD.Parameters("@st").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("st")(0)))) Catch ex As Exception sqlCMD.Parameters("@st").Value = "" End Try Try sqlCMD.Parameters("@postalcode").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("postalcode")(0)))) Catch ex As Exception sqlCMD.Parameters("@postalcode").Value = "" End Try Try sqlCMD.Parameters("@co").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("co")(0)))) Catch ex As Exception sqlCMD.Parameters("@co").Value = "" End Try sqlCMD.Parameters("@adspath").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("adspath")(0)))) If sqlConnection.State = ConnectionState.Closed Then sqlConnection.Open() End If Try 'Here's where the error occurs, of course... rowsAffected = sqlCMD.ExecuteNonQuery() Catch ex As Exception writeLog(ex.Message) End Try sqlCMD.Dispose() End Sub Tag: How to tell if a timeout exception occures Tag: 125646
  - 25
    - Must declare the scalar variable "@" - paramaterized sqlclient insert - HELP!! Below is my code, the error occurs when it is executed. I don't quite understand it; What am I doing wrong? Sub insertADRecords(ByVal oEntry As SearchResult) Dim iIndex1 As Integer Dim strSql, strDN, strProxyAdd, strProxy(), strMyString As String, rowsAffected As Integer strSql = "INSERT INTO Tradoc.dbo.CurrAD (objclass, cn, mailnickname, targetAddress, proxyAddresses, displayname, givenName,initials,sn,title,telephoneNumber,company,department,physicalDeliveryOfficeName,l,st,postalcode, co,adspath) VALUES (@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@))" Dim sqlCMD As SqlClient.SqlCommand = New SqlCommand(strSql, sqlConnection) 'sqlCMD.Connection() = sqlConnection sqlCMD.CommandType = CommandType.Text writeLog(strSql) 'Dim oResult As SearchResult Dim item, strtemp As String sqlCMD.Parameters.Add(New SqlParameter("@objclass", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@cn", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@mailnickname", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@targetAddress", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@proxyAddresses", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@displayName", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@givenName", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@initials", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@sn", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@title", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@telephoneNumber", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@company", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@department", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@physicalDeliveryOfficeName", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@l", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@st", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@postalcode", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@co", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@adspath", SqlDbType.VarChar, 400)) '*********************************************************** sqlCMD.Parameters("@objclass").Value = "contact" Try sqlCMD.Parameters("@cn").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("cn")(0)))) Catch ex As Exception sqlCMD.Parameters("@cn").Value = "" End Try Try sqlCMD.Parameters("@mailnickname").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("mailnickname")(0)))) Catch ex As Exception sqlCMD.Parameters("@targetAddress").Value = "" End Try Try sqlCMD.Parameters("@targetAddress").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("targetAddress")(0)))) Catch ex As Exception sqlCMD.Parameters("@targetAddress").Value = "" End Try Try sqlCMD.Parameters("@proxyAddresses").Value() = Convert.ToString(oEntry.Properties("proxyAddresses")(0)) Catch ex As Exception sqlCMD.Parameters("@proxyAddresses").Value() = "" End Try Try sqlCMD.Parameters("@displayName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("displayName")(0)))) Catch ex As Exception sqlCMD.Parameters("@displayName").Value() = "" End Try Try sqlCMD.Parameters("@givenName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("givenName")(0)))) Catch ex As Exception sqlCMD.Parameters("@givenName").Value = "" End Try Try sqlCMD.Parameters("@initials").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("initials")(0)))) Catch ex As Exception sqlCMD.Parameters("@initials").Value = "" End Try Try sqlCMD.Parameters("@sn").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("sn")(0)))) Catch ex As Exception sqlCMD.Parameters("@sn").Value = "" End Try Try sqlCMD.Parameters("@title").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("title")(0)))) Catch ex As Exception sqlCMD.Parameters("@title").Value = "" End Try Try sqlCMD.Parameters("@telephoneNumber").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("telephoneNumber")(0)))) Catch ex As Exception sqlCMD.Parameters("@telephoneNumber").Value = "" End Try Try sqlCMD.Parameters("@company").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("company")(0)))) Catch ex As Exception sqlCMD.Parameters("@company").Value = "" End Try Try sqlCMD.Parameters("@department").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("department")(0)))) Catch ex As Exception sqlCMD.Parameters("@department").Value = "" End Try Try sqlCMD.Parameters("@physicalDeliveryOfficeName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("physicalDeliveryOfficeName")(0)))) Catch ex As Exception sqlCMD.Parameters("@physicalDeliveryOfficeName").Value = "" End Try Try sqlCMD.Parameters("@l").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("l")(0)))) Catch ex As Exception sqlCMD.Parameters("@l").Value = "" End Try Try sqlCMD.Parameters("@st").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("st")(0)))) Catch ex As Exception sqlCMD.Parameters("@st").Value = "" End Try Try sqlCMD.Parameters("@postalcode").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("postalcode")(0)))) Catch ex As Exception sqlCMD.Parameters("@postalcode").Value = "" End Try Try sqlCMD.Parameters("@co").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("co")(0)))) Catch ex As Exception sqlCMD.Parameters("@co").Value = "" End Try sqlCMD.Parameters("@adspath").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("adspath")(0)))) If sqlConnection.State = ConnectionState.Closed Then sqlConnection.Open() End If Try 'Here's where the error occurs, of course... rowsAffected = sqlCMD.ExecuteNonQuery() Catch ex As Exception writeLog(ex.Message) End Try sqlCMD.Dispose() End Sub Tag: How to tell if a timeout exception occures Tag: 125645

If a time out occures an SqlException is thrown, but how can I
programatically tell if the SqlException is a timeout error vs some other
type?

Top

Re: How to tell if a timeout exception occures by Truong

Truong
Thu Mar 09 03:00:30 CST 2006

I suggest you check SqlException.Number. However, I don't know the
error number for connection timeout, you may need to test to see.

Top

Re: How to tell if a timeout exception occures by MrSmersh

MrSmersh
Thu Mar 09 08:47:28 CST 2006

if( sqlException.Number == -2 && sqlException.Class == 10 )
for a normal timeout this is what you get

"Truong Hong Thi" wrote:

> I suggest you check SqlException.Number. However, I don't know the
> error number for connection timeout, you may need to test to see.
>
>

Top

Re: How to tell if a timeout exception occures by Jeremy

Jeremy
Thu Mar 09 10:59:33 CST 2006

Thanks. Are these numbers defined somewhere in the framework, because I
can't find -2 documented there or in the sql documentation.

"MrSmersh" <MrSmersh@discussions.microsoft.com> wrote in message
news:87C17E73-E7DB-4A38-8A31-BD2062420C8E@microsoft.com...
> if( sqlException.Number == -2 && sqlException.Class == 10 )
> for a normal timeout this is what you get
>
> "Truong Hong Thi" wrote:
>
>> I suggest you check SqlException.Number. However, I don't know the
>> error number for connection timeout, you may need to test to see.
>>
>>

Top

Re: How to tell if a timeout exception occures by MrSmersh

MrSmersh
Fri Mar 10 03:25:26 CST 2006

Some of these (Iâ??ve tried to classify the most common exceptions) are in the
SQL Server documentation.
But for some is just plain debugging you got the exception look at the
message and you know now when occurs.
BTW: these are the values you going to get when using the native database
provider, for ODBC there are other conditions.

"Jeremy Chapman" wrote:

> Thanks. Are these numbers defined somewhere in the framework, because I
> can't find -2 documented there or in the sql documentation.
>
>
> "MrSmersh" <MrSmersh@discussions.microsoft.com> wrote in message
> news:87C17E73-E7DB-4A38-8A31-BD2062420C8E@microsoft.com...
> > if( sqlException.Number == -2 && sqlException.Class == 10 )
> > for a normal timeout this is what you get
> >
> > "Truong Hong Thi" wrote:
> >
> >> I suggest you check SqlException.Number. However, I don't know the
> >> error number for connection timeout, you may need to test to see.
> >>
> >>
>
>
>

Top