Problem with Framework

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
    - How to capture sql command text when DbDataAdapter's Update is cal Hi, We are having a major debugging problem here and would like to take advices from anyone. In our app, we need to update our dataset using DbDataAdapter against Oracle database. Once we have issues, like invalid data or something like that, the update will fail but only with limited returned message. It would be extramly helpful if we could somehow capture the SQL text that built by the ADO.Net, right before or after the Update is called. Is there a way to do that? Thanks Feng Tag: Problem with Framework Tag: 118298
  - 2
    - Sending email from within a WebService (sorry for the dual post here and the webservice NG. I meant to send to both at the same time) I have a method which sends email to & from a specific account. All was working fine until the server was upgraded to an AD/DNS server. Now the email never goes through. I can run the same code from an exe and it works fine. MailMessage mail = new MailMessage(); mail.Body = msg; mail.From = emailfrom; mail.To = emailto; mail.Subject = "Test."; mail.Fields["http://schemas.microsoft.com/cdo/configuration/smtpauthenticate"] = 2; mail.Fields["http://schemas.microsoft.com/cdo/configuration/smtpserver"] = "mail.mydomain.com"; mail.Fields["http://schemas.microsoft.com/cdo/configuration/smtpserverport"] = 25; mail.Fields["http://schemas.microsoft.com/cdo/configuration/sendusername"] = "sender@mydomain.com"; mail.Fields["http://schemas.microsoft.com/cdo/configuration/sendpassword"] = "******"; SmtpMail.SmtpServer = "mail.mydomain.com"; SmtpMail.Send(mail); Does the service need to be granted a certain permission? Tag: Problem with Framework Tag: 118295
  - 3
    - Working with different kinds of databases Hi, How can I make my application work with SQL Server, Oracle, MySql, etc? _dino_ Tag: Problem with Framework Tag: 118290
  - 4
    - Event for Field Change I am a Delphi programmer who is excited about converting to .Net (however still novice in .Net), and I need your help to understand some data manupulation concepts. I am using I have a typed DataGrid bound to an access database, which has a table with 2 datetime fields: Date1 and Date2. I added an unbound column to the grid called ELAPSED, which will diplay the difference in days between the 2 dates. So the grid looks like this: DATE1 DATE2 DIFF ------------------------------------------ __/__/____ __/__/____ 999 days __/__/____ __/__/____ 999 days __/__/____ __/__/____ 999 days __/__/____ __/__/____ 999 days __/__/____ __/__/____ 999 days I wrote a method to calculate the difference in days (using TimaSpan), and I want to run this method for each row, as it's been "filled" from the database. Additionally, I want this method to be run as I change DATE1 or DATE2 in the grid, so that the it reflects the correct difference in days. Please help me to achieve this, explaining in what event(s) I should place the call to my method. PS: In Delphi I would put it in the TField's OnChange event... Thank you very much!!!!! - Gus Tag: Problem with Framework Tag: 118289
  - 5
    - Multiple DataViews on the same DataTable appear to interact I have a DataTable that is being maintained in a Model class. I also have a View class which creates a DataView from the DataTable that the Model passes it. The view class then has methods to filter the contents of the DataView so that the user can narrow down the list to the items they are interested in. This all works fine as long as I only have a single instance of the View class, however whenever I create a second instance of the view class and have it make its DataView use the same DataTable I find that any filter applied to the DataView in one window is also applied to the DataView in the other form. Can anyone explain this to me? It seems that as long as I am using 2 independant DataViews (dim dv as new DataView(model.GetTable()) they shouldn't interact. TIA Ron L Tag: Problem with Framework Tag: 118284
  - 6
    - Microsoft.Practices.EnterpriseLibrary.Data manifest mismatch I built the Microsoft (June 2005) Enterprise Library as strong named assemblies. In a Web application called ConfigTest, I use the Data Access Application Block. When the application starts and the code that uses the enterprise library is executed, I get the following error page: Server Error in '/ConfigTest' Application. ---------------------------------------------------------------------------- ---- The located assembly's manifest definition with name 'Microsoft.Practices.EnterpriseLibrary.Data' does not match the assembly reference. 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.IO.FileLoadException: The located assembly's manifest definition with name 'Microsoft.Practices.EnterpriseLibrary.Data' does not match the assembly reference. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Assembly Load Trace: The following information can be helpful to determine why the assembly 'Microsoft.Practices.EnterpriseLibrary.Data' could not be loaded. === Pre-bind state information === LOG: DisplayName = Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null (Fully-specified) LOG: Appbase = file:///c:/inetpub/wwwroot/ConfigTest LOG: Initial PrivatePath = bin Calling assembly : (Unknown). === LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind). LOG: Post-policy reference: Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/configtest/2f32983c/f9a353e7/Microsoft.Practices.EnterpriseLibrary.Dat a.DLL. LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/configtest/2f32983c/f9a353e7/Microsoft.Practices.EnterpriseLibrary.Dat a/Microsoft.Practices.EnterpriseLibrary.Data.DLL. LOG: Attempting download of new URL file:///c:/inetpub/wwwroot/ConfigTest/bin/Microsoft.Practices.EnterpriseLibrary.Data.DLL. WRN: Comparing the assembly name resulted in the mismatch: PUBLIC KEY TOKEN Stack Trace: [FileLoadException: The located assembly's manifest definition with name 'Microsoft.Practices.EnterpriseLibrary.Data' does not match the assembly reference.] System.Type.GetType(String typeName, Boolean throwOnError) +0 Microsoft.Practices.EnterpriseLibrary.Configuration.Transformer.XmlSerialize rTransformer.Deserialize(Object section) Microsoft.Practices.EnterpriseLibrary.Configuration.ConfigurationBuilder.Rea dConfiguration(String sectionName) Microsoft.Practices.EnterpriseLibrary.Configuration.ConfigurationContext.Get Configuration(String sectionName) Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetData baseSettings() Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetData baseProviderData(String instanceName) Microsoft.Practices.EnterpriseLibrary.Data.DatabaseProviderFactory.GetConfig urationType(String instanceName) Microsoft.Practices.EnterpriseLibrary.Configuration.ConfigurationFactory.Cre ateInstance(String configurationName) Microsoft.Practices.EnterpriseLibrary.Data.DatabaseProviderFactory.CreateDat abase(String instanceName) Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase(St ring instanceName) ConfigTest.WebForm1.Button1_Click(Object sender, EventArgs e) System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo stBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1292 ---------------------------------------------------------------------------- ---- Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032 I even changed the version of the common, configuration, and data (Microsoft.Practices.EnterpriseLibrary) assemblies to 1.2.0.0 before running this application. The assemblies are stored in the bin folder under the virtual folder for the web app (not in the GAC, but I even tried that and got the same results - they can be stored in the GAC so they definitely are strong named assemblies). The references in VS.NET show these assemblies (common, configuration, and data) as version 1.2.0.0 and they are copied local to the web app (copied to its bin folder). I can't figure out why the Pre-bind state information is referencing Version=1.1.0.0. Any ideas on how to fix this problem? I was able to use these assemblies as "weakly named", but they are used in a work project by an assembly that is strongly named, so I needed to make them that way as well. Thanks! Tag: Problem with Framework Tag: 118283
  - 7
    - vs2005/sql server 2005 tutorial Hi I am looking for a step by step tutorial on how to do a winform database app using parameterised stored procedures. Any suggestions would be appreciated. Thanks Regards Tag: Problem with Framework Tag: 118280
  - 8
    - How to merge multiple datarows within a single dataset Hello all, I wonder how to merge multiple datarows within one single dataset? I have a dataset which contains one table, in this table, for example, there are 10 records, where rec#1 - 5 have the same content in column(0) and rec#6-10 have the same content in column(0), now I want to concatenate another column(1) for records that have same content in column(0). that is, the new dataset should have only two record: rec1's column(1) contains the text from previous rec1-5, and rec2's contains previous rec6-10 Can anyone tell me how to do it? I believe there should be a simple way. Thanks in advance. Tag: Problem with Framework Tag: 118279
  - 9
    - DataRow index within a DataRowCollection Is there anyway to determine the index of a DataRow within a DataRowCollection? I am using the Find() method of the DataRowCollection on my table to get me the record I am looking for, but it is returning a DataRow object and not the index of the object. Is there another way to find this? All I can find is Find()and Contains(). Thank you, Brian Tag: Problem with Framework Tag: 118278
  - 10
    - VS2005 Dataset Designer - dataenvironment hell reborn or a reliable tool? I have been reading about the new data features in VB 2005, and while the DataSet Designer promises to reduce development time, it also looks very much like the VB6 DataEnvironment which, for me at least, was a source of much grief which went away when I replaced it with straight ADO code, as well as being rather inflexible when changes are required. Can anybody tell me if the time saved writing less code with the DataSet Designer is going to just be postponed to support and bug fixes or is it really time saved creating reliable apps? Tag: Problem with Framework Tag: 118274
  - 11
    - can a menu on a base form be inherited and shown on another form? can a menu on a base form be inherited and shown on another form? How can i do this? Tag: Problem with Framework Tag: 118270
  - 12
    - Displaying Select columns(windows forms app) This is really stumping me. I have a dataset where I compute certain columns because I need to reorganize the data to a certain format, but I need to take the new columns and put them into a new dataset. I have a custom control where a user performs some actions and it combines certain columns or at least creates a new one with a name I can use. What I need is to bind a dataset to a grid with only the computed columns. I thought I would create a new DS and merge it with the doctored one, but no go, empty values with only the column headers. How do I get a dataset to be created from only certain columns in another dataset? Thanks in advance!! Paul Huff paul@postnexusinc.com Tag: Problem with Framework Tag: 118269
  - 13
    - copy query result to different DB Hi I 've got 2 databases on 2 different SQL servers. I need to copy the result of a stored procedure on SQL1 into a table in a database of SQL2. What would be the most efficient way of doing this. I'm slightly concerned about performance, since the query result can easily be 500000 records. Any suggestions? thanks Sue Tag: Problem with Framework Tag: 118257
  - 14
    - "Timeout expired" in ADO.NET Hi, I've sent a similar post earlier - but after no more luck and a lot more frustration, I am reposting the issue with some additional information. It's regarding several web applications on the same server, connecting to a SQL Server on another server. I keep getting the following exception when accessing the database: ----- System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---- I am currently using the following code to connect, but I've had the same problem with all the different code snippets I've tried, so I doubt the problem lies herein: ----- using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); .... data code .... connection.Close(); } ----- The problem happens 1-5 times, after I refresh the page enough times, it usually goes through. I've seen a number of potential solutions to the problem - but none of them fits the problem. I usually get the exception after not using the system for a while, but I haven't experienced when the system is "in use", i.e. when the previous request was no more than a couple of minutes ago, and no recompile of the application has been done. I _don't_ get enough connections to exceed the maximum - far from it (when I don't get the exception, the connection pooling seems to work fine). The exception is thrown instantly, not after the default 30 second timeout. And after I had accidentally misconfigured the authentication in the web application, the user didn't have access - I got "Login failed for user (null)" - what's odd was that I _still_ got the "Timeout expired" exception 4-5 times before I finally got the expected "Login failed" exception. The "Timeout expired" exception gets thrown even before I successfully connect to the database! Suggestions are very welcome, I've been struggling with this problem off and on for several weeks now. It's only a big nuisance during development, but naturally, it's a real showstopper for going into production with the application(s). Regards, Nils Magnus Englund Tag: Problem with Framework Tag: 118255
  - 15
    - Not updated Textbox value inside a datalist editItemTemplate Good Morning, I still havent solved my problem with a textbox inside an editItemTemplate of a datalist, in fact now it is filled with the word "CIAOOOOOO" , if a runtime in the form I put a different word like "PIZZAAAA" this new word is not available in the Update_Command following : void Update_Command(Object sender, DataListCommandEventArgs e) { String sNomeCampo = ((TextBox)e.Item.FindControl("NomeCampo")).Text; } where instead I've again sNomeCampo = "PIZZA" . I need help, this problem is stopping my job, many thanks Antonio D'Ottavio www.etantonio.it/en Here's the code inside HTML: <ASP:DataList id="MyDataCampi" runat="server" HorizontalAlign="Center" RepeatDirection="Horizontal" RepeatColumns="1" OnEditCommand="Edit_Command" OnUpdateCommand="Update_Command" OnCancelCommand="Cancel_Command" OnItemDataBound="BindComboes" > <ItemTemplate> <tr style="background-color:CCFF99"> <td width=10% align="center"> <asp:LinkButton id="EditButton" Text="Edit" CommandName="Edit" runat="server"/> <input id="HiddenIDCampo" type="hidden" value='<%#DataBinder.Eval(Container.DataItem, "IDCampo") %>' runat="server" /> </td> <td> <%# DataBinder.Eval(Container.DataItem,"NomeCampo")%> </td> </tr> </ItemTemplate> <EditItemTemplate> <asp:LinkButton id="UpdateButton" Text="Update" CommandName="Update" runat="server"/> <td> <asp:TextBox id="NomeCampo" text='CIAOOOOOOOOOO' runat="server"/> </td> </EditItemTemplate> </ASP:DataList> Tag: Problem with Framework Tag: 118253
  - 16
    - Move column order in a dataset Hi! How do I reorder the column in a dataset after it is loaded with data? Don't know if this is a easy one and I just missed it, but mabye you know? ;) Erik Tag: Problem with Framework Tag: 118249
  - 17
    - ADO.Net 2 Providers Hey all, I've been extremely pleased in both the Beta 2 and RC releases of VS.Net 2005 and the new .Net Framework 2. There is just a little something that has been bothering me, and a problem I just cannot seem to resolve? As far as I'm concerned, will there not be any updates to the ADO.Net data providers especially OLEDB and Jet 4. Is this correct? I started out a little project using the .Net Framework 1.1, and somewhere within this project I reference a connection to an Excel document making use of OLEDB as there is no way I can use SQLClient? This has been working fine ever after I upgraded to .Net Framework 2 Beta 2 release 2 months ago. Over this weekend, I updated my release to the RC to try and test the release but for some ob reason I get a "System.EnterpriseServices.Wrapper.dll cannot be found" exception thrown as soon as the code enters the "ReadXLS" method within my code? Now I did a file search and found the file in the .Net Framework directory and I made sure that my project references the "System.EnterpriseServices" namespace. Is there something I am missing here, or will I need to reinstall the Framework again, as I've tried this before? Any help would be greatly appreciated! -- "Code .... really, what''s that?" Tag: Problem with Framework Tag: 118248
  - 18
    - Inserts to DataSet aren't added to db - updates work fine Here is a newbie question, but this one is driving me crazy. In a VB.NET Windows form application, I am inserting and updating records in a DataSet, which show up in a bound DataGrid just fine. I am also issuing a DataAdapter.Update command, and the updates are saved to the database but the inserts are not. As far as I can tell, I am following the two examples that I have to the tee, but it just doesn't work. I'm sure that I'm overlooking some simple detail. FYI I am using an OleDBCommandBuilder to build the insert and update commands. I moved all of the relevant code into a single form to create a simplified example, and it follows. Thanks in advance!!!! ---------------------------------------------------------- ' this project has a single window with a bound DataGrid that 'displays a single user's "contact information", which is one row ' 'clicking on btnUpdate updates that one record 'clicking on btnInsert inserts a new row 'both updates and inserts are immediately visible in the DataGrid 'but only the updates are saved in the database Public Class Form1 Inherits System.Windows.Forms.Form Private oleConnection As OleDbConnection Private Shared connString As String Private sql As String Private daCustContact As New OleDbDataAdapter Private dsCust As DataSet Private cmdCustBuilder As OleDbCommandBuilder Private cmdCustContact As New OleDbCommand Private cmdCustContactBuilder As OleDbCommandBuilder Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load connString = " .. my conncetion string .." oleConnection = New OleDbConnection(connString) oleConnection.Open() dsCust = New DataSet("CustomerContact") cmdCustContact.Connection = oleConnection cmdCustContact.CommandText = "SELECT CustomerNumber, ContactAddress, MethodType, SequenceNumber, InactiveDate " _ & "FROM CustomerContact " _ & " WHERE CustomerNumber = 526" daCustContact.SelectCommand = cmdCustContact daCustContact.TableMappings.Add("Table", "CustomerContact") cmdCustContactBuilder = New OleDbCommandBuilder(daCustContact) cmdCustContactBuilder.QuotePrefix = "[" cmdCustContactBuilder.QuoteSuffix = "]" daCustContact.UpdateCommand = cmdCustContactBuilder.GetUpdateCommand daCustContact.InsertCommand = cmdCustContactBuilder.GetInsertCommand daCustContact.DeleteCommand = cmdCustContactBuilder.GetDeleteCommand daCustContact.Fill(dsCust, "CustomerContact") DataGrid1.SetDataBinding(dsCust, "CustomerContact") End Sub Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click With dsCust.Tables("CustomerContact").Rows(0) .Item("MethodType") = "Fax" .Item("SequenceNumber") = Convert.ToByte(10) .Item("ContactAddress") = .Item("ContactAddress") & "xxx" End With UpdateCustomerContact() End Sub Public Sub UpdateCustomerContact() BindingContext(dsCust.Tables("CustomerContact")).EndCurrentEdit() daCustContact.Update(dsCust, "CustomerContact") End Sub Private Sub btnInsert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnInsert.Click Dim dtCc As DataTable = dsCust.Tables("CustomerContact") Dim dr As DataRow = dtCc.NewRow() dr("CustomerNumber") = 526 dr("MethodType") = "Email" dr("SequenceNumber") = 2 dr("ContactAddress") = "hacking code" dr("InactiveDate") = System.DBNull.Value Try dsCust.Tables("CustomerContact").Rows.Add(dr) dr.AcceptChanges() dsCust.AcceptChanges() UpdateCustomerContact() Catch ex As Exception MessageBox.Show("Exception occurred: " & ex.Message, MessageBoxButtons.OK, MessageBoxIcon.Error) End Try End Sub Public Sub UpdateCustomerContact() BindingContext(dsCust.Tables("CustomerContact")).EndCurrentEdit() daCustContact.Update(dsCust, "CustomerContact") End Sub End Class Tag: Problem with Framework Tag: 118245
  - 19
    - Two questions for gurus about using strongly typed DataSet in Web Services. 1. Is there a 2nd way to declare a strongly typed DataSet (e.g. CustomerDataSet) in WSDL instead of using the WSDL <import namespace="CustomerDSnamespace" location="url to CustomerDS.xsd"/>? Apparently, if I include CustomerDataSet schema definition in WSDL types, it will not be recognized as a DataSet by .NET WSDL compiler when a Web Reference is created. I have to use the WSDL import statement. What do I need to do to make it recognize the CustomerDataSet definition in the WSDL types. The CustomerDataSet has the correct definition (ie isDataSet=true) and does work with the WSDL import. 2. How to send a strongly typed DataSet over SOAP without the XSD? I found that when I am sending a strongly typed DataSet (e.g. CustomerDataSet) instance over SOAP, I still need to send its XSD with the CustomerDataSet every time. Otherwise, .NET will not parse attribute data type right even though, the XSD is available as part of the strongly typed DataSet (ie CustomerDataSet). This defeats the purpose of using the strongly typed DataSet between Web service server and client. Is there a way not to send the XSD? Thanks, Don Tag: Problem with Framework Tag: 118231
  - 20
    - Speed up of connection to SQL Sever from VB.NET I am running a tiny SQL Server 2000 database on a Small Business server premium edition. I am connecting (using SQL Server security logins) to it from 2 XP professional workstations each running the same simple VB.NET program. (I am not running the server as a domain controller, just using a workgroup.) From one of the machines, the opening of the database connection is immediate (small fraction of a second). From the other it is very slow (20 seconds). I have tried to fool around with network settings, but both machines seem to be set up with the same parameters. What am I missing? (I had the same problem previously when the SQL Server was running on another XP workstation.) Tag: Problem with Framework Tag: 118230
  - 21
    - WebForm read Hi, Is there a way to read witch WebControl (like TextBox's) and howmany webcontrols are in a WebForm? Tag: Problem with Framework Tag: 118224
  - 22
    - creating a dataset from existing dataset First, thanks to all who helped on my previous question regarding copying a datatable to a new datatable. I have struggled and struggled with this and I just am not getting it. Here is my code. I am displaying a dataset in a datagrid and using a checkbox on the datagrid items, I need to create a new dataset to bind to a repeater. The checkbox things work and I can see in debug that my destination table has the desired row count. However, the repeater is not displaying any items. Viewing the source in IE, I can see that the values are blank. --- Private Sub btnSelect_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSelect.Click 'Copy the selected Physicians to the Physicians Referred repeater 'Clone the dataset for the datagrid to used by the repeater with ' the selected physicians Dim DScptPhysicianSearch As New DataSet DScptPhysicianSearch = CType(Session("cptPhysicianSearchDS"), DataSet) Dim DScptPhysicianReferred As New DataSet DScptPhysicianReferred = DScptPhysicianSearch.Clone 'Get a reference to the tables and clear existing data Dim DTSource As DataTable = DScptPhysicianSearch.Tables("cptPhysicianSearch") Dim DTDest As DataTable = DScptPhysicianReferred.Tables("cptPhysicianSearch") 'Remove existing rows from destination table DTDest.Clear() 'Inform table objects of the primary key Dim PrimaryKeyColumns(0) As DataColumn PrimaryKeyColumns(0) = DTSource.Columns("PhysCode") DTSource.PrimaryKey = PrimaryKeyColumns PrimaryKeyColumns(0) = DTDest.Columns("PhysCode") DTDest.PrimaryKey = PrimaryKeyColumns 'Import the selected physicians into the referred physicians table Dim Item As DataGridItem For Each Item In Me.dgPhysReferralSearch.Items ' Retrieve the SelectPhys CheckBox control from the ' specified item (row) in the DataGrid control. Dim Selection As CheckBox = CType(Item.FindControl("chkPhysSelect"), CheckBox) ' If the control is found and checked, import the row to the destination table If Not Selection Is Nothing Then If Selection.Checked Then 'Extract PhysCode Dim CurrentPhysCode As String = Item.Cells(1).Text Dim strExpr As New System.Text.StringBuilder strExpr.Append("[PhysCode] = ") strExpr.Append("'") strExpr.Append(Trim(CurrentPhysCode)) strExpr.Append("'") Dim DRSource As DataRow() = DTSource.Select(strExpr.ToString, "", DataViewRowState.CurrentRows) DTDest.LoadDataRow(DRSource, True) End If End If Next 'Bind the dataset to the repeater DScptPhysicianReferred.Tables.Clear() DScptPhysicianReferred.Tables.Add(DTDest) Me.rptPhysReferred.DataSource = DScptPhysicianReferred.Tables("cptPhysicianSearch") Me.rptPhysReferred.DataBind() End Sub --- Thanks, Alex Tag: Problem with Framework Tag: 118222
  - 23
    - Help with DataAdapter Update Hello everyone, I have a data adapter and would really like to be able to change the value of a column on update. I am using New System.Data.SqlClient.SqlParameter("@DateModified", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "DateModified", System.Data.DataRowVersion.Original, Now) and when I add a watch to it, it shows a date value. However, when I trace the update statement on SQL server, it comes out as Null. The value of the datacolumn is null, I would like to change it to Now during the update. Anyone have any ideas as to how to overcome this? Thanks Tag: Problem with Framework Tag: 118220
  - 24
    - DataTable Factory and cache problem I want to produce typed DataTables (create factory for creating it ready to use (for example 30 of given type)). Everything works fine when i use widows application to simulate 'eating' datatables from Queue where are datatables are ready for use. But something goes wrong when i use my Factory in context of IIS (now 5.0 and windows 2000). I have one thread which populates Queues when there is no needed datatables and 1 instance (accesed by static Property) of my Factory which is one for application domain. DataTables are returned by Create( IDataTableCreator dataTableCreator) method. Synchronization is very fast because i use Interlocks to perform synchronization and Interlocks are used during Dequeue my Queue so I don't have synchronization problems. My question is that: Why in application context everything works fine but in IIS context everyting is extremaly slow :( If number of precreated datatables is high (500) then IIS dies during populating my queues. I just wanted to know if this mechanizm can work in IIS :/ Is there any way to improve performance of Typed DataTable?? Tag: Problem with Framework Tag: 118215
  - 25
    - ADO Connection after DB backups We stop a separate server with a SQL Server instance for backups at night the restart after backups are completed. The ADO connection on our web server (Win Svr 2k w/IIS) cannot reconnect to the database server unless the web machine is rebooted. We have tried to restart IIS but it did not work. Has anyone seen this problem before? Any thoughts on where to start? R. DeWaal Tag: Problem with Framework Tag: 118207
- Next
  - 1
    - vs2003 with vs2005 Hi Is it possible to install and use vs2003/net1.1 and vs2005/net2 side by side on the same drive? Only from experience please. Thanks Regards Tag: Problem with Framework Tag: 118206
  - 2
    - How do I bind an MSAccess CrossTab to a DataGrid I have an MSAccess database that I have used to create a cross tab querry. When I try and bind it to a datagrid unsing an OleDbDataAdapter or OleDbDataReader the data grid only displays two of the many column headers and none of the data. I am not haveing trouble binding to other queries in the same database. I did note that in the Visual Studio .Net Server explorer if I make a connection to the database it lists the Crosstab querry as a stored procedure not a view. I have also tried using an OleDbCommand of CommandType StoredProcedure but still no luck. Any help would be appreciated. Tag: Problem with Framework Tag: 118189
  - 3
    - Textbox value in the edittemplate of a datalist doesn't report the changes Good Morning, I've a problem with a textfiled inside a datalist, in particular it's value it is not updated with the changes, I mean sNomeCampo has still the value coming from the dB and not that changed by the user, May you help me ??? Antonio D'Ottavio www.etantonio.it/en Here's the code : void Update_Command(Object sender, DataListCommandEventArgs e) { String sNomeCampo = ((TextBox)e.Item.FindControl("NomeCampo")).Text; } <ASP:DataList id="MyDataCampi" runat="server" HorizontalAlign="Center" RepeatDirection="Horizontal" RepeatColumns="1" OnEditCommand="Edit_Command" OnUpdateCommand="Update_Command" OnDeleteCommand="Delete_Command" OnCancelCommand="Cancel_Command" OnItemDataBound="BindComboes" > <ItemTemplate> <tr style="background-color:CCFF99"> <td width=10% align="center"> <asp:LinkButton id="EditButton" Text="Edit" CommandName="Edit" runat="server"/> <input id="HiddenIDCampo" type="hidden" value='<%# DataBinder.Eval(Container.DataItem, "IDCampo") %>' runat="server" /> </td> <td> <%# DataBinder.Eval(Container.DataItem, "NomeCampo")%> </td> </tr> </ItemTemplate> <EditItemTemplate> <asp:LinkButton id="UpdateButton" Text="Update" CommandName="Update" runat="server"/> <td> <asp:TextBox id="NomeCampo" Text='<%# DataBinder.Eval(Container.DataItem, "NomeCampo") %>' runat="server"/> </td> </EditItemTemplate> </ASP:DataList> Tag: Problem with Framework Tag: 118181
  - 4
    - OracleClient Namespace+BLOB can some one help me out here. I am trying to retrieve a ppicture from a DB using OracleClient Namespace. But cant seem to get it right. Please help me out here. -- Sent via .NET Newsgroups http://www.dotnetnewsgroups.com Tag: Problem with Framework Tag: 118180
  - 5
    - Binding multiple datasets to one datagrid Hello, I have an asp datagrid where i'd like to display four colums, each one showing datas coming from a different dataset. Each dataset has a common PK, so i'd like to make a join on this PK, and fill a result dataset to bind it to my asp datagrid. I can't find any samples showing this kind of technique. Any ideas ? Thanks in advance, J.Philippe Tag: Problem with Framework Tag: 118178
  - 6
    - Enterpriseservices namespace and Timeout Hi all I am using System.enterpriseservices in a class library. I am calling a stored procedure within this class procedure. This procedure is taking a long time to execute and after some time I get the follwoing error "Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction." It is working fine with less records. If I change the timeout from MTS option tab then it is working fine . I know the solution here is to increase the timeout value. But I have no access to the productin server where the web application woudl be finally deployed. I need to know how to increase the MTS Transaction through code for a single class and to again reset it back. Thanks pradeep_TP Tag: Problem with Framework Tag: 118171
  - 7
    - One SqlDataAdapter, One DataSet with multiple tables. possible? Hi, I have a data adapter and trying to connect it to multiple tables. I am not sure if it is possible and if so, I can't find what I am doing wrong. I am using HTML controls because the original page was created with another software, but I changed all the controls to "Run as Server Control". The loading works fine, but the updates don't. How can I attach two SQL statements to one data adapter? Or do I have to use two data adapters? Option Explicit On Option Strict On Imports System.Data.SqlClient Public Class _62031 Inherits System.Web.UI.Page ' Variables to hold local copies of the global data objects Dim lv_PageDataAdapter As SqlDataAdapter Dim lv_PageConnection As SqlConnection Dim lv_PageDataSet As DataSet Dim lv_TableName1 As String = "INCLUS" Dim lv_TableName2 As String = "EXCLUS" Dim lv_id1 As Integer Dim lv_id2 As Integer Dim Radio(1) As HtmlControls.HtmlInputRadioButton ' A holder for radio buttons used to get indexes Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ' Make local copies of the data objects to make it easier to manipulate lv_id1 = CType(Session.Contents("gv_id1"), Integer) lv_id2 = CType(Session.Contents("gv_id2"), Integer) lv_PageConnection = CType(Session.Contents("gv_Connection"), SqlConnection) lv_PageDataAdapter = CType(Session.Contents("gv_DataAdapter"), SqlDataAdapter) lv_PageDataSet = CType(Session.Contents("gv_DataSet"), DataSet) If Not Page.IsPostBack Then ' Make sure we have an open connection If lv_PageConnection.State <> ConnectionState.Open Then lv_PageConnection.Open() lv_PageDataAdapter.SelectCommand = _ New SqlCommand("SELECT id1, id2, i1 FROM " & _ lv_TableName1 & " WHERE id1=" & lv_id1 & " AND id2=" & lv_id2, _ lv_PageConnection) lv_PageDataAdapter.Fill(lv_PageDataSet.Tables.Add(lv_TableName1)) ID1.Value = lv_PageDataSet.Tables(lv_TableName1).Rows(0).Item("id1").ToString ID2.Value = lv_PageDataSet.Tables(lv_TableName1).Rows(0).Item("id2").ToString i1.Value = lv_PageDataSet.Tables(lv_TableName1).Rows(0).Item("i1").ToString) ' Exclusions lv_TableName2 = "EXCLUS" lv_PageDataAdapter.SelectCommand = _ New SqlCommand("SELECT id1, id2, e1 FROM " & _ lv_TableName2 & " WHERE id1=" & lv_id1 & " AND id2=" & lv_id2, _ lv_PageConnection) lv_PageDataAdapter.Fill(lv_PageDataSet.Tables.Add(lv_TableName2)) e1.Value = lv_PageDataSet.Tables(lv_TableName1).Rows(0).Item("e1").ToString) End If End Sub Private Sub Submit1_ServerClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Submit1.ServerClick lv_PageDataSet.Tables(lv_TableName1).Rows(0).Item("i1") = i1 lv_PageDataSet.Tables(lv_TableName1).Rows(0).Item("e1") = e1 Try sbUpdateData(lv_PageDataSet) lv_PageDataSet.AcceptChanges() Catch ex As SqlException End Try End Sub Private Sub sbUpdateData(ByVal pardv As DataSet) Dim lv_CommandBuilder As New SqlCommandBuilder(lv_PageDataAdapter) If lv_PageConnection.State <> ConnectionState.Open Then lv_PageConnection.Open() lv_PageDataAdapter.UpdateCommand = lv_CommandBuilder.GetUpdateCommand lv_PageDataAdapter.Update(pardv.Tables(lv_TableName1)) End Sub End Class Tag: Problem with Framework Tag: 118162
  - 8
    - Concurrency Problem I am running a VB.NET app on my desktop with Access 2003 as the DB. The table I am working with has a PK made up of 2 columns. I am currently the only user. I built my own UpdateCommand for the data adapter. The command uses values for the PK columns in the WHERE clause ad then uses "Set" for some (but not all) other columns. Whenever I try to do an update I get a concurrency violation? How can that be? Since this application is strictly a single user application, is there a way to simply turn off all concurrency checking? Wayne Tag: Problem with Framework Tag: 118161
  - 9
    - Run-time error '430' Visual 6.0 Hola mundo tengo la siguinnte conexion a una base de datos Acces 97, funciona bien en windows 98 y 2000 pero al instalar la aplicacion en WindwsXP SP2 sale el sgiuiente erorr Run-time error '430': Class does not suppot Automation. Estoy usando mdac2.7 Public db As New ADODB.Connection Public strcnn As String strcnn = "provider=Microsoft.Jet.OLEDB.4.0;data source=" & App.Path & "\Basedatos\xxx.mdb" db.ConnectionString = strcnn db.Open db.CursorLocation = adUseClient Tag: Problem with Framework Tag: 118157
  - 10
    - No value given for one or more required parameters on relation update Here's a variation on the old chestnut, but I can't get a handle on it. I have a database that has a many to many relation. Table A has two columns AID and AName, table B has two columns BID and BName and table AB has three columns ABID, AID and BID for relating tables A and B. (I am using Access, but don't use the autogenerated ID, although I let it operate.) I create a relation which contains ABID, AID, BID and BName. If I edit BName in this relation I get the above error when I try to update the databases, but I am only updating AB with the IDs, not the name info and yet I am getting the error: System.Data.OleDb.OleDbException: No value given for one or more required parameters. at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) at ConsoleApplication1.Program.Main(String[] args) in C:\Documents and Settings\Gordon\My Documents\Visual Studio 2005\Projects\ConsoleApplication1\ConsoleApplication1\Program.cs:line 111 0 A and 0 B and 0 AB records updated - from my line of code Line 111 contains the: i = daAB.Update(ds, "AB"); line I have noted by cycling through the datarows of the AB table in the dataset that the one that is changed is getting its status changed to modified, which is fair enough. I suspect that since the dataadapter.update is seeing that change then it wants to update the AB table in the access table, even though it doesn't need to. Any pointers would be gratefully appreciated, as well as any thoughts on the update code, as I found this pretty complex to get my head around - possibly where there are errors? I have stripped my code as much as possible, but this is what generates the error: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.OleDb; using System.Drawing; using System.Text; using System.Windows.Forms; namespace WindowsApplication2 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { string myDB = "AorB.mdb"; OleDbConnection conn = null; DataSet ds; OleDbDataAdapter daA; OleDbDataAdapter daB; OleDbDataAdapter daAB; OleDbDataAdapter daBA; DataRelation drAB; DataRelation drBA; //create a connection string to the access database conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; User Id=;Password=; Data Source=" + myDB); //clear the dataset ds = null; ds = new DataSet(); //set up the link daA = new OleDbDataAdapter("SELECT * FROM A ORDER BY AName", conn); daB = new OleDbDataAdapter("SELECT * FROM B ORDER BY BName", conn); //fill the dataset with data daA.Fill(ds, "A"); daB.Fill(ds, "B"); //Create Data Relation from A to B, daAB = new OleDbDataAdapter("SELECT AB.ABID, AB.AID, AB.BID, B.BName FROM B INNER JOIN AB ON B.BID = AB.BID ORDER BY B.BName", conn); daAB.Fill(ds, "AB"); drAB = new DataRelation("AToB", ds.Tables["A"].Columns["AID"], ds.Tables["AB"].Columns["AID"], true); ds.Relations.Add(drAB); //daBA = new OleDbDataAdapter("SELECT AB.ABID, AB.BID, AB.AID, A.AName FROM A INNER JOIN AB ON A.AID = AB.AID ORDER BY A.AName", conn); //daBA.Fill(ds, "BA"); //drBA = new DataRelation("BToA", // ds.Tables["B"].Columns["BID"], // ds.Tables["BA"].Columns["BID"], true); //ds.Relations.Add(drBA); ds.EnforceConstraints = true; //Change the BName in the first row of the AB table DataRow[] dr = ds.Tables["AB"].Select(); DataRow r = dr[0]; r["BName"] = "Help"; //update database string updateSQLA = "Update A set [AID]=?, [AName]=? where [AID]=?"; // //the @ is to make sure that it is treated as is, no confusion with C# keywords daA.UpdateCommand = new OleDbCommand(updateSQLA, conn); daA.UpdateCommand.Parameters.Add("@AID", OleDbType.Integer, 10, "AID"); daA.UpdateCommand.Parameters.Add("@AName", OleDbType.VarWChar, 50, "AName"); OleDbParameter AID1 = daA.UpdateCommand.Parameters.Add("@AID", OleDbType.Integer, 10, "AID"); AID1.SourceVersion = DataRowVersion.Original; string updateSQLB = "Update B set [BID]=?, [BName]=? where [BID]=?"; // daB.UpdateCommand = new OleDbCommand(updateSQLB, conn); daB.UpdateCommand.Parameters.Add("@BID", OleDbType.Integer, 10, "BID"); daB.UpdateCommand.Parameters.Add("@BName", OleDbType.VarWChar, 50, "BName"); OleDbParameter BID1 = daB.UpdateCommand.Parameters.Add("@BID", OleDbType.Integer, 10, "BID"); BID1.SourceVersion = DataRowVersion.Original; //now need to update AB table in real database string updateSQLAB = "Update AB set [ABID]=?, [AID]=?, [BID]=? where [AID]=? and [BID]=?"; // daAB.UpdateCommand = new OleDbCommand(updateSQLAB, conn); daAB.UpdateCommand.Parameters.Add("@ABID", OleDbType.Integer, 10, "ABID"); daAB.UpdateCommand.Parameters.Add("@AID", OleDbType.Integer, 10, "AID"); daAB.UpdateCommand.Parameters.Add("@BID", OleDbType.Integer, 10, "BID"); //OleDbParameter ABID1 = daA.UpdateCommand.Parameters.Add("@ABID", OleDbType.Integer, 10, "ABID"); //ABID1.SourceVersion = DataRowVersion.Original; OleDbParameter ABID2 = daA.UpdateCommand.Parameters.Add("@AID", OleDbType.Integer, 10, "AID"); ABID2.SourceVersion = DataRowVersion.Original; OleDbParameter ABID3 = daA.UpdateCommand.Parameters.Add("@BID", OleDbType.Integer, 10, "BID"); ABID3.SourceVersion = DataRowVersion.Original; int g = 0, h = 0, i = 0; try //AB first (important) { i = daAB.Update(ds, "AB"); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } try { g = daA.Update(ds, "A"); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } try { h = daB.Update(ds, "B"); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } //for testing MessageBox.Show(g.ToString() + " A and " + h.ToString() + " B and " + i.ToString() + " AB records updated"); } } } Tag: Problem with Framework Tag: 118154
  - 11
    - How to read and execute script file I create a script file (.sql) with DTS. How can I read it into Asp.net and execute it? Tag: Problem with Framework Tag: 118149
  - 12
    - Displaying datagrid on second form I have a form which has a listbox, 5 textboxes and a datagrid, what I'm trying to do is when a user double clicks a row on the datagrid this then displays another datagrid on the second form with the information from the Items Table I have already set up a data relation to link the Customers and Orders Table on the first form through the Customer ID and have tried to link the Orders Table and Items Table through the Order ID to display the info in the second datagrid but doesn't work, getting an error on the relation declaration line My coding is below any advice would be appreciated on this Thanks Imports System.Data.OleDb Imports System.IO Public Class Form1 Inherits System.Windows.Forms.Form Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System. EventArgs) Handles MyBase.Load 'Declares and instantiates a command object Dim SqlCustomers As String = "SELECT * FROM customers" 'Sets the connection string Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\ The Doughnut Shop.mdb" 'Declares and instantiates a new OleDbconnection object Dim myconnection As OleDbConnection = New OleDbConnection(connString) 'Sets the connection string property myconnection.ConnectionString = connString 'Declares and instantiates a data adapter Dim dacustomers As OleDbDataAdapter = New OleDbDataAdapter(SqlCustomers, myconnection) 'Declares and instantiates a new data set Dim ds As DataSet = New DataSet 'Fills the data adapter with the customers table dacustomers.Fill(ds, "customers") 'Declares and instantiates a command object Dim sqlorders As String = "SELECT * FROM Orders " 'Declares and instantiates the datadapter Dim daorders As OleDbDataAdapter = New OleDbDataAdapter(sqlorders, myconnection) 'Fills the data adapter with the orders table daorders.Fill(ds, "orders") 'Declares and instantiates a new data relation linking together the customers and the orders table Dim relation As DataRelation = New DataRelation("CustomersOrders", ds.Tables ("Customers").Columns("CustomerID"), ds.Tables("Orders").Columns("CustomerID") ) 'Adds the relation to the collection ds.Relations.Add(relation) ListBox1.DisplayMember = "CustomerID" ListBox1.DataSource = New DataView(ds.Tables("customers")) 'Binds the customers table details to the text boxes TextBox1.Text = ds.Tables("customers").Rows(0).Item("FirstName") TextBox2.Text = ds.Tables("customers").Rows(0).Item("LastName") TextBox3.Text = ds.Tables("customers").Rows(0).Item("City") TextBox4.Text = ds.Tables("customers").Rows(0).Item("State") TextBox5.Text = ds.Tables("customers").Rows(0).Item("ZipCode") End Sub Private Sub ListBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ListBox1.SelectedIndexChanged 'Declares a data row view Dim drv As DataRowView = CType(ListBox1.SelectedItem, DataRowView) 'Declares a data row Dim childRows() As DataRow = drv.Row.GetChildRows("CustomersOrders") TextBox1.Text = drv("FirstName") TextBox2.Text = drv("LastName") TextBox3.Text = drv("City") TextBox4.Text = drv("State") TextBox5.Text = drv("ZipCode") 'Sets the data grid data source property DataGrid1.DataSource = drv.CreateChildView("CustomersOrders") End Sub Private Sub DataGrid1_DoubleClick(ByVal sender As Object, ByVal e As System. EventArgs) Handles DataGrid1.DoubleClick 'Declares and instantiates a new form Dim myForm As New Form2 'Displays the second form myForm.ShowDialog() End Sub End Class Imports System.Data.OleDb Imports System.IO Public Class Form2 Inherits System.Windows.Forms.Form Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System. EventArgs) Handles Button1.Click End End Sub Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System. EventArgs) Handles MyBase.Load Dim sqlOrderItems As String = "SELECT * FROM Items" Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\ The Doughnut Shop.mdb" Dim myconnection As OleDbConnection = New OleDbConnection(connString) myconnection.ConnectionString = connString Dim daOrderItems As OleDbDataAdapter = New OleDbDataAdapter(sqlOrderItems, myconnection) Dim ds As DataSet = New DataSet daOrderItems.Fill(ds, "Items") Dim relation As DataRelation = New DataRelation("OrdersItems", ds.Tables ("Orders").Columns("OrderID"), ds.Tables("Items").Columns("OrderID")) ds.Relations.Add(relation) Dim drv As DataRowView Dim childRows() As DataRow = drv.Row.GetChildRows("OrdersItems") DataGrid1.DataSource = drv.CreateChildView("OrdersItems") End Sub End Class Tag: Problem with Framework Tag: 118147
  - 13
    - CommandBuilder Problem I am using ADOX to create an Access table and populate it with one row of data. The ADOX code sets two columns as primary keys (I can view the table in Access and see that they are set). When I try to create the UpdateCommand I get an error that it fails because the Select does not include a primay key field (the select is "Select * From tablea"). The relavent code is shown below. Any ideas on what I am doing wrong are appreciated. ======================================== Dim cmdBldr As New OleDb.OleDbCommandBuilder(da1) da1.InsertCommand = cmdBldr.GetInsertCommand da1.UpdateCommand = cmdBldr.GetUpdateCommand da1.DeleteCommand = cmdBldr.GetDeleteCommand ================================================ Wayne Tag: Problem with Framework Tag: 118146
  - 14
    - Call stored procedure in ASP.NET 2.0 I would like to know if anyone knows how to execute a stored procedure from ASP.NET 2.0. I'm using the NorthWind database and I'm trying to execute the "CustOrderHist" stored procedure. The error I get is "Incorrect syntax near 'CustOrderHist'. " Public Function GetCustomerOrderHistory(ByVal customerid As String) As SqlDataReader Dim conn As New SqlConnection(conString) Dim cmd As New SqlCommand("CustOrderHist", conn) cmd.Parameters.AddWithValue("@CustomerID", customerid) conn.Open() Dim dtr As SqlDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection) Return dtr End Function Tag: Problem with Framework Tag: 118138
  - 15
    - Confused About Connections What is the difference between an OleDBConnection and an ADODB.Connection? I am working in a VB Express 2005 application and I want to have a global connection object throughout but when creating a table in an Acess DB using ADOX the OleDBConnection won't work and I have to create an ADODB.Connection. I am confused (as usual!) Wayne Tag: Problem with Framework Tag: 118128
  - 16
    - Passing output parameters to SQL Server stored procedures through an SqlCommand object's Parameters collection Hi, I'm currently working writing a Windows service in C# which needs, among other things, to interface with Microsoft Great Plains 8.0, specifically to add General Ledger entries. In order to add a new General Ledger entry to a Great Plains database, it's necessary to supply a journal entry number - Microsoft provide a stored procedure which calculates the most recent journal entry number used, increments this value by one, and returns this to the caller in the form of an output parameter. The top of the procedure is as follows: CREATE PROCEDURE dbo.glGetNextJournalEntry @l_tINCheckWORKFiles tinyint = NULL, @I_iSQLSessionID int = NULL, @IO_iOUTJournalEntry int = NULL output, @O_tOUTOK tinyint = NULL output, @O_iErrorState int = NULL output AS IF((@l_tINCheckWORKFiles IS NULL) OR (@IO_iOUTJournalEntry IS NULL) OR (@I_iSQLSessionID IS NULL)) BEGIN SELECT @O_iErrorState = 20159, @IO_iOUTJournalEntry = 0, @O_tOUTOK = 0 RETURN END <snipped rest of proc> @IO_iOUTJournalEntry returns the next journal entry number @O_tOUTOK returns 0 or 1 depending on whether the procedure succeeds or fails @O_iErrorState contains 0 if the procedure succeeds, or the error state if it fails I'm calling the procedure as follows: SqlConnection mobjSqlConn; SqlCommand mobjSqlCommand; SqlParameter mobjSqlParameter; ArrayList maobjSqlParameters = new ArrayList(); SqlDataReader mobjDR = null; maobjSqlParameters.Clear(); mobjSqlParameter = new SqlParameter("@l_tINCheckWORKFiles", SqlDbType.TinyInt); mobjSqlParameter.IsNullable = true; mobjSqlParameter.Value = 0; maobjSqlParameters.Add(mobjSqlParameter); mobjSqlParameter = new SqlParameter("@I_iSQLSessionID", SqlDbType.Int); mobjSqlParameter.IsNullable = true; mobjSqlParameter.Value = 0; maobjSqlParameters.Add(mobjSqlParameter); mobjSqlParameter = new SqlParameter("@IO_iOUTJournalEntry", SqlDbType.Int); mobjSqlParameter.IsNullable = true; mobjSqlParameter.Direction = ParameterDirection.Output; mobjSqlParameter.Value = 0; maobjSqlParameters.Add(mobjSqlParameter); mobjSqlParameter = new SqlParameter("@O_tOUTOK", SqlDbType.TinyInt); mobjSqlParameter.IsNullable = true; mobjSqlParameter.Direction = ParameterDirection.Output; mobjSqlParameter.Value = 0; maobjSqlParameters.Add(mobjSqlParameter); mobjSqlParameter = new SqlParameter("@O_iErrorState", SqlDbType.Int); mobjSqlParameter.IsNullable = true; mobjSqlParameter.Direction = ParameterDirection.Output; mobjSqlParameter.Value = 0; maobjSqlParameters.Add(mobjSqlParameter); mobjSqlConn = new SqlConnection(CGlobal.gstrSQLConnectionString); mobjSqlCommand = new SqlCommand("glGetNextJournalEntry", mobjSqlConn); mobjSqlCommand.CommandType = CommandType.StoredProcedure; foreach(SqlParameter objSqlParameter in maobjSqlParameters) { mobjSqlCommand.Parameters.Add(objSqlParameter); } mobjSqlCommand.Connection.Open(); mobjDR = mobjSqlCommand.ExecuteReader(CommandBehavior.CloseConnection); It all works as far as here, i.e. there are no errors and mobjDR contains an SqlDataReader, obviously with no records. However, the procedure does not return the next journal entry number. The values of the three output parameters are as follows: @IO_iOUTJournalEntry - 0 @O_tOUTOK - 0 @O_iErrorState - 20159 Clearly, the procedure is not getting past the first validation (see above). So I enabled SQL debugging in the probject and set a breakpoint at the top of the procedure - turns out that all three output parameters have lost their initial values by the time they get passed into the procedure i.e. they are all being passed in as NULL. Therefore, I tried to send a hardcoded SQL string to the procedure instead i.e. string strSQL = ""; strSQL += "DECLARE @IO_iOUTJournalEntry int, @O_tOUTOK tinyint, @O_iErrorState int "; strSQL += "SELECT @IO_iOUTJournalEntry = 0, @O_tOUTOK = 0, @O_iErrorState = 0 "; strSQL += "EXEC glGetNextJournalEntry 0, 0, @IO_iOUTJournalEntry out, @O_tOUTOK out, @O_iErrorState out "; strSQL += "SELECT @IO_iOUTJournalEntry"; mobjSqlConn = new SqlConnection(pstrSqlConnectionString); mobjSqlCommand = new SqlCommand(pstrSQL, mobjSqlConn); mobjSqlCommand.Connection.Open(); mobjDR = mobjSqlCommand.ExecuteReader(CommandBehavior.CloseConnection); mobjDR.Read(); intNextJournalEntry = mobjDR.GetInt32(0); mobjDR.Close(); This worked perfectly. Can anyone please tell me what I'm doing wrong? Is there something specific about passing output parameters to SQL Server stored procedures in the SqlCommand's Parameters collection which makes them lose their initial values? Any assistance gratefully received. Regards, Mark Rae Tag: Problem with Framework Tag: 118115
  - 17
    - Cursors vs Data Table Hi. I have an asp.net application where I have encrypted customer information (all columns encrypted) in a table, and need to pull each row, decrypt the email address and see if it matches a person logging in. I'm using sql server 2000. I could use sql cursors, and go through each row and do my processing, or I could fill a data table on the client and then do my processing. Which way is more efficient in terms of connection bandwidth and other practical matters??? Thanks, Phil Boston, MA Tag: Problem with Framework Tag: 118113
  - 18
    - Do a Find on a Dataset With Multiple Column Primary Key How do I code a Find method for a dataset that has a multiple column primary key. I tried the following but it won't accept the syntax of the Find. The prinmary key is a combination of the name and uclass columns. =========== code =========== Public Function FindUnitRow(ByVal name As String, ByVal uclass As String) FindUnitRow = ds.Tables(0).Rows.Find(name, uclass) If FindUnitRow Is Nothing Then MsgBox("Entry not found for: " & name & " - " & uclass, MsgBoxStyle.Critical, "Unit Record Not Found") End If End Function ======================================= Wayne Tag: Problem with Framework Tag: 118110
  - 19
    - Problem Creating Dataset I am using VB 2005 Express and trying to create a dataset. I did the Add New Item for the Dataset and then defined some columns. In the IDE I have a warning "Warning 1 The 'urn:schemas-microsoft-com:xml-msdatasource:DataSetUISetting' element is not declared. " which points to the DataSetUISetting phrase in the xsc file (see below) =========== xsc file contents ================= <?xml version="1.0" encoding="Windows-1252"?> <DataSetUISetting Version="1.00" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TableUISettings> </TableUISettings> </DataSetUISetting> =================================== I suspect I have a missing reference but I cannot figure out what it wants. Any ideas? Wayne Tag: Problem with Framework Tag: 118103
  - 20
    - When to use ExecuteNonQuery Do I use ExecuteNonQuery only when I insert, delete, and update the database? Thanks Ross Tag: Problem with Framework Tag: 118098
  - 21
    - Morphing UPDATEs I was wrong. When the CommandBuilder is hooked to the DataAdapter, the UPDATE statements generated DO morph from row-to-row. This way only the changed columns are SET. This is a good feature, but given the other limitations of the CB, I still can't recommend its use. When you use hand-written UPDATE commands (set the DataAdapter UpdateCommand), the SQL is invariant. Except for input parameters, the SQL does not change from row to row. I apologize for any confusion. -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP www.betav.com/blog/billva www.betav.com www.sqlreportingservices.net Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Tag: Problem with Framework Tag: 118095
  - 22
    - Stored Procedure Are stored procedures are precompiled in SQL Server. John. Tag: Problem with Framework Tag: 118091
  - 23
    - There is already an open DataReader associated with this Connection which must be closed first I'm starting to worry a bit now. We're getting the above error when two users hit the same database/page on an ASP.NET application using ADO.NET, talking to a SQL 7 server. The error is perfectly repeatable :-( But this should help! The error is occurring inside ExecuteReader which uses a DataReader internally. Here are some things that I'm pretty sure it's *NOT*: It's not because our data readers are not being closed - they are. If they weren't being closed, then the same error would occur in single user operation. It doesn't - it's only when two users (threads) are running at once. It's not connection pooling as we've turned that off using Pooling=False in the SqlConnection connection string. I've verified it really is off by watching connections open & close manually in SQL Enterprise manager. The two threads are not (AFAIK) sharing the same connection object. The SqlConnection object is not in a shared or static variable - it's stored as a private variable within one of our classes (called MSSQL) in a variable called m_Connection. This m_Connection variable is created each time we open a connection using m_Connection = New SqlConnection(ConnString), opened, used (ExecuteScalar) closed and then destroyed using m_Connection = nothing. The instance of MSSQL is stored in the session cache but I've verified that the two users/threads are indeed using their own instance of MSSQL and therefore their own instance of m_Connection. The two instances of m_Connection will have the same connection string (SQL login used, not Windows authentication). There are no exceptions/error conditions occuring elsewhere apart from this final error. I don't think it's the connection/data reader closing - I've triple checked all open/close pairs and the close is always within a Try...Catch with the connection closed in the Finally section. The error never occurs in our own use of data readers, only from within ExecuteScalar. Hmm, I guess I could write my own version of ExecuteScaler... So, pretty flummoxed at the moment. I willing to try any suggestions! Cheers, Rob. Tag: Problem with Framework Tag: 118089
  - 24
    - How do a get a sql serverSscale value from a numeric datatype Windows Forms Application Sql Server backend Controls are bound to a DataSet I want to restrict the amount of numbers to the right of the decimal a user can enter into a control that is bound to a sql server numeric, .net system.decimal. If the numeric's scale is 2 then the user can only enter 2 numbers to the right of the decimal. If the numeric's scale is 3 then the user can only enter 3 numbers to the right of the decimal, etc.... I want this to be dynamic, the control 'knows to do this'. How can I get the value of the scale through ADO.NET? Tag: Problem with Framework Tag: 118087
  - 25
    - Error "exporting data" in Server Explorer Greetings! In the VS.Net IDE, in the Server Explorer, you can right-click on a table and choose "Export Data" to send the table data to a .dat file which can be used in scripts to recreate the database. When I attempt to use this I get this error: "The bulk copy initialization failed. Possibly the connection was not BCP enabled." Does anyone know how to fix or get around this? Thanks, Mike Tag: Problem with Framework Tag: 118086

Hi

vs2005 rc. When I try to add a connection to a winform project, I get the
error 'An unexpected error occurred in the .Net Framework Data Provider for
SQL Server Mobile Edition. Please contact the provider vendor to resolve
this problem.'.

How can I fix this?

Thanks

Regards

Top

Re: Problem with Framework by Ken

Ken
Wed Sep 28 05:26:21 CDT 2005

Hi,

I would try and do a repair on vs.net 2005 rc

Ken
-------------------
"John" <John@nospam.infovis.co.uk> wrote in message
news:%23SE5wh6wFHA.1124@TK2MSFTNGP12.phx.gbl...
> Hi
>
> vs2005 rc. When I try to add a connection to a winform project, I get the
> error 'An unexpected error occurred in the .Net Framework Data Provider
> for SQL Server Mobile Edition. Please contact the provider vendor to
> resolve this problem.'.
>
> How can I fix this?
>
> Thanks
>
> Regards
>
>

Top