RowFilter Expressions with multiple relationships

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
    - Statement separator for Oracle client provider Hi, I have a large portion of an application (actually some sort of middleware) that has been developed first for SqlServer and now I am in the process of making it accessible to Oracle as well. The problem is that I use DataSets where, for instance, the UpdateCommand contains an UPDATE sql statement followed by a semicolon and a SELECT sql statement, all of this in the same CommandText. In this way, and in one single round-trip to the server, I can modify and obtain a fresh copy of the record. With Oracle provider, this is not working at all since Oracle dislikes the ';' and throws an exception (invalid character...). I have tried this in ORACLE SQL Plus Worksheet and works fine if one places a newline after the ';', but my hopes were seriously affected when I tried it in ORACLE SQL Plus, where it does not accept the semicolon regardless of a following newline. Can somebody shed some light on this, please!! -- Thanks in advance, Juan Dent, M.Sc. Tag: RowFilter Expressions with multiple relationships Tag: 111113
  - 2
    - ado and ado.net dissimilarities Salam, this is faisal and i want to know about vb.net Actually, i am a programmer of Visual Basic and used to work with ado in order to have connectivity with database, now i want to move on .Net api but the problem is that, i can understand the tools provided by the .net but unable to work with ado.net. Can any Please tell me all about this. ------------------------------- From: faisal khanzada ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>mTbt6M6UTEadruoUV2jBXw==</Id> Tag: RowFilter Expressions with multiple relationships Tag: 111102
  - 3
    - Adding a Row With an AutoIncrement Field I am trying to add a row to a table in a dataset. The table contains an ID field, which is set up as an AutoIncrement field, with AutoIncrementSeed = 1 and AutoIncrementStep = 1. I like the convenience of the following syntax: MyDataset.Tables("MyTable").Rows.Add(New Object(){"data for field1", "data for field2", "data for field3"...}) but because the first field is an AutoIncrement field, I'm not sure what to put in place of the first field. I tried vbNull, but that doesn't help. It complains on the second add that the ID already exists. How do I deal with the AutoIncrement field in an add such as the one above? Thanks. Tag: RowFilter Expressions with multiple relationships Tag: 111101
  - 4
    - Help! Typed Dataset across multiple databases (e.g. IDBDataAdapte Is there a way the strongly typed dataset wizard will create classes that are usable across multiple databases? We are writing an application that can use Oracle, PostgreSQL, or Sql Server as the database. We have setup a DAL (using IDBConnection, IDBDataAdapter, etc.) to facilitate database portability. We can now use the DAL for all our database functions, which is great. However, we can't figure out how we to utilize the auto-generated strongly typed dataset classes across multiple databases. Is it possible? Our app has 1000's of columns, so this would be a MASSIVE time saver vs. creating all the classes by hand or hand-writing all the SQL. Thanks, Josh Tag: RowFilter Expressions with multiple relationships Tag: 111100
  - 5
    - How does Dataset.Relations work internally? Does ADO.NET internally sets up hashtables for the columns that are used to tie tables, so that later on hashtables can be used to quickly retrieve data? Or does it just loop through data to locate the ChildRows. For instance, in a line like this. ds.Relations.Add( new DataRelation(RELATION_BREAK_PRODUCT, tblBreak.Columns[FIELD_BREAK_ID], ds.Tables["Product"].Columns[FIELD_BREAK_ID])); Thanks. Tag: RowFilter Expressions with multiple relationships Tag: 111097
  - 6
    - Load a string of CSV from memory into a dataset Hi Group, Here is what I'm trying to do in my application: 1. the customer uploads an encrypted file to the server (it's a ASP.NET application) 2. the uploaded file is decrypted to a comma separated list of values 3. the list is being written to a CSV file 4. the csv file is being loaded into a datatable, using OleDbDataAdapter 5. the recordset, after some checking and validation, is being written to a SQL database. Question: Is it possible to skip somehow the steps where I'm writing the comma separated list to a csv file and then reloading the list into a datatable? Something like loading the datatable directly from the comma separated string **in memory** ? Many thanks ! Andrei. Tag: RowFilter Expressions with multiple relationships Tag: 111093
  - 7
    - Invalid Key node inside constraint error I have an XML document that I'm reading into a dataset. I programmatically created dataadapters and constraints for all the tables and relationships and I'm able to insert all the data into the database no problem. Instead of running the code to create the constraints all the time, I used WriteXMLSchema to write out an .xsd for me that has everything already defined. Now when I read this schema back using ReadXMLSchema, I get the error: Invalid 'Key' node inside constraint named: Arrests-Inv_Holding_Facilities .NET created this .xsd for me, why can't it read it in? I've made no changes to it manually. I've seen several messages with this same question out on the web, but no answers. Can anyone tell me what the problem is? Tag: RowFilter Expressions with multiple relationships Tag: 111090
  - 8
    - Oracle Driver Behavior I am running the Oracle 9.02 driver in development, which is working fine with the following statement. #region Add Inbound Transaction // for valid requests, insert transaction into table: INBOUNDTRANSACTIONS // returns boolean indicating success public bool addInboundTransaction(string structureID, string msgIn, string status, string lastUpdatedBy, string originatingID, string hostSystem) { OleDbConnection cn = new OleDbConnection(DataSource); string sql = "INSERT INTO TABLENAME (TABLEROWID, STRUCTUREID, STATUS, LASTUPDATEDBY, MSGIN, ORIGINATINGID, HOSTSYSTEM) VALUES (IBTXN_SEQ.NEXTVAL, :1,:2,:3,:4,:5,:6)"; OleDbCommand cmd = new OleDbCommand(); cmd.CommandTimeout = CommandTimeOut; cmd.CommandText = sql; cmd.Connection = cn; cmd.CommandType = CommandType.Text; OleDbParameter p1 = cmd.Parameters.Add("strucID", OleDbType.VarChar,50); p1.Direction = ParameterDirection.Input; p1.Value = structureID.Trim(); OleDbParameter p2 = cmd.Parameters.Add("status", OleDbType.VarChar,50); p2.Direction = ParameterDirection.Input; p2.Value = status.ToUpper().Trim(); OleDbParameter p3 = cmd.Parameters.Add("lastUpdatedBy", OleDbType.VarChar,50); p3.Direction = ParameterDirection.Input; p3.Value = lastUpdatedBy.ToUpper().Trim(); byte[] ba = stringToByteArray(msgIn); OleDbParameter p4 = cmd.Parameters.Add("blobData", OleDbType.Binary, ba.Length); p4.Direction = ParameterDirection.Input; p4.Value = ba; // the ip/dns address of the system making the request (like http_referrer) OleDbParameter p5 = cmd.Parameters.Add("originatingID", OleDbType.VarChar,50); p5.Direction = ParameterDirection.Input; p5.Value = originatingID.ToUpper().Trim(); // the name of the host system (http, websvcs) OleDbParameter p6 = cmd.Parameters.Add("hostSystem", OleDbType.VarChar,50); p6.Direction = ParameterDirection.Input; p6.Value = hostSystem.ToUpper().Trim(); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); return true; } #endregion But, when trying to run this same code from test system, which is running Oracle driver 8.01.07, I am receiving this error: "ORA-01036: illegal variable name/number" Is there something I can do to fix my SQL so it runs properly using the 8.01 driver? Or is it possible to install the 9.02 driver on test without disrupting the current apps that are using 8.01? - not a highly supported solution by other developers on my team. Or can I run these drivers side by side on the same machine? Ideally, I can identify what is causing this code to fail using the 8.01 driver and just redo the SQL. Thanks for the assistance! Tag: RowFilter Expressions with multiple relationships Tag: 111086
  - 9
    - ADO.NET System.Data.SqlClient I'm developing web applications using Visual Studio.NET 2003 Version 7.1.3088 on two laptop configurations. One is Windows 2000 Professional, other is Windows XP SP2. Microsoft.NET Framework 1.1 Version 1.1.4322 SP1 (on XP Laptop), Microsoft.NET Framework 1.1 Version 1.1.4322 (on 2K Laptop). I have SQL Server 2000 - Version 8.00.0384 - SP4 installed on standalong machine. I've used VB.NET 2003 for over 1.5 yrs - no problems on 2K platform. I have web application connecting flawlessly to SQL server using SqlClient namespace. I have "headaches" while migrating same web application on XP platform. Continually getting message "System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding". Basically SQL Server 2000 - is fully operation for all apps, includes web app on 2000 Professional development machine. Just can't get SQL connects to database on XP Sp2 platform. I feel differences in OS are causes - different DLL's, possible issue with MDAC - TDS stream issue. I've submitted 3 postings to other newsgroups. Other disagree with MDAC issue & OS issue. I guess my questions are then - What is causing this to NOT work on SP2 of XP platform - same code - etc... Just 98% of time WON'T connect - once in blue-moon connection passes with XP Sp2. Again, no problems with 2000 OS platform. Please advise! Tag: RowFilter Expressions with multiple relationships Tag: 111083
  - 10
    - Accessing deleted and changed rows in a DataSet I'm writing a client to connect to a legacy system (pre-.NET) which only accepts input and provides output using ADO Recordsets. I've been able to convert Recordset to DataSet, and if the DataSet has no changes I can convert back to Recordset. The problem comes when converting DataSet to Recordset when rows have been deleted or updated. The only way I could find to do the conversion involves "hand-crafting" the XML for the ADO Recordset combined with running an XSLT transform on the DataSet data. What I can't do is access the original rows in the DataSet in order to write <rs:update>, <rs:original>, and <rs:delete> elements and their child rows in the <rs:data> section. This data must be in there somewhere, otherwise how could a DataSet update a database directly? Does anyone know how I can get to it? Alternatively, if I'm missing an obvious way of making this easier, please can someone enlighten me ;-) Thanks Ian Tag: RowFilter Expressions with multiple relationships Tag: 111082
  - 11
    - Can't insert in my table Hello, I have a stange error and I don't know where to look at. I do multiple insert in muliple table in my MDB databse. Everything work except from one table. when the code execute I get this error: Message "Syntax Error in the instruction INSERT INTO." StackTrace " at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at NTiersConstructeur.Data.DataProviderOleDb.Execute(String SQL) in C:\_DEV\NTiersConstructeur\Classe\DataProvider.vb:line 187" String When I execute the sql string in my mdb, It's work!!! Here is the sql string INSERT INTO [Valeur] (IDEntity, [Name], [Description], [Version], [TypeValue], [ReadWriteValue], [FieldNameValue]) VALUES (20, 'Valeur1', '', '', 'String', 'ReadWrite', '' ) Here is the code that execute all the insert, update and delete SQL string Private Function Execute(ByVal SQL As String) As Boolean Try Dim strConnectionString = System.Configuration.ConfigurationSettings.AppSettings("OLEConnectionString") Dim oConnection As New OleDbConnection oConnection.ConnectionString = strConnectionString oConnection.Open() Dim oCommand As OleDbCommand oCommand = New OleDbCommand(SQL, oConnection) oCommand.CommandType = CommandType.Text Dim oTransaction As OleDbTransaction oTransaction = oConnection.BeginTransaction oCommand.Transaction = oTransaction Dim intResult As Integer = 0 intResult = oCommand.ExecuteNonQuery Dim blnResult As Boolean = False If intResult >= 0 Then blnResult = True End If If blnResult Then oTransaction.Commit() Else oTransaction.Rollback() End If oConnection.Close() oConnection.Dispose() oCommand.Dispose() Return blnResult Catch ex As ArgumentException Catch ex As OleDbException MsgBox(ex.ToString) Catch ex As Exception MsgBox(ex.ToString) End Try End Function Can someone tell me what I am doing wrong? Is there an error in my sql string? Why do I have this error only with one table and not from the others? Tag: RowFilter Expressions with multiple relationships Tag: 111081
  - 12
    - Divide by Zero exception Hi there My .asp application draws data from a number of sources, converts the results to type.double and does various calculations with these figures. Because of data entry errors on the system from which some of the data is drawn (this system is unfortunately not under my control so I can not sort this problem out at source....) I occasionally get Divide by Zero Exceptions which crash my application. Does anyone have a clever (or otherwise) way of catching this particular error and inserting a value of 0 in to the result instead of crashing ? Any help would be appreciated Tag: RowFilter Expressions with multiple relationships Tag: 111076
  - 13
    - Problem with Data Refresh Hi there I have an .asp application that uses an accounting package for some of it's data. This links to a warehouse stock system. I am not running an ODBC link straight to the accounting system, but instead run a data refresh every 5 minutes that synchronises all the stock in the warehouse in to an SQL table - my .asp application links to this. I believe I am having issues with queries that are executed during this scheduled refresh of data - the application does not fail, but I am getting reports of inaccurate data resulting from queries at apparently random times of the day. Does anyone know if I am able to either lock the table during a refresh (and how my ado programming will recognise this status) so that I can catch the query and display a message along the lines of "Data refreshing, please wait" and then requery once the refresh has completed - any more practical suggestions would be musch appreciated. Thanks very much for your time Stuart Tag: RowFilter Expressions with multiple relationships Tag: 111075
  - 14
    - Issues with DataGrid sort I have been trying to follow some examples on http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconsortingdatainsqldatabase.asp http://www.dotnetjunkies.com/Tutorial/E169C6D4-D335-4D2B-AE3F-918EE3161815.dcik http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemWebUIWebControlsDataGridClassTopic.asp I found two issues 1) Sorting does not seem to work at all when AutoGenerateColumns is set to False 2) Data binding is not working When AutoGenerateColumn disabled, the header appears in plain text, with no links to sort on columns! Even when AutoGenerate is enabled (and I can't have that!) Any suggestions on how to resolve these? Code snippet as follows: /********* Start of ListForms.aspx***********************/ <asp:DataGrid id="FormListDataGrid" runat="server" AutoGenerateColumns="False" ShowHeader="true" HeaderStyle-CssClass="header" AllowSorting="true" OnSortCommand="SortCommand_OnClick"> <Columns> <asp:HyperLinkColumn Runat="server" DataNavigateUrlField="FormName" DataNavigateUrlFormatString="ShowForm.aspx?form={0}" DataTextField="FormName" HeaderText="Form Name"></asp:HyperLinkColumn> <asp:BoundColumn DataField="Due Date" HeaderText="Due Date" DataFormatString="{0:d}"/> <asp:BoundColumn DataField="Entity" HeaderText="Entity" /> </Columns> </asp:DataGrid> /********* End of ListForms.aspx***********************/ /*************Start of ListForms.aspx.cs*****************/ using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Data.Odbc; namespace BeanCounter { /// <summary> /// Summary description for ListForms. /// </summary> public class ListForms : System.Web.UI.Page { protected System.Web.UI.WebControls.DataGrid ArchivedDataGrid; protected System.Web.UI.WebControls.DataGrid FormListDataGrid; protected string currentFormSQL = "SELECT * from Forms where Active=1"; protected string actualCurrentFormSql; private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here DataSet dataList = new DataSet(); actualCurrentFormSql=currentFormSQL; OdbcConnection Conn = new OdbcConnection("Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\\db\\outstandingForms.mdb"); Conn.Open(); OdbcDataAdapter accessDataAdapter = new OdbcDataAdapter(currentFormSQL,Conn); accessDataAdapter.Fill(dataList); DataView oView= new DataView(dataList.Tables[0]); FormListDataGrid.DataSource= oView; FormListDataGrid.DataBind(); Conn.Close(); } #region Web Form Designer generated code override protected void OnInit(EventArgs e) { // // CODEGEN: This call is required by the ASP.NET Web Form Designer. // InitializeComponent(); base.OnInit(e); } /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.Load += new System.EventHandler(this.Page_Load); } protected void SortCommand_OnClick(Object source, DataGridSortCommandEventArgs e) { actualCurrentFormSql = currentFormSQL + " ORDER BY " + e.SortExpression; FormListDataGrid.DataBind(); } #endregion } } /*************End of ListForms.aspx.cs*****************/ Tag: RowFilter Expressions with multiple relationships Tag: 111070
  - 15
    - Merging XML Documents (with ADO.NET?) I have got 2 XML documents, both of which conform to the same XSD Schema, which define possible optional elements. The 2 XML documents contain 2 disjoint set of XML elements. What is the best, easiest, most efficient way of merging the 2 XML Documents? Can I use DataSet.Merge() facility in ADO.NET?? Any pre-requisites? Any other suggestions? Tag: RowFilter Expressions with multiple relationships Tag: 111067
  - 16
    - Error when committing the row to the original data store I am new to VB.NET so please bear with me. I have a small test application where the user can choose a table from a combo box, whereupon a DataGrid is populated with data from the chosen table. Here is the code in the combo box's SelectedIndexChanged event procedure. Private Sub cboTable_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboTable.SelectedIndexChanged If cboTable.Text <> "" Then Dim cmdLookupTableSelect As New SqlClient.SqlCommand With cmdLookupTableSelect .Connection = cnnConnection .CommandType = CommandType.StoredProcedure .CommandText = "admLookupTableSelect" .Parameters.Add("@tableName", SqlDbType.NVarChar, 50).Value = cboTable.Text End With mdaDataAdapter = New SqlClient.SqlDataAdapter mdaDataAdapter.SelectCommand = cmdLookupTableSelect mdsDataSet = New Data.DataSet mdaDataAdapter.FillSchema(mdsDataSet, SchemaType.Mapped, cboTable.Text) mdaDataAdapter.Fill(mdsDataSet, cboTable.Text) dbgDataGrid.DataSource = mdsDataSet dbgDataGrid.DataMember = cboTable.Text End If End Sub The idea is that the user will be able to add/update/delete data in the DataGrid and save the changes to the database. I am using a CommandBuilder to build the commands on the DataAdapter. Validation of the data added to the DataGrid is handled automatically; for instance, if I add too many characters to a column and move to the next row in the DataGrid, I get an error message with the title, 'Error when committing the row to the original data store', and the message gives details of the constraint. This is mostly what I want and I didn't have to write much code to achieve it, which is great. The trouble is that I want to make the MessageBox fit in with the rest of the application, which will have a rigorously consistent style for all GUI elements. So my question is, how can I trap this error message and package it in a way that is more in keeping with my application? The message appears on moving from an edited DataGrid row to another row. The exception thrown is of type System.ArgumentException. No matter what events I try to trap on the DataTable, I cannot get access to this exception. Any help would be greatly appreciated. Tag: RowFilter Expressions with multiple relationships Tag: 111063
  - 17
    - Type Casting to long When we retrieve data from a int field from a datatable and if I write lValue = (long)dtTable.Rows[0]["Fld1"] it generates an error at runtime. whereas it should be done because we are converting int to long which should be possible. but if I use Convert.ToInt64 it does give any error. What is reason for that? Regards, Lalit Bhatia Tag: RowFilter Expressions with multiple relationships Tag: 111062
  - 18
    - Oracle Client Components Is there a way to connect to oracle 9i database from c# WITHOUT installing the Oracle Client Components on my machine? Thanks Arlef Tag: RowFilter Expressions with multiple relationships Tag: 111059
  - 19
    - Updating joined tables Hi, I am trying to display data from two sqls tables in a datagrid, and then alow the user to make changes that update one of the tables. Currently I am bringing in two tables into a dataset, merging them and binding them to a datagrid. I then use a comand builder on one of the original sql tables in order to update it. It sort of works - I cant get tables to merge that have different numbers of records. Is there a better way to do this? Thanks, Tag: RowFilter Expressions with multiple relationships Tag: 111056
  - 20
    - How do I convert a base64 encoded bytearray? Hi! I have a webservice which queries a table in SQLServer. The table has a column, "Text", which is of datatype "image". When invoking the webmethod it returns dataset with the table included. The column is returned as a base64binary as can be seen in the declaration excerpt below: <xs:element name="text" type="xs:base64Binary" minOccurs="0" /> When I call the webservice and loops through the rows I see that the column "text" is represented as a bytearray as well. What I'd like to do is to convert this bytearray into an "ordinary" string. Please note that it must work in a .Net Compact Framework environment. I've tried a number of approaches but none has worked so I feel a little bit "lost in binary space". Hope you can help me! /Peter Tag: RowFilter Expressions with multiple relationships Tag: 111054
  - 21
    - how to update datagrid (Type your message here) i am trying to create tables in sql server programmatically in= vb=2Enet=2Ei can add fields and update them programmatically=2E i need= to know how i can update the table records when displayed in= datagrid=2Ei want to update the datagrid/records as it is done in= access=2Eneed to know how to get count of number of rows filled in= datagrid=2Eplzzz help!! -------------------------------- From: amritac20 chaudhuri ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>kSuuS0+4DU+lP+VwPUuFeA=3D=3D</Id> Tag: RowFilter Expressions with multiple relationships Tag: 111052
  - 22
    - Updating a column in a DataTable... Ok, I'm sure this one has been asked before, so I'll apologize upfront. What I'd like to do is take a DataTable and run an update statement against one of its columns. Say for instance, my DataTable has a ProductID column, which is an integer, and I'd like to update all values in that column to something like 33786. What's the best way to do it? Would a SQL-like statement work combined with a DataAdapter, or is it not that simple? Tag: RowFilter Expressions with multiple relationships Tag: 111039
  - 23
    - null or DbNull or what? Hello, I am trying to find the most efficient way to send record UPDATES from a client to my webservice. I am already using GetChanged to only send the records that have actually been modified, but I would like to further reduce network traffic by not sending individual columns that were not modified. My first attempt in doing this was to use SQL stored procs that have default values that would be values that would never actually be used for these fields. The update statement then evaluates each parameter to determine whether it should really update each column. This works great on the SQL Server side, and I've discovered that by leaving the Command Parameter value as null (not DbNull), the default values would be invoked. The problem here lies in determining if a value in my DataTable is DbNull because it was set to null or if it is DbNull because it was not changed. It seems that I cannot actually set fields in a datarow to be actual null (not DbNull). Is there something I am missing here? Moreover, is there something bigger that I am missing? Is there a better solution for minimizing the amount of XML being sent from my client to my webservice? I do realize that a possible solution would be to stop sending a DataSet and just use my own XML specification that allowed for more flexibility in minimizing packets being sent. But that solution seems to negate a great deal of Microsoft technology that we hoped to be leveraging. Thank you for any suggestions, Glenn Thimmes Tag: RowFilter Expressions with multiple relationships Tag: 111038
  - 24
    - Reading Data From Excel Via ADO.NET I have an application reading data from an Excel file and filling a SQL Server table. When I read the Excel file, I want to be able to trim trailing spaces off the data as it's read into the dataset. I'm connecting to the Excel file via an OleDbDataAdapter & OleDbCommand object. All the code compiles and runs fine - I just want to trim any trailing spaces off of the data. Here is a portion of the code I'm using: Dim oCmdSelect As New OleDbCommand(moImportFormat.SelectFromStatement, moConnExcel) 'Get the values in the Excel file and verify mDSExcel = New DataSet() Dim oDA As New OleDbDataAdapter() oDA.AcceptChangesDuringFill = False oDA.SelectCommand = oCmdSelect oDA.Fill(mDSExcel, sTableName) The SQL statement stored in moImportFormat.SelectFromStatement is: SELECT STORENAME FROM [Sheet1$] The trick, I believe, is to add a "trim" statement as in TRIM(STORENAME) or RTRIM(STORENAME). However when I tried TRIM & RTRIM, I receive an error message. When I take out the TRIM or RTRIM it works fine. So the $1 million dollar question is, is there a function that can "trim" data when being read in with an OleDbDataAdapter / OleDbCommand? Thanks, Kyle Tag: RowFilter Expressions with multiple relationships Tag: 111035
  - 25
    - good data-driven place to store default values? so i have a database schema, a .NET object library .dll, and an ASP classic web application. i'm wondering where in this setup i should place default values for fields/columns of forms/objects/rows. SQL Sever doesn't seem like a good candidate, because i'm using stored procedures for all inserts. these procs use input parameters for each of the values in case there IS a value other than default, but since the parameters are optional, they are defined with the = null. so these mechanisms basically completely circumvent the default values, because either a value is specified by the caller of the proc, and that value is stored, or the value is not specified by the caller, and a null is stored. either way, no default values from the table definition. The object library seems like a decent place, except that i would love for it to be data driven. i suppose each object could keep track of all of its own default variables. part of the constructor could be to go find its default-value definition file, and load them up that way. does anyone foresee any major architectural problems with this? And the last option is to put the default value definitions in the ASP code somehow, probably through a constants file, and value comparisons. Much less elegant than putting them in the object library, but pretty simple, too. Thoughts? comments? Suggestions? Thanks, Jason Tag: RowFilter Expressions with multiple relationships Tag: 111026
- Next
  - 1
    - how can I create a properties collection for a user control How can I create a properties collection for a user control? (or reference what's there if it already exist) I have a user control that displays an HTML table with several values. For each field's value I have a public property that is set from a repeater's itemdatabound event. In the ItemDataBound Sub, I use something like the following where the datasource column name is always the same as the form's property name: DisplayTable.FIELD1 = DataBinder.Eval(e.Item.DataItem, "FIELD1") I have to go through and set approx. 30 fields just like this but I'd like to do something that is completely independent of the number of columns returned plus I'd rather not have to name each property or field should one be deleted or added.... Something like: dim x as property for each x in MyUserControlInstance.PropertiesCollection MyUserControlInstance..x= DataBinder.Eval(e.Item.DataItem, x) next I've tried several different approaches but can't get it working . The compiler identifies the .x part after the control name as the source of the error. I can't recall right this second if the message was 'identifier expected' or 'expression expected' but I think it was one of these. Mike Tag: RowFilter Expressions with multiple relationships Tag: 111024
  - 2
    - Using DataReader to count rows Hello All: First let me thank everyone on the forum(s) for all the great (and timely) help!!! I am writing a help desk app in asp.net that allows people to input work orders for IT. I used to use data adapters and datasets until someone here helped me to realize the performance advantage of using data reader. It works great for displaying the info, but i would like to add the ability to pull the *number* of open and closed work orders for a particular user as such: SELECT * FROM workorders WHERE extension = ('extension') and STATUS = ('Open') SELECT * FROM workorders WHERE extension = ('extension') and STATUS = ('Closed') then i want the data reader to tell me how many rows were selected. I tried things similar to; ****************************************** While rdr.read() a = a + 1 End While labelOpenWorkOrders.text = a ****************************************** and I also tried ******************************************** while rdr.read() do a = a + 1 loop end while labelOpenWorkOrders.text = a ******************************************* It never returns the actual row count. i also tried labelOpenWorkOrders.text = rdr.recordsaffected -- but this is only for insert, update, delete. HELP!!!! Thanks Steve Tag: RowFilter Expressions with multiple relationships Tag: 111018
  - 3
    - Defaults in Column Mappings Dear All, I have designed a DataAdapter which reads data from a table. The table has an auto-incrementing Primary Key. None of the columns in the table accept Nulls although some of the columns do have defaults. My question is - Is there an automatic method of filling these properties on the table when I call the fill method, or do I have to manually key the properties for each column when the table has been filled? Thanks in advance for your assistance Mike Tag: RowFilter Expressions with multiple relationships Tag: 111008
  - 4
    - ConnectionState problem Hi, My application connects to an Access database when it is loaded, and keeps the same connection open all the time. There is logic in the code to ensure that the connection is automatically opened the first time it is used: if ((cmd.Connection.State == ConnectionState.Closed) || (cmd.Connection.State == ConnectionState.Broken)) cmd.Connection.Open(); However occasionally my application says this: System.InvalidOperationException: The connection is already Open (state=Connecting). or it might say the same but with state=Executing. But if the state is Executing, you can neither call .Open nor can you execute a query. So how can I maintain an open connection without these errors occuring? To be honest, I don't understand why it is ever in the "Exectuting" state, because it's a single threaded application and theres no way that it can be doing more than one thing at once. Thanks, Nick... Tag: RowFilter Expressions with multiple relationships Tag: 111006
  - 5
    - Updating typed dataset schema from code when a column is deleted I have an existing .xsd file with typed dataset information in it. I need the ability to update this existing schema information when a column is removed from one of the underlying data adapters. Currently I read the existing schema info into a temp dataset object, update the schema for the table in question by just calling MyAdapter.FillShema and passing it my temp dataset. I then write the schema file back to disk. This works great for column additions, the new columns are placed in the schema, but it does not change the schema if a column is deleted. I've been searching through the merge documentation, the MissingSchemaAction documentation, anything I can think of, but I'm at a loss. Any ideas or pointers in a new direction? TIA, J.D. Tag: RowFilter Expressions with multiple relationships Tag: 111004
  - 6
    - Group By Hi, I have a resultset with different columns which I would use to group the data by. For examle: Name Categ Year AAA 1 2003 BBB 1 2004 CCC 2 2003 DDD 2 2004 I want to have differnt views of this data like this: 1 - 2003 - AAA 2004 - BBB 2 - 2003 - CCC 2004 - DDD or 2003 - AAA CCC 2004 - BBB DDD I could solve this using multiple queries and differnt filters, but I wonder if there is a more elegant solution using ADO.Nets hierarchical features. And hints or ideas? regards, Achim Tag: RowFilter Expressions with multiple relationships Tag: 111003
  - 7
    - Change display value in a grid Hi, I'm using compact framework for pocket Pc and I should change the display values of a column in a grid, so I've a xml file where there is a field where are saved the follow value 1,2,3 but I don't want to transfrom it like: switch (myRow["FIELD"]) { case 1: DisplayValue = "First"; break; case 2:DisplayValue = "Second"; break; case 3:DisplayValue = "Third"; break; } so a run time I should see the description and not the value, How can I do this? Thanks Tag: RowFilter Expressions with multiple relationships Tag: 110998
  - 8
    - Tricky Ado.net Addition Hello I'm stuck on this one. I have a dataset which has many tables. amongst them I have 2 tables: tblJob & tblCompany In my form, I have a tab for jobs, which has a combo named "cmbCompany" which lists company name from the table Company. Now I have logic built into my application so that if the user enters a text which is not in the list, it asks the user if he wants to add it. Then it pops up another form, which populates all the information. The tblCompany has a CompanyID field which is autoincrement and set to -1 & -1. So the tblJob which has the foreign Key "CompanyID" gets "-1" saved in it. When I save the database. I get the proper ID before I merge the database, so I have to correct ID for the "tblCompany" however the foreign key in tblJob is not updated although I've set it to cascade.. I don't know if i've explained the issue properly, but if someone has an idea on this, please let me know. Thanks Tag: RowFilter Expressions with multiple relationships Tag: 110997
  - 9
    - SQL Server problem I have created a simple web application using ASP.NET, which queries an SQL-Server database, but every time the application is run, I get the following error: (truncated for brevity) Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. Relevant code is here: string strConnection = "Data Source=testdb;Initial Catalog=testdatabase;User Id=testuser;Password=testpassword;"; dbConn = new SqlConnection(strConnection); dbConn.Open(); strSQL = "SELECT Title, ISBN, Publisher " + "FROM BOOK " + "ORDER BY Title"; dbCmd = new SqlCommand(strSQL, dbConn); dbReader = dbCmd.ExecuteReader(); dgQuick.DataSource = dbReader; dgQuick.DataBind(); My setup is as follows: IIS 5 webserver running on Windows XP Database server is Microsoft SQL-Server 2000, running on Windows Server 2003 Enterprise (These two servers are in seperate Windows domains) The really odd thing is that I can connect just fine using the same connection information in Query Analyzer running on the same machine as the web server. What I'm thinking is that most likely the ASP.NET worker process running on the web server does not have the proper access rights for accessing the database server. I'm not especially knowledgeable about the security model on Windows 2003 server, so this is just a guess. Anyone got any suggestions? Tag: RowFilter Expressions with multiple relationships Tag: 110994
  - 10
    - TypedDataset I have a typed dataset as follows,which as you can see **Dose have a primary key**.In the application when I try to use the Find mentod on it it says that the table dosen't have the primary key,so I traced from the begining of object creation and I noticed when I instanciate an object from my typedataset (EntityReport m_EntityReport=new EntityReport();) ,there is not primary key definded there!!!! I used these two lines of code and the length of **test** is Zero!!! Why? DataColumn[] test=m_EntityReport.Parameters.PrimaryKey; Debug.WriteLine(test.Length.ToString()); Thanks a lot *****************My Typed Dataset Schema*************** <?xml version="1.0" encoding="utf-8" ?> <xs:schema id="EntityReport" targetNamespace="http://www.adventureworks.com/EntityReport.xsd" elementFormDefault="qualified" xmlns="http://www.adventureworks.com/EntityReport.xsd" xmlns:mstns="http://tempuri.org/EntityReport.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" xmlns:NS="http://www.adventureworks.com/EntityReport.xsd" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="Report"> <xs:complexType> <xs:sequence> <xs:element name="ID" type="xs:string" /> <xs:element name="Name" type="xs:string" /> <xs:element name="Description" type="xs:string" nillable="true" msprop:nullValue="_null" /> <xs:element name="Path" type="xs:string" /> <xs:element name="CreatedBy" type="xs:string" /> <xs:element name="CreatedDate" type="xs:date" /> <xs:element name="ExecutionTime" type="xs:dateTime" /> <xs:element name="CustomParams" type="xs:boolean" /> <xs:element name="SessionID" type="xs:string" nillable="true" msprop:nullValue="_null" /> <xs:element name="ExecutionOption" type="xs:short" nillable="true" /> <xs:element name="HistoryID" type="xs:string" nillable="true" msprop:nullValue="_null" /> <xs:element name="ExportFormat" type="xs:string" default="HTML4.0" /> <xs:element name="DeviceSettings" type="xs:string" nillable="true" /> <xs:element name="RemoteCall" type="xs:boolean" /> </xs:sequence> </xs:complexType> <xs:key name="IDKey" msdata:PrimaryKey="true"> <xs:selector xpath="." /> <xs:field xpath="NS:ID" /> </xs:key> </xs:element> <xs:element name="Parameters"> <xs:complexType> <xs:sequence> <xs:element name="Name" type="xs:string" /> <xs:element name="Value" type="xs:string" /> <xs:element name="ReportID" type="xs:string" /> </xs:sequence> </xs:complexType> <xs:key name="NameKey" msdata:PrimaryKey="true"> <xs:selector xpath="." /> <xs:field xpath="NS:Name" /> </xs:key> <xs:keyref name="ReportsParameters" refer="IDKey"> <xs:selector xpath="." /> <xs:field xpath="NS:ReportID" /> </xs:keyref> </xs:element> </xs:schema> Tag: RowFilter Expressions with multiple relationships Tag: 110980
  - 11
    - ColumnMappings don't seem to work! Hi, I am new to column mappings and can't seem to make them work. The following is an example: DataTable table = new DataTable( "SYSTEM.Usernames"); table.Columns.Add( "S1", typeof(decimal) ); OracleCommand cmd = new OracleCommand(); cmd.Connection = this.oracleConnection1; cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT SuperUserFlag FROM SYSTEM.Usernames WHERE Username = 'JuanDent'"; OracleDataAdapter da = new OracleDataAdapter( cmd ); DataSet ds = new DataSet( "Temp ds"); ds.Tables.Add( table ); DataTableMapping map = da.TableMappings.Add( "Table", table.TableName ); map.ColumnMappings.Add( "S1", "SuperUserFlag" ); ds.EnforceConstraints = false; da.MissingSchemaAction = MissingSchemaAction.Error; try { da.Fill( ds, 0, 200, table.TableName ); } catch( Exception ex ) { MessageBox.Show( ex.Message, ex.Source); } No matter how I play with it, I can't get the Fill statement to work, it always asks for a missing column "SuperUserFlag" in the table - I thought this is precisely what column mappings did for us... -- Thanks in advance, Juan Dent, M.Sc. Tag: RowFilter Expressions with multiple relationships Tag: 110979
  - 12
    - Sharing Data Saved As XML From a Dataset If using ReadXML and WriteXML to serialize a dataset instead of using a regular database, is it still possible to avoid the problem of one person overwriting another person's changes...or is it not possible for data serialized as XML from databset to be shared? Thanks. Tag: RowFilter Expressions with multiple relationships Tag: 110964
  - 13
    - Access to MSDE Hi, What is the most effective way to migrate an access DB to MSDE / SQL Server using only code, C# in this case. I do not have access to the MSDE other than via code and I was looking for a reliable solution. Thanks. Tag: RowFilter Expressions with multiple relationships Tag: 110959
  - 14
    - Using a Class enumeration as a Data Source Hello, I have a class that contains an enumeration and I would like to bind the members of the enumerations to a drop down list box. If have seen some examples that use Enum.GetNames and Enum.GetValues but when ever I pass the name of my enumeration I get an error. Let me illustrate. --- VB.NET Code ---------- Public Class Phone Public Enum PhoneNumberType Home = 1 Work = 2 Mobile = 3 Fax = 4 Pager = 5 End Enum End Class --- ASP.NET Code ------- dropDownListBox.DataSource = System.Enum.GetValues(Phone.PhoneNumberType) It's here that I get an error. "PhoneNumberType is a type in Phone and cannot be used as an expression". Any guess on what I might be doing wrong? Thanks. -dwok Tag: RowFilter Expressions with multiple relationships Tag: 110958
  - 15
    - ODP Authentication problem with ADO.NET Hi, I'm using the latest ODP provider with an Oracle 10g database. My connection string is setup for db authentication - contains the rdbms userid and password. Every so often though I see a Windows Authentication prompt dialog come up - corresponding with an internal Oracle DB Error. All I'm doing is fetching (the same) bunch of records back into an IE browser. Does this ring any bells with anyone? Thanks rpb Tag: RowFilter Expressions with multiple relationships Tag: 110952
  - 16
    - GenerateDBDirect What is the difference between GenerateDBDirect and the Insert/Update/Delete sql commands that can be generated via the advanced button in the select table section of the TableAdapter Wizard in Dot Net 2.0. Tag: RowFilter Expressions with multiple relationships Tag: 110951
  - 17
    - dataset from tab separated Hello I want to create a asp.net / winform application, which has a text box. In the text box, the user will paste data (copied from another source), in tab separated format. Supposedly, all the columns are always in a predetermined order, how can I put this into a dataset and bind to it .. Any input would be appreciated. Thanks Hemang Tag: RowFilter Expressions with multiple relationships Tag: 110950
  - 18
    - Parent expression column Hi all, I am trying to create a visualisation of a many-to-many relationship in VB.NET. The tables, columns and relationships are detailed below (Sorry for all the code). The cables and columns match those found in the Acess database that the application is based around. At the end of the code is an expression column that I wish to add tothe joining table in the middle of my many to many relationship. Dim mmToothType As New DataColumn("Tooth_Type", System.Type.GetType("System.String"), "Parent(Type_Teeth).yID") The column uses a relationship to get the parent record of the joining table. The record is added without error. However, when I run my code, create the tables and relationship and then load the data from the database, the expression column shows a NULL when loaded to a datagrid control!!! Does anyone has any experience of this type of expression column? Is this the best way to illustrate the many-to-many relationship? The joining table (Teeth) contains the number of teeth of a particular type, as well as the FK columns from the person table and the teethtype table and I need to be able to display this column in the same grid. Many thanks in advance for you help. Jason. ' Person Table Dim dPerson As New DataTable("Person") ' Add Name column dPerson.Columns.Add("Name", System.Type.GetType("System.String")) ' Add PK Dim dColumnPK As New DataColumn dColumnPK.ColumnName = "ID" dColumnPK.DataType = System.Type.GetType("System.Int32") dColumnPK.AllowDBNull = False dColumnPK.AutoIncrement = True dColumnPK.AutoIncrementSeed = 1 dColumnPK.AutoIncrementStep = 1 dColumnPK.Unique = True dPerson.Columns.Add(dColumnPK) ' Teeth table Dim tTeeth As New DataTable("Teeth") ' Add the number of teeth tTeeth.Columns.Add("tNumber", System.Type.GetType("System.Int32")) ' Add PK Dim tColumnPK As New DataColumn tColumnPK.ColumnName = "tID" tColumnPK.DataType = System.Type.GetType("System.Int32") tColumnPK.AllowDBNull = False tColumnPK.AutoIncrement = True tColumnPK.AutoIncrementSeed = 1 tColumnPK.AutoIncrementStep = 1 tColumnPK.Unique = True tTeeth.Columns.Add(tColumnPK) ' FK to Person table Dim tColumFKPerson As New DataColumn tColumFKPerson.ColumnName = "tdID" tColumFKPerson.DataType = System.Type.GetType("System.Int32") tColumFKPerson.AllowDBNull = False tTeeth.Columns.Add(tColumFKPerson) ' Add FK to TeethType table Dim tColumFKToothType As New DataColumn tColumFKToothType.ColumnName = "tyID" tColumFKToothType.DataType = System.Type.GetType("System.Int32") tColumFKToothType.AllowDBNull = False tTeeth.Columns.Add(tColumFKToothType) ' TeethType table Dim tTeethType As New DataTable("TeethType") ' Tooth name tTeethType.Columns.Add("yName", System.Type.GetType("System.String")) ' Add PK Dim yColumnPK As New DataColumn yColumnPK.ColumnName = "yID" yColumnPK.DataType = System.Type.GetType("System.Int32") yColumnPK.AllowDBNull = False yColumnPK.AutoIncrement = True yColumnPK.AutoIncrementSeed = 1 yColumnPK.AutoIncrementStep = 1 yColumnPK.Unique = True tTeethType.Columns.Add(yColumnPK) ' Person-Teethth relationship Dim drPersonTeeth As New DataRelation("Person_Teeth", dColumnPK, tColumFKPerson) ' ToothType - Teethth relationship Dim drTeethType_Teeth As New DataRelation("Type_Teeth", yColumnPK, tColumFKToothType) ' Add tables to dataset ds.Tables.Add(dPerson) ds.Tables.Add(tTeeth) ds.Tables.Add(tTeethType) ' Add relationships to dataset ds.Relations.Add(drPersonTeeth) ds.Relations.Add(drTeethType_Teeth) ' Calculated expression that gets the parent from the Type_Teeth relationship Dim mmToothType As New DataColumn("Tooth_Type", System.Type.GetType("System.String"), "Parent(Type_Teeth).yID") ' Add new column to Teeth table Try tTeeth.Columns.Add(mmToothType) Catch ex As NullReferenceException MessageBox.Show(ex.Message) End Try Tag: RowFilter Expressions with multiple relationships Tag: 110943
  - 19
    - Using Crystal Report Hi ALL, I need a help in Crystal Report?! When I'm using Crystal Report Command Based Report that include Graphs and Grouping and then change the report command using report(OBJECT).SetDataSource(Command) it doesn't retreive the correct sql command and retreive the data of the old command that have been used in report building,why?? are there any reason??!! Also,when i used Report XML Based at huge number of data it gives time out or server application Unavilable,also when i increase the time out of the connection in the connection string. Please Help Walid Salah Senior S\W Developer Tag: RowFilter Expressions with multiple relationships Tag: 110934
  - 20
    - Mutating Record, maybe? Hi I'm having a problem performing updates on records in an Oracle 8.1.7 database. The table I'm updating, TABLE_1 has a update and insert trigger which updates another table, TABLE_2, which in turn updates an archive table ARCH_TABLE_2. I can perform an insert and a single update within a single transaction. But, when I try and perform an insert an update then another update the OracleDataAdapter.Update() method fails. Incidentally, the reason for performing multiple updates within a single transaction is for audit and reporting purposes against the ARCH_TABLE_2. A colleague mentioned the problem of mutating records, but I don't see the ORA-04091 exception. Any ideas? Thanks in advance Glenn Tag: RowFilter Expressions with multiple relationships Tag: 110933
  - 21
    - Master-Detail Strategy I have a master table that I would like to display on a form with a navigator, and I would like to display the detail records in a grid for each master record. Right now, I am getting all the records for both tables using DataAdapter.Fill and a "select * from <table>" select command. I am then setting up a DataRelation in code between the two tables. The problem I am having is that it is taking up to 30 seconds to fill the detail table because of it's size. Is there a way to dynamically retrieve and display (and edit) the detail records as each master record is displayed? I'm using the XtraGrid from Developer's Express for the detail records if it makes a difference. --Bruce Tag: RowFilter Expressions with multiple relationships Tag: 110929
  - 22
    - ANN: Sooda 0.7 has been released! Announcing the release of Sooda 0.7 We're proud to announce the immediate availability of Sooda v0.7. Version 0.7 is the initial public release made after more than 2 years of development and testing as well as a number of deployments in various projects. Sooda homepage: http://www.sooda.org/ Download Sooda 0.7 here: http://www.sooda.org/en/download.html Sooda mailing lists: http://www.sooda.org/en/mailinglist.html About Sooda: Sooda is an open-source easy-to-use object-to-relational mapping software for .NET released under the terms of BSD license with portions released under GPLv2. This release includes: * Sooda library * Sooda stub generator utility * Sooda stub precompilation utility * Sooda Query Analyzer Sooda supports the following O/R features: * transparent object materialization * lazy reads * clean and natural syntax - the amount of boilerplate code is reduced to the absolute minimum, the code is readable and maintainable * support for most data types supported by the .NET Framework * natural mapping of one-to-many relations as referenced objects and collections. * natural mapping of many-to-many relations as collections * various models of object inheritance * differential XML serialization and deserialization for moving data across layers * support for long running transactions * data caching with copy-on-write support Sooda supports Microsoft .NET Framework version 1.1 or later and Mono 1.x. Visual Studio.NET 2003 and NAnt 0.85 are supported build platforms. Tag: RowFilter Expressions with multiple relationships Tag: 110927
  - 23
    - Problem with datatable compute max(value) method I have the following code that is getting (or should get) the max value from an xml file. Even though the max value should be 21, it is always returning 9: DataSet ds = new DataSet(); DataTable dt = new DataTable(); ds.ReadXml(Server.MapPath"~/Home/XMLMenus/MenuCategory.xml"),XmlReadMode.InferSchema); dt = ds.Tables[0]; string selectCommand = "Max(report_category_id)"; string filterCommand = "report_category_id > 0"; int nextNum = Convert.ToInt32((object)dt.Compute(selectCommand,string.Empty)); DataRow dr = ds.Tables[0].NewRow(); dr["report_category_id"] = nextNum + 1; dr["report_category"] = "Test"; ds.Tables[0].Rows.Add(dr); DataGrid1.DataSource = dt; DataGrid1.DataBind(); here is the xml: <NewDataSet> <Table> <report_category_id>1</report_category_id> <report_category>Accounting</report_category> </Table> <Table> <report_category_id>5</report_category_id> <report_category>Company</report_category> </Table> <Table> <report_category_id>21</report_category_id> <report_category>Continuous Improvement</report_category> </Table> <Table> <report_category_id>6</report_category_id> <report_category>Customer Care</report_category> </Table> <Table> <report_category_id>7</report_category_id> <report_category>Documentation</report_category> </Table> <Table> <report_category_id>8</report_category_id> <report_category>Employee</report_category> </Table> <Table> <report_category_id>9</report_category_id> <report_category>Engineering</report_category> </Table> <Table> <report_category_id>10</report_category_id> <report_category>Test</report_category> </Table> I have a feeling it is treating the xml values as strings because removing the single digit numbers whos left char is equal to or less than the left char of the max double digit returns the right value. In other words 3 > 21 because 3 > 2 and 21 > 2. Any suggestions? Tag: RowFilter Expressions with multiple relationships Tag: 110921
  - 24
    - I got an "invalid parameter used" exception while using DataGrid with Excel Hi, I am developing an add-in for Excel 2003 using Visual Studio .Net 2003. I am using Windows 2000. I created a Windows Form and loaded a DataGrid control on it. When I ran my add-in, the exception "invalid parameter used" is thrown inspite not writing any code. I want to use this DataGrid for populating it with data from a DataSet. What should I do? My project work is stuck due to this. Will it help if I move on to Windows XP? I am desparately waiting for your early reply. Manas A. Pathak ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>G6SPr3B7u06m1W1G0Aoyow==</Id> Tag: RowFilter Expressions with multiple relationships Tag: 110919
  - 25
    - SqlDataReader & paging Hi, I have an <asp:DataGrid> control to which I'm trying to bind an SqlDataReader. When I do so, I get the following error: AllowCustomPaging must be true and VirtualItemCount must be set for a DataGrid with ID dgrdTimesheet when AllowPaging is set to true and the selected datasource does not implement ICollection. If I set the datagrid's AllowCustomPaging property to true and its VirtualItemCount property to be the number of records returned by the SqlDataReader, the error disappears. The datagrid's paging hyperlinks correctly show the correct number of pages, but each page contains the first page's data. I.e. SqlDataReader contains 76 rows DataGrid's page size is 10 rows DataGrid correctly shows pages 1-8 Clicking on page 1 correctly shows the first 10 records Clicking on any other page incorrectly shows the first 10 records, not 11-20, 21-30 etc. Of course, using a DataSet object instead of an SqlDataReader object cures the problem instantly, but I was wondering if there is any way to use an SqlDataReader object as the datasource of a datagrid which supports paging? Any assistance gratefully received. Mark Tag: RowFilter Expressions with multiple relationships Tag: 110918

I am difficulty in filtering a dataTable with muiltiple FK relationships.

I have a table tblContacts(name, cityID, companyID) which has FK
relationships to 2 lookup tables tblCity and tblCompany created in the
DataSet.

When I build the DataView.rowFilter String, I use "Parent.cityName like
'San*' AND Parent.companyName like 'Uni*'", but I get an error "Additional
information: Invalid variable: Parent.cityName" at run time.

Is there a way to work around this error?

Thanks.

Top

RE: RowFilter Expressions with multiple relationships by aconrad

aconrad
Wed May 25 19:12:50 CDT 2005

For multiple relationships - you must explicitly identify the relationship
by name. See the following for more info:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfsystemdatadatacolumnclassexpressiontopic.asp

Andrew Conrad
Microsoft Corp

Top