Forms Data Controls :: Making GridView Cells Specific?

Apr 9, 2010

I have a gridview that has both a select and an update statement. One of the cells is a date cell, and the other is for numerics only. Is there a way I can do this? At the moment, anything can be keyed into the cells and this results in an error as my update stored procedure expects a date value and a numeric value respectively.

View 2 Replies


Similar Messages:

Forms Data Controls :: Make Onle Specific Cells In Gridview As Hyperlink?

Sep 9, 2010

i have gridview and im displaying the employement history of employee.and im providing a hyperlink in empid to open employee page with update mode ..so that user can update the record.i have an issue here.only if the employeeresigned = "N" empid should be hyperlink, if its "Y" it should not be a hyperlink.

<asp:TemplateField
HeaderText="empid"
SortExpression="empid"> [code]....

am wondering how to do this

1) shall i replace all the linkbutton with label if the resignedstatus = "Y"

- how to do this? 2) or shall i make the empid as boundfields instead of templatefields and write code on rowbound...with checkin that

if resigned =
"Y" then
e.Row.Cells(0).BackColor = Drawing.Color.blue

e.Row.Cells(0).Attributes.Add("onclick", "empDetails_disp")

e.Row.Cells(0).Attributes.Add("class", "statusclass")

......

in this case i can use only javascript function for

e.Row.Cells(0).Attributes.Add("onclick", "empDetails_disp")

this statement? or can i directly call my empdetials_disp function in my aspx.vb page...

View 5 Replies

Forms Data Controls :: Make Specific Cells In A Dynamic Gridview Clickable And Capture The Cell Info Before Redirecting

Aug 3, 2010

I generate dynamic grids based on a count value returned from some DB tables. the code for it goes like this : I give and Id to each grid that is generated.

if (myDataList1.Count >= 1)
{
for (int i = 0; i < myDataList1.Count; i++)
{
//retrieving the exact i count from pageload
ViewState.Add("newCount", i);
//creating the dynamic grid with its corresponding gridview properties.
grvDynamic = new GridView();
grvDynamic.ID = "GridView" + (i+3);
grvDynamic.AutoGenerateColumns = false;
grvDynamic.RowCreated += GridViewRowCreated;
grvDynamic.RowDataBound += grvDynamic_RowDataBound;
//adding bound field columns to retrieve data from stored proc
BoundField metric = new BoundField();
metric.HeaderText = "Goal ";
metric.DataField = "metric";
grvDynamic.Columns.Add(metric);
BoundField mtd = new BoundField();
mtd.HeaderText = "MTD";
mtd.DataField = "value_MTD";
grvDynamic.Columns.Add(mtd);
BoundField goal = new BoundField();
goal.HeaderText = "Tier Level Achieved";
goal.DataField = "value_goal";
goal.HeaderStyle.Width = Unit.Percentage(10);
grvDynamic.Columns.Add(goal);
BoundField you1 = new BoundField();
you1.HeaderText = "Month End";
you1.DataField = "firstLevel_you";
grvDynamic.Columns.Add(you1);
BoundField you2 = new BoundField();
you2.HeaderText = "Month End";
you2.DataField = "secondLevel_you";
grvDynamic.Columns.Add(you2);
ButtonField singleClick = new ButtonField();
singleClick.CommandName = "clickHyperlink";
singleClick.Visible = false;
grvDynamic.Columns.Add(singleClick);
BoundField metricId = new BoundField();
metricId.HeaderText = "Metric Id";
metricId.DataField = "metricID";
metricId.Visible = true;
grvDynamic.Columns.Add(metricId);
//binding the gridview to data.
grvDynamic.DataSource = data;
grvDynamic.DataBind();
grvDynamic.Columns[5].Visible = false;
}
}

protected void grvDynamic_RowDataBound(object sender, GridViewRowEventArgs e)
{
//this basically gets the metric Id's of rows with the ishyperlink flag set to 'Y'. I need to make these particular cells clickable var isClickable = (from md in myDataList3 where md.IsHyperLinkFlag == 'Y' &&

md.value_MTD != null select md.metricID).ToList();
if (e.Row.RowType == DataControlRowType.DataRow)
{
// Get reference to button field in the gridview.
LinkButton _singleClickButton = (LinkButton)e.Row.Cells[5].Controls[0];

if (isClickable.Contains(Convert.ToInt32(e.Row.Cells[6].Text)))
{
e.Row.Cells[1].Style["cursor"] = "hand";
e.Row.Cells[1].Style["color"] = "blue";
e.Row.Cells[1].Style["textdecoration"] = "Underline";
e.Row.Cells[1].Attributes.Add("onClick", "window.location ='../HeaderPages/page2.aspx' ");
}
}
}

This code works perfectly fine , depending on the ishyperlink flag in the database...specific cells in the grid are made clickable and then redirected to page2.aspx My Issue: I need to capture which specific cell in which specific grid the user has clicked. store some information in sessions based on the cell clicked and use that information in page2.aspx.

View 5 Replies

Forms Data Controls :: Set The Padding In The Cells Of A GridView

Nov 16, 2010

CellPadding only applies the padding to the header row. CssClass in Gridview, RowStyle or EditRowStyle has no effect.

View 2 Replies

Forms Data Controls :: Merge Cells In Gridview

May 4, 2010

i have a gridview in my website and i want to merge two cell of that in same column but in different row , for example i have a data about tours in an agency , now i define a tour that has two hotel with difference grade , i want tow show my grid view in this manner :

tour a
hotel a1
100 $
2010 / 5 / 5
hotel a2
200 $

View 2 Replies

Forms Data Controls :: Calculating Cells In A Gridview?

Feb 12, 2010

I have a gridview where I placed several item templates with text boxes in them. I want to enter a number in the text boxes and have the total displayed in the footer.

The last footer template is where I want to display the total. I've placed a label there.

Here's my Gridview

[Code]....

View 4 Replies

Forms Data Controls :: How To Use Gridview Cells Like Hyperlink

Nov 30, 2010

I have a Gridview with one column (news title).

i wan to when user click this cells go to another page to show full news.(i know how to use querystring
)

THEN:

How can i change this cells(i think DATABOUND) to hyperlink

View 3 Replies

Forms Data Controls :: GridView: Get E.Row.Cells From FindControl?

Nov 10, 2010

Can one use the findcontrol to access the row.cells value? (C#)

[code]

[Code]....

[/code]

I though that this would work, but alas no.

View 2 Replies

Forms Data Controls :: Merge Like Cells In Column In Gridview

Mar 18, 2010

I'm working on a project in vb.net framework 2.0 and have a column that has server names. I have the accessdb sql setup to order by the db, what I would like to do is to have it look like the following picture below. I'm pretty stumped on how to do it as the methods I've found online haven't worked so well. Also just a small tid-bit the gridview is bound to a ddl which selects the application and the gridview refreshes with server data. Country would be server name and state would be the environment.

View 5 Replies

Forms Data Controls :: How To Merge Gridview Columns (cells)

Nov 5, 2010

How to merge gridview columns in a grid when the items in the grid are duplicate. i mean in one row four columns are there i need to merge the columns which are repeating

eg: Mango Mango Mango Apple

i want like: Mango Apple

i the columns mango is getting repeated i need to merge it into one

View 14 Replies

Forms Data Controls :: How To Change The Formatting Of The Cells In The Second Gridview

Jan 26, 2010

specially VB code behind pages.I am writing an app with a colleague and I am stuck on something.he app is a holiday booking calendar. I have a gridview that shows the total number of days booked for each month of the year. When you click the cell for say January another gridview is populated below showing each day of january.My problem is that I want to change the formatting of the cells in the second gridview depending upon if any of the cells have a 1 or a 0.

View 3 Replies

Forms Data Controls :: How To Retrieve Value From Empty Gridview Cells

May 26, 2010

When retrieving values from Gridview empty cells, you will get " " instead of a empty string or null.

Someone once change the columne's properties as following, but it doesn't work

ConvertEmptyString > true
HtmlEncode > false
HtmlEncodeFormatString >false

One solution is to check if the cell value is " ". If so, assign it an empty string. But this approach looks awkward.

View 9 Replies

Forms Data Controls :: How To Get Values Of Gridview Cells Which Are Not Visible

Mar 2, 2010

I am able to get the values of GridView cells when the columns are not visible.

For Example:

<asp:BoundField DataField="TemplateKey" Visible="false"/>
foreach (GridViewRow gvrow in GridView1.Rows)
{
gvrow.Cells[0].Text.ToString()
}

But if I make the BiundFiled Visible="true" then I get the value in the code behind.

I do not want to show this value to the user and also want to get the value in the code behind. How can I do that?

View 2 Replies

Forms Data Controls :: Gridview - Add Hyperlinks To Cells Programmatically?

Mar 8, 2011

we're creating a GridView to display news articles programmatically (not using a SQL database).

We can create & display the GridView, but are having a devil of the time to get the hyperlinks in SetupGrid() attached to the titles

of the articles in the GridView. Below is our .aspx code and .vb code of how we create the GridView. Any ideas on what we should do to get the hyperlinks array of strHyperlinks() in SetupGrid() to be applied to the titles in column 1 of the GridView?

[Code]....

View 2 Replies

Forms Data Controls :: Row.Cells[4].Text Return Nothing In GridView?

Aug 31, 2010

I have a GridView in my page :

[Code]....

But always temp string is empty!

What's wrong with it?

View 1 Replies

Forms Data Controls :: Change Some Cells Background In Gridview?

Dec 1, 2010

How can change some cells in gridview that have some condition?

For example:

IF name=="x" column[2].background="red"

(only column for this name)

EXPLAINE :

my GRidview show houses,and i want to when it is for sale the clolum (sell price) background will be another color,and also for rent.

ask 2: I should use the code in RoewCreated event or OnRowDataBound ?

View 2 Replies

Forms Data Controls :: Merge And Sort Selected GridView Cells

Apr 9, 2010

I have a GridView known as GV_R001 with IssueType, ActID, IssueID cells. I want to Merge the similar IssueType cell accordingly. How do i merge and also sort the IssueType cell accordingly. The following is my codes:

Protected Sub GV_R001_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles GV_R001.DataBound
For rowIndex As Integer = GV_R001.Rows.Count - 2 To 0 Step -1
Dim gvRow As GridViewRow = GV_R001.Rows(rowIndex)
Dim gvPreviousRow As GridViewRow = GV_R001.Rows(rowIndex + 1)
Dim cellCount As Integer = 0
If gvRow.Cells(cellCount).Text = gvPreviousRow.Cells(cellCount).Text Then
If gvPreviousRow.Cells(cellCount).RowSpan < 2 Then
gvRow.Cells(cellCount).RowSpan = 2
Else
gvRow.Cells(cellCount).RowSpan = gvPreviousRow.Cells(cellCount).RowSpan + 1
End If
gvPreviousRow.Cells(cellCount).Visible = False
End If
Next
End Sub

Apart from that, after sorting i want to calculate the amount of IssueID are in a particular IssueType and display in a cell called "Total". Is it possible to do so? By the way, I am using Web Developer 2008, VB.net.

View 2 Replies

Forms Data Controls :: Empty Cells On GridView With 10 Rows To Edit?

Mar 25, 2011

I am using a GridView on my ASP.NET form.

Would it be possible to have a GridView with 10 empty rows, having 5 columns.

Can I define the number of GridView Rows I could Edit.

i would then have an Update Button, which would update all the rows to the database.

View 2 Replies

Forms Data Controls :: Accessing Cells In A GridView Using An External Button?

Dec 15, 2010

I have a GridView (it could just as easily be a ListView if the latter is easier).

I have a Button completely outside of the GridView.

I want to access the cell values in the GridView from the Click event handler of the Button.

View 6 Replies

Forms Data Controls :: Turn Null Cells In A Gridview Into Zeros?

Jul 7, 2010

I have a Gridview with some cells in numbers while in some cell they could be null without numbers. I need to modify it such that the numbers in the Gridview are in these formats:-

(a) If it is 12345.333 becomes 12,345

(b) If it is blank, I wish the cells to display 0

This is the code I am using to achieve (a), but when it comes to blank, it returns error (I believe my code below failed to provide blank cases but I dunno how. So what should be the code to do (b) above ?

For i As
Integer = 1
To N
e.Row.Cells(i).Text = String.Format("{0:#,##0}", Convert.ToDouble(e.Row.Cells(i).Text))Next

View 13 Replies

Forms Data Controls :: Edit All Cells Within A Particular Column => Gridview (vb Code)?

Oct 20, 2010

I'm looking for a technique to edit a whole column (vertical) instead of a row (horizontal).Suppose i have 10 rows en 5 columns (like in Excel), and i want to edit all digits from different students (rows) for test number 3 (column).

View 2 Replies

Forms Data Controls :: Prevent Line Breaks In GridView Cells?

Feb 24, 2011

One column in my GridView has the format 1-2345 (one digit followed by a dash followed by four digits. Normally, everything looks OK, but sometimes the other data in my GriView will expand to two or more "lines" in the same row of data. Unfortunately this causes my cell to look like the following:

1-
2345

This looks really really awful and I need to fix it. You know how in HTML there is the non-breaking space symbol? Well I want a non-breaking dash symbol.

View 2 Replies

Forms Data Controls :: Unable To Retrieve A Gridview Selected Row Cells Data

Mar 16, 2010

i am still stumped with this operation: i am trying to retrieve a GridView selected row data..here is my code.. the commented part that gives me the selectedindex works just fine....but the one giving the selected row cell value does't work and there is no error.. The update operation is done successfully...weired. i need to assigned selected row cells values to variables ..do some calculations and then re-assign the result calculation to cell[9]..

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string s = GridView1.SelectedRow.Cells[5].Text;
TextBox1.Text = s.ToString();
//string s2 = GridView1.SelectedIndex.ToString();
//TextBox1.Text = s2.ToString();
}

View 5 Replies

Forms Data Controls :: Convert Gridview Data Cells From Text To Hyperlink?

Feb 14, 2010

1. First i am populating a datatable with two columns of type text. The second column is a hyperlink (but i am not specifying that datacolumn type as hyperlink).

2. After populating the rows, i am adding the datatable to dataset.

3. then binding this dataset to the gridview (the gridview's AutoGenerateColumns=true).

Question:

Obviously, the hyperlink column is represented as text in the gridview (non-clickable hyperlink).

here i am trying to convert this hyperlink column (data rows), from text to a hyperlink, so that the user can click directly and navigate to that url.

FYI, I cannot change this method of binding, and just want to convert this text hyperlink to a real hyperlink.

View 7 Replies

Forms Data Controls :: Merge Gridview Cells That Have Same Data In Column

Mar 18, 2010

I'm working on a project in vb.net framework 2.0 and have a column that has server names. I have the accessdb sql setup to order by the db, what I would like to do is to have it look like the following picture below. I'm pretty stumped on how to do it as the methods I've found online haven't worked so well. Also just a small tid-bit the gridview is bound to a ddl which selects the application and the gridview refreshes with server data. It is sorted by server than environment so the columns contain much of the same info for those over and over. Country would be server name and state would be the environment.

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved