let us assume we have a Chemical master table with 10000 records. this table contains chemdesc,uom,closingquantity,closingvalue,...,createdon. for every chemical there are multilple records. so i want a query to get chemical name with recently created records. i mean to say that last record of each and every chemical. [if i have give date like 22-08-2010 then i should get records on or before latest record of each chemical]
I have two table Master table A, Master table B where i have Refno column...I need to check if Refno is avaialbale in Table C .. If itz available then i dont need to show Refno... If not available any oftwo master table then i need to show Refno with sum of (Quantity)
Is it possible to extend the RequiredAttribute class in a way to have it validate a condition against another property in the model? For example, in my hypothetical code.
[Code]....
The DriversLicenseProperty is to be required in the model if HasLicense is true. Is this possible? Is there an example somewhere?
I have some suitation where i want to store aspx controls in SQL Server database and retrive on aspx.cs page according to database i want to design my aspx page and also event handler to them.
Controls may be vary time to time according to suitation and aspx page changes all time according to suitaion.
For Example :
I want to display a information about Computer and Technolgy the aspx page will be display only Computer related topics like 1. Computer Name 2. Price 3. Discount
but in other case I want to display information about City Information then Display 1. City Name 2. Distance from nearest city. 3. City Map 4. About City 5. Query or book a car. extra - extra.
I have developed real time application in asp.net. The software listen data from hardware devices and store data in database. Now I want to set minimum hardware requirement for my application.
By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.
In asp.net web application I have restricted users actions depending on their roles like as follow
I have created three tables in database
Tables
Table: Users
UserID Username Password 1 Bob password1 2 Scott password2 3 Jisun password3 4 Sam password4 5 John password5
Table:Groups
GroupID Name 1 Administrators 2 Clerk 3 Manager 4 Cashier
Table:Roles
UserID GroupID 1 1 2 2 2 3 3 4 4 3 4 4
In Global.asax file I have written the following
Sub Application_AuthenticateRequest(sender As Object, e As EventArgs) If Request.IsAuthenticated Then 'Determine this user's roles[code].....
as of now it is working fine. Now a new requirement has araised that to allow the clerk to access some of (but not all) functionalities perfomred by administrator.
Do i need to change my source code to provide above new requirement?
Do I need to do the same again and again when such requirement araises in future ?
I'm using the jQuery NotifyBar quite nicely in an Index view to display business rule errors when a user e.g. clicks a delete link for an item than cannot be deleted. However, if the user adds a new item, they are redirected to the Create view. If the new item is successfully created, the Create action redirects back to the Index view.
My quandary is that I need (have been told) to show a success notification in the above scenario. Previously, to request a notification while remaining on the same view, I was using return JavaScript() for an action result, but when I use return RedirectAction() for the action result, I'm left with nowhere to put the return JavaScript().
The way I see this is that I need to: a) include information in the return RedirectAction() that tells the 'destination' view to show the notification, or b) invoke the notification in the 'source' view, instead of the return RedirectAction(), and tell it that when it closes/is closed, to perform the redirect to the 'destination' view.
I am trying to create statitics for game downloads and am having dificulty with a sub part of my query. the goup by command is not having the disired result and i think i have been looking at it too long to see what i am doing wrong. [Code]....
At the moment it is producing each result in many rows when only 4 rows should appear. its the download column that is doing it. needs to be sub queried or something to display total in relation to month,gameid,userid.
I am trying to display this query result in an aspx page.
It is very slow in loading. Here is the query. The inner query inside the outer quesry is the problem.(Please see the underlined part in the query) - (If I remove that part it is very fast.)
select
top 500
--This column is the issue ,Governing_Class=( case when exists (select top 1 tqc.class_code from t_quote_class tqc inner join t_quote_class_premium tqcm on tqc.class_code =tqcm. class_code where tqc.appid=pi.appid and tqc.class_code not in('8742' ,'8810','7380') order by tqcm.premium_amt desc ) then ( select top 1 tqc.class_code from t_quote_class tqc inner join t_quote_class_premium tqcm on tqc.class_code =tqcm. class_code where tqc.appid=pi. appid order by tqcm.premium_amt desc ) ......... From tables
I am a biggner in SQL DB . but i started a complicated and painfull work in SQL SERVER 2008. the problem convert Oracle hierarchical query to SQL query. the query
SELECT DISTINCT LEVEL LVL, SCH.NSCHEDULE_SL, SCH.NSCHEDULE_SL_FM, SCH.CSHED_CNAME FROM FA_SCHEDULES SCH WHERE LEVEL = 1 AND NSCHEDULE_SL_FM IS NULL AND NBRANCH_SL = 2 CONNECT BY PRIOR SCH.NSCHEDULE_SL_FM = SCH.NSCHEDULE_SL AND NBRANCH_SL = 2
actually i got confused in session object,view state,application domain, can u tell me where i have to use these object. can u define some sort of condition in which session object must used & view state must used & diffrence of thses object where we can only use session & where i we can only use view state
We have a controlled list of the users (It s an Extranet solutions for our collaborators)
We need to develop some new web pages (not all) some of which require the user accessing the web page to fill out some form and sign it using his digital signature/certificate. Each customer has their own certificate which he has on his computer (either as a local desktop file or the certificate may be probably integrated into the browser certificates via browser advanced options).
In other words:
1- Allow a client visiting some of the web pages to digitally sign the form before submitting it to our web server (the signature is his specific certificate)
2- Send either the form and the certificate or the html encrypted with his certificate to the web server
3- Read and identify the certificate on the web server (C# code)
What are the licences required for an asp.net (MVC) web application using sql server running a windows server ? Is Windows Web Server 2008 R2 enough for running SQL Server 2008 Web ? Is it possible (legal ?!) to install SQL Server on a "Web" operating system ? What are the limitations ? An official link would be nice
I am using VS2008.I am binding dynamic datatable to gridview. I have few dropdowns and textboxes in gridview. I have dropdownlist(ddlTrCodeNw_)in gridview foooter template. Based on the selection of Trcode value few controls will be enabled,disabled,visible,hide. in gridview.
<asp:GridView ID="gvAPPost" runat="server" Width="100%" ShowFooter="true" AllowPaging="true" AutoGenerateColumns="false" onrowcommand="gvAPPost_RowCommand" onrowdatabound="gvAPPost_RowDataBound" > <Columns> <asp:TemplateField HeaderText="Discount %" Visible="false"> <FooterTemplate> <asp:TextBox ID="txtDiscountPerNw" runat="server" Width="40px" Enabled="false" Visible="false" ></asp:TextBox > </FooterTemplate> <ItemTemplate> <asp:TextBox ID="txtDiscountPer" runat="server" Width="40px" Enabled="false" Visible="false"></asp:TextBox > </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> Intially I set TemplateField HeaderText also Visible="false". so i have written the condition in ddlTrCodeNw_SelectedIndexChanged. Now when if(ddlTrCodeNw.SelectedValue=="24") { txtDepstNw.Enabled = true; txtDepstIncNw.Enabled = true; txtCrdtNw.Enabled = false; txtCrdtIncNw.Enabled = false; lblDiscTrcodeNw.Visible = true; // I want to show this TemplateField HeaderText also when i need. }
I can I show TemplateField HeaderText also whenever i need.
This code is working fine in my local system but when i upload it on server then it gives this error. From the last 1 year it was working fine but from last few days it gives me above said error, please suggest me is there any authentication required to send mail from server (my hosting plan is with 1and1.com)
Trying to get a query going in SQL server but I get bad/ errors in the query.I have a 2 tables. One is the "Project" table while the other is the "Task" table.Table structure is as follows.
A project can have many task. The ProjectID in Task table is the foreign key which reference the project ID.What I need to do is to SUM all the hours in the Task table and group it by quarter and then group it by ProjectID. Output of the SQL should be in the form of projectID,Quarter, Hours.
The remote server returned an error: (407) Proxy Authentication Required.I get it when I use the GetReponse() method in WebRequest Dim request As WebRequest = WebRequest.Create(getNextURL()) Dim httpResponse As HttpWebResponse = CType(request.GetResponse(), HttpWebResponse)
Right off the bat, I hit a wall with the default test added by VS 2010. I forget the exact error now, but it was saying that the tests weren't executed... something about the server. Before I sounds too stupid, the "fix" was to remove the web attributes on the test, causing my tests to NOT need to run through the web server. At this point I have a number of simple, but relevant controller tests up and running.
QUESTION #1.Is it commonplace to run unit tests throught the web server. I have a hard time envisioning that taking place on the build server once I port this solution. It feels much quicker and cleaner to run them directly against the code.
QUESTION #2.I have a security helper class that simply checks to see if the authenticated user is a member of the required Active Directory group before allowing them to perform updates in the application.
I wanted to test it, but the helper uses the HttpContext.Current instance.Should I require this test to run through the web server, or should I change it to accept the context as an argument and mock that context for the unit test? I've installed MOQ, but haven't started the learning process with it yet.
