| DataSet Question (VIP replies) |
| Develop.com's DOTNET List |
| Here are two options: foreach(DataRow row in TableB.Rows) TableA.ImportRow(row); //or DataTable CopyOfTableB TableB.Copy(); CopyOfTableB.TableName TableA.TableName; DataSet.Merge(CopyOfTableB); I hope this information proves helpful. David Sceppa Microsoft This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use. 2001 Microsoft Corporation. All r... |
|
| "Assembly of Ressource not found" (VIP replies) |
| microsoft.public.dotnet.framework.compactframework |
| Hello NG! I've created the CAB files for my CF app with the wizard. Now I want to test it on two devices: (1) iPaq 3850, ARM SA1110, PPC2002 (2) Medion, Intel PXA250, PPC2002 For both I've taken "... PPC.ARM.CAB". On device (1) everything works fine, but on device (2) there apears an error "The Assembly of the Ressource couldn't be found". Anyone knowing what's the problem? Is it a problem of the ... |
|
| "Filter" data from XML datafile into datagrid (VIP replies) |
| microsoft.public.dotnet.languages.vb |
| Hi, I fill a datgrid with data from a xml document, it works fine But.... Now I will to filter the data to the grid so only the data shows from the criteria that I set. My code now is very simple to fill the grid Dim strProj As String Dim MyA As String() Dim dsCodes As New DataSet Dim fsReadXml As New System.IO.FileStream(XMLFile, System.IO.FileMode.Open) Dim XmlReader As New XmlTextReader(fsReadX... |
|
| "IF" test in SP evals to True and False at same time using DataAdapter.FillSchema() (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| The IF test in a Stored Procedure is evaluating to true and false at the same time for FillSchema() (See result below SELECT TOP 2 TOP 100 PERCENT) Any thoughts are appreciated. Dave Information on Problem Below is the output from the Fill() and FillSchema(). The commands were run back to back using the exact same SQL Command and DataAdapter. DataAdapter.Fill() DECLARE @request list table (id uniq... |
|
| "Index was out of range" error when editing DataRow (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| "Index was out of range" error when editing DataRow Our application makes thousands of edits to DataSets without problem, but occasionally this error appears: "Index was out of range. Must be non negative and less than the size of the collection. Parameter name: index" I have found one place in the code where I can reproduce the error, though still intermittently. In this case I am changing the va... |
|
| "Refreshing" a databound comboBox after data update? (VIP replies) |
| microsoft.public.vsnet.enterprise.tools |
| I've got a simple data bound comboBox that loads up fine. When I add data to it's DataView's table, though, the combo goes blank. I tried re Fill(ing) the appropriate table with the DataAdapter and then calling AcceptChanges on the DataSet, but still no luck. Can someone tell me what I'm obviously missing? Thanks in advance! |
|
| "top" of datatable (newby) (VIP replies) |
| microsoft.public.dotnet.languages.vb |
| Hi: I have created a datatable and I'm able to access it by key values. I need to be able to go to the "top" of the datatable and process records sequentially until they are completed. I can't figure out the command to set me to the top or "beginning" and then read. (datatable.select?) Any help in the steps to do this would be greatly appreciated! Thanks, Fred |
|
| 'FindStringExact' is not a member of 'System.Web.UI.WebControls.ListBox'. (VIP replies) |
| microsoft.public.dotnet.framework.aspnet |
| Dim index As Integer lbSysteem.FindStringExact(strSysteem) basicly i want to return the value but as the examples show on the MSDN library, nothings wrong with the code? if FindStringExact isnt a member of Listbox then from what is it? thx in advance, Richard |
|
| 'System.MissingMethodException' when calling function from Mousedown Event? (VIP replies) |
| microsoft.public.dotnet.framework.compactframework |
| This is so puzzling...maybe someone here with has a suggestion to help me. It started when I added an If statment (CurrentTab "A" ) to this code in a MouseDown event (Note: the image bitmap assignment was working *FINE* until I added the IF code around it): Private Sub pictTabA MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles pictTabA.MouseDown If CurrentTa... |
|
| .Net Codepage 850 problem with uppercase accented characters (VIP replies) |
| microsoft.public.dotnet.framework |
| Hi. I have a problem using ASP.Net or VB.Net (Winforms) accessing an Oracle database that uses WE8PC850 (which is the IBM PC codepage 850) character set. Our older ASP apps work fine with this database, but the three different ASP.Net and VB.Net Winforms test apps we have developed so far do not display uppercase French accented A and E characters correctly. I have tried all the potential codepage... |
|
| .NET DataTable to String array? (VIP replies) |
| microsoft.public.dotnet.languages.vb.data |
| Hi, Is there a built in mechanism to turn a datatable into a string array and insert chars after each row. I know I could loop through and create the string myself but I thought that old ASP and ADO had some method to return a string array from a recordset and put characters after each row. I want something like this: DataTable has one column Part Row1 12345 12345 Row2 12345 54545 I want to get a ... |
|
| .NET Datatable usage question (VIP replies) |
| microsoft.public.dotnet.languages.vb |
| Greetings I have a .net Windows application with a procedure that loads some comboboxes from SQL server. I make the connection to SQL with SQLconnection object, run a command against this Object and load the results to a DataTable object. My question is will the datatable object still store the resultset if I end the procedure with a SQLconnection.close, thus allowing the user to run in a disconne... |
|
| .Net slow, SQL tools FAST? (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| I am running an sproc that runs in 2 3 sec using query analyzer, but takes just under 5 min using .net data providers (I've used SqlClient, OleDb, and Data block v2) t sql statement executed from QA: RptInvRoyalty 126, '2/1/2004', '2/29/2004' ..net code: System.Data.SqlClient.SqlCommand cmd; cmd new System.Data.SqlClient.SqlCommand("RptInvRoyalty 126, '2/1/2004', '2/29/2004'"); cmd.Connection new ... |
|
| <***VB.NET***> DataTable.Select's efficiency? (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello!! You would be welcome to answer the Question: I make a DataSet's instance(sfSalesPlanDataSet) of DB's Table, Add new DataRow into sfSalesPlanDataSet, and seek a record, But When I Creating the DataRow, seek the record, it becomes very slow. the following code is the sample: When running the ***Sample 1*** , it is very fast (3 seconds); When running the ***Sample 2*** , it becomes very very ... |
|
| ? about DataColumn (VIP replies) |
| microsoft.public.dotnet.languages.vb.data |
| I'm reading F. Scott Barker's book titled "Database Programming with Visual Basic.NET and ADO.NET Tips, Tutorials, and Code" and an example sub is below Private Sub frmHowTo3 3 Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim strSQl As String Dim dc(1) As DataColumn Try modaCust New OleDb.OleDbDataAdapter("select * from Customers", (BuildCnnStr("(local)", "Northwin... |
|
| 101 ADO Help (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| This is the first time I've tried to convert my .asp ado connection to the ..NET framework and I'm totally lost. Most of the examples I've seen are incompliant or more complicated then I can comprehend. I was wondering If someone could point me to a referance that showes an entire example of connecting to a database and adding a record to a table within the database. I'm pretty sure that the conne... |
|
| 2 DataView's from 1 DataSet/DataTable influence each other... (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have 2 comboboxes, both bound to a different DataView, but thoe DataViews are bound to 1 DataTable in 1 DataSet. Like this: Dim dvwList2 As New DataView dvwList2 MyDataSet.Tables("tblAccounts").DefaultView dvwList2.Sort "Account ASC" cmbAccount.DataSource dvwList2 cmbAccount.DisplayMember "MaskAccount" cmbAccount.ValueMember "Account" cmbAccount.Text "" Dim dvwList3 As New DataView dvwList3 ... |
|
| 2 DataView's from 1 DataSet/DataTable influence each other... (VIP replies) |
| microsoft.public.dotnet.languages.vb.controls |
| Hi, I have 2 comboboxes, both bound to a different DataView, but thoe DataViews are bound to 1 DataTable in 1 DataSet. Like this: Dim dvwList2 As New DataView dvwList2 MyDataSet.Tables("tblAccounts").DefaultView dvwList2.Sort "Account ASC" cmbAccount.DataSource dvwList2 cmbAccount.DisplayMember "MaskAccount" cmbAccount.ValueMember "Account" cmbAccount.Text "" Dim dvwList3 As New DataView dvwList3 ... |
|
| 3-D String Array (or better alternative?) (VIP replies) |
| microsoft.public.dotnet.languages.csharp |
| I have data that looks something like this when returned from a stored procedure (3 columns, X rows): Key1 Name1 Value1 Key1 Name2 Value2 Key1 Name3 Value3 Key1 Name4 Value4 Key2 Name1 Value1 Key2 Name2 Value2 Key3 Name1 Value1 KeyX NameY ValueY Data type for all is string. Number of rows returned from sp will never exceed 100. You can see that there is a conceptual 1:many relationship between Key... |
|
| A "IN" like where queries on DataTable (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi I have a DataTable which is part of dataset, and has relation with other DatyaTables in the DataSet. I have to make select on the DS tables, which its meaning is same as "IN", when I query on sql E.G. Select T1.field1 from T1 where T1.Field2 in (select T2.field2 from T2 where ....) Is there any built in way to do it, otherwise, what is the best practice to simulate this action |
|
| A problem about KB 815672 (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| When I test examples in KB 815672 step by step. In "Test the Disconnected ADO.NET Windows Application" section Step 4. Application crash. This is the error message An unhandled exception of type 'System.Web.Services.Protocols.SoapException' occurred in system.web.services.dll Additional information: System.Web.Services.Protocols.SoapException: Server was unable to process request. System.Data.SqlC... |
|
| A question about CheckedListBox. (VIP replies) |
| microsoft.public.dotnet.languages.csharp |
| All, Please pardon what is probably a dumb question, but I am having some trouble wiht my CheckListBox in my c# Windows Forms application. My goal is a table like display, with 4 columns including the checkbox, the data item name, and 2 dates. I have to query 3 tables in my database and assemble the DataTable by hand, but I do this successfully, and I am able to look at the contents of my DataTabl... |
|
| A simple question (VIP replies) |
| microsoft.public.dotnet.framework.windowsforms |
| Please pardon my ignorance, I want to know how to clear data from a datagrid. I attached a dataset to a datagrid. Now I want to clear the current data from datagrid and want to attach new dataset with the datagrid. I don't know how to clear the current dataset out of datagrid Looking forward for some help |
|
| A Strange Issue with DataGrid (VIP replies) |
| microsoft.public.dotnet.languages.vb.data |
| Hello, I am trying to bind a DataTable to a Grid which will allow users to Edit data and then submit the changes back to the Database. I want to display values in the Grid satisfying a particular criteria like follows: Dim tbl as new DataTable For Each row As DataRow In DataTableName.Rows If (row.Item("ColumnName") Is System.DBNull.Value) Then tbl.Rows.Add(row.ItemArray) End If Next Grid.DataSourc... |
|
| A VERY strange problem when Updating a Dataset (VIP replies) |
| microsoft.public.dotnet.languages.vb |
| A little background: I use three Datagrids that are in a child parent relation. I Use Negative Autoincrement on the the DataTables and that's workning nice. My problem is when I Update these grid and write to the database and I set the new Primary Keys and related Fields to the new asigned atuonumbers in the Access. The following Sub is the RowUpdated for the TopGrid's Adapter that will get the ne... |
|
