at least as far as I can tell, not one that I can access programatically. It has a "_rowsTotal" property that I can't get access to it for some reason. Seem to be some sort of protected or locked property?
View 7 RepliesI wanted to get the total row count in a GridView's databound event handler, so I tried the following:
protected void grid_DataBound(object sender, EventArgs e)
{
GridView grid = (GridView)sender;
DataSet data = grid.DataSource as DataSet;
if (data == null)
return;
int totalRows = data.Tables[0].Rows.Count;
}
The problem is that the grid.DataSource property is null. The DataSourceID property is not null, so does that mean that I can't access the DataSource object in the DataBound event handler unless I assign the DataSource property directly?
Edit1: Here is the code in my GridHelper class for adding rowcount to the BottomPagerRow. I would like to get rid of the requirement to pass in the ObjectDataSource, but can't because I need to use the Selected event to get total row count. Hence the reason for the question. I also think this might be better in a custom control where I can access ViewState, and/or create child controls during the Init event (I still have a problem to resolve with the way the pager renders with an extra cell), but then I'd still have the problem of how to get to the total row count when the DataSource itself doesn't appear to be available in any GridView events.
Edit 2: Not really relevant to the specific problem, but I resolved the problem I was having with the pager rendering so i've updated the code posted. I found the trick here: [URL]
#region Fields
private int totalRows = -1;
#endregion
#region Constructors
/// <summary>
/// Initializes a new instance of the <see cref="GridHelper"/> class.
/// Adds EventHandlers to the GridView to display results from the ObjectDataSource in the footer.
/// Marked as obsolete because AddResultsToFooter method provides a static access to the same functionality
/// An instance of GridHelper is required by the passed in GridView to store the totalRows value between the two event handlers
/// </summary>
/// <param name="grid">The grid.</param>
/// <param name="source">The ObjectDataSource linked to the GridView.</param>
[Obsolete("Use AddResultsToFooter instead.")]
[EditorBrowsable(EditorBrowsableState.Never)]
public GridHelper(GridView grid, ObjectDataSource source)
{
source.Selected += source_Selected;
grid.PreRender += grid_PreRender;
}
#endregion
#region Event Handlers
private void grid_PreRender(object sender, EventArgs e)
{
GridView grid = (GridView)sender;
if (grid.HeaderRow != null)
grid.HeaderRow.TableSection = TableRowSection.TableHeader;
//Add a cell to the bottom pager row to display the total results
if (grid.BottomPagerRow == null || !grid.BottomPagerRow.Visible)
return;
//Get the control used to render the pager
//http://michaelmerrell.com/2010/01/dynamically-modifying-the-asp-net-gridview-paging-control/
Table tblPager = grid.BottomPagerRow.Cells[0].Controls[0] as Table;
if (tblPager == null)
return;
if (totalRows < 0)
{
//The DataSource has not been refreshed so get totalRows from round trip to client
addResultsToPagerTable(tblPager, grid.Attributes["results"]);
return;
}
int firstRow = grid.PageIndex * grid.PageSize + 1;
int lastRow = firstRow + grid.Rows.Count - 1;
string results;
if (totalRows <= grid.PageSize)
results = string.Format("<span class='grid-pager'>{0} Results</span>", totalRows);
else
results = string.Format("Results <b>{0}</b> to <b>{1}</b> of <b>{2}</b>", firstRow, lastRow, totalRows);
addResultsToPagerTable(tblPager, results);
//Need to store the information somewhere that is persisted via ViewState, and we don't have access to ViewState here
grid.Attributes.Add("results", results);
}
/// <summary>
/// Handles the Selected event of the source control. Gets the total rows, since it is not possible to access them from the GridView.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.Web.UI.WebControls.ObjectDataSourceStatusEventArgs"/> instance containing the event data.</param>
private void source_Selected(object sender, ObjectDataSourceStatusEventArgs e)
{
if (e.ReturnValue is DataView)
totalRows = ((DataView)e.ReturnValue).Count;
else if (e.ReturnValue is EntitySet)
totalRows = ((EntitySet)e.ReturnValue).Count;
}
#endregion
#region Private Methods
private static void addResultsToPagerTable(Table tblPager, string results)
{
//http://michaelmerrell.com/2010/01/dynamically-modifying-the-asp-net-gridview-paging-control/
//Get a handle to the original pager row
TableRow pagesTableRow = tblPager.Rows[0];
//Add enough cells to make the pager row bigger than the label we're adding
while (pagesTableRow.Cells.Count < 10)
pagesTableRow.Cells.Add(new TableCell { BorderStyle = BorderStyle.None });
//Add a new cell in a new row to the table
TableRow newTableRow = new TableRow();
newTableRow.Cells.AddAt(0, new TableCell
{
Text = results,
BorderStyle = BorderStyle.None,
ColumnSpan = pagesTableRow.Cells.Count
});
tblPager.Rows.AddAt(0, newTableRow);
}
#endregion
#region Public Methods
/// <summary>
/// Adds EventHandlers to the GridView to display results from the ObjectDataSource in the footer.
/// </summary>
/// <param name="grid">The GridView.</param>
/// <param name="source">The ObjectDataSource linked to the GridView.</param>
public static void AddResultsToFooter(GridView grid, ObjectDataSource source)
{
if (grid == null)
throw new ArgumentNullException("grid", "grid is null.");
if (source == null)
throw new ArgumentNullException("source", "source is null.");
new GridHelper(grid, source);
}
#endregion
I am trying to show as part of the Gridview table the amount of records found as a total in one of the Gridviews rows. I have some code which does add a row to the Gridview but it does not seem to be counting the number of rows it just shows 0 all the tim. Does anyone know why this might be? you can see the count "visitCount" and the dt.Rows.Add but it doesn't increment
[Code]....
I have MySQL database, and I just installed the MySql-Connector-Net. But MySQL Provider doesn't appear in the list of providers e.g. in the Server Explorer.
View 8 RepliesI have a large existing stored procedure who's interface I cannot change that has several parameters of type boolean. ODP.NET doesn't support a boolean type and I get an error when trying to access this proc via .NET using a different data type.
View 1 Repliestrying a sample from the jquery template plugin. Getting an error:
[Code]....
what do I need to run the templating plugin?here are my script includes ( I added the jquery.tmpl.js file as an existing item to the scripts folder of my MVC project )
[Code]....
The following action in my controller does not update the Model property which is bound by a radio buttons group (all are named "ListType") when the form is submitted. On the Edit.ASPX form, I used JQuery to reset the radio buttons group. When setting other type of input elements on the form to blank or checked=false, those Model properties are set accordingly upon submission. Does anyone know how to set radio buttons to unched state?
Also I am trying to get the SqlException to show up in my form where I have Html.ValidationSummary helper. My ModelState helper captures the know business rules violations, but I am unable to pass any SqlException and its Message property to this helper class due to unexected exception.
[Code]....
i have the following query.
[code]....
but if there were no "hits" for a particular date range in the last week i only get the dates returned where there were hits. i need to get all the days returned and where there were no results, i need a zero returned.
hitdate hitsperday
2010-10-07 2
2010-10-06 58
2010-10-04 1645
2010-10-03 1192
what i need to return is this:
hitdate hitsperday
2010-10-08 0
2010-10-07 2
2010-10-06 58
2010-10-05 0
2010-10-04 1645
2010-10-03 1192
I have simple accordion:
$("#accordion").accordion({ autoHeight:
false, active:
false });
[code]...
URL....i am getting below error if i use above code..Microsoft JScript runtime error: Object doesn't support property or method 'live'.
View 1 RepliesNo matter how I set the width in the EmptyDataRowStyle in a GridView, it gets ignored. The width of this construct always takes on the width of the text instead of what is asigned to the width property. This is also true if the property is set as a CSS style width.
If the width is assigned to the GridView construct then the EmptyDataRowStyle will take on that width.
I used this construct to test this:
[code]....
i have little knowledge on javascript but i need to use this code get from somewhere for a jquery to work. I face this "Jscript runtime error: Object does not support property or method" whenever im trying to run this page. In my experience, im get this error msg 9 out of 10 times i use javascript in my system. Im using Microsoft Visual web developer 2008, i wonder if this is related to my problem, i not sure there is anything i need to add as reference or update anything. But anyway, in short, i just couldn't use javascript code when using this development tool because of this sort of error. Anyway, it happen that last time i tried use the same type of jquery code in another project and it seems to work well without an error. But now when im try to use it again in this recent project i created, it come out with this error and i have no idea how to solve it even look through google and this forum. It doesn't really seems like its the code problem itself although im not sure, because any javascript code just couldn't work. So below is my code that i need to use.
[Code]....
[Code]....
When i add this control to a page i set it's address with Address property. But it never sets it's address property like this :
[Code]....
When i try it like above, it always set address null. So it never goes to webpage that i want. It's result in the address bar always like this :
http://localhost:4533/TarihKoruma/?Date=12.05.2010 but i want it like this :
http://localhost:4533/TarihKoruma/Events.aspx?Date=12.05.2010
I am using Media Player Control to play a video file(.mpg). The video file can be played ok when I specify an absolute URL value (something llike C:UsersMyFilesMyVideoTestVideo.mpg) for the MovieURL property . Anyway when I set a relative URL value like ./TestVideo.mpg (the format follows an example from some tutorial) for the MovieURL property, the video file cannot by played.
View 6 RepliesI have to load the values to parent page from the popup page. The popup page will be in another website(saparate server).
I used opener.document.getElementById('parentcontrolID'), this is working fine if i run in the local(i created saparate virutual directory for popup page website in my local machine) system the values are loaded properly. but Once i move to the different servers it's not working. getting this javascript error message "Object doesn't support this method or property" in the popup page bottom left corner.
What will be the problem.
Whether we can load the value to parent page from popup page even both are in saparate server?
I am trying to use jGrowl in ASP.NET, but am getting a Microsoft JScript runtime error: Object doesn't support this property or method error when trying to run the page in IE.
<link rel="stylesheet" href="css/jquery.jgrowl.css" type="text/css" />
<style type="text/css">
div.jGrowl div.smoke {
background: url(images/smoke.png) no-repeat;
[Code]....
I am trying to validate my gridview checked checkboxs, using code below.
I get "Microsoft JScript runtime error: Object doesn't support this property or method" error when button is clicked and i used breakpoints to check strangely, i am getting back gridViewx count=3 in javascript function. my gridview has nested gridview?
CodeBehind.aspx
page on_load
ActiveAssignButton.Attributes.Add("OnClick", "return IsCheckBoxSelected(" & GridView2.ClientID & ")")
html page
function IsCheckBoxSelected(gridViewx) {
if (gridViewx != null) {
var chkBoxes = gridViewx[0].getElementsByTagName("input");
for (i = 0; i < chkBoxes.length; i++) {
if (chkBoxes[i].type == "checkbox" || chkBoxes[i].type == "CHECKBOX") {
if (chkBoxes[i].checked == true) {
return true;
}
}
}
alert("At least one ticket needs to be selected!");
return false;
}
}
I'm generating the rdlc at runtime and I'm using LoadReportDefinition(memorystream) to provide the definition to report viewer. It works fine but when I export it to pdf or excel, the file extension comes in as .xls[1] or .pdf[1].
I have tried giving the DisplayName property but it doesn't work.
I am writing a Web Application in ASP.NET using C#. Whenever I run it, I get three types of Runtime Javascript Errors.
My Problem is that even though I am running a new Web Application with out any modification, then I also get the same errors.
These are the errors:
Microsoft JScript runtime error: Object doesn't support this property or method
at
document.addEventListener("mousemove", updateLastMouseMoveCoordinates, false);
Microsoft JScript runtime error: Object expected
at divSurveyInit();
Microsoft JScript runtime error: Object doesn't support this property or method
at enter code here:
document.addEventListener("mousemove", updateLastMouseMoveCoordinates, false);
I am trying to sort in gridview however I got some error message in _dopostback function which shows "Microsoft JScript runtime error: Object doesn't support this property or method" at theForm.submit()
my user.aspx.cs shows as follows
[code]....
In the GridView_RowUpdated event the e.OldValues.count <> e.NewValues.Count. 1 out of 5 columns has been converted to a template field.
View 9 RepliesWhen a user submits the query to SQL when clicking a button I need to get a count of the number of rows that are returned. Which event does the gridview.count code need to be place in?
Right now I have it in the btn_click event, but in order to get it to count the rows you have to hit the button twice since the query is not returned yet. Here is my code.
[Code]....
I HAVE A GRID VIEW IN asp.net + VB Code. There is a drop down list and the selected data is displayed in web page. I placed a label in web page and code behind i used following code.
Protected Sub GridView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.DataBound
Label1.Text = GridView1.Rows.Count.ToString()
Dim ONYO As Integer = 0
Dim DONE As Integer = 0
For i As Integer = 0 To GridView1.Rows.Count - 1
If GridView1.Rows(i).Cells(0).Text = "ON YO" Then
[Code] .....
I am trying to pass a textbox integer to a sql statement in my code behind using the "where" statement to filter what I get from the mysql database but for some reason, it diplays nothing. If I change the variable in the "where" statement to an actual digit between 1 and 12, it works.
Here's my code:
Default.aspx:
[Code]....
Default.apsx.cs:
[Code]....
protected void Button3_Click(object sender, EventArgs e)
{
//Create a connection to the database
MySqlConnection conn = new MySqlConnection("Database=kid07025;Data Source=195.178.228.254;User Id=kid07025;Password=********");
//open the connection
conn.Open();
//MySQL Query which updates the row where Anvandarnamn = Anvandarnamn (recieved from a cookie)
MySqlCommand cmd = new MySqlCommand("UPDATE personer SET Information=?Information,Fnamn=?Fnamn,Enamn=?Enamn,Personnr=?Personnr,Adress=?Adress,Postnr=?Postnr,Ort=?Ort WHERE Anvandarnamn=?Anvandarnamn", conn);
// Update with new text
cmd.Parameters.AddWithValue("?Anvandarnamn", Request.Cookies["Anvandarnamn"].Value);
cmd.Parameters.AddWithValue("?Information", TextBox1.Text);
cmd.Parameters.AddWithValue("?Fnamn", TextBox2.Text);
cmd.Parameters.AddWithValue("?Enamn", TextBox3.Text);
cmd.Parameters.AddWithValue("?Personnr",TextBox4.Text);
cmd.Parameters.AddWithValue("?Adress", TextBox5.Text);
cmd.Parameters.AddWithValue("?Postnr", TextBox6.Text);
cmd.Parameters.AddWithValue("?Ort", TextBox7.Text);
cmd.ExecuteReader();
conn.Close();
RefreshProfile();
}
I don't know what I am doing wrong here, but the database doesn't get updated when I press the button.
I use VS 2010, ASP.NET