16,018,805 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Visual Basic questions
View Javascript questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
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
Show More