Use Combined Query When No Of Field Are Uncertain?

Feb 14, 2011

Here is idea i have 6 different fields to allow search if i give the option for user to enter value in any of 6 option or enter combined fields how to use sql query to retrieve the value.

View 1 Replies


Similar Messages:

MVC :: Returning Custom Or Combined Query With Linq?

Feb 2, 2010

I have a simple model that contains about 6 tables dealing with customers. As long as I am dealing with one table at a time or returning the single or list of an entire class everything is great. I am struggling with having to return subsets or combinations of the class information. For example customer sales by year.

This query involves these classes:

Customer
CustomerOrder

I need to return something like

CustomerName
Year
TotalSales

I can build the query fine. Returning that to a model is what puzzles me. I have no class that I form a generic.list with and nothing to inherit on the view. What is the best way to handle this?

View 4 Replies

How To Pick Specific Field Besides Primarykey Field Through HQL Query

Oct 24, 2010

how to pick a specific field (besides Primarykey field ) through HQL query ???

View 5 Replies

Web Forms :: SQL Query On Bound Field?

Mar 17, 2010

I have a gridview that displays the results of a SELECT * from a SqlDataSource. Works great. However one of the fields is a Unique ID linking to another table.

Instead of displaying this Unique ID I would like to do a seperate SQL query like, SELECT name from CONTACTS where UID=UID, and display the name of the item that has the matching Unique ID in the boundField, or another field.

View 2 Replies

ADO.NET :: Increase Value Of A Field With Linq Query?

Jan 2, 2011

i am work with linq to sql,i have a table called News,and its class in linq to sql is New

i want will increase value of Counter field when user visited a News

my code look below : but i have no any change in field Value(Counter) why?

//note I change it's ReturnValue to new( entity class of News table in LINQ TO Sql)

// default value for Counter Field is 0

[Code]....

View 1 Replies

C# - Get Date From Datetime Field Mysql Query?

Dec 24, 2010

I want to fetch date from a datetime field, when i select this field in database i get the result as 'yyyy-mm-dd hh:mm:ss' i want the result to be like dd/mm/yyyy

I am developing website using ASP.net C# using Mysql.query i have made is:

//***to get next date
string nextdatequery = "SELECT next_dt
FROM testcase.heardt where fil_no=?
and next_dt>?;";

View 2 Replies

C# - Query Filter Design For String Field?

Jun 14, 2010

A field in my table can have arbitrary strings. On the UI, there is a drop down having options like

All, Value1, Value2

And the results were filtered by the selected option value. So far this is easy and adding new filters to the UI is not a problem. Needs no changes in my stored procedure. Now I want to have an "Others" option here as well, which will return rows not having the column value as Value1 or Value2.

Apparently this will require a "not in" operator in my query, and will make maintenance difficult, as the list of values is likely to change

View 2 Replies

SQL Server :: Using A Database Field As A Hyperlink Query?

Sep 3, 2010

I have three tables in my sql database

contacts

survey answers

respondent_initial

Contacts holds all customer data with custid.

survey answers has assigned everyone how took the survey a number in a field called
respondent_no.

respondent_initial holds input from a webform where I populated it with the custid from contacts and respondent_no from survey answers before the webform input is inserted.I want to send an email to them that had there respondent_no in a hyperlink to the webform so that when they entered their data into the webform it would use the repondent_no to determine where to insert the form data.

Example joe clicks http://www.myplace.com/order.aspx?23

Mike clicks http://www.myplace.com/order.aspx?125

it would look up respondent_no (23) from the respondent_initial table and insert the data in that row in the database for joe's webform entry and it would look up respondent_no (125) from the respondent_initial table and insert the data in that row in the database for mike's webform entry. my code behind looks like this

// Create command
comm = new SqlCommand("INSERT INTO respondent_inital (Practice_Name, Address1, Address2, City, State, Zipcode, Phone, Email, Contact, Dealer, item_9223, item_9129, item_42795, item_30695, item_42834) VALUES (@Practice_Name, @Address1, @Address2, [code]....

View 10 Replies

ADO.NET :: Field Method Missing With LINQ Query?

Sep 7, 2010

I want to access the data from datatable object. When i trying to get the fieldslist usng "Field" method. But I could not find the method with my table object. Eventhoguh i forcibly write a method and trying to access the fields, It is giving the below error for the first join in query. Rest of the lines are fine.

What is the reason behind it.

The errro: "Error 2 'LINQ2DB.SP_VS_OP' does not contain a definition for 'Field' and the best extension method overload 'System.Data.DataRowExtensions.Field<T>(System.Data.DataRow, string)' has some invalid arguments"

What is the meaningof the error. Shall i do any other changes in the query line?

var QueryChnl = from oSPOP in SPOP.AsEnumerable()
join oDiscChannel in DiscChannel.AsEnumerable() on oSPOP.Field<int>("spid") equals oDiscChannel.Field<int>("SPID")
join oChannel in Channel.AsEnumerable() on oDiscChannel.Field<int>("channel") equals oChannel.Field<int>("channelID")
where oSPOP.Mappingkey == 3200004
select new { oSPOP.Mappingkey, oChannel.channel, oDiscChannel.STATUS };

View 1 Replies

SQL Server :: Query Field For Double Quotes?

Mar 24, 2011

using sql server 2005.I need to query some nchar fields to see if any of them contain string with double quotes (char(34)).whats the syntax to do this? I was thinking something like this but I think the first query would get exactly the text Char(34) when I only want to get the double quotes:SELECT fieldA FROM myTable where fieldA LIKE '%char(34)%'ORSELECT fieldA FROM myTable where fieldA LIKE '%'+char(34)+'%'

View 3 Replies

Databases :: Parameterized Query And Date Field?

Sep 17, 2010

[Code]....

This is a query to an old FoxPro database on a server (Same Network). This work in the execution, but just passing the date values as aaaa/mm/dd.On my page when a pass two DateTime Parameters from two TextBox it throw "Unable to recognize the string as a valid DateTime Value"I'm using Ajax Calendar exterder on the textbox to be more specific.Here, (My Country) the format i'm using es dd/mm/aaaaAnd when i select the datepicker it comes in this format, and then a get the DateTime error type.I can get the rows in the query builder just passing the date like "2010/01/15" and "2010/01/30" for example.Hay can i force the texbox to get this format aaaa/mm/dd?

View 4 Replies

Can Cache The Combined Script

Mar 9, 2010

I am building a AJAX intensive web application (using ASP.NET, JQuery, and WCF web services) and am looking into building an HTTP Handler that handles script combining and compression for my JavaScript files and my CSS files. I know not combining the scripts is generally a less preferred approach, and I'm sure it's probably the way I will end up going, but my question is this...Since so many of my JS files are due to the controls I use don't they get cached by the browser after the first load anyway? Since so many of these controls can be found on many of the pages of my web application is it actually faster to combine all of my scripts and serve that one file (which will vary for every page) or to serve the individual files which will get cached? I guess what I'm getting at is, by enabling script combining am I now losing part of the caching ability of the browser? I know I can cache the combined script, but the combined script will be different for every page whereas with the individual control scripts each one will be cached and the number of new scripts will be minimal for each page call.

View 4 Replies

AJAX :: Combined AXD Files?

Feb 7, 2011

Why do I have so many AXD files downloaded...Reducing the number of components in turn reduces the number of HTTP requests required to render the page. This is the key to faster pages. How do I make only one AXD file to be download by the user?hOW DO i MAKE ONLY ONE js FILE ...?

View 3 Replies

ADO.NET :: How To Replace The Field Names In SQL Query String With Variables

Aug 17, 2010

How can I replace the field names in sql query string with variables like:-

string field1="ID";
string field2="Name";
sql = "Insert into [Sheet1$] ('" + field1 + "','" + field2 + "') values('1','abc')";

I am inserting data into an Excel document which has got nearly 100 columns.

I am inserting data using OLEDB as follows:-

System.Data.OleDb.OleDbConnection MyConnection ;
System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand();
string sql = null;
MyConnection = new System.Data.OleDb.OleDbConnection(connectionstring);
MyConnection.Open();
myCommand.Connection = MyConnection;
sql = "Insert into [Sheet1$] (ID,Name) values('1','abc')";
myCommand.CommandText = sql;
myCommand.ExecuteNonQuery();
MyConnection.Close();

I want to specify the field names at runtime as mentioned above - sql = "Insert into [Sheet1$] ('" + field1 + "','" + field2 + "') values('1','abc')"; When I try this I am getting error.

View 12 Replies

SQL Server :: How To Query Only Date Portion Of Datetime Field

Nov 27, 2010

i have one data base field called CreatedDate whos Type is DateTime. Let say i have following Data in this Field

10/7/2010 12:07:57 PM

10/7/2010 12:09:14 PM

10/8/2010 01:02:34 AM

now if i pass date 10/7/2010 to my above table i'll not get any record. what is the best way to query only date portion of DateTime field

View 7 Replies

Crystal Reports :: Concatenate In Formula Field Or SQl Query?

Sep 28, 2010

I need to concatenate address string. Is it better to concatenate using the formula field or concatenate in the Sql query itself? which one would be faster?

View 1 Replies

DataSource Controls :: Finding A Field In A Linq Query

Mar 1, 2010

I have a field name as a string and i want to find it in a linq query. so something like this

[Code]....

View 3 Replies

SQL Server :: Totaling Up The Numeric Values Of A Field In A Query?

Nov 12, 2010

In this query below I need the total of the 'amount' field.

SELECT
[Amount]
FROM
deals_DealBucks

View 1 Replies

How To Make A Set Up With C# And Combined With SQL Server 2005

Oct 3, 2010

am confuse to make setup in following points,1. what is the connection string (basically the server name) to run it on various system.2. what is the actual steps for doing this.3. what files we have to save in our setup and how .4. what software (viz. .net , sql)we needed to install into a system that have no sql server and .net; Can be any alternative in our setup to install these required setup automatically, when my setup run.

View 1 Replies

Mvc Views Not Found When Using Combined With Webforms CMS

Apr 28, 2010

We have a website build in the umbraco 4.1 cms (webforms) default .net 3.5 And we have some MVC tools and controls build with MVC2.0 on net 4.0 i've managed to let the umbraco cms run in .net 4.0 and i've been following parts of this guide (for mvc 1.0 and umbraco 4.0.3) but now i'm stuck, umbraco has alot of url management itself, so i use the urlRewriting.net (included in umbraco) to redirect a certain url, to [URL] for example. i know the url rewriting works (if i force an error into the mvc.ashx i recieve it in the browser window. but each time it gets to the ProcessRequest it throws a "resource not found" error to the screen here is the full code for mvc.ashx that i use

<%@ WebHandler Language="C#" Class="mvc" %>
using System.Web;
using System.Web.Mvc;
public class mvc : IHttpHandler
{
public void ProcessRequest(HttpContext httpContext)
{
string originalPath = httpContext.Request.Path;
string newPath = httpContext.Request.QueryString["mvcRoute"];
if (string.IsNullOrEmpty(newPath))
newPath = "/";
HttpContext.Current.RewritePath(newPath, false);
IHttpHandler ihh = (IHttpHandler)(new MvcHttpHandler());
ihh.ProcessRequest(HttpContext.Current);
HttpContext.Current.RewritePath(originalPath, false);
}
public bool IsReusable
{
get { return false; }
}
}

here is the web.config that i use

<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="urlrewritingnet" restartOnExternalChanges="true" requirePermission="false" type="UrlRewritingNet.Configuration.UrlRewriteSection, UrlRewritingNet.UrlRewriter" />
<section name="microsoft.scripting" type="Microsoft.Scripting.Hosting.Configuration.Section, Microsoft.Scripting, Version=0.9.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" />
<sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
<section name="umbraco.presentation.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</sectionGroup>
<section name="clientDependency" type="ClientDependency.Core.Config.ClientDependencySection, ClientDependency.Core"/>
<section name="UmbracoExamine" type="UmbracoExamine.Core.Config.UmbracoExamineSettings, UmbracoExamine.Core"/>
<section name="ExamineLuceneIndexSets" type="UmbracoExamine.Providers.Config.ExamineLuceneIndexes, UmbracoExamine.Providers"/>
</configSections>
<urlrewritingnet configSource="configUrlRewriting.config" />
<microsoft.scripting configSource="configscripting.config" />
<clientDependency configSource="configClientDependency.config" />
<UmbracoExamine configSource="configExamineSettings.config" />
<ExamineLuceneIndexSets configSource="configExamineIndex.config" />
<appSettings>
<add key="umbracoDbDSN" value="server=sander_pcSQLEXPRESS;database=database;user id=username;password=password" />
<add key="umbracoConfigurationStatus" value="4.1.0.betaII" />
<add key="umbracoReservedUrls" value="~/config/splashes/booting.aspx,~/install/default.aspx,~/config/splashes/noNodes.aspx" />
<add key="umbracoReservedPaths" value="~/umbraco,~/install/" />
<add key="umbracoContentXML" value="~/data/umbraco.config" />
<add key="umbracoStorageDirectory" value="~/data" />
<add key="umbracoPath" value="~/umbraco" />
<add key="umbracoEnableStat" value="false" />
<add key="umbracoHideTopLevelNodeFromPath" value="true" />
<add key="umbracoEditXhtmlMode" value="true" />
<add key="umbracoUseDirectoryUrls" value="false" />
<add key="umbracoDebugMode" value="true" />
<add key="umbracoTimeOutInMinutes" value="20" />
<add key="umbracoVersionCheckPeriod" value="7" />
<add key="umbracoDisableXsltExtensions" value="true" />
<add key="umbracoDefaultUILanguage" value="en" />
<add key="umbracoProfileUrl" value="profiler" />
<add key="umbracoUseSSL" value="false" />
<add key="umbracoUseMediumTrust" value="false" />
<add key="umbracoContentXMLUseLocalTemp" value="false"/>
</appSettings>
<system.net>
<mailSettings>
<smtp deliveryMethod="SpecifiedPickupDirectory">
<specifiedPickupDirectory pickupDirectoryLocation="c:mail" />
</smtp>
</mailSettings>
<!--
<mailSettings>
<smtp>
<network host="127.0.0.1" userName="username" password="password" />
</smtp>
</mailSettings>
-->
</system.net>
<!-- REMOVE FOR BETA -->
<!-- added by NH to test foreign membership providers-->
<connectionStrings>
<remove name="LocalSqlServer" />
<!--<add name="LocalSqlServer" connectionString="server=.sqlexpress;database=aspnetdb;user id=DBUSER;password=DBPASSWORD" providerName="System.Data.SqlClient"/>-->
</connectionStrings>
<system.web>
<!-- <trust level="Medium" originUrl=".*" />-->
<customErrors mode="Off" />
<trace enabled="true" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes" cookieless="false" timeout="20" />
<globalization requestEncoding="UTF-8" responseEncoding="UTF-8" />
<xhtmlConformance mode="Strict" />
<httpRuntime requestValidationMode="2.0" />
<pages enableEventValidation="false">
<!-- ASPNETAJAX -->
<controls>
<add tagPrefix="umbraco" namespace="umbraco.presentation.templateControls" assembly="umbraco" />
<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
</controls>
<namespaces>
<!-- ASP MVC -->
<add namespace="System.Web.Mvc"/>
<add namespace="System.Web.Mvc.Ajax"/>
<add namespace="System.Web.Mvc.Html"/>
<add namespace="System.Web.Routing"/>
<add namespace="System.Linq"/>
<add namespace="System.Collections.Generic"/>
</namespaces>
</pages>
<httpModules>
<!-- URL REWRTIER -->
<add name="UrlRewriteModule" type="UrlRewritingNet.Web.UrlRewriteModule, UrlRewritingNet.UrlRewriter" />
<add name="umbracoRequestModule" type="umbraco.presentation.requestModule" />
<!-- UMBRACO -->
<add name="viewstateMoverModule" type="umbraco.presentation.viewstateMoverModule, umbraco" />
<add name="umbracoBaseRequestModule" type="umbraco.presentation.umbracobase.requestModule, umbraco" />
<!-- CLIENT DEPENDENCY -->
<add name="ClientDependencyModule" type="ClientDependency.Core.Module.ClientDependencyModule, ClientDependency.Core"/>
<!-- ASP MVC -->
<add name="RegisterRoutesModule" type="RegisterRoutesModule"/>
</httpModules>
<httpHandlers>
<remove verb="*" path="*.asmx" />
<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
<!-- UMBRACO CHANNELS -->
<add verb="*" path="umbraco/channels.aspx" type="umbraco.presentation.channels.api, umbraco" />
<add verb="*" path="umbraco/channels/word.aspx" type="umbraco.presentation.channels.wordApi, umbraco" />
<!-- CLIENT DEPENDENCY -->
<add verb="*" path="DependencyHandler.axd" type="ClientDependency.Core.CompositeFiles.CompositeDependencyHandler, ClientDependency.Core "/>
<!-- SPELL CHECKER -->
<add verb="GET,HEAD,POST" path="GoogleSpellChecker.ashx" type="umbraco.presentation.umbraco_client.tinymce3.plugins.spellchecker.GoogleSpellChecker,umbraco" />
<!-- ASP MVC -->
<add verb="*" path="*.mvc" validate="false" type="System.Web.Mvc.MvcHttpHandler, System.Web.Mvc, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
</httpHandlers>
<compilation defaultLanguage="c#" debug="true" batch="false" targetFramework="4.0">
<assemblies>
<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
<add assembly="System.Data.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
<!-- ASP MVC -->
<add assembly="System.Web.Mvc, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add assembly="System.Web.Routing, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add assembly="System.Web.Abstractions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
</assemblies>
</compilation>
<authentication mode="Forms">
<forms name="yourAuthCookie" loginUrl="login.aspx" protection="All" path="/" />
</authentication>
<authorization>
<allow users="?" />
</authorization>
<!-- Membership Provider -->
<membership defaultProvider="UmbracoMembershipProvider" userIsOnlineTimeWindow="15">
<providers>
<clear />
<add name="UmbracoMembershipProvider" type="umbraco.providers.members.UmbracoMembershipProvider" enablePasswordRetrieval="false" enablePasswordReset="false" requiresQuestionAndAnswer="false" defaultMemberTypeAlias="Another Type" passwordFormat="Hashed" />
<add name="UsersMembershipProvider" type="umbraco.providers.UsersMembershipProvider" enablePasswordRetrieval="false" enablePasswordReset="false" requiresQuestionAndAnswer="false" passwordFormat="Hashed" />
</providers>
</membership>
<!-- added by NH to support membership providers in access layer -->
<roleManager enabled="true" defaultProvider="UmbracoRoleProvider">
<providers>
<clear />
<add name="UmbracoRoleProvider" type="umbraco.providers.members.UmbracoRoleProvider" />
</providers>
</roleManager>
<!-- Sitemap provider-->
<siteMap defaultProvider="UmbracoSiteMapProvider" enabled="true">
<providers>
<clear />
<add name="UmbracoSiteMapProvider" type="umbraco.presentation.nodeFactory.UmbracoSiteMapProvider" defaultDescriptionAlias="description" securityTrimmingEnabled="true" />
</providers>
</siteMap>
</system.web>
<applicationSettings>
<umbraco.presentation.Properties.Settings>
<setting name="umbraco_com_regexlib_Webservices" serializeAs="String">
<value>http://regexlib.com/WebServices.asmx</value>
</setting>
</umbraco.presentation.Properties.Settings>
</applicationSettings>
<system.webServer>
<validation validateIntegratedModeConfiguration="false" />
<modules>
<remove name="UrlRewriteModule"/>
<remove name="umbracoRequestModule"/>
<remove name="viewstateMoverModule"/>
<remove name="umbracoBaseRequestModule"/>
<remove name="ScriptModule"/>
<remove name="ClientDependencyModule"/>
<!-- URL REWRTIER -->
<add name="UrlRewriteModule" type="UrlRewritingNet.Web.UrlRewriteModule, UrlRewritingNet.UrlRewriter" />
<!-- UMBRACO -->
<add name="umbracoRequestModule" type="umbraco.presentation.requestModule, umbraco" />
<add name="viewstateMoverModule" type="umbraco.presentation.viewstateMoverModule, umbraco" />
<add name="umbracoBaseRequestModule" type="umbraco.presentation.umbracobase.requestModule, umbraco" />
<!-- ASPNETAJAX -->
<add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
</modules>
<handlers accessPolicy="Read, Write, Script, Execute">
<remove name="WebServiceHandlerFactory-Integrated" />
<remove name="ScriptHandlerFactory" />
<remove name="ScriptHandlerFactoryAppServices" />
<remove name="ScriptResource" />
<!-- ASPNETAJAX -->
<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add name="ScriptResource" verb="GET,HEAD" path="ScriptResource.axd" preCondition="integratedMode" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<!-- UMBRACO CHANNELS -->
<add verb="*" name="Channels" path="umbraco/channels.aspx" type="umbraco.presentation.channels.api, umbraco" />
<add verb="*" name="Channels_Word" path="umbraco/channels/word.aspx" type="umbraco.presentation.channels.wordApi, umbraco" />
<!-- CLIENT DEPENDENCY -->
<add verb="*" name="ClientDependency" path="DependencyHandler.axd" type="ClientDependency.Core.CompositeFiles.CompositeDependencyHandler, ClientDependency.Core "/>
<!-- SPELL CHECKER -->
<add verb="GET,HEAD,POST" name="SpellChecker" path="GoogleSpellChecker.ashx" type="umbraco.presentation.umbraco_client.tinymce3.plugins.spellchecker.GoogleSpellChecker,umbraco"/>
</handlers>
</system.webServer>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="System.Web.Mvc" publicKeyToken="31bf3856ad364e35" />
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>
and the routing file
using System.Web;
using System.Web.Mvc;
using System.Web.Routing;
public class RegisterRoutesModule : IHttpModule
{
public void Init(HttpApplication application)
{
RegisterRoutes(RouteTable.Routes);
}
public static void RegisterRoutes(RouteCollection routes)
{
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
if (routes["Default"] == null){
routes.MapRoute(
"Default",
"{controller}.aspx/{action}/{id}",
new { action = "Index", id = "" }
);
}
routes.MapRoute(
"Root",
"",
new { controller = "Home", action = "Index", id = "" }
);
}
public void Dispose()
{
}
}

i have very few knowledge of mvc, though i am a certified umbraco developer. what i suspect is that there are some routing issues, and the views folder is not found or something like that.

View 1 Replies

SQL Server :: Query To Update The Date Part Only From A DateTime Field

Aug 2, 2010

Could someone giving me the correct T-SQL query to update the Date part from a DateTime field?

To be more clear:

In my table i have 3 Columns, (all are DateTimes):

1. Date

2. StartingHour

3. EndingHour

This is for example one record:

2004-01-26 00:00:00.000

View 1 Replies

AJAX :: Adding To ToolkitScriptManager Combined Scripts?

Jan 6, 2011

I need to $create Ajax Control Toolkit extenders (i.e. DropDown Extender) manually in JavaScript. To do so, the appropriate ACT scripts need to be loaded (i.e. DropDown.DropDownBehavior.js) manually since they are not declared in the page.

Prior to 3.5, I was loading these using the ScriptManager

[Code]....

My manually added DropDownBehavior.js script is loaded **before** the combined script containing all the ACT base classes resulting in a Value cannot be undefined. Parameter name: baseType

error in JavaScript. If I manually load the base types before DropDown.DropDownBehavior.js, I get Sys.InvalidOperationException:

Type Sys.Extended.UI.BehaviorBase has already been registered.

Is there some way to add these scripts either after the `_TSM_CombinedScripts_` or append to the end of it?

View 3 Replies

AJAX :: CalendarExtender Combined With MaskedEditExtender Not Working

Feb 16, 2010

I have a textbox with a calendar extender.

When a date on the calendar is clicked the textbox is filled with the date value in format: dd-mm-yyyy That works...but now I added a MaskedEditExtender on that same textbox field. Now when a date in the calendar extender is clicked the focus is set on the textbox field, the mask shows, but the values are not filled in!

I also checked this post:[URL]but that didn.

Here's my code

[code]....

View 8 Replies

AjaxControlToolkit ToolkitScriptManager Cache Combined Js On Client?

Apr 13, 2010

Usual javascript files can be cached on a client-side if web server sets the expiration. If user has once downloaded it, it will be cached by his browser.And what about AjaxControlToolkit ToolkitScriptManager? Are combined JS files cached on a client? How can expiration time be managed?

View 1 Replies

Security :: Authorization Setting For Combined Applications?

Sep 22, 2010

I am working on a scenario where I need to combine three applications into one (Project Requirement). I link the three applications on a web page and which ever link is clicked, I redirect it to that page.

My application sturcture looks as below

MainPage

- Folder1 with App1 (uses Active Directory group for authentication)

- SubPages

- Folder2 with App2 (Uses Membership roles and users)

- SubPages

- Folder3 with App3 (Uses Other logins for oracle database)

- SubPages

Is it possible to provide authorization only for my App2 based on the role created in membership.

For eg: There is user1 with role1 and user2 with role2 but i need to allow only user1 with role1.

When I was checking this scenario in the ASP.NET configuration settings to modify, it has the allow all permisions which is disabled to modify and it is given that Rules that appear dimmed are inherited from the parent and cannot be changed at this level.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved