What should I use and how to use something that functions like a label box but can handle several columns and columns? Something that looks like this. [code] Name | Age | Birthday are headers and the letters are variables
View 5 RepliesI'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
My goal is to connect to my database either manually or using an sqladapater, and get information from two of my databases on sql server 2005. Then I want to take this information and on run-time begin to add/subtract/divide/multiply certain columns and place the information into other columns. I can do this in queries, however, I want to do it on run-time what is the best way to achieve this.I had some of this working, but I just want to start fresh and see how you would go about doing this.
[Code]...
I have the below Linq query that is returning the data but I need to aggregate the columns to group on the Period and Sum the Count columns. How do I go about doing this?
LINQ
from t In tblTimes
join h In tblEngineeringDashboard_CADMachinesCounts on t.ID Equals h.TimeID
Order By t.Period
[code].....
I am using the following code to alter an table imported from an Excel spreadsheet
Dim SQL As String = "ALTER TABLE receipts ADD payee integer, account integer, category integer, reconciled boolean"
Dim dataread As New OleDb.OleDbCommand()
dataread.Connection = Connection1
[code]....
Both ExecuteNonQuery() actions yields the exception message {"Syntax error in field definition."}The error message does not happen with the first if the boolean column is not there (I tried Tes/No as a definition - but that also failed.The second query to modify the ID column from autonumber to integer I assume fails because it is a Primary KeyHas?
Imagine the following scene: I have one table which have tree columns (ID, Number, Name).
A Select query result on this:
code:
Now, the user deletes the Number 3 and 4. So, now the Select query is going to be:
code:
And I want to have:
code:
How can I organize the column?
an aspx page where a user can upload a file to the webserver, and then then webserver can bind the csv file to a grid view, and allow the user to mark what fields are what.here's my code to bind the csv file:
uploadFile = CType(Session.Item("uploadFile"), String)
Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
& MapPath("~/upload/data/") & ";
How do you make columns in a label? [url]....
View 6 RepliesI've the following code which successfully makes an average for all the columns from a table. What I need to do though is ignore certain columns in this equation.
Dim totalNumber as Double = 0
Dim count as Integer = 0
For x = 0 To xyz123.Tables(0).Columns.Count - 1
[Code]....
Averaging columns in a table - ignoring certain columns
View 2 RepliesCreate a generic label method:
Public Function buildBasicLabel(ByVal labelName As Label, ByVal text As String, ByVal font As Font, ByVal align As Integer)
Dim tmpLabel
[Code]....
For some reason, the label is not lining up with the others once I span it. I'm trying to span it to get all the text to show but once I do, it starts pushing it over. I don't see anywhere where I restrict the size so that shouldn't be the issue.
I tried doing all this in the design and it works just fine. Mimicking the designer code doesn't seem to fix it either unless I'm doing something seriously wrong...
Posting images for clarity. NOTE: The borders are just to show the label alignment and the text should read "Flat-Footed AC"
IMAGE 1: Spanning 1 column (doesn't show all text)
IMAGE 2: Spanning 3 columns (still doesn't show text and you can see it's starting to dis-align)
IMAGE 3: Spanning 6 columns (Still doesn't show text and greatly dis-aligned. It should at least show all the text)
I have a datatable property called prpParametersTable in a class called clsBatch. I have a procedure that sets a datatable variable called dtP equal to prpParametersTable at the beginning of the procedure. I then add three new columns to dtP.Here is my problem. When I add the three new columns to dtP my original table prpParametersTable also gets those columns added to it, why? I only want to add the three columns to dtP and not prpParametersTable. How can I do that?
Private Function prvfnc_InsertBatchParameters(ByRef cnn As SqlConnection, ByRef trans As SqlTransaction) As String
' set new columns that have BatchID, Insert DateTime, and UserID for the SQLBulkCopy method below
Dim clm As DataColumn
Dim dtP As DataTable = clsBatch.prpParametersTable
[code]....
I have Dataset ds filled up with values Until now I was displaying values in GridView. Now I want that all the rows should be columns and columns should be rows.I have 2 options: Either 1 I can directly convert grid to columns and display it, or 2 I can convert the GridView to html and then write loops to convert. I was trying the 2nd option but I cant figure out how I should do that.[code]With this code I am still getting same as GridView. Please help me for converting rows to columns and vice versa.
View 1 RepliesI have a CheckedListBox that will be used to choose what columns they want to select from a database. Is it at all possible to display it in the format of [Table Name].[Column Name]?So far I have this:
con.Open()
theQuery.Connection = con
theQuery.CommandText = strColumns
theAdapter.SelectCommand = theQuery
[code]....
I tried adding another clbFields.DisplayMember, but this obviously just overwrites the table name with the column name. I also tried doing:
clbFields.DisplayMember = "Table_Name" & "." & "Column_Name"
but that didn't work either.I know it's not exactly life threatening if the user can only see the column name, but it'd be nice to be able to see the table name in case of any duplications?
I have some data and would like to add certain columns into a list. So if my data is
[Code]....
Although the code works, im wondering how i could relate the director to the movie with the two list types i have?
i have a datagridview table ("Bookingen") that is bound to an acces datatable
this table ("Bookingen") has columns
an i also have another form that alows people to add info like a registerform
what i would like is that when adding the info by button click
a column with the name of the person from registerform displayes in datagridview ("booking")
this my code so far
Public Class nieuw_personeel_invoer_code_
Private stroledb As String = "SELECT* FROM Loginnummer"
Private strconnection As String = "provider= Microsoft.ACE.OLEDB.12.0; Data Source=D:clifs project21.accdb; persist security Info=false;"
[Code].....
I'm having problems with adding columns to listview. [code]....
View 1 RepliesHow can i add Columns to Treeview so that first column should be as tree and rest are like listview or Listbox.
View 12 RepliesHow can I get a sum for all the columns in a datatable? Say I had the following table. How can I calculate the "total" row? It should be easy to add total row to a datatable.
Columns hits uniques sigups, etc...
Rows
1 12 1 23
2 1 0 5
[Code].....
Textboxes are arranged in a 5x5 matrix and each text box is only restricted to either a "1" or "0" input. I need help in the code that will count all 1's in each row and column. Since this is a 5x5 arrangement, there are 5 rows and 5 columns each. I am actually making a simulation of a VRC/LRC program. There will be 2 buttons namely "Even/Odd Parity". If user presses Even parity and the number of 1's in that specific row/column is Even, the result will be a 0,If odd the result is 1. There is a result textbox at the end of each row/column.
View 1 Repliesis there an easy way to make the size of a datagridview expand dynamically (like say it is not long enough to display all the data it will grow in width), or do i have to implement this functionality manually?
View 3 RepliesI want to get two rows out of 6 columns in datagrid from database out of 6 columns so kindly give me a query of this programme but give me linq to sql query
View 2 RepliesWhen using a listview with several columns.
How do I for example get data from the second line and column 3?
I have a ListView with 3 columns, I know how to add items to the first 2 columns, however how do I add an item to column 3? The code below adds a result to column 2 but I cant work out how to add a result to column 3.[code..]
View 3 RepliesSQL SERVER 2005, Table1 has data as follows
Date----------sno----------name
14/01/10------1-------------A
14/01/10------2-------------B
[Code].....
With a standard MSFLEXGRID control you are able to get the number of rows/columns of the control. I am not seeing anything like this for the Hierarchial flexgrid control. Am I missing this, or is there some roundabout way to get the same function?
View 5 Repliesi have a printing code which prints a listview however if a listview contains many columns it cuts the columns and will not print all the columns needed
View 3 RepliesUsing the ListBox1 properties I tried to set the number of columns to 2 but could not do it.
View 2 RepliesI'm sure this has been asked here before but i couldn't find it, anyway my issue is i have filled a dgv using a LINQ query and i need to sort my results by 2 columns, i.e. type and cost so that it lists items by each type in creasing cost[code]...
View 10 RepliesI'm using the follow code to grab values when a row is selected on my datagridview:
Me.DataGridView1.CurrentRow.Cells(0).Value
in this case for the first column. I am doing this for several columns. What I would like to do is switch to specifying the columns by name so the code won't have to be changed if columns are moved around. I have tried several things that didn't work. Can anyone supply me with the code to retrieve the value of a column on a selected row by the name of the column?