Comments by Nayan Ambaliya (Top 44 by date)

Despite us reporting on fortnightly basis, I do have to store it on day to day basis because we can modify working hours for any particular day.

You did not describe how are you binding the gridview. The more code you post, more likely someone can spot on the issue.

Use identifiers in your body text parameter;
Example
This is the PRESAVE email with {{STUDENTID}} and {{STUDENTNAME}} and then replace {{}} with relevant parameters
and the same goes on with POST SAVE (Have different identifiers for variables.
You can also achieve this with String.Format(" {0}, {1}, email contents", StudentID, StudentName); but this will only work if you have same emails with various different variables. I think the first option will work for you.

Are you setting any session variables on the first load? or any variable for global use?
The problem might be that the page you are trying to access is accessing a session variable which may not have been created so far and there is an error handler in place which then redirects to default page. This can be one of the issue.
Look at your code. We can not identify the issue without looking in to the piece of code. Hope this helps a bit.

I tried putting delays but it did not help.. I am going crazy.. and I need this to be out of my way as soon as possible.
I have done a lot of googling on this and nearly there to conclude as other people are saying that this is a bug in IE. But I need a workaround and there has to be a workaround. Please help guys.. I have emptied my brain in this...!!!!

Try using a limited datatype (like VARCHAR(50)) and then try. Hope this resolves as it did in my case.
Indexes also play part here though.

There are two things. "Hide" and "Close" and both have different meanings.. Over the top, there are things like MODAL and NON-MODAL dialogs.

What do you really want to achieve? and what have you tried so far..

what are you trying to say.. ?

Hi Murali,

I think he is talking about desktop applications and not web based applications..!!

In that case, you can create a class with properties.
When the user successfully logs in to your application, you set those properties with the user name and any other required parameters. On log out, you set it back to default values. That way you can identify whether the user is logged in or not.

Let me know if you need any help.

If you can give us more information on what you want to use the cookie information for, it would help us give you options on how to achieve that via different methods. I think cookies are meant for websites and not for desktop applications. I hope this makes sense.

You could use a combination of update panel and user control to have the page loaded and let the data load later and take its time.

However, this might not be your answer.
You need to describe your conditions on why you need to loop through rows and use a table object and not the grid view. Mind well that the more you display on the page, more time is taken to draw it on the page and hence the rendering of the page will be slow depending on your data and logic to show/hide rows.

Please state what technique you use to filter the rows and then to display them.

Refer to the below on code project:
http://www.codeproject.com/Articles/277065/Creating-PDF-documents-with-iTextSharp

yes, the fileName refers to the file you want to transfer.
In your case if you would like to transfer more than one file, you can have an array as an argument and then do all the logic in the UploadFile function.

Hope this clears.

Please mark the above answer as correct if this has resolved your issue. This helps..!!

I think you need to tell us where are you stuck and we can help resolving an issue. This is like you are asking for a tutorial..!!

Please elaborate your question. It does not state what sort of admin panel are you using.. Do you have access to the code/database? Did you try doing anything and encountered a problem ? Sorry but no point in imaging your situation and providing answers in a different direction..

Good luck..!!

I would recommend to update the required field (regular SQL update statement) and at the same time, construct the field 5 and update it as well. All other methods like string replace, etc on either the front end side or SQL side would consume more resources than a regular update. Its just my opinion.

Please clarify your question details more accurately.. Sounds simple but if you can clarify little bit more ('[Under line data it is from 1st Row]' does not help..!!)

Yea.. I noticed it too... It seems like someone is doing their university assignments here... Poor fellow, he thought that he can get away with this.. Sorry bro, but if you have a specific scenario where we can see that you have done something to sort it out but can not, we are then happy to help you..

Thanks Ron, I will take it from here..
Thank you very much for your inputs.

Regards,
Nayan

hmm.. I think you made me think in another direction now with more questions.. I totally take your point, but what I was thinking of using these web services somewhere else (in terms of UI) just to use the same code for multiple UIs.. I think I forgot to mention that in my initial question.. What do you think now..

Hi Ron,

Thanks for the prompt reply.

Ya, I got your point, but, I think, executing data requests via C# directly to SQL via business and data layers would be time consuming and heavy while, using JSON via web services would atleast load the page with data loading indicator. Over the top, JSON is light weight as well which will minimize load on the page.

All request will be outside and nothing is internal here..
What you think ?

Thanks Ron

Hi Ron,

Thanks for your input. What I was really concerned is all about JSON. Am I right by using JSON as an in page technology to trap the data everywhere.. ?

Thanks.

You need to clarify what is inserted on the line:
EXEC spGetTaxAmountForTallyByInvoiceId @Id;

There might be something which is causing this OR because it is # temp tables, something previously entered might cause it since you are not deleting any entries

You need to clarify what this line do:
EXEC spGetTaxAmountForTallyByInvoiceId @Id;

Also you need to tell what you mean by "2nd Row is also wrong"

Hi Kishore,

Thanks for your time.. I am getting the data in a datatable from DB in c# and then binding the treeview in C# itself. Therefore, I do not need data on the client side... Am I doing anything wrong..?? Sorry I am not an expert in this topic..

var selectedCB1 = $("#<%=cmbCB1.ClientID%> option:selected").val();
var selectedCB2 = $("#<%=cmbCB2.ClientID%>").val();

var request;
request = $.ajax({
url: '<%=ResolveUrl("~/AllProcesses/Process156900.aspx") %>?ProcessToPerform=Process156900&CB1=' + selectedCB1 + '&CB2=' + CB2,
type: 'POST',

});

request.done(function() {

$('#<%=pnlProcess156900.ClientID %>').dialog({
width: 850,
height: 700,
show: 'slide'
});
alert($("#<%= tvProcess156900.ClientID %>").children("div").siblings("table").length);
});
request.fail(function(jqXHR, textStatus, errorThrown) {
alert('Error occured: ' + textStatus + ' | Error thrown: ' + errorThrown);
});

return false;

The values are string: Say for example: TargetDirectory: C:\\Data\\ and MemberID: XMIM

Have you thought about the field Level.. It might be possible that for station 2101 and position 1 - there are many levels. And can you clarify what is the 'Row' field for?

--Nayan

Apologies for asking your code..
In your code, you have e.Row.BackColor..
This will change the color of the whole row.

Please see the solution code above.
It has e.Row.Cells[4].BackColor.
This will change the color of the cell only.

Mate,

Please closely have a look at the solution.
It clearly says that e.Row.Cells[4].BackColor. This will only change the cells color.

Please paste your code here if you are still having issues...

Hi Ryan,

Yes, I do understand I will have to re-do everything, but, I am not finding any documentations for WEBI anywhere or an example with C# or anything. All I find is APACHE reference in the ECLIPSE IDE.
Can you please shed some light by examples or web places where I can go and have a look..?

Thanks.

Regards,
Nayan

Thank you very much...
But the web browser control has the limitation of 32 bit and 64 bit machines by its own...
I think I will have to download and delete it as done..

Thanks you very much...

I have done it now.. Thanks.

Thanks Sergey, I will definitely look in to your options..

Ok, I think I am confusing you... Let's see this another way:

Scenario:

The client application is on the user PC and the SQL server database sits on a server on the internet somewhere. The data is saved, updated and deleted from the client application to the SQL server database.

My concern:

Whenever the user either saves, updates or deletes the data, the data sent to the SQL server database will be in plain text format. I need to secure this data during transit.

Can anyone provide me with different options...

Thanks.

Regards,
Nayan

My question is:

How should I secure the data communication from the client to the database (sitting on the internet MS SQL Server)
Should it be normal connection string in a dll or should it be a web service with https etc etc.
I hope this makes you understand my question.

Regards,
Nayan