I try an update but I get an error"The Index was out limits.I shouldn't be negative and should be smaller than size of the collection" This concern this line in debug "Dim courseId As String = gridViewCourse.DataKeys(e.RowIndex).Values("CourseId").ToString()" This my grid asp code
[Code]...
I want to add the ability to post images to facebook or Flickr in my app.Basically, they just browser for the file using an OpenFileDialog to get the path. Then they click an 'Upload to Flickr' or 'Upload to Facebook' option.how to do the upload to facebook/flickr part? How is it done?
View 1 Repliesi have a datagridview that is pulling information from a access database. The tables being queried is called "History" I can pull data and update data with no problem, however if i edit the date field i get the following error "Syntax error in UPDATE statement" my code is below.pulling from access
[Code]...
I have a search form on that will be pulling search template queries from a table in the underlying (an Access db on a share). The search form has a calendar control for filtering by date range, a listbox containing the names of the search templates, a second listbox which lists the fields in the selected template, and then some controls which show/hide themselves depending on which field is selected so that the user can pick a field and enter it's unique criteria in the appropriate control for filtering. Below these controls is a DataGrid, which will obviously display the results.
The problem is how to dynamically "transform" this DataGrid to display the selected search template. These templates do not represent tables in the underlying; rather they represent preconstructed SQL queries (stored in a table) which are essentially SELECT queries with joins and no WHERE clause (so they are the results of multiple tables joined together by their keys).
To be honest, I'm having trouble even generating the LINQ queries to represent these template dynamically, but that's not as important, since I can manually translate the SQL queries into LINQ. This is definitely not the preferred method, as the whole point of putting these templates in a table, rather than code, was to allow for future additions without rebuilding/redistributing the application interface.
I have a custom dgv column and custom cell.I m trying to instance the column and pass it an instance of the cell as a template, but it's not working.my code needs a form with a button and dgv on it. When the button is click, the text in cell(0,0) should toggle from on to off. [code]
View 2 RepliesI have a vendor application which is precompiled. I want to add a template column into the aspx page, however I'm having some difficulty.This works for me fine as "Available" is a column bound to the asp DataGrid:
<asp:TemplateColumn HeaderText="test">
<ItemTemplate>
<asp:Label ID="Label2" Text='<% #DataBinder.Eval(Container.DataItem, "Available") %>'
[code].....
I have a datagrid who's ItemsSource is a strongly typed IEnumerable object In this datagrid, I have a checkbox column, a price column, a part name column, and a 'total selling for' column. On checking the checkbox I need to update the total selling for column with the value in the price column. This part I have working, however, how can I get the checkbox to remain checked when this happens?
Private Sub UpdateSellFor(sender As System.Object, e As System.Windows.RoutedEventArgs)
Dim _CB As CheckBox = DirectCast(sender, CheckBox)
Dim _ID As Integer = _CB.Tag
Dim _PP = DirectCast(DG_PartsToSelect.CurrentItem, PartTyping).PartPrice
[code]....
It seems that on clicking datagridview column header, the column will be automatically sorted based on the column type. I have a column showing some numbers. If column type is string, it sorts "1","20","3" into "1","20","3". If column type is double, it sorts into "1","3","20" which is the result that I want. However, there might be some erros in the numbers and error messages(text) will show in the cell instead of numbers. So I cannot set the column type as double. I want to ignore these error messages and sort all the numbers. How can I do this?
Also, I need to add some background colors to different rows in datagridview. So in the column header click event, I call the bkgColor Sub to achieve this. My question is that how can I override the sorting method in this event?
Private Sub DataGridView1_ColumnHeaderMouseClick(sender As Object, e As System.Windows.Forms.DataGridViewCellMouseEventArgs) Handles DataGridView1.ColumnHeaderMouseClick
Try
[code]....
I have a datagrid that I am unable to change the width setting, it always reverts back to the original setting.
To change this setting:
1. select the datagrid view tasks
2. Edit columns bound column properties
3. Select Width property
4. Width property will always revert back to the original setting.
I have check the properties settings without any luck.
In VB.NET,I want to create template at runtime and save it the template with name. for ex : Administrator design a page with 5 fields like using firstname, lastname, dob,nationality and job. He want to assign this page to the user with some restriction like user1 need to enter the all the fields and save it the forms as user1profile, but user2 need to enter only firstname and lastname and save it as user2profile.(in features, he can remove the fields from the form).
View 1 RepliesI'm working on my first T4 code generation tool to add some Stored Procedure helper code to my project. I've created custom types (e.g. StoredProcedure and StoredProcedureParameter to help with my code generation and have included the assembly and namespace references in my code:
<#@ template debug="false" hostspecific="false" language="VB" #>
<#@ output extension=".generated.vb" #>
<#@ assembly name="$(TargetPath)" #>
<#@ import namespace="StoredProcCodeGenerator" #>
This allows me to use my custom types in my T4 template code. However, because my custom types exist in the same project as the T4 template code, I can't recompile my project once I run the template code without restarting Visual Studio. This isn't very much fun.
I read a great article that addresses this exact issue by using the T4 Toolbox, but it's not working. Either I'm implementing the VolatileAssembly directive wrong or the T4 toolbox simply didn't get installed. I'm not sure that the toolbox got installed correctly (I'm using VS 2010 on Win XP).
I'd like to get the value of a column from a datagrid and insert that to a table. I get an error "Object reference not set to an instance of an object."
Here's my code:
Imports System.Data.SqlClient
Imports System.Data
Public Class Class1
[Code]....
The thing is -- when I look at table amtdue, everything is actually saved there. I just don't understand why I'm getting the error, and so I can't proceed with what I have to do after clicking the btnaddtocart button.
I need to add some columns in the DataGrid view at run time. I have nearly 12 columns in the DataGrid and I need to add 5 columns fully from top to bottom and show the sum result at last column. How can I do that?
View 1 RepliesI have a issue with updating a row in a DataTable. I can initially create and populate the data table. But I am unable to update a row. I have found examples of datatabe connected to database ETC. Looking around I see reference to LoadDataTable but I can not find a way to make PmaDataTable. LoadDataRow() work.[code]
View 6 Replieshow to update the sql database from the gridview without having to add a primary key to the table,like when the user finishes updating the datagrid it will go delete the sql table and replace it or read with the adapter and fill the rows i cant find a way for this its not making sense to me i wrote a code i am sure its all wrong i am trying to return all rows values from datagrid
For i As Integer = 0 To DataGridView1.Rows.Count - 1
For Each column In DataGridView1.Columns
For j As Integer = 0 To DataGridView1.Columns.Count - 1
[code]....
what is the use of adding new columns to datagrid view? [code]if we can't add / update these columns to databse ?
View 1 RepliesI have a database and a dataset as the image shows in the link, how would i add the values of the colums "amount1" and "amount2" for every row and entry as the user make entries to be automatically displayed in the "total" column. Meaning that every time values are entered in those amount columns, they will be added and the total displayed in the "Total" column.
[URL]
I want to change datagrid first colomn value with some . or $ BUT when user clicks on first colomn then we need its actual value
Using : vb.net (Desktop development)
I am retrieving data from a table and displaying it in a datagrid, how can I make the columnwidth variable depending on the size of the text field being returned and do it in the code ?
View 3 RepliesAny way to access a specific column and row of a datagrid generated by a sql-query in visual basic. The datagrid looks, simplified, like this:
Column1 Column2
Data1 Data2
Now I would need a function, that reads data2 out in visual basic (asp.net web).
i want to ask about the check/uncheck the checkbox in a column in datagrid.if all row in the checkbox column is not selected, what is the code is.because i want the msgbox appear if the user not check any row.
View 17 Repliesi got a datagrid connected to sql...my problem is i have two columns which is grade and evaluation i need to do is.. if grade has a value of 1-3 print passed and 4 above will print failed a string will be printed in evaluation column here is my sample code of mine.. which didnt work..
[code]...
this is my code to format column style at datagrid:
Private Sub frmCustomer_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim sql As String = "select cust_id,cust_name From inv_t_Customers order by cust_id"
[code].....
Using SQL Express 2008, I have tables with the following columns[code]...
View 7 RepliesIs there a way to sort a datagrid by one coloumn and then by another? For example by column 1 then by column 2. I have managed to sort it by a single column, however this doesnt give consistent results.
View 12 Repliesis it possible to have a datagridView in which each column can have diff no of rows in it?
View 1 RepliesI'm having some trouble to formatt a datagrid column. At the present time the data column is displaying "o1-13-2009" I would like it to display JAN-13-2009" Here is my code
[code] Dim notecolumn3 As DataGridViewColumn = Me.CustomerNoteGrid.Columns(3)
notecolumn3.Width = 65
notecolumn3.DefaultCellStyle.Format = "MMM-dd-yy"
well can you get the average sum of datagrid column ?
View 7 RepliesCan we make a particular column in DataGrid to behave like text box AutoComplete mode?In the GUI, am planning that the user will select a ProductName and will enter the details in the datagrid.The problem I am facing is am not able to set datagrid column to AutoComplete.If I use Textbox or Combobox for the purpose, am not able to enter the selected content into the datagrid because the datagrid is binded to a dataset.
View 6 RepliesHow to assign value from a listbox into a column of a datagrid?
When user press Enter by placing the cursor into a particular column, it will display a listbox holding data values.
Now i need to assign the value that i click in the listbox to the datagrid column. how could i achieve this?
