Connection Pool

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
    - All data is text in ADO Update to Excel... I am updating several excel worksheets using ADO.NET (OLEDB objects). = Everything is working fine except all the data is inserted as text = despite being typed in the DataTable object and when the Excel worksheet = was actually created. If the user-specified Excel Workbook does not exist, one is created and = worksheets are added using "CREATE TABLE" statements with type-specific = data columns. The data type for each column is specified in the = DataTable object as well as the actual "CREATE TABLE" SQL statement. However, if the user-specified workbook already exists, the worksheets = will be updated correctly, but all data will be inserted as text values = regardless of how it is typed in the DataTable. Any help, suggestions, or advice would be greatly appreciated. - Carl Tag: Connection Pool Tag: 100367
  - 2
    - Cascade without relation I have two datatables, dtTable1 has an INDENTITY column, dtTable2 has a integer column to have the value of table1 indentity column but it can be null. so I can't create the relation between tables (unless there is some kind of ignore null relation). Now when I add new row to dtTable1, then add new row to dtTable2 with the same indentity value (of cause a temp value, will change in dtTable1 when save to database) from dtTable1, is there any way to cascade value to dtTable2 when I save data into database? Please... Wei Tag: Connection Pool Tag: 100363
  - 3
    - ADO.NET text driver not importing data as text I have the following comma delimited file to read: Date,campaign code,count 12/1/2004,DM31,10 12/1/2004,DM32,15 12/1/2004,DM33,20 12/1/2004,DM34,25 12/1/2004,DM35,30 I'm using the ADO.NET, System.Data.Odbc namespace to create and ODBCConnection to this file and read it using the following (simplified) code. Dim cn As New OdbcConnection("Driver={Microsoft Text Driver (*.txt; _ *.csv)};DefaultDir=d:\websites\jpg\dataimport;") Dim cmd As New OdbcCommand ("select * From cfr.csv") Dim myreader As OdbcDataReader cn.open() cmd.connection = cn myreader = cmd.executereader() response.write("<table>") While myreader.read() response.write("<tr><td>" & myreader.getstring(0) & "</td><td>" & _ myreader.getstring(1) & "</td><td>" & _ myreader.getstring(2) & "</td></tr>") End While response.write("</table>") cn.close() It outputs the following: 2004-12-01 00:00:00 31.0000 10 2004-12-01 00:00:00 32.0000 15 2004-12-01 00:00:00 33.0000 20 2004-12-01 00:00:00 34.0000 25 2004-12-01 00:00:00 35.0000 30 It converted the second field to a numeric value. I can get it to treat the field as character data if I put the values inside quotes but I don't have control of this file, it's delivered to me from a third party as is. Is there anyway to get it to read the data as plain character data without modifying the file? --Buddy Tag: Connection Pool Tag: 100360
  - 4
    - DateTimePicker problem with .AddNew Hi! My Windows Form contains DateTimePicker to show date-type data from DataTable. Because application need to be able to save "no date" ie. NULL into database table, I solved it like way... ("dtpRepaired" is DateTimePicker-control) dtpRepaired.Checked = Not IsDBNull(dt.Rows(cm.Position)("Repaired")) If dtpRepaired.Checked Then dtpRepaired.Value = Date.Parse(dt.Rows(cm.Position)("Repaired").ToString()) End If Private Sub dtpRepaired_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles dtpRepaired.TextChanged dt.Rows(cm.Position)("Repaired") = IIf(dtpRepaired.Checked, dtpRepaired.Value, DBNull.Value) End Sub ...because I didn't succeeded to do this like this way bounding it directly to the DataTable... 'dtpRepaired.DataBindings.Add(New Binding("Text", dt, "Repaired")) This is almost working fine, but it occurs an error after cm.AddNew when trying to change dtpRepaired-controls value or Checked-state. Error message is: "There is no row at Position 5.". I understand this why, but don't know how I could solve to make it possible to "add new" and make it possible to edit dtpRepaired too without this problem. Any succestions? Is it really impossible to bound DateTimePicker-control to DataTable, and make it possible to change date in DataTable to "NULL" ? Hopefully you understand my problem with my poor english, I'm finnish :) -- Thanks in advance! Mika Tag: Connection Pool Tag: 100358
  - 5
    - Problem catching exception from a procedure Hi! I wrote a procedure in my sybase database this procedure is one line only, and attemp to insert a record in a table generating a constraint violation of a primary key and an exception. I do this only for test... then when I call the procedure from .net: com.Connection = conn com.CommandType = CommandType.StoredProcedure com.CommandText = "PRUEBA" Dim valor Try conn.Open() com.ExecuteNonQuery() Catch ex As System.Data.OleDb.OleDbException ms = ex.Message finally conn.Close() End Try there is not excetion catch!!! , I try several code modification whitout result... Tag: Connection Pool Tag: 100351
  - 6
    - SqlDataAdapter aand transaction Hello, I'm using SqlDataAdapter to insert data from one table into another with SqlCommand after I start a transaction. If I have convertion error for the insertion of the data, The transaction is no longer valid, I'ts rolled back. Is there a property to leave the transaction open ? my code : SqlTransaction trans = m_Conn.BeginTransaction(); SqlCommand oCmd1 = new SqlCommand("Insert into tbl1(col1) select col1 from tbl2", m_Conn); oCmd1.Transaction = trans; oCmd1.ExecuteNonQuery(); Thanks, Sharon Tag: Connection Pool Tag: 100349
  - 7
    - DataSet, new row and default values ? When I add a new row to a DataSet that was filled with info from a database the new row does not get the default values defined in SQL Server, how do I accomplish this seemingly simple task ? I don't want to have to fill in the default values in the row first, I want it to understand the defaults set in the database and fill it automatically as you would expect it to. Thank you PL. Tag: Connection Pool Tag: 100348
  - 8
    - Best aproach to update DataAdapters with XML-Data Hi all What's the best aproach to import xml-based data into an oracle 9i database with ado.net DataAdapters, when the data is in an xml-file? The operations should insert new rows and update changed rows. Does ado.net provide some automatisms for this or do i have to do this with functions written myself? Is there anywhere some example code? Thank you Adrian Tag: Connection Pool Tag: 100347
  - 9
    - Help ... I need somebody Help I have create such a DB -> look at the end: And I would like to have a 2 comboboxes in which I could select all Prog_Id And Profile_Id and in this way modified datasource in each of Rows in table Progs and aloso 6 textboxes to display and modified datasource in each of rows in Profile_Base. How it can be done in the fastest way ?? It is really urgent, beacuse i sit on it 3 days !! Thanks in advance ----------------------------------------- CREATE DOMAIN For_Prog_ID AS VARCHAR(20); CREATE DOMAIN For_SubProgs As VARCHAR(20); CREATE TABLE Profile_Base( Profile_ID For_SubProgs NOT NULL PRIMARY KEY, Param_1 FLOAT, Param_2 FLOAT, Param_3 FLOAT, Param_4 FLOAT, Param_5 FLOAT, Param_6 FLOAT ); CREATE TABLE Progs ( Prog_ID For_Prog_ID NOT NULL PRIMARY KEY, Profile_S1 For_SubProgs, Profile_S2 For_SubProgs, Tenon_S1_S1 For_SubProgs, Tenon_S1_S2 For_SubProgs, Tenon_S2_S1 For_SubProgs, Tenon_S2_S2 For_SubProgs, FOREIGN KEY (Profile_S1) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Profile_S2) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Tenon_S1_S1) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Tenon_S1_S2) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Tenon_S2_S1) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Tenon_S1_S2) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE ); -------------------------------- *-----------------------* Posted at: www.GroupSrv.com *-----------------------* Tag: Connection Pool Tag: 100344
  - 10
    - How To Recursively Search Directories by Using C# .NET I've found this script on microsoft site that searches for file with given extension, its window based. How can i convert it to make it web based? I am looking for a c# script that will search a particular drive with given file extension and email the search result. http://support.microsoft.com/default.aspx?scid=kb;en-us;303974 Please help.. many thanks in advance. Tag: Connection Pool Tag: 100340
  - 11
    - Updating table at a different database Hello, I'm using SqlDataAdapter to get records from table at database different from my connection using the databasename at the select statment "Select * from otherdb..myTable" After updating the data I want to update the table, I'm using SqlCommandBuilder to set the UpdateCommand at the SqlDataAdapter. But when I use the SqlDataAdapter.Update I get an error : "Invalid object name 'myTable'" I tried to change the UpdateCommandText to "Update otherdb..myTable ..." but it's not working. I don't want to use another connection. Is there a way of making it work? Thanks, Sharon. Tag: Connection Pool Tag: 100336
  - 12
    - Printing excel files Hi. Can anybody help me on how to print excel files that has been read via ADO.NET. Or anyway, what I want to avoid is automation (instantiating an excel application object). Hopefully, there is way aroudn this.. Thanks in advance. Tag: Connection Pool Tag: 100324
  - 13
    - higher reads when using ADO.NET thatn when using Query Analyzer I was doing some testing and noticed that when I execute a stored procedure from my ADO.NET (using the Command class of the System.Data.SQLClient namespace) the number of reads on a relatively simple query were significantly higher. As a matter of fact I have not found a case where the reads when executed from ADO.NET are lower than the reads when executing in QA. Sometimes they may be the same but QA is always has equal or fewer reads. Any reason why this is and is there any thing I can do to get ADO.NET to perform like QA? --Buddy Tag: Connection Pool Tag: 100317
  - 14
    - OleDbConnection problem with more than 1 connection Hi, I had wrote 2 app in c#.net one Windows Form base and one Web Base and those 2 connect to a access database and some time I got this error in my web base application and I can't figure out what's wrong, I just hit reload and it's work Thanks for your time Sylvain Bissonnette Server Error in '/WebApplication1' Application. Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt. Source Error: Line 77: // Open database connection Line 78: OleDbConnection MyConn = new OleDbConnection(ConnectionString); Line 79: MyConn.Open(); Line 80: Line 81: // Create the data adapter and execute the query Source File: C:\Inetpub\wwwroot\WebApplication1\Light.aspx.cs Line: 79 Stack Trace: [OleDbException (0x80004005): Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.] System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20 System.Data.OleDb.OleDbConnection.InitializeProvider() +57 System.Data.OleDb.OleDbConnection.Open() +203 WebApplication1.Light.MyDataGrid_ItemCommand(Object source, DataGridCommandEventArgs e) in C:\Inetpub\wwwroot\WebApplication1\Light.aspx.cs:79 System.Web.UI.WebControls.DataGrid.OnItemCommand(DataGridCommandEventArgs e) +110 System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e) +68 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26 System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source, EventArgs e) +106 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +121 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +115 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277 Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 Tag: Connection Pool Tag: 100315
  - 15
    - Command Builder in tables without primary key Hi every one, i'm trying to use a sqlcommandbuilder in an application using a table without a primary key, when i call the DataAdapter.Update Method there comes an Error saying that "the selectcommand does not return information about the primary key" or some thing like that... Does some one knows a way to implement the command builder or similar method to work around on updating tables with out primary key?? Tag: Connection Pool Tag: 100306
  - 16
    - SqlHelper.UpdateDataSet with transaction Hi, I'm trying to use the SqlHelper.UpdateDataSet method with transactions. The DAAB 2.0 documentaion only say: "SqlHelper.UpdateDataset does not include transaction support. If you need this, you can implement it yourself by a preceding call to the helper method SqlHelper.ExecuteScalar("begin transaction")." but I didn't find any matching overload in the ExecuteScalar method. What would be the correct way of using the UpdateDataSet with transaction? Thanks, Gwenda Tag: Connection Pool Tag: 100293
  - 17
    - encapsulating SQL queries into OO framework Right now I'm putting my query strings into static functions in a DbQuery class that returns Datatables. Eg. public class DbQuery { public static Datatable GetMyData() { Dataset ds; ... string query = "select * from SomeTable"; .... return ds.Tables[0]; } } Over time, I'm accumulating a lot of static methods in my DbQuery class. This way seems very procedural. I'm trying to make it more object oriented. Any recommendations on how to encapsulate individual queries into a more object oriented framework? Tag: Connection Pool Tag: 100291
  - 18
    - How to update one table based on a match found in another Hi I'm trying to figure out the best way to perform a simple but repetitive task in vb.net. Access DB with 2 tables: first table - a list of phone numbers not to call and a table holding contact information. Both tables have a 'telephone' column and I need to set a logical flag = 1 in the second table only if a match is found in the first. I've tried using a single Dataadapter for each and two Datasets and every other combination. I've even tried example code from MS (KB Q308057) but this doesn't work. However, when I try to retrieve a record it all falls apart and vb.net throws a relation exception that I cannot fathom out. I know I can run a simple update query - but want to do this programatically. If anyone can throw me a bone or suggest a place to start again - I really would appreciate any help. With thanks Tag: Connection Pool Tag: 100284
  - 19
    - MSDN Webcast: Introducing ADO.NET 2.0 for SQL Server 2005 We'll host a webcast on ADO.NET 2.0 & SQL Server 2005 next week. I thought you guys might be interested. For more information you can check out: http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032263284&Culture=en-US This is part of a webcast series on SQL Server that will take place during the week. For more information about the series you can look at: http://msdn.microsoft.com/sql/2005webcasts/default.aspx Thanks, -- Pablo Castro Program Manager - ADO.NET Team Microsoft Corp. This posting is provided "AS IS" with no warranties, and confers no rights. Tag: Connection Pool Tag: 100282
  - 20
    - DataObjects.NET OR mapping, any opinions ? Hajo, I consider to use DataObjects.NET (http://www.x-tensive.com/Products/DataObjects.NET/) and I need any opinions about this solution. 1. Is is mature enaugh to use it in commercial project? 2. Can it work seamlessly with Oracle data base? thanks in advance for info Gawel Tag: Connection Pool Tag: 100281
  - 21
    - Storing missing values For a column in (eg an Access) database that's used to store numeric data, is there a specific way to designate a missing value for a given row (ie the value was simply never measured or assigned). Or must I set up my own convention, ie if it's a short type then to use eg -32768 or -999 (or some other value obviously outside the valid range for that column)? JGD Tag: Connection Pool Tag: 100279
  - 22
    - System.Data.OracleClient Version Recently I started a project attempting to connect to an Oracle 9i database using the System.Data.OracleClient namespace with .Net 1.1. The database's service name is longer than 16 characters & I have since found that their is indeed a bug limiting service names to 16 characters in the namespace. What is the latest version of the library I should be using? The assembly version (installed on my development environment) for System.Data.OracleClient is 1.0.5000.0. Is there a fix forthcoming if this is the latest version? Tag: Connection Pool Tag: 100277
  - 23
    - Passwords with Special Characters I'm trying to figure out a general algorithm to allow any valid MS SQL 2000 username/password combination to log into a Winform application. I'm having trouble with special characters. I'm created a user named test The password assigned is test'"; (that is, the word test, followed by a single quote, followed by a double quote, followed by a semi-colon) In the connection string, I've tried quoting the password with double quotes and doubling each double quote in the password. That causes the code to run fine (no runtime exceptions), but it can't log into the SQL server. I also tried the above with single quotes instead of double quotes. That doesn't work either. If I change the password to test' I can then place double quotes around it, and it works fine. If I change the password to test" I can plance single quotes around it and it works fine. But I can't get the combination of both single and double quotes in a single password to work. Thanks in advance! Tag: Connection Pool Tag: 100276
  - 24
    - Stored procedure not returning a value in @RETURN_VALUE Hi everyon, I am experiencing a problem with a stored procedure not returning a value in the parameter @RETURN_VALUE when debugging in C#. The stored procedure looks something like this: CREATE PROCEDURE dbo.ListSomething @myParam int AS declare @rc int set @rc = 0 select * from dbo.myTable where myField = @myParam if (@@error <> 0) set @rc = @@error return @rc When I run this stored procedure in Query Analyzer, it works as expected returning any matching records and a return value of 0. For information, the SQL I'm using in Query Analyzer is: declare @rc int exec @rc = ListSomething 123 select @rc In my C# code though, when I query the @RETURN_VALUE parameter in the Parameters collection of the SqlCommand, all I ever get is "undefined value". Even if I change the stored procedure to return something specific such as 1, 2, 3, etc. The code I'm using is: SqlConnection DBConnection = new SqlConnection(); SqlCommand DBCommand = new SqlCommand(); DBConnection.ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;database=myDatabase;server=myServer"; DBConnection.Open(); DBCommand.Connection = DBConnection; DBCommand.CommandText = "ListSomething"; DBCommand.CommandType = CommandType.StoredProcedure; SqlCommandBuilder.DeriveParameters(DBCommand); if (DBCommand.Parameters.Count > 1) { foreach (SqlParameter SPParameter in DBCommand.Parameters) { // set the value of each input parameter } } SqlDataReader CommandResults = DBCommand.ExecuteReader(CommandBehavior.CloseConnection); if (DBCommand.Parameters["@RETURN_VALUE"].Value == 0) { // display results from stored procedure } else { // raise an error } CommandResults.Close(); I have read that the use of DeriveParameters is not recommended because of the additional roundtrip to the server, but this isn't an issue for me as the stored procedures are not going to be used that often, and I need a way of dynamically building the parameters list for population without having to define all of them in advance. When I debug the code, the line that reads the value of @RETURN_VALUE fails as it has an "undefined value". The return value just isn't coming back from the stored procedure, even though through Query Analyzer it is being returned. Is anyone able to help me get the return value from my stored procedure please? I've searched the internet but haven't had much luck. Many thanks in advance Adam Ainger Tag: Connection Pool Tag: 100272
  - 25
    - Aggregate data columns not working after the dataset is deserializ Hi, I have a dataset with three tables in it. A parent table MenuPricing and two child tables Labor and Parts. In the MenuPricing table I created a data column named TotalPrice with the following expression: Sum(Child(relParts).TotalPrice). See the xml source below. This dataset will work fine if used locally ie in the same app domain. But if I access this dataset from a web service, I get the error below. Is there a way arround this bug? System.InvalidOperationException: There is an error in XML document (1, 4190). ---> System.Data.EvaluateException: Cannot find column [TotalPrice]. at System.Data.AggregateNode.Bind(DataTable table, ArrayList list) at System.Data.DataExpression.Bind(DataTable table) at System.Data.DataExpression..ctor(String expression, DataTable table, Type type) at System.Data.DataColumn.set_Expression(String value) at System.Data.Merger.MergeSchema(DataTable table) at System.Data.Merger.MergeTableData(DataTable src) at System.Data.Merger.MergeDataSet(DataSet source) at System.Data.DataSet.Merge(DataSet dataSet, Boolean preserveChanges, MissingSchemaAction missingSchemaAction) at ServiceMonitor.SMService.MenuPricingDS.ReadXmlSerializable(XmlReader reader) in C:\softdev\CS\SM2\ServiceMonitor\Web References\SMService\Reference.cs:line 7407 at System.Data.DataSet.System.Xml.Serialization.IXmlSerializable.ReadXml(XmlReader reader) at System.Xml.Serialization.XmlSerializationReader.ReadSerializable(IXmlSerializable serializable) at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReader1.Read13_GetMenuPricingResponse() --- End of inner exception stack trace --- Dataset definition: <?xml version="1.0" encoding="utf-8" ?> <xs:schema id="MenuPricingDS" targetNamespace="http://tempuri.org/MenuPricingDS.xsd" elementFormDefault="qualified" attributeFormDefault="qualified" xmlns="http://tempuri.org/MenuPricingDS.xsd" xmlns:mstns="http://tempuri.org/MenuPricingDS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop"> <xs:element name="MenuPricingDS" msdata:IsDataSet="true"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element name="Labor"> <xs:complexType> <xs:sequence> <xs:element name="DealerID" type="xs:short" minOccurs="0" /> <xs:element name="MpHeaderID" type="xs:int" minOccurs="0" /> <xs:element name="MpLaborID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" minOccurs="0" /> <xs:element name="Description" type="xs:string" minOccurs="0" /> <xs:element name="Quantity" type="xs:float" minOccurs="0" /> <xs:element name="HourRate" type="xs:decimal" minOccurs="0" /> <xs:element name="TotalPrice" type="xs:decimal" minOccurs="0" msdata:Expression="Quantity * HourRate" /> <xs:element name="OpCode" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Parts"> <xs:complexType> <xs:sequence> <xs:element name="DealerID" type="xs:short" minOccurs="0" /> <xs:element name="MpHeaderID" type="xs:int" minOccurs="0" /> <xs:element name="MpPartID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" minOccurs="0" /> <xs:element name="PartNo" type="xs:string" minOccurs="0" /> <xs:element name="Quantity" type="xs:float" minOccurs="0" /> <xs:element name="Description" type="xs:string" minOccurs="0" /> <xs:element name="UnitPrice" type="xs:decimal" minOccurs="0" /> <xs:element name="TotalPrice" type="xs:decimal" minOccurs="0" msdata:Expression="Quantity * UnitPrice" /> <xs:element name="Cost" type="xs:decimal" minOccurs="0" /> <xs:element name="Profit" type="xs:decimal" minOccurs="0" msdata:Expression="UnitPrice - Cost" /> <xs:element name="TotalProfit" type="xs:decimal" minOccurs="0" msdata:Expression="(Quantity * UnitPrice) - (Quantity * Cost)" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="MenuPricing"> <xs:complexType> <xs:sequence> <xs:element name="DealerID" type="xs:short" /> <xs:element name="MpHeaderID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" /> <xs:element name="Description" type="xs:string" /> <xs:element name="YearID" type="xs:int" /> <xs:element name="ModelID" type="xs:int" /> <xs:element name="CategoryID" type="xs:int" /> <xs:element name="ShowOnWeb" type="xs:boolean" /> <xs:element name="PrePaid" type="xs:boolean" /> <xs:element name="Rental" type="xs:boolean" minOccurs="0" /> <xs:element name="TotalParts" type="xs:decimal" minOccurs="0" msdata:Expression="Sum(Child(relParts).TotalPrice)" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:unique name="MenuPricingDSKey1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:MenuPricing" /> <xs:field xpath="mstns:DealerID" /> <xs:field xpath="mstns:MpHeaderID" /> </xs:unique> <xs:keyref name="relParts" refer="MenuPricingDSKey1" msdata:DeleteRule="Cascade" msdata:UpdateRule="Cascade"> <xs:selector xpath=".//mstns:Parts" /> <xs:field xpath="mstns:DealerID" /> <xs:field xpath="mstns:MpHeaderID" /> </xs:keyref> <xs:keyref name="relLabor" refer="MenuPricingDSKey1" msdata:DeleteRule="Cascade" msdata:UpdateRule="Cascade"> <xs:selector xpath=".//mstns:Labor" /> <xs:field xpath="mstns:DealerID" /> <xs:field xpath="mstns:MpHeaderID" /> </xs:keyref> </xs:element> </xs:schema> Tag: Connection Pool Tag: 100269
- Next
  - 1
    - Datagrid SortCommand does not work ??? Hi There I have a datagrid with a Select(LinkButton) Column followed by several Bound Columns. I have enabled the columns to sort and created the correct event handler (I think) - however the crux of my problem is that when I click on one of the column headers to sort by it the ItemCommand fires rather than the SortCommand. in the .aspx file I have: OnItemCommand="SalesGroupInitial_ItemCommand" OnSortCommand="SalesGroupInitial_SortCommand" which correlate to the .aspx.vb file (I also have an OnItemDatabound event if that is of any significance) I have not included the code at this juncture as it is a flat case of the wrong event firing when I click the Column Header Any ideas would be very much appreciated Stuart Tag: Connection Pool Tag: 100267
  - 2
    - Error Message: Timeout expired. Hello there, I have about 50 users who use an asp.net application i made. For a while there were no problems but now i see a lot of timeout expired messages i diiferent forms of my application. See the stack trace below: What can i do to avoid this? Thnx in advance, Victor Error Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Page Error Occured: /webgabprod/Administration/administration.aspx ExceptionType: System.Data.SqlClient.SqlException Stack trace: at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at WebGab.WebForm1.GetAanvragen() at WebGab.WebForm1.btn_zoek_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain() Tag: Connection Pool Tag: 100251
  - 3
    - concurrency violation with bound control Hi. I'm sorry if this is a repost. Please reply with existing links, if any. I have a list box with a datatable as data source. I edit an item from the list box (by changing the item in the datatable) and call the update method() of a data adapter. My problem is I get a concurrency violation saying no rows were affected. Tag: Connection Pool Tag: 100241
  - 4
    - DataTable.LoadDataRow - can you improve on this? DataTable is dt, filled already and with keys defined, uid, seq etc, suitable variables ... object[] newRow = new object[5]; newRow[0] = uid; newRow[1] = seq; newRow[2] = text; newRow[3] = type; newRow[4] = data; dt.LoadDataRow(newRow,false); >>>> I don't like this because it relies on the column positions - of course I could use an enumeration for readability but that wouldn't remove the underlying problem >>>> I can create a detached row with thr right schema DataRow newRow = dt.NewRow(); >>>> and then fill the columns by name .... newRow["uid"] = uid; newRow["seq"] = seq; >>>> which is great, but then there is no overloaded method for .LoadDataRow, which allows me to load that data ... any suggestions for achieving the required effect - loading data without hardwiring the column positions? Cheers Jim Tag: Connection Pool Tag: 100239
  - 5
    - ado vs oledb Hi, I use to program using VB + ADO with MS Access. however, i've read that oledb is faster and better then ADO to access to DB. could you tell me in which wqy is it faster ? what i've seen till now, it's that i need 3 times more code lines to do the same thing. thanks a lot, PM Tag: Connection Pool Tag: 100230
  - 6
    - Using DSN in connection string with SqlConnection Object I want to use DSN in Connection string. But for opening connection i am using 'SqlConnection' object. i.e using System.Data.SqlClient; So is it possible to use DSN in connection string with 'SqlConnection' object. OR i should go only for 'OdbcConnection'. Tag: Connection Pool Tag: 100229
  - 7
    - best way to retrieve thousands of records. I have currently using a dataset to access my data from sql server 2000. The dataset contains 3 tables that is related to each other. parent/child/grandchild relationship. My problem is it's very slow to retrieve records from sql server. I'm using sqldataadapter.fill method to populate dataset. Parent table contains more than 3,000 records and child table contains more than 10,000 records and grandchild table contains more than 90,000 records as of now. I tried to limit the number of records to return by a select command using the criteria but my problem is I dont know how to limit the number of records return by a 3rd table (grandchild). I'm using textboxes in parent table and datagrid in 2nd and 3rd table. There is no problem querying the 1st and 2nd table but I don't know how to query the 3rd table. 3rd table must know first the primary key value of the 2nd table that is stored in a datagrid. but don't know how to do this. Anyone know what is the better way to access this data? I would love to read some article about techniques on accessing table that has a relationship up to 3rd table (grandchild). thanks in advance. Tag: Connection Pool Tag: 100222
  - 8
    - Is there any way to know if a connection is in a transaction? Greets. A very simple question in the topic, probably takes about 10 seconds for an expert to answer =) Thanks .. Tag: Connection Pool Tag: 100217
  - 9
    - DataGridView error Hi, i have DataGridView whose sourse i set to a datatable with 5 columns containing data. i then remove the 3rd column, created a DataGridViewComboBoxColumn, set it's DataSource, ValueMember and DisplayMember. the Valumeber is an integer and the displaymember is a string. I then instert this into the same location as the column that was removed. the problem i am getting is when the Grid is loaded, i get errors stating "System.FormatException: the value of the DataGridViewComboBoxCell is invalid. To replace this default dialog, please handle the DataError event.". Why is this error happening? here is the code that does the replacing and adding of a combo box: private void addExchangeLookUpCombs( DataGridView dt ) { dt.Columns.Remove( "exchange_id" ); DataGridViewComboBoxColumn cb = new DataGridViewComboBoxColumn( ); cb.DataSource = DbConnection.instance.getDbTable("StockExchange"); cb.ValueMember = "exchange_id"; cb.DisplayMember = "symbol"; cb.FlatStyle = FlatStyle.Flat; dt.Columns.Insert( 2, cb ); } Tag: Connection Pool Tag: 100215
  - 10
    - RowState Question Hi folks, I'm reading through David Sceppa's excellent ADO.NET book, trying to teach myself ADO.NET, and have a question about the RowState property. If I add a new row to a DataTable, it has a RowState of 'Added'. If I modify an existing row, its RowState is 'Modified'. If I add a row, but before I call AcceptChanges I modify that row, is it still 'Added'? I guess it has to be ... but what happens to the data I first entered into the row that I might have overwritten with the subsequent edit? Just trying to get a handle on how this stuff fits together :) Cheers, Matt Tag: Connection Pool Tag: 100209
  - 11
    - RowState Undelete? A row was deleted in a DataTable, and now I want to bring it back so I can remove it (so my dataadapter will not touch it later). How can I do that? Thanks. replaceExisting Tag: Connection Pool Tag: 100201
  - 12
    - OracleDataReader returning no rows or data even though data exists Hi All, I am trying to get result from Oracle Function that returns a number. When I rum from SQL Plus I could see the result. When I call from my C# application I get no data. I am using System.data.OracleClient to access oracle function on Database 8.1.7. I am using Oracle 9i client from my application to connect to 8.1.7 Database. I am able to get results if i use query like select * from table name. I have paseted my code and Oracle function below. I would really appreciate any help As I have spent couple of days trying to get it work. //Oracle Function create function test_func return number as begin return 5; end; C# code StringBuilder commandText = new StringBuilder("TEST_FUNC"); string str = "Data Source=EXP_DUP;User Id=test;Password=tst;Integrated Security=no;" ; System.Data.OracleClient.OracleConnection Conn = new OracleConnection(str); OracleCommand DSCmd = new OracleCommand(commandText.ToString(),Conn); Conn.Open(); DSCmd.CommandType = CommandType.StoredProcedure; //Set OUT parameter direction DSCmd.Parameters.Add("RC", OracleType.Number).Direction = ParameterDirection.ReturnValue; try { OracleDataReader dataReader = DSCmd.ExecuteReader(); if( dataReader.HasRows) { while (dataReader.Read()) { System.Windows.Forms.MessageBox.Show(dataReader.GetString(0).ToString()); } } dataReader.Close(); } catch( Exception ex) { System.Windows.Forms.MessageBox.Show(ex.ToString()); } Please any suggestions on how to achieve this or what am I missing. Thanks in Advance, MS Tag: Connection Pool Tag: 100199
  - 13
    - How can I format date in databound combobox in windows app? Hi, I have a combobox bound to a smalldatetime column in a table. The ComboBox displays all available dates. However it displays them in long format and I want to display them in short format. Is this possible? Tag: Connection Pool Tag: 100196
  - 14
    - Displaying dates in dd/mm/yy format I have two Date/Time fields in my Access 2003 database. The VB.NET app I'm developing (and making some real progress with) uses TextBoxes to input these as part of a record in a DataSet. Problem: Access always stores years as 4 digits, and it automatically tags a time onto the field, so when the user enters: 30/11/04 I end up with: 30/11/2004 00:00:00 when I view the record after it's created; the DataSet is populated using the database schema. Since the TextBox is set to display only 8 characters, this is annoying at best. The only way I can think of around this is to store the date as a string and write a validation handler for each TextBox that inputs dates. But is there a better way? Can I somehow force Access to store the short date and nothing else? Tag: Connection Pool Tag: 100193
  - 15
    - Very simple INSERT INTO with a DateTime parameter -> "Syntax Error in INSERT INTO statement" Hello. The following very simple code does not seem to accept the DateTime variable as a parameter - why? The table (MS Access db) here contains only a primary key and a column Date of type date/time. connection.Open(); transaction = connection.BeginTransaction(); commandString = "INSERT INTO [Events] (Date) Values(@Date)"; command = connection.CreateCommand(); command.CommandText = commandString; command.Transaction = transaction; OleDbParameter param_Date = new OleDbParameter("@Date", OleDbType.DBTimeStamp); // Also tried DBTime and DBDate param_Date.Value = date; // date == DateTime command.Parameters.Add(param_Date); // Execute command command.ExecuteNonQuery(); // Syntax error in INSERT INTO statement??? Tag: Connection Pool Tag: 100189
  - 16
    - Read-only transaction in Oracle Hello All; Does anybody know any way to start read-only Oracle transaction in .NET application? This mode can be set in PL/SQL by SET TRANSACTION READ ONLY statement, but Oracle provider for .NET does not support such isolation level. Thank you, Maxim Tag: Connection Pool Tag: 100187
  - 17
    - Add Raw DataRow Collection? I have a remote DataTable and I want to add 5 DataRows to it. My current code does a "remoteTable.Rows.Add( new object[] { .... } );". That results in 5 remote calls, which is bad. I already know the schema of the remote DataTable. Is it possible to create a DataRow collection, populate all 5 rows, and then send than entire collection to the DataTable? Thanks. Tag: Connection Pool Tag: 100177
  - 18
    - mapping 2 datatable columns to one datagrid column Is this possible? I want to concatenate two columns in my table and display them in one datagrid column. I have a TableStyle where I create DataGridColumnStyle's. I'd like to set the MappingName to two columns but I dont see how this can be done. Thanks. Tag: Connection Pool Tag: 100175
  - 19
    - Use of undocumented sp_MSforeachtable and MStablespace What is wrong with the following code? What I want to do is to store the results of MStablespace for every table in a DataTable. The result contains the number of rows and the data space and the index space. This seems to be okay, because dataTable has three columns after executing the code. The problem is, that I get only one row. using ( SqlConnection conn = new SqlConnection(connString) { conn.Open(); SqlCommand cmd = new SqlCommand("sp_MSforeachtable", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@command1","exec sp_MStablespace '?'"); SqlDataAdapter adapter = new SqlDataAdapter( cmd ); DataTable dataTable = new DataTable("Statistics"); adapter.Fill(dataTable); } Thanks for any hints, Hans Tag: Connection Pool Tag: 100169
  - 20
    - question for the minds This is what should be an easy question, but I can't get it through my head. Can someone help me undestand the following? The way I see it, .DataSource is whatever you decide to refer back to thel the Datalist in my case it is an array: System.Collections.ArrayList al = new ArrayList(); DropDownLIst1.DataBind(); is the call that I have to bind my fields that is an easy one, but for the life of me I DON'T GET: DropDownList1.DataTextField="Name"; DropDownList1.DataValueField="ID"; It doesn't make sense to me what the difference is for DataTExtField and DataValueField. It seems that it doesn't matter one way or another, can someone help me understand? Provided below are all of the items but my question only lies in the ones marked Q: DropDownList1.DataSource=al; Question: DropDownList1.DataTextField="Name"; Question: DropDownList1.DataValueField="ID"; DropDownList1.DataBind(); Tag: Connection Pool Tag: 100167
  - 21
    - [BUG?] (2) Update database using stored procedure and OleDbDataAdapter.Update As suggested by Cor Ligthert, i've created a simpler sample, with the same problem; this is the full source code, so everyone can try itself: Access database "dati.mdb": Tables: "myTable" Fields: fNumber Numeric fString VarChar(50) No primary keys defined. Stored Procedures: "qry_Ins": PARAMETERS [@fNumber] Long, [@fString] Text ( 255 ); INSERT INTO myTable ( fNumber, fString ) VALUES ([@fNumber], [@fString]); C# Project: Only 1 WebForm (WebForm1.aspx) ////////////////////////////////////////// // Code Start ////////////////////////////////////////// private void Page_Load(object sender, System.EventArgs e) { OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source=" + Server.MapPath("dati.mdb") + ";"); conn.Open(); OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM myTable", conn); DataSet ds = new DataSet(); // The table is initially empty so ds has no rows da.Fill(ds, "myTable"); OleDbCommand upCmd = new OleDbCommand("qry_Ins", conn); upCmd.CommandType = CommandType.StoredProcedure; upCmd.Parameters.Add("@fNumber", OleDbType.Integer, 0, "fNumber"); upCmd.Parameters.Add("@fString", OleDbType.VarChar, 50, "fString"); da.InsertCommand = upCmd; int i = 1; while (i<=20) { ds.Tables["myTable"].Rows.Add(new object[] {i, "data_" + i}); i++; } da.Update(ds, "myTable"); conn.Close(); conn = null; } ////////////////////////////////////////// // Code End ////////////////////////////////////////// This is the output in the database after 1 execution of the above code: fNumber fString 1 data_1 1 data_2 1 data_3 1 data_4 1 data_5 1 data_6 1 data_7 1 data_8 1 data_9 1 data_1 1 data_1 1 data_1 1 data_1 1 data_1 1 data_1 1 data_1 1 data_1 1 data_1 1 data_1 1 data_2 As visible, fNumber is always 1, and fString is truncated to 6 chars. So, how to fix? It's a BUG??? Tag: Connection Pool Tag: 100163
  - 22
    - newbie question. Hello, I have backed up a table from a database in an DataTable (dt ) object. The table has been wiped up (in sql server) after the backup but i still have the copy in memory (in my DataTable object ). now i need to restore the table from memory. Is there a quick way of doing this apart from a row by row insert? I'm not using typed dataset. Many thanks in advance JB Tag: Connection Pool Tag: 100162
  - 23
    - XML Dataset I have a dataset that is based on an xml file, which contains the same structure as a sql server table and is exported from a dataset. When I do: sqlDataAdapter.Update(dataset, strTableName) I get the error: "Missing the DataColumn 'InspectionDate' in the DataTable 'tblEquipmentInspections' for the SourceColumn 'InspectionDate' The reason the column InspectionDate is missing is beacuse its a null value and when you export a dataset to xml in dot net it doesn't create an entry for any null columns in the xml. I'm guessing I need to do something with table mappings but I'm not sure where to go. Any ideas ? Many thanks Séan Tag: Connection Pool Tag: 100161
  - 24
    - Annoying Bug with parent-child-grandchild relationships. Tables: Parent, Child, Toys Relationships: ParentToChildRel, ChildToToysRel. dataGridParent.Datamember="Parent"; dataGridChild.Datamember="Parent.ParentToChildRel"; dataGridToys.Datamember="Parent.ParentToChild.ChildToToysRel"; all grids pointing to same datasource. the flaw is that when a move to a parent, whose child has no toys but the previous one had, datagridToys still shows the toys of the previous one instead of none. I think this is a bug, because it should display none. Tag: Connection Pool Tag: 100156
  - 25
    - how to move record forward or backward hi all I have got a datareader by sqlcommand, now I wanna move forward or backward, but I don't find first,last,prior and next methods. How can I do it? thanks for your suggestion. hui Tag: Connection Pool Tag: 100150

Hello,

Is it ado provider by default do the connection pooling? or it is depending
on the database. I know sqlclient provider does the connection pooling but
can I use connection pooling with MYSQL?

thanks
ap

Top

Re: Connection Pool by Paul

Paul
Thu Dec 02 13:42:00 CST 2004

On Thu, 2 Dec 2004 11:13:08 -0800, "ap" <ap@discussions.microsoft.com> wrote:

¤ Hello,
¤
¤ Is it ado provider by default do the connection pooling? or it is depending
¤ on the database. I know sqlclient provider does the connection pooling but
¤ can I use connection pooling with MYSQL?
¤

Connection pooling is enabled by default unless the data provider does not support the feature.

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Top

Re: Connection Pool by Miha

Miha
Thu Dec 02 13:48:30 CST 2004

"ap" <ap@discussions.microsoft.com> wrote in message
news:2F481944-6592-4DD7-99F7-DDBAED2C1DDA@microsoft.com...
> Hello,
>
> Is it ado provider by default do the connection pooling? or it is
> depending
> on the database. I know sqlclient provider does the connection pooling
> but
> can I use connection pooling with MYSQL?

With native provider? If provider supports it then yes, otherwise not -
depends on provider.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

Top

Re: Connection Pool by Sahil

Sahil
Thu Dec 02 14:00:52 CST 2004

This is implemented in the provider - and is provider specific. SqlClient
does it by default - unless you disable it. That is the default behavior in
99% of the cases.

For more info please see --
http://dotnetjunkies.com/WebLog/sahilmalik/archive/2004/11/12/31798.aspx

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

"ap" <ap@discussions.microsoft.com> wrote in message
news:2F481944-6592-4DD7-99F7-DDBAED2C1DDA@microsoft.com...
> Hello,
>
> Is it ado provider by default do the connection pooling? or it is
depending
> on the database. I know sqlclient provider does the connection pooling
but
> can I use connection pooling with MYSQL?
>
>
> thanks
> ap

Top