I load a 47,000 line Text file into a Datagridview, not a problem at all.
I would like to get the Distinct values for Column1. I have been scratching my head on how to do this, I have not as of yet found an easy way to do this,
I have a gridview which returns a number of columns, sorted by date.If possible I would like to display each distinct date only once. So, for example, if there were 5 records for 18/06/2009 and 3 records for 19/06/2009, they would be displayed as follows;
'Date Name
'18/06/2009 John
'<no date here> Mary
'<no date here> Susan[code]......
I am trying to distinct on multiple columns and get datarows from datatable. but getting error.
Dim query As IEnumerable(Of DataRow) =
(From row As DataRow In SourceTable.AsEnumerable() _
Select row.Field(Of String)("ColumnName1"),
[Code]....
I want another datatable with distinct row based on given columns from SourceTable.
I have a DataTable with about 64 columns, including "UserAnswer", "CorrectAnswer", and "QID_Lookup". I am building a LINQ that will select all the rows that have a correct answer (user answer matches correct answer), but I only want to select rows that have distinct "QID_Lookup".
[Code]...
The problem is that the result set includes duplicate QID_Lookup values. How can I include only distinct QID_Lookup values? keep in mind that there are 64 columns, so if I can avoid it, I wouldn't want to list each column individually for selection.
I need to get a list of distinct names inside the data table and the sum of values for each one. I know some basic stuff about linq, but i don't know how to put the distinct and the sums together.
The SQL Query:
SQL
SELECT DISTINCT username,
[Sum1] = SUM(day1),
[Sum2] = SUM(day2)
[Code].....
I have a DataTable "dt1" that has thousands of rows.
Columns are:
- Type_And_Model
- Val_1
- Val_2
- Val_3
- Val_4
There are only about 30 different "Type_And_Model"-types.How can I insert into a new DataTable (dt2) only distinct "Type_And_ Model" types with the sum of their specific values and total appearance number?
dt1 - DataTable with thousands of rows
Type1 2 2 5 5
Type1 4 2 7 5
Type2 2 2 5 8
Type1 2 2 9 5
Type3 3 2 5 5
Type1 6 2 5 7
Type3 2 7 5 9
Type1 8 2 9 5
.....
INTO =>
dt2 -DataTable with disinct types and their sum values + appearance numbers.
Type1 22 10 35 27 5
Type2 2 2 5 8 1
Type3 5 9 10 14 2
i want 2 select data from data gridview and want retrive that data into another form in to the textbox ...is it possible ? i 'm doing like this for that
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.[code...]
How to print data from datagridview in tabular form?
View 2 RepliesI have a gridview which generate a link based on certain condition inside the Grid from code behind. What I want to achieve is when I click on that link, I want to catch all the information from the row that the link is in. So for example, if row 1, 2, and 4 has links in cell 5, When I click row 1's link, I want to get all the cell value from row 1. When I click on row 2's link, I want to get all the cell value from row 2, etc. I am somewhat close but not quite. When I click on row 2, I still get the same value from row 1, same as when I click on row 4, I get the same value from row In short, I want to get the row's value based on the link that's in the row. Here's my code:
$('a.SendEmail').click(function(e){
var Name = $('#<%=GridView2.ClientID%> td:eq(1)').text();
var Id = $('#<%=GridView2.ClientID%> td:eq(2)').text();
[code].....
I have developed an applcation using vb.net 2008, its a windows based Application. I read data from SQL and show them with DataGridView . I want to colored some of rows that have specific characteristics .[code..]
View 6 Repliesi am using asp.net.In my gridview control i have a column called "TotalAmount".The total amount in this column is to be calculated.How can i do this?
Like this:-
Col3(TotalAmount)
30
40
30
Total Amount=30+40+30=100?How can i calculate this 100?
A datagridview control that bounds to ms access database.
I am adding more rows to gridview control. How can i save these data to database?
I am trying to loop through the rows of my gridview and retrieve the data key value of each row and then execute some code to run sql queries. How can I get the data key value of each row in variable? right now I am receiving an error message saying:
value of type system.web.ui.webcontrols.datakey cannot be converted to integer.
Here is my code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
For Each row As GridViewRow In GridView1.Rows
Dim therowindex As Integer = row.RowIndex
[code]....
i use this command to display data from my ms access database table, but, it is not working
[CODE...]
I have a form consisting of datagridview and two buttons of update and load all.. I have used fillby method to obtain data from database. The query seems to be working fine, except that the data is not shown in the gridview. As in, for the qeury, if the returned rows are 2, it will show 3 rows in the gridview, but all empty.
Imports System.Data
Imports System.Data.OleDb
Imports System.EventArgs
Imports System.Data.OleDb.OleDbConnection
Imports System.Data.OleDb.OleDbCommand
[Code] .....
I am using visual studio 2008. I have a winforms app that takes data from an xml doc. I store the data in a ms sql database that I have created via a stored procedure. When Irun the app the data from the xml doc is captured and put in the database, but I can only see old data, the data that is captured during the current session can not be seen unless I close the app down and restart it. I have tried the following, and every variation I can think of to allow me to see the new data but to no avail.[code]
View 4 RepliesYesterday I attempted to add some code to turn one of the cells a different colour diring databinding method. When I added that code and debugged, my gridview stopped showing data.
So I took the entire method OUT...
Now my gridview does not display even when I put a STOP at the page load method, and it shows the gridview AND SQLDATASOURCE as having rows.
My gridview is showing more than one ProductName column and the ProductID column as well.All I want it to show is the Product Name clickable column.
<asp:Content ID="Content2" ContentPlaceHolderID="body" Runat="Server">
<br /><br /><br />
<asp:linkbutton id="btnAll" runat="server" text="ALL" onclick="btnAll_Click" />
[code].....
iam using C# winforms and SQL as backend in VS 2005 i want the data in the datagrifview to be printed when i click the print button for that
View 2 RepliesI have a gridview which generate a link based on certain condition inside the Grid from code behind. What I want to achieve is when I click on that link, I want to catch all the information from the row that the link is in. So for example, if row 1, 2, and 4 has links in cell 5, When I click row 1's link, I want to get all the cell value from row 1. When I click on row 2's link, I want to get all the cell value from row 2, etc. I am somewhat close but not quite. When I click on row 2, I still get the same value from row 1, same as when I click on row 4, I get the same value from row 1.In short, I want to get the row's value based on the link that's in the row. Here's my code:
$('a.SendEmail').click(function(e){
var Name = $('#<%=GridView2.ClientID%> td:eq(1)').text();
var Id = $('#<%=GridView2.ClientID%> td:eq(2)').text();
[code].....
[URL]
I have a GridView, named GridView1 used to getting data from SQL Server Database, because the data from database always changing, I would like to get the new data to display on the GridView1 when a user press the "Fresh Button"
I tried:
GridView1.Refresh() - did not work
Me.Refresh() - did not work
Me.Hide() then Me.Show() did not work
[Code]....
I need to loop through a gridview to then compare it to my database.this is what i have now:
Dim rows As Integer = gwResults.Rows.Count()
For Each row As GridViewRow In gwResults.Rows
'move through rows and check data in each row against the dataset
cSource.GetDetails(Convert.ToInt32(row.Cells(1).Text))
Next
is it possible to get gridview values in each column by calling them by a name, instead of index? so maybe have something like cells("userID") instead of cells(5)i have many columns, and indexes could get really confusing.
am having a little problem with an application form...I have used a DGV to capture data
from textbox and it is unbound from database.I have successfully added some codes and it
works but am having problem when adding new data...Where, when i click on the "Clear"
button to input new data, all the data which was already displayed in the DGV is replaced
by the new data in the first row...all i want is to be able to add data in a new row and
keep the first input...I wanna the app. to display data input in the DGV and then be able
to add new data in a new rowThis is important for me to be able to go to the next step of
the app development.[code...]
Is it possible to update data in Gridview in VB.Net???On Which event we write our update query?????
View 4 RepliesI have a mdi container, that has several forms (childrens), one of those forms has only one datagridview, to show data, from an datatable...Image There're several image columns in the form.
To debug the process i created a new project only with one form and put everything working, and the images in the columns were just fine.
Then i "copied" the code to my application to the mdi children form, but the images doesn't show up.
After spending some hours trying to figure out what i was doing wrong i finally came to conclusion that the problem it's in the form/datagridview, that doesn't paint/refresh the images correctly if the form it's a mdi children...
There's something that i'm missing here? There's some event that prevent or override the images that i set? I need to put this to work, but i don't see how.
I'm working on a shopping cart i have a gridview that loop throuh all record in the database and display on the gridview i add two extra column one for a link when user click on the link it add the product in the shopping cart the other column is a textfield which user should enter the quantity of the item they want to purchase here is my problem i can get the value user enter in the textfield [code]...
View 1 RepliesI have a Master Page with nested pages in ASP.NET. Fairly simply I want to databind some hyperlinks to a gridview for the master page. This however is throwing a null reference exception when I try to set the DataSource.
I tested the code on a separate page and it works as expected. When debugging I can see the Page_Load Sub hit twice, I don't know if this is the cause I have one nested page being loaded, this is a blank page at the moment
EXCEPTION
Object reference not set to an instance of an object.
MASTERPAGE CODE BEHIND
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[Code]....
Alright, so here's my basic ASP.NET page setup: I've got a page with a GridView that has ContentTemplates in it. You can add a row and edit/remove rows at any time. There's a "New" button that creates a new row.
All of this data is bound to custom data objects. So if I have a GridView of "People" and each row has "FirstName", "LastName", and "Gender" (with TextBox and DropDown controls), I then have a "Person" object which has public properties for "FirstName", "LastName", etc. I have the binding set up correctly, and I can push data into the GridView from the object, and I persist the object with the Session variable. My page lifetime structure looks something like this:
Page_Load: Loads the List(Of Person) from Session()
Any events fire, and modify the List(Of Person).
After any event, the List(Of Person) gets saved back into Session(), and is then DataBound to the GridView (and any subsequent fields are also DataBound, such as the DropDownList.
My question is: Whenever I fill in rows in the GridView, and then add a new row (there is no database saving going on whatsoever), my fields clear out and don't persist across PostBacks. So, how can I persist my custom data objects with databinding across postbacks?
I've searched everywhere for some example code for this, but I can't figure out how to bind data returned from a function that looks like this to a gridview or dataset.
Public Function GetCompanyList() As IEnumerable(Of BusinessUser)
Return (From companyList In CorporateLists
Select companyList.User).Distinct()
[code].....
I am trying to bind XML data into a gridview, after clicking the 'ButtonSaveToDataBase' button, the method will begin to read data from my gridview and load it into an array of my serializable class type and after that serialize it and finally store it into a XML type field in my SQL. The problem is When I call BindData() at the end of the serialization, it reads the XML from my database and successfully binded it but my gridview displays an empty row below my datas like this:
[Code]...
