Hi, My sharepoint web application which is in Timezone ((GMT+08:00) Kuala Lumpur, Singapore) and my system set to another timezone (GMT = 05:30)Chennai, Kolkata,Mumbai,New Delhi). Now I have been trying to get the current datetime of my sharepoint webapplication. But i am getting different time. I used to following to retrive sharepoint web app current time. SPUtility.GetServerNow(Your spweb object);". But this time is different when i check with the time when i created a list item in that web applciation. Please let me know how to get the sharepoint web app curr time ?

G. Satish

Hi, i have a requirement like as below. I need to get the current url of the browser in the code.Based on that url the logic will depends. The problem is we are doing URL rewriting in web.config. Original URL - http://mysite.com/test/mypage.aspx URLRewrite - http://mysite.com/site/champ In my code if i use Request.URL i am getting URLRewrite one. But how can i get the original url in mycode ? Please suggest me

G. Satish

modified on Friday, October 29, 2010 3:49 AM

Thanks for your reply. It works for me ;)

G. Satish

Hi, The dropdown event is not firing when i changed an item in drop down list. Can any one suggest what's going wrong in my code.

public class FirstWebPart : System.Web.UI.WebControls.WebParts.WebPart
{
DataSet _listData;
string _SelectedValue = string.Empty;
DropDownList ddlList = new DropDownList();
DataGrid dgSpListData = new DataGrid();

    public FirstWebPart()
    {
    }

    protected override void CreateChildControls()
    {
        base.CreateChildControls();

        // TODO: add custom rendering code here.
        
        Label lblAssignedTo = new Label();
        lblAssignedTo.Text = "Assigned To";

        string\[\] Members = { "Satish", "Suman", "Saravana" };
        ddlList.DataSource = Members;
        ddlList.DataBind();

        this.Controls.Add(lblAssignedTo);
        this.Controls.Add(ddlList);
        
        this.ddlList.SelectedIndexChanged += new EventHandler(\_ddlList\_SelectedIndexChanged);
        this.\_SelectedValue = ddlList.SelectedValue.ToString();

        dgSpListData.DataSource = GetListData(\_SelectedValue);
        dgSpListData.DataBind();
        this.Controls.Add(dgSpListData);
        

    }

    void \_ddlList\_SelectedIndexChanged(object sender, EventArgs e)
    {
        this.\_SelectedValue = ddlList.SelectedValue.ToString();
        //DataGrid dgSpListData = new DataGrid();
        dgSpListData.DataSource = GetListData(\_SelectedValue);
        dgSpListData.DataBind();
        //this.Controls.Add(dgSpListData);
    }

    DataSet GetListData(string \_SelectedValue)
    {
        \_listData = new DataSet();
        DataTable \_table = new DataTable();
        DataColumn dc = new DataColumn("Title");
        \_table.Columns.Add(dc);
        dc = new DataColumn("AssignedTo");
        \_table.Columns.Add(dc);
        dc = new DataColumn("Status");
        \_table.Columns.Add(dc);
        using (SPWeb web = SPContext.Current.Site.RootWeb)
        {
            SPList mylist = web.Lists\["MySPList"\];
            SPQuery query = new SPQuery();
            query.Query = "<Where><Eq><FieldRef Name='AssignedTo'/><Value    Type='Text'>" + \_SelectedValue+ "</Value></Eq></Where>";
            SPListItemCollection items = mylist.GetItems(query);

Hi, How we can create ISAM(indexed sequential access method) files?

G. Satish

Thanks Mark, Can you please let me know, how can we create these ISAM files.

G. Satish

Hi, Is there any Dotnet Library to access ISAM(Indexed sequential access method) files ? please let me know Regards Satish

G. Satish

namespace MYConsoleApplication
{
class Program
{
static void Main(string[] args)
{

        int x = 3;
        int y = 2;

        x= (x==y++)?x+y:x-y;

        A ObjA = new A();
        ObjA.M1();
    }
}

interface Inf1
{
     void M1();
     void M2();
}

interface Inf2
{
     void M1();
}

class A: Inf1,Inf2
{
    public void M1()
    {
        Console.Write("test");
    }

    public void M2()
    {
        Console.Write("test2");
    }
}

}

From the above code ..how can i know from which interface the method M1() is overriding in Class A. Please let me know..if this is the case where tow interfaces contains same method..

G. Satish

Thank you. But the code u have given is in DotNet 3.0 I am working in DotNet 2.0. Please give code which works in 2.0. Thank you

G. Satish

Thanks for ur funcion. But its not meeting my criteria..it giving some wrong results.

G. Satish

Pls Can you give code for this? I tried by i am not getting correct order. i am getting result what i have in substr.

string _mainstr = "INDI,GERM,ENGL,SCOT,BLAC,BANG,CHIN,JAPN";
string _substr = "CHIN,ENGL,INDI";
ArrayList ary = new ArrayList();

    string\[\] sub = \_substr.Split(',');

    for (int i = 0; i < sub.Length; i++)
    {
        if (\_mainstr.Contains(sub\[i\].ToString()))
        {
            ary.Add(sub\[i\]);
        }
    }

G. Satish

Hi, the requirement looks easily but i am not knowing how to achieve this. i have two strings as below

string _mainstr = "INDI,GERM,ENGL,SCOT,BLAC,BANG,CHIN,JAPN";
string _substr = "CHIN,ENGL,INDI";

Now i want to remove all other country names from _mainstr which are not in _substr. But the order shouldn't be changed. I am looking an ouput from _mainstr as follows _mainstr = "INDI,ENGL,CHIN"; Here the order is important. How can i get this in c#? Please give an idea

G. Satish

modified on Thursday, March 18, 2010 5:50 AM

Yes. I tried now by using Server.MapPath(). But still same problem loosing sessions and static variables becoming null.

G. Satish

Hi, I have an web application. I am lossing sessions and static variables become null if i use the following code in my application.

public string _xmlfilepath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "App_Code\\Culture.xml");
public string _userfilepath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Users");

Even when i am using this code...the sessions are lost

_userfilepath = Request.PhysicalApplicationPath + "Users\\";
_xmlfilepath = Request.PhysicalApplicationPath + "App_Code\\Culture.xml";

If i use this code then its working fine. Adding paths in web.config

<add key="UserPath" value="F:\MyFolder\Users\" />
<add key="CultureXML" value="F:\MyFolder\Admin\Culture.xml" />

Later i am retirving those paths in application

public string _userfilepath = ConfigurationManager.AppSettings["UserPath"];
public string _xmlfilepath = ConfigurationManager.AppSettings["CultureXML"];

But I dont know the drive names etc at client location to place my application. If i use the appdomain code then where ever this code placed the files will create in that directory itself. But the problem is i am loosing sessions and static variables becoming null. Due to this exceptions are arising. How can i overcome this issue?

G. Satish

Hi, I have written http module to catch the errors from my application and then redirect a user to custom error page. In this case..can't i use try-catch blocks. Since my code contains try-catch blocks..but even it displaying error instead of going to cutom error page. Can you suggest the way to resolve this? Regards Satish

G. Satish

Hi, i created a simple web application in which App_Data folder contains .mdf and .ldf files. When i try to publish this application i am getting below error. "Error 1 The process cannot access the file 'D:\Projects\SqlTest\App_Data\MyTestDB.mdf' because it is being used by another process." How can i resolve this issue?

G. Satish

modified on Tuesday, February 9, 2010 10:27 AM

Thank You. It works fine

G. Satish

Hi, I created one web applicaiton which contains aspx and aspx.cs files. I want this application as exe file to give this to client. So i tried this by adding webseup project to solution and i created a msi/exe file for this project. Up to here every thing is fine. But when i install this appliation it is creating a folder with all aspx and aspx.cs files. But i dont want to place .cs files at client place. I tried by publishing website. Then its is giving dll's. But i can;t make it as exe at that time, bcz its giving error as "already precompiled". what is the solution for my problem? how can i give exe file to client which doesn't contins code files once he installed in his machine.

G. Satish

Hello, The application was developed in .NET and SQL 2005. Originally, we'd thought that it'd be a web-based application (i.e. the SQL database will be hosted by us and users can connect to it). But some clients want the database to be hosted on their computer itself. Of course the application needs the database to run, however, by putting the database on the client's machine we will lose control of our data. I cannot find an easy way that SQL provides to allow only the application to access the data, but not humans. Nothing is altered in the database--we are simply reading data from the SQL table, so should we explore other things (indexed flat files?) to make this into a software product without losing control over the data? The Database size is around 30GB.

G. Satish

Hello, The application was developed in .NET and SQL 2005. Originally, we'd thought that it'd be a web-based application (i.e. the SQL database will be hosted by us and users can connect to it). But some clients want the database to be hosted on their computer itself. Of course the application needs the database to run, however, by putting the database on the client's machine we will lose control of our data. I cannot find an easy way that SQL provides to allow only the application to access the data, but not humans. Nothing is altered in the database--we are simply reading data from the SQL table, so should we explore other things (indexed flat files?) to make this into a software product without losing control over the data?

G. Satish