Im trying to add data into a new column I have created in my gridview.[code]...
Now I need to go in and add data for the rows below the column. I have seen ppl saying I need to set it equal to a datafield but how do I create a datafield from scratch then?
I want to store additional information about a listview item using a custom class, but I can't seem to get it to work.I'm currently using this code to accomplish something similar using a listbox item.I just want to do the same thing with a listview.
Public Class myListboxItem
Public id As String
Public rootFolder As String[code]....
I forgot to add "Inherits ListViewItem" to my class.I'll update the code listed here to serve as an example for others.
I'm trying to create a "wrapper" DLL to provide additional functionality on top of an existing DLL. Here's what I'm doing, it may be the wrong approach.The existing DLL is basically a .net version of WinSock. It has lots of public methods and events.The DLL I'm trying to create will provide specific file processing methods, and notification events, which will then utilize the WinSock DLL totransfer the files. This wrapper Dll is intended to encapsulate all of DLL #1 methods and events.
So what I'm doing is having my new DLL reference the existing one, and create a new set of events, some of which get raised by handling DLL #1 events.So I end up with two DLLs, one of which is dependent upon the other. When I try to use my DLLS in a Forms app,I am able to use my wrapper to call methods in the WinSock DLL. Some events that are raised within my wrapper are properly handled by the forms app.The events that do not work (get raised) are the ones which are raised by handling the other DLL's events.This seems to be because the WinSock DLL's events never get raised, when they apparently should be. The WinSock object in question was declared as "WithEvents".
Is it possible to change the data source of a dropdown list in a gridview from another dropdown list selected index changed method in the same gridview
View 2 RepliesI was having a heck of a time populating a gridview combo box.I learned a ton in the last 48 hours but would really like to know the answers to the bottom three questions.You guys are the experts, so I'm hoping you will enlighten meBut the summary of it is below:I was never able to get the ComboBox to bind to the data source. I tried everything until I turned blue. So I went to the basics and coded all the automatic stuff. I'm curious as to why the automatic binding didn't work. Perhaps its because my gridview datasource was LINQ.Here is how I pulled it off. I hope someone down the road benefits from the last 48 hours of my delima:First of all, know that I have two drop down lists on my form, one is the GPField and the other is the BankField. These are already populated DDLs that are static. So I used them to cheat on the values instead of using enums.
Sub fillGPFieldListDDL(ByVal obj As Object)
Dim db As New CompanyDataDataContext
Dim myConn As New Connection With {.ConnCls = ConnCls}
[code].....
I have created a site in VB.Net and ASP.Net where a user types in a centre code and clicks on 2 buttons to retreive 2 GridView's of records from an SQL Server backend database.
View 1 RepliesI'm looking for a solution to implement in web apps where I have the option to see a print preview or print either a gridview, datagrid, or datatable or export it to word or excel. What's the best method to do this or has someone written a class that does this, and does it well (I've seen many examples, but many still have errors)?
View 1 RepliesI'm developing a user control that exports a grid view to many file formats, this control takes the gridview as a property, I need a code that returns the gridviews in the form if so that in design time user can choose one to export
View 3 RepliesUsing DevExpress 10.2 within Visual Studio 2008 with VB.Net I have created a single gridcontrol that contains two different gridviews. The gridviews are related using an id column. Basically if there are related details about a row in the first gridview then the user can click on the plus sign to see all the related details. When I have any row on the first gridview I am able to get the focused row. Yet when I have the focus on any of the rows in the second gridview I am unable to get the focused row or the content of the row.
[Code]...
Is there any way to get the value in id from the focused inner gridview? Or at least figure out the parent row and grab the id value from there?
When I have changed the name of a table field name none of my combo boxes or grid views work properly. The TableAdapter still refers to the original name. Is there an easy way to make the change propergate through the program or do I have recreate all my TableAdapters.
View 5 RepliesI've created a Gridview control that pulls some data from my database, but doesn't display all of the information I'm hoping it gathers. I choose not to display the primary key for user interface purposes, but require that key for basic operations on the grid.I'm currently attempting to add a "Delete" option to the table, but unfortunately I'm having very little luck. Here's my .aspx file.
<asp:GridView ID="ManagerList_GV" runat="server"
AutoGenerateColumns="False" AllowSorting="True"
DataKeyNames = "ManagerID" OnRowEditing="editManager"
[code].....
I am currently programming within Visual Studio 2010 using VB.Net and DevExpress V10.2 Winforms. I currently have a DevExpress GridControl that contains two DevExpress GridViews.So there is the main view and the subgrid (similar to the DevExpress demo for Master-Detail Grids - example with WinForms and better view with ASPxGridView). Currently the data for the grid is fetched into a DataSet:
If myDataSet.Tables.Count > 0 Then
myDataSet.Relations.Add("Details", myDataSet.Tables(0).Columns("id"), myDataSet.Tables(1).Columns("id"))
[code].....
I know how to create an array and loop through it normally - but what if I need a multi-column array. e.g. usually I might do something like:
For Each row in NameofArray
Dim name as String = row
Response.Write("Hello " & name & "!")
Next
But what if I want to do something like:
For Each row in NameofArray
Dim name as String = row.name
Dim age as Integer = row.age
Response.Write("Hello " & name & "! You are " & age & " years old!"
Next
If this isn't possible with an array?
I am using this method to create a csv file using vb.net.
protected void btnExportCSV_Click(object sender, EventArgs e)
{
Response.Clear();
[Code]...
This code is creating csv file. But i dont want any extra column in csv.
i've create a datagridview with two columns, one textbox and the other checkboxes. The chekcbox column has a check box in column header aswell.
When i resize each column the checkbox column speciallly the checkbox in the column header, does not align with the checkbox column, it even goes in the textbox column as well. How do i fix this column resize issue?
I am using data grid view in Windows Form standalone application to display items as excel spread sheet in VB.NET. I got a table named CostTypes with column names [CostTypeID, CostType] and values [1,External] and [2,Internal] (These are constant but more values can be added to table).
I want to create columns with names of the values[External , Internal] in DataGridView. If I use databiding directly I get columns [CostTypeID,CostType] which is not what I am looking for.
I have text file that is saved as comma delimited. There are 3 columns with x number of rows. I cannot seem to figure out how to create an array that will store all three columns with the variable intProductArray as the length of the array. I have been opening the file with only one column and putting it into a textbox and using the lines of the textbox as the variable for length. I cannot figure out the array for all 3 columns.
Private Sub btnChoose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnChoose.Click
Dim myFileDlog As New OpenFileDialog()
myFileDlog.InitialDirectory = "c:"
myFileDlog.Filter = "All Files (*.*)|*.*" & _
[Code] .....
On runtime about the number of columns to show (mainly remove columns that are available and then shift the remaining columns).. I can view the reports in a report viewer normally all I need is to be able to edit the columns in run time.
View 1 RepliesI have a Datatable consisting of columns with Latitude and longitude I want to be able to pass through each of those values in each row into an array that can then be passed through a function which gets the distance between each row and a static. In short I am trying to get distance between one location and various others that reside in a datatable that will vary in size. Right now with this existing code I am getting 6 different locations into an array:
HTML
Public Function GetCoords() As Coord()
Dim myCoords() As Coord
myCoords(0).Lat1 = CDbl(list1_Lat.Text)
myCoords(0).Lon1 = CDbl(List1_Lon.Text)
[Code] .....
If I am on the right track I think I need to create a new array that will accept Lat and Lon from each row in my Datatable? My end goal is to be able to find properties within a certain distance of a property. In other words "return all properties that are within .25 miles of 12 Maple Street". I thought if I had Lat and Lon of a certain property there would be a formula that would give me the max and min Lat and Lon to be within a .25 mile radius. I have searched for how to get a radius, but didnt come up with anything I could comprehend. So instead I thought I would just get each properties (row) return the distance in a new column then loop through the table to return properties within the desired distance .25 miles etc...
I need to build an interface that allows the user to select a horse from a list. The horses are as follows: horse1, horse2, horse3 and horse4. The application should display the way the horse places with a 1 means the horse won, 2 indicates second place , 3 indicates third and 0 indicates the horse did not place. Application needs to display a summary of each horse's individual performance as well as the performances of the other horses. Table for keeping track of each horse is as follows:
5 races-how each placed
1 2 3 4 5
horse1 0 1 0 3 2
[Code]....
I want to create two columns of checkboxes but only the first column is being displayed.
[Code]...
I want to select column 'F1' from an excel spreadsheet and dump the data into my datatable 'oleDT'. How do I map the column F1 to the column i've added called 'colTest' ? When i call Fill, the dataTable has 2 columns, which are 'colTest' full of nulls and a created column called F1.[code]...
View 1 Repliesi would like to ask if how do i create a column of picturebox.. something like a thumbnail, with a specified number of columns inside a form.. the number of picturebox depends on a variable.. has anyone done this?something likeimage1 image2 image3image4 image5 image6
View 2 RepliesI have a class that add extra information about a column for linq2sql (see code below) right now, I have to explicitly tell what column I want that info on, how would you put that code with a loop on every column in every table from a dbml file? I was doing my test on a very very small DB, now I have to implement it on a much more bigger database and I really don't want to do it manually for every tables/columns it will take hours.
how it's being used:
Partial Class Contact ''contact is a table inside a dbml file.
Private _ContactIDColumn As ExtraColumnInfo
Private _ContactNameColumn As ExtraColumnInfo
Private _ContactEmailColumn As ExtraColumnInfo
[Code]....
Ok, what I would like to be able to do seems simple enough. I would like to be able to create an Excel document with a series of columns that contain data to import into Visual Basic 2008
[Code]...
I'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?
