Quirky DataGrid behavior

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 can I read a list of files from a folder into a DataTable? Hi, What is the easiest way to populate a DataTable with a list of files from a folder? Thank you, Sasha Tag: Quirky DataGrid behavior Tag: 101914
  - 2
    - testing Tag: Quirky DataGrid behavior Tag: 101911
  - 3
    - Constraint violated but no exception thrown I have a VB Windows form that calls the DataAdapter.Update method, passing a DataTable of one row with RowState = 'Added'. This is the stripped-down code: Try Dim Count As Integer = MySqlAdapter.Update(MyDataTable.GetChanges) Catch ex As System.Data.SqlClient.SqlException MessageBox.Show("Update failed: " & ex.Message) End Try The underlying table, in SQL Server 2000, has a unique constraint defined on a non-PK data column. When that column has a DataTable value which violates the constraint, the DB refuses to add the row, Update returns zero for a rowcount, but there is no exception thrown. Why not? Client: Windows XP SP1, Visual Studio 2003 version 7.1.3088, .NET Framework 1.1 version 1.1.4322 SP1, MDAC 2.8 RTM Server: Windows NT 5.0 (Build 2195: Service Pack 2), SQL Server 2000 version 8.00.760 Tag: Quirky DataGrid behavior Tag: 101907
  - 4
    - Getting off the ground with orace parameters Having a devil of a time passing a parameter to an oracle command in cnet . If I substitute the :EXID for a string (Eg 'dogbreath') and remove the parm stuff it all works. What I was expecting to happen was for the valiue in exid_txt replace the :EXID. But instead I got the error "ORA-01008: not all variables bound " at the da.fill line. Apparently I am missing can someone fill me in? query = "select ext, active, inactive from cam where ext = :EXID "; OracleCommand cmd = new OracleCommand(query,con); cmd.Parameters.Add("EXID", OracleType.VarChar); cmd.Parameters["EXID"].Value = exid_txt.ToString(); DataSet ds = new DataSet(); OracleDataAdapter da = new OracleDataAdapter(query, con); da.Fill(ds); // squeeze a view and feed it the dataset ds for sortability DataView dv = new DataView(ds.Tables[0]); Tag: Quirky DataGrid behavior Tag: 101899
  - 5
    - OracleDataReader error when returning binary/lob fields I am using the System.Data.OracleClient namespace to call on an Oracle stored procedure that runs a query and returns a ref cursor. One of the fields returned by the query is a LONG RAW. When I call OracleDataReader.Read(), I get the following exception: ORA-01406: fetched column value was truncated I have not been able to find any information on how to resolve this. I tried switching to Oracle's ODP.NET provider, but it seems to have problems of its own. Any help would be greatly appreciated. Here is some of my code Dim myCommand As OracleCommand Dim myReader As OracleDataReader 'I set up the command and reader here myReader = myCommand.ExecuteReader() While myReader.Read() ' <--- this throws the exception End While I only see the problem when calling on stored procedures. If run the same SELECT query from the application, it works fine. Tag: Quirky DataGrid behavior Tag: 101898
  - 6
    - Problem with Update Adapter I'm new to .NET, and I'm having problems creating an Adapter update command for a simple data set. I'm using the following code which compiles and runs, but does not update the database. This is just a barebones test using the Northwind database. Since this is a learning exercies, I'm not worried about concurrency at this time. I'm updating the database from bound textboxes. The data table contains one row in the dataset. The connection, adapter, and dataset are already created. Thanks in advance. // Create and configure command object SqlCommand cmdUpdateCust = cnCust.CreateCommand(); cmdUpdateCust.CommandText = "UPDATE Customers SET CompanyName = @NewCompanyName " + "WHERE CustomerID = @OldCustomerID"; cmdUpdateCust.Parameters.Add(new SqlParameter("@OldCustomerID", SqlDbType.NChar, 5, "CustomerID")); cmdUpdateCust.Parameters.Add(new SqlParameter("@NewCompanyName", SqlDbType.NVarChar, 40, "CompanyName")); cmdUpdateCust.Parameters["@OldCustomerID"].SourceVersion = DataRowVersion.Original; cmdUpdateCust.Parameters["@NewCompanyName"].SourceVersion = DataRowVersion.Proposed; daCust.UpdateCommand = cmdUpdateCust; // Push the update to the datebase cnCust.Open(); int NumRows = daCust.Update(dsCust.Tables["Customers"]); cnCust.Close(); Tag: Quirky DataGrid behavior Tag: 101897
  - 7
    - Really need some help on this I have a stored procedure that I call from an aspx page but for some weird reason i get this error message: Procedure 'sp_insert_customer' expects parameter '@username', which was not supplied. Here is my stored proc CREATE PROCEDURE dbo.sp_insert_customer @username varchar(16), @password varchar(34), @email varchar(128), @firstName varchar(50), @lastName varchar(50), @company varchar(50), @address varchar(50), @address2 varchar(50), @city varchar(50), @state varchar(50), @zip varchar(50), @country char(2), @telephone varchar(50), @cellPhone varchar(50), @fax varchar(50) AS INSERT INTO CUSTOMERS (username, [password], email, first_name, last_name, company, address, address2, city, state_province, zip_postal, country, telephone, cell_phone, fax) VALUES (@username, @password, @email, @firstName, @lastName, @company, @address, @address2, @city, @state, @zip, @country, @telephone, @cellPhone, @fax) GO And here is the funtion I am calling it from Public Function insert() As Boolean Dim oCmd As SqlCommand Try oCn.Open() oCmd = oCn.CreateCommand With oCmd .CommandType = CommandType.StoredProcedure .CommandText = "sp_insert_customer" With .Parameters .Add("@username", SqlDbType.VarChar, 16, m_username) .Add("@password", SqlDbType.VarChar, 34, m_password) .Add("@email", SqlDbType.VarChar, 128, m_email) .Add("@firstName", SqlDbType.VarChar, 50, m_firstName) .Add("@lastName", SqlDbType.VarChar, 50, m_lastName) .Add("@company", SqlDbType.VarChar, 50, m_company) .Add("@address", SqlDbType.VarChar, 50, m_address) .Add("@address2", SqlDbType.VarChar, 50, m_address2) .Add("@city", SqlDbType.VarChar, 50, m_city) .Add("@state", SqlDbType.VarChar, 50, m_state) .Add("@zip", SqlDbType.VarChar, 50, m_zip) .Add("@country", SqlDbType.Char, 2, m_country) .Add("@telephone", SqlDbType.VarChar, 50, m_telephone) .Add("@cellPhone", SqlDbType.VarChar, 50, m_cellPhone) .Add("@fax", m_fax) End With End With oCmd.Prepare() oCmd.ExecuteNonQuery() Catch ex As Exception m_lastError = ex.Message Return False Catch sqlEx As Exception m_lastError = sqlEx.Message Return False Finally oCmd.Dispose() oCn.Close() End Try Return True End Function Now the bizzare thing is if I modify the parameter list of the .Add function everything works ok. where is the problem??????? Here is the working version of that function. Public Function insert() As Boolean Dim oCmd As SqlCommand Try oCn.Open() oCmd = oCn.CreateCommand With oCmd .CommandType = CommandType.StoredProcedure .CommandText = "sp_insert_customer" With .Parameters .Add("@username", m_username) .Add("@password", m_password) .Add("@email", m_email) .Add("@firstName", m_firstName) .Add("@lastName", m_lastName) .Add("@company", m_company) .Add("@address", m_address) .Add("@address2", m_address2) .Add("@city", m_city) .Add("@state", m_state) .Add("@zip", m_zip) .Add("@country", m_country) .Add("@telephone", m_telephone) .Add("@cellPhone", m_cellPhone) .Add("@fax", m_fax) End With End With oCmd.Prepare() oCmd.ExecuteNonQuery() Catch ex As Exception m_lastError = ex.Message Return False Catch sqlEx As Exception m_lastError = sqlEx.Message Return False Finally oCmd.Dispose() oCn.Close() End Try Return True End Function Tag: Quirky DataGrid behavior Tag: 101895
  - 8
    - ADO.NET problem Hello, I am trying to build a database project and have the following. I have one table "Subject" in sql server. I have a dataclass Data1 I have a business class Business1 I have a connection class Connection1 that instantiates and returns a new sqlconnection object Business1 calls connection class and gets a new connection. Now Business1 instantiates Data1 object. New() creates a new dataadapter, 4 sqlcommand objects and assigns them to the dataadapter.command and creates a dataset object Now Business1 calls GetEmptyRecord() of Data1 and passes name of a table and connection object In GER() I assign a sql to commandtext, set commandtype and connection, create new table, add to dataset, fills dataset using fillschema, create emptyrow in table. Now I pass this datarow to Business1. Is there any way in which I can find the column names of the columns in this datarow. Since i filled table with fillschema it should have the column names and I want to avoid hard-coding column names in my code. Also, is there a way to automatically generate update, delete and insert sql commands? I tried using commandbuilder but that is not working. Thanks, Tag: Quirky DataGrid behavior Tag: 101887
  - 9
    - prueba Tag: Quirky DataGrid behavior Tag: 101885
  - 10
    - Getting XML as string Hi I'm a bit new to this so here goes my question: I need to get the XML from a dataset as a string. I've been beating my head against the wall trying to use the overload methods of the [mydataset].WriteXML methods but with no sucess. I'm sure I'm missing something easy.. Can anyone lend a hand? TIA Steve Tag: Quirky DataGrid behavior Tag: 101884
  - 11
    - a basic question Hi, I'm new to ADO.NET. I'm have a very basic problem and trying to figure out what is the best way to approach in .net. I just need to display some fields of a table (read only), but I need to choose which fields to display depending on the value of a field. Which one of the web controls and ADO class is best fit to this purpose? (so, for example if columnA='a', display coloum B C D, otherwise display column D E F...) TIA. Tag: Quirky DataGrid behavior Tag: 101875
  - 12
    - Thread was being aborted Errors Hi, I have a web app that is intermittently throwing "Thread was being aborted." errors in my data access component. This seems to occur when the app is under a heavier than normal load. I would have thought if the DB call was timing out I would get a timeout error. This is a sample of the exception details I'm getting: System.Threading.ThreadAbortException: Thread was being aborted. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at NCSUtilities.DataAccess.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at NCSUtilities.DataAccess.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) Any ideas on how I could identify the cause or how I could resolve this would be greatly appreciated. Thanks, Keith F Tag: Quirky DataGrid behavior Tag: 101872
  - 13
    - Best way to process millions of records I have a MS SQL Server database table that contains 5 million records. The primary key of the table is a GUID. I need to write an application that reads each of these records and passes some values to another process. What's the best way to retrieve the records to be processed? Reading the records into a DataTable would probably result in far too much memory usage. Does using a DataReader pass the load (and hence memory problem) onto SQL Server instead? Reading batches of records would be difficult as the primary key is a GUID and is not sequential. What about reading the primary key values into a DataTable and then reading batches of records? Has anyone had to solve a similar problem? Thanks, Peter Tag: Quirky DataGrid behavior Tag: 101867
  - 14
    - MDAC and interop.adodb Hi Gurus, I had a application in DOTNET which for D/B operations use "interop.adodb". I am facing hell lot of problem due to this. Can anybody please suggest me whats the best way to use interop.adodb beause i guess it depends lot on MDAC version.. Any URL or writeup is highly appreciated. Regards Robin Tag: Quirky DataGrid behavior Tag: 101863
  - 15
    - sp_addmergepublication error from VB.NET When attempting: exec sp_addmergepublication @publication = 'SAMPLEPublication', @description = 'SAMPLEPublication Merge publication'; from VB.NET, I receive: A severe error occurred on the current command. The results, if any, should be discarded. When running through Query Analyzer it works fine. I have changed my connection string and tried logging in using SSPI and sa, both fail from the program. Both work from QA. I have seen on newsgroups this same error, but noone has ever posted a resolution to it. Please help. I am looking at allowing the user, from a windows form, setup and configure replication, but I can't do it with the error. THanks in advance Darin *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Quirky DataGrid behavior Tag: 101861
  - 16
    - read datareader stream and read output parameters at the same time Been working through a few scenario's where I have returned a stream of data to the datareader and also returned some output parameters from a stored procedure. The question is in order to get the parameters returned from the stored procedure you have to close the datareader. Then you are unable to step through the stream return ie in a list format. can anyone advise the best way to do this at the minute i am making to calls one to get the output params and the second to then step through the datareaders stream. The only way I can think is to pass the result to a dataset and then close the reader to expose the output params ????!!!!!!??????? Regards Ben Tag: Quirky DataGrid behavior Tag: 101859
  - 17
    - Cascading issues while updating multiple tables with SqlDataAdapter.Update method All, I broke my head over this for 18 hours now and tried out all the suggestions posted here but of no use. Here is what I'm trying to accomplish I have two tables, 1) Criteria 2) Regulator Criteria is a master table and Regulator is a child table. ie, the primary key of Criteria table (CriteriaID, identity column with autoincrement set to 1) is a foreign key in the Regulator table. pretty classic stuff. I wrote a console app in C# to update these two tables using SqlDataAdapter.Update method. The only slight difference from other postings is that I get the XML data file from an external application. I have to import the data from that XML file into these two tables. I tried to follow David Sceppa's suggestions but No matter what I do, the identity value I receive from the Criteria table DOES NOT GET CASCADED to the Regulator table. As a result records are not inserted into the child (Regulator) table. Here is my code Any thoughts would be much appreciated { ...... SelectQuery = "select * from Criteria"; SqlDataAdapter CriteriaDataAdapter = new SqlDataAdapter(); SqlConnection CriteriaSQLConnection = new SqlConnection(ConnectionString); SqlCommand CriteriaSQLSelectCommand = new SqlCommand(SelectQuery, CriteriaSQLConnection); CriteriaDataAdapter.SelectCommand = CriteriaSQLSelectCommand; cmdGetIdentity = new SqlCommand("SELECT @@IDENTITY as CriteriaID", CriteriaDataAdapter.SelectCommand.Connection); CriteriaDataAdapter.RowUpdated +=new SqlRowUpdatedEventHandler(CriteriaDataAdapter_RowUpdated); SqlCommandBuilder Criteriacmdb = new SqlCommandBuilder(CriteriaDataAdapter); SelectQuery = "select * from Regulator"; SqlDataAdapter RegulatorDataAdapter = new SqlDataAdapter(); //attempted to use the same connection object..didn't help //SqlConnection RegulatorSQLConnection = new SqlConnection(ConnectionString); //SqlCommand RegulatorSQLSelectCommand = new SqlCommand(SelectQuery, RegulatorSQLConnection); SqlCommand RegulatorSQLSelectCommand = new SqlCommand(SelectQuery, CriteriaSQLConnection); RegulatorDataAdapter.SelectCommand = RegulatorSQLSelectCommand; SqlCommandBuilder Regulatorcmdb = new SqlCommandBuilder(RegulatorDataAdapter); DataSet NewDataSet = new DataSet(); NewDataSet.ReadXmlSchema("PostApprovalsReport.xsd"); DataColumn NewColumn = NewDataSet.Tables["Criteria"].Columns.Add("CriteriaID", typeof(Int32)); NewColumn.Unique = true; NewColumn.AutoIncrement = true; NewColumn.AutoIncrementSeed = -1; NewColumn.AutoIncrementStep = -1; DataColumn NewFColumn = NewDataSet.Tables["Regulator"].Columns.Add("CriteriaID", typeof(Int32)); NewDataSet.Relations.Add("CriReg", NewDataSet.Tables["Criteria"].Columns["CriteriaID"], NewDataSet.Tables["Regulator"].Columns["CriteriaID"]); Reading the data from a xml file that came from another application NewDataSet.ReadXml("5393_PostApprovalsReport_2004-12-01.xml"); CriteriaDataAdapter.Update(NewDataSet, "Criteria"); RegulatorDataAdapter.Update(NewDataSet, "Regulator"); } private void CriteriaDataAdapter_RowUpdated(object sender, SqlRowUpdatedEventArgs e) { if ((e.Status == UpdateStatus.Continue) && ((e.StatementType == StatementType.Insert))) { Console.WriteLine (cmdGetIdentity.ExecuteScalar().ToString()); e.Row["CriteriaID"] = Int32.Parse(cmdGetIdentity.ExecuteScalar().ToString()); e.Row.AcceptChanges(); Console.WriteLine (e.Row["CriteriaID"]); } } Tag: Quirky DataGrid behavior Tag: 101858
  - 18
    - Simple task, can't do in ADO.NET Switching from ADO to ADO.net and I am totally lost and and frustrated. What I'm trying to do is so dirt simple: At RUNTIME, load an arbitrary database table into a datagrid for editing. Simple: create a SqlDataAdapter, dynamically constructing the SQL command string based on the the name of the table supplied at runtime; create a CommandBuilder; call Fill, supplying a new blank DataSet; call Update when complete. So far, so good. The table that I'm editing has lookups that the user needs to be able to see as they are editing. However, there's not updatable view concept in ADO.NET. If I do a JOIN to any lookup tables, CommandBuilder flatlines and can't generate the necessary update statements. Is the only alternative here to generate the update statement by hand? That just seems incredibly tedious and unnecessary. Another weird thing is that it's a mystery as to how CommandBuilder works. If you trace through the code you'll see that it doesn't actually modify the UpdateCommand property in the DataAdapter. Somehow it's doing it's magic in the background. This prevented me from kludging up update statements from a non-lookup version of the SelectCommand and using that in the lookup version. Another problem is now to specify a primary key for the DataSet. Supposedly the SqlDataAdapter uses a DataReader in the background to generate schema for the DataSet. But the IsKey fields are all null. So somewhere between there and the DataSet it somehow decides what the primary key is, but it's not accessible to the programmer. I guess what I'm wonder is can I specify a primary key directly to the DataSet after it has been filled? Tag: Quirky DataGrid behavior Tag: 101841
  - 19
    - Is TDS used only if server is local? In order to use TDS via ADO.NET, does the SQL Server need to be on the same machine? If not, this will have to involve TCP/IP or named pipes correct? How does TDS help in that case? Thanks, Brett Tag: Quirky DataGrid behavior Tag: 101840
  - 20
    - Testing for the existence of a table All: Is there some standard way I can test for the existence of a database table? I am using ODBC with an ingres database; and I don't really want to open a query like "select * ...." because I may end up reading the whole thing in, when all I want to know is if the table exists. I'm just wondering if there is a standard way in ado with ODBC. TIA ... Greg Shannan Tag: Quirky DataGrid behavior Tag: 101835
  - 21
    - how to create a master detail display on the datagrid When I read an xml file, the read data will be converted into different tables with the relationship. But how can I display the data into a relational table like the data grid? Tag: Quirky DataGrid behavior Tag: 101834
  - 22
    - "Method '~' of object '~' failed" error Hi, I'm using ADO.NET command to execute a stored procedure which will do a bounch of deletes and inserts on database side. If the data is not too big, it's fine, but if there is a lot of data needs to be proceeded, sometime I got error of "Method '~' of object '~' failed", sometime I got "Import of MSDTC transaction failed: Result Code = 0x8004d00e." as well. When I ran the stored procedure manually with same parameters, no any problems. What could be the problem? Thanks. william Tag: Quirky DataGrid behavior Tag: 101832
  - 23
    - system.Data.OracleClient.dll 1.0.5 and TNSNAME longer than 16 char There is a known issue with system.Data.OracleClient.dll 1.0.50000.0 that came with NET 1.1 framework: It cannot handle TNSNAME entries that are longer than 16 chars and produce the error below: ORA-00162: external dbid length 17 is greater than maximum (16) Is there a work around or bug fix for this problem? Thanks Tag: Quirky DataGrid behavior Tag: 101828
  - 24
    - non-labor intensive solution to Nulls in legacy DB I don't want to enter the religious wars about NULLS and whether they should or should not be allowed in Databases. I have a legacy database and I can't change it. NULLS are a fact of life for me. My question is whether anyone has a less labor intensive solution. In the auto-generated class definition code for the datarow of eacch table is code like the following... Public Property Birthday As Date Get Try Return CType(Me(Me.tableo_Person.BirthdayColumn),Date) Catch e As InvalidCastException Throw New StrongTypingException("Cannot get value because it is DBNull.", e) End Try End Get Set Me(Me.tableo_Person.BirthdayColumn) = value End Set End Property I have been modifying this code to... Public Property Birthday As Date Get Try Return CType(Me(Me.tableo_Person.BirthdayColumn),Date) Catch e As InvalidCastException return nothing End Try End Get Set if value = nothing then Me(Me.tableo_Person.BirthdayColumn) = system.convert.dbnull else Me(Me.tableo_Person.BirthdayColumn) = value endif End Set End Property This code gets generated anytime I have to redrag a datatable into a dataset. Then I have to go thru each field and modify as above again. Is there a smarter way to do this? (I'm normally a foxpro programmer, but this one is going against a SQL server database, if that has any bearing on this question) -- T Ralya, new .NET developer, HMSA Tag: Quirky DataGrid behavior Tag: 101825
  - 25
    - Re: ADO.net Schem... Hi all gurus, I have question to clarify.. If get back a dataset. Will i get back the schema information and user rigths on the objects? Thanks Srree Tag: Quirky DataGrid behavior Tag: 101821
- Next
  - 1
    - Checking to see if SQL Service is running I have users who, as soon as they boot into XP, immediately try to run my app without waiting for all of the services to start. My app uses MSDE. Is there something I can do in code to check to see if the service is running to prevent them from running the app and therefore seeing any kind of errors? Thanks. Norton Tag: Quirky DataGrid behavior Tag: 101816
  - 2
    - Slow reads over VPN Have an Access db. When multiple user hit it on the LAN, performance is fine (response time <= 1 sec). Application is in C# using ADO.NET. When a remote user tries to access the db (via a VPN), their response time is fine also. As soon as a user on the LAN access the db, response time goes into multi second (almost a minute). All of these accesses are reads with through a dataset (not datareader). Using a packet sniffer, we find that the file system (client is XP Pro - db is on a W2K Server) is placing/clearing many lock requests on the .mdb file. Any thoughts? TIA Don Tag: Quirky DataGrid behavior Tag: 101813
  - 3
    - Still stuck on DataRelation names Hi, I've created an xml instance document named "test.xml" and from that created an associated schema document named "test.xsd". I have used the schema designer to add three primary keys and two relations. I have named the relations "RelationDocumentItems" and "RelationItemsItem". When I create a DataSet in code using ReadXml("test.xml") and then read the names of the relations in DataSet.Relations I get "TestDocument_TestItems" and "TestItems_TestItem" rather than the expected "RelationDocumentItems" and "RelationItemsItem" ( my expectation). Can someone please help me understand where my names went? Thanks Jeff Higgins Tag: Quirky DataGrid behavior Tag: 101811
  - 4
    - Syncronizing Read/Writes Using OleDB There is an issue with sync-ing read/writes from different connections when using the OleDB provider for ADO. The solution that Microsoft gives for it works using the Jet Replication Object to refresh the cache. This is all good and works fine. However, the same issue exists in ADO.NET. What is the correct method of refreshing the cache in ADO.NET, as an ADODB.Connection does not exist to pass to the JRO ActiveX DLL? Not to mention that I would like a managed method to handle this instead of using COM Interop. Thanks -- David Williams Tag: Quirky DataGrid behavior Tag: 101810
  - 5
    - Several Questions on ADO.NET Hi,there I get some problems when I am struggling in ADO.NET programming. I should really preciate your kindly advice. 1.How could I perform a data paging on master-detail datasets,especially the detail one? As I thought, I retrieve the master data and detail data seperately and then associate them through dataRelation. So it seems that I can paging the master data readily but how about the detail data? 2.Suppose I use DataSet only in my asp.net application. How could I re-position to the row after I insert a new row into the dataset? 3.I am editing a datarow. When I modify the value in a column, I hope value in another column should change correspondingly ASAP. For instance, the "Cost" column should change with "Price" column and "Quantity" column correspondingly. In what event should I place the code? Thanks. Tag: Quirky DataGrid behavior Tag: 101797
  - 6
    - Using ADO.NET DataSet in Unmanaged C++ COM Code Hello, I am accessing the database using ADO.NET/Managed C++. I would like to use the returned data in form of cursors in Unmanaged C++ (standard C++ with COM). Through COM Callable Wrappers & Interop the Stored Procs will be called. The in-out data volume handled through this module will be large, so the high performance is required. Is there any standard way to write marshaling to use ADO.NET DataSets in COM/C++ world? How to leverage XML? Thanks. -AJ Tag: Quirky DataGrid behavior Tag: 101786
  - 7
    - where can I download the ADO.Net object? Dear All, I am newbies in .Net. I would like to ask do i need to download the ADO.Net objects for the database connection? just like need to download the ODBC driver for Java? If yes, where can I find the ADO.Net object? Thank you very much. Victor Tag: Quirky DataGrid behavior Tag: 101785
  - 8
    - Left join, cross-joined view, running forever Hi All, I am using VB.Net on a Pervasive.SQL database. I am trying to retrieve all Customers and Items, and only the related Sales for these Customers/Items. Because there isn't a link between the customer and items, I've created a cross joined view of the customers and items, which returns all the customers and items. I'm trying to left join specific customer and items to Sales for a specific period; however this query is taking forever to return my recordset. Any ideas, for a simpler and/or more efficient solution. Regards, Viren Tag: Quirky DataGrid behavior Tag: 101784
  - 9
    - Problem with running a SP that has input & a output parameter Hi folks I have a SQL Server SP that is eventually called from a command button on a form. The SP has one input parameter and one output parameter. The problem is that when I call the SP from the command button click event and assign it to a variable, it returns the value "Nothing". The SP code is as follows ====================================== CREATE PROCEDURE [DBO].[sp_GetStoredPwd] @UserName varchar(15), @Result char(10) OUTPUT AS DECLARE @StoredPwd char(10) PRINT 'Msg from DB - @UserName = ' + @UserName SET @Result = (SELECT chPWD FROM Clients WHERE vchClientUserName = @UserName) PRINT 'Msg from DB - @UserName = ' + @UserName + ' - @Result = ' + @Result RETURN GO ============================================ The code for the command button click event is as follows: =========================================== Private Sub btnCommit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCommit.Click Dim strInfo As String Dim cn As SqlConnection Dim cmd As SqlCommand Dim chrPwd As Char If Len(txtUserName.Text) = 0 Or Len(txtPassword.Text) = 0 Then MessageBox.Show("Please enter both a UserName AND Password", "Missing Required Info", MessageBoxButtons.OKCancel, MessageBoxIcon.Error) Exit Sub End If Try strInfo = "server=USER-LMZWW8DZJO\DSK_TOP_ENG;Trusted_Connection=true;database=Int_Expl_Proj" cn = New SqlConnection cn.ConnectionString = strInfo cn.Open() cmd = New SqlCommand With cmd .CommandType = CommandType.StoredProcedure .CommandText = "sp_GetStoredPwd" .Connection = cn End With Dim pmTemp As SqlParameter pmTemp = cmd.Parameters.Add(New SqlParameter("@UserName", SqlDbType.VarChar, 15)) pmTemp.Direction = ParameterDirection.Input pmTemp.Value = txtUserName.Text pmTemp = cmd.Parameters.Add(New SqlParameter("@Result", SqlDbType.Char, 10)) pmTemp.Direction = ParameterDirection.Output chrPwd = cmd.ExecuteScalar If chrPwd = txtPassword.Text Then Process.Start("IEXPLORE.EXE") 'Me.Visible = False Else MessageBox.Show("Incorrect UserName or Password") End If Catch InvalidOpEx As InvalidOperationException If cn.State = ConnectionState.Open Then cn.Close() End If Catch SQLEx As SqlException Dim errorMessages As String Dim i As Integer For i = 0 To SQLEx.Errors.Count - 1 errorMessages += "Index #" & i.ToString() & ControlChars.NewLine _ & "Message: " & SQLEx.Errors(i).Message & ControlChars.NewLine _ & "LineNumber: " & SQLEx.Errors(i).LineNumber & ControlChars.NewLine _ & "Source: " & SQLEx.Errors(i).Source & ControlChars.NewLine _ & "Procedure: " & SQLEx.Errors(i).Procedure & ControlChars.NewLine Next i Dim log As System.Diagnostics.EventLog = New System.Diagnostics.EventLog log.Source = "Int Expl" log.WriteEntry(errorMessages) Debug.Write(errorMessages) Console.WriteLine("An exception occurred. Please contact your system administrator.") Finally If cn.State = ConnectionState.Open Then cn.Close() End If End Try End Sub =========================================== I hope somebody can help Kind regards Ross Petersen Tag: Quirky DataGrid behavior Tag: 101776
  - 10
    - ObjectSpaces, object persistence I'm looking for a good persistence framework to use with a new project. Gentle.NET looks promising but doesn't support SQL Server stored procedures as far as I can tell. Any tips on that? Is ObjectSpaces still scheduled to be released with Whidbey or has it been pushed off? Thanks, amit Tag: Quirky DataGrid behavior Tag: 101764
  - 11
    - Metadata about Foreign Keys ADO.NET 2.0 Hi, I can use "...Connection.GetSchema("ForeignKeys")" to get the name of an foreign key defined for a table. But how to get related/additional infos like the referenced table(name) and the corresponding fields ? Thx Robert Holler Tag: Quirky DataGrid behavior Tag: 101763
  - 12
    - Help with DataRelationCollection indexer In the code below, when I use the integer indexer I get the correct output. DataRelation myRelation = ds.Tables["TestDocument"].ChildRelations[0]; Output: No.1TestItems No.2TestItems But when I use the string indexer the output is nil. DataRelation myRelation = ds.Tables["TestDocument"].ChildRelations["RelationDocumentItems"]; Output: Will someone help me understand what I'm doing wrong? Thanks, Jeff Higgins using System; using System.Data; using System.Xml; using System.Text; using System.Windows.Forms; namespace xmltest { class Class1 { [STAThread] static void Main(string[] args) { StringBuilder s = new StringBuilder(); DataSet ds = new DataSet(); ds.ReadXml("test.xml", XmlReadMode.Auto); DataRelation myRelation = ds.Tables["TestDocument"].ChildRelations["RelationDocumentItems"]; DataTable myTable = ds.Tables["TestDocument"]; DataRow[] arrRows; foreach(DataRow myRow in myTable.Rows) { arrRows = myRow.GetChildRows(myRelation, DataRowVersion.Current); for(int i = 0; i < arrRows.Length; i++) { s.Append(arrRows[i]["name"] + "\n"); } } MessageBox.Show(s.ToString(), "Menu Data", MessageBoxButtons.OK); } } } <?xml version="1.0" encoding="utf-8"?> <TestDocument xmlns="http://tempuri.org/test.xsd" me="{E292E134-BEC8-49f7-A1E8-C3580C76C5B8}" name="TestDocument"> <TestItems me="{3738B467-C142-4ece-88B6-666327FA37B0}" owner="{E292E134-BEC8-49f7-A1E8-C3580C76C5B8}" name="No.1TestItems"> <TestItem me="{72C372F3-4E96-4a82-892B-B441E42D77B6}" owner="{3738B467-C142-4ece-88B6-666327FA37B0}" name="No.1FirstTestItem" /> <TestItem me="{BEB920DF-C2BA-46cf-8E59-EB060E2715DD}" owner="{3738B467-C142-4ece-88B6-666327FA37B0}" name="No.1SecondTestItem" /> <TestItem me="{3776230C-0669-4be4-BBFB-1D50789320D4}" owner="{3738B467-C142-4ece-88B6-666327FA37B0}" name="No.1ThirdTestItem" /> </TestItems> <TestItems me="{560223A6-0938-4a3b-89CD-9507F1F26682}" owner="{E292E134-BEC8-49f7-A1E8-C3580C76C5B8}" name="No.2TestItems"> <TestItem me="{2AA34205-3695-4f2c-9DF0-C3D0EA9E1AF2}" owner="{560223A6-0938-4a3b-89CD-9507F1F26682}" name="No.2FirstTestItem" /> <TestItem me="{3EC22224-B0BE-4364-A631-F455AD2E6F61}" owner="{560223A6-0938-4a3b-89CD-9507F1F26682}" name="No.2SecondTestItem" /> <TestItem me="{8FC33219-4104-458e-A08A-8A5DB549DD50}" owner="{560223A6-0938-4a3b-89CD-9507F1F26682}" name="No.2ThirdTestItem" /> </TestItems> </TestDocument> <?xml version="1.0" ?> <xs:schema id="NewDataSet" targetNamespace="http://tempuri.org/test.xsd" xmlns:mstns="http://tempuri.org/test.xsd" xmlns="http://tempuri.org/test.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified"> <xs:element name="TestDocument"> <xs:complexType> <xs:sequence> <xs:element name="TestItems" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:sequence> <xs:element name="TestItem" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:attribute name="me" form="unqualified" type="xs:string" /> <xs:attribute name="owner" form="unqualified" type="xs:string" /> <xs:attribute name="name" form="unqualified" type="xs:string" /> </xs:complexType> </xs:element> </xs:sequence> <xs:attribute name="me" form="unqualified" type="xs:string" /> <xs:attribute name="owner" form="unqualified" type="xs:string" /> <xs:attribute name="name" form="unqualified" type="xs:string" /> </xs:complexType> </xs:element> </xs:sequence> <xs:attribute name="me" form="unqualified" type="xs:string" /> <xs:attribute name="name" form="unqualified" type="xs:string" /> </xs:complexType> <xs:key name="KeyPrimaryTestDocument" msdata:PrimaryKey="true"> <xs:selector xpath="." /> <xs:field xpath="@me" /> </xs:key> <xs:key name="KeyPrimaryTestItems" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:TestItems" /> <xs:field xpath="@me" /> </xs:key> <xs:key name="KeyPrimaryTestItem" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:TestItem" /> <xs:field xpath="@me" /> </xs:key> <xs:keyref name="RelationDocumentItems" refer="mstns:KeyPrimaryTestDocument"> <xs:selector xpath=".//mstns:TestItems" /> <xs:field xpath="@owner" /> </xs:keyref> <xs:keyref name="RelationItemsItem" refer="mstns:KeyPrimaryTestItems"> <xs:selector xpath=".//mstns:TestItem" /> <xs:field xpath="@owner" /> </xs:keyref> </xs:element> <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:EnforceConstraints="False"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element ref="TestDocument" /> </xs:choice> </xs:complexType> </xs:element> </xs:schema> Tag: Quirky DataGrid behavior Tag: 101762
  - 13
    - Disable Datagrid scrolling with mouse wheel Hi, In my datagrid I add the control (numeric updown) in very streightforward way: I add this control to the datagrid controls collection and when I click the particular cell the numeric control apper instead of cell (at the place of cell, to be exact) The problem is: when I scroll the mouse wheel the datagrid is scrolling TOGETHER with my cell with numeric updown. The mouse wheel movement affects also the numeric up down, but as far as the whole datagrid is also scrolling I "lose" the cell as it goes away of visibility. The question is: How can I restrict the datagrid scrolling when I move mouse wheel and make the wheel scrolling affect only the numeric up down. Thanks beforehand, hope that I explained clear enough the problem and my question. -- Message posted via http://www.dotnetmonster.com Tag: Quirky DataGrid behavior Tag: 101760
  - 14
    - DataRelation with 3 tables Hi, I'm trying to setup two DataRelations for the 3 tables in my application. The first table is the master, the 2nd relates to the master based on the selected record and the third relates to the second based on the selected record. The problem I'm having is the third table filters based on the selected record of the main table and not the child dataset. Does anyone know how to implement a master/detail with 3 levels with DataRelation objects or suggest a better way to do it. Below is the code I'm using. Thanks for your help. Public Sub LoadDataset() Dim SqlServer As New SqlServer Dim TableName() As String = {"JobSummary"} Dim DBConnectionString As String = System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString") TableName(0) = "Job" SqlServer.FillDataset(DBConnectionString, "GetJobsNotCompleted", FDataset, TableName, FMachineName) TableName(0) = "WorkOrder" SqlServer.FillDataset(DBConnectionString, CommandType.Text, _ "SELECT * from fl_Work_Order_Summary " & _ "WHERE MachineID = " & FMachineName, FDataset, TableName) TableName(0) = "Item" SqlServer.FillDataset(DBConnectionString, CommandType.Text, _ "Select * from fl_Item_Summary " & _ "WHERE MachineID = " & FMachineName, FDataset, TableName) FDataset.Relations.Add("JobWorkOrders", FDataset.Tables("Job").Columns("JobID"), FDataset.Tables("WorkOrder").Columns("JobID"), False) FDataset.Relations.Add("WorkOrderItems", FDataset.Tables("WorkOrder").Columns("OrderID"), FDataset.Tables("Item").Columns("OrderID"), False) End Sub Private Sub MainForm_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load LoadDataset() DataGrid1.DataSource = FDataset DataGrid1.DataMember = "Job" DataGrid2.DataSource = FDataset DataGrid2.DataMember = "Job.JobWorkOrders" DataGrid3.DataSource = FDataset DataGrid3.DataMember = "WorkOrder.WorkOrderItems" End Sub Tag: Quirky DataGrid behavior Tag: 101758
  - 15
    - binding a dropdown list in web app guys, i'm binding the results of a sql query to a drop down list in a web app in the usual way. dropdownlist.datasource= ds.tables(0) dropdownlist.datatextfield ="org1" dropdownlist.databind() now what if i wanted to concatenate other fields and combine them. specifially org1,org2,org3 & org4 together normally in sql this is easy. just select org1||org2||org3||org4 from org_security; and the result would be a long string. and works fine in toad or sql+ but if i want to bind that whole string to the dropdown list, just like i did with the single value, how would i do that? i've tried playing with the datatextfield property all sorts of ways, and nothing seems to work. any ideas would be appreciated. thanks again. ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: Quirky DataGrid behavior Tag: 101749
  - 16
    - Table relations across datasets Hi all, May be this is an illogical question. But I will try anyway. Is there a way to create a relationship between two tables across datasets without violating the constraints? in other words, the primary table (with a foreign key) is in dataset1 and it's lookup table is in dataset2. I will explain why I need this setup. I have a Web application. I want to store all the lookup tables at the Application level and the business logic dataset at the Session level. The Session level dataset tables have foreign keys that need to map to these lookup tables. I don't want to populate these lookup tables at session level since it could choke the system resources if the number of sessions are huge. Any idea anybody? Babu. Tag: Quirky DataGrid behavior Tag: 101746
  - 17
    - Is Whidbey the beginning of the end for the developer ? Hi Everyone I have just been getting up to speed on the forthcoming ASP.Net 2.0 (Whidbey) that Microsoft is releasing some time this year. It all looks great but I was a bit concerned that it aims to reduce the amount of code that needs to be written by the developer by 70%. The new GridView control will be "far simpler to use, requires less code, and provides far more power than the DataGrid Control". After working extremely hard to get my Computer Science degree and investing my own hard earnt money heavily in MSDN subscriptions and programming books etc just to keep my skills up to date, I began to wonder if it had all been worthwhile now that the forthcoming ASP.Net 2.0 (Whidbey) seems to be abstracting much of the techniques that I had learnt to "hand code". For instance, I was particularly pleased with my implementation of Roles Based Forms Authentication that I had mastered in C# but now I understand that it will all be wasted now that this functionality will be covered by the new Membership classes. I fully understand that by definition, IT is a constantly evolving industry but it does make me worry that the very systems that we use to improve business efficiency could one day make the role of the qualified developer redundant. The way things are going, the office junior will be able to do all the stuff that the highly qualified and trained developer once did and the developers will be ignored because the higher wages that they rightly attract will no longer be justified. Maybe this is what Microsoft are working towards or maybe I'm just a Luddite. Please accept my appologies for the cross-posting but it's just something that I feel very stongly about and is of equal importance to each group. Tag: Quirky DataGrid behavior Tag: 101736
  - 18
    - Cann't get my only record with OracleDatareader object I a newbie to VB.net (only about 3 three weeks). I wrote a small module to upload file to server and send out a e-mail with the upload files. the codes basics as: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim num As Integer cart_id = Request.QueryString("cart_id") num = Request.QueryString("num") .. End Sub Sub SubmitButton_Click(ByVal Source As Object, ByVal e As EventArgs) Dim filepath As String = "D:\Emallupload" ' "D:\Emallupload" Dim uploadedFiles As HttpFileCollection = Request.Files Dim strFilenamesCollection As String = "" Dim i As Integer = 0 Dim arrPostedFile As New ArrayList Dim fullFileName As String Do Until i = uploadedFiles.Count Dim userPostedFile As HttpPostedFile = uploadedFiles(i) Try If (userPostedFile.ContentLength > 0) Then userPostedFile.SaveAs(filepath & "\" & cart_id & "~" & _ Path.GetFileName(userPostedFile.FileName)) strFilenamesCollection = strFilenamesCollection + cart_id + "~" + Path.GetFileName(userPostedFile.FileName) + ";" fullFileName = cart_id & "~" & Path.GetFileName(userPostedFile.FileName) arrPostedFile.Add(fullFileName) End If Catch ex As Exception Span1.InnerHtml += "Error:<br>" & ex.Message End Try i += 1 Loop Span1.InnerHtml += strFilenamesCollection & " Has been saved.<p>" StorePostedFile(cart_id, strFilenamesCollection, arrPostedFile) End Sub Private Sub StorePostedFile(ByRef cart_id As String, ByRef strFilenamesCollection As String, ByRef af As ArrayList) OracleConnection(ConfigurationSettings.AppSettings("strCon")) Dim sTrans As OracleTransaction oCon.Open() sTrans = oCon.BeginTransaction() Dim oCmd As New OracleCommand("set_order_attachments", oCon, sTrans) oCmd.CommandType = CommandType.StoredProcedure oCmd.Parameters.Add("p_cart_id", OracleType.VarChar, 15).Value = cart_id oCmd.Parameters.Add("p_attachment", OracleType.VarChar, 255).Value = strFilenamesCollection Try oCmd.ExecuteNonQuery() sTrans.Commit() EmailPostedFile(cart_id, af, oCon) Catch e As Exception ... Finally .... End Try End Sub Private Sub EmailPostedFile(ByRef cart_id As String, ByRef fn As ArrayList, ByRef oCon As OracleConnection) Dim .. Dim sTrans As OracleTransaction sTrans = oCon.BeginTransaction() Dim eCmd As New OracleCommand("get_vendor_email_info", oCon, sTrans) eCmd.CommandType = CommandType.StoredProcedure eCmd.Parameters.Add("p_cart_id", OracleType.VarChar, 15).Value = cart_id eCmd.Parameters.Add("o_FirstName", OracleType.VarChar, 40).Direction = ParameterDirection.Output eCmd.Parameters.Add("o_LastName", OracleType.VarChar, 40).Direction = ParameterDirection.Output Try eCmd.ExecuteReader() Dim myReader As OracleDataReader = eCmd.ExecuteReader() If myReader.Read Then FirstName = myReader.GetString(0) LastName = myReader.GetString(1) Else ... End If Catch e As Exception .... Finally .. End Try If noEmail Then .. rest of email codes End If End Sub Although the first Sub work (an Insert), I had dificult to run the second Sub, which selected one row back. When I used the OracleDataReader object, the myReader.read was always false even I have tested outside that there was definetely had a record return. Since the myreader.read is a standard way of syntax. I could not figure out what went wrong or missing. Can anyone help me out ? Thanks. C Chang Tag: Quirky DataGrid behavior Tag: 101732
  - 19
    - I want help with the jet 4.0 provider.. I try to make a connection with an access database using jet 4.0 OLE DB provider and i receive the following messages: "Test connection failed because of an error in initializing provider.catastrophic failure" and/or "An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll Additional information: No error information available: REGDB_E_CLASSNOTREG(0x80040154)." I have made the following steps until now -I updated my jet 4.0 db engine with the last version (4.00.8618.0) -I re-installed visual studio.net....and nothing change!! I use windows xp and office 2003. Can anyone Help me with this problem? Tag: Quirky DataGrid behavior Tag: 101726
  - 20
    - ADO and ADO.net in the same transaction Our old COM data access components use ADO. As we are now begining to move to C#.net, we would like any new data access components to use ADO.net. Therefore we will end up having two seperate connections: One ADO connection and one ADO.net connecation. Is there any way of making it so that updates made through either of these connections will be part of the same transaction? We use Oracle but do not currently have any preference as to which ADO.net data provider we use. Thanks, Jonathan Tag: Quirky DataGrid behavior Tag: 101719
  - 21
    - REGDB_E_CLASSNOTREG(0x80040154) -> What else to do? Hi, It seems I ran out of clues. This is the situation: Win98se client with Windows.Net Application (framework 1.1, MDAC2.8, Jet 4.0 Service Pack for Win 98) and the following connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\archive\db\app.MDB;User Id=admin;Password=;" When I try to open the connection: Dim conn As New OleDbConnection(ConnectionString) conn.Open() the error message in the subject is shown... Who can help me out on this?! Thank you in advance & Happe NewYear! Tag: Quirky DataGrid behavior Tag: 101716
  - 22
    - error in executing SELECT statement I get this message when executing SELECT statement in SQL 2000: Location: recbase.cpp:1374 Expression: m_nVars>0 S PID: 51 Process ID: 2480 Why? Any help? Tag: Quirky DataGrid behavior Tag: 101715
  - 23
    - DataAdapter call ExecuteReader instead of ExecuteNonQuery I'm working on my own implementation of an ADO.NET Data Provider derived from IDbXXXX classes and MSDN sample (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconImplementingNETDataProvider.asp). All is fine when I execute simple Command and DataReader but I got an error with DataAdapter. Running of SelectCmd and InsertCmd work fine but each UpdateCmd or DeleteCmd thrown a DBConcurrencyException. It seems that problem is that DataAdapter call ExecuteReader instead of ExecuteNonQuery on InsertCmd, UpdateCmd and DeleteCmd. So, number of row affected is probably incorrect. Do I miss something or is it an usual way of working for a DataAdapter ? Why ExecuteReader is called for an Update and a Delete without any result expected ? Thanks in advance for your help or advices. Lionel. Tag: Quirky DataGrid behavior Tag: 101712
  - 24
    - Add Connection to ADO Database Hi, Im trying to create a connection to A database in Visual Studio.Net. I select Tools->Connect to Database. Nothing happens. Im trying to connect a data source to my datagrid, but not even able to connect to the database I want to. Any suggestions will be appreciated. Thanks. Tag: Quirky DataGrid behavior Tag: 101707
  - 25
    - Returning error from stored proc This is probably a stupid question but its been so long since I've had to do it with ADO, I can't decide which way to do this in ADO.Net. I have basic stored procedures (SQL 2000/MSDE) that do inserts, updates and deletes. I call these from an SQLDataAdapter Update/Insert/Delete -> Update command. So, I can put a try/catch around the adapter Update call, but should I just be trying to catch a Sqlexception? How should I throw the error within the stored proc? For example, I can do: DELETE FROM tblMine WHERE myID = @iID IF @@ERROR <> 0 BEGIN ROLLBACK TRAN A RETURN ? END Should I return a value? I suppose a basic sample might be all I need. Thanks. STom Tag: Quirky DataGrid behavior Tag: 101706

Hey you guys, How's it going?

I have a Parent/Child/GrandChild relationship, and I have all my controls,
including three DataGrids, bound to the database using the BindingMangerBase
object (I've also tried the CurrencyManager with the same results). Also,
each BindingManagerBase object is associated to its own PositionChanged
event. When any or all of the DataGrids are visible, their respective
PositionChanged event "fires" no problem. However, whenever any of them are
hidden the PositionChanged event quits working. For instance, when I hide
the DataGrid that's bound to the parent table its PositionChanged event
stops firing. This is also true if I hide the DataGrid that's bound to the
child table also. Other than this quirk everything works fine.

Very baffled

Top