I have a SqlDataSource
setup in the markup on my page. After some new requirements, I am
trying to find a way to modify the SelectCommand before the data is
filled for the first time. The SelectCommand below will now be used by
default since we'll always have the first param. I am faced with a need
to modify the SelectCommand though, adding a second session parameter
along with it. I tried to override the OnInit method but it didn't seem
to help...it still used the default query. Is there a best way to
accomplish this? Here is the section of markup I am referring to:
<asp:SqlDataSource ID="SqlDataSourceHD" runat="server"
ConnectionString="<%$ ConnectionStrings:HDOracleConnectionString %>"
ProviderName="<%$ ConnectionStrings:HDOracleConnectionString.ProviderName %>"
SelectCommand="SELECT * FROM Customer WHERE (HOME_PHONE=:HOME_PHONE)"
UpdateCommand="UPDATE Customer SET CustomerEID=:Cu
View Complete Post
My problem is whenever i execute my app the first page that loads is the login page pointed to by my web.config file forms authentication, this page is meant to show CSS formatting for the info i am displaying but it is not. Any help with this problem would be great. A cut and paste of my problem is shown below as you can see there is no CSS.
jsfdnjldfngjfg here it is
I have inserted all the link as in:
< sqldatasource with Inner Join SelectCommand.... I have a gridview with a sqldatasource with SelectCommand as below:"SELECT DISTINCT pr1.ID, pr1.Candidate_Code, pr1.Desc2 AS Name_EN, pr2.Desc2 AS Name_CN FROM Table1 pr1 INNER JOIN Table1 pr2 ON pr1.Candidate_Code = pr2.Candidate_Code AND pr1.Stat1=pr2.Stat1 AND pr2.Desc1 = 'NAMA (CINA)' WHERE pr1.SESSIONS = @Sessions and pr1.DUN = @Dun AND pr1.Stat1 = 'M' AND pr1.Desc1 = 'NAMA (ENG)'" Hw can set the UpdateCommand to update pr1.Candidate_Code? I have tried "UPDATE SPR_Candidate_Profile2 SET Candidate_Code = @Candidate_Code WHERE ID = @ID AND Candidate_Code = @Candidate_Code" but it's not workling.....
I have a new issue regarding the progressbar
I have a page from which i am passing a parameter to CrystalReportviewer on the next page
and a converting a Crystal report in to PDF .
My problem is i want to show a progress bar while the page is loading (on which crystal Report Viewer is Placed) and writing a PDF file
I have already place a scriptmanager Updatepanel and updateprogresbar on that page but the still the page is showing blank while loading the page
can anybody plz tell me how to stop re-loading of page after selecting a date from a calendar control in a aspx page.
I want to show the selected date in a Textbox control but i don't want to re-load the page.
I have an instance where I need to show a classic ASP page within an ASP.Net page. I didn't want to use an iframe for several reasons, but those aren't the issue here. I searched and searched and finally found some code that would let me do it, available here: http://www.mikesdotnetting.com/Article/49/How-to-read-a-remote-web-page-with-ASP.NET-2.0. I implemented the C# code and found that for the purpose of loading a plain HTML page it works just grand. But, when I try to load a Classic ASP page that way, I get a 500 Server error. The page that I am trying to load works just fine if I load it directly into a browser, or into an iframe, but not using this method.
I'd really like to know what is causing the error so that I can fix it. If I could get the whole error response that the page sends out it would be helpful. I'm just not well-versed in how these classes work deep inside. Should I be setting a user agent or some of the other header values? If so, what should they be set to and how? Any insight would be very appreciated. For completeness, my code follows.
The AjaxControl Toolkit has been configured onto our SharePoint 2007 Server, however when we bring up a page with a WebPart+UserControl, we get the following exception:
 Exception Loading CPI RPI WebPart: System.Web.HttpCompileException: c:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a112516a\152cc84\App_Web_cpirpicalc.ascx.57bd6353.duu1hbuu.0.cs(138): error CS0433: The type 'AjaxControlToolkit.ToolkitScriptManager' exists in both 'c:\Windows\assembly\GAC_MSIL\AjaxControlToolkit\3.5.40412.0__28f01b0e84b6d53e\AjaxControlToolkit.dll' and 'c:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a112516a\152cc84\assembly\dl3\4bec602a\25bcac65_13efca01\AjaxControlToolkit.DLL'
The userControl+Ajax Portion of the WebPart works correctly when brought up under ASP.NET but not SharePoint.
Is there anyway to force this to go to the correct version?
I have recently noticed that ,my list edit form page load time is more compare to old version .
I have migrated my sharepoint site from wss3.0 to foundation 2010. I have a large list with 15,000 items and 43 fields.
My new item form is loading very quickly but edit form taking more than a minute. I tried with helath reports and firebug and yslow tools.
I didn't success with any reason. I request you to send me why it happening to the edit form page only
Out of 42 field 12 fields are lookup and I have field edit permissions enabled for different users.
Let me know what can I do to improve page load time for my list edit form.
hi there, i have an SQLdatasource in my pagei was trying to modify it as:SQL.SelectCommand = "Select * from " + TXT_Tabella.Text;because i want update dinamically my sql server tablesbut ,every time i am going to sort, or change pagethe selectCommand returns as before!!!viewState is true!how can i have an SQLdatasource dinamyc by tableName?and how this problem occurs?
When I click Submit button in my Registration form
it should be open a (div) progress bar Showing processing.... (or) loading and block background.
how to display a progress bar loading.... in div after Submit button click??
plsssssss tell me,it's very urgent.
Many Thanks in Advance.
My question is: if I have a data grid on my web page along many other controls, and that datagrid is fetching some data while the page loading.
The page won't load until data grid finish fetching .
I want to show the page to user even thou data grid didn't finished loading and after it loaded it will show. I saw that on few sites, it has preloading bar.
Any one can point a direction please?
My asp.net page now gives a popup box titled "Security Warning" when the page loads. There are multiple pages in my app that do this. The content of the dialog box reads "Do you want to view only the webpage content that was delivered securely?"
Why is this happening all of a sudden? I think it's because the pages contain some http links to external site pages, but i don't remember seeing the message before, and those "nonsecure" links have been there from the beginning. I did add 30+ images though, sourced from in another directory of the project.
Is there some way i can make the images and links "secure"; delivered via https?
Is there some browser setting for users to set so they don't see this popup every time one of the many pages in this website loads?
All feedback and insight is appreciated!!!
how can i display the last record of the table in asp.net. i have button(Cparts) on status webform when you click this two events takes place
1.A pop-up window will appearon on the screen which has 4 textfield,pop-up window comming with blank fields i want to fill all the 4 fields with current/last record of the corresponding table.
2.Also tranfering the primary key value (WONumber in status) of status webform into textbox of the pop-up window(CParts.aspx) which is a hidden field.here i am inserting values into different table(Cparts table) based on WONumber which is not an unique column in this table
I want when this pop-up window opened last record of the CParts table should be populated into CParts.aspx fields. WONumber is not an unique number in CParts table