Filtering a DataTable

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
    - DataSet binding/updates If I base my DataSet on a schema (an .xsd file), and then bind the controls on my form to the necessary fields in a DataTable in the DataSet, how then would I use the SqlDataAdapter to put all this information into the database? Loading the DataSet from a schema is easier than basing it on a query since there are several tables involved. Tag: Filtering a DataTable Tag: 101694
  - 2
    - Datasets and merging Hi! I want to extract a single row from one table in a typed dataset (dsUser) containing multiple tables, and then send it on to a data access layer component for create/read/update/delete operations. I found two ways: 1. Create a standalone typed dataset (dsPerson) with the same structure as the one table I'm interested in, and use the Merge function to get the content of the datatable. dsPerson.Merge(dsUser.COR_Persons) 2. Extract the row by using the ItemArray property of the dsPerson.COR_Persons and dsUser.COR_Persons datatables respectively. Dim dsPerson As New COR_Persons Dim personRow As COR_Persons.COR_PersonsRow personRow = dsPerson.COR_Persons.NewCOR_PersonsRow personRow.ItemArray = dsUser.COR_Persons(0).ItemArray The first approach is the easiest implement, but I get a bulkier object to send on the data access layer. Does someone now anything about the performance differences for these two approaches? TIA Jonas Tag: Filtering a DataTable Tag: 101692
  - 3
    - ASP.NET vs VB.NET guys i have a very simple question concerning the differences between the two. for instance, radio buttons and the checkchanged event. it really doesnt seem to respond in asp.net if i set an if statemtent in that control, where if checked = true, then one thing happens, or if checked = false another thing happens. but, in VB.NET it responds perfectly. is there something extra i have to do. i am using the radio button as a server control. thanks guys. i know this is a pretty simple one for probably everyone..........but, it's kinda got me curious thanks rik ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: Filtering a DataTable Tag: 101684
  - 4
    - Named tables/Sql Server/Can't do TableMappings I have a stored proc that returns me multiple tables. Is there a way I could set their names to be something other than TABLE TABLE1 TABLE2 ... ?? Sorry TableMappings won't do !! I can't use that for certain reasons. I have to be able to do something in the T-Sql that after SqlDataAdapter.Fill, my tables are named properly. DM Tag: Filtering a DataTable Tag: 101674
  - 5
    - Update to Visual FoxPro 6 Table is failing Everything I've read says the below code should update the foxpro table, but it doesn't. The dataview and datagrid are being updated, but the actual foxpro table isn't. The table has 3 fields ( idnum, fname and lname). The select statement gets the one matching record just fine. The record in the table has the number 2 in the idnum field, and I'm trying to change it to the number 90. I also have downloaded and installed the latest Microsoft VFPOLEDB provider from http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en#filelist ***** code in button **** Dim ConnFoxTest As OleDbConnection = New OleDbConnection Dim SqlCmdFoxTest As OleDbCommand = New OleDbCommand Dim DaFoxTest As OleDbDataAdapter = New OleDbDataAdapter Dim DsFoxTest As DataSet = New DataSet Dim DvFoxTest As DataView = New DataView Dim idNum As Integer Dim StrSqlCmdFoxTest As String StrSqlCmdFoxTest = "Select * From FoxTest where fname='Jeff'" ConnFoxTest.ConnectionString = "Provider=VFPOLEDB.1;Data Source=c:\temp\foxtest.dbf;Persist Security Info=False" ConnFoxTest.Open() SqlCmdFoxTest.Connection = ConnFoxTest DaFoxTest.SelectCommand = SqlCmdFoxTest DaFoxTest.SelectCommand.CommandText = StrSqlCmdFoxTest DaFoxTest.Fill(DsFoxTest) DvFoxTest.Table = DsFoxTest.Tables.Item(0) idNum = DvFoxTest.Item(0).Item("idnum") ' Messagebox shows '2' MsgBox(Str(idNum)) DvFoxTest(0).BeginEdit() DvFoxTest(0)("idnum") = 90 DvFoxTest(0).EndEdit() DsFoxTest.AcceptChanges() DaFoxTest.Update(DsFoxTest) idNum = DvFoxTest.Item(0).Item("idnum") ' Messagebox shows '90' MsgBox(Str(idNum)) ' datagrid also shows '90' in the idnum field DataGrid1.SetDataBinding(DsFoxTest, DsFoxTest.Tables.Item(0).TableName) DvFoxTest.Dispose() DsFoxTest.Dispose() DaFoxTest.Dispose() SqlCmdFoxTest.Dispose() ConnFoxTest.Close() **** end code ******* Tag: Filtering a DataTable Tag: 101671
  - 6
    - Child rows Hi guys, I need to know how to create child rows for a newly created parent row. I've been doing it one way, but it's obviously not the right way to do it (finally starting to cause me some problems!). Here's what I've been doing ("ParentID" is the primary key): \\ Dim NewParent as DataRow = tblParentTable.NewRow '<Initialize NewParent values> tblParentTable.Rows.Add(NewParent) Dim NewChild as DataRow = tblChildTable.NewRow NewChild.Item("ParentID") = CInt(NewParent.Item("ParentID")) '<Initialize other NewChild values> tblChildTable.Rows.Add(NewChild) // What happens is, the dataset creates a "temporary" value for ParentID, and that value is assigned to the child rows. So the relationship works okay until the database is updated and then the tables refilled. On update, the database sometimes gives a different value for ParentID than the database had, but that value change is not carried through to the child rows. What is the proper way to do this? Thanks, Nathan Tag: Filtering a DataTable Tag: 101661
  - 7
    - How to INSERT pure <NULL> Into SmallDataTime Field (MS SQL Server) I need to insert NULL into the field with SmallDataTime datatype. In .NET when I tried to use "" or DBNull.Value it insert "" what will be automatically converted into '1/1/1900' by SQL Server... I need to have the Insert statement like this: INSERT tblTest (Name,smDate) Values ('John',NULL) But using pure NULL without double quotes ("") is not allowed in .NET. When I use double quotes ("NULL"), .NET interpreted it as character string and I got the SQL converting error. Thank you for the help. Eugene Tag: Filtering a DataTable Tag: 101659
  - 8
    - CommandBuilder InsertCommand Update Hi All!!! Seasons Greetings.... I have read a lot of the post regarding CommandBuilder, InsertCommand and Update. The code below works.... 'This is a foxpro table that matches my MS SQL Table fpDA = New OleDbDataAdapter("select * from table", GetConnection) flat = New System.Data.DataSet() fpDA.Fill(flat, "table") Try Dim cn As New Data.SqlClient.SqlConnection(ConnSqlClient) cn.Open() da = New Data.SqlClient.SqlDataAdapter("select * from table", cn) cb = New Data.SqlClient.SqlCommandBuilder(da) cb.QuotePrefix = "[" cb.QuoteSuffix = "]" da.InsertCommand = cb.GetInsertCommand() Dim p As Data.SqlClient.SqlParameter Dim row As Data.DataRow Dim col As Data.DataColumn For Each row In flat.Tables("table").Rows For Each p In da.InsertCommand.Parameters p.Value = row.Item(p.SourceColumn) Next affectedRows += da.InsertCommand.ExecuteNonQuery Next Return affectedRows Catch ex As Exception MsgBox(ex.Source & vbCrLf & ex.Message) End Try There should be more documentation for the "Update" command from Microsoft. It seems that if you just wanted to insert an unmodified table directly into SQL server using CommandBuilder is a no go. Once again...there should be documentation showing how to insert unmodified data (rowstate is unchanged) into an SQL server database with out getting a headache and eye strain. Markus McGee Tag: Filtering a DataTable Tag: 101653
  - 9
    - Data Access Application Block v3? Hi Guys, Have just downloaded v2 of the Data Access Application Block but see that v3 is available on the GotDotNet website. Does anyone know: if v3 is stable enough for use in real systems and when Microsoft are likely to release it officially. Cheers, Peter Tag: Filtering a DataTable Tag: 101644
  - 10
    - Different results with the same query?!? Hi all, I want to check if a record exists in the DB. I use two different ways to create the sql query. One way is by using SqlCommand and SqlParameter. The other way by building the query myself (without SqlParameter(s)) and using the SqlCommand to execute it. In one I get false in the other i get true. Can anyone help me? //////////////////////////////////////////////// //Build the query using SqlParameters //////////////////////////////////////////////// SqlCommand m_MessageSelectCommand = new SqlCommand(); m_MessageSelectCommand.CommandText = "SELECT MessageNumber FROM Messages WHERE CommunityNumber=@CommunityNumber and ForumParent=@ForumParent and ForumNumber=@ForumNumber and WrittenBy=@WrittenBy and MessageDate=@MessageDate"; m_MessageSelectCommand.Connection = m_Connection; m_MessageSelectCommand.CommandTimeout = 0; m_MessageSelectCommand.Parameters.Add(new SqlParameter("@CommunityNumber", System.Data.SqlDbType.Int, 4, "CommunityNumber")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@ForumNumber", System.Data.SqlDbType.Int, 4, "ForumNumber")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@ForumParent", System.Data.SqlDbType.Int, 4, "ForumParent")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@WrittenBy", System.Data.SqlDbType.NVarChar, 100, "WrittenBy")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@MessageDate", System.Data.SqlDbType.DateTime, 8, "MessageDate")); // later in the code m_MessageSelectCommand.Parameters["@CommunityNumber"].Value = dlMessage.m_CommunityNumber; m_MessageSelectCommand.Parameters["@ForumParent"].Value = dlMessage.m_ForumNumber; m_MessageSelectCommand.Parameters["@ForumNumber"].Value = dlMessage.m_TopicNumber; m_MessageSelectCommand.Parameters["@WrittenBy"].Value = dlMessage.m_MessageAuthor; m_MessageSelectCommand.Parameters["@MessageDate"].Value = dlMessage.m_MessageDate; SqlDataReader reader = m_MessageSelectCommand.ExecuteReader(); bool b = reader.HasRows; // B IS FALSE!!! //////////////////////////////////////////////// //The other way - just build the query by myself //////////////////////////////////////////////// System.Text.StringBuilder sql = new System.Text.StringBuilder(256); sql.Append("SELECT MessageNumber FROM Messages WHERE CommunityNumber="); sql.Append(dlMessage.m_CommunityNumber); sql.Append(" and ForumParent="); sql.Append(dlMessage.m_ForumNumber); sql.Append(" and ForumNumber="); sql.Append(dlMessage.m_TopicNumber); sql.Append(" and WrittenBy='"); sql.Append(dlMessage.m_MessageAuthor); sql.Append("' and MessageDate='"); sql.Append(dlMessage.m_MessageDate); sql.Append("'"); SqlCommand c = new SqlCommand(sql.ToString(), m_Connection); SqlDataReader reader = c.ExecuteReader(); bool b = reader.HasRows; // I get that b is true. This happens durring the same program execution How can this be??? Tag: Filtering a DataTable Tag: 101642
  - 11
    - Different results with the same query?!? Hi all, I want to check if a record exists in the DB. I use two different ways to create the sql query. One way is by using SqlCommand and SqlParameter. The other way by building the query myself (without SqlParameter(s)) and using the SqlCommand to execute it. In one I get false in the other i get true. Can anyone help me? //////////////////////////////////////////////// //Build the query using SqlParameters //////////////////////////////////////////////// SqlCommand m_MessageSelectCommand = new SqlCommand(); m_MessageSelectCommand.CommandText = "SELECT MessageNumber FROM Messages WHERE CommunityNumber=@CommunityNumber and ForumParent=@ForumParent and ForumNumber=@ForumNumber and WrittenBy=@WrittenBy and MessageDate=@MessageDate"; m_MessageSelectCommand.Connection = m_Connection; m_MessageSelectCommand.CommandTimeout = 0; m_MessageSelectCommand.Parameters.Add(new SqlParameter("@CommunityNumber", System.Data.SqlDbType.Int, 4, "CommunityNumber")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@ForumNumber", System.Data.SqlDbType.Int, 4, "ForumNumber")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@ForumParent", System.Data.SqlDbType.Int, 4, "ForumParent")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@WrittenBy", System.Data.SqlDbType.NVarChar, 100, "WrittenBy")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@MessageDate", System.Data.SqlDbType.DateTime, 8, "MessageDate")); // later in the code m_MessageSelectCommand.Parameters["@CommunityNumber"].Value = dlMessage.m_CommunityNumber; m_MessageSelectCommand.Parameters["@ForumParent"].Value = dlMessage.m_ForumNumber; m_MessageSelectCommand.Parameters["@ForumNumber"].Value = dlMessage.m_TopicNumber; m_MessageSelectCommand.Parameters["@WrittenBy"].Value = dlMessage.m_MessageAuthor; m_MessageSelectCommand.Parameters["@MessageDate"].Value = dlMessage.m_MessageDate; SqlDataReader reader = m_MessageSelectCommand.ExecuteReader(); bool b = reader.HasRows; // B IS FALSE!!! //////////////////////////////////////////////// //The other way - just build the query by myself //////////////////////////////////////////////// System.Text.StringBuilder sql = new System.Text.StringBuilder(256); sql.Append("SELECT MessageNumber FROM Messages WHERE CommunityNumber="); sql.Append(dlMessage.m_CommunityNumber); sql.Append(" and ForumParent="); sql.Append(dlMessage.m_ForumNumber); sql.Append(" and ForumNumber="); sql.Append(dlMessage.m_TopicNumber); sql.Append(" and WrittenBy='"); sql.Append(dlMessage.m_MessageAuthor); sql.Append("' and MessageDate='"); sql.Append(dlMessage.m_MessageDate); sql.Append("'"); SqlCommand c = new SqlCommand(sql.ToString(), m_Connection); SqlDataReader reader = c.ExecuteReader(); bool b = reader.HasRows; // I get that b is true. This happens durring the same program execution How can this be??? Tag: Filtering a DataTable Tag: 101641
  - 12
    - Question about relationships - "cycles or multiple cascade paths" error I have 2 tables: Table: UserTable Field: Id (pk) Field: FullName Table: MarriageTable Field: MarriageId (pk) Field: Husband Field: Wife The MarriageTable.Husband and MarriageTable.Wife fields BOTH have to be valid users from the UserTable. In SQL Server I'm creating a relationship diagram. I (1) dragged Id from UserTable to MarriageTable.Husband and (2) dragged Id from UserTable to MarriageTable.Wife. But, the Diagram has trouble saving the Wife relationship. Any ideas? Am I doing this correctly? Here's the error: 'UserTable' table saved successfully 'MarriageTable' table - Unable to create relationship 'FK_MarriageTable_UserTable1'. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Introducing FOREIGN KEY constraint 'FK_MarriageTable_UserTable1' on table 'MarriageTable' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. [Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint. See previous errors. Thanks. Tag: Filtering a DataTable Tag: 101640
  - 13
    - VB.NET: How to apply a DataView Can somebody please help. I'm coming from VB6 and this is my first VB.NET applciation. Below is my code that fills two tables contained in a DataSet, creates a relation between them, and finally, uses them as DataSources for two grid controls on the form. This code works prefectly fine. Now, my question is how do I apply a DataView in order to sort and filter my data without destroying my relation? Ever snippet of code I've looked at involves setting up a DataView and then setting it to the DataSource of my DataGrid. This, however, destroys my relation. Thanks for any help. m_Ds = New DataSet m_Da1 = New OleDbDataAdapter("SELECT * FROM Groups", Conn) m_Da2 = New OleDbDataAdapter("SELECT * FROM Clients", Conn) m_Da1.FillSchema(m_Ds, SchemaType.Source, "Groups") m_DgGroupsCount = m_Da1.Fill(m_Ds, "Groups") m_Da2.FillSchema(m_Ds, SchemaType.Source, "Clients") m_Da2.Fill(m_Ds, "Clients") 'Create a relation and add it to the collection. Dim rel1 As New DataRelation("LinkToClients", _ m_Ds.Tables("Groups").Columns("GroupID"), _ m_Ds.Tables("Clients").Columns("GroupID")) m_Ds.Relations.Add(rel1) 'Master/detail setup. Me.dgGroups.DataSource = m_Ds Me.dgGroups.DataMember = "Groups" Me.dgGroups.AllowNavigation = False Me.dgClients.DataSource = m_Ds Me.dgClients.DataMember = "Groups.LinkToClients" Tag: Filtering a DataTable Tag: 101638
  - 14
    - comparing two lists hey guys, i need some help on an approach. i need to compare, two different lists. one will be pulled from a dataset and could have as much as 2500 varchar employee numbers in it. the other will have the same data, but might be missing some of those same numbers. what's the best way to compare the two lists, or group or array and find who's missing from the second list? thanks rik ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: Filtering a DataTable Tag: 101635
  - 15
    - Validating data. Hi everybody, this is my first post in this group. I'm working with an Access DB and i have the following code to validate fields with unique indexes (no duplicates): 'Field is a DataColumn If Field.Unique Then If Field.Table.Rows.Contains(NewData) Then Return "Error: This field can't have duplicate values." End If End If The problem that i found is that apparently the property 'Unique' works only for Primary Keys fields. So, how do i make a similar validation but with fields with unique indexes only (no Primary Key)? The other doubt that i have is that the property 'DataColumn.DefaultValue' doesn't set itself to anything when i get the values from a field wich has a default value. Note: I fill a DataSet with Fill and FillSchema methods in order to do the tests. Thanks. Tag: Filtering a DataTable Tag: 101633
  - 16
    - OT: Database Design I am trying to make sure I'm using best practice for an Access table. If I have a table that has 100 discrete colums. Is it best to just keep the table with so many columns or to split it into a few other tables. The 100 columns are indeed discrete so splitting them isn't going to reduce any duplication of data. Tag: Filtering a DataTable Tag: 101622
  - 17
    - how to merge 5 tables into one table I have a dataset that reads from an xml file. When the file was read, 5 tables where created.having the relationship between the table. how can i merge those five tables into one table or better yet how can i make that table relational? thanks Tag: Filtering a DataTable Tag: 101620
  - 18
    - bound textbox text change won't save to dataset BlankHi, I select a value in a bound combobox on tab 1, then I programically assign related text to a bound textbox's text property on tab 2. I see the text in the textbox when I view tab 2 and the textchanged event fired. However, after I save the changes, close the form, reopen the form, the previous data appears in the textbox, not the new data. Here's the code from the combobox's selectedIndexChanged event: With txtSignalOffset .Focus() .Text = "10" End With CType(sender, ComboBox).Focus() CType(cmTerminal.Current, DataRowView).EndEdit() Both the combobox and textbox are bound to the same datatable. If I type data directly into the textbox there is no problem. However I want the textbox to be read only and assigned a value by code only. I tried editing the CType(cmTerminal.Current, DataRowView) datarow directly but then got screwy behavior from the combobox such that it wouldn't change its selected value - it kept bouncing back to the original value. Same thing happened when I instead tried directly editing the datatable. This is driving me crazy and wasting a lot of time. Thanks for any insights you may have, NJ Tag: Filtering a DataTable Tag: 101615
  - 19
    - return value from stored procedure using SqlHelper.UpdateDataset Hi, I'm trying to update the Database (sql2000) using the DAAB v2.0 SqlHelper.UpdateDataset method. The problem is that my insert stored procedure returns the primary keys of my new inserted rows as a returned values parameters. But with the above method there seems to be no way to get back those parameteres. What woul be the best way to overcome this problem? Thanks, Gwenda Tag: Filtering a DataTable Tag: 101613
  - 20
    - UPDATING database using datagrid : error on UPDATE button click I am using a datagrid to write data to the database. I am using the walkthrough by msdn "Using a datagrid to Read & write data to Database". But when i hit the update button I get the following error: : Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Source Error: Line 348: Line 349: // Updates the dataset table. Line 350: r.CompanyName = track; Line 351: r.Region =esn; Line 352: Source File: c:\inetpub\wwwroot\demo\boflog\viewrec.aspx.cs Line: 350 Stack Trace: [NullReferenceException: Object reference not set to an instance of an object.] BofLog.ViewRec.DataGrid1_UpdateCommand_1(Object source, DataGridCommandEventArgs e) in c:\inetpub\wwwroot\demo\boflog\viewrec.aspx.cs:350 System.Web.UI.WebControls.DataGrid.OnUpdateCommand(DataGridCommandEventArgs e) +109 System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e) +507 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26 System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source, EventArgs e) +100 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +120 System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +115 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +138 System.Web.UI.Page.ProcessRequestMain() +1292 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032 MY CODE for UPDATE button click is:: private void DataGrid1_UpdateCommand_1(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { string track, esn; // Gets the value of the key field of the row being updated string key = DataGrid1.DataKeys[e.Item.ItemIndex].ToString(); // Gets get the value of the controls (textboxes) that the user // updated. The DataGrid columns are exposed as the Cells collection. // Each cell has a collection of controls. In this case, there is only one // control in each cell -- a TextBox control. To get its value, // you copy the TextBox to a local instance (which requires casting) // and extract its Text property. // // The first column -- Cells(0) -- contains the Update and Cancel buttons. TextBox tb; // Gets the value the TextBox control in the third column tb = (TextBox)(e.Item.Cells[1].Controls[0]); track = tb.Text; // Gets the value the TextBox control in the fourth column tb = (TextBox)(e.Item.Cells[3].Controls[0]); esn = tb.Text; // Finds the row in the dataset table that matches the // one the user updated in the grid. This example uses a // special Find method defined for the typed dataset, which // returns a reference to the row. dsCompany.FormFieldsRow r; r = dsCompany1.FormFields.FindBy_AsiOrder_(key); // Updates the dataset table. r.CompanyName = track; r.Region =esn; // Calls a SQL statement to update the database from the dataset sqlDataAdapter1.Update(dsCompany1); // Takes the DataGrid row out of editing mode DataGrid1.EditItemIndex = -1; // Refreshes the grid DataGrid1.DataBind(); } I think the problem is bcoz " key" is a string & r maybe is an int. But when I tried doing r = dsCompany1.FormFields.FindBy_AsiOrder_(INT.PARSE(key)); it showed error! Please help. thanks -- pmud Tag: Filtering a DataTable Tag: 101612
  - 21
    - Read Description of Field Any way in ADO to get to the Description of the field - for example, in Access you can provide a logical description for each field in the table. Thanks, Scott Tag: Filtering a DataTable Tag: 101611
  - 22
    - INSERT into Access Database using C# from ASP page The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. Is the error message I get when it gets to dbCmd.ExecuteNonQuery();. I have 15 fields to insert, therefore I did one field at the time and found that the 13th field is the one causing the problem, this field has size 20 and data I am entering has size is 1. I took the INSERT command and entered it from Access Query and it worked, but not from ASP page using C#. Please help I thank you for your assistance. I found the similar error in http://www.error-bank.com/microsoft.public.dotnet.languages.vb.1/196223_Thread.aspx. But there were no solutions posted. Tag: Filtering a DataTable Tag: 101606
  - 23
    - Recordsets and Ref Cursors I am passing an ADODB.Recordset (rs) into a .Net C# dll. I need to fill a dataset using Oracle.DataAccess.Client.DataAdaptor. OracleDataAdapter da = new OracleDataAdapter(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); da.Fill(dt, rs); This does not work. I need to use: da.Fill(dt, ref cursor); How do I convert the recordset (rs) to a ref cursor? Thanks.... -- Robert Hill Senior Programmer/Analyst Wake Forest Univ Baptist Med Ctr Tag: Filtering a DataTable Tag: 101595
  - 24
    - Database Insert with IDENTITY ON I have a situation where I have two datasets each equal with the data from the same table. I want to update one dataset with the records from the next dataset IDs in tact. Here's the code I have: ' Set AcceptChangesDuringFill = False objDataAdapterSource.AcceptChangesDuringFill = False ' Fill the data adapter with some data from the source "myTable" objDataAdapterSource.Fill(objDataSetSource, "myTable") ' This is a function I wrote that just calls the "SET ' IDENTITY_INSERT myTableON" SetIdentityInsert(True, "myTable") ' Select everything from myTable on the database toupdate and ' create a data adapter strSQL = "SELECT * FROM myTable" objDataAdapterDest= New SqlClient.SqlDataAdapter(strSQL, strConn) ' create a commandbuilder object objCB = New SqlClient.SqlCommandBuilder(objDataAdapterDest)' 'Update the destination data set objDataAdapterDest.Update(objDataSetSource, "myTable") Let's say the Source object objDataSetSource had a "myTable" with two columns" "TableID" and "Description" where "TableID" was the key. Let's say it had one row, where the TableID = 1 and Description = "TEST". I am expecting the same table in the destination database to be inserted with the exact same data. Instead, the TableID ends up being generated by the database as if Identity_Insert isn't turned on. Any suggestions? Tag: Filtering a DataTable Tag: 101586
  - 25
    - Adding Columns to DataSet-DataTable out of Position Is it possible to add a column to an existing DataTable (in a DataSet) with the new column being some place other than the end of the column collection? I looked at Columns.Add and there is no position parameter and there is no InsertAt method like some other collections. Is this possible through some other means? Maybe create a new Table and copy data??? Thanks, Ashton Tag: Filtering a DataTable Tag: 101580
- Next
  - 1
    - PRIMARY KEY required for WRITING data to SQL DATABASE using DATA G I am posting this question here too coz I was not sure whether I had posted this earlier in the right group. I need an editable datagrid. But for editing a datagrid as shown in the walkthrough: Using a DataGrid Web Control to Read and Write Data, the table in the SQL database should have a primary key. But my table doesnt have one. So what is the best way I can create primary key in SQL database? Is UNIQUE IDENTIFIER a good option? Is it something like Auro Number of MS Access which is automatically filled by the database for each row? If not , how can i make a primary key for that SQL table? -- pmud Tag: Filtering a DataTable Tag: 101578
  - 2
    - MEMBER_UNIQUE_NAME property NULL Hi, I use OleDb (.NET) to execute MDX queries. An simple example query: WITH MEMBER [Promotion Media].[CalcMember] AS '[Promotion Media].[All Media].[Bulk Mail]'SELECT {[Measures].[Unit Sales]} ON COLUMNS,{[Promotion Media].[All Media].[Bulk Mail], [Promotion Media].[CalcMember]} PROPERTIES MEMBER_UNIQUE_NAME ON ROWS FROM [Sales] When I use OleDb to execute this query and populate a DataTable object, the MEMBER_UNIQUE_NAME column value for the [CalcMember] row comes up NULL instead of "[Promotion Media].[CalcMember]". [Promotion Media].[Media Type].[Member_Unique_Name] [Measures].[Unit Sales] ========================================= ================ [Promotion Media].[All Media].[Bulk Mail] 4320 (null) 4320 Can anyone tell me why that is and how to fix it? Thanks in advance. Tag: Filtering a DataTable Tag: 101572
  - 3
    - How to kow the Lenght of the Text in the Current DataGridTextBoxColumn (on MouseMove) Hi, I need to know the Lenght of the Text in a DataGridTextBoxColumn when I move with the mouse over it, and show it in a ToolTip. I have something that works, but it works only when the DataGridextBoxColumn is not selected. Once I select it (type some additional text in it), I don't see the ToolTip anymore... I gues that's because it isn't anymore the DataGrid that the Mouse is moving over, but the Cell. Does anybody knows a solution for this? Thanks a lot in advance, Pieter You can see my DataGrid_MouseMove here: Private Sub dbgGrid_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles dbgGrid.MouseMove Dim p1 As New Point p1 = dbgGrid.PointToClient(Cursor.Position) Dim intCol As Integer = dbgGrid.HitTest(p1).Column Dim intRow As Integer = dbgGrid.HitTest(p1).Row If (intCol = 3) And (intRow > -1) Then Dim strT As String Try strT = dbgGrid.Item(intRow, intCol).ToString Catch ex As Exception strT = "" End Try strT = strT & vbCrLf & "Length: " & strT.Length totImport.SetToolTip(dbgGrid, strT) totImport.Active = True Else totImport.SetToolTip(dbgGrid, "") totImport.Active = False End If End Sub Tag: Filtering a DataTable Tag: 101569
  - 4
    - How to fill multiple datatables in a dataset in a single fill Anyone who knows how to fill more than one datatable in a single fill using a dataadapter? I have 4 joined tables in a select-statement that I want to fill into their datatables. Now I have to make 4 selects to do that, and that's no good. Alternatively make a datatable representing all 4 tables alltogether. Tag: Filtering a DataTable Tag: 101568
  - 5
    - Identifying stored procedure output columns In VS.Net Server Explorer, you can drill down to a SQL Server store procedure and finally, it diplays not only parameter of the procedure but also the result columns. How can I replicate this behaviour in my application? Tag: Filtering a DataTable Tag: 101558
  - 6
    - Getting RowCounts for Multiple Statements I am trying to execute several DML statements in a single call to an ADO.NET SqlCommand object, ie. update table1 set column1 = x update table2 set column2 = y I am wanting to get the rows affected for each update statement, ie. 10 rows for table1, 20 rows for table2, but the RowsAffected only gives me the total for the statement. Is there any way to get the records affected broken out by statement. I tried capturing the InfoMessages from the SqlConnection and turning set nocount off, but it doesn't provide any messages. Any ideas? Thanks, Ashton Hobbs Tag: Filtering a DataTable Tag: 101553
  - 7
    - DataReader and record locking problem Hi, I am using the ExecuteReader method from the Microsoft DAAB to return a DataReader which I am iterating through to mainly read a binary value from one of the returned columns. I am using this value as the raw data to render a PDF document. After this is successful, I want to update the same record with a timestamp to indicate the render to PDF was successful. However,using a totally separate method in my code (using ExecuteNonQuery of the DAAB) to do this whilst the reader is still open (using the pk of the row I want to update), throws an exception - the call times out and if I look at the processes in the database, the update of the timestamp is being locked by the datareader process. My code is the only code accessing this table and the column I am updating is not one of the ones returned by the datareader. So now on to the questions: 1) Should I theoretically be able to read a row with a datareader and update a column in the same row (using a separate connection/call) before moving on to the next record? 2) If I cannot do this, what is the best and most efficient practice to perform this kind of operation (I may have to do this for up to 30,000 rows)? Do I get a list of all the rows I want to operate on (in an array or datatable) and then iterate through each one, pulling the relevant data back for one row at a time in a disconnected fashion for each row and then perform the update or should i just pull back all the records in a disconnected fashion (this seems like it would work when there are a small amount of rows but then if I have 30,000, that's going to be one very big DataSet/DataTable? Any help would be greatly appreciated Thanks in advance Mike Tag: Filtering a DataTable Tag: 101548
  - 8
    - Connection pooling... I'm using connection pooling (0 min/100 max) in an asp.net web application. All users log in using the same connectionstring. Is it prudent, for instance, to close and dispose of my connection after a database update takes place which I normally do when I'm not using connection pooling? Tag: Filtering a DataTable Tag: 101534
  - 9
    - Getting month from Date field in SQL DATABASE Hi I have an ASP.NET application. I am using a dataset for loading data (based on user input month & company Name) from SQL database. I have the query as :: SELECT CompanyName, Date , CEO from TABLE WHERE (CompanyName=@a && But how do I get the month part from the Date field in the database so that when the user enters the month in text box, records can be selected based on the month. Any help is appreciated. -- pmud Tag: Filtering a DataTable Tag: 101531
  - 10
    - How to compare two tables? Hi, Our database is constantly updated (input data) from another DB, and sometimes it crashes our ASP.NET applications. My boss told me to write a DB utility app to check DB and make sure all apps are still running. The first step of few checks is to compare current DB tables with yesterdayâ??s tables. I store yesterdayâ??s tables at a XML file (DB is maintained by another guy, and certainly they donâ??t want me to make back copy for few tables in DB everyday). I thought itâ??s trivial, and just do loop and compare two XML DOM (XmlDocument) objects and make a new one. But the algorithm is more complex than I thought. The new rows can be inserted or deleted based on primary key. So, my question is: Is there a sample code to compare two tables (either DataTable in DataSet, or XmlDocument)? Another question is: Can I set color for individual cell in DataGrid UI, because I want to use different color to show new, deleted or modified field dynamically? Thanks Shaw Tag: Filtering a DataTable Tag: 101530
  - 11
    - table ColumnChanging and windows form textbox databinding What do I need to do to get a datatables ColumnChanging event to trigger when one of it's fields is bound to a textbox? There must be some way to get this to work. It works great in complex bound scenarios. I have found that if I use a dataview for a datatable and do an "Addnew" and then bind that to a text box and alter that textbox value I can get the table ColumnChanging event to fire if I run a CurrencyManager.Refresh. But this does not work if the record already exists, a CurrencyManager.Refresh only gets the previous value. Any suggestions? Thanks, AJL Tag: Filtering a DataTable Tag: 101527
  - 12
    - Driver upgrade - class naming and namespace query I've been working on the Mono Sqlite 2.x client (http://www.go-mono.com/sqlite.html) in order to make it work with Sqlite 3.0. Note that I have nothing to do with Mono, but I find this code useful for working with Sqlite in Microsoft .NET. I'm wondering what would be the best way to name the classes. The Sqlite data format changed from version 2.x to 3.x, so I need a different set of classes for the new version. Currently the namespace is Mono.Data.SqliteClient, and within this there are classes such as: SqliteConnection SqliteCommand SqliteDataReader etc My first instinct is to add new classes in the same namespace: SqliteConnection3 SqliteCommand3 SqliteDataReader3 etc This way, you can use the version 2.x and 3.x clients side by side. However, another approach is to create a new namespace, say Mono.Data.SqliteClient3, and stick with the old class names. Or to have a new namespace *and* new class names. Is there any guidance as to what is best practice here, either for ADO.NET or for .NET generally? Tim Tag: Filtering a DataTable Tag: 101523
  - 13
    - URGENT:Viewing MULTIPLE RECORDS from database using DATA READER Hi, I have an ASP.NET application. I need to read records from the SQL database based on a value entered by the user. I need to get the result in Text boxes. I am using DATA READER for this. But how can i view the next record from the database in the text boxes?? I get one record in the text boxes by clicking a button....but how can i view the next record??? My code is: System.Data.SqlClient.SqlDataReader d1; private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here } private void Button1_Click(object sender, System.EventArgs e) { sqlCommand1.Parameters["@a"].Value=txtC.Text; sqlConnection1.Open(); d1= sqlCommand1.ExecuteReader(); while(d1.Read()) { TextBox3.Text= d1["Company"].ToString(); TextBox4.Text=d1["Ceo"].ToString(); TextBox5.Text=d1["Month"].ToString(); } d1.Close(); sqlConnection1.Close(); } Please help. Its URGENT! -- pmud Tag: Filtering a DataTable Tag: 101515
  - 14
    - OleDbLiteral Does System.Data.OleDb.OleDbLiteral have a purpose or is it just there to look good, as if it is used by something when it is not, or will be used in something in the future ? Tag: Filtering a DataTable Tag: 101505
  - 15
    - About MSDTC,The same ContextUtil.TransactionId,but the state of Database A,B is different. I want to update MultiDatabase with Microsoft's MSDTC.Just like ADO.Net provided, I designed an interface below: public interface IDistributeTransaction { int StartTransaction(); int CommitTransaction(); int RollBackTranstion(); int ExecuteSql(string connectionstring,string SqlStr,out string ErrStr); } I called the Interface by Remoting. int rt = m_DistributeTrans.StartTransaction(); if(rt == 0)//sucess { rt = ExecuteSql(....);//Update A database; if(rt == 0)//sucess { rt = m_DistributeTrans.ExecuteSql(....);//Update B database } if(rt == 0)//sucess m_DistributeTrans.CommitTransaction();//Commit; else //failed DistributeTrans.RollBackTranstion();//Rollback; } But when Rollback,the A database is updated sucessful. The ContextUtil.TransactionId is the same during the whole Transaction. Why this happened? Tag: Filtering a DataTable Tag: 101501
  - 16
    - exploring database schema Hi, how can I list the following things with ADO.NET in a generic way: a) list all databases available in a DBMS b) list all tables within a selected database c) list the fields (and their type, constraint etc.) with in a table I've found things like GetOleDBSchema.. but (of course) it is available only for OleDBConnector. Is there a generic way like the "Connectionstring"-Wizard does it, too? thanks doc Tag: Filtering a DataTable Tag: 101500
  - 17
    - but in ado.net handling an output parameter with an initial value NULL? hi, i use ado.net to call a stored procedure in SQL Server 2000. the SP have a parameter that is input and output when i send an input value of null, the return value does not return correctly and i get null in return even if the SP set the value to something else. if the initial value is not null, the return value of the output parameter is received correctly. what's the problem??? TIA, z. Tag: Filtering a DataTable Tag: 101484
  - 18
    - need guidance on - dataset, view and bit of ASP .NET Hi, I am new to web programming and am using ASP .NET (C#) and ADO .NET to develop a web based room booking application. I have been reading a lot of books on ADO .NET and ASP .NET and I have a few basic question which I am totally confused about. Please note that I am a beginner and you have to see the questions in that angle. I may be vague on my questions - if it is not clear please guide me. 1. Regarding dataset: (a) I have one bookings table which takes in all the booking information - ID of the person, date booked, start time, end time and room booked. Update, Delete, Add mainly happens in this database. there are other tables but the main one is the above mentioned table. Question: Does every client who accesses the web application end up creating a dataset? OR Is there only one dataset which is accessed by all clients? (b) If I have a view in the database - Can dataset carry the same view? or should we make up a view in the dataset? If the question is unclear to you it is because I myself is not clear about what I shold be asking. Could you please through some light on views in dataset. 2. Regarding ASP .NET: If it is only one dataset which part of the program do I set this dataset up so that the application creates only one dataset. ? If I do it in the pageload section will it not end up creating dataset for every client? Are you with me? If the above question is not clear, please let me know. The book talks about how to create the dataset - gives the code. But it doesn't actually tell me which part of the program should the code for the dataset be in. Thank you and I appreciate your guidance. Best Regards, Li Tag: Filtering a DataTable Tag: 101483
  - 19
    - using IIF expression to decide what formula to use for the field? Hi, I want a datacolumn expression which will work out a value depending on the value of child records here is the expression that does not work. if any1 can help me that would be great iif(child(Packaging).CasingFlag = 'Y',Sum(child(Packaging).PackagingCostPerKg) * parent(ProductProductVariant).NetWeight,Sum(child(Packaging).PackagingCostPerKg) * parent(ProductProductVariant).GrossWeight) also is it possible to refernce a chile or parent value through multiple relationships? thanks Tag: Filtering a DataTable Tag: 101480
  - 20
    - Slow to Execute Stored Procedure Hello, I've recently started playing around with SQL 2000 and Stored procedures and calling these stored procedures with a C# program. I have the following setup: 1 Windows 2003 server running SQL 2000 (SP3). I have created a small C# program to run a stored procedure called "usp_CreateNewAddressType". It has two parameters, both of type varchar: @AddressName varchar(30), @AddressDescription varchar(50). When I run the code posted below on the server itself it takes about 3 seconds to run. Is this what I am too expect as far as running this code? Or am I missing something that may make it run faster (note: the slowness only happens when I run the application for the first time, after that it inserts the two items to the db much faster). Here is the code I am using: //Constructor public Form1() { // // Required for Windows Form Designer support // InitializeComponent(); string storedProcedureName = "usp_CreateNewAddressType"; string connectionString = "server=win2003srv;database=mytestdb;uid=sa;pwd=123"; this.mySQLConnection = new SqlConnection(this.connectionString); this.command = new SqlCommand(storedProcedureName, mySQLConnection); //Sets the command type to be of stored procedure type this.command.CommandType = CommandType.StoredProcedure; } //Button Event that saves to DB private void btnSaveToDB_Click(object sender, System.EventArgs e) { //This fills in the data that has been typed in to the text boxes //this.param = this.command.Parameters.Add("@AddressName", SqlDbType.VarChar, 30); //this.param.Value = this.txtAddressTypeName.Text; //this.param = this.command.Parameters.Add("@AddressDescription", SqlDbType.VarChar, 50); //this.param.Value = this.txtAddressTypeDescription.Text; this.command.Parameters.Add("@AddressName", SqlDbType.VarChar, 30).Value = this.txtAddressTypeName.Text; this.command.Parameters.Add("@AddressDescription", SqlDbType.VarChar, 50).Value = this.txtAddressTypeDescription.Text; //Will execute the stored procedure this.mySQLConnection.Open(); this.rows = this.command.ExecuteNonQuery(); this.mySQLConnection.Close(); //Shows' user that it worked MessageBox.Show("Number of Rows affected: " + rows.ToString()); } //End of Code Can anyone point me to any reason as to why this is happening? Maybe I am just expecting this to run faster, or this may just be normal. I just want to make sure I am not missing anything that can make this code run fast the first time you run the program. For example, should I put some of the code in the load event of the windows form? Any advice provided will be greatly appreciated! Tag: Filtering a DataTable Tag: 101478
  - 21
    - Unspecified error: E_FAIL(0x80004005) Hey, While wandering about one day writing some VB code, I came across an ugly little error, as seen above. Further delving into my code tosee whether I am a complete and utter fool, I managed to track downthis ugly little error's source, which is as follows: aComm.CommandText = "SELECT Cust_No, Cust_Name " & _ "FROM Customers " & _ "WHERE LOWER(Cust_Name) LIKE " & txtName.Text.ToLower() & _ " + '*' OR LOWER(Cust_City) LIKE " & txtCity.Text.ToLower() & _ " + '*' OR LOWER(Cust_Prov) LIKE " & txtProv.Text.ToLower & "+ '*'" This little bad boy is causing the executeReader() method of the command object to throw the aformentioned error. I am using an Access database to run this query against, and putting the data collected into a list box. I tried running the query without the WHERE clause from my procedure, and it ran. The query runs in Access with the WHERE, however, it won't run from here. If anyone has an idea, that would be super duper. Cheers, Matt Bailey Tag: Filtering a DataTable Tag: 101471
  - 22
    - Parameter["@xxx"] does not have a default value I keep getting this error message and cannot find the solution for it. I've written the following stored procedure: SELECT Username FROM [User] WHERE Username=[@Username]; When I run the stored procedure within Access, it works. However, the following code does not work. The field in the Access table is set to: Text and has Required: yes. Any suggestions? public static bool CheckUsername(string name){ bool success = false; try{ using(OleDbConnection conn = new OleDbConnection(BroodmoorBase.CONNECTION_STRING)){ conn.Open(); OleDbCommand cmd = new OleDbCommand("bspCheckUsername",conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new OleDbParameter("@Username",OleDbType.Char,50)); cmd.Parameters["@Username"].Value = name; if( cmd.ExecuteNonQuery() > 0 ) success = true; conn.Close(); return success; }//end using } catch(Exception e){ throw e; } } I've tried putting a breakpoint immediately before the 'if' statement to see if there is indeed a value for the parameter. There is. Sometimes, the statement conn.Close() doesn't even execute as I step through the code. It just skips that line and executes the 'return success;' statement. I'm using Access and I'm using .NET Framework 1.0. I've checked the spelling in the strored procedure and my code and it is the same. Any help would be appreciated. thanks, Prince Tag: Filtering a DataTable Tag: 101470
  - 23
    - Generic Update routine, except for primary keys In my implementation of a 'Save As' routine, I have a current, multi-row dataset. When I do a save as, I create an entirely new object which therefore creates its own multi-table dataset with its own primary keys. After the new object (dataset) is created, what I need to do is copy the contents of the original dataset to the new dataset. The original dataset will already have been saved to the database. It is possible that the original dataset will have more rows than the new dataset. At first, I tried to use a dataset merge, but the issue with this is that the new table and the original table have their own unique primary key values and therefore, what I get is an extra row and not an update to the current row. I can't just copy the dataset either because then I will have two datasets with identical primary key IDS in many tables. So what I need to do is : a. If a row already exists, update the fields that are not the primary key or foriegn key to another table. How can I tell if a column is a primary or foreign key? b. If a row does not exist, add the row, not including primary key value. Here, I still can't just copy the whole row because the new row still has to have a unique ID. This new row can also have child rows, so on the client side, how can I create a primary key and then use that key as a foreign key? I am thinking of using GUIDs as primary keys but not sure if this is appropriate. Any ideas? STom Tag: Filtering a DataTable Tag: 101469
  - 24
    - Using @@IDENTITY and SCOPE_IDENTITY() I need to obtain an identity value from a row I just added to a table. I would prefer to use SCOPE_IDENTITY() rather than @@IDENTITY but have found that the only way I can get SCOPE_IDENTITY() to work is to place a SELECT SCOPE_IDENTITY() just after the INSERT.... code of a single SQLCommand object(and then fire ExecuteScalar). If I try to use 2 seperate SQLCommand objects, the first doing the INSERT and the second the SELECT SCOPE_IDENTITY(), the SCOPE_IDENTITY() returns a DBNULL every time. I've made sure that both SQLCommand objects use the same open connection. I don't seem to have the same problem with the @@IDENTITY, even if I use the 2 SQLCommand object technique. Each time I get the correct answer. Can you help me with use of the SELECT SCOPE_IDENTITY() in a SQLCommand object(s)? Must it be in a single object (with the INSERT and SCOPE_IDENTITY() statements), sort of like a stored procedure, or can it be made to work with 2 sequential SQLCommand objects. Happy Holidays -- Michael Hockstein Tag: Filtering a DataTable Tag: 101466
  - 25
    - Primary Key, autoincrement field set to zero Hi there, I'm working on a app which is suppossed to update an Access 2000 database through an Web Service. So i have made an Windows App. which works on a disconnected DataSet. It then Insert and Update this DataSet and sends it to the Web Service, which then inserts it into the actual Access database. The Web Service then returns a DataSet with the changes made in the database. The two DataSet's are then merged. My problem is that after adding a new Row to the disconnected DataSet, i can see that it's primary autoincrement key is set to zero. When i then try to merge it with the DataSet from the Web Service, the Row is added again instead of acknowledged as the same Row. Anybody experienced the same problem? Any help will be appreciated, - Martin Klopp Jensen Tag: Filtering a DataTable Tag: 101462

I'm trying to filter a DataTable... first I do a SELECT on my DataTable...
and assign the result to a DataRow array... then I CLEAR the DataTable... and
try to import the DataRows from the DataRow array... I end up with an empty
DataTable... what am I doing wrong? And... is there a better way to do this?

Top

Re: Filtering a DataTable by Sahil

Sahil
Thu Dec 30 13:46:27 CST 2004

The DataRow array doesn't actually copy the objects, all it does is copy the
references to the objects and gives you the array. So when you do a "Clear"
the array gets cleared too.

Use a dataview instead?

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

"MER78" <MER78@discussions.microsoft.com> wrote in message
news:6B3626B2-0DD3-49D8-A747-C0B112675102@microsoft.com...
> I'm trying to filter a DataTable... first I do a SELECT on my DataTable...
> and assign the result to a DataRow array... then I CLEAR the DataTable...
and
> try to import the DataRows from the DataRow array... I end up with an
empty
> DataTable... what am I doing wrong? And... is there a better way to do
this?

Top

Re: Filtering a DataTable by Sahil

Sahil
Fri Dec 31 13:49:04 CST 2004

You could also create a new DataTable and use the ImportRow method instead
of "Add".

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

"Sahil Malik" <contactmethrumyblog@nospam.com> wrote in message
news:OBZy$gq7EHA.208@TK2MSFTNGP12.phx.gbl...
> The DataRow array doesn't actually copy the objects, all it does is copy
> the
> references to the objects and gives you the array. So when you do a
> "Clear"
> the array gets cleared too.
>
> Use a dataview instead?
>
> - Sahil Malik
> http://dotnetjunkies.com/weblog/sahilmalik
>
>
>
> "MER78" <MER78@discussions.microsoft.com> wrote in message
> news:6B3626B2-0DD3-49D8-A747-C0B112675102@microsoft.com...
>> I'm trying to filter a DataTable... first I do a SELECT on my
>> DataTable...
>> and assign the result to a DataRow array... then I CLEAR the DataTable...
> and
>> try to import the DataRows from the DataRow array... I end up with an
> empty
>> DataTable... what am I doing wrong? And... is there a better way to do
> this?
>
>

Top