protected void BtnSave_Click(object sender, EventArgs e) {
try {
lblErrorMsg.Text = "";
GridView1.Visible = true;
string str = ConfigurationManager.AppSettings["prink"].ToString();
[Code] .....
My griedview code :-
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" RowStyle-BackColor="Black" Font-Names = "Arial" Font-Size = "10pt"
HeaderStyle-BackColor="Black" HeaderStyle-ForeColor="Black" ForeColor="Black" AllowPaging ="true"
OnPageIndexChanging = "OnPaging" PageSize = "5">
[Code] ....
Error is:- The data source does not support server-side data paging.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception
Details: System.NotSupportedException: The data source does not support server-side data paging.
Source Error:
Line 34: con.Open();
Line 35: GridView1.DataSource = cmd.ExecuteReader();
Line 36: GridView1.DataBind(); Line 37: con.Close();
Line 38: }
following is the code i write
[code].....
it gives error"The data source does not support server-side data paging."
I am using Visual Studio 2010 and SQLServer 2008. I have a GridView and code is
[Code]....
And populating grid on Page load Event like this.
[Code]....
I am trying to implement server side paging with gridview using coding by DAL and BOL concept.But the Problem is with the Gridview page index.As the No of rows retrived are equal to page size and hence I am not able to genearate pager information .I cannot use object data source as i have 2 generate this on some event by passing some arguments like button clickPlease let me know how can i resolve it.Can i use datapager,Or do i need 2 create custom hyperlinks or any alternative to display gridview page index.
View 1 RepliesI have a gridview in a user control which I'm using to display a list of items. The data source is a list of objects (not using ObjectDataSource). I have paging enabled on my gridView. The trouble is that I am forced to rebind my grid in my paging method, otherwise the grid loses all it's data when a user clicks a page button. Is there a good way of binding to an enumerable list such that the values are reused on postback?
[Code]....
protected void gridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
BindGrid(); //Not Good. Removing gives me an empty grid.
((GridView)sender).PageIndex = e.NewPageIndex;
((GridView)sender).DataBind();
}
Just I started learning MVC pattern, of course i am learning it from Microsoft's website.Just i want to gather quiz information from the experts. My understanding is (correct me then and there)
1 ) MVC does not support server side events, but supports client side events. If it supports client side events, I need html page with jQuery/Javascript (view), but most of the example I absorbed is to display the information(model) in view, I did not see any client side event handling happens in view.
2) Except ViewState and controlState, MVC supports Sessions, Application State management, Cache management.
3) When request goes to MVC engine, the routing module routes the request that is picked up by the controller. The controller in executes the appropriate action and returns the appropriate view.
I have a gridview which I databind to EntityModel
This typically looks like
something a
something b
companyID
on Login I get and set the compnay which has the ID so what in essence I want to do is on databind set the Where clause of data source to what the server side paramter for company ID is.
Is there a way to confige IIS to open a database(s) at server level and other application just reference the database handler(pointer)? For an example in Tomcat or Resin, we can specify a set of database souece in the configuration file so the Tomcat or Resin starts, these database will be opened. And rest of applications can reference these datasource handler/pointer in their individual application web.config files.
View 2 Repliesbelow is my code using for simple gridview and i am only having problem with the sorting and paging is working as expected and i even define the ONSorting event but it still throws me an error: [Code]....
[Code]....
I'm trying to use a DataPager to do Server Side paging. Here is my code
<asp:DataPager ID="pgrFooBars" PagedControlID="lvFooBars"
QueryStringField="page" runat="server" >
<Fields>[code]....
The problem is that the DataPager appears to be using the Count property of the ListView to determine the total number of records, which in this case is 20. Somehow, it needs to know that there are 1,500, not 20 total records. The DataPager has a property TotalRowCount, but this is read-only.I have never seen a DataPager example with Server Side paging, but assumed that it could do Server Side Paging, otherwise what good is the QueryStringField attribute?
I am aware that you can do a custom paging solution using methodology like the 4GuysFromRolla did here http://www.4guysfromrolla.com/articles/031506-1.aspx, but I'd first like to know if a solution with the DataPager is possible before creating a custom solution.
UPDATE,The more I look at this, the more that I'm coming to the conclusion that this is not possible and that, unfortunately, the datapager is a control meant for small web sites only. What I want to do should really be quite simple if the control were built correctly. I want to be able to say
dpFooBars.TotalRowCountComputed = false;
dpFooBars.TotalRowCount = AnyNumberThatISoChoose;
I've been looking for some hack to accomplish the same thing, but it appears that the datapager's TotalRowCount is computed from the actual number of items in the datasource that it's bound to. It seems very odd to me that Microsoft would create a ListViewPagedDataSource() class and a DataPager at the same time and not have them work correctly together, but this appears to have been what has happened.
UPDATE 2 (AHA MOMENT?It seems that it has been possible to do server side paging since .Net 2.0 by using an ObjectDataSource and customizing the SelectCountMethod(). I believe it should be possible to customize ObjectDataSource to suit my needs. Hmmm. I'm going away for the weekend, so it'll be a couple of days for me to see if this works. Stay tuned, true believers.
i have a grid as
<asp:GridView ID="dgv_passengerdetails" runat="server" AutoGenerateColumns="False"
CssClass="pasdetailsgrid" BorderStyle="None">
<Columns>
<asp:BoundField HeaderText="Seat No" DataField="seatno">
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
[code]...
the string gs=null, if i click the button again then gs takes the value from textbox.
Regarding ASP.NET's GridView server control: Can I bind to a datasource in the code-behind, load the entire resultset, and then implement client-side paging without postbacks? If this isn't possible with GridView, I'm willing to implement a custom solution. EDIT: My GridView instance sits inside of a nyroModal (jQuery) pop-up div, which is why I need a non-postback solution.
View 3 RepliesI want to use a gridview with sorting and paging to display data from an SQL server, the query uses 3 joins and the full text search containstable. The from part of the query uses all 3 tables in the join.What is the best way to do this? I can think of a stored procedure, SQL directly in the SQLDataSource and creating a view in the database.I want good performance and would like to leverage the automatic sorting and paging features of the gridview as much as possible.
Edit:About size, I suspect very few records, total about 1000 and a query would typical result in no more than 100 records and most times much less.
I would be grateful if someone could let me know what controls in ASP.NET (out of the box) support paging?
View 1 RepliesIs there a way to use the GridView paging and having the links not use JavaScript. So that when you click on the page number 5 (for example) that link is a hyperlink.
View 3 RepliesWhere and what am i missing?
this code produces some error:
DataSet ds = services.getOrdersReport(1, "", DateTime.Parse(System.DateTime.Now.Date.ToShortDateString()));
ReportDataSource datasource = new ReportDataSource("JMJ", ds.Tables[0]);
rv.LocalReport.DataSources.Clear();
rv.LocalReport.DataSources.Add(datasource);
rv.LocalReport.Refresh();
ERROR :
A data source instance has not been supplied for the data source 'dsOrders_tblOrdersReport'
'dsOrders_tblOrdersReport' -- name of the table designed in dataset.XSD
How to change gridview by datalist in this example? [URL]
View 1 RepliesI created a web application in which I am generating a ms-word document using Microsoft.Office.Interop.Word dll. The application is running fine in the visual studio but when I tried to run on IIS 5.0 through virtual directory then its giving the following error -
Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following error: 80070005.
In my application I have taken reference of Microsoft Word 12.0 Object Library, but its coming as Microsoft.Office.Interop.Word dll, this interop dll is just a wrapper of the actual word COM dll. But I have to register the actual word COM dll. so my problem is to find -
1) The path of the original word dll(COM)
2) How to register this dll, either using regsvr32 or to register on IIS.
I just want to know how to capture an image using asp.net server side.
My code runs smoothly and captures the image when I'm running it in localhost, but when if I published or deployed it in our web server then access it tru its url, it doesn't work or i can't capture the image.
Here's my code:
[Code]....
Tools: MS Visual Studio 2008
Language: ASP.NET VB (Visual Basic)
.NET Framework: 3.5
Host: Winhost.com basic hosting
I have a class that is normally compiled into a .dll prior to distribution and used as a component library.
IE: vbc /t:library /out:xyz.dll xyz.vb
(User would download then put the .dll in the bin directory and use
Imports xyz
Dim obj As New xyz
ojb.Foo)
There is a need to write a line of content to the class file specific to the user prior to compile.
Is this possible via server side?
I believe my short question would be, can I call vbc.exe from a site hosted with winhost.com and compile a class.vb file through vbc.exe on the server? And how?
I have been able to reach IE via ASP.NET from my account there so I think it may be possible.
I'm running an ASP.NET ver 4.0 website on Windows Server 2003. Everything was working fine, until I uploaded a new version of the site tonight.I have a new version of the website on my local box, with so many changes that I decided to remove all the existing files on the live site, with the exception of the web.config.Then I uploaded all new files (except the local version of my web.config) from my local box to the live site.
Afterward, when I browsed to the site and tried to use the standard Account/Login.aspx page, all my server code in the code-behind file was displayed in the browser!What would cause this? It *seems* like that would be a server-configured issue, but after I rolled the website back to the old files, everything worked again!
I have created a javascript function along with the scripts in a class file using string builder as follows
public static string ShowAlertMessage(string pHeader, string pError)
{
StringBuilder strScript = new StringBuilder();
strScript.Append("<script type="text/javascript" src="").Append("Scripts/jquery-1.4.1.js").Append(""></script>");
strScript.Append("<script type="text/javascript" src="").Append("Scripts/jquery.msgBox.js").Append(""></script>");
[code]...
This method I am calling on each and every page on the button click where ever I required as follows
ClientScript.RegisterStartupScript(this.GetType(), "Popup", Alert.ShowAlertMessage("Hello", "Welcome"), true);
But this is not giving me the output I needed, the one which I converted is the following URL....
I'm using an entity model with metadata annotations. My controller method looks like this...
if (!ModelState.IsValid)
{
return View(model);
}
else
{
UpdateModel(model);
repo.Save();
return RedirectToAction("Index");
}
If I enable client side validation in the view I'll get the error per the Attributes from the metadata class. If I take clientside validation out, error gets thrown from saving to the DB rather than return the view with an Error Summary.
This is the top portion of my view....
<% using (Html.BeginForm())
{%>
<%: Html.ValidationSummary(true) %>
I've tried running without debugging (ctrl + f5) in debug and release mode as well as setting breakpoints and Debugging (f5) but it just seems weird to get Client side validation without server side validation. What am I missing here?
I want to get the values from the Invisible rows from my gridview. here is my code.
<asp:GridView ID="gvTeam" runat="server" Width="900px"
AutoGenerateColumns="False" BackColor="White" BorderColor="#CC9966"
BorderStyle="None" BorderWidth="1px" CellPadding="4">
<Columns>
<asp:BoundField DataField="FULLNAME" HeaderText="NAME" />
<asp:ButtonField DataTextField="EVALUATION" HeaderText="EVALUATION"
Text="EVALUATION" CommandName="select" >
[Code]...