Hi, This can be achieved by using the inbuilt ValidatorEnable function. Refer http://msdn.microsoft.com/en-us/library/aa479045.aspx[^] for more information.

When you fail to plan, you are planning to fail.

Are you are binding a DataTable to this gridview ? If yes, then add an extra DataRow with the appropriate data at the first position in the datatable.Hope that helps !!!

When you fail to plan, you are planning to fail.

First of all, How is your dropdown list added in the UI? Please make sure you are adding the same dropdown returned from the function in a panel or a table. Secondly do check if your dropdown is filled while debugging in your function scope (Bind_DdlBranch in this case). Hope that helps...

When you fail to plan, you are planning to fail.

Hi, I have an Web Application developed in .NET Framework 4.0 and created an deployment setup for the same. The client requirement is to create an custom Apppool and assign it to the virtual directory which is currently installing. To address this issue i created an custom actions project as described in following article. http://weblogs.asp.net/scottgu/archive/2007/06/15/tip-trick-creating-packaged-asp-net-setup-programs-with-vs-2005.aspx[^] I wrote the following code to create an apppool and assign it to the virtual directory.

private void CreateAppPoolIIS7()
{
using (ServerManager serverManager = new ServerManager())
{
string appPoolName = this.Context.Parameters["APPPOOL"];
ApplicationPool newPool;
newPool = serverManager.ApplicationPools.FirstOrDefault(x => x.Name == appPoolName);
if (newPool == null)
newPool = serverManager.ApplicationPools.Add(appPoolName);
newPool.ManagedRuntimeVersion = "v4.0";
newPool.ManagedPipelineMode = ManagedPipelineMode.Classic;
serverManager.CommitChanges();
}
}
private void AssignIIS7AppPoolToVirDir()
{
using (ServerManager serverManager = new ServerManager())
{
// Find Default Website
Microsoft.Web.Administration.Application newApp = null;
string appPoolName = this.Context.Parameters["APPPOOL"];
// Get the Root website
Site site = serverManager.Sites.First(s => s.Id == 1);
string installpath = this.Context.Parameters["INSTALLDIR"];
installpath = installpath.TrimEnd('\\');
//Get the name of the virtual directory
string virdirname = "/" + installpath.Substring(installpath.LastIndexOf('\\') + 1);

            newApp = site.Applications.FirstOrDefault(x => x.Path == virdirname);
            if (newApp != null)
            {
                newApp.ApplicationPoolName = appPoolName;
                serverManager.CommitChanges();
            }
            else

Thanks for your reply, however i had already went through this documentation after googling the problem. The documentation says that we have a part called "CurrentPageTextBox" of the datapager class which can be styled but the fact that i am using the display mode "FirstLastPreviousNextNumeric" doesn't have a textbox!!!! Why doesn't the datapager have a "CurrentPageButton" or a "CurrentPageTextBlock" part !!!!

When you fail to plan, you are planning to fail.

Hi all, I have developed an application using Silverlight 4.0 which uses the Twilight Blue theme thats available on codeplex. I have a datagrid which uses a datapager whose "DisplayMode" is set to "FirstLastPreviousNextNumeric".My requirement is to highlight the currently selected page in the datapager. I tried myself and was unable to find any style property that corresponds to manipulating the current page style. Googling also didn`t help. Any help would be appreciated.

When you fail to plan, you are planning to fail.

public class TreeItem { public string HeaderTag { get; set; } public List<TreeStatusItem> StatusItems { get; set; } public List<TreeItem> items { get; set; } public TreeItem() { StatusItems = new List<TreeStatusItem>(); } } public class TreeStatusItem { #region Properties [DataMember] public string StatusText { get; set; } [DataMember] public string StatusValue { get; set; } } Here a TreeItem has a HaderTag which displays as the Header for the treeview, the StatusItems contains items of a different type and the items have a List of the container class itself. The sample data would be -RegionName(object of TreeItem type) --Oustanding(object of TreeStatusItem type) --Live (object of TreeStatusItem type) --Areas(object of TreeItem type) ----Oustanding(object of TreeStatusItem type) ----Live (object of TreeStatusItem type) ----SubAreas(object of TreeItem type) ...... ... I need to bind the data which is List<TreeItem> to a silverlight treeview. I can`t figure out how the hierarchical template should be !!!!

When you fail to plan, you are planning to fail.

This one does execute.

DECLARE @SomeLongName VarChar(100) = 'Some long text'

DECLARE @Sql VarChar(1000) 
SET @Sql='DECLARE @temp TABLE( someCode VarChar(10) )' 
SET @Sql=@Sql+
        'INSERT @temp SELECT MAX(SomeCode) ' +
        'FROM MyTable ' +
        'WHERE \[Name\] LIKE''' + LEFT(REPLACE( @SomeLongName, ' ', ''), 3) + '%'''
           
EXEC (@Sql)

The problem here is the scope in which the sql statement executes. The @temp table variable declared is different from the @temp variable used in the inline query as the scope of both the queries are different. To make the query work we need to run the query in same scope ie declare the table variable using the same SQL satements as one used for the query.

When you fail to plan, you are planning to fail.

Hi, I really don`t know whether it`s the right place to post this question. I am using SSRS 2008 and I have a report which has two datasets among which one is a query and other is a stored procedure. The stored procedure is basically used to prepare data and insert it in a physical table from where the other dataset would query and generate the report. My problem is how do i configure the execution of the report so that the procedure executes first and the query executes after the completion of the execution of the stored procedure ? Any help would be appreciated.

When you fail to plan, you are planning to fail.

You may not have configured your website folder as a virtual directory. Hope that helps...

When you fail to plan, you are planning to fail.

Hi, I am using an external css file in my webpage which contains classes defined at control type level. for eg: INPUT { font-size: 12px; font-family: arial,verdana; background: #ffffff; border: 1px solid Gray; } This class gets applied for each and every input control over my page. What i want is some checkboxes on my form should not inherit this class( which it actually does by default) and have there default style. I cant change the external file, so the changes that i should make are in my file itself. Does any body here knows how do i achieve it???

When you fail to plan, you are planning to fail.

Hi, I wan`t to use URL rewriting to map my requests to other page. for eg: http://mydomain.com/101120/54623/Invoice\_14235.zip to http://mydomain.com/Download.aspx?a=101120&b=54623&c=Invoice\_14235.zip Can anybody suggest how this can be done more efficiently and are there any microsoft tools (3rd party is not allowed in my project). Any suggestions wold be welcomed.

When you fail to plan, you are planning to fail.

padmanabhan N wrote:

i have to update only A with B...

If that`s the case then simply update columnA with columnB eg:

update mytable set mytable.columnA=mytable.columnB where .....

When you fail to plan, you are planning to fail.

PIEBALDconsult wrote:

In fact, why aren't you using DateTimePickers?

Actually i am. I have a layered architecture and pass the datetime values as Nullable which allows me to send a null datetime to my SP. Anyways, Luc`s answer fits correctly for me.

AND
(
@frmdate IS NULL OR OrderedDate >= @frmdate
}
AND
(
@todate IS NULL OR OrderedDate <= @todate
)

Thanks again.

When you fail to plan, you are planning to fail.

Hi, I have a table which has a date column "OrderedDate" which can be null in db. Secondly i have a UI which has an frmdate and todate. While querying if the two textboxes are empty i need to show all the records( including the rows with null date). I have written the following query but it fetches the ros with non null values only.

AND
(
isnull(OrderedDate,@frmdate) between isnull(@frmdate,OrderedDate) and isnull(@todate,OrderedDate)
)

I can`t figure out whats the problem. Kindly look into the matter if possible. Thank You.

When you fail to plan, you are planning to fail.

You need to user Server.MapPath() while retrieving the full path. e.g: string strFilename = Server.MapPath(Path.GetFileName(myFile.FileName));//path of a file I guess this should work now.

When you fail to plan, you are planning to fail.

test-09 wrote:

Now i need to search columns from 5 tables How can i do it....

Obviously, you need to join the remaining tables with your existing ones and filter the data from the corresponding columns.

When you fail to plan, you are planning to fail.

This usually happens when you don`t have write permissions on your application folder. Try giving the permissions.

When you fail to plan, you are planning to fail.

modified on Tuesday, December 29, 2009 7:19 AM

Hi, I have SQL 2000 installed on my development machine. Things were fine till yesterday, but then things started turning out nasty. I created an SP with name sp_retrieve_ageinginward_details ( I am aware that naming SPs with "sp_" as a prefix is not good ). Today just to make a minor change i scripted the SP, but it returns an error:

---------------------------
SQL Query Analyzer

[SQL-DMO]Object 'dbo.sp_retrieve_ageinginward_details' was not scripted. It is possible that the information in system table 'syscomments' about the object was corrupt or missing.

OK

Also when i check the script from syscomments it gives me an error in an C++ file.

Server: Msg 3624, Level 20, State 1, Line 1

Location: recbase.cpp:1371
Expression: m_nVars > 0
SPID: 57
Process ID: 556

Connection Broken

How can i retrieve my SP from my DB :sigh: :sigh: , since its huge and i have no backup. :(( :(( Pls help.......

When you fail to plan, you are planning to fail.

Hi, We have a website hosted on godaddy. They have provided us the control panel login. Our project has a home page called "Home.aspx". By default , when the website opens up, it looks for a default.aspx page. So we wrote a simple javascript to transfer the page to home.aspx from a default.aspx page. Unfortunately, since this is a product based website, google refused to index the website because it "doesn`t like redirects". So the only option left is we change the home.aspx to default.aspx, but it would call for a huge change in the already built up project. The other option, we thought, would be asking godaddy to change the default document in their IIS. We called in the support, but "Its not possible" is the only answer we received. If anyone here uses godaddy, where do we find the option for changing the default document in the control panel???? Any other solution is welcomed.

When you fail to plan, you are planning to fail.