Where To Start To Learn Database
Jul 6, 2009please can anyone tell me where do i start to learn database???please help me because is a lot and confused information in google.
View 1 Repliesplease can anyone tell me where do i start to learn database???please help me because is a lot and confused information in google.
View 1 RepliesRecently, I've changed my job to a biological company, they have huge data but managed by Excel, only by Excel. For example, they have hundreds of orders every month, but they just simply record them by Excel. No database concept is used in this company. Excel to manage this is nightmare, only one person can write the file, others can only read the file by ReadOnly. And these data is very easy to be mistakenly modified.
So, since I come to the above Excel-managed company about one month ago, I cannot stop myself thinking apply database.But I have no programming background at all, only used VB6.0 to create some tiny program in High School. Now I started to think whether I can use VB2010 to do this.First of all, I turn this problem to Access, and I learned a lot database design theory from getting to know Access. However, I finally find out that Access can hardly freely create Form like VB (maybe I didn't find out how)
Anyway, I started to study VB2010, to add DataSet to my Form1, and use DataGridView to display data, and to use TableAdapter to modify data. However, it is quite hard to learn, without any systematic books. For example, I am confused about TableAdapter and TableManger, and I don't know how to simply display a modified DataTable by DataGridView control. And SQL search language is new to me as well.
So, I'm wondering if anyone could recommend me any books based on what I would like to learn? Or any tips and reviews?
I have made my application to start automaticly when windows start (registry ../currentversion/run/appname + path). In this mode the application start minimized and an little icon appear in the notification icon area. With this icon you can maximize the app or exit it.If you exit the app and start it again using the Menu (Start/programs etc) than the application start in minimized mode (and in this case I would like to have it in normal mode) because the setting autostart is still true.Is there a way you can detect when the application start when windows startup using the above registry or when people click on an icon in the programs menu (or desktop)?
View 2 RepliesPossible Duplicate: Which language should I pick up: VB.Net or C# I'm trying to make a descision on learning VB.NET or C# as my first .NET language. I'm aware that bith languages can achieve the same things since both ultimately use the .NET framework. I'm also aware that C# has a similar syntax to both Java and C/C++, so I definitely see the benefits with this.
But how about the future of VB.NET? Will it be maintained in the years to come?I do know a bit of python, so would that make C# easier to learn?
I am looking to switch to C#. I come from a C / C++ background but C# is a little different for me. I am switching mainly because of Silverlight and MVVM; all examples are in C#. Any information is in C# and I am confused when I read through it all.
What is a good place to start learning C# when starting with existing C / C++ knowledge?
I'm a high school teacher and I have started a course in how to program with Visual Basic. Start with the 1st entry at url...
View 3 RepliesI'm a C# programmer who needs to pick up some VB. The syntax differences are easy enough to figure out, but there are other things I'll need more of a tutorial on. For example, VB's "strict" mode in Visual Studio is something essential to me, but something I wouldn't have learned just by comparing language syntax. Any recommendations on how to pick up VB quickly, yet thoroughly? I can't stand to work through a 1000 page book introducing VB to novices.
View 10 RepliesI would like to learn the Microsoft reports in vb.net.Anyone can provide me the links?
View 2 RepliesI am wanting to learn more about databases and how to code them into my VB application. I've been searching the forums and I see a lot of examples of code with OleDB.OleDBConnection, OleDBCommand and same with SQL. How did you learn how to work with databases? What resources would you recommend? Any online tutorials that you found helpful?
One of the particular issues that I am having is that I've set up a table with approximately six columns. I have this shown on the main form as a datagridview with only two of the columns shown. To edit / add a new record, I have set up a button to load a new form with the details of the datagridview showing in textboxes (for all six columns). So, if the user were to select an entry on the main form page and then click on the edit/add button it would bring up the row's information in their respected textboxes. From there the user would be able to edit and then save the changes. I'm having difficulty bringing up the form with the selected row's information.
where is the best place to learn InvokeRequired and BeginInvoke.
View 4 Repliesas part of my alevel course i had to learn Pascal and now moved on to VB.NET.in Pascal there was a data type called 'real' where a number could have floating point values) my question is this; what in VB.NET is the equivalent to the Pascal real??
View 3 RepliesI've been an ASP.NET VB.NET Web Developer for the past 4 years, but its been mainly self-taught so I think theres a fair few basics I have probably not learnt along the way.I'm interested in switching to C#, and was wondering what book would be best to buy to learn this.Is Jon Skeet's 'C# in depth' book a good place to start learning, or would this be too difficult for me to start with?
View 4 Repliesis there any series to learn Server and Client in VB.NET?
View 1 RepliesCan i get any best tutorial/Book/site to learn ADO.Net
View 1 RepliesI am not sure if this is the correct forum to post. I sometimes train Excel VBA. I would like to learn the language to a developers level. What relevant qualifications do Microsoft offer since I cannot find anything on their site?
View 1 RepliesI am taking a training course in Visual Basic.NET.
1) I downloaded the trial version of Visual Studio Professional and I am having troubles getting the Visual Studio trial version to recognize some of the coding.I know the coding is correct.I have heard of a Visual Studio.NET that the course recommends.Is it Available?If not is there a way to correct Visual Studio allow Recognition of this code?
2) What is the best Visual Studio package to learn the Visual Basic.NET Language?
learn and understand datetime picker and timer that would allow me to create application that is like reminder which would be like an appointment when this certain date and time is now at my computer then this form with listbox would show the appointment for the day that is stored in my database in sql server management studio express and vb.net 2008 as my programming language?
View 3 RepliesI always wanted to make some websites. Is VB 2010 a good tool to make websites?
Where is a good place to start. Tutorials, examples and all of that.
I'm beginner programmer in the amazing world named ".Net".I've a lot of questions
well, what I should learn C# or Vb.net What's the best blogs which talk about .Net technology and Open source projects Where can I find good tutorials, free books and ideas of projects how can I progress in ".Net" please, share your knowledge , your OPML of your favorite blogs or web sites about ".Net "
I want to learn visual basic 2010 for software development
View 3 RepliesI'm trying to read and learn the save file dialog coding.[url]....
View 5 RepliesI'm new to VB but completly new. I've dabbled with it a bit before but mostly from copying and pasting code from online. Is there a good book that I can purchase that will show me the ropes of the basics?
View 5 RepliesAssociating an Event with an Event Handler, in the VB 2008 Express Edition Learn VB tutorial, but the link to "Events and Event Handlers"does not work.
View 1 RepliesWhere should I go to leanr to program stuff like getting keystrokes, locking keyvoards, changing desktop backgrounds, opening CD trays, changing IE homepage, etc.... Basically everything windows... I'm using VB.NET right now. Is there an api or something to learn for this kind of stuff?
View 10 RepliesI'm not sure what is the best approach. Here is what I'm trying to do. I have installed sql express 2005 and sql express manger as pre-req before my program is installed. Now I would need to attach a DB to my new sql express instance. I'll be using windows login for this. I pretty much can not touch sql express, and run it as it was installed. No changing settings. Now I can run the SP_AttachDB from sql, but how would I automate that? I have tried the connection string, with the attach database option, but it's not working.
View 10 RepliesEvery time when application start check for change in structure..
View 1 Repliesi have completed my application successfully and now i want to deploy it on the Customer End.How i can have to do this i have to install SQL Server 2005 on the Customers End and then have to create all the Tables and Views and Stored Procedures that SQL Server once again or is there anything else ???
if it is then its a big task coz i have about 12 tables and how i can get all the data stored in my Computer already of the Customer during testing...
i have completed my application successfully and now i want to deploy it on the Customer End...How i can have to do this ??i have to install SQL Server 2005 on the Customers End and then have to create all the Tables and Views and Stored Procedures that SQL Server once again or is there anything else ???if it is then its a big task coz i have about 12 tables and how i can get all the data stored in my Computer already of the Customer during testing... ?
View 4 RepliesI have custom asynchronous WebRequest class that I am testing to find out how fast the request will be cancelled and found some odd results, that starting 6 WebRequests with TPL and cancelling them right away takes 25 sec, but when I used just regular background threads it took only 5 sec.
Update: Running them without cancelling takes with Task.Start 9 sec and Thread.Start 3 sec accordingly.
Imports System.Net
Imports System.Threading
[Code]....
im using vs to create a simple security form, i am successful to create a a form of log but i need some more improve like
1) if the software remain untouch for a minute the login form should be shown as the user try to use it again
2) and how the software start automatically when window start