This code works:
[Code]....
However, how this extra column merge code. I do not want to have a separate column.
Something like:
[Code]....
I want to combine two columns into one column and displayed as ButtonType = "link".
I have a couple of things that are not working with my Gridview:
1) I've managed to display 3 columns in one column (see code above) but the data is separated by commas, how can I display each data item in separate rows.
2) How can I make the data unique, as I have added the distinct command which I configured in my SQL data source
3) I need the rows to not display nulls, but at the moment it isn't displaying the row if one of the columns is null?
[Code]....
I have access to two seperate databases (mySQL) located on two servers. I need to get the data, link the tables on a key field and display the results in a datagrid. My challenge is that if the search criteria changes for the display it affects rows returned from on table and should thus automatically affect the linked table and resulting data returned.
what the best approach would be to achieving this? So far I have set up a dataset with a dataadapter and table for each connection and then linked the tables in the dataset. The problem that I'm having is getting the linked resultsets to work.
On my form I have the datagrid with two Objectdatasources one for each dataadapter and i believe that's where I'm going wrong...
I am retrieving a column from a table using an SqlDataSource in ASP.NET/C#, which contains multiple 'values' separated by commas. I'd like to be able to separate this values into multiple columns in my GridView, and also allow them to update them. Is this easy to accomplish?
View 1 RepliesIn my gridview I want there to be gridlines to separate the columnheaders only, no gridlines otherwise. How would I do that?
View 1 RepliesI am using listview to create a forum (like this website) like page. I want that the first post of a thread should look different than others ( i.e. an item to look different than all others items of itemtemplate).
View 3 Repliesi have 50 rows in the database, i want to load those data from database and show on page using datalist
i set RepeatColumns="6" and RepeatDirection="Horizontal"
so 8 rows will come up. at the end of the last row only 2 data will show.. i want to show that only 2 data in the first row not in the last row.. how i can do that..be aware, i only want to show 2 data in the first row and in second row 6 data and carry on at the end..
I'm making a simple homes classifieds section and when a home ad is created, a HomeID is automatically created for it in the db. I need the images to upload and enter the associated HomeID with each image automatically. What I tried isn't working, because it looks like it's looking for the HomeID in the codebehind before it gets entered into the db.
ASPX CODE
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
InsertCommand="INSERT INTO [Homes] ([UserName], [Street], [Details], [Contact], [Phone], [Email], [Thumb], [Price], [Approved], [Posted]) VALUES (@UserName, @Street, @Details, @Contact, @Phone, @Email, @Thumb, @Price, @Approved, @Posted)"
[Code]....
I have a gridview which is binded to a Sqldatasource. I would like to replace a column data field value to 'Not Applicable' if that column has got a value of 2 in database.
View 2 RepliesI am looking to sort a column on my gridview by simply clicking on the column rather than clicking on the column header. In the design I have been given, the column header will not be shown, and I need to be able to give the user to sort this column, by simply just clicking any where on the column.
View 2 RepliesDoes anyone know if it is possible to create a gridview from a class on a seperate webpage?
So I have webpage 1, that calls Class 1, in Class one there will be a Select Query that will call some info from a database and then return it to a gridview. The gridview wont work obviously as it is in the class and not on webpage 1.
Is there anyway to reference the fact I would like the gridview created on webpage1?
i am displaying a gridview from db(SQL2005), which display leave table where employee apply leave and submit to admin. Viewing the leave table in gridview the admin sanction or rejected their leave request, by clicking the check box displays on each gridview rows and click on sanction or rejected button.
here i am sending SMS to the employee number displaying in the gridview (taking the employee phone number and send SMS).. this i have done using bulk SMS services, i have taken the number using the following
if check conditions...
but now what the problem is i have to delete the gridview rows.. i am using the same employee phonenumber to delete the corresponding gridview, but if suppose the single employee applied for two or more leave, the gridview display all leave for the single employee, the admin have sanction only one leave for that employee.. so if he checks the check box and click on OK button.. it have to delete the corresponding row as well as send SMS to the phonenumber of the employee.. Other leaves of the same employee display in the gridview.. i used the following coding
Protected Sub bttnsanction_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles bttnsanction.Click
Dim row As GridViewRow
Dim selection As New ArrayList()
For i As Integer = 0 To GridView1.Rows.Count - 1.........
I am using the Sno as primary key in leave table.. where i want to delete the corresponding row which sends SMS to employee number also the delete the row of corresponding Sno.. i have to get the corresponding gridview row sno in the delete store procedure..
I have several repeaters on the same page. They are not nested. Because of design and database issues I had to keep them independent. I need to total the amount in a particular column for all repeaters. Is there a common approach to this or do I have to hack something?
View 1 RepliesI am using a DataGridView and have a master table which contains values which different tables related to the master data, i.e. StatusID =1 in master table = TrailerStatus (1, 2, 3, 4 and their descriptions) are in a related table. I am able to retrieve the values from Table B 1 = Empty, 2 = Rejected, 3 = Onsite, etc. However, I don't know how to relate the master table StatusID = 1 to default my dropdown list from the relational table 1, 2, 3, 4.
I have been fighting with this for quite some time and just have not found a solid example of how to do this. I actually have two dropdownlists which will need to be correctly wired in order for my application to work.
This will also be an editable dataGridView but I will tackle that challenge once I get this first hair plucked from my butt.
There is some code-behind which doesn't work at all pertaining to a ;; gvSCACDetail_RowDataBound ;;
but I dont' think I can even get the code to compoile when this is not commented out.
Here are some of the details:
<td style="width: 700px; height: 20px">
<asp:GridView ID="gvSCACDetail" runat="server" AutoGenerateColumns="False" AutoGenerateEditButton="True" DataKeyNames="trailerid,locationid,scacid,statusid,capacityid" AutoGenerateDeleteButton="True" DataSourceID="SCACDetailView" Visible="False" Width="698px">
<PagerStyle CssClass="centerh" HorizontalAlign="Center" />
[Code]....
Is it possible to split a single datasource, so that it can be shown in 2 separate gridviews that are side by side?
So what I am trying to do is change this:
HEADER A
HEADER B
1A
1B
2A
2B
[Code]....
I'm generating a number of calculated arrays in the code behind a ButtonClick event on a particular page. Stuff like:
Dim Delta(,) As Double = New Double(nPer - 1, 0) {}
For i = 0 To nPer - 1
Delta(i, 0) = Delta_Buckets(i, 0) + fwds(i, 0)
Next
What I want to do is convert this to a datatable and use this as a datasource for a gridview in a different page.
i want to do;
for example:when user enter the this number 2514447 i want to separate like that: (251) 4447 first 3 numbers of the given number.
I would like to know if someone can please help me with the followingI would like to create a bulk entering textbox...every sentence seperated by a line break should go in to the Database as a new column.....Im gonna use SqlDatasource for the inserting..How can I get all the sentences to break up at the linebreak and then get inserted in a separate database column?
View 3 Repliesi have a grid view and i use TemplateField.
when i am in ItemTemplate all the column (7 column) are label so it fit to the current screen
by when i use EditItemTemplate or InsertItemTemplate the coulmn don't fit the the current screen and
i have to use the ruler in order to see more information about the cell (which is ok - because in each cell i have a dropdownlist or long textbox)
but when i drag the ruler to the right size to see more information only the cells are moved but the header coulmn stay so i see the current coulmn with worng header coulmn
i have a need to display the each row in a separate page,
example: if a Grid view contains the 10 rows,each row should be displayed in one page(only that row only),when ever second row comes, first row should be removed from grid and second row should be displayed as a whole in that, like wise..when ever 3rd row comes 2nd should be erased and 3rd will come into Grid view.
i am using following code but not getting result as i want,
foreach (GridViewRow gr in GridView1.Rows)
I am using two Grid Views to display data. One (headersGV) is used to show custom headers which change depending on the device type in the second table (dataGV).
The second displays device data and is bound to db tables. This table has a sort mechanism enabled, the functionality of which is in the header cell of the table, hence the need for the headerGV for column headers.
I need to align these two seperate tables so that the headers align with the data columns in the other table. The dataGV columns dynamically resize depending on the data displayed.
I have tried inline styles, css bound to both tables at different levels of priority, onbind methods, and overriding DataBind() method.
I made my own master-detail pages using a listview. Rather than url, I use a listview event to set a session variable and response.redirect to the detail page, which on Page Load, loads the data from the database using the session variable, where it can then be edited. The details page is basically just text boxes and dropdownlists, but I used some third party controls and it all looks really sharp.
Here is the corner I pained myself into. Several dependent dropdowns on the master page filter the main listview. If I go back to the master page using response.redirect, the user would have to use the dropdowns again just to get back to where they were before they went to the details page. This is just not going to work.
To further complicate things, I wanted the master page to have paging on it. So if a back button reloads the page, they would have to set the dropdowns again, and page through the data again if needed. Egads.
The closest I have come to working is using a javascript back back button, but this fails after some postbacks on the details page (that are needed). And of course, the master page isn't refreshed when you go back to it (but I could probably live with that).
I'm currently working on a small project and therefore created a gridview, including one bit column which has been linked with a checkbox in both the itemtemplate as the edititemtemplate (autopostback = true).Databinding for these two checkboxes has been linked (two-way) to the bit column.Now I want to display the gridview to end-users. They should be able to just click on the checkbox so they value in the database column gets changed as well (as I want to run update queries behind it), but not passing via the command column 'EDIT'.=> problem I'm having now is that the bit column in the database doesn't get updated.
View 3 Replieswant to display gridview column heading when mouse over to the particular column in the gridview.
View 9 Replies[Code]....
Stacked-column chart has inconsistent column segment widths