I have one datatable tempDT with value :
[Code]...
The problem is I want merge duplicate serial_no into one row which the value of testong adding to new column. I have tried many ways, but I can't find the solution. Here is my code behind :
[Code]...
I need to write a method in C# to save all rows in a given datatable back to the database, but I cannot depend on the rowstate of each row. I can't think of how best to do this without extensive looping through the database table data or constant database querying.
I want to essentially perform the following insert / update for each row in the datatable, but more efficiently:
[Code]...
merge two rows in to one row from many rows below is data example:
id Date AccessType Empno CardNo
1 |04-03-2012 07:23:42 AM | Door Access Granted | 150512 | 8543183
2 |04-03-2012 09:37:05 AM | Card Exit Granted | 150512 | 8543183
3 |04-03-2012 11:08:07 AM | Door Access Granted | 150512 | 8543183
4 |04-03-2012 03:20:32 PM | Card Exit Granted | 150512 | 8543183
5 |04-03-2012 07:47:09 AM | Door Access Granted | 150506 | 8234333
6 |04-03-2012 09:37:03 AM | Card Exit Granted | 150506 | 8234333
Not certain what exactly I am doing wrong here, but I am having problems in setting a new DataTable (for posting back to the database) to the Changes resulting from the Merge proc of 2 DataTables. The code works fine until I attempt to set the ChangesTable --- it always ends up = Nothing.What is strange is that the "preMergeCount" = 0 and the "postMergeCount" = 23, which is EXACTLY how I expect it to be! So I know that the Merge is working correctly.
Dim sqlTable As DataTable = dsMonitoring.Tables("SQL_SRTraps")
Dim exlTable As DataTable = dsMonitoring.Tables("Excel_SRTraps")
AddHandler sqlTable.RowChanged, AddressOf Row_Changed
[code]....
I need to marge two datatable with condition. i table data come from local XML Database and another data come from remote sql data if any update made at remote datatable and then marge with local datatable. i wrote a code below :
Public Sub MargeTwoTable()
Dim SQL As String = ""
Dim RemoteTable As New DataTable
Dim LocalTable As DataTable
[code]....
as you see in my code data come from remote database which update date getter then local database . Both table are same and "ID" is primary key. I code is working well. But problem is that when data more then 1000 updated record so this function take too long in loops.
i write a code like : Dim mm() As DataRow = LocalTable.Select("ID = '" & RemoteTable.Rows(i).Item("ID") & "'"). for finding local datatable id row so when data is more then 1000 it take too long because localtable record more than 100000 records. So I need someone help to modify my code what the best way to write the code.
I have three sub tables that I want to process. For each I want to combine the rows, as they are only different by contents in the second column(I want to do the same to the fourth column, later):
'Sub table 1
xx|C201 |02300877 |Samsung |....
xx|C201 |02300877 |Toshiba |....
xx|C213 |02300877 |Samsung
[code]....
p.s. For the fourth column, Manufacturer information , I want to do the same and I'd probably get something like this for the final table:
xx| C201,C213,C606,C619 |02300877 | Samsung
xx| C201,C213,C606,C619 |02300877 | Toshiba
xx| C303, C305,C712 |02301163
xx| C207, C209, C708 |02301165
My code got an error at messagebox.show at messagebox said System.NullReferenceException was unhandled Message="Object reference not set to an instance of an object"What is wrong? (dt1 and dt2 are all ok. They are have only one columnd: ID)
[Code]...
I have one datatable. In that table I have columns named [Total Day], [Present day], and [leave].
Data are as follows:
[Total Day], [Present day], [leave]
30 25 5
30 26 4
Now i want to concatenate those three columns in one another column. I want output something like this:
[Total Day] [Present Day] [Leave] [TotalDay PresentDay Leave]
30 25 5 30 VBCrLf 25 VBCrLf 5
30 26 4 30 VBCrLf 26 VBCrLf 4
i create a Class to update data from remote sql server to local compact sql server data. I write two method one method check if any update date in remote server method like..[code]Last i Call SaveLocalDatabase method. But When i check table in my local compact sql server database there has no data update.is any think missing to write. i Think i found a problem. i use LocalTable.Merge(dTable, True). When Merge Call then rowstate remain unchange.
View 2 RepliesI am trying to merge multiple datacolumns in a datatable. Eg. The address data is stored in a different columns such as, Housename, street, city and postcode. I want to merge those datacolumns in to one and put it into one datacolumn as "Address".
View 1 RepliesHere is a sample piece of my code, the problem that I am have is that I can only selected one record at a time to mail merge, regardless if I select 5 rows from the datagrid. Or I can mail merge the entire datagrid, but I want my users to be able to select the data that they want, whethere it is 1 or 5 rows and be able to mail merge based off the selection. I've been pulling my hair out over this, I know it is something simple that I am missing....Please help...I am working in VB.NET visual studio 2008
Private Sub btnMailMerge_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnMailMerge.Click
Dim objWordDoc As Microsoft.Office.Interop.Word.Document
'Dim objWordDoc As New Microsoft.Office.Interop.Word.Application
[code]....
I have two text files. The first text file has the format:
ID h1 h2 h3
a 1 5 7
b 3 3 5
c 0 4 8
And the second file:
ID h4 h5 h6
a 2 4 9
b 3 6 1
b 4 1 5
Now I want to merge two files. The output likes
ID h1 h2 h3 h4 h5 h6
a 1 5 7 2 4 9
b 3 3 5 3 6 1
b 4 1 5
c 0 4 8
The two files has the same rows and columns. For the first rows(except header) in the two files, they have the same first column. Therefore just a simple append. The final first row becomes
a 1 5 7 2 4 9
The question is in the first only has one
b
and the second file has two
I want the maximum count of items from each list in the resultant list. I put some white spaces after "b" then append strings.
b 4 1 5
For key "c", because it is only in the first file and not in the second file, so I append white spaces after the corresponding strings.
Is there a way of merging (importing or whatver is the correct terminology is) the data from an Array in to a DataTable woithout looping. I already know how to loop through the array to populate the DataTable with new DataRow but I'm looking for something much faster if it exists. I've got a 1 dimensional String array i.e. 'String()' that I need to populate a DataTable with new DataRows.
View 4 RepliesDim _tableBackLogs As System.Data.DataTable
Do While i - 2 > 0
_tableBackLogs = Global.DataAccess.GetDataTable("SELECT SubjectID,SubjectName,Grade FROM SubjectPI WHERE RegNo='" & CInt(HttpContext.Current.Session("userName")) & "' AND Status='Fail' AND Semester='" & i - 2 & "'")
i = i - 2
Doing this replaces the previous data in the DataTable. I want to retain the previous data i.e i want the new rows to be added to the DataTable w/o replacing the previous rows.
I want to compare differences between two tables in my database with identical schemas.
vb.net
DataTable1.Merge(DataTable2)
Dim changedRows As DataTable = DataTable1.GetChanges
'changedRows is always Nothing. Why???
The DataTable1 is updated with rows from DataTable2 correctly. i.e. missing rows are added and datarows that don't match are updated. But the RowState of each row is still unchanged. I need to have the rowstate (added/modified/deleted) so that I can update the database table.
I have a DGV that has a datasource to load the rows I need for display.
Now, I need to save the selected rows to a DataTable.
binding the DGV. I created the DataTable in my DataSet dsProfiles1 and created a BindingSource - bsDataTableDGV
DataTable:
ClientID Int32 not null PK
ClientName String not null
ProgramNo Int32 Not Null
[Code].....
I have a form with a textbox and a add button. User can write a name down on the textbox and click add button. it will save in a datatable with auto ID. After that, the textbox is cleared and the user can write another name on the text box and click the button. This should add to the existing datatable on memory with existing ID + 1. Show on the gridview. (this is just for display purpose to confirm it works)
I have a datatable like this.
Button1.click() event
Dim name = txtname.Text
Dim dt As New DataTable
dt.Columns.Add("ID", GetType(Integer))
[Code] .....
At the moment I have sometime like the code above. in the real program, it is not just name and it is not just one datatable so i just mock up some code. And this code for aspx.
<asp:TextBox ID="txtname" runat="server">
</asp:TextBox><asp:Button ID="Button1" runat="server" Text="Button" />
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
I Have a datatable in .net. I need to flip the location of two of them. For example, a datatable that the select statement had an order by priority clause. The user wants to up the priority of a single row by selecting it and clicking increase priority, how do i move a row up (AKA flip two rows)
View 2 RepliesI have this sub :
Private Sub error_out(ByVal line As Integer, ByVal err_col As Integer, ByVal err_msg As String)
Dim ln = t_erori.Rows.Add
[Code]....
I suspect this is because it's trying to add the same row twice.
How can i make this work ? Or what else method could I use to do this ?
I need this datatable because my app is writing some results in there, but any other method to store the results that works with parallel.for would be ok.
I have a datatable object, which is populated from a webservice.Apparently, the web service just throws everything (data) back to me. The data which gets in my datatable looks like this:
Dept Code Value
Science ABC 5
Science ABC 6
[code].....
At the moment I use this code but I have 591 rows to delete and it takes forever to loop and delete each row on an individual basis
[Code]...
i need to delete some rows from datatable
i don't know the indexes i have 2 columns to idendify the rows to delete
how to achive this in easy way
i don't want to delete inside loop wat will happen if i have 2 million rows? tats why i don't want to delete indendify the rows and delete in loop
I have a Datatable in my code in vb.net. I need to delete rows from the datatable. The name of my Datatable is "temptable".in my row deleting event of a Gridview control. I wrote code as follows:
In the Row_Deleting event of Gridview:
temptable.Rows.Remove(Gridview1.Datakeys(e.RowIndex).value)
But,it shows an error as follows:
"Cannot cast System.Int32 to System.Data.Datarow".
IDE : VS 2008,Platform : .NET 3.5,Here is my DataTable columns :ID Note DetailI want to write sth like this :
View 8 RepliesI have a simple application that uses a database to store usernames and passwords.I have a hidden control that, when activated,should clear all usernames and passwords from the datatable.Then, one admin account is added. I have tried the datatable.clear method BUT while it throws no errors, it doesn't clear the datatable.I have also tried the datatable.reset method, with the same problem. I am now trying this method:
Dim row As DataRow
For Each row In Authenticate.Logins
row.Delete()[code]....
I'm trying to set the same value for all rows for a single column in a datatable without using for loop. Any faster methods to achieve the same.
View 2 Repliesam just curious to know...which is the better or more efficient way of these two?
Note: tblOD is a DataTable
For dtrows As Long = 0 To tblOD.Rows.Count - 1
dgv1.Rows.Add(tblOD(dtrows)(0), tblOD(dtrows)(1), _
[code].....
Way to access datatable rows
[code]...
I have a datatable and I want to create a text file using this datatable. I want that each row of the newly created text file is unique. If there is a duplicate row, then it should add * to both rows ( duplicate rows)
I am using following code:
Dim str As String
For Each row As DataRow In dataTable.Rows
str += row(1) ' This is text data
[Code]...
I have a DataTable which I want to check if values in three of the columns are unique. If not, the last column should be filled with the line number of the first appearance of the value-combination.
[Code]...
I solved this by iterating the DataTable with two nested for loops and comparing the values. While this works fine for a small amount of data, it gets pretty slow when the DataTable contains a lot of rows.My question is: What is the best/fastest solution for this problem, regarding that the amount of data can vary between let's say 100 and 20000 rows? Is there a way to do this using LINQ? (I'm not too familiar with it, but I want to learn!)