I am trying to write a small method to loop through and find a GridView Column by its Index, since it can change position based on what might be visible.
Here is what I have so far:
private int GetColumnIndexByName(GridView grid, string name)
{
foreach (DataColumn col in grid.Columns)
{
if (col.ColumnName.ToLower().Trim() == name.ToLower().Trim()) return col.Ordinal;
}........
i know how to find the index of selected row in asp gridview , but i need to find the index of selected column in asp gridview ?for ex:i have i gridview contains columns with header ( the header is the primary key i looking for ) , this grid contain linkbutton , i want to get the column header name on click on linkbutton ?
View 5 RepliesI have a grid view with 4 columns and 12 rows. Getting the row index is not problem; ;however, I cannot find a way to get the column index of the cell that i select.
View 1 RepliesI have a gridview and the OnRowDataBound event is linked to this function:
if (e.Row.RowType == DataControlRowType.DataRow)
{
ThisRow = e.Row.DataItem as MyObjectModel;
if (ThisRow.Property1 == null) { e.Row.Cells[5].Text = "-"; }
This code looks at the value of a property of the object in the data source and if it's null, converts the null to display "-" in column 5. The problem I'm having is that if I change the order of the columns of the gridview, then I need to change the index of every other modification. What I'd like to do is change the statement "e.Row.Cells[5].Text" to something that says "the cell whose column header is xyz".
how to clear the GridView column greater than index 1.
grdview.Columns.Clear() will clear all columns, but i need to clear the columns greater than index 1
Is there a way to find out which column is selected in the Gridview row command? When I click on a gridview row in a specific column, is there a way to get the column index of the selected row?
View 4 RepliesI have been trying to hide a column but make use of the value in another function but the function i am trying to hide it give me and error at the embolded line. System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Public Sub FetchDetails()
Dim valtable As DataTable = New DataTable()
valtable.Columns.Add("LINK")
valtable.Columns.Add("WATCH PERIOD")
valtable.Columns.Add("DAY ENTRY")
valtable.Columns.Add("listid")
Dim seltext As String = "SELECT [Watchlistname], [Watchlisturl], [Watchlistdate],[listid] FROM [Watchlist]"
Dim madap As SqlDataAdapter = New SqlDataAdapter(seltext, Connection())
Dim mdset As DataSet = New DataSet()
Dim i As Integer = 0, pager As Integer = 0
madap.Fill(mdset, "WATCHLIST")
Session("tab") = mdset.Tables("WATCHLIST")
For Each arow As DataRow In Session("tab").Rows
Dim valrow As DataRow = valtable.NewRow()
valrow("LINK") = arow("Watchlisturl")
valrow("WATCH PERIOD") = arow("Watchlistname")
valrow("DAY ENTRY") = arow("Watchlistdate")
valrow("listid") = arow("listid")
valtable.Rows.Add(valrow)
Next
'Dim str As String = ChrW(8358)
gridWatchlist.DataSource = valtable
gridWatchlist.DataBind()
gridWatchlist.HeaderRow.Cells(1).Visible = False
gridWatchlist.HeaderRow.Cells(2).Text = "WATCH PERIOD"
gridWatchlist.HeaderRow.Cells(3).Text = "DAY ENTRY"
gridWatchlist.Columns(4).Visible = False
End Sub
I have a gridview control and in need to get the column name and the column index number
View 3 Repliesi have a dynamic data layer, i.e every user can add custom fields to database tables, so i need dynamic methods in my application.
i know i can use params to specify a variable number of parameters for a method, but the gridview in asp.net looks for a method with the same fields it is updating, i.e if gridview updates fields :name, age, phone, email(suppose email is a custom field of a certain user i.e it doesn't exit for another), and the object data source calls the update method with signature : (name, age, phone, params object[] custom_attributes) an error is generated that the gridview can not find the method with the signature(name, age, phone, email)
I have a GridView in which I want the program to find a specific column, but it doesn't. I've used this code in another program where it worked so what am I missing here? Why doesn't it work? Here's the code where I'm trying to find "status" in column .
[Code]....
...and this is the GridView:
[Code]....
I do the following with datagrid to get the value of a column/row:
dim lblRMDocFilename as string = e.Item.FindControl("lblRMDocFilename")
How to find the same with gridview.
Gridview name is docgrid
I would like to enter a name into a textbox, click a button and find the name in my gridview name column , then move to and select that row in the gridview. How can this be done?
View 4 RepliesI have a DetailsView control about a store products.
When I hit the "Edit" button of the DetailsView control, I want to bind a DropDownList to list products categories and select the current product category in it.
I used the method "ModeChanged" to select the current product category like this:
[Code]....
the FindControl method DOES NOT find the "ddlCategory" (returns null) although it's present in the EditTemplateField.
I'm thinking to use "DropDownList's PreRender" event for doing the purpose I aim, but I want to know what is wrong!
How to bind a GridView Column to a public method in a Page. I have done this before but forgot the syntax. Basically the DataSource has a column named "EndDate" and based on value of the enddate i want show some text in column.
[Code]....
where GetEndDateText is a method in a Page
I have a Datagrid in image below. [URL] I can't find row Index in Datagridview when I call a event in DropDownList.
protected void DescriptionOfProduct_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList _DescriptionOfProduct = (DropDownList)gvSales.FindControl("DescriptionOfProduct");
Label _Unit = (Label)gvSales.FindControl("Unit");
Label _PriceType = (Label)gvSales.FindControl("PriceType");
//...
}
Iam using a dropdown list ,in that am having 4 values ,the following are my values
Uk-L1
Us-L1B
Aus-BUssness
Uk-HSMP
and here i need to choose the a particular value as a selected index ,and i did that for a exact value and in my requirement i will pass only the values after that '-' .so that i need get the value to be selected and here am using the following code to select it is not working can any one help for this.
Code:
DropList.SelectedIndex = DropList.Items.IndexOf(DropList.Items.FindByValue("L1"));
i have a textbox, i need to enter only alphabet in the starting of textbox.. no integers, no special characters.... what should i do?
View 4 RepliesSeems I can't find a way to get row index (or id) for the row just updated in gridview1_RowUpdated()
(in RowUpdating, I can use: for example:
txtActivityID = CType(gridview1.Rows(e.RowIndex).FindControl("txtActivityID"), TextBox)
)
<br />
<table align="center">
<tr>
<td>
<fieldset>
<legend>
[code]...
For Edit I want to select the OfficeName before Selecting a Department or any another way to do this
I have problem with JSON, MapRoute. If I click on "save" I always get Page / Index Page instead of / SendForm. I dont know why, in javascript it says url: '/ page / sendform'. But the problem is at Global.asax.cs,
routes.MapRoute("Default",
"{controller}/{action}/{url}",
new { controller = "Page", action = "Index", url = UrlParameter.Optional });
But there is still problem at the url, which shows Controller, Action that I dont want to .. I have a url / lang / seo-url /. How can I achieve by clicking on the Save, it should call SendForm method instead of Index ..
public class MvcApplication : System.Web.HttpApplication
{
public static void RegisterRoutes(RouteCollection routes)
{
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.MapRoute("page",
"{lang}/{url}",
new { controller = "Page", action = "Index", lang = "cz", url = UrlParameter.Optional });
routes.MapRoute("Default",
"{controller}/{action}/{url}",
new { controller = "Page", action = "Index", url = UrlParameter.Optional });
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
RegisterRoutes(RouteTable.Routes);
ValueProviderFactories.Factories.Add(new JsonValueProviderFactory());
}
}
Index.aspx
<script type="text/javascript">
$(function () {
$("#personCreate").click(function () {
var person = getPerson();
// poor man's validation
if (person == null) {
alert("Specify a name please!");
return;
}
var json = $.toJSON(person);
$.ajax({
url: '/page/sendform',
type: 'POST',
dataType: 'json',
data: json,
contentType: 'application/json; charset=utf-8',
success: function (data) {
// get the result and do some magic with it
var message = data.Message;
$("#resultMessage").html(message);
}
});
});
});
function getPerson() {
var name = "Ruda";
var age = "18";
// poor man's validation
return (name == "") ? null : { Name: name, Age: age };
}
</script>
<input type="submit" value="Save" id="personCreate" />
PageCollector.cs
public class PageController : Controller
{
//
// GET: /Page/
public ActionResult Index(string lang, string url)
{
switch(url)
{
case "anglictina":
return View("~/Views/English/Index.aspx");
case "nemcina":
return View("~/Views/German/Index.aspx");
case "prihlaska":
return View("~/Views/Application/Index.aspx");
case "galerie":
return View("~/Views/Galerie/Index.aspx");
case "kontakt":
return View("~/Views/Contact/Index.aspx");
default:
return View("~/Views/English/Index.aspx");
}
}
[HttpPost]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public JsonResult SendForm(string name, string age)
{
return Json(string.Format("Message: '{0}'", name));
}
}
Id name
1 xyz
2 pqr
5 mnp
3 iuy
4 lkj
in a sql table like this how to get the column index of a particular name like out put will be for "mnp" index is 3....(not according to id) what will be the sql query or if it is a datatable then what will be the code to find the column index...
I have newly use Asp.net Grid in Past i was use Telerik:RadGrid in asp:Grid i have create a <asp:tempelateColumn> in which under <ItemTempelate> i create the link button CommandName="Edit" on click i goes t GridListing_RowEditing event i want to find out the index in that Event
protected void GridListing_RowEditing(object sender, GridViewEditEventArgs e)
I have this code
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ArrayList olist = new ArrayList() { "aa", "bb", "cc", "dd" };
[Code] ....
I want to find the index of the button inside the repeater.
It's look something like this ....
I'm rewriting a Web Forms application as an exercise to learn some MVC skills.I have a number of LinkButtons on the original application which postback and raise a serverside event that rebinds data to a datagrid.
E.g.
Event handlers:
protected void lbtnOffset0_Click(object sender, EventArgs e)
{
[code]....
What I currently have in MVC is this:
<%= Html.ActionLink("CurrentYr", "Index", 0)%>
<%= Html.ActionLink("1", "Index", 1)%>
and
public ActionResult Index()
{
return View(MietController.GetMietByYearOffset(0);
[code]...
As the ActionLink renders an tag it doesn't postback so my overloaded Index() method isn't called. What are my options for doing this in MVC?
I need to create the index for a column and accessing that in sqlserver 2005.
View 3 Replies