I'm completely dense here, but I'm trying to get some stats from a DataTable. One of the columns in the datatable is called "colour".I need to find out how many of each instance of "colour" are in the datatable.
I'm trying: Dim q = From p In PGWorkingDataTable _ Group p By p("colour") Into Group _
I'm using Reporting Services 2005 to produce a one-time report that will group records according to the PLANCODE field. I've created the following VB function:
[Code]...
How do I reference the above function in a new calculated field so that the report will group data based on the results of this function? The doucmentation states that the expression should be something like =code.PayorGroup. However, when I try this expression in the Calculated Field window, I get the infamous red squiggly line stating Unrecognized Idnetifier.
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):
Dim _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 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>
In my datagrid, i added a checkbox column, and what i want to do is be able to change the value of one column (in as many rows that are selected) to a certain value. Like from a combo box is it possible to have a combobox in a messagebox? or do you have to create a new form?
When referring to a list or group in .net, generally, it starts with 0 as the first item, but concerning the starting place in an Access table the first row is considered 1. Is this correct and, thus, represented in the code below?
Code: intCurrRow = 0 If dtOrderEntry.Rows.Count > 0 Then ShowData()
I am using MSHFLEXGRID control to display data from an access-database table. The grid contains entries some of which are to be selected by the user but I want some of the rows to be disabled/skipped(avoid selection of those rows). I have grayed out the unusable rows and dont want the gray rows to be selected.
Code: Private Sub MSHFlexGrid1_RowColChange(ByVal sender As Object, ByVal e As System.EventArgs) Handles MSHFlexGrid1.RowColChange
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)
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.
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 :
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:
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".
I 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 am making a game and decided to add a high score section. I currently have this code setup to insert and read from the database, I set the insert code to a bottom just for testing purposes.[code]There are three columns in the database rank, score and name. I set the rank to auto number so the database would assign the player rank automatically, how would I go about inserting the score into the relevant place inside the database and moving the other scores to their new relevant places?
1) I have a checkbox field in a datagrid, and when you check the box, it highlights the entire current row, and when you check the next one, it stops highlighting the first one and highlights the one I just clicked on. What I would like to know is how can I keep all the rows with a checkbox highlighted? 2) I have a column in my datagrid that I have changed to combobox and I did two things both gives me this error, first I inserted the values for the combobox in the collection. Second, I connected to one of the tables with a binding source and has one of the columns as the options (advisors).
Each student has a different advisor so the field gets set to the correct advisor each time but the problem I am getting is when I scroll (doesn't happen for a little while) I get an error so i put in this sub to handle it and the error message box says: Error Happened Formatting, Display.
Private Sub DataGridView1_DataError(ByVal sender As Object, ByVal e As DataGridViewDataErrorEventArgs) Handles DataGridView1.DataError MessageBox.Show("Error happened " _ & e.Context.ToString()) If (e.Context = DataGridViewDataErrorContexts.Commit) _ [Code] .....
Usually, to go through my Access Database records in VB, i used the "Data control tool" in the older versions of VB, but i cant find it in VB2008, is there anyother tool that allows you to scroll through Access database records, on VB 2008?