Comments by Jαved - CodeProject

Jαved 12-Mar-18 3:32am View

use below code-

Dim _New_dt As New DataTable()

_New_dt = dt

dt.Columns.Add("Key_Id", GetType(String))

Dim c = _New_dt.Rows.Count / 30000
Dim SheetNumber = Convert.ToInt64(System.Math.Ceiling(c))
' If c = CDbl(c) Then
'c = System.Math.Floor(c + 1)

Dim dtArr(c) As DataTable
For j = 0 To c
dtArr(j) = dt.Select("key_id <= 1 And key_id >= 30000").CopyToDataTable()
dtArr(j) = dt.Select("key_id <= 61000 And key_id >= 90000").CopyToDataTable()
dtArr(j) = dt.Select("key_id <= 91000 And key_id >= 120000").CopyToDataTable()
dtArr(j) = dt.Select("key_id <= 121000 And key_id >= 150000").CopyToDataTable()
Next

'End If

Jαved 12-Mar-18 3:19am View

Hi Maciej,
thanks for suggestion I only saw updated time.

Jαved 12-Mar-18 3:16am View

you are looping through all the rows in main table 'dt' un-necessarily and the batchSize check is in middle of the loop it should be the first check in the loop.
Although this code will take lot of time and is not optimized.

Jαved 12-Mar-18 2:55am View

Yes, declare another variable to set count to split and declare dtArr to be DataTable array as - Dim dtArr() as DataTable and in loop set array as-
dtArr(i) = dt.Select("key_id <= 1 And key_id >= 30000").CopyToDataTable()

Jαved 12-Mar-18 2:35am View

nope, it is decimal the code will not work and give error.

Jαved 12-Mar-18 1:58am View

what is the issue with solutions given in the link?

Jαved 12-Mar-18 1:57am View

your code seems to be wrong. the variable "dtArr" is of type "double".
i.e. Dim dtArr = _New_dt.Rows.Count / 30000

Jαved 6-Apr-17 8:06am View

Show some of your code what have you tried?

Jαved 28-Dec-15 6:26am View

Hi phil,
the solution isn't incomplete, and for 4 year old question because the question dont have any accepted answer yet.
thanks,

Jαved 19-Nov-14 2:23am View

+5

Jαved 19-Nov-14 2:10am View

5ed.

Jαved 6-Nov-14 22:18pm View

Thank you :)

Jαved 28-Oct-14 11:17am View

Sure.

Jαved 23-Oct-14 3:22am View

Thanks CodingK :)

Jαved 10-Aug-14 5:01am View

Thank you :)

Jαved 3-Jul-14 5:38am View

Not clear. what you want to do?
do you want to set css to Label?

Jαved 2-Jul-14 11:55am View

Welcome bro :)

Jαved 10-Mar-14 0:20am View

Hi RyanDev,
I want to call a fuction on asp.net fileupload control file selection. And i dont find any event for that. can you help?

Jαved 10-Mar-14 0:19am View

Hi CHill60,
Thanks for your time. Actually what I want is to fill the dropdownlist on file selection of fileupload control. which are in DataGrid in asp.net. I have tried everything but cannot find event on which i can call fill dropdownlist function.
Any of c# or vb.net code/ Idea will do.

Jαved 5-Jun-13 10:52am View

Show us what have you done so far.

Jαved 5-Jun-13 7:43am View

Are you storing image in database or path of the image?

Jαved 4-Jun-13 5:21am View

I dont know what you are asking. Remember I cant see your files/ Desktop/ data.

Jαved 6-May-13 4:57am View

check here- http://www.connectionstrings.com/

Jαved 29-Apr-13 5:00am View

Have you solved it? or else add the code here so i can check it for you.

Jαved 9-Mar-13 8:07am View

what do you want to do? please elaborate.

Jαved 9-Mar-13 3:24am View

Deleted

Hello Michael,
can you tell how can i do it. I dont know.

Jαved 9-Mar-13 3:23am View

Deleted

Question updated!

Jαved 9-Mar-13 3:23am View

Deleted

Question updated!

Jαved 9-Mar-13 3:23am View

Deleted

Question updated!

Jαved 9-Mar-13 3:23am View

Deleted

Question updated!

Jαved 9-Mar-13 3:08am View

Welcome. If you find it useful then please accept it as answer.

Jαved 8-Mar-13 2:47am View

Hi Kavitha,
is your table's primary key referenced in other table?

Jαved 13-Feb-13 8:03am View

Not clear, exactly what do you want to do?

Jαved 13-Feb-13 7:26am View

Why Label in Datagridview?

Jαved 13-Feb-13 7:21am View

You're welcome! B-)

Jαved 13-Feb-13 3:48am View

instead of Console.WriteLine() add to ListBox as ListBox1.Items.Add().

Jαved 13-Feb-13 2:57am View

I have updated the answer check the link.

Jαved 13-Feb-13 2:54am View

it should work i dont know why it is not working.

Jαved 13-Feb-13 2:38am View

+5. good answer.

Jαved 7-Feb-13 7:25am View

elaborate. nothing happens automatically.

Jαved 1-Aug-12 5:02am View

+5.

Jαved 11-Jul-12 2:36am View

+5 good links.

Jαved 29-Jun-12 7:19am View

have you referenced System.IO Namespace?

Jαved 29-Jun-12 7:05am View

Hi Dhinesh,
Sorry for late reply. You can store the client IP/ Name to identify.

Jαved 29-Jun-12 6:47am View

Hello faizyab,
Try Google for this.

Jαved 29-Jun-12 6:12am View

Thanks Tim.

Jαved 28-Jun-12 7:59am View

so what is the problem?

Jαved 28-Jun-12 7:02am View

added pre tag.

Jαved 28-Jun-12 2:10am View

Thanks.

Jαved 28-Jun-12 2:10am View

You are Welcome.

Jαved 27-Jun-12 7:44am View

Please explain clearly what you want.

Jαved 27-Jun-12 7:01am View

Answer updated.

Jαved 27-Jun-12 6:55am View

You are welcome. Accept as answer if you think it helped.

Jαved 27-Jun-12 6:55am View

:-)

Jαved 22-Jun-12 2:09am View

Good +5.

Jαved 21-Jun-12 7:31am View

Good links +5.

Jαved 21-Jun-12 7:14am View

You are welcome.

Jαved 13-Jun-12 5:09am View

Perfect +5.

Jαved 12-Jun-12 8:33am View

Useful links +5.

Jαved 12-Jun-12 8:24am View

you are Welcome. If you think it helped you then "Accept it as answer".
Thanks.

Jαved 12-Jun-12 7:57am View

Thank you.

Jαved 11-Jun-12 9:52am View

Good answer +5!

Jαved 11-Jun-12 9:40am View

Hi Pratik,
I think in the article it is already demonstrated.

Jαved 11-Jun-12 9:38am View

Thanks Tim.

Jαved 11-Jun-12 9:37am View

Deleted

Thanks Tim.

Jαved 11-Jun-12 9:37am View

Deleted

Thanks Tim.

Jαved 11-Jun-12 9:36am View

Deleted

Thanks Tim.

Jαved 11-Jun-12 9:35am View

Glad it helped.

Jαved 11-Jun-12 8:57am View

Hey Sandeep links not working.

Jαved 11-Jun-12 8:55am View

Not clear.

Jαved 11-Jun-12 8:52am View

Perfect solution SA 5 from me!

Jαved 11-Jun-12 8:04am View

???

Jαved 6-Jun-12 15:30pm View

Good 5 from me.

Jαved 1-Jun-12 9:17am View

Oh yes sorry. thanks Tim.

Jαved 1-Jun-12 7:57am View

Good 5!

Jαved 1-Jun-12 7:56am View

What have you done so far?

Jαved 1-Jun-12 6:17am View

Good 5!

Jαved 1-Jun-12 5:58am View

do you want to check only one checkbox out of 3? if so, then go for radioButton.

Jαved 1-Jun-12 5:53am View

Deleted

please explain the problem.... cant understand.
in datagridview?

Jαved 1-Jun-12 3:05am View

Thanks Sandeep.

Jαved 1-Jun-12 3:01am View

Have you installed any hardware or software on your PC recently?

Jαved 31-May-12 5:02am View

are the records seperated by comma or space? or there is only one record on one line?

Jαved 31-May-12 4:53am View

what kind of payment information? any kind of payment statement?

Jαved 29-May-12 2:56am View

All right. I think your question is answered here-
http://stackoverflow.com/questions/9721161/microsoft-interop-excel-column-names

Jαved 28-May-12 9:37am View

Set HDR=YES in connection string.

Jαved 12-Apr-12 6:07am View

It seems to be your Assignment. Try it yourself. if any problem arises post it here.

Jαved 12-Apr-12 6:00am View

Please explain neatly. It's completely confusing.

Jαved 30-Mar-12 8:17am View

Reason for my vote of 1
Very poor.

Jαved 29-Mar-12 5:16am View

I have updated the answer.

Jαved 29-Mar-12 5:08am View

Anytime for you dude.
Accept it as answer then.

Jαved 26-Mar-12 8:28am View

Yes you are right.

Jαved 26-Mar-12 8:25am View

Thanks Shahin.

Jαved 21-Mar-12 9:46am View

It is using disconnected architecture so it does your reqirement.

Jαved 21-Mar-12 7:34am View

Yes i Google for this and spent almost 2 days finding that is why I posted it here else i would not. I dont want to use Regular Expressions.

Jαved 21-Mar-12 5:01am View

Agreed SA. but i require for my project. its a clients requirement that login password should have atleast 1 char, 1 number and 1 Special char. I dont want you to do it for me atleast giude me or tell me if is it possible or not. Thanks for the comment.
Special character are - " ~@#$%^&*()_+=/*-+.[]';/.?>":}{<,"

Jαved 27-Feb-12 5:01am View

Not solved yet.

Jαved 16-Feb-12 10:08am View

Try it yourself. it will help you learn. We dont do homework for you if you have any problems then post here we will try to solve it.

Jαved 15-Feb-12 6:10am View

you want to show records of type (selected from combobox) in second combobox right?

Jαved 10-Feb-12 6:35am View

did you use DateTimePicker for date?

Jαved 7-Feb-12 5:52am View

No. I'm using it for Winforms application.

Jαved 4-Feb-12 8:41am View

Not solved yet.

Jαved 30-Jan-12 0:53am View

Hi,
sorry for the late reply.
I think the error you received is because you forget to use New keyword while creating object somewhere.

Jαved 24-Jan-12 8:53am View

Added pre tag.

Jαved 24-Jan-12 8:51am View

seems to be correct.
Edited=> Moved return true in the if else loop.

Jαved 24-Jan-12 8:48am View

You are not returning any value then why are you using Functions?

Jαved 24-Jan-12 8:44am View

Added pre tag.

Jαved 20-Jan-12 5:09am View

added pre tag.

Jαved 20-Jan-12 5:06am View

Added pre tag.

Jαved 18-Jan-12 2:57am View

Explanation needed. what you want to do exactly?

Jαved 17-Jan-12 12:08pm View

Deleted

Not an answer. post in questions.

Jαved 16-Jan-12 8:31am View

Put some efforts. try it yourself.

Jαved 16-Jan-12 8:27am View

Have you tried it yourself?

Jαved 16-Jan-12 7:55am View

Give more information.

Jαved 16-Jan-12 7:54am View

dont ask Same questions again and again...

Jαved 16-Jan-12 2:06am View

Completely agreed.

Jαved 16-Jan-12 2:02am View

You are welcome.
All the best.

Jαved 13-Jan-12 9:39am View

Deleted

What if i want to restrict user to copy content/ text from page ??

Jαved 13-Dec-11 3:02am View

Thanks.

Jαved 7-Dec-11 2:44am View

Deleted

Reason for my vote of 5
Awesome work.

Jαved 30-Nov-11 4:26am View

That seems to be helpful... can u convert it to VB.
and how do i make it update/ insert "HOLIDAY" in table automatically for the month.

Jαved 30-Nov-11 4:16am View

how do i automatically insert HOLIDAY on sundays in table.

Jαved 30-Nov-11 3:44am View

Thanks Hemant-Sharma hope this works for me. let me give it a try.

Jαved 30-Nov-11 3:43am View

Deleted

Thanks http://www.codeproject.com/script/Membership/View.aspx?mid=2900187 let me see if it works for me.

Jαved 30-Nov-11 3:35am View

Deleted

Good attempt but you'll have to write it for every number. then it will become fore lengthy. and to write it is very time consuming.
give some better solution.

Jαved 30-Nov-11 1:19am View

Deleted

Reason for my vote of 4
Should provide some description about the working.

Jαved 28-Nov-11 1:33am View

no Amol i can run query on table. but i am asking about running query which is added later in the Access Database.

ex. my query name is query1 in database then
how do i run query1 using .net.

i write
Dim selectCMD As SqlCommand = New SqlCommand("SELECT CustomerID, CompanyName FROM query1", nwindConn)

selectCMD.ExecuteNonQuery()
Dim custDS As DataSet = New DataSet
custDA.Fill(custDS, "Query1")

can i run in access?

because i can run using SQLserver query perfectly

Jαved 28-Nov-11 1:27am View

not yet.

Jαved 28-Nov-11 1:23am View

Deleted

Reason for my vote of 5
Very informative.
Thanks

Jαved 28-Nov-11 1:13am View

Deleted

Thanks man i was in so much need of this.
hope it works for me.

Jαved 9-Nov-11 5:20am View

Deleted

thanks Wayne.
appreciate your help.

Jαved 8-Nov-11 8:08am View

can u tell me in brief?

Jαved 5-Nov-11 5:20am View

Deleted

thanks Pascal Ganaye.
my problem is actually with application using more memory. i've created one sidebar application. i've made it to start when pc starts.

is it possible if i compile it with other compilor?

Jαved 17-Oct-11 9:24am View

oh yes....my mistake. :-)

Jαved 15-Oct-11 8:59am View

thanks André Kraak. That helped me.
u r a Rockstar man.
keep up the gud work. :-)

Jαved 15-Oct-11 8:58am View

Thanks Muhammad Shahid Farooq.

Jαved 15-Oct-11 8:58am View

Thanks OriginalGriff.

Jαved 14-Oct-11 3:13am View

Thanks DaveAuld.

Jαved 13-Oct-11 10:05am View

Still not solved do anyone can solve my problem?

Jαved 13-Oct-11 9:38am View

Thanks Mehdi Gholam can u please tell me briefly about it.
Thanks

Jαved 13-Oct-11 9:30am View

Thanks Mehdi Gholam but i want the db to run from the same machine.

do i have to install them to run SQL database?

Jαved 11-Oct-11 16:00pm View

Deleted

Thanks Dave. it sounds intresting. i will try your solution.

Thanks.

Jαved 11-Oct-11 9:27am View

Deleted

thanks tusharpal i think link u provided has solution for my problem.

Thanks man thank you so much.
Appreciate your help...!!!

Jαved 11-Oct-11 9:13am View

Deleted

thanks tusharpal for ur help...

but can u give me some details regarding it.. or how can i do it.
i have linked one image of it u can have a look at it..
Thanks

Comments by Jαved (Top 143 by date)