Click here to Skip to main content
15,122,218 members

Comments by Oshtri Deka (Top 200 by date)

Oshtri Deka 1-Oct-20 4:51am View
Use punctuation marks. It is hard to read.
Question is to vague to be given exact answer.
Oshtri Deka 1-Oct-20 4:49am View
:( Didn't know that.
Yet I've posted "solution".
Oshtri Deka 1-Oct-20 4:40am View
Write entire method.
What is the structure of both tables?
How do you fetch data from db?
Oshtri Deka 29-Sep-20 7:30am View
I agree, don't complicate.
Oshtri Deka 28-Sep-20 13:06pm View
1. I agree with Richard's remark.
2. How long is that varchar column in DB?
3. Write us error text your receive.
Oshtri Deka 28-Sep-20 12:12pm View
Where is return statement of PostString method?
Oshtri Deka 28-Sep-20 11:44am View
From what I understand his problem is only in NULL value in pid_proexpiry column.

Your advice is good, code in question is a mess.
Oshtri Deka 14-Dec-17 4:12am View
Oshtri Deka 12-Dec-17 5:55am View
Can you share an example of data assigned to d?
Oshtri Deka 12-Dec-17 5:40am View
Give us code!
Without it we can only guess.
Oshtri Deka 12-Dec-17 5:39am View
Valid point, your approach is more concise.
When it comes to parentheses, every coder should pay attention.
Oshtri Deka 10-Dec-17 22:10pm View
Please explain how does it not work?
Oshtri Deka 10-Dec-17 21:43pm View
Oh boy, that is one long explanation for a common error. :)
Anyhow, it is honest and educational.
Oshtri Deka 13-Mar-15 5:32am View
Do you want all records concatenated inside label?
Oshtri Deka 13-Mar-15 5:26am View
Is service online? Can you reach it with your browser?
Oshtri Deka 8-Jan-15 5:09am View
Thank you.
Oshtri Deka 8-Jan-15 5:08am View
Oshtri Deka 8-Jan-15 3:54am View
That will work if data is binded in a form of a table.
What if he has binded data in a form of an IList?
Oshtri Deka 8-Jan-15 3:51am View
Is it ASP.Net or Windows application?
Oshtri Deka 8-Jan-15 3:49am View
Which kind of barcode? There are many standards.
Do you want to generate barcode picture or only to genereate barcode number?
Please give us more information in order to give you good answer.
Oshtri Deka 21-Nov-14 2:03am View
Superior English skills?
Lack of professionalism?
Oshtri Deka 26-Sep-14 4:31am View
Thread.Sleep(N) is sufficient. Solution with timer is IMHO overkill and only adds to complexity.
Anyway, my 5.
Oshtri Deka 26-Sep-14 4:21am View
In your original post you haven't mentioned that you use MySQL.
I am not clairvoyant!

Oshtri Deka 25-Sep-14 7:54am View
I'm having serious trouble with inserting links.
What have I missed?
Solution as it is looks like crap.
Oshtri Deka 25-Sep-14 7:02am View
Are there any exceptions thrown?
There is no need to upload entire markup and code behind. Now we have this behemoth which is not pretty nor very readable.
Oshtri Deka 23-Sep-14 3:22am View
In this state your code is hard to read, how about some basic formatting?
Oshtri Deka 23-Sep-14 3:12am View
Oshtri Deka 22-Sep-14 3:09am View
Kind of harsh, but true.
Oshtri Deka 22-Sep-14 3:08am View
I am sorry, but I must inform you.
This is the very kind of question that most people around here find extremely annoying.
Oshtri Deka 21-Aug-14 11:53am View
If I have understood you correctly, you just have to skip first two strings in concatenation ('/' + 'new value') which will leave you this:
SUBSTRING(ReportLocation, CHARINDEX(ReportLocation, '/', 2), LEN(ReportLocation)).

I hope this helps.
Oshtri Deka 19-Aug-14 17:23pm View
My 5.
Oshtri Deka 19-Aug-14 17:22pm View
Oshtri Deka 14-Aug-14 3:24am View
My bad, questions sound similar, but now I think they are not.
Though both are equally bad!
Oshtri Deka 14-Aug-14 3:17am View
Where is the question?!
Oshtri Deka 14-Aug-14 2:21am View
You have posted similar question only minutes ago!
Oshtri Deka 12-Aug-14 8:39am View
Just set combos after filling to some default value or index.
For instance monthCombo.SelectedIndex = 0 and adjust above mentioned checks accordingly.
Good luck!
Oshtri Deka 12-Aug-14 7:53am View
What have you tried so far to detect problem source?
I suggest you to invest some time to learn and implement some logging mechanism, without it you are virtually blind.
Check EventViewer and IIS logs, that's all I can do for you unless you provide more information.
Oshtri Deka 9-May-14 6:52am View
Reason for my vote of 1 \n Too short
Oshtri Deka 31-Mar-14 3:56am View
Bad question.
First there is too much code. We don't need entire html.
What kind of calculation do you need? +-/*%?!?
Which columns should be involved in calculation?

Improve it!
Oshtri Deka 28-Mar-14 10:59am View
Oshtri Deka 28-Mar-14 6:12am View
C'mon, try harder!
This isn't quantum physics.
Oshtri Deka 28-Mar-14 3:35am View
Can you please improve your question?
Perhaps it too early for me, but I'm having trouble with reading your last sentence.
Oshtri Deka 27-Mar-14 10:21am View
Can we see some code?
What sort of application is this?
Service? WebApp?
Oshtri Deka 27-Mar-14 10:19am View
What do you want? Current time somewhere in the header?
Or in the specific cell?
Oshtri Deka 26-Mar-14 16:46pm View
I could swear MacOS tag wasn't there when I've read it the first time.
According to this:
it is not possible at this time.
Oshtri Deka 26-Mar-14 8:44am View
What does resetcontrols() method?
Have you debugged it? Is SFRID set to some value other than empty string?
Oshtri Deka 22-Mar-14 17:20pm View
Lately I only use custom methods and Entity framework, but I'll never say they're best choice.
I have no professional experience in LINQ to SQL, but I doubt I'll ever try to use it. It's OK technology, but it's not evolving.
My choice of technology depends on data source, client's demands and how soon it must be done.
Oshtri Deka 12-Jun-13 6:34am View
Reason for my vote of 2 \n It's not bad, but it isn't very good either.
You should make another example and work on introduction.
Oshtri Deka 12-Jun-13 5:25am View
Reason for my vote of 5 \n Informative and clear.
Oshtri Deka 12-Jun-13 3:13am View
In all honesty, this code means nothing to me... give us code of your Print method.
Oshtri Deka 6-Jun-13 13:17pm View
If you like this answer, up-vote and solution acceptance would be nice.
Oshtri Deka 6-Jun-13 6:22am View
I think I understand what is troubling you, but that is one poorly written question.
Oshtri Deka 5-Jun-13 15:46pm View
I gave 5 to answer 1, therefore I must give it here as well.
Oshtri Deka 5-Jun-13 15:45pm View
Valid answer. 5.
Oshtri Deka 5-Jun-13 15:41pm View
Right click on any object inside code (while in Visual Studio), for instance right click on OpenDataTableThroughAdapter method. That action will open context menu with above mentioned actions.
Oshtri Deka 10-May-13 3:32am View
I like this answer, but would suggest using stored procedure (if possible).
Oshtri Deka 9-May-13 7:32am View
Show us your code and error message.
Oshtri Deka 9-May-13 7:31am View
What do you mean?
Do you want to add control VS Toolbox pane or do you want to learn how to use it?
Oshtri Deka 2-May-13 8:59am View
Long, but correct answer. ;)
Oshtri Deka 2-May-13 8:58am View
OP tagged this question as C#.
Oshtri Deka 30-Apr-13 3:04am View
Which particular format?
Do you really need to use cursor, i.e. loop?
Is there particular reason for using three tables or it was your idea?
Oshtri Deka 29-Apr-13 14:47pm View
Windows Forms?
Oshtri Deka 29-Apr-13 6:13am View
Is this web forms or win forms project?
Oshtri Deka 29-Apr-13 6:06am View
Yes it is.
Oshtri Deka 29-Apr-13 5:58am View
Is this homework?
Oshtri Deka 29-Apr-13 5:21am View
What have you done so far?
Can you show us your code?
Oshtri Deka 12-Apr-13 4:42am View
Can you share a code responsible for filling status bar text?
Oshtri Deka 4-Jan-13 5:35am View
Oshtri Deka 13-Nov-12 3:34am View
Yes, improve this.
Oshtri Deka 11-Oct-12 4:44am View
What the...?!?
Please improve your question. Here we have savants, but not seers.
Oshtri Deka 11-Oct-12 3:35am View
Have you tried to remove and add reference again?
Oshtri Deka 11-Oct-12 2:46am View
Googlable, but nonetheless very good question.
Oshtri Deka 11-Oct-12 2:44am View
That's right.
There were significant changes from v2.0 to 3.0(3.5).
My 5.
Oshtri Deka 11-Oct-12 2:09am View
Let us see your code.
Oshtri Deka 9-Oct-12 3:48am View
Oshtri Deka 7-Oct-12 16:21pm View
Very good starting points.
Oshtri Deka 4-Oct-12 11:20am View
Oshtri Deka 4-Oct-12 11:01am View
Why don't you read about Replace method? I've supplied you a link.

In short Replace method finds ALL references of particular string and replaces it with with another. It's simple as that.
Oshtri Deka 4-Oct-12 6:20am View
To many parameters?!
Does the procedure fill only one or several tables? I'm just being curious.
Oshtri Deka 4-Oct-12 6:16am View
I agree!
Oshtri Deka 2-Oct-12 7:18am View
Can we see the code?
Oshtri Deka 1-Oct-12 13:56pm View
Do you create PDF with data you data from SQL Server 2005?
Oshtri Deka 29-Sep-12 5:41am View
Best advice I can give you is to use Google and to talk in person with shop owners/managers/employees you know.
Oshtri Deka 28-Sep-12 3:22am View
You should really try Google first.
Oshtri Deka 28-Sep-12 3:21am View
IMO second link is a bit over the top for beginner.
Oshtri Deka 28-Sep-12 3:19am View
This is not correct place for l33t
Oshtri Deka 28-Sep-12 3:18am View
Good link.
Oshtri Deka 26-Sep-12 3:43am View
//in ms access datatype: autonumber
oda.UpdateCommand.Parameters.Add("@sn_s", OleDbType.Integer).Value = textboxFirstname.Text;

The last part looks suspicious - textboxFirstname for identity value?!
Or you tend to give strange names to your variables.
Oshtri Deka 26-Sep-12 3:36am View
Need more details.
Oshtri Deka 26-Sep-12 3:35am View
1. Give as tables' schema (i.e. columns).
2. Do you want to insert data (update records in one table with data from another) or you want result-set which combines data from two tables?
Oshtri Deka 26-Sep-12 2:43am View
Thank you.
Oshtri Deka 25-Sep-12 6:28am View
Thank You!
Oshtri Deka 6-Sep-12 4:57am View
Schema looks strange. Is this school or professional project?
Oshtri Deka 5-Sep-12 2:38am View
Can you rewrite your question and use proper punctuation?
You know, as if you want people to understand your problem.
Oshtri Deka 5-Sep-12 1:52am View
Wouldn't a Resources be a more convenient place to store an image?
Oshtri Deka 3-Sep-12 7:33am View
Correct. 5.
Oshtri Deka 3-Sep-12 7:30am View
Your question is not very comprehensive.
Can you please use punctuation and rephrase your question?
If I deciphered it correctly, you want to create a program which will be copied on memory device and auto-run each time device is connected to pc?
Oshtri Deka 3-Sep-12 7:23am View
Can we see the code please?
Oshtri Deka 3-Sep-12 4:02am View
You are checking if there is any record inside a table.
I believe OP wants to check for particular values.
Oshtri Deka 24-Aug-12 3:24am View
Oshtri Deka 8-Aug-12 7:14am View
No code, sqlDataSources call stored procedures, page was meant to be for presentation only.
It rarely returns more than 35k rows. Schema is datetime2, int, int, int
and date int, int, int. Integers values are up to 3k.
Oshtri Deka 1-Aug-12 5:33am View
You rewrote code to C# and then post it here in comments.
I think it would be better if you "move" it from comments to your solution, i.e. replace VB code with C# code.
Oshtri Deka 1-Aug-12 5:30am View
You posted same question twice!
Oshtri Deka 1-Aug-12 5:23am View
Thank you.
Oshtri Deka 1-Aug-12 5:23am View
Don't you have edit button?
Replace original code with one in reply to my comment.
Oshtri Deka 1-Aug-12 5:00am View
I believe OP wants C# example.
Oshtri Deka 1-Aug-12 4:31am View
What is your problem?
Saving Data to DB or behavior of your GUI?

Share some code to make your request more clear.
Oshtri Deka 24-Jul-12 18:10pm View
Bummer. =/
Oshtri Deka 13-Jul-12 3:17am View
DataReader, adapter, etc. are under the hood in SqlDataSource.
I have no code, all is done with Configure Data Source.
Oshtri Deka 13-Jul-12 3:14am View
As I said it takes less than 1s when I execute it in Management studio.
Oshtri Deka 28-Jun-12 6:52am View
As I wrote before, I've done that and it doesn't help.
Oshtri Deka 24-Jun-12 11:28am View
Oshtri Deka 19-Jun-12 8:54am View
Why don't you rewrite your query to return only columns you are interested in?
This straight-forward -- SELECT [columns you want] FROM [table of your choosing].
So what's the problem?
Oshtri Deka 19-Jun-12 8:47am View
To the point.5.
Oshtri Deka 14-Jun-12 9:26am View
Reason for my vote of 5
That's it?!
Oshtri Deka 12-Jun-12 10:09am View
WinForms or Asp.Net?
Oshtri Deka 12-Jun-12 6:24am View
"BESART-ARSENAL\SQLEXPRESS" isn't name of a MySQL server or you have twisted sense of humor.
Oshtri Deka 11-Jun-12 9:38am View
You should improve your question, title is a bit misleading and strange.
Oshtri Deka 11-Jun-12 6:26am View
I agree.
Oshtri Deka 9-Jun-12 4:03am View
Do you get an exception?
Can we see part of your code?
It is not easy to give a solid answer to such thin description of your problem.
Oshtri Deka 8-Jun-12 8:21am View
Oshtri Deka 8-Jun-12 7:56am View
Yep. Linked article is great.
Oshtri Deka 5-Jun-12 16:22pm View
I recommend this approach.
Oshtri Deka 5-Jun-12 16:05pm View
Thank you both.
Oshtri Deka 30-May-12 6:00am View
Can we get some code please?
Oshtri Deka 24-May-12 5:38am View
Give us entire error message.
Oshtri Deka 24-May-12 5:36am View
Please improve your question.
Do you mean "MS project file" or what?
Do you have any code at all?
Oshtri Deka 24-May-12 5:34am View
"when i five 0"
Oshtri Deka 18-May-12 8:38am View
Can you please, at least in future, try to use punctuation and capital letters.
It is hard to read poorly written questions.
Oshtri Deka 18-May-12 3:36am View
Excellent answer.
Oshtri Deka 18-May-12 3:36am View
Good answer. 5.
Oshtri Deka 18-May-12 3:31am View
Your title is misleading.
Oshtri Deka 18-May-12 3:29am View
This is good direction.
Oshtri Deka 18-May-12 3:27am View
Edit: code formatting.
Oshtri Deka 17-May-12 4:59am View
Edit: ! operator
Oshtri Deka 24-Apr-12 6:28am View
Nothing? Come on, this is easily reproduced.
1.Make model from database
2.create web form with gridView
3.add entity dataSource to gridView
4.delete row from grid
5. refresh page
6. boom!
Oshtri Deka 18-Apr-12 9:45am View
? There is no code, only markup.
DataGridView with its dataSource, dataSource can automatically add, remove and update data; I change data with Command buttons on grid.

Updating data works well, deleting also, when I navigate off and on the page data shown in grid is up-to-date, my problem only occurs when I am trying to refresh a page and I wonder why it happens?

It never happened with SQLDataSource or ObjectDataSource.
Oshtri Deka 27-Mar-12 8:18am View
I agree, it's simpler and efficient.
Oshtri Deka 27-Mar-12 6:22am View
Whats' Lkg and Ukg and I?
What's the datatable's schema?
Oshtri Deka 27-Mar-12 6:09am View
Edit: I've added C# code.
Oshtri Deka 27-Mar-12 6:00am View
Why is this tagged with C# tag?
Oshtri Deka 27-Mar-12 4:29am View
Can you share some code?
Oshtri Deka 25-Mar-12 13:27pm View
What is your problem? Setup projects are usually rather straight forward.
Is database deployment your problem or...?
Oshtri Deka 24-Mar-12 7:28am View
5. I am afraid OP doesn't get it or hurries too much with beginners' guides.
Oshtri Deka 24-Mar-12 6:52am View
Edit: query readability.
Oshtri Deka 24-Mar-12 6:42am View
Please improve your question. I doesn't have sense.
Do you want confirm message before some DB operation? Or after? Or something else?!
Oshtri Deka 24-Mar-12 6:39am View
Can you improve your question please. I don't understand what is your problem.
Oshtri Deka 23-Mar-12 6:01am View
Oshtri Deka 23-Mar-12 5:59am View
50 dropdowns in one page? This is going to be users' nightmare.
Oshtri Deka 23-Mar-12 5:47am View
Give us exception text.
Oshtri Deka 20-Mar-12 4:16am View
It works great on strings. Just to make it clear to OP or to some beginner who shall stumble upon this in future, you should provide write Result.ToString().
Oshtri Deka 20-Mar-12 4:05am View
Removing unnecessary pre tags.
Oshtri Deka 20-Mar-12 4:03am View
Oshtri Deka 20-Mar-12 4:02am View
Old school ;).
Oshtri Deka 19-Mar-12 8:27am View
Data as database or selected tables?
Oshtri Deka 19-Mar-12 8:22am View
This code has too many errors.
Oshtri Deka 19-Mar-12 8:02am View
Align as text-align?
Oshtri Deka 16-Mar-12 7:10am View
1. There is no mention of your ddl in code behind you submitted here.
Change that and perhaps someone will be able to help.
2. Ddl from your markup is called ddl_formstatus and ddl from your error message is dropdownlist1, therefore I think it is possible that code you have submitted here isn't source of your error.
Oshtri Deka 16-Mar-12 6:49am View
Again I agree.
Oshtri Deka 16-Mar-12 6:48am View
I agree.
Oshtri Deka 16-Mar-12 6:46am View
Edit: tag
Oshtri Deka 16-Mar-12 6:44am View
Oshtri Deka 16-Mar-12 5:19am View
Orginal code you copied here had several mistakes in markup. Did it work at all?
What is your problem? Which par doesn't work?

1. If you haven't install FireBug or press F12 on IE
2. Use to evaluate your variables
3. Try to get some conclusion from results and if they matter, post them here.
4. Good luck!
Oshtri Deka 16-Mar-12 5:15am View
Edit: general formatting (code, empty spaces, identations etc.)
Oshtri Deka 15-Mar-12 9:06am View
I agree. 5.
Oshtri Deka 15-Mar-12 9:00am View
Have you set it to landscape?
Using smaller font can help.
Have you set margins?
Oshtri Deka 13-Mar-12 4:01am View
That's good start for OP.
Oshtri Deka 13-Mar-12 3:56am View
Give us table schema as well.
Oshtri Deka 13-Mar-12 3:53am View
Off-topic, but I must ask, why don't you use xml based config solutions?
Oshtri Deka 9-Mar-12 14:01pm View
Just to be sure, you are working on project, am I right?
Oshtri Deka 9-Mar-12 5:22am View
Have you written any code?
Oshtri Deka 9-Mar-12 3:50am View
So what data you wish to show in gridview? All or subset?
Oshtri Deka 9-Mar-12 3:23am View
Do you want search or filtering? From what I've read you want to filter data, don't you?
Oshtri Deka 6-Mar-12 7:48am View
Why do you need popup?
Oshtri Deka 6-Mar-12 7:35am View
Oshtri Deka 6-Mar-12 7:33am View
I am trying to understand what is your problem, your comment is hard to read.
Please use editing option and make it more readable.
Oshtri Deka 5-Mar-12 4:27am View
Can you please write your table schema?
Oshtri Deka 5-Mar-12 4:17am View
What error do you get?
Oshtri Deka 5-Mar-12 4:08am View
Don't be lazy :)
Oshtri Deka 2-Mar-12 7:47am View
Can we see your code?
I assume you use SMTP, perhaps you only need to authenticate your sender.
Oshtri Deka 2-Mar-12 3:29am View
First of all how do you get that array?
You cant' just fill array with random values and save it as .wav.
Oshtri Deka 2-Mar-12 3:21am View
Por favor, traducir la pregunta en Inglés.
Google translate te está esperando.
Oshtri Deka 2-Mar-12 3:21am View
Moderator or administrator I summon thee!
Oshtri Deka 1-Mar-12 15:30pm View
Drop ASP.Net tag.
Oshtri Deka 1-Mar-12 9:39am View
Syntax errors!
To get row's field via indexer only square ([]) brackets work.
r("Name") wrong!
r["Name"] correct.
Oshtri Deka 1-Mar-12 9:31am View
What about auto-numbers?
Oshtri Deka 1-Mar-12 5:21am View
Add SQL CE and/or SQL Server tag.
That will attract more people.
Oshtri Deka 1-Mar-12 5:13am View
I am not aware of such tool and I agree with SAKryukov.
Oshtri Deka 1-Mar-12 5:11am View
Can you be more specific please? Title is a bit misleading.
What do you want? A crystal reports' own promt or your custom pompt dialog?
Oshtri Deka 1-Mar-12 3:15am View
I agree.
Oshtri Deka 1-Mar-12 3:11am View
Reason for my vote of 4
Nice work, but I don't see nothing new.
Oshtri Deka 1-Mar-12 3:08am View
Reason for my vote of 5
End of story.
Oshtri Deka 1-Mar-12 3:05am View
Reason for my vote of 5
Can't be used on .Net 2.0, but it's nice anyway.
Oshtri Deka 29-Feb-12 16:41pm View
I agree. Use validators and if they don't suit you, use JavaScript.
Oshtri Deka 29-Feb-12 8:42am View
Oshtri Deka 29-Feb-12 8:41am View
Oshtri Deka 29-Feb-12 8:02am View
This is school project, isn't it?
Oshtri Deka 29-Feb-12 7:59am View
I agree.
Oshtri Deka 29-Feb-12 7:57am View
What do you actually want?
An algorithm to create your menu tree or how to bind your toolStripItems to data source in order to track and submit changes?

Please be more specific.
Oshtri Deka 28-Feb-12 15:28pm View
Can you post exception message?
I know it's not your question, but why you don't use separate columns for each of above values?
Perhaps there are to much character for that column to handle?