I Have many entries that have this 'HK' as a kind of prefix. in SQL Server table while i have nothing against HK, the sales person would like this HK removed. the name of this column is categoryname
HK-Dietary
HK-Jan
how to remove master page prefix from control ID after rendering content page
i m using master page in my web application, i am using a java script that works on one of my div id and i am genrating div at run time using C# code, problem is that one one of my content page rendred a prefix ct100 attached on that div,
How can i remove that prefix from my server side control (assume panel) id
Om C# how can i remove all the characters on the left and the #?
Take this: aaaeeae#http://www.sharepointsite.net/Staff/_w/lawn_JPG.jpg'
And make it this: http://www.sharepointsite.net/Staff/_w/lawn_JPG.jpg'
I've a scenerio where i've to create a primary key with prefix Rad####. For example Rad0001. How to do that.
View 2 Repliesin sql server 2000 stored procedure which gives left and right tree counts to parent without using curzors..
using curzors it is dead slow to execute the store procedure when the tree grows..
so i need just left and right count of parent node..
I have 9 tables i need data out of.. 8 of those tables will always just return 1 row of fields that i need. the 9th table can contain many records.. So what i need is a few fields out of each of the 8 tables and then ALL records from the 9th table.. so i know that because there will be multiple records in the 9th table returned, that the fields i pull from the other 8 tables will contain duplicate information and thats fine since i will be displaying the individual records from table 9 on their own page..So everything could be for the same vendor, except for the date in the 9th table that contains specific dates and details about each record returned.When i review the execution plan im getting an yellow exclamation icon on a nested inner join and has this message as the warning: No Join Predicate
Here is what i have, but is returning incorrectly, way to may records, seems to be stuck in a loop.. then below that, i have one that returns the correct number of records, but everything except one column is duplicate, all the TR columns should be unique in the values stored in them.. the rest should all be duplicates, just because its the same vendor, so all the other information will be generic information about that record.
[Code]....
This FROM and WHERE return the correct number of records, but the fields are all duplicated except the last column with is transaction_date, seems that the 3 TR fields are being populated with the first records data or something.. not sure.
[Code]....
i want to delete data from two table using left outer join..
here is my query:
delete from projects p LEFT OUTER JOIN emp_project empp on p.serial_no=empp.projectid where p.serial_no=7
but i am getting error:
Incorrect syntax near 'p'.
I have encountered a problem about "order by" sorting in SQL. As some of the items (strings) in a dropdown list contain negative sign on the left, it is surprising for me that the SQL server cannot sort the items in an alphabetical order and as a result I was forced to set the property value (IsSort = False) of the Ajax ListSearch, which slow down the searching speed a lot. Below are examples of two of the string items with a negative sign on the left.
View 6 RepliesIn ASP.NET, Session_End will be fired when the Session is time out then I can guess the user has left or close the Browser window in this method. But there is some delay till time out, is there any better solution?
View 2 RepliesI have a table in sql having a numeric data type column,Now i want that whenever user left this field blank from front end aspx page, null value should be inserted in this column from stored proc.How can i achieve this? Also what kind of data type is most appropriate on front end for such taking kind of value?
View 2 RepliesI have the following method:
Code:
XmlNode AttributeNode = xmlDocument.CreateNode(XmlNodeType.Attribute, fieldName, WILTSNAMESPACE);
AttributeNode.Value = fieldValue;
parentNode.Attributes.SetNamedItem(AttributeNode);
this create (for example):
<Person d2p1:PersonRole="Boss">
How do I add an attribute without the d2p1: prefix:
<Person PersonRole="Boss">
I want to add a dynamic prefix to the url for some of the Views in my site, e.g. [URL] but am having difficulty. Out of the box I have [URL] but need to set a prefix dynamically. I created another Route in the Global.asax like so, but is is even needed? If it is how do I call it from my controller?
routes.MapRoute(
"Questions", // Route name
"{dyna}/{controller}/{action}/{id}", // URL with parameters
new {dyna = "dyna", controller = "Quote", action = "Questions", id = UrlParameter.Optional } // Parameter defaults
);
I have a C# application with a folder Controls (has three ascx files in it) in the same namespace. This is a sort of toolkit of reusable controls relating to this application. I currently have to register three different tag prefixes to use the controls but this seems messy. How can I reference all controls with a prefix such as mytoolkit:* where * is the name of the control I wish to use?
View 1 Repliesi have an entity called User with 2 properties called UserName and Role (which is a reference to another entity called Role). I'm trying to update the UserName and RoleID from a form which is posted back. Within my postback action i have the following code:
var user = new User();
TryUpdateModel(user, "User", new string[] { "UserName, Role.RoleID" });
TryUpdateModel(user, new string[] { "User.UserName, User.Role.RoleID" });
However none of these updates the Role.RoleID property. If i try the following:
TryUpdateModel(user, "User", new string[] { "UserName, Role" });
TryUpdateModel(user);
The RoleID is updated but the RoleName property is validated aswell. That's why i'm trying to be more specific on which properties to update but i can't get any of the first examples to work.
how to add a prefix value with existing value while updating a column in sql??
View 4 RepliesI have MySqlMembershipProvider working with Asp.Net MVC. My question is how can I configure the table prefix... so instead of 'my_aspnet_' prefix on the tables, I want this to be either none or defined by me. My web.config:
<?xml version="1.0"?>
<add name="ApplicationServices" connectionString="server=localhost;user id=root;Password=*********;database=sparkSources" providerName="MySql.Data.MySqlClient"/>
<authentication mode="Forms">
<forms loginUrl="~/Account/LogOn" timeout="2880" />
</authentication>
<membership defaultProvider="MySqlMembershipProvider">
<providers>
<clear/>
<add name="MySqlMembershipProvider"
type="MySql.Web.Security.MySQLMembershipProvider,
MySql.Web, Version=6.3.4.0, Culture=neutral,
PublicKeyToken=c5687fc88969c44d"
autogenerateschema="true"
tablePrefix="ss"
connectionStringName="ApplicationServices"
enablePasswordRetrieval="false"
enablePasswordReset="true"
requiresQuestionAndAnswer="false"
requiresUniqueEmail="false"
passwordFormat="Hashed"
maxInvalidPasswordAttempts="5"
minRequiredPasswordLength="6"
minRequiredNonalphanumericCharacters="0"
passwordAttemptWindow="10"
passwordStrengthRegularExpression=""
applicationName="sparkSources"
/>
</providers>
</membership>
<profile>
<providers>
<clear/>
<add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/" />
</providers>
</profile>
<roleManager enabled="false">
<providers>
<clear/>
<add name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="ApplicationServices" applicationName="/" />
<add name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" applicationName="/" />
</providers>
</roleManager>
<pages>
<namespaces>
<add namespace="System.Web.Mvc" />
<add namespace="System.Web.Mvc.Ajax" />
<add namespace="System.Web.Mvc.Html" />
<add namespace="System.Web.Routing" />
</namespaces>
</pages>
i have a username= LICTowner.
i need to get the prefix from the word LICTowner i.e LICT.
how to split the word and get the 4 letter prefix.
in asp.net using C#
I am trying to create a xmlElement from my asp page. The result xml node should look like the following:
<str:nam ft:qsType="qsString">NAME_I</str:nam>
I am having some problem putting the "str" prefix before the tag-name. I tried doing:
[Code]....
I get the result as:
<str:nam qsType="qsString" xmlns:str="xmlns:str="urn:instec-corp.com:qsdatamodel:autostructs:v1""> </str:nam>
I am not sure how to get the desired result which should be:
<str:nam ft:qsType="qsString">NAME_I</str:nam>
I am trying to find the most efficient way to prefix listbox item text with their current index.I have two listboxes on a page, the first holds a list of states, the second holds the selection of states. When the user selects a state into the destination listbox, the state should be prefixed with the current index position. The destination box is sorted, and also has buttons to change the item positionsIs there a way to get the index of the item after insertion, instead of looping through the entire collection to add the index?
View 2 RepliesI am using a MaskedEditExtender on a textbox to verify a date. MaskType="Date" Mask="99/99/9999". Users of the system are used to typing just the last two digits of the year (i.e. 22/06/10) so I am trying to make this possible.
I have tried using Century="2000" but this option does not seem to function at all (still results in 22/06/0010).
A response in another forum suggests modifying the MaskedEditBehavior.js file to fix this behaviour - see here.
My question is, how should I go about modifying the MaskedEditBehavior.js file (as suggested in the link above), and how do I ensure that this modification is distributed with my application? I cannot even find this file to modify.
How to Create a function for Prefix generation on each insert row ?I have a table with ID as primary and is identity and increment by 1. and POID another column.Now I need to generate a function like this.In POID Column on each insert I need to set prefix like this
PI000001
PI000002
PI000003
PI000004
PI000005
PI000006
PI000007
PI000008
PI000010
PI000011
and so on ......like this and so on ....
I have a details page containing a form field named UserId. On the same page i have another search form with a field also named UserId.
I am using Html.LabelFor(vm > vm.UserId) and Html.TextBoxFor(sm > sm.UserId) on the two different view models, vm being the view model and sm being the search model. (Yes, the UserId property on the two models has identical names - because they are the same domain property.
When i navigate to the page, the populated UserId on the vm is inserted into BOTH form fields named UserId by MVC. Even the sm.UserId are empty.
That is my initial problem. There are a few ways ti avoid that. My solution was to use the Prefix flag for the sm.
[code]...
My problem is that MVC can't map the Search.UserId (because of the .) to fit the UserId (prefixed with Search) in the action shown above.
So it seems like MVC has a prefix-feature, that are actually nok fully supported through the Route-handler.
Ofcourse i could rename the Search.UserId to Search_UserId, but then the name dosent match the name MVC expects in the recieving action above. (expects Search.UserId) Renaming The UserId property of the search model would fix the issue, but since it is the same value in the domain, this seems like a workaround.
I am returning a table row like so:
[Code]....
One, Two, Three,
But i'm not so sure how to remove the last comma, i have looked at the LEFT and CHARINDEX operators but can't quite figure out the syntax.
The following asp.net side code of control:
<asp:TextBox runat="server" ID="LimitTextBox" Text="20" ClientIDMode="Static" />
Generates such HTML-code:
<input name="ctl11$ctl00$ctl02$TeamPlayerSelector$LimitTextBox"
type="text" value="20" id="LimitTextBox">
ID attribute - as is required, but how can I remove 'name' attribute? It is not required for me and is also too long to transfer it to user browser.
How can I prevent 'name' attribute generation?
i published my site to server and login users with session but this session remove after 30 seconds !!! and user page send error i used this code in web.config buy session remove again
View 2 Replies