Hi All, I have an "Acount" and my Acount has multiple "users" . And my user have three settings like App,Web,Key So we have to write XML on this behalf of tree. Structure like - Acount User1 Acount Setting web App Key User2 Acount Setting web App Key I have create XML like same as structure.

protected void _bindTopicPage()
{

    int \_lowerLimit = \_pageIndex \* \_pageCount;
    int \_upperLimit = (\_pageIndex \* \_pageCount) + (\_pageCount - 1);

    string \_str;

    if (Convert.ToInt32(Request.QueryString\["UserID"\]) != 0)
    {
        \_str = "SELECT  dbo.tblUser.FirstName, dbo.tblUserMessage.SubmittedOn, dbo.tblUserProfile.UserID, dbo.tblUserProfile.ImageUrl, dbo.tblUserMessage.Message FROM dbo.tblUser INNER JOIN  dbo.tblUserMessage ON dbo.tblUser.ID = dbo.tblUserMessage.MessageFrom INNER JOIN  dbo.tblUserProfile ON dbo.tblUserMessage.MessageFrom = dbo.tblUserProfile.UserID where dbo.tblUserMessage.MessageTo=" + Convert.ToInt32(Request.QueryString\["UserID"\]) + " order by \[tblUserMessage\].ID desc";
    }
    else
    {
        \_str = "SELECT  dbo.tblUser.FirstName, dbo.tblUserMessage.SubmittedOn, dbo.tblUserProfile.UserID, dbo.tblUserProfile.ImageUrl, dbo.tblUserMessage.Message FROM dbo.tblUser INNER JOIN  dbo.tblUserMessage ON dbo.tblUser.ID = dbo.tblUserMessage.MessageFrom INNER JOIN  dbo.tblUserProfile ON dbo.tblUserMessage.MessageFrom = dbo.tblUserProfile.UserID where dbo.tblUserMessage.MessageTo=" + Convert.ToInt32(Session\["UserID"\]) + " order by \[tblUserMessage\].ID desc";
    }
    SqlDataAdapter da = new SqlDataAdapter(\_str, con);
    DataSet ds = new DataSet();
    da.Fill(ds);

    StringBuilder \_sb = new StringBuilder();
    int \_count = ds.Tables\[0\].Rows.Count;

    ViewState\["\_cccount"\] = ds.Tables\[0\].Rows.Count;

    if (\_upperLimit >= \_count)
        \_upperLimit = \_count - 1;

    for (int i = \_lowerLimit; i <= \_upperLimit; i++)
    {
        \_sb.Append("<div class='scrapGrayBg'>");
        \_sb.Append("<div class='scrapUser'><a href='Userprofile.aspx?UserID=" + ds.Tables\[0\].Rows\[i\]\["UserID"\] + "'><img src='cropimages/" + ds.Tables\[0\].Rows\[i\]\["ImageUrl"\] + "' width='50px' height='50px' alt='' class='imgBdr' /></a><br /><**input name='' id='chk"+i+"' runat='server' type='checkbox'**  class='scrapCheck' value='' /></div>");
        \_sb.Append("<div class='scrapRt'>");
        \_sb.Append("<div class='scrapHdSce'>");
        \_sb.Append("<div class='scrapHd'><a href='Userprofile.aspx?UserID=" + ds.Tables\[0\].Rows\[i\]\["UserID"\] + "'>" + ds.Tables\[0\].Rows\[i\]\["FirstName"\] + ":</a></div>");
        \_sb.Append("<div class='scrapDelet'>" + ShowDateTime(ds.Table

Hi All Please provide code for page ranking as soon as possible. thanks in advance.....

how to fix System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.UIPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. How we solve this problem? Thanks in Advance Regards vivek

I want to make an event calendar, i want that when i click on any date in calendar then submit any types of eventand date color will change???

I am taking a calendar server control for any types of events we submit at particular date any one click on calendar date if any activity is avaialabe then he can see??/so my calendar looking mean design of cal is not attractive bt my require is that my cal must attractive so wht i do ?? plz suggest me soon????????

Hi all I m inserting an event date in my databse like marriage. so we want that before coming marriage date automatic mail will be shoot after a particular time like 1 or 2 or 5 day etc, when that marriage will not be finished. so how we fixed that time that email shoot automatically

Hi I have take a calender and a formview. we want that when we click on calendar any particular date,so that date come in textbox of formview. It's mean ,i am taking TextBox in Formview. How we will fectch that calendar date in formview textbox. plz help me soon????? Thanks Vivek

i ve take two textboxes so i want to compare both textboxes value and print a message that value not same like this with javascript so plz help me soon?????? thanks and regards vivek

i am generating receipt no.let us take 1 to 100 numbers, if i do any entry between 1 to 100 numbers then it show a mssage that this numbers alaready generated? so plz help me soon?? thanks

I am taking five sessions in a same page ,and i remove only one session. can we use Session.abandon for remove single session, if not then wht we use for removing single session. thanks vivek sachan

I am taking three dataset and i want to bind all dataset value in a single gridview.so plz can help me???????? vivek sachan 9582134764 DataSet ds = dut.getDataSet("select Class,CurrentLevel,Name from Tbl_StudentDetails where RollNo='" + Request["RNo"].ToString() + "'"); foreach (DataRow DR in ds.Tables[0].Rows) { string s2 = DR["Class"].ToString(); string s3 = DR["CurrentLevel"].ToString(); string s4 = DR["Name"].ToString(); } DataSet ds1 = dut.getDataSet("select count(Status) from Tbl_Attendence where RollNo='" + Request["RNo"].ToString() + "'"); foreach (DataRow DR1 in ds1.Tables[0].Rows) { string s5 = DR1["Status"].ToString(); } DataSet ds2 = dut.getDataSet("select FMonth,Fyear,TPendingFee,Fees from Tbl_SFee where RollNo='" + Request["RNo"].ToString() + "'"); foreach (DataRow DR2 in ds2.Tables[0].Rows) { string s6 = DR2["FMonth"].ToString(); string s7 = DR2["Fyear"].ToString(); string s8 = DR2["TPendingFee"].ToString(); string s9 = DR2["Fees"].ToString(); }

I want to fetch data from three tables according to itemcode .and item code is entering only two tables. plz help me

I am entered some data through textboxes, i am not saving records in database atfirst we want to show data in like Grid or datatable etc.. after looking data we click on save then it will save,how we will do it. plz tell me some code related this i ve no idea????????? thanks and regards vivek sachan

modified on Saturday, September 26, 2009 1:06 AM

hi sir please tell me how to create a dynamic array in asp.net with c# at run time. help me soon as possible. thanks vivek

Hi EveryBody how to generate an automaticcode in a lebel in asp.net which starting three digit are character and end three are numbers. vivek sachan

plz tell me javascript validation for a textbox for blank and only characters and for only numbers. and tell me how we use this function in textbox event. thanks

Hi sir i want to say my code is for text but i want 2 ask u how we use this code for date format.

How we get XML tag value in MM/DD/YYYY format in .net with c# ?? private string getXmlTagDate(XmlElement xEle, string name) { XmlNodeList xList; string text; xList = xEle.GetElementsByTagName(name); if (xList.Count > 0) { text = xList[0].InnerText.ToString(); text = Convert.ToDateTime(text).ToShortDateString(); } else { text = "00/00/0000"; } return text; } this function work properly for text value and we get this in date format <?xml version="1.0" standalone="yes"?> <NewDataSet> <PinType_TABLE> <pinname>HALF UNIT</pinname> <fullvalue>12000</fullvalue> <percent_value>50</percent_value> <pin_type>P</pin_type> <pin_price>6000</pin_price> <ind_active>1</ind_active> <CreateOn>2009-02-01T00:00:00+05:30</CreateOn> </PinType_TABLE> <PinType_TABLE> <pinname>Full</pinname> <fullvalue>12000</fullvalue> <percent_value>100</percent_value> <pin_type>P</pin_type> <pin_price>12000</pin_price> <ind_active>1</ind_active> <CreateOn>2009-02-03T00:00:00+05:30</CreateOn> </PinType_TABLE> <PinType_TABLE> <pinname>fourth unit</pinname> <fullvalue>12000</fullvalue> <percent_value>25</percent_value> <pin_type>P</pin_type> <pin_price>3000</pin_price> <ind_active>1</ind_active> <CreateOn>2009-05-21T00:00:00+05:30</CreateOn> </PinType_TABLE> <PinType_TABLE> <pinname>s.s</pinname> <fullvalue>12000</fullvalue> <percent_value>0</percent_value> <pin_type>P</pin_type> <pin_price>0</pin_price> <ind_active>1</ind_active> <CreateOn>2009-07-16T00:00:00+05:30</CreateOn> </PinType_TABLE> </NewDataSet>

hi how we create popmenu by html and javascript,plz help me????????