i need to ask u some questions to get started in doing a database
-
hi im new to c# and this is my first attempt to create a database.. right now i only have a concept, i donno how to get started or what i need to do exactly to carry out my plan.. i've separated my groups of data in tab pages.. so now, each tab page consist of a different type of data.. 1) when the user saves the tab page of data, i want the data to go into the database.. but how do i "throw" the data into my database? 2) i need to create a few sets/types of sample data eg. types of food taken and personal particulars.. where do i go to to create my sample data n how do i store these sample data in my database? 3) more importantly, im not even sure what database to create.. microsoft access or microsoft sql server or others.. which database is the best/easiest to use for my app? 4) my app is something like this >> let's say i've these buttons : updateBtn1, viewBtn1, updateBtn2 n viewBtn2.. the user chooses what he wants to click and the page will be displayed.. if this button is to view only and it is to open a tab page about types of food taken, im supposed to retrieved only types of food taken from database and display in the tab page.. i need it to sort and only retrieve food taken and leave out personal particulars which is also kept in the same database.. if the button clicked is to open tab page to update food taken, i need to get the relevant data frm database and let user edit those data before he saves them again to database.. so my question is how do i open/display/retrieve only the relevant data for THAT tab page AND how do i save it back to database? note: the same data shd NOT be written again to database, only add NEW data in to database.. how to do this? when the user loads (whether to view or update) tab page by clicking the button, i want the page to display both old data + new data in a datagrid for example (old data means data that's already in database that is my sample data & new data means the data that was updated/added in to database.. i really appreciate it if u cld provide me with some examples of codes and how they work or some help articles or anything that u think will help.. thank you so much for trying to help! =)
-
hi im new to c# and this is my first attempt to create a database.. right now i only have a concept, i donno how to get started or what i need to do exactly to carry out my plan.. i've separated my groups of data in tab pages.. so now, each tab page consist of a different type of data.. 1) when the user saves the tab page of data, i want the data to go into the database.. but how do i "throw" the data into my database? 2) i need to create a few sets/types of sample data eg. types of food taken and personal particulars.. where do i go to to create my sample data n how do i store these sample data in my database? 3) more importantly, im not even sure what database to create.. microsoft access or microsoft sql server or others.. which database is the best/easiest to use for my app? 4) my app is something like this >> let's say i've these buttons : updateBtn1, viewBtn1, updateBtn2 n viewBtn2.. the user chooses what he wants to click and the page will be displayed.. if this button is to view only and it is to open a tab page about types of food taken, im supposed to retrieved only types of food taken from database and display in the tab page.. i need it to sort and only retrieve food taken and leave out personal particulars which is also kept in the same database.. if the button clicked is to open tab page to update food taken, i need to get the relevant data frm database and let user edit those data before he saves them again to database.. so my question is how do i open/display/retrieve only the relevant data for THAT tab page AND how do i save it back to database? note: the same data shd NOT be written again to database, only add NEW data in to database.. how to do this? when the user loads (whether to view or update) tab page by clicking the button, i want the page to display both old data + new data in a datagrid for example (old data means data that's already in database that is my sample data & new data means the data that was updated/added in to database.. i really appreciate it if u cld provide me with some examples of codes and how they work or some help articles or anything that u think will help.. thank you so much for trying to help! =)
hi i think u should read more about the database connection and about dataset with this you will have more idears about .net database
-
hi i think u should read more about the database connection and about dataset with this you will have more idears about .net database