Comments by Debabrata_Das

Debabrata_Das 24-Jul-19 7:29am View

sri44 Have you tried the solution that I shared? If not, I would encourage you to try once before getting into any conclusion.

Debabrata_Das 31-Aug-18 7:52am View

It's a Stored Procedure which should be written in the DB. Hope this helps.

Debabrata_Das 13-Apr-17 5:20am View

Sorry friend, but I'm unable to get your concern. Will you be able to rephrase your query or concern.

Debabrata_Das 22-Mar-15 9:51am View

Reason for my vote of 5 \n Excellent article for beginners to mongoDB!

Debabrata_Das 7-Dec-14 9:08am View

Thanks for your comment.
Yes, we've decided to move all the databases to SQL Server 2012 on Windows Server 2012.

Debabrata_Das 12-Nov-14 1:40am View

Yup, that's a good point! :)

Thanks for your valuable inputs. :thumbsup

Debabrata_Das 12-Nov-14 1:32am View

Thanks again!

The requirement is very straight forward. Client has to move up from the existing Windows Server 2003 to any upper version as Microsoft will stop supporting post Jun 2015. Currently, SQL Server 2005 is there in that server.

So, we're considering moving to either Windows Server 2008 or Windows Server 2012. Along with that, the database will be upgraded to SQL Server 2012.

There is no limit of resources (hardware/software). We can get whatever we propose.

Please let me know if you need any other details.

Debabrata_Das 12-Nov-14 1:20am View

Thank you so much for your response!

Can you provide any reference about pros & cons of these options? That would be helpful to take the final decision.

Thanks once again.

Debabrata_Das 1-Jul-14 12:00pm View

Hi Yogesh, Can you please share your aspx changes? Have you used <asp:Button> or HTML button control?

Debabrata_Das 1-Jul-14 11:41am View

my 5!

Debabrata_Das 25-Jun-14 5:27am View

Hello friend, as per my understanding of your query:
You have a web application developed in ASP.NET which allows user to create tables. The activity is time consuming as user has to write the CREATE TABLE statements manually. Now you want to provide feature to create table just like we create table in SQL Server.

Please correct me if I'm wrong.
- DD

Debabrata_Das 25-Jun-14 5:20am View

Hi, can you please share your code changes?

Debabrata_Das 23-Jun-14 2:23am View

Ok, so you want to bind a DataGridView instead of a GridView. Am I correct? If yes, then what is the problem you are facing?

Debabrata_Das 23-Jun-14 2:18am View

Ok, so you can write something like,
Rstring = Replace(Rstring, "Hello", "Hi")
In this case, I've written HTML tag instead of plain text and this should also work. Are you facing any challenge while doing so?

Debabrata_Das 23-Jun-14 2:18am View

Deleted

Ok, so you can write something like,
Rstring = Replace(Rstring, "Hello", "Hi")
In this case, I've written HTML tag instead of plain text and this should also work. Are you facing any challenge while doing so?

Debabrata_Das 22-Jun-14 11:31am View

Hello friend, please share your code changes so that we understand what you've tried so far.
- DD

Debabrata_Das 22-Jun-14 11:28am View

Hello Rahul, your question is incomplete hence doesn't make any sense. We can only help you once you provide more details about the problem/requirement. It would be great if you can share your code changes along with your question.
- DD

Debabrata_Das 22-Jun-14 11:25am View

Hello friend, please help us understanding the issue you're facing. I would suggest you to share the error details that you're getting.
- DD

Debabrata_Das 22-Jun-14 11:22am View

Hello friend, please share your code changes so that we understand the problem.
- DD

Debabrata_Das 22-Jun-14 11:19am View

Hello friend, could you please share your code changes so that we understand your question?
- DD

Debabrata_Das 21-Jun-14 1:58am View

my 5!

Debabrata_Das 20-Jun-14 13:34pm View

my 5!
This is because of your effort to make someone comfortable with his/her question. The beauty in your answer is that you have explained every bits n pieces clearly. Keep up the great work!

Debabrata_Das 20-Jun-14 2:34am View

Deleted

Hello NagaRaju, I have updated the question with your code changes. Henceforth try to follow this approach when you ask any question. :)
- DD

Debabrata_Das 20-Jun-14 2:29am View

Muhamad, could you please accept this solution as answer?

Debabrata_Das 20-Jun-14 0:15am View

Hey Andrew, It's good to hear that! I would request you to accept this solution as answer. You can rate this too ;)

Debabrata_Das 19-Jun-14 1:42am View

Hi Neha, it seems like few closing tags are missing from your aspx code that you shared here.
One more thing, can you please help me understanding the requirement of having a repeater control within a GridView?
- DD

Debabrata_Das 18-Jun-14 6:03am View

Good to hear that :)

Debabrata_Das 17-Jun-14 8:29am View

Could you please share your code changes?

Debabrata_Das 17-Jun-14 8:22am View

Hi, I've modified my solution. Please have a look and let me know if it works for you.
- DD

Debabrata_Das 16-Jun-14 8:56am View

Hello friend, debugging is the best solution to trace any bug within the code. Please set debugger point on the button click event and start debugging.
- DD

Debabrata_Das 16-Jun-14 8:53am View

Hello friend, if you just google "export to excel C#", I'm sure you'll get plenty of ready-made solutions. Pick one of those solutions and give a try. If you're stuck to any specific point, come back and post your question. We'll be happy to help you out.
- DD

Debabrata_Das 16-Jun-14 8:50am View

Hello friend, first of all Combobox or DropDownList control is not a preferred control when you are expecting 1000 items to be displayed. May I ask you what kind of data you're going to display in the control?
- DD

Debabrata_Das 16-Jun-14 4:00am View

Rohan, I've gone through the code changes shared in the question and I didn't find any issue except the part where it's checking whether a Page is postback. As per my knowledge, the check is irrelevant hence suggested to remove the check and try.

Please let me know if you feel otherwise.

- DD

Debabrata_Das 16-Jun-14 3:30am View

Hi Rohan, Are you asking me anything? Sorry I didn't get your post.
- DD

Debabrata_Das 16-Jun-14 3:12am View

Hello friend, this community helps developers when they're stuck solving a particular problem. As a developer, you have to try to solve your problem / requirement. If you're stuck to a specific point, come back and post your query. We'll be happy to help you out. :)

- DD

Debabrata_Das 16-Jun-14 3:05am View

Ok, now try to build your project first. If you get the same error, please update the question with your code changes so that we understand the exact issue.

- DD

Debabrata_Das 16-Jun-14 2:56am View

Hello friend, can you please share what have you tried so far? Please update the question with your code changes.
- DD

Debabrata_Das 16-Jun-14 2:51am View

Yes, you can use any image of your choice to decorate your page.

- DD

Debabrata_Das 16-Jun-14 2:45am View

Hello Reem, looking at the exception, it seems like you're trying to access a control named 'Axi' but it doesn't exist. Can you please check if there is any control with name as "Axi"?

- DD

Debabrata_Das 16-Jun-14 2:11am View

Deleted

Hello friend, please check the spam folder of gmail account.

- DD

Debabrata_Das 16-Jun-14 2:09am View

Hello friend, what is the question?

Debabrata_Das 16-Jun-14 1:23am View

Thanks Nirav :)

Debabrata_Das 16-Jun-14 1:22am View

Hello friend, Please share your code changes so that we know what have you tried so far.
- DD

Debabrata_Das 16-Jun-14 0:48am View

Hello friend, can you please update your question with the aspx changes?

Debabrata_Das 16-Jun-14 0:33am View

You're WC :)

Debabrata_Das 15-Jun-14 11:44am View

:)

Debabrata_Das 15-Jun-14 10:04am View

my 5!

Debabrata_Das 14-Jun-14 13:14pm View

Hello friend, TextChanged is a server side event of TextBox control hence until your page is postback the event will not get triggered.
- DD

Debabrata_Das 14-Jun-14 7:51am View

WC :)

Debabrata_Das 13-Jun-14 12:27pm View

Sorry to say... but I cannot understand the question. Can you explain considering your input how are you generating the output? Take your time and explain properly so that everyone understand your requirement.

Debabrata_Das 13-Jun-14 12:05pm View

Hi Shiva, are you getting any error?

Debabrata_Das 13-Jun-14 11:24am View

Anup, apart from the issue you are facing, there are some other issues with your code.

As a best practice one should not write functionality within an event. In other words, you should write a separate function with the functionality and call that function from any event (SelectedIndexChanged in this case).

You should not form SQL by concatenating parameters which leads SQL Injection problem. Always use SqlParameter object to add parameters.

- DD

Debabrata_Das 13-Jun-14 11:05am View

Hi Sandip, May I ask if you are a student? The intention behind my question is that if you're a student and you need to build a project with the functionality, then using any third-party library would not be an ideal solution. You have to write a parser logic which will read the string and calculate the output.

-DD

Debabrata_Das 13-Jun-14 7:01am View

Anurag, Can you tell me why you tried to add two columns with the same name - "LastAccessTimeForServer1" ?

Debabrata_Das 13-Jun-14 6:35am View

my 5!

Debabrata_Das 13-Jun-14 6:31am View

That is fine but you have to try yourself first. If you are stuck somewhere, people can help you out.
- DD

Debabrata_Das 13-Jun-14 6:28am View

What is the criteria to decide Start Date and End Date?

Debabrata_Das 13-Jun-14 4:17am View

my 5!

Debabrata_Das 13-Jun-14 4:12am View

Nice solution! Here 100.0 is actually doing the upcast into a decimal value hence we're getting the output. :)
- DD

Debabrata_Das 13-Jun-14 3:53am View

If you want to merge the above three data source into a single List (in a single column) then solution provided by Manikanandan10 will solve your problem.

Debabrata_Das 13-Jun-14 3:39am View

Deleted

Ok, but it seems like you do not want to merge three list in a single column rather you want to keep three columns intact. Please correct me if I'm wrong.

Debabrata_Das 13-Jun-14 3:37am View

Deleted

my 5!

Debabrata_Das 13-Jun-14 3:05am View

Did you mean merging three lists into a single object?

Debabrata_Das 13-Jun-14 2:51am View

my 5!

Debabrata_Das 13-Jun-14 1:07am View

Hello friend, please share your code changes.

Debabrata_Das 13-Jun-14 1:02am View

Ok. So if you consider Folder structure is nothing but a Tree structure where root node is the top level (n) folder. From root, you have to traverse to it's child node (i.e. n-1 level) and get all the files. Then you have to move to it's child node (i.e n-2 level) to get the files and so on...

I tried to provide a logical solution as I have never tried such problem. Please let us know if you face any challenges to implement it.
- DD

Debabrata_Das 13-Jun-14 0:50am View

Hello friend, There could be n number of levels in a folder structure. As you mentioned that you want to populate List controls with files from each folder in each level. Since you never know the value - n, how are you planning to create List controls? Are you creating List controls dynamically?
- DD

Debabrata_Das 13-Jun-14 0:43am View

Hello friend, I believe if something is logically correct, then it's possible to implement. But I want to know the reason behind creating new database on every data insert. Can you please explain the requirement in more detail?
- DD

Debabrata_Das 12-Jun-14 12:20pm View

Please share your web.config changes.

Debabrata_Das 9-Jun-14 2:00am View

You are welcome :)

Debabrata_Das 8-Jun-14 9:31am View

Hi, please check if you are calling DataBind() method before you set visible false. It should work for multiple rows as well. If still the issue not resolved, please share your method.
- DD

Debabrata_Das 6-Jun-14 11:36am View

Thank you Sir :)

Debabrata_Das 6-Jun-14 9:39am View

Thank you :)

Please check Solution 2 where I've written a Stored Proc. Hope it will be helpful.

Debabrata_Das 6-Jun-14 4:23am View

Good to hear that. Well, the logic cannot be implemented using a single SQL statement. I would suggest start writing a STORED PROC. If you are stuck anywhere, we are here to help you out.

BTW, since you liked my post, may I request you to provide your rating :p

- DD

Debabrata_Das 6-Jun-14 3:58am View

Hello friend, changing background color of a form is understandable. But I didn't understand the requirement of having Threads. Please add some more details regarding your question. Then we can help you out. :)
- DD

Debabrata_Das 6-Jun-14 3:49am View

Hi Priyanka, I saw that you got your answer. But I could not understand the conversion logic. Can you please help me in understanding it? I'm not looking for any programmatic solution. just want to understand the logic of the problem.
Input | Output
8000022 | 8.2.2
9000002 | 9.0.2
1000111 | ?

- DD

Debabrata_Das 6-Jun-14 3:30am View

Hi,
Let's not jump directly into the actual problem. First try with a simple POC where you can achieve cells merging functionality. Once you are successful, you'll feel more confident and you can implement the same logic into your real program.

Please note the code I shared is not going to solve your problem 100%. It's just a direction and then you have to tweak as per your requirement. :)

- DD

Debabrata_Das 6-Jun-14 2:29am View

Hi,

It will merge the columns whenever there are consecutive cells with same values. I think it will work for your requirement. I would suggest you to give a try and then let me know your findings.

- DD

Debabrata_Das 6-Jun-14 1:58am View

Hello friend, could you please elaborate your question? It would be helpful if you can share some code as well.
- DD

Debabrata_Das 6-Jun-14 1:51am View

my 5 too! :)

Debabrata_Das 6-Jun-14 1:29am View

If you have already solved it, then I don't think there is any requirement of any code. But it would be helpful if you could mark this question as answered so that everyone knows about it.
- DD

Debabrata_Das 6-Jun-14 0:57am View

Hello friend, could you please share your code?

Debabrata_Das 5-Jun-14 10:31am View

Hello friend, I have a query. Can you confirm if there could be multiple records of same ProductId in Product Inventory table?

Debabrata_Das 5-Jun-14 10:18am View

Hello friend, could you provide more details about the problem you are facing?

Debabrata_Das 5-Jun-14 6:01am View

Hello friend, I could not figure out what is the issue. Do you want that whenever user hits Enter key, it should produce the result irrespective of the button is selected?

Debabrata_Das 5-Jun-14 5:56am View

Hello SA, Nice explanation!

One correction is required:
MyTextBox.Text += MyTextBox.Text + e.KeyChar.ToString();

It should be either:
MyTextBox.Text = MyTextBox.Text + e.KeyChar.ToString();
OR
MyTextBox.Text += e.KeyChar.ToString();

Please correct me if I'm wrong.

- DD

Debabrata_Das 4-Jun-14 12:44pm View

Hello friend, can you please share your code? That would be helpful to understand exact problem.

Debabrata_Das 28-May-14 11:57am View

Deleted

I think there is some logical issue in the if-else conditions. There is no check for
if(userExists==1 && passwordExists==1)

Debabrata_Das 28-May-14 11:53am View

Hi, good to hear that your first problem is resolved. Could you please be specific about your other problem that you are facing?

Debabrata_Das 28-May-14 11:47am View

Hello friend, it would be more helpful if you can ask specific question with the related code only. Try to format also, it becomes more readable.

Debabrata_Das 28-May-14 11:01am View

You are welcome! :)

Debabrata_Das 27-May-14 10:27am View

It would be helpful if you could provide some code snippet.

Comments by Debabrata_Das (Top 92 by date)