Comments by Raj.rcr (Top 200 by date)

Oh. I think it was by mistake. Thanks for letting me know. :)

I have not posted this again. I just posted my answer as I have solved it by myself. Check again. thanks

My question was clear. I think you did not understand it. I solved it myself by using history.pushState(null, null, '../Test.aspx?One=numberone'); . It actually chnages the URL without reloading the page and div will not disappear. Thanks

You are right. But, my requirement is this. I want to display the div content after changing my URL because I am going to use the query string of the changed URL for some other purpose. Is there any alternate solution ? Thanks

I tried this. But after 3 seconds, when URL changes, the div will again disappear.

This is what I was exactly looking for... Thanx soooo much :)

Thanks All... I have got the solution after following all of your suggestions..

Thanks a lot.

Thank you... This is what I was looking for..

Thanks all...!

Thank you... ! I will search for some other way..

You mean, it is not possible to embed?

I have downloaded IrfanView which is providing keyboard shortcuts for .tiff images. But, Please suggest me how to embed IrfanView in my ASP.NET application.

I have downloaded IrfanView which is providing keyboard shortcuts for .tiff images. But, Please suggest me how to embed IrfanView in my ASP.NET application.

Thanks all :)

Thank you so much.. I have got the solution from the second URL..

Thanks a lot.. I got the solution..

Sorry, this site is blocked. Any other site to refer?

No indexes are created. I guess, I need to create the indexes to make it work faster. Can u please guide how do I do that?

No, there is no change in the execution time..

Here only the FinalOutput is a View

Yes, I have not created the indexes for this view. But, how to optimize this?

Thank you Abhinav and Simon... The following is the query that is working fine :

UPDATE MyTable SET [Column New] = CASE WHEN RIGHT(LTRIM(RTRIM([Column New])),1) = ';' THEN SUBSTRING([Column New], 1, LEN([Column New])-1) ELSE [Column New] END

But there's an issue with IIf also... What can I use for IIf?

But there's a issue with IIf also... What can I use for IIf?

I am trying a lot by following the links you have furnished.. But, I am not able to make it work for sql server.. plz guide me if u can

Thank you.. But, do I need to remove the following statement from the application?

Dim objAcc As New Access.Application

Thanks.. Fine, I am not going to include sql server in my installation.. But how can I include some other .exe or setup file in my installation?

Thanks for your valuable suggestions. I understand the consequences, but is there a way to install the sql server express along with .exe file to test it in my machine?

Hello, the following is the code written in website1:

public DataTable GetCustomer()
{
DataTable dt = null;
DataSet ds = new DataSet();
try
{
string xmlPath = "~/XMLFiles/Customer.xml";
ds.ReadXml(HttpContext.Current.Server.MapPath(xmlPath));
dt = ds.Tables[0];
}
catch
{ }
finally
{
ds = null;
}
return dt;
}

Here, we are linking xml to the database.. I hope this is the main issue in website2..

Actually we have some reports in both the web sites.. while generating the reports, it takes too much time in website2.. i.e., in all the pages.

In the website1, we are making use of xml and in website2, we are not using the xml.. could that be a issue?

In the website1, we are making use of xml and in website2, we are not using the xml.. could that be a issue?

In the website1, we are making use of xml and in website2, we are not using the xml.. could that be a issue?

In website1, we are using sql parameters in code behind file of a page, where as in website2, we are using sql parameters function in BLL file which is referenced by the Page.. This is the only difference at the coding side.

It has condition.. I mean, It wil insert the sum of a column called sell thru quanity where serial no's are null..

yes, u r right.. I want 2 rows to be inserted at the same time.. One for null values and another for non-null values

syntax error (missing operator) in query expression 'A.[serial numbers] = C.[serial numbers]
LEFT JOIN
MCCMaster ON SellThruMaster.[Eclipse ID] = MCCMaster.[Deal Num]'.

I tried if statement several times but its not working..

I have tried this.. Its giving error for the condition that u have specified here

Hiii Abhinav.. The link you have furnished is really good. But, I am not getting, how to send the names of customer table as parameters to the function which I use in the link provided by you.. Do u have any idea?

Thank you so much for the gud link.. I got the idea of using transactions.

yeah.. I have tried as below:
int var = Logout.Subtract(Login).Hours;
if (var > 3 )
{
lblCount.Text = "0";
}

But the problem is: Even if the condition fails, its still making lblCount as "0".

Login and Logout times are actually getting today's date and time when the user logs in or off.. How to use Hour property for these two?

Hiii Deepthi, its not working yar.. and I have tried the following too.

document.getElementById("TextBox1").focus();

I never post my question before I try....

Thanx a lot. I have got the clear idea and solved it.. my 5

Thank you for the help.. My 5

Thanx a lot... Perfect answer.. My 5

No... I am given this task in such a way that I should not hardcode the menu names.. But they shoud be retreived from the database and appear on the dynamic web page.. i.e, Before I run the application

"you mean you want to see the menu from database when you developing your application, example you want to see them while you working in visual studio ? if so i dont think that is possible."

It sounds like u r right... Its not possible. But I am given the task to use XML and display the menu names which are in database.. and I should not hardcode the items in html tags. Do u think its possible?

dynamically it displays as below:
Root Root Root Root Root Root.....

But I want like this:
Home UserMaintainance MyReport DailyReport Contact About

Hi, the link u have given is really very useful.. I have gone through that.. My problem is, I am getting the menu names from data base in the menu bar only when I run the appication.. But, I want the menu names to be displayed dynamically (on the page before running the application).

Hope u have understood what I am trying to say..

I am not getting, Can u plz tell me how to save the cropped tiff image and then display it on the webpage?

I am using the ScriptManager to display the image as below:

string PDFfileName = string.Empty;
PDFfileName = txtImgPathHid.Text.ToString();
int MyRandomNumber = RandomNo.Next();
ScriptManager.RegisterStartupScript(this, typeof(string), MyRandomNumber.ToString(), "javascript:setsrc('" + PDFfileName + "');", true);

Its working, but can u plz tell me how to display the cropped image using javascript?

Fine SA... Hoping to get ur reply.. cya

Thanks for the info..

Thanks for the links...

SA.. Are you busy now? Please reply as soon as possible.

sorry for the delay SA.. Actually, I am using tiff images in my solution with help of alternatiff plug ins.. The issue is that, when I select the page 1(initial page) of a particular image and click on a button with autopostback property, which calls the image using script manager... it works fine. But, if I select page 2 and click on the same button, again the page 1 is getting displayed. Hope, u have understood the problem.

Hello SA... Hope u r doing well.. I need ur help. Please check out the following post and do me a favor if u can..

http://www.codeproject.com/Questions/195010/using-tiff-image-in-asp-net.aspx

Thanks,
Raj

sorry, its not working.. I followed the same as u posted.. I am really struggling a lot for this.. anyways, thanx for the help..

I have copied the property in code behind and set the CurrentPageNo = 2 in button click event. But, what the next statement does? i.e.,tiff0.GoToPage(<%= CurrentPageNo %>). where to call this??

I can try this. but can u plz gimme an example?

My 5

Thanx... My 5

Thank you... Its working fine..

A baby cannot run as soon as it takes birth. Similarly, the novice developers cannot understand the new stuff. So, they need some suggestions to better understand the things. However, I asked for a good link and not for explaination. If we can do it by ourself, then y is this blog for? Please do not continue this for anyone, if u do not know the solution..

What non-sense is this? We are here to learn the new stuff.. not for making fun of developers. check out the link u have provided once again.

Thank you so much... I have understood the concept and started working on it..

I dnt expect you to write the code for me. I just asked an example code. anyways, thanx for the help

My process is: First I am moving to 2nd page with the link button present in 1st page. And I have a back button in the 2nd page through which I need to move back to the 1st page. My problem is that when I move back to 1st page using back button, the same data should present over there(1st page). Hope u understood. Plz help

No actually, my process is: First I am moving to 2nd page with the link button present in 1st page. And I have a back button in the 2nd page through which I need to move back to the 1st page. My problem is that when I move back to 1st page using back button, the same data should present over there(1st page). Hope u understood. Plz help

I am not able to understand... I am trying but not working

I tried it in button.. Its not working..

The good one Amit. Hope OP will get help from ur answer.. my 5

But, still it doesn't work...

good link.. My 5

Have u tried in other browsers? Is it working fine??

Thank you.. I got the solution..

Thank you SA...

Thank u Mahen...

Thank u Mika...

coding is the problem SA. I can display the same text in 2nd textbox, but dnt knw how to display only the last 4 digits..

you are welcome.

Thanks.. I can now reference the dll file...

ok .. Can u plz give me the steps what u did. I will do the same and get back to u if it works.

I have added the dll file in my project and able to use the same namespace. But getting many errors as the methods will not match that are present in the namespace included... Is this a problem in my solution or ?

you mean, do I need to include only the LumenWorks.Framework.IO.dll file in my project?

yeah it is... I want to do something like,

Update table1 set status='Accepted' where EId=1
select status from table1


Now these are two different statements, but I need to merge both in a single query.. I hope u understood..

I work on stored procedures here... I need a single query for both updating and selecting the columns at the same time.. but not the stored procedure

Sorry i didnt get the proper solution..

Its ok SA.. I can understand.. anyways, thank u so much for the kind reply as well as the way u tried to explain the solution.. I will try it agn and agn until i get the solution for this.
cya

Hiii, I checked it out.. I have gone through this already, butI need to do some changes in InitializeComponent() method. That is the main issue.

I said that because, I have been trying for this from yesterday... But not getting how to get rid of this issue.. anyways thanx for the link .. I will go through that..

Hi SA, Thankx for the links.. I have gone through, but I am unable to convert from System.Timers to Threading.Timers... I am having an issue in InitializeComponent() method.. Can u plz edit my code?

Hi SA, Thankx for the links.. I have gone through, but I am unable to convert from System.Timers to Threading.Timers... I am having an issue in InitializeComponent() method.. Can u plz edit my code?

I tried the code that u have posted to replace.. Its not working. Plz give me some other idea..

how to use Thread.Sleep ? If it is required to use in the code that I have posted, then it vl b helpful for me.

Actually, here I am working on windows service with Timers namespace as I have posted above. But I think, I am given the task to remove System.Timers namespace and Use Thread instead. I have no idea on this.. how to do?

Hi, I am given a task to understand about this, to use it in one of the modules in a project. I searched in google, but didnt understand clearly. So posted here to get better idea.. But, in one of the sites, I saw like System.Timers.Timer is ideal for windows service rather than System.Threading.Thread... So, I am still confused.

well done Mika

Good call. my 5

could u plz post ur code? so that some one can try to rectify this issue.

My pleasure.. Cheers..!

Good link.. my 5

http://www.eggheadcafe.com/community/aspnet/2/10070502/how-to-get-windows-password.aspx

Posted the same solution as above.. But, correct...

Do u want to run the application without the code behind files or what? plz elaborate ur question..

My post and discussion is here, please check it out for more info:

http://www.codeproject.com/Questions/166614/Export-gridview-data-to-excel-2007-format.aspx

string fileName = "attachment;filename=OverallReport_" + DateTime.Now.ToString("dd-MM-yyyy-hh-mm-ss") + ".xls";

Response.Clear();

Response.AddHeader("content-disposition", fileName);

Response.Charset = "";

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.ContentType = "application/excel";

System.IO.StringWriter stringWrite = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

ExcelHead.RenderControl(htmlWrite);

gvOverallReport.RenderControl(htmlWrite);

string s_styleInfo = @"<style> td { mso-number-format:""" + "\\@" + @"""; }</style>";

string s_excel = stringWrite.ToString();

Response.Write(s_styleInfo + s_excel); Response.End();

The above code is written for 2003 format. But I tried changing the content type by searching in google.. .xlsx is also not working

Mr.Ramalinga, I have been searching for a solution to export the gridview data into excel in 2007 format. I tried in many different ways, but till now I didn't get the solution for it. Even in this website also.. I hope u can help me.. Thanks

---
Raj

Very good Link.. My 5

My pleasure..!

I think, u may need the answer that costica has posted in the second solution.. Just a minor modification as in my code.. Follow the second solution..

Atleast, OP should have replied for any of the answers or comments posted here.. I think u r right..

Can u please explain in detail ?

According to his requirement, this is just an idea.. I think, OP can use this for dropdownlist and also the textbox..

My 5

Not clear..!

Simple answer...my 5

Hi everyone... Thanks for ur no response. Anyways, I got the solution for this issue.. cya

I tried this also. An error says:
"Excel cannot open the file 'UserProdReport_10-03-2011-10-24-44.xlsx' because the file
format or file extension is not valid. Verify that the file has not been
corrupted and that the file extension matches the format of the file.

Yes, for the first time I had changed with this contrnt type.. It didnt work. Then I removed the extension..

hi, you have given the link for 2003 format. I want it for 2007 format..

This is not working.. I had tried the same before posting this question over here..

Noooo.. Its not working.. I tried this..!

I tried.. but not getting the solution as I need...

I am given the task not to use PIVOT... Can u plz give me an idea using the loop, where we can use alter table and exec sp?

Perfect Answer.. My 5

No, I want to use the loop to get display result in the format I asked.. I have gone through the link, there is no looping condition at all..

You can simply use either a message box or textbox to display the result..

yes, The for the same select query that u have noticed.. I tried what u posted. But its not working.. I think using 'pivot' can solve the problem.. But, I don't know about pivot

Yep, u r right.. I heard the same from my ofc mate.. But, how to display the Total row? Is there any other idea?

No, I want 'NewDate' as the 'GRAND TOTAL'. That means, one more row called 'GRAND TOTAL' as a last row of the 'NewDate' column. sorry, I guess, my question was bit confusing.

Now check..

not copied. But its there in one of the pages of our project. I want to use the same in another page. Thats it. Ofcourse, I have not written this code. I am trying to understand the logic behind this.

I tried changing the value instead of zero(0) in the following.
string lnkid = dt.Rows[i][0].ToString();
Please have a look.. Its not working

I tried by removing the if statement and did what u suggested, but still i am not able to get the link for the specific column..

Perfect solution for which I was looking for.. Thank you sooooo much Mr.Morley.

Hello Mr. mkgoud.. U are right, I want to pass the day as a parameter and get the data as I have mentioned in my question. Can u plz edit my code and give me what am looking for? Hoping to get ur reply.. thanks

I tried but its displaying the different format for a specific day. I want the date to be displayed as say, if I pass the day 24 as a parameter, then it should display

24/01/2011
24/02/2011
.
.
.
.
24/12/2011.I hope u undrstd now.

Not able to understand... Can u plz tell me according to my procedure..?

Thank you so much... Its working.

Exactly, This is what I needed. Thank you I will try now... and get back in few minutes..

I am getting the data based on the specific month selected from dropdwonlist.. there is no problem in that.. But I want the gridview data to b displayed based on the specific day of specific month using the same dropdownlist.. The entire task is depending on the stored proc.. I hope u understand what I am saying..

I am not at all using Linq anywhere in my project. I can fetch the data through the connection string defined in web.config.. So, except Linq, any other idea to do this?

Yes.. I tried for both.. It gives an error if I add..

I have revised the question. you can now see the gridview..

I have revised the question. you can now see the gridview..

I am using the second step... where gridview's "autogeneratedcolumns=true" I can provide the stored procedure but its too lengthy.

No, I am also using VS2008(3.5)... But using System.Linq is not working, if I try to include it. What might be the probelm?

I think u r talking about using LINQ namespace. but in my VS edition, there is no LINQ namespace.

Actually I am using the "button" to display the data after selecting the month from ddl.

Sorry, I am not able to understand the code u have provide.. any other idea?

No.. I have listed the month names with values from 1-12

Thanx for the answer.

Yeah got it... Its working as I needed. Extra column doesn't affect the drop downlist. Thank you soooooo much.

The edited part is working as per my requirement but one more column called ForOrdering should not be displayed.

I really tried both.. Its not working.. Please take 'Select' instead of 'All' to avoid the confusion and
suggest me.

ya.. I tried this also.. Its not working.

This is same as the above one. 'All' should always be on Top in the dropdown list. Thats not possible with this query.

But, 'All' should always be on Top in the dropdown list. Thats not possible with this query.

No, I am not using repeater or gridview. I am looping through html code and using the <tr> data, I am getting the database column's counted values. But the problem is, if I click the particular value, I want another page to be redirected with the details of the counted values.

Nothing is fuss around the tif image. Its being displayed. But u didn't understand the actual issue. Please don't comment if u do not know the solution.. Thanx

sorry, its not working... I tried with the link button..

The .tif file consists of a border that includes page no.'s. I think its really hard to find the solution for it. Very less programmers can solve it. But still I hope, some one vl give me an exact way to handle this issue.

Its ok.. I will handle this..! Anyways, thanx...

can I have ur id, so that I can send u .tif file.. You will surely understand.

No. Its a .tif as I alrdy mentioned.. When, the page loads, the .tif image will be displayed with the page numbers, so that the user can select different images..

Please anybody help me.. Its an urgent task

Yes, its postback and it goes to page 1. Each image means, its a .tif image that includes 2 pages(images)

I didnt understand how to explain. so I replied with code.. Its actually .tif image including 2 pages.. Please gimme an idea to solve this

Yes. the following is the code:

<asp:RadioButtonList ID="rbtnDataMatch" runat="server" RepeatDirection="Horizontal"
Style="font-size: 10pt;" AutoPostBack="true" OnSelectedIndexChanged="rbtnDataMatch_SelectedIndexChanged">
<asp:ListItem Text="Yes" Value="Y"></asp:ListItem>
<asp:ListItem Text="No" Value="N"></asp:ListItem>
</asp:RadioButtonList>

protected void rbtnDataMatch_SelectedIndexChanged(object sender, EventArgs e)
{
if (rbtnDataMatch.SelectedItem.Value == "N")
{
trDbMatchBtn.Visible = true;
trDbMatch.Visible = false;
txtMobileNo.Text = "";
txtConfirmMob.Text = "";
txtMobileNo.ReadOnly = false;
txtBarcode.Text = "";
txtConBarcode.Text = "";
txtBarcode.ReadOnly = false;
}
else if (rbtnDataMatch.SelectedItem.Value == "Y")
{
SaveMobCode();
}
string PDFfileName = string.Empty;
PDFfileName = txtImgPathHid.Text.ToString();
int MyRandomNumber = RandomNo.Next();
ScriptManager.RegisterStartupScript(this, typeof(string), MyRandomNumber.ToString(), "javascript:setsrc('" + PDFfileName + "');", true);

}

Thank you... I got the idea..

excuse me.. this is not the same question.. Check it out properly..

ya its correct.. but I want to know how to display the pop up window as an url..

can anyone please give me an idea for this...?

I tried yesterday... But I didnt get.. still I am trying for the same.. Can u plz gimme the idea of writing the csv file?

is it not possible without using the button?

Is anybody there? please suggest me on this..

actually I am calling the javascript function "rbtnconfirm()" through C# code..

Is anybody thr? please reply

Use html tags for getting and setting the position of any control on ur form. You can do a lot with html..

You said be patient and I accepted ur words. But till now I have got no suggestion from any one for my problem..

I tried... but it doesn't work...

please any one reply...

Thank you very much for perfect answer... I tried implementing the same. Finally, I got the solution. Thanx agn.

But its a stored procedure. I want to use it in select statement only. You can see that below INSERT..