|
SQL Server Database Control 2.0
|
Email
|
| Submitted on: |
8/9/2003 10:53:34 AM |
| By: |
Issam Hijazi
|
| Level: |
Intermediate |
| User Rating: |
By 129 Users |
| Compatibility: |
VB.NET |
| Views: |
53460 |
|
(About the author) |
|
|
|
SQL Server Database Control 2.0 (VB.NET Version)
Here is a list of this control futures:
1. Login in to MS SQL Server
2. Backup, repair and restore databases
3. Upload databases and delete databases
4. Control the server (Start, Stop, Pause and Continue)
5. Check Server Status (Started, Stoped or Paused)
5. Check connection if active to server or not
6. List databases in the MS SQL Server, list teables and fields in table
7. Open connection with database and SQL statments (like select)
8. Save any file to Binary Field in table (like upload picture to table)
9. Display picture saved in database field to object (like Picture control)
10. Save a file from database field (like picture or txt files) to harddisk
11. Check if EOF or BOF
12. Find any record easy
13. Add, Edit, Update and Delete records
14. Bind the database fields to VB Objects (like Text Box or Label)
15. Bind the database table to MSFLEXGRID32 control
16. Handle All errors easy (no visible run time or desgin time errors), all hadled by name & num.
Its the easiest, coolest code ever seen! You can learn even how to upload and download files from MS SQL Server! Its learning control and can be used for your projects as well!
Actually I upgraded it from version VB 6.0 to VB.NET with some changes for BETTER!!
P.S: PLZ PLZ PLZ, rate this control on its page after or before downloading it, but don't forget, its just 3-4 clicks, PLZ do it!!!! thanks
|
| |
|
 Download code
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
- Re-scan downloaded files using your personal virus checker before using it.
- NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
|
Terms of Agreement:
By using this code, you agree to the following terms...
- You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
- You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
- You may link to this code from another website, but ONLY if it is not wrapped in a frame.
- You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
|
Report Bad Submission
|
Your Vote
|
| |
Other User Comments
|
 8/9/2003 10:57:51 AM: Issam Hijazi
Hello all, this is the newest code. I included th code this time 100%. Its written using VB.NET
enjoy it all!!
But please all, Rate this control, please, I need your votes, Please!!!! Its just 3 click!! Please Help ME!
(If this comment was disrespectful, please report it.)
|
8/9/2003 11:01:05 AM:
great work!! its just what I was looking for!!! you deserve the rating!!
(If this comment was disrespectful, please report it.)
|
8/10/2003 8:55:03 PM: gerard del rosario
great job, very useful tool, care to port it to C# as well???
(If this comment was disrespectful, please report it.)
|
8/10/2003 9:35:01 PM:
What can I say, the kid is a genius!!!
(If this comment was disrespectful, please report it.)
|
8/11/2003 12:14:53 AM:
that's really a help tool, but after get our vote. please enhance it to the best code, then can benefit who support using Micorsoft VISUAL BASIC developer.
(If this comment was disrespectful, please report it.)
|
8/11/2003 8:49:15 AM: Issam Hijazi
hi my friend posted in 8/11/2003 12:14:53 AM,, first thank you..
let me know what do you mean by ( enhance it to the
best code, then can benefit who support
using Micorsoft VISUAL BASIC developer.
), so that I can do your request!!!
(If this comment was disrespectful, please report it.)
|
8/11/2003 11:16:52 AM:
AWESOME
(If this comment was disrespectful, please report it.)
|
8/14/2003 7:19:44 AM: Ihsan Anabtawi
Great code and useful tool Issam. I didn't get the chance to consume it but I read the code and it's good. What's amazing is that you say ur 15 years old!!You'll have a bright future.Your coding techniques will improve when u explore good OOD and Software Engineering practices more in the future.(P.S:U still have many things to know and learn about Computer Science, it's not just programming, programming is only a small part of it :)..Best of luck man...
Ihsan
(If this comment was disrespectful, please report it.)
|
8/31/2003 5:34:12 PM:
I download the VB 6.0 and wondering if I can find it in VB.NET! and I really find one just like the old but work great with VB.NET, thank you!
5 globes from me :)
(If this comment was disrespectful, please report it.)
|
9/11/2003 10:49:54 AM:
Great control, saved me quite a bit of time.
(If this comment was disrespectful, please report it.)
|
9/18/2003 11:55:31 AM: AKCW
very good work. is it possible a version for vb 6.0
(If this comment was disrespectful, please report it.)
|
9/18/2003 2:25:47 PM: Issam Hijazi
SQL Server Database Control 1.0 (VB6.0)
link is here:
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=47433&l ngWId=1
(If this comment was disrespectful, please report it.)
|
9/18/2003 4:02:36 PM:
I am new to VB.NET. How do I use your control in an application?
(If this comment was disrespectful, please report it.)
|
9/24/2003 11:07:32 AM:
Awesome, how do you recommend using it though
(If this comment was disrespectful, please report it.)
|
11/4/2003 11:39:14 PM: Guidant Corporation
Is it completely managed code? It looks like it is using a interop dll. SQLDMO?
(If this comment was disrespectful, please report it.)
|
11/17/2003 3:09:01 AM: Mr.Surat
i'm looking for this.Great work keep it up
(If this comment was disrespectful, please report it.)
|
11/30/2003 4:06:09 AM:
Good works, 5 globes from me. But the Stopsqlserver Function doesn't work at my Pc, anything wrong?
(If this comment was disrespectful, please report it.)
|
1/28/2004 9:29:19 PM: Issam Hijazi
hello guys, thx for voting and comments, this control can be used if you really wannt control your sql server, database, all about sql server stuff with easy commands, yes it use SQLDMO library which installed by sql server, anybody missing any file just ask me here, it can be used by your application for free as well in VB.NET, well about the issue of stop not working, its working buddy, try it again, check your input, it should work if all work :)
thx again, any question, suggestion is welcomed
cheers
(If this comment was disrespectful, please report it.)
|
2/15/2004 6:46:11 PM:
i can't seem to get it started. it asks that i start it with debug and it appears incomplete. should i have set something special before pressing F5? Thanks.
(If this comment was disrespectful, please report it.)
|
2/16/2004 4:30:10 PM: Issam Hijazi
hi buddy,
this is not exe project, its activex, which creat ocx library, that means it can be added yo your exe project like a control (like textbox, label...).
Hope you got it!
(If this comment was disrespectful, please report it.)
|
4/21/2004 7:22:48 AM: Angy
Good ... Thank for sharing the good thing !!!
(If this comment was disrespectful, please report it.)
|
4/21/2004 11:47:28 PM: Angy
Hope u can put a sample code or maybe some simple instruction here to guide the newbie like us !! TQ
(If this comment was disrespectful, please report it.)
|
4/22/2004 5:20:45 AM: VipulPatel
very good good
(If this comment was disrespectful, please report it.)
|
5/29/2004 8:01:30 AM: MOB
WellDone ...
remember me bro .. :)
(If this comment was disrespectful, please report it.)
|
7/23/2004 11:55:03 PM:
hello there
i'm a programming student
i work with visual basic.net 2002 and mssql server 2000
i've downloaded your tool
it is indeed supposed to be a very helpful tool
but how could i make it work?
since it is a .dll file
i created a windows application to
reference it to.
there is no any error generated when
i called the BackupDatabaseToFile function
(passing all the needed parameters)
but the problem is
there is no any .bak file created in the
directory i entered as the path
so i don't think my database was really
backed up.
i know perhaps i made used of the tool
the wrong way
what other methods do i need to call before the
BackupDatabaseToFile function?
please tell me if i used
it the wrong way
kindly enlighten me
by showing me a bit of code on how to use it.
more power
thanks
(If this comment was disrespectful, please report it.)
|
7/24/2004 12:01:45 AM: Issam Hijazi
hello buddy..
you gotta connect to the server first using the control.. then do the backup function...
use the error description to see whats wrong with your code.. first enter your code then enter the sqlSDBC1.ErrDesc (as i remember) or sthing like that.. been long time like 2 years since i made this out.. so take it easy..
(If this comment was disrespectful, please report it.)
|
8/3/2004 4:40:54 AM:
i'm a new vb.net programmer
i know the basics but i'm still kinda learning
so please if it's not too much,
could you please provide me
a step by step instruction
on how to use your code.
perhaps you could start upon
after i download your code,
since your code is
a control, what will i do next?
do i need to really create a
windows application like the others
who posted their comments?
what will i do with the application
(if it's needed)?
thank you very much...
(If this comment was disrespectful, please report it.)
|
8/4/2004 3:27:15 AM:
i was the one who posted the
8/3/2004 4:40:54 AM message
forget it. i think i've found
the answers to my questions
all i needed was few hours in
front of the computer
and i was able to fully understood
and reuse your code.
thank you very much for sharing
your very useful code.
(If this comment was disrespectful, please report it.)
|
8/18/2004 10:55:24 AM:
Your control saved me a lot of work in both reading and writing, may God bless you.
(If this comment was disrespectful, please report it.)
|
10/19/2004 12:41:47 PM:
xCeLlenT cOde! blew me away! waz lookin fer dis 4!! tnks
(If this comment was disrespectful, please report it.)
|
11/17/2004 4:17:18 PM:
Hi Issam,
Great code.
Is it posible to use ADO.NET insted of ADODB?
Thanks
(If this comment was disrespectful, please report it.)
|
1/17/2005 12:20:04 AM:
HI Issam,
I have already downloaded your zip files but i dont know how to use it. How can I use your control? I cant see any .DLL or .OCX after i unzipped it.I'm just a newbie in vb.net. I hope you can help me.
thnx
(If this comment was disrespectful, please report it.)
|
3/23/2005 10:25:45 PM:
1st Time I rated and it's for you Bro.
(If this comment was disrespectful, please report it.)
|
1/14/2006 8:01:11 AM: afroz
exellent job
(If this comment was disrespectful, please report it.)
|
3/24/2006 10:56:44 AM: Carlos
Excelent, well done
(If this comment was disrespectful, please report it.)
|
8/7/2006 9:17:10 AM: martin
i have a problem using SQL Server Database Control 2.0
im using vb.net 2005 and sql 2005.when i open the program then after being converted im getting errors..
what do i need to do?
(If this comment was disrespectful, please report it.)
|
9/11/2006 2:51:49 AM: Joshy George
it's very helpful to me thank u very much
(If this comment was disrespectful, please report it.)
|
2/28/2007 9:35:03 AM: Salah AlZoubi
Thank you very much Islam
This is a very useful code
(If this comment was disrespectful, please report it.)
|
7/7/2007 11:14:04 AM: Jinni
good!
(If this comment was disrespectful, please report it.)
|
11/19/2008 11:20:01 AM: Paul Mather
Thank you for sharing this half of the project! Please post the other half which shows us newbies to .NET how to use it! Thanks!
(If this comment was disrespectful, please report it.)
|
6/14/2009 3:15:51 AM: donvbr
Has any more work been done on this? Does anyone have a sample app using it they could share the code of? Thanks!
(If this comment was disrespectful, please report it.)
|
10/18/2012 7:21:05 AM: D.Ravi
great job
(If this comment was disrespectful, please report it.)
|
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
To post feedback, first please login.
|
