I wish to be able to instantiate my Cell class while naming the cell instance with such name as "A", "B", "C", etc. just like in an Excel spreadsheet.
I have my Cell class like so:
public class Cell {
public Cell(Range nativeCell) {
NativeCell = nativeCell;
[Code].....
I would need to generate a name based on the alphabetic letters and double and triple them once I encounter the last alphabet letter 'Z'. The algorithm would have to generate the letters that I would concatenate with the rowIndex value that would result to this naming strategy such as Excel.
i am having trouble putting a value in a textbox. Each time a ticket is sold i put the total price in a textbox, each time a ticket is sold for the same concert it increases by adding its self to the total price. It works at the first sale, but after that it breaks down. here is the code
Private Function DisplayMoneyTaken() As Integer Dim totalMoney As Integer 'open the database connection
How can i get the Column Index and the Row Index when I click on the ListView?The ListView1.FocusedItem.GetSubItemAt(e.X, e.Y).Text function only gets the text of the first column, I can't find the option of getting the Index of the Column and Row upon clicking.
Is there a way to find the column index of a datagridview column using the columns DataPropertyName?I currently use a loop (shown below in the class) which is kind of ugly, but it works. I'd like to do something like this, which seems more elegant.My goal is this, I store the users DataGridView column settings (i.e. DisplayIndex, Visible, & Width).When the user opens the form that contains the datagridview I want to get those settings from the database and apply the settings to the datagridview.[code]
How to implement like "Textchanged" in Datagridview. For example, when user insert mark in column 3(Mark), then the gred will automatically appear in column 4(Gred) based on mark in column 3. Let say user enter 95 in column 3, then gred A will appear in column 4.[code]....
Is there a way to implement a new column with a header in a checklistbox in vb.net? I've done a bit of searching, but didn't find much on the topic. Should I just abandon the quest and use a listview or some other control?
I have a DataGridView containing a large number of columns. I want the users to be able to select multiple columns and then select a menu item to hide the selected columns. For example a user might selected columns 5 through 10 and I want the program to hide those columns. I know how to hide columns, one at a time. I can get the count of selected columns but I have not figured out how to get the index to the left-most selected column. Trial and error is such a slow process.
Considering the huge number of options offered by the DataGridView tool, it would be nice if this forum had a special category for the DataGridView (common to VB and C#).
Finally I got the desired results but it took a lot of coding, looping through the selected cells to find the one with the lowest column index, then a second loop to count previously-hidden columns, then a third loop for hiding the selected columns, stepping past previously-hidden columns and declining to hide frozen columns.
I want to perform some simple auto-formatting to the cells in my GridView. So far, I have the following code:
Private Sub gridviewRefreshPanel_RowDataBound( _ ByVal sender As Object, _ ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) _ Handles gridviewRefreshPanel.RowDataBound
In a DataTable object, is there added overhead to looking up a column value by name thisRow("ColumnA") rather than by the column index thisRow(0)? In which scenarios might this be an issue. I work on a team that has lots of experience writing VB6 code and I noticed that didn't do column lookups by name for DataTable objects or data grids. Even in .NET code, we use a set of integer constants to reference column names in these types of objects. I asked our team lead why this was so, and he mentioned that in VB6, there was a lot of overhead in looking up data by column name rather than by index. Is this still true for .NET?
I have datagridview with XSD as the binding source (i configured it with the smart tags). After build, the dgv change its columnIndex which surely result error of my code.
For example
columnIndex(0) = idEmployee (dataGridViewTextBoxColumn) columnIndex(1) = name (dataGridViewTextBoxColumn) columnIndex(2) = status (dataGridViewCheckBoxColumn) suddenly, the columnIndex(2) moved into columnIndex(0)
I am trying to sort a column in DGV as follows: DataGridView8.Sort(DataGridView8.Columns(0), ListSortDirection.Ascending) However, I want to use the name of the column and extract the index number in the first parameter of the Sort method. However this fails: DataGridView8.Sort(DataGridView8.Columns("Date").Index, ListSortDirection.Ascending)
When I right click on ultra grid view or may be grid view. I want to display different contextmenu strip for different columns. But when I right click I get index of column which I selected not which I right clicked.
Code is as follows: Private Sub DataGridView1_MouseDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles DataGridView1.MouseDown If e.Button() = Windows.Forms.MouseButtons.Right Then MessageBox.Show(DataGridView1.SelectedCells(0).ColumnIndex.ToString()) End If End Sub
In my program I allow to the user to change the columns Display index of a data gridI need to save the new Column Display index in a database so I can use it to display the columns in the order that the user want the next time he opens the form
I'm trying to figure out how to set the index of a combobox column in a datagrid view when I load it from SQL Server. The combobox has a string in the text field and an index in the value field, and I want to set the selected index to match the value to an ID in the row from SQL. Not really sure how to bind it that way.
I need to sort a datatable. I do it with linq this an example
Dim query = From c In dt.AsEnumerable _ Order By c.Field(Of DateTime?)("LastPurchaseDate"), _ c.Field(Of String)("LastName") Descending Dim dv As DataView = query.AsDataView
But my problem is that i need to sort the fields not by passing the name of the column but the index of that.
i have two datragridviewcomboboxcolumn,and two textbox column in a datagridview.each combobox column is binded to separate binding source.
column names are sl_no,col_empname,col_empworktype,Col_Hours etc.and displaymember,datapropertyname,valuemember and for comboxcolumn are col_empname:-emp_name,emp_id,emp_id col_empworktype:-worktypename,worktypeid,worktypeid
I have a datagridview with 3 columns. The second column is a combobox which I want to bind with a dataset. How do I go about setting the column index for it as I am doing something like this.
Problem: Calling a method which uses a cell's value from a DataBound DataGridView. Works as desired without adding an image column.When I add the image column, the method attempts to use the value from column 1 instead of column 2, as the code in the 2nd method below ("findSign") states:
I am getting this error in MySQL on search for keywords. The error: Can't find FULLTEXT index matching the column list. My Database Table is a MyISAM and my dataTypes I am searching are Text. Any Ideas why I would get the above error?
This is something that's been bugging me for a while. Say I have a dgv with several columns and rows of data. Many times while working with the grid, it's necessary to know the number of the column, but all you know is the column header name, or vice versa. Is there any internal command that will return these values, or is there at least a better solution to the problem than making a function that loops through every header name until you find the one you want? It just seems so inefficient.
I'm a beginner in visual basic programming.I want to make login form in vb and i want that after signing in,another form opens with message "Welcome (User name)".This user name will be given at run time. So i just want a guidance in how to implement this thing in vb.
I've created a VB.NET2010 stub service application with a bunch of common features that I'd like to be able to use repeatedly as the starting point for various more specialized projects.
For each spin-off project I want to be able to start with the stub and then rename the service "completely", so that each instance behaves as if it was created from scratch with its own unique name.
I've tried the steps below with limited success; the re-named service builds as wanted/needed, BUT it won't run because I can't add the new service name to the StartupObject pulldown list.
Change ServiceInstaller.ServiceName from stubName to newSvceName.
how when i open my text editor that in the blue area at the top it displays "untitled" but when a file is saved it shows in blue the new title name.im using vb2008?
I am creating the pictureboxes through code in VB, and I am trying to give them instance names through code, since they do not exist in the forms physically (I cannot manually name each one), only when I run my application (using VB 2008 express). The pictures work, they are displayed when I run the application but I need to find a way to be able to call each one because I need to create motion animation for every separate picture object.
Mostly because of reading this site, I'm trying to move away from Hungarian Notation. Or I guess the improper (system) Hungarian.
I can figure out a better way to name most data types, but I don't know what to do with objects. What would be a good naming convention for objects? I use objRS for recordsets now.
