Click here to Skip to main content
15,066,191 members

Comments by Jαved (Top 143 by date)

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