Make DGV Columns Not Sortable?
Jun 10, 2010how can i make my DGV columns not sortable?
View 3 Replies
ADVERTISEMENT
Make A Quiz Result Sortable?
Apr 2, 2009Make a Quiz result sortable? Option Strict On[code]...
View 2 RepliesSortable DatagridView From Stored Procedure Via Web Service?
Sep 9, 2009I've noticed that I can use LINQ to call a SQL Stored Procedure and use those results in a datagridview and have sorting by column automatically included. However, if the LINQ call is done on a web service, it seems like I have to return the results as an array which, when it gets back to the client, doesn't have the interface needed by the datagridview control to do it's sorting. I haven't been able to find an easy way to get the sorting ability back.
I've tried to serialize the result on the web service but the returned type can't be serialized. I tried putting the data context in a common DLL so I could use the Attach functionality but that doesn't exist for stored procedures. I suppose I could make a table in the data context just for this purpose but that will be a pain to maintain. Would I just be better off skipping LINQ and using an old fashioned typed dataset for this?
Asp.net - Making A Listview Sortable When It Doesn't Contain A Layouttemplate And Built In Codebehind
Sep 6, 2011I have a page of checkboxes, I select a few of them, click submit, and go to a second page. on this page, I have a listview that is built using the checkboxes selected on the previous page. Now I'm wondering how i can add sortability to this listview.
In the past I would add CommandName='sort' CommandArgument='column' to the link on the header in the LayoutTemplate. But since my listview has it's header row outside of the listview, this doesn't seem to work. This is what I have so far:
<!-- header row (outside of listview, when I try to put it as a LayoutTemplate in listview i get an error, see below) -->
<table>
[Code]....
I've tried to add a templatelayout in the listview, but that gives me an error on the line that binds the data (listview.databind() ), i'm assuming because this isn't possible.
get a sortable header row on this listview?
Asp.net - Sorting (rearranging Order) Of A Photo Album Using JQuery Sortable?
Feb 6, 2011I have a photo album gallery within my website and would like to allow users to sort the order of their photos within an album. After looking at very different ways I came across this example [URL]... which is exactly what I need. The photo are stored in the uploads directory and details in the database. The images are displayed using the ListView as shown below:
[Code]...
Log / Store Info And Display In Sortable Multiple Column ListBox
Mar 31, 2011I am wriing a vb.net windows application to log and store information. then display it in a sortable multiple column listbox (I personally like FlexGrid by Component One). However... I am not sure how to go about storing the information. Should I go with a .sdf file database, registry, simply storing them in a file, or some other method?
What I need is to be able to:
read/write/delete from it
read possibly up to a 20mb file and sorting it without a lot of lag
be transported to multiple systems and maintain these writes (installed on many systems)
I know I could split up the reading/writing to anther thread. Even to other .DLL's and whatnot. But as for storing. Not sure what the best option is.
Make A Listbox With To Columns?
Dec 26, 2009I want to make a listbox with to columns on it and they both have titles. If you look at the Mozilla Firefox bookmarks window i want it to be like that.
View 2 RepliesMake Columns In A Label?
Jan 8, 2012How do you make columns in a label? [url]....
View 6 RepliesMake A Listbox Have Multiple Columns?
Oct 19, 2011how to make a listbox have multiple columns and for certain columns to be editable.
I thought about using a DataGridView, but I am not linking this to any kind of database.
[2005] Make Labels In RDLC Columns
Feb 25, 2008I want to make labels in RDLC columns. Each label must have his own column in the RDLC report. Does anyone know how to fix this. I put an example as a image!
View 7 RepliesCompare Two Columns And Replace Values In One To Make Them Both Same, Using Macros?
Jun 17, 2010I have list of about 100 names in first columns. and i have list of same people's names in second columns, but both are not same.
[Code]...
If you notice carefully, all five people in column A have their names in column B as well.I need somehow both column showing same names for same people ignoring extra names like Jones,
DataGridView, Set Up Columns, Populate Data Table, Bind, But Not Using Columns Created In Code?
Oct 26, 2011I'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
Add/subtract/divide/multiply Certain Columns And Place The Information Into Other Columns?
Nov 30, 2010My 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]...
.net - Aggregate The Columns To Group On The Period And Sum The Count Columns?
Jun 29, 2011I 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].....
Adding Columns And Modifying Columns In Access Database Using NET/SQL?
Oct 15, 2009I 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?
Organize Columns - One Table Which Have Tree Columns (ID, Number, Name)
May 23, 2011Imagine 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?
Way To Make The Band In The DevExpress Banded GridView Be Invisible If All The Columns Are Also Invisible?
Jan 6, 2012I am currently using a DevExpress (10.2) Banded GridView within my Visual Studio 2010 project. It works great except I was have an area where I allow the user to choose which columns they want visible or invisible. I noticed that if I make all the columns within a band invisible the band still remains and gives an empty column in my grid. I was wondering if there is some way to automatically
View 1 RepliesAsp.net - Averaging Columns In A Table - Ignoring Certain Columns
Feb 21, 2011I'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?
Feb 28, 2010Averaging columns in a table - ignoring certain columns
View 2 RepliesHow To Use Something That Functions Like Label Box But Can Handle Several Columns And Columns?
Feb 18, 2010What 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 RepliesMake Columns In Datagridview Non-editable Or Editable?
Jun 1, 2011How to make some columns in datagridview editable and some columns are non-editable in the same datagridview control??
View 2 RepliesOriginal DataTable Object Has Columns Added When Variable Has Columns Added?
Oct 6, 2011I 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]....
Convert GridView Table To Html Table But Rows Should Be Columns And Columns Should Be Rows
Aug 18, 2011I 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 Replies2 Columns In One CheckedListBox?
Jan 15, 2012I 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?
Add Certain Columns Into A List?
Jan 11, 2012I 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?
Add Columns To Datatable?
Nov 26, 2010i 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].....
Add Columns To Listview?
Feb 19, 2010I'm having problems with adding columns to listview. [code]....
View 1 RepliesAdd Columns To Treeview?
May 24, 2012How can i add Columns to Treeview so that first column should be as tree and rest are like listview or Listbox.
View 12 RepliesC# - Sum Columns In A DataTable?
Apr 8, 2011How 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].....
Count All 1's In Row And Columns?
Feb 19, 2009Textboxes 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 Replies