BackgroundWorkers and ADO.Net

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
    - Automatic filling fields Hi guys, could you please help me on my problem. >>>> --------------- <<<<<<<<< Datasource: MS Access 2003 Table1: Tbl_Employee Field1: Emp_name Field2: Position Field3: Contact# Field4: Address Table2: Tbl_Salary >>>> --------------- <<<<<<<<< Windows Form of Visual Basic.net i have a field Employee on the form, the problem is, i when i type the name of employee, i want the position, contact# and address to automatically fill my other fields and will save on my database Tbl_Salary. -- Message posted via DotNetMonster.com http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-ado-net/200707/1 Tag: BackgroundWorkers and ADO.Net Tag: 140566
  - 2
    - ObjectDataSource a little help I have something that works, but it only returns one row of data when i create an ObjectDataSource with it and bind it to a gridview so i need a little help with this (thanks) as simple as it gets 1. my class: Imports Microsoft.VisualBasic Public Class radioShowFiles Private _szFileName As String Public Property szFileName() As String Get Return _szFileName End Get Set(ByVal value As String) _szFileName = value End Set End Property End Class 2. the functions that allows it to bind: Public Function fn_getallRadioShows() As DirectoryInfo Dim ri As System.IO.DirectoryInfo = New System.IO.DirectoryInfo("c:\websites\arlnewlook\radioshows") Return ri End Function Function fn_rtn() As radioShowFiles Dim rsf As radioShowFiles = New radioShowFiles Dim ri As DirectoryInfo = Me.fn_getallRadioShows Dim diar1 As IO.FileInfo() = ri.GetFiles() Dim dra As IO.FileInfo For Each dra In diar1 rsf.szFileName = dra.Name Next Return rsf End Function End Class I know why it's only including the last row of data, but i am sorry to say i don't know what to do to change it! I know i'm very close. THANKS! KES -- Share The Knowledge. I need all the help I can get and so do you! Tag: BackgroundWorkers and ADO.Net Tag: 140565
  - 3
    - combining datasets Hi, I have 2 datasets right now, say with the following structure: DataSet 1 has a row called ItemCode, index 1 DataSet 2 has a row called ItemCode, index 1 both are similar, but i need to merge them to make one dataset, which needs to have everything in DataSet1 plus anything from DataSet2 that's not in DataSet1 already. I'm not too familiar with working with Datasets, i know theres suppose to be a way to join them, can someone help out? Both have a ItemCode which is what needs to be used to make sure no duplicates from DataSet2 get into DataSet1. Thanks. Tag: BackgroundWorkers and ADO.Net Tag: 140563
  - 4
    - DataAdapter with Parameter problem When I run the following code everything works fine (which proves the = stored procedure and the parameter: Dim cmdSQL As New SqlCommand cmdSQL.CommandType =3D CommandType.StoredProcedure cmdSQL.CommandText =3D "bdl_CustomerOrders_SELECT" cmdSQL.Connection =3D mcnnSQL Dim prm As New SqlParameter() prm.ParameterName =3D "@CustomerID" prm.Value =3D Me.cboCustomerSELECT.SelectedValue prm.Direction =3D ParameterDirection.Input cmdSQL.Parameters.Add(prm) mcnnSQL.Open() Dim dr As SqlDataReader dr =3D cmdSQL.ExecuteReader() While dr.Read Debug.WriteLine(dr.Item(0).ToString) End While dr.Close() However, when I run the following code I get the error message: Incorrect syntax near 'bdl_CustomerOrders_SELECT' at the last line: = sda.Fill(ds, "CustomerOrders") Thoughts anyone ? Dim sda As New SqlDataAdapter("bdl_CustomerOrders_SELECT", mcnnSQ= L) Dim prm As SqlParameter =3D = sda.SelectCommand.Parameters.Add("@CustomerID", SqlDbType.NChar, 5, = "CustomerID") prm.Direction =3D ParameterDirection.Input prm.SqlValue =3D Me.cboCustomerSELECT.SelectedValue sda.TableMappings.Add("Table1", "CustomerOrders") Dim ds As New DataSet() sda.Fill(ds, "CustomerOrders") Des -- = Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ Tag: BackgroundWorkers and ADO.Net Tag: 140562
  - 5
    - Question about TransactionScope Hi, Does TransactionScope need DTC in situations that the transaction is not distributed? I have a set of non-distributed transactions and I am not sure that TransactionScope is the best option for best practice perspective. Thank you, Max Tag: BackgroundWorkers and ADO.Net Tag: 140560
  - 6
    - Strongly Typed DataSet -> Preview Data -> How to preview stored procedures with GUID parameter? Hi, In Strongly typed datasets, when we preview a table adapter query, we cannot preview a stored procedure query that has GUID parameter. The error complains that cannot convert a string to GUID. What is the proper format for GUID parameters? Of course I tried {.} format. Thanks, Max Tag: BackgroundWorkers and ADO.Net Tag: 140556
  - 7
    - Typed DataSets ADO.NET 2.0 For a project I have a typed dataset created ( by dragging tables/ views and configuring the appropriate queries ). If the database schema for these tables is changed (e.g. few columns get added), is it possible to automatically refresh the DataSet. Right now, I see that the Fill query only has the previous columns selected, the new added ones do not appear. This is my first time using datasets, so wondering if the adapter queries can be refreshed somehow. Thanks. Tag: BackgroundWorkers and ADO.Net Tag: 140553
  - 8
    - Check user input data exist in database: ERROR Dim retVal As Boolean = False Dim cnSQL As SqlConnection Dim cmSQL As SqlCommand Dim strSQL As String strSQL = "Select * From Table_Contacts where EmailAddress = '" & txtEmail.Text & "' OR Name = '" & txtName.Text & "';" cnSQL = New SqlConnection(thisConnection) cnSQL.Open() cmSQL = New SqlCommand(strSQL, cnSQL) Dim reader As SqlDataReader = cmSQL.ExecuteReader() If Not reader.HasRows Then retVal = False MessageBox.Show("No Record") Else MessageBox.Show(" already exists!", " ", MessageBoxButtons.OK, MessageBoxIcon.Error) retVal = True End If cnSQL.Close() cmSQL.Dispose() cnSQL.Dispose() retVal = True Can someone help me with this? I'm keep getting "already exist" even there is no matching record in the database. - Thanks Tag: BackgroundWorkers and ADO.Net Tag: 140546
  - 9
    - Help with this Argument 'Prompt' cannot be converted to type 'Stri Hi; I am creating a windows app using ado.net 2.0 in the app I am connecting to a database by creating and then using a data provider factory. When I call sqlConn.Open() I get the follwoing message "Argument 'Prompt - cannot be converted to type String". What am I missing in my code ? My code follows: Here are the entries in my app.config file <configuration> <appSettings> <add key="provider" value="System.Data.SqlClient" /> </appSettings> <connectionStrings> <add name ="cnStr" connectionString = "Data Source=aServer;integrated Security=True;initial Catalog=GoodTable" /> </connectionStrings> </configuration> Here is how I call this in my app. : Try Dim sAttr As String = ConfigurationManager.AppSettings("provider") ' Dim dp As DataProvider = CType(Enum].Parse(GetType(DataProvider),sAttr), DataProvider) Dim cnStr As String = ConfigurationManager.ConnectionStrings("cnStr").ConnectionString ' Create the provider factory Dim df As DbProviderFactory = DbProviderFactories.GetFactory(sAttr) 'Connection here Dim sqlConn As DbConnection = df.CreateConnection() sqlConn.ConnectionString = cnStr Catch ex As Exception MsgBox(ex) End Try Try sqlConn.Open() Catch ex1 As Exception MsgBox(ex1) End Try Thanks for any suggestions ! -- Gordon Tag: BackgroundWorkers and ADO.Net Tag: 140545
  - 10
    - What are the pros and cons in using Enterprise Library? I'm new to .net. It seems that those application blocks in Enterprise Library are very useful especially when one tries to build a new application. I want to know the pros and cons in using those blocks. Is MS going to release new Enterprise Library for future .net version/build? If I use the current version of the blocks, what happen when a new version comes out? Tag: BackgroundWorkers and ADO.Net Tag: 140544
  - 11
    - NULL GUID fields in a Nested Query Hi there, Firstly, I hope this is in the right place! I have a problem with a nested query I am generating at runtime. My table (tblIndexValue) has values in every cell in all rows including the createdUserID column. The createdUserID's datatype is a GUID, and the table is in Access using Jet 4 to connect from .NET. Here is the query, as captured in the immediate window: - SELECT DocumentID, (SELECT value FROM tblIndexValue WHERE indexFieldID={7b47a555-9a8e-4336-acbf-12b170d46f71} AND departmentID={f7d75dd6-096c-43e1-9f25-285fbe74a547} AND DocumentID=Q.DocumentID) AS IV1, (SELECT createdUserID FROM tblIndexValue WHERE indexFieldID={7b47a555-9a8e-4336-acbf-12b170d46f71} AND departmentID={f7d75dd6-096c-43e1-9f25-285fbe74a547} AND DocumentID=Q.DocumentID) AS IVID1 FROM tblDocument AS Q GROUP BY Q.DocumentID; IV1, i.e. the value field (a text value) displays fine. However, IVID1, the createdUserID file (a GUID) only shows NULLS. If I run the inner query on it's own (i.e. SELECT createdUserID FROM .... substituting the Q.DocumentID for any of my documentID GUIDs) it displays as expected. Have I missed something here? Many thanks, David Tag: BackgroundWorkers and ADO.Net Tag: 140539
  - 12
    - Flummoxed by Connection Problem Everything was working fine until suddenly this problem appeared from nowhere: Boot up the pc and go into SQL Server Management Studio. The database is present and the data can be accessed. Go into VB2005 Express and run the project. Everything works fine. Open Database Explorer and connect to the database and the following happens: 1. The project no longer works and this error appears at cnn.open() 'Cannot open user default database. Login failed. Login failed for user' 2. The database is no longer available in Management Studio. It appears but no longer has the little + sign next to it and the data is no longer accessible. If I try and view the database properties I get this error: Cannot show requested dialog. ADDITIONAL INFORMATION: Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt) An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) Database 'T:\VS_DATA\NORTHWND.MDF' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945) The only way I can get out of this situation is to reboot my pc. I am ok as long as I don't try and connect to the database via Database Explorer. I have tried disconnecting from and even deleting the database in Database Explorer to no avail. HELP! Des -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ Tag: BackgroundWorkers and ADO.Net Tag: 140536
  - 13
    - Computed Field In Typed Dataset I have a list box that is bound to an object data source. I added a column, say ColumnC, to my typed data set (using the designer) and for the expression property I entered ColumnA + ': ' + ColumnB When I preview the data in the designer I get exactly what I want. Now I go over to the object data source on my web page, refresh it and refresh the schema. I can now see ColumnC as an option for the list box's data text field. However, when I run the page nothing shows up in the list box. However, when I view the page source, I see that the data value field did render. Next I put in a value (instead of the default DBNull) for the DefaultValue property. After going through the whole exercise of refreshing and such again, I run the page and the default value I put in is returned in the list box. Does anyone know what I missed? It must be something stupid. Thanks ... Tag: BackgroundWorkers and ADO.Net Tag: 140531
  - 14
    - !VB.NET/Access: OleDbException (Data type mismatch in criteria expression) Dear ADO.NET experts! I hope someone can help me, as I've been tearing my hair out with this one all day! I'm getting very odd "Data type mismatch in criteria expression" errors that I can absolutely not nail down or debug at all. SCREENSHOT: http://img384.imageshack.us/img384/6564/oledbexceptionwb5.jpg Using: VB.NET (2005/.NET 2.0 & MS Access (2000) MDB) Process: This is a Wizard to make a monthly tax return. The user selects a date from a pre-filled drop-down combo box and clicks "Next" to go to the next page of the Wizard which loads payments (grouped by supplier) from the Payments table into a DataGridView. The tableadapter fill method is called, passing the From and To dates which are used to determine which payments are shown in the DataGridView on the next page. --- SQL (taken from the command property of the dataset designer): SELECT Subcontractor_ID, SUM(Gross) AS Gross, SUM(DirectCostOfMaterials0dp) AS DirectCostOfMaterials0dp, SUM(TotalAmountDeducted) AS TotalAmountDeducted, SUM(Net) AS Net FROM Payment WHERE (PaymentDate >= ?) AND (PaymentDate < ?) AND (Company_ID = ?) AND (MonthlyReturn_ID IS NULL OR MonthlyReturn_ID = '') GROUP BY Subcontractor_ID CODE: ' A tax month is from the 6th to the 5th of the following month _FromIncDate = DateAdd(DateInterval.Day, 1, DateAdd(DateInterval.Month, -1, CDate(cboMonthlyReturnPeriod.Text))) _ToDate = DateAdd(DateInterval.Day, 1, CDate(cboMonthlyReturnPeriod.Text)) ' Crashes on this line taPayments.FillForNewMonthlyReturn(DsInvoice1.Payment, _FromIncDate, _ToDate, My.Settings.CurrentCompany_ID) --- I have checked, double-checked and re-checked the data The table columns are defined as "DateTime" in Access, "DateTime" in the DataSet designer, and the values passed as parameters to the .Fill function are .NET Dates. This fault only happens on one customer's database, although this database appears to be no different to any of the other databases. I had thought perhaps this was to do with regional settings, but cannot find any evidence for this. What can I do to prevent this from occurring, and how can I debug the OleDbException to find out precisely what column the type mismatch is referring to? Warm Regards, Mike Wilson P.S. How does one go about subscribing to the Microsoft privatenews.microsoft.com newsgroups? We have an MSDN Subscription, but the links from the MSDN Subscriber Downloads page take you round in circles... (also x-posted to: microsoft.public.dotnet.languages.vb.data - but forgot to add this group) Tag: BackgroundWorkers and ADO.Net Tag: 140530
  - 15
    - Ado.net and SQl view ??? Dear all, I would like to bind a datgrid control to an SQL view. How set SQL command type for a view ? Is it Text ? IN which form the sql view is returned, data set ? When I get my view bind to my grid, if new data is inserted in my database, does my view will be automatically refreshed with new data or dor I have to run the refresh my self with my datagrid ? The idea is that I would like that my grid data gets automatically updated if new data gets inserted and remove from my tables manged by the view thnaks for help regards serge Tag: BackgroundWorkers and ADO.Net Tag: 140529
  - 16
    - Sending a set of data to a stored procedure Hello I need to write a stored procedure that executes a bunch of bulked and related(stock) trades. For example, the customer may have requested four trades to be placed. The trades are related because the money from selling one stock say needs to fund a new stock purchase. What is the recommened approach for sending the set of information to my stored procedure please? I can'r rely on stored proc parameters because the number of bulk trades varies and can be quite large. We have thought of two possible approaches: 1. Send a delimited string with special characters in the string signalling the begining of a new trade instruction. Clearly the stored proc is going to be complicated because of the string handling it is going to have to do 2. Insert the trade instructions into a temporary table and have the trade execution stored read the data from it during from its execution The target database is Sybase. Thanks Amir Tohidi Tag: BackgroundWorkers and ADO.Net Tag: 140525
  - 17
    - Syntax error in INSERT INTO statement. vb.net I am using VB.net The Error message is :Syntax error in INSERT INTO statement. vb.net Could this be casused by my primary Key? if my primary key is "ID" and it is (autonumber). I tried inseting a blank field, number in a field, and the example is with out the field at all. INSERT INTO EST_TRI_Target_Data (TRI Facility ID, Facility Name, Street Address, City, State, Zip Code, County, Parent Company, Parent Company Duns, Mailing Name, Mailing Street Address, Mailing City, Mailing State, Mailing Zip Code, Public Contact Name, Public Contact Phone, Tech Contact Name, Tech Contact Phone, Tech Contact Email, Major Industry, Primary SIC Code) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) This is the code Dim myConnection2 As New _ OleDbConnection( _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\Documents and Settings\BookPC\My Documents\EST ltd USA\TRI data\TRI_data.mdb") 'Dim mySqlDataAdapter As SqlDataAdapter Dim strSelect2 As String = _ "SELECT * FROM EST_TRI_Target_Data" Dim dsCmd2 As _ New OleDbDataAdapter(strSelect2, myConnection2) 'myConnection2 = New SqlConnection("server=(local)C:\Documents and Settings\BookPC\My Documents\EST ltd USA\TRI data\TRI_data.mdb;Trusted_Connection=yes;database=TRI_data") 'mySqlDataAdapter = New SqlDataAdapter("Select * from EST_TRI_Target_Data", myConnection2) Dim myDataSet As DataSet = New DataSet() Dim myDataRow As DataRow ' Create command builder. This line automatically generates the update commands for you, so you don't ' have to provide or create your own. Dim myDataRowsCommandBuilder As OleDbCommandBuilder = New OleDbCommandBuilder(dsCmd2) ' Set the MissingSchemaAction property to AddWithKey because Fill will not cause primary ' key & unique key information to be retrieved unless AddWithKey is specified. dsCmd2.MissingSchemaAction = MissingSchemaAction.AddWithKey dsCmd2.Fill(myDataSet, "EST_TRI_Target_Data") myDataRow = myDataSet.Tables("EST_TRI_Target_Data").NewRow() 'myDataRow("TRI_Facility_ID") = "gs5436t3tsata" 'myDataRow("Parent_Company_Duns") = "db Enterprises" 'myDataRow("County") = "Nassau" myDataSet.Tables("EST_TRI_Target_Data").Rows.Add(myDataRow) myDataSet.Tables("EST_TRI_Target_Data").Rows(0)("ID") = dsCmd2.MissingSchemaAction Do While i < 21 i = i + 1 'SearchText = IIf(TextBox2.Text = "", "Tech Contact Name" & "</td><td><font color=#990000>", TextBox2.Text) SearchText = IIf(TextBox2.Text = "", DataFields(i, 0) & "</td><td><font color=#990000>", TextBox2.Text) gOptions = "rtfWholeWord" 'RichTextBox1.Find (FindString, StartPos, EndPos, Options) ' options: rtfNoHighlight,rtfWholeWord, rtfMatchCase TextLength = RichTextBox1.TextLength PosOne = RichTextBox1.Find(SearchText, 0, RichTextBoxFinds.NoHighlight) PosTwo = RichTextBox1.Find("</font>", PosOne, RichTextBoxFinds.NoHighlight) RichTextBox1.SelectionStart() = (PosOne + 29 + DataFields(i, 1)) FieldSize = PosTwo - (PosOne + 29 + DataFields(i, 1)) RichTextBox1.SelectionLength = FieldSize 'StoremyData.DesignMode.Tables(0).Rows(i)(DataFields(i, 0)) = RichTextBox1.SelectedText 'MsgBox(RichTextBox1.SelectedText) myDataSet.Tables("EST_TRI_Target_Data").Rows(0)(DataFields(i, 0)) = RichTextBox1.SelectedText 'myDataRow(DataFields(i, 0)) = RichTextBox1.SelectedText ' If PosOne = -1 Then ' MsgBox("Text not found") ' Else ' MsgBox("Text Found") ' End If Loop '*************************************************************************** 'myDataSet.Tables("EST_TRI_Target_Data").Rows.Add(myDataRow) Debug.WriteLine(myDataRowsCommandBuilder.GetInsertCommand.CommandText) dsCmd2.Update(myDataSet, "EST_TRI_Target_Data") myConnection2.Close() Tag: BackgroundWorkers and ADO.Net Tag: 140523
  - 18
    - How to insert data row and reading out the ID of the new dataset Hello there, what is the best way to add an dataset and, then, to read out the ID value of the created dataset? ExecuteNonQuery() does not retrieve informations about the new ID of the dataset. Of course I can execute a statement like this: SELECT MAX(ID) from TableName, but this would not work, if the ID is of type string (this could be if someone likes to create a GUID string as ID value). Is there a possibility to work with a Dataset by setting the SelectCommand and UpdateCommand properties? How to I define the SelectCommand to fetch the ID of the new dataset? Regards, Norbert Tag: BackgroundWorkers and ADO.Net Tag: 140522
  - 19
    - System.Transactions.Diagnostics.DiagnosticTrace throws an exception of initialization I use .Net 2.0 and connect to a database access, on the connection.open() I've this message "The type initializer for 'System.Transactions.Diagnotics.DiagnosticTrace' threw an exception" Code : public DataSet GetData(string SqlQuery) { using (OleDbConnection connection = new OleDbConnection(m_ConnectionString)) { connection.Open(); OleDbCommand command = new OleDbCommand(SqlQuery, connection); command.CommandType = CommandType.Text; OleDbDataAdapter adapter = new OleDbDataAdapter(command); DataSet ds = new DataSet(); adapter.Fill(ds); connection.Close(); return ds; } } Thanks for your help Tag: BackgroundWorkers and ADO.Net Tag: 140521
  - 20
    - Sharing a DataSet among different Projects in a solution? I have genearated a Typed DataSet in a C# project and am able to use it in the from designer (I can drop a dataset Object from tool box and Set its DataSetName Property this typed dataset very normally) my Question is: Can I share this typed dataset with other projects in solution so I can use in their form designer? the reason I need this is I guess regerating a Type in another project (Assembly) actually makes a new type that is not considered the same by the .Net Runtime(even if the definition is exactly the same) Tag: BackgroundWorkers and ADO.Net Tag: 140513
  - 21
    - From ADO.NET 1.1 to SQL 2005 and SQL 2008 Dear Sirs. I have Client Server Application on Client Side i have .NET 1.1 WinForm Application on Server Side i have SQL Server 2000 I'm using "OLE DB PROVIDER FOR SQL SERVER" for the Data Access 1) I'd like to upgrade Server Side to SQL Server 2005 (I will copy same database with users to sql2005) Should i update Clients to .NET 2.0 too ? Do i need install Native Client Lib on Client ? 2) when SQL Server 2008 is Relesed Can i connect to it from .NET 1.1 Application ? Thank you in Advance. Tag: BackgroundWorkers and ADO.Net Tag: 140512
  - 22
    - finding column/row that causes System.Number.FormatException I'm reading in xml into a dataset. I'm having to mess around with the types of the xsd as well, since there are many null values in the data. The data is about 25% string, 10% int, the rest decimals. When I read this data in I frequently get a System.Number.FormatException. No surprise, since I'm messing with types in the xsd. But there is no indication of what row, column or string caused the error. So I'm doing this by process of elimination. Which is taking forever, due to the presence of nulls. I have no ability to modify the data really. Is there *any* way to set a breakpoint on System.Number.ConvertToNumber()? That might not be the exact method call... The exception has no data, the innerexception is null and the msg tells me basically nothing. Grr. Also, there are several thousand rows in about 85 tables. Tag: BackgroundWorkers and ADO.Net Tag: 140510
  - 23
    - Strongly Typed DataSets and "Refresh the data table" Option Hi, Using Visual Studio 2005 and SQL Server 2005: I am trying to understand the stored procedures that Strongly Typed Datasets wizard generates for me. When we create a new strongly typed Datasets, and choose the following path: Choose connection-> Create new stored procedures -> Enter SQL (select * from tbl) -> Advanced Options -> Refresh the data table We have an advanced option to refresh the data table. When we check the option, the wizard adds a select statement to the end of SP_INSERT and SP_UPDATE. I don't understand how the result of the added select statement (to the insert and update stored procedures) are being read back by the internal DataAdapter. What makes the table adapter reads the result of the select statement after insert or update operations? A link to an online article would greatly help. Thank you, Max Tag: BackgroundWorkers and ADO.Net Tag: 140509
  - 24
    - How save DataSet back to database? In my client Windows application, I am receiving a DataSet containing one DataTable. This comes to my client via the business tier on a different physical machine (we're using WCF if that matters). After I make changes to the data in the underlying DataTable, I send the DataSet back to the business tier. In the business tier, what should my code look like to persist the data up to the database? I'm assuming I need to do something like this: Dim Connection As New SqlConnection() Connection.ConnectionString = My.Settings.COWFeedyardConnectionString Dim Command As New SqlCommand() Command.Connection = Connection Dim DataAdapter As New SqlDataAdapter() DataAdapter.UpdateCommand = Command DataAdapter.Update(PenDataSet) .. but I get the errror: "Update unable to find TableMapping['Table'] or DataTable 'Table'." Thanks for any help, Ron Tag: BackgroundWorkers and ADO.Net Tag: 140507
  - 25
    - How best to automatically update What is the best way to update a row in a DataGrid to the server database automatically whenever a user edits and then steps off the row they have been editing (rather like in Access). There doesn't seem to be an explicit RowEndEdit event so I was thinking of setting a flag on the CellEndEdit event and running the update off the RowLeave event if the flag is set. Thoughts anyone? Des -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ Tag: BackgroundWorkers and ADO.Net Tag: 140506
- Next
  - 1
    - HELP: CLR Trigger Fails when inside a user defined transaction! when I use my C# Application to update My DB using a transation I get the following Exception The context transaction which was active before entering user defined routine, trigger or aggregate "UpdateIntegrityCheck" has been ended inside of it, which is not allowed. Change application logic to enforce strict transaction nesting. What should I do? Tag: BackgroundWorkers and ADO.Net Tag: 140503
  - 2
    - probleum in running asp i am facing the probleum in running asp onmy machine. i am using window xp 2000 and also i have installed iis on my machine but the asp does't work plese guide me how can i remove this probleum Tag: BackgroundWorkers and ADO.Net Tag: 140502
  - 3
    - Can ADO to leave remnant data behind? I have encountered a situation where supposedly a function returning a datatable does not always clear the datatable before loading. This is according to a client, but I have not been able to verify that this is indeed what is happening ... client evidence seems to indicate this "type" of problem. For example, Dim dtMast As New dsMaster.MastDataTable For each drSetup in dtSetup dtMast = CreateTimeLine(drSetup.UniqueID, dtTemp1, dtTemp2) Next -------------- public function CreateTimeLine(...) as dsMaster.MastDataTable Dim dtMast As dsMaster.MastDataTable dtMast = New dsMaster.MastDataTable : : return dtMast end function -------------- Shouldn't the "dtMast = CreateTimeLine(drSetup.UniqueID, dtTemp1, dtTemp2)" always create a new dtMast such that all of the rows in the table are cleared when the CreateTimeLine is called each time in the loop? In walking through it in the debugger (VS 2003 Framework 1.1) it exhibits that behavior each and every time (i.e., the data from the prior loop is NOT in the database table), but has anyone encountered a situation where this does not occur with each function call ... essentially creating a table with rows from the last two loops instead of rows from just the latest? Thanks RonF Tag: BackgroundWorkers and ADO.Net Tag: 140499
  - 4
    - EnterpriseLibrary. Return Recordset from oracle stored procedure Hi, I'm trying to use an EnterpriseLibrary 3.1 and return recordset from oracle database using stored procedure. As you may know, oracle stored procedures have out parameter of type cursor in order to return a dataset. It seems like I need to add a paramenter of type cursor to execute this stored procedure, but I can't find the type for the cursor. Does enterprise Library support this senario at all? Thanks everybody, Oleg Tag: BackgroundWorkers and ADO.Net Tag: 140497
  - 5
    - Exception at SqlCommand.Connection.Open() in nested TransactionScope Hi, I have a VB class to update a MS SQL server according to different incoming parameters in .Net 2.0. However, I keep getting the error message "Communication with the underlying transaction manager has failed." when I have nested TransactionScope. I am quite new to this topic, please kindly correct me if my implementation is incorrect. Public Class UpdateAssignment MainFunction( param 1, param2) Try Using scope As TransactionScope = New TransactionScope() ..... ..... Function2(param2) scope.Complete() End Using Catch ex As System.Exception IsSuccess = False End Try End Function Function2 Try Using scope As TransactionScope = New TransactionScope() For i = 0 To 10 Function3 Next scope.Complete() End Using Catch ex As System.Exception IsSuccess = False End Try End Function Function3 Dim oSqlConnection As SqlConnection = New Data.SqlClient.SqlConnection Dim oSqlCommand As SqlCommand = New Data.SqlClient.SqlCommand Try Using scope As TransactionScope = New TransactionScope() oSqlConnection.ConnectionString = ConnectionString1 oSqlCommand.Connection = oSqlConnection ...'Add param here ... oSqlCommand.Connection.Open() oSqlCommand.ExecuteNonQuery() scope.Complete() End Using Catch ex As System.Exception IsSuccess = False Finally oSqlCommand.Dispose() oSqlConnection.Dispose() End Try End Function End The exception will occur at the oSqlCommand.Connection.Open() in Function3 when it loops for the second time. The error message is "Communication with the underlying transaction manager has failed." The inner exception is "Error HRESULT E_FAIL has been returned from a call to a COM component." Attached also the stack trace: System.Transactions.TransactionManagerCommunicationException was caught Message="Communication with the underlying transaction manager has failed." Source="System.Transactions" StackTrace: at System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropigationToken(Byte[] propagationToken) at System.Transactions.TransactionStatePSPEOperation.PSPEPromote(InternalTransaction tx) at System.Transactions.TransactionStateDelegatedBase.EnterState(InternalTransaction tx) at System.Transactions.EnlistableStates.Promote(InternalTransaction tx) at System.Transactions.Transaction.Promote() at System.Transactions.TransactionInterop.ConvertToOletxTransaction(Transaction transaction) at System.Transactions.TransactionInterop.GetExportCookie(Transaction transaction, Byte[] whereabouts) at System.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx) at System.Data.SqlClient.SqlInternalConnection.Enlist(Transaction tx) at System.Data.SqlClient.SqlInternalConnectionTds.Activate(Transaction transaction) at System.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at UpdateAssignment.Function3(TAJobAction JobAction) in http://server//Project/App_Code/UpdateAssignment.vb:line 169 Any help is greatly appreciated. Thank you. Angela Tag: BackgroundWorkers and ADO.Net Tag: 140492
  - 6
    - Copying Rows from a DataSet Is there an easy way to copy rows from one data set to another other than field by field copy? Thanks Brad Tag: BackgroundWorkers and ADO.Net Tag: 140487
  - 7
    - DataSet.ReadXml and "Input string was not in a correct format." Hi I have a strongly typed dataset which I am trying to populate with data from an XML document. I am getting the error: Input string was not in a correct format. The problem is that one of the columns in one of the dataset's tables is of type double: <xs:element name="TotalBalance" type="xs:double" minOccurs="0" /> The XML document that I am being sent contains an empty element for this column: <TotalBalance></TotalBalance> Obviously an empty string, which is how the above element is being interpreted, can not be cast to a double. There many similar instances in the documents that I am receiving. Is there a simple way of telling my dataset to ignore such empty elements for value types? I could parse and clean the XML myself prior to calling ReadXml() but I really don't want to do that. Thanks Amir Tag: BackgroundWorkers and ADO.Net Tag: 140481
  - 8
    - Collections, databinding, column name There seems to be an infinite way to create a business object in which a .NET control can bind to: Strings(), Arraylist, datasets, a vast collection library... But none of them that I create seem to show the .NET control what the column names are. I want to bind to an objectdatasource, and have the gridview or dropdown list automatically recognize what is being return to it. What kind of collection do I use for that? Tag: BackgroundWorkers and ADO.Net Tag: 140477
  - 9
    - TableAdapter Wizard Unique Keys Not Created Automatically Hi, I have a table in SQL Server 2005 that has a unique key on two columns. When I run the TableAdapter wizard and create a corresponding tableadapter for the table the unique key constraint is not created. I have to create it manually in the designer. It there a way to have the unique key created by the wizard automatically? I'm surprised it does not do this automatically in the first place. Thanks for your help, Terry Tag: BackgroundWorkers and ADO.Net Tag: 140474
  - 10
    - How to make Raiserror report to ado.net Hi group, I have put some validation logic in a trigger and when it doesn't validate I do a rollback + raiserror. So for so good but how do I detect this in ADO.NET ? Is there a way to use raiserror or some othe mechanism to communicate to ado.net/asp.net that someting went wrong? Currently if I do an insert and it doesn't validate the ASP.NET site still thinks everyting is fine. Tag: BackgroundWorkers and ADO.Net Tag: 140473
  - 11
    - SQL JOIN between DataTables in a DataSet Hello, Am I correct in thinking that it is currently not possible to perform an SQL JOIN across multiple DataTables in a DataSet in .NET? I have a typed DataSet with three relational tables which need to be placed into one flat table, e.g.: Table A: PK, Table A Col 1, Table A Col 2... Table B: PK, FK 1 (Table A PK), FK 2 (Table C PK) Table C: PK, Table C Col 1, Table C Col 2... => PK, Table A Col 1, Table A Col 2, Table C Col 1, Table C Col 2 Currently the only way to resolve this involves embedded for-loops going down each of the typed relations to get the required data. Obviously performing one SELECT statement would be far more efficient, but is this possible here? I only have access to this DataSet and so am unable to perform the join in the database before the DataSet is Filled. Thanks, Marc Tag: BackgroundWorkers and ADO.Net Tag: 140469
  - 12
    - How to put ' and " into sql I need to put " and ' into sql server database. I write: string SQL = "INSERT INTO SomeTable (Email, Message) VALUES (' + txtName.Text + "','" + txtMessage.text +')"; What if someone enters character ' in text box? Than I got error message because ' is character for strings in sql. Then my sql query have more fields because of this characters. How can I put ' and " into sql database? Tag: BackgroundWorkers and ADO.Net Tag: 140463
  - 13
    - How write SQL's "ISNULL(ThemeRank, 255)" instead in ADO.NET when sorting DataView? In SQL, I can write: SELECT * FROM Product ORDER BY ISNULL(ProductRank,255) To return: Alpha 1 Delta 2 Golf 3 Foxtrot 4 Charlie 5 Echo NULL Bravo NULL But how can I do this in ADO.NET in a DataView? Right now I just have: view.Sort = "ThemeRank ASC"; I tried: view.Sort = "ISNULL(ThemeRank, 255)"; but that didn't do the trick. Any help would be greatly appreciated. Thanks, Ron Tag: BackgroundWorkers and ADO.Net Tag: 140460
  - 14
    - tableadapter update - existing primary key I have two seperate .net programs that are working with the same table in a SQL database. Both programs are using TableAdapters to read/ write to the table. Both programs can create a record in their TableAdapters using the same primary key. If this happens and one program updates the database before the other, the later will generate the following SqlException: "Violation of PRIMARY KEY constraint 'PK_TableName'. Cannot insert duplicate key in object 'TableName'. How do I force the latter program's TableAdapter to do an UPDATE rather than and INSERT? Tag: BackgroundWorkers and ADO.Net Tag: 140456
  - 15
    - How sort DataView so blanks are at bottom, not top? I have a DataTable with column "Sequence". Values are like: Sequence -------- 5 1 3 (blank/null) 7 6 (blank/null) 4 When I create a DataView and do a sort, I get Sequence -------- (blank/null) (blank/null) 1 2 3 4 5 6 7 But I need the blank/nulls to be at the end like Sequence -------- 1 2 3 4 5 6 7 (blank/null) (blank/null) How can I do this, please? Thanks, Ron Tag: BackgroundWorkers and ADO.Net Tag: 140454
  - 16
    - Question about automatic connection string settings using VS2005 I feel like I'm forgetting something. Assume Visual Studio 2005 (VB) and assume you have created a data source and dataset by the usual means. Assume multiple tables. Now you have a designer.vb module associated with the dataset containing an InitConnection sub for each table, as well as an ominous message at the top of the file warning against manual change. (For simplicity's sake also assume that you chose the option not to create an Application Setting connection string.) Given this, is there any one place in the dataset I could programmatically set the connection string, or must I always do it for each individual table adapter, whenever one is instantiated? Tag: BackgroundWorkers and ADO.Net Tag: 140448
  - 17
    - sqltransaction timeout Hello, I have a asp.net application in which users can create content and then save everything to a SQLServer2000 database. When they hit the save button on the form here is what I do : Dim conn As SqlClient.SqlConnection = New SqlClient.SqlConnection( myconnectionstring ) Dim tx As SqlClient.SqlTransaction conn.Open() tx = conn.BeginTransaction("Cutting Saving") here I save stuff to the database (_adpCutting is my dataadapter) _adpCutting.UpdateCommand.Transaction = tx _adpCutting.InsertCommand.Transaction = tx _adpCutting.Connection = c _adpCutting.Update(_dtCutting) if everything succeeded : tx.Commit() otherwise I rollback I've noticed that when I'm debug mode and I stop just after _adpCutting.Update(_dtCutting), then I can't access my SQL table from anywhere (even from SQLServer Enterprise or any other applications). It's like the transaction is holding the table, until I commit or I rollback. This wasn't an issue up until now. But with a growing number of users and applications using this one table in the database, now I'm getting loads of timeout errors. I'm not going to increase the timeout value to be greater than 30 seconds, it doesn't make sense. Is there another way to solve this issue ? I'm not making progress on this, so I'd appreciate any help thanks Tag: BackgroundWorkers and ADO.Net Tag: 140447
  - 18
    - DataTable Performance I'm interested in knowing the runtime complexity of the DataTable.Find method in 2.0 when attempting to find a row by the primary key. The MSDN documentation is vague...probably intentionally. I used .NET Reflector to examine the DataTable and what I found is that the primary key index is implemented with a red black tree. That leads to be believe that the operation is O(log n) unless something else was going on that I missed. I'm a little disappointed that a O(1) algorithm isn't used, but I can understand the reasoning behind the BST since it keeps the index in a sorted order. Can anyone else confirm? Tag: BackgroundWorkers and ADO.Net Tag: 140443
  - 19
    - Access to tables in dataset Is it possible to treat the tables in the dataset the same as any other tables, i.e. run queries on them, etc. ? -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ Tag: BackgroundWorkers and ADO.Net Tag: 140440
  - 20
    - value NOTHING can appear in the Object() array filled by the OleDBDataReader ? I am using an OledbDataReader to read each record into an array of objects, as usual. My question is: is it ever possible that one of the values contained in the array be Nothing. I have never seen it happen and I would believe it is impossible. Can anyone confirm that ? And in case what is the reason ? -P Tag: BackgroundWorkers and ADO.Net Tag: 140436
  - 21
    - Problem adding table to DataSet .NET 2.0 I'm working on .NET 2.0 project which contains a DataSet. On this DataSet I can right click on the tables and select "preview data" and I can a preview of table data - which to me shows that VS2005 somehow is connected to the project database. The problem comes when I want to add a new table to the databaset. I know I just need to drag the table from Server Explorer (from database) on to the DataSet but no databases shows up when I click on Server Explorer. Looks like I frist need to create a databse connection... but still VS2005 is able to retrieve data from the existing tables in the DataSet... any suggestions on how fix this are most welcome! jeff Tag: BackgroundWorkers and ADO.Net Tag: 140434
  - 22
    - Iteration SLOW!!! WTF did Microsoft do when it came to ADO.NET???????????????????????? Using an OLEDB connection and Dataset it took hours to iterate through 5000+ records in one simple table. That is horrible. If I go into Access 2003 and do the same thing with old ADO and create a standard ADO resultset (recordset) ... I can iterate through 5000+ records in seconds. All I want my VB.NET application to do is copy data from an Access database to a SQL Compact Edition SDF file on the desktop. I can connect to the Access database, get data, and the iteration is damned slow ... I can open to the SDF file with OLEDB ... but I haven't gotten to do the insert statements yet ... But anyway ... What is up with an iteration being super-slow? Thanks! Tom Tag: BackgroundWorkers and ADO.Net Tag: 140433
  - 23
    - How to solve these data access issues in VS2005? 1. Connection String needs to be customizable by users during runtime. 2. Source of Connection String can be changed programmatically. 3. Tables can be modified by users. 4. Use table adapters or use data adapters 5. How to update all data tables for all datasets with changes in a Windows Form without specifying dataset? Tag: BackgroundWorkers and ADO.Net Tag: 140431
  - 24
    - deploying from vs.net 2005 vc++.net on vista to sql2005 on w2k Hi, I am using VS2005, using c++ to build a CLR DLL as an extended stored procedure for an SQL2005 instance. My VS2005 is running on Vista. I built a dll using clr and am tring to use the "deploy" feature from the list of options: BUILD, REBUILD, DEPLOY, CLEAN, ... After some time I get an error message: 1>Deployment to database failed 1>Unverifiable code failed policy check. (Exception from HRESULT: 0x80131402) ========== Build: 0 succeeded, 0 failed, 1 up-to-date, 0 skipped ========== ========== Deploy: 0 succeeded, 1 failed, 0 skipped ========== This does not tell me much. Ok, Now what? Tag: BackgroundWorkers and ADO.Net Tag: 140429
  - 25
    - How may I use the IN operator when using a RowFilter on a DataView? How may I use the IN operator when using a RowFilter on a DataView? - Such that I can query whether a value is in a column from the Table associated with the DataView. Suppose I have the following table myTable = new DataTable(); myTable.Columns.Add("ActivityID", typeof(int)); myTable.Columns.Add("MandateID", typeof(int)); myTable.Columns.Add("ConsultantID", typeof(int)); myTable.Columns.Add("ConsultantName", typeof(string)); myTable.Columns.Add("ManagerID", typeof(int)); myTable.Columns.Add("ManagerName", typeof(string)); myTable.Columns.Add("ACIS_IDs", typeof(string)); myTable.Columns.Add("AssetClassList", typeof(string)); myTable.Columns.Add("EntryDate", typeof(DateTime)); The 7th column (ACIS_IDs) currently has values like this ", 2,16,24,". i.e. A list a integers separated by a comma and starting and ending with a comma. The c# method to build the relevant part of the RowFiler search looks like this: public static string AssetClassCodeToSearchFilter(int code) { if (code == 0) return ""; else return "ACIS_IDs LIKE '%," + code.ToString() + ",%' AND "; } Q: How can I change this to use the IN operator instead of the LIKE operator? For instance so that the last line of the method is: return code.ToString() + " IN ACIS_IDs AND " When the 7th column of the table (ACIS_IDs) has values like this "(2,16,24)". I get an error message: Syntax error: The items following the IN keyword must be separated by commas and be enclosed in parentheses. An example final filter looks something like this: "16 IN ACIS_IDs AND EntryDate >= '2002-01-01' AND EntryDate <= '2007-06-30'" Will this be impossible to do? I suppose it's telling me that it wants a literal value rather than a column name for ACIS_IDs. Tag: BackgroundWorkers and ADO.Net Tag: 140423

I have an app that allows the user to build a query and then click on a
button to execute the query and the results are then used to fill a grid.
Can I have the retrieval run in a backgroundworker and have a button that
would allow the user to cancel the query if it is running for too long of a
period? Is the BackgroundWorker able to populate a grid which is running in
the primary thread?

Bill

Top

Re: BackgroundWorkers and ADO.Net by Eric

Eric
Thu Jul 19 05:10:22 CDT 2007

See
http://www.emoreau.com/Entries/Articles/2006/11/MARS-and-Asynchronous-ADONet.aspx

--

ALP

Éric Moreau, MCSD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc. (http://www.emoreau.com)

"Bill Gower" <billgower@charter.net> wrote in message
news:%2350ex3cyHHA.1164@TK2MSFTNGP02.phx.gbl...
>I have an app that allows the user to build a query and then click on a
>button to execute the query and the results are then used to fill a grid.
>Can I have the retrieval run in a backgroundworker and have a button that
>would allow the user to cancel the query if it is running for too long of a
>period? Is the BackgroundWorker able to populate a grid which is running
>in the primary thread?
>
> Bill
>
>

Top