Comments by a1mimo (Top 53 by date)

Try google it's faster and easier than waiting for people to answer actually on google there is lots and lots of answers for your problem try search for fill gaps in sql server auto increment

A further explanation would be good if you looking for an answer

What kind of authentication you use in your website?

What have you done so far? add your code so we can help

I added a link for you in the question check it out you will find all you need there and to upload the database you will need FTP client as I mentioned in the question

If you hard coded your translation then simply make the links redirect to the pages in the same language its that easy (IF you translated and made pages of each language of your own) if not state how you make your translation and maybe we can help

You answered it yourself it's a timeout problem as for 2gb or 1gb file to be uploaded you sure need some more timeout than this 300 try making it 0 (unlimited) and check again if the problem is gone

Hope this helped

It seems that you posted your web.config but for some reason it isn't appear in here so try to improve question and put it there in the question, and I can't quite understand the next part of your reply

I can't say nothing but LOL
Nice one Sergey :-D

Do you mean that you have two times and you want to get the difference between both of them to get the total time spent or whatever?

You can't know because there is too many factors that may affect the time simply if your processor is working in high percentage the shortest call to the server ever may give you time out try make it 0 and see if it works or no after all you have nothing to lose :-)

have you tried to set the timeout of your sql server to higher number than 600 cause it seems to be that this operation takes more time than the server allows

nitish nalan I am sorry for so late answer I just didn't log in for a very long while but I actually remember what was the problem it was just a hang up and the previous solution worked best for me all I needed to do is to delete the label and create it again sorry for late one more time but after all better late than never :-)

Sure I will :)

I did sorry it didn't even tell me it posted both of them my bad
thanks :)

you explain your case good but not the problem what is the problem exactly? what do you want the select statement to look like?

What is the error?

My vote of 5 because actually I am sure this wasn't what he asked for but at least you tried to give him something for that non question question :-)

What? what are you trying to say exactly please enhance your question and answer the people who are trying to help you

I think you already have the answer just remove the extra quotation mark you put before the semi colon in the third line and it will work fine

I second John just add dataGridView1.Refresh(); at the end and it will update it

I dont get what you want very clear do you want for example when you click on a record the image display in the image control or you want all the images to appear in images control beside the records?

give more details what your database table look like what do you exactly need to do? will the datagrid be already filled with some values or you will have an empty one and fill it? please be more clear

when exactly do you get this error what is in your main?

what kind of reports do you use? if you use windows reporting service it has a feature to add this row for you, please make your question more clear

yes I know and btw my vote of 4

Thank you Danny
I already discovered the problem it was the single quote I didnt put it around the date value but your solutions will work as well so my vote of 4

Thank You mkgoud
I just solved the problem right now and to be fair I thought it would be as you said too but it was because I forgot to put the value of the date between '' like this cmd.CommandText="INSERT INTO person (birthdate) VALUES('"+dateTimePicker.Value.Date+"')";
but still there is something I wish to know how to get only the date value from the dateTimePicker if dateTimePicker.Value.Date dont get only the date?

Thank You I got it now.

here is something that I may add it might cause the problem "Label1" Text is binded to database, will this make any difference?

Thank you for your answer but actually this solution for some reason doesnt work for me
it always return null when I debug as if it cant find "Label1" at all
thanks again :-)

Thank You I got it :-)

Thank You I got it :-)

thanks alot for your answer I know it really works but I have a problem I am still fixing in the onclick event so I cant use it but its a great answer anyway thanks again :-)


my vote of 5

thank you,
but how to pass them in the querystring can you give me an example

My vote of 4

because its almost perfect

why almost?
because its not going to work for all the barcode scanners
but its still a great answer keep the good work :-)

I think this was it or that what I understood from his comment on your answer :-)

It would help if you share some code

Thank you Toli
I actually tried your advice and I was just reading it, you are a big help :-)

Thanks Rampas
I got it I appreciate your help :-)

can you suggest me an article or something to do so? I would appreciate this
Thank you,

I know that, but its just I am too lazy and curious about it :-)
Thank you,

it seems to be that you putting this code in an area that being called before the columns created
so to avoid this error you may find it helpful to put the code between a try and catch

try
{
the code
}
catch
{
message or leave it empty doesnt matter
}

you are right it just hit me when I saw "child" that its an mdi app :-)

my bad

all you have to do is to select the textbox and see the see properties window you will find the validating event

:) I mean I dont understand what you want give more details about your question

what do you mean? please dont be short at your question give as much details as you can so you can get as much answers as we can

can you please discribe more I am getting lost starting from "if the user edits...."