Comments by SruthiR - CodeProject

SruthiR 24-Jun-13 6:34am View

this checks only if the string is datestring. But i need to find the format YYYYMMDD.

SruthiR 14-May-13 1:49am View

it did not work. But I used a right join then it worked.
DELETE ObjectsLog.*
FROM ObjectsLog
right join Objects on Objects.ObjectID = ObjectsLog.ObjectID
WHERE CreatedDate <= GETDATE() - 30

SruthiR 14-May-13 1:12am View

CreatedDate is not a column in ObjectsLog table. It is a column in Objects table. Thats why i need another level.

SruthiR 14-May-13 1:04am View

There is no error. But it deletes only the records with ObjectID 1. It has to delete records with ObjectID 2 also.

SruthiR 15-Mar-13 2:48am View

Yes. There are indexes in both the tables. I think the third join is required for their logic which we are completely unaware of.. :( think its tough...

SruthiR 7-Mar-13 6:26am View

thanks .. is there any way to reduce the time..

SruthiR 25-Feb-13 5:49am View

Reason for my vote of 5 \n Great article!! Thanks for sharing..

SruthiR 4-Dec-12 5:02am View

yes it works. It downloads the file also.

SruthiR 15-Nov-12 5:54am View

any update?

SruthiR 3-Oct-12 1:54am View

Output is nothing but updating the values of column Center in AssetOwner table using the above rules.

AssetOwner table should look like this.

Owner, Asset, Center
1. Alex - ABC -Ivert
2. Peter - PQR -SGYt
3. Sam - GHI -RenGT
4. Alex - LMN -IUOy

SruthiR 13-Sep-12 13:37pm View

I wonder why this code does not work for you. It works perfect!! Could you please show the code.

SruthiR 10-Sep-12 5:29am View

Please post your code here.

SruthiR 2-Aug-12 7:24am View

I need to check with min(releasedate) in the search

SruthiR 2-Aug-12 7:23am View

I need to get max(releasedate) in the result

SruthiR 2-Aug-12 7:21am View

It worked. Thanks a lot!!!

SruthiR 7-Jun-12 5:48am View

Tried it. But i am getting the same result..

SruthiR 2-May-12 6:19am View

Thanks. Can u please post a sample code which retrieves the email list from the distribution list name.

SruthiR 10-Apr-12 0:19am View

<pre lang="sql">Set UpdateMode and ChildrenAsTriggers properties of UpdatePanel. This is needed if u want postback from child controls of update panel. Try this.

<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Always" ChildrenAsTriggers="True">
<ContentTemplate>
<asp:Rating ID="Rating1" runat="server" CurrentRating="0"
StarCssClass= "ratingStar" FilledStarCssClass ="filledRatingStar"
EmptyStarCssClass = "emptyRatingStar" WaitingStarCssClass = "filledRatingStar" Visible ="true">
</asp:Rating>
</ContentTemplate>
</asp:UpdatePanel></pre>

SruthiR 5-Apr-12 7:22am View

yes. It is not giving any error now. But i am not getting the output. I have the date values in table still the output is showing null. Need to check. Thank you.

SruthiR 5-Apr-12 6:49am View

Why do you set the CurrentRating in aspx as 3? Keep it as 0.
CurrentRating="0"

In the codebehind, get the rating from database and store to a variable. Then assign that value to your rating control.

LikeRating.CurrentRating = Convert.ToInt16(rating);

SruthiR 5-Apr-12 5:45am View

I tried your solution but i am getting the same error.
As an output i want to get the comma separated dates.There is a table with fields Emplyee and date as below.

Employee NotificationDate
E1 1/1/2012
E1 2/1/2012

I need to show the given dates separated by comma for a specific employee. The output should be as follows.

Employee NotificationDate
E1 1/1/2012,2/1/2012

This is the requirement.

SruthiR 8-Mar-12 3:42am View

Hi, where should i call GetTextBoxValue() method? I tried with replacing the value of StartDate parameter with the function call. But it did not work.

SruthiR 6-Mar-12 6:04am View

Hi, You need not use System.IO.Path.GetFileName. You can directly save the file in the specified location.

string fileName = FileUpload1.FileName;
string fileDest = folder_from_config + "\\" + fileName;

FileUploadZi1.SaveAs(fileDest);

Will solve your problem. Good luck..!

SruthiR 27-Feb-12 6:23am View

Hi,
Thanks for your solution. It really helped. One thing i want to know that is there any way to add the stylesheet before the browser reads the html. i.e. before reading the menu control.

Thanks,
Sruthi R

SruthiR 9-Jan-12 5:08am View

Thanks for the detailed code.. But thats not the issue which i am facing. I am able to open and save the ms-excel with the gridview contents.
But when i get the OpenFileDialogue box and i click 'Open'

i am getting a window message,
"The file your are trying to open Report.xls is in different format than specified by the file extension verify that the file is not corrupted and is from trusted source before opening the file, do you want to open the file now ?"
and then the file opens.
But i don't want to the window message before opening the file. Is there any way to hide the message?

SruthiR 9-Jan-12 3:59am View

This is code i used for export,
protected void BtnExport_Click(object sender, EventArgs e)
{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Report.xlsx");
Response.ContentType = "application/excel";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
updGridView.RenderControl(htw); //Update Panel containing Gridview
Response.Write(sw.ToString());
Response.End();
}

public override void VerifyRenderingInServerForm(Control control) { return; }

SruthiR 9-Jan-12 3:56am View

Deleted

This is code i used for export,
protected void BtnExport_Click(object sender, EventArgs e)
{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Report.xlsx");
Response.ContentType = "application/excel";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
updGridView.RenderControl(htw);
}

public override void VerifyRenderingInServerForm(Control control)
{
return;
}

Response.Write(sw.ToString());
Response.End();

SruthiR 9-Jan-12 3:53am View

Deleted

protected void BtnExport_Click(object sender, EventArgs e)
{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Report.xls");
Response.ContentType = "application/excel";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
updGridView.RenderControl(htw); //UpdatPanel containing Gridview
Response.Write(sw.ToString());
Response.End();
}

public override void VerifyRenderingInServerForm(Control control)
{
return;
}

Comments by SruthiR (Top 28 by date)