|
Hi,
I've a datagrid populating around 8000 records. The query is excuted quickly in SQL Server but the webpage is being timeout.
Any idea how to solve this?
Regards
Berba
|
|
|
|
|
Why would you do that? Who can possibly look through 8000+ rows and get anything meaningful? You need to return a meaningful subset (maybe the first 100 records) and then let the user request by filtering or bringing more back as needed when paging through the data.
Anyway, when you say quickly, how quick is quickly, exactly? Are you sure the query is indexed correctly? Have you gone through the execution plan? Are there any other bottlenecks?
Really need more info to sort this out but I'd start with the stored procedure.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
8000 records at a time? It's horrible. Use Paging & Filters in your Grid.
SQL Server 2005 Paging Results[^]
thatrajaNobody remains a virgin, Life screws everyone
|
|
|
|
|
hi
can i update/insert record directly from markup if i use UpdatePanel inside asp.net GridControls (GridView, DetailsView, FormView...) using SqlDataSource
this is what i am trying to do
<asp:GridView runat="server" ID="gv"
DataSourceID="mySqlDataSource"
DataKeyNames="id"
AutoGenerateEditButton="true"
AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="Naziv" />
<asp:BoundField DataField="Opis" />
<asp:TemplateField>
<ItemTemplate>
<%#Eval("html") %>
</ItemTemplate>
<EditItemTemplate>
<asp:UpdatePanel runat="server" ID="up">
<ContentTemplate>
<asp:TextBox Text='<%#Bind("html") %>' runat="server" ID="tb" />
</ContentTemplate>
</asp:UpdatePanel>
</EditItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
i can bind "html" field to "tb" TextBox, but executing update or insert command of "gv" i cant update/insert "html" field as long as it is inside UpdatePanel.
i can dynamicly find control ("tb" TextBox) using RowUpdating event and set value that way, but i am just wondering if this can be done with no extra code?
|
|
|
|
|
Hi
I have an Access table with a field that has the names of JPG pictures. I want a Datagrid to display these pictures (which are stored in the image directory).
I can use this line:
|
|
|
|
|
hi guys
how can i create subdomain in the asp.net and read it
thanks a lot
|
|
|
|
|
Don't really understand the question. Can you rephrase?
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
i use iis7 with asp.net 2005
on win server 2008 r2 64bit
and my printer it is network printer
and use server side to print
this code work correct from visual studio but when publish application and make print from url i get this error:
.Invalid printer specified.><><>< at CrystalDecisions.ReportAppServer.Controllers.PrintOutputControllerClass.ModifyPrinterName(String newVal).. at CrystalDecisions.CrystalReports.Engine.PrintOptions.set_PrinterName(String value).. at VisitRegister.PrintDirectlyFromServer(String idIndex)
|
|
|
|
|
Hi ,
Here is my requirement .
Want to create a button in Outlook in the Toolbar
After i click that button want to open a outlook form without To and CC ,only show BCC.Want it to do programatically Using Outlook Add in Template .
Urgent Please help me.
iam a software engineer working for varisis technologies bangalore
|
|
|
|
|
hi everyone,
how do I make emails deliver to inbox not junk box.
i am using a pickup directory.
please help!
|
|
|
|
|
See answer below.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
hi everyone,
how do I make emails deliver to inbox not junk box.
i am using a pickup directory.
please help!
|
|
|
|
|
Fix your junk filter to allow them through.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
Hi All,
I Publish my web application on IIS 7.0 and i reach it using the url
localhost/Eval/LogInPage.aspx
after login succeeded go to page
localhost/Eval/StudiesAndEvaluations.aspx
My Questions is
How To Hide Pages Name?
I Want to see in the url onl localhost/Eval
and hide the pages name.
Please Help Me To Do That ASAP.
thanks All.
|
|
|
|
|
What you're talking about is URL rewriting, and this is really simple to do in IIS 7. This[^] should help you.
|
|
|
|
|
I have an aspx form which are having three usercontrols (basically 2 sets of radio buttons). All are placed dynamically on page load in a placeholder control.
I want to display the other radiobuttons(usercontrols) based on the previous selection. So for eg:
If I have three usercontrols, uc1, uc2, uc3 which are all having two sets of radio buttons. uc2 will display only if uc1 is selected and uc3 will display only if uc2 is selected.
How can I achieve this through jquery/javascript? All these controls should be loaded and visible should be hidden while loading the page.
I googled for sometime, but didn't get any effective result. Could anybody please help.
Following is my code:
<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Src="~/DI_UserControls/AppForm0602.ascx" TagName="AppForm602" TagPrefix="AppForm602" %>
<%@ Register Src="~/DI_UserControls/AppForm0719.ascx" TagName="AppForm719" TagPrefix="AppForm719" %>
<%@ Register Src="~/DI_UserControls/AppForm0466.ascx" TagName="AppForm466" TagPrefix="AppForm466" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<div>
<table>
<tr>
<td>
<asp:PlaceHolder ID="DIPlaceHolder" runat="server"></asp:PlaceHolder>
</td>
</tr>
</table>
</div>
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["con1"].ConnectionString.ToString());
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_GetPages";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@PageID", 12);
cmd.Parameters.AddWithValue("@ApplicationID", 157);
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adpt.Fill(dt);
cmd.CommandText = "sp_GetPageDependency";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@PageID", 12);
SqlDataAdapter adpt1 = new SqlDataAdapter(cmd);
DataTable dt1 = new DataTable();
adpt1.Fill(dt1);
foreach (DataRow row in dt.Rows)
{
int colValue = Convert.ToInt32(row[4].ToString());
switch (colValue)
{
case 602:
obj602 = LoadControl("~/DI_UserControls/AppForm0602.ascx") as DI_UserControls_AppForm0602;
obj602.ID = "602";
DIPlaceHolder.Controls.Add(obj602);
DIPlaceHolder.Controls.Add(InsertLineBreaks(1));
break;
case 466:
obj466 = LoadControl("~/DI_UserControls/AppForm0466.ascx") as DI_UserControls_AppForm0466;
obj466.ID = "466";
DIPlaceHolder.Controls.Add(obj466);
DIPlaceHolder.Controls.Add(InsertLineBreaks(1));
break;
}
}
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
You have to create an empty container like a set of div tags, in the form or the control, assign an id to it, and use Java-script to write html in the container, creating a new set of radio buttons.
So if the DOM detects that the first set of radio buttons was selected, then the JQuery would fire and create a new set based on the result of the first set.
I've never seen an example of exactly what you want, but I have written code that does the same thing.
|
|
|
|
|
Each control rendered in an ASP.NET page has a unique ID (that can be queried using Control.ClientID ) that can be used to access the control from JavaScript (and jQuery).
You can set up client side event handlers for the click events of the controls and show/hide other controls using the display or visibility attributes of the DOM element.
|
|
|
|
|
Hi All,
I have a website on asp.net4.0. I wish to use Ajax Control ToolKit but it is giving compilation error
Quote: Error 20 The type 'System.Web.UI.ExtenderControl' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'
I did following to install AjaxControl Toolkit
1) Installed NuGet
2) Installed AjaxControlToolKit using NuGet Console in Visual Studio 2010
Install-Package AjaxControlToolKit
Error comes as soon as i add
Quote: <ajaxtoolkit:toolkitscriptmanager runat="Server" id="ScriptManager1">
Please help.
|
|
|
|
|
|
Hello,
If select
Delete all existing files prior to publish option while publishing the website....than all the files of that location will be deleted.
Any one knows the files those have been deleted can be recovered? If yes than how can i get those files/ what is the location for those files?
Thanks in advance..
|
|
|
|
|
NTheOne wrote: If select
Delete all existing files prior to publish option while publishing the website....than all the files of that location will be deleted
I hope You have a back up of your site. If not then this will be a hard lesson. I did that once now I back up everything all the time. Good luck
Frazzle the name say's it all
|
|
|
|
|
The files are permanently deleted when you do that.
The only way to recover those files is to use recovery tools like PC Inspector File Recovery.
|
|
|
|
|
Description :
Connecting TFS 2005 via .Net console application for pulling the project and users information. This console will be used by the different users as standalone app for pulling out the information from thier machine.
Problem :
When the user executing the console with the proper input details as mentioned below
Eg : <tfs server="" :="" port=""> <username> <pwd> <domain>
getting the below error message
TF31002: Unable to connect to this Team Foundation Server
Note :
1.The user as got ADMIN rights and can connect to the TFS for different process (check in , check out etc...)
2. This console application is working fine for TFS installed in single tier architec server (TFS app server ,Database server in same server), problem occurs for the TFS installed in two tier architec sever (TFS app server ,Database server in different server )
Error Occurs in below line of code :
System.Net.NetworkCredential credential = new System.Net.NetworkCredential(UserName, Password, Domain);
TeamFoundationServer server = new TeamFoundationServer(serverUri, credential);
server.Authenticate();
|
|
|
|
|
Guys;
I am developing an extender that provides the ability to post back files asynchronously.
I need you to suggest me whether I should add multi-filt feature or not and why.
you can find my extender here Asynchronous File Upload[^]
Help people,so poeple can help you.
modified 19-Feb-12 7:58am.
|
|
|
|