I am learning new things, thank you very much, will proceed with each of your videos at least 2 or 3 per day. I am also looking for a group of people who are interested in learning programming language and are willing to collaborate with simple projects. Practice will always make you better at whatever you do.
Thank you :). For Visual Studio 2013 it is slightly different regarding controls and since I am not using Express versions of both VS2013 and SQL Server 2014 I have to use Service-based Database, but approach is the same.
I am trying this in visual studio 2015 and I can't find the "Local Database" add item. I can find it in visual studio 2010 installed in the same machine but cannot find in 2015 version? I am new to these things so what is the problem here can someone help me out?
Thank you very much for your time and effort. Your videos are awesome. I was wondering if you could make a tutorial for a practical online database, to keep a database in a website so people could log in and view/update the data through internet. Imagine we just have a domain/web hosting, what's the best way to do this through visual studio/ C# or ASP? A tutorial would help a whole bunch of people who I know are looking for a tutorial. Thanks a lot.
@ 8:56 you can actually "Configure Data Source with Wizard..." instead of adding a new one. So you can check database objects in EmployeeDataSet without creating EmployeeDataSet1. Or am I missing something?
Thank you so much for your video It is clear and helpful I have two questions and I hope you help me 1- how to create multi users form so every user has different form that appearead when logging in?? 2- how to create calender appointment form to register different teachers' schedule (by data entery employee) and every teacher could find his/her schedule??
Thank you for the very clear idea for the database... i want to ask can i use the local database consept for windows compact embedded application which i and making c#... Thank you
If i want to use the c# project on another computer, will the database be saved if i copy and paste the project on the other computer? I'm asking this question because i see that the database is local.
You select the Employee.mdf(or .sdf) and under the tab "properties", you select as "Copy to Output Directory" the "Copy if newer" option. That worked for me.
For those who do not see "local data base " in add new item go to msdn.microsoft.com/en-us/library/ms233763.aspx - it helped me 100% to use with this tutorial. (as well as msdn.microsoft.com/en-us/library/ms171890.aspx )
in sql server the database is named Employeeinfo , but in Visual Studio you named it Employee.sdf , would not this cause a problem as they should be named the same ?
Great tutorial work fine until i save to windows explorer save all the file apart from employee,sdf is it because I'm not using visual studio 2010 professional ? I'm using visual Ultimate
please help me, am using visual studio 2012 and am not finding the option on which i have to use to add a data source. Can i get help on how i can proceed.
I can drag my dataset over to display on my form.. Problem is, I am not getting the arrows or save or delete button on mine like yours has.... So there is no way I can navigate through the data..
***** ok I will Can you suggest me how to change the collation of the service based DB to utf8_general_ci, because I'd like to work cyrillic symbols ? (thanks)
Hello Sir, I have two computer and server, i need a local database sync with server. Is it Possible, when server rows updated it's want to update the local database automatically.
Very nice and knowledgeable video...👍👍👍👌
I really Really Like Your #Videos And Your #Teaching #Method Sir...😍🥰
watch this video with 1.5 speed
Pretty funny going 0.5 speed
thanks!
you right thanks
:) ;) heheh hehahaah
oke
I am learning new things, thank you very much, will proceed with each of your videos at least 2 or 3 per day. I am also looking for a group of people who are interested in learning programming language and are willing to collaborate with simple projects. Practice will always make you better at whatever you do.
Thanks dear
Very Clear and very useful information
Very useful!Thank you for helping me to learn Java and C#.God bless you!
Thank you for this video it helps me to create a database as a beginner =) Thanks a lot.
Thank you! I am gonna watch your other videos
very nice and clear explained,
Thank you very much for your better tutorial. Very nice tutorial
Thank you very much for your helpful video and your time.
Was just having problems with this connection stuff now...thanks a lot
Thanks man! liked this tutorial a lot! + you got a new subscription!
Thanks for the tutorial, it was very enlightening.
Nice tutorial, thank you.
I don't have the Local Database item, how do I get that? Thanks in advance :)
Thank you,
That was just what I was looking for!
Thank you sir for the video, very informative.
Good Explain ... i like your voice
Very Good ........... Thanks
Super Explanation bro.
Thank you :). For Visual Studio 2013 it is slightly different regarding controls and since I am not using Express versions of both VS2013 and SQL Server 2014 I have to use Service-based Database, but approach is the same.
thank you so much , this is giving me new lesson :)
Very good to understand
Thank you for the video, you very helped me.
watching with 2x ( Great work )
I am running Visual Studio 2013 for desktop and it does not have the Local Database yellow icon. I can't find the local database.
Yeah! What is up with that?
That's a Service-Based Database in 2013.
Oh
Thankz you :)
Randy Smith Thanks a lot !!!!!
Glad I could clarify that.
i cant see "local data base " in add new item
Same query...
+Akhil Gangula What version of Visual Studio do you have?
2015, the version I used, encountered same problem.
Nikola011 ya I used 2015
Hmm, I'm using VS 2012 and I don't have that problem. Do you have legal version of VS?
I am trying this in visual studio 2015 and I can't find the "Local Database" add item. I can find it in visual studio 2010 installed in the same machine but cannot find in 2015 version? I am new to these things so what is the problem here can someone help me out?
Do you have SQL featured installed with Visual Studio? :)
Thank you very much for your time and effort. Your videos are awesome. I was wondering if you could make a tutorial for a practical online database, to keep a database in a website so people could log in and view/update the data through internet. Imagine we just have a domain/web hosting, what's the best way to do this through visual studio/ C# or ASP? A tutorial would help a whole bunch of people who I know are looking for a tutorial. Thanks a lot.
THANK YOU SO MUCH SIR...
@ 8:56 you can actually "Configure Data Source with Wizard..." instead of adding a new one. So you can check database objects in EmployeeDataSet without creating EmployeeDataSet1. Or am I missing something?
Thank you so much for your video
It is clear and helpful
I have two questions and I hope you help me
1- how to create multi users form so every user has different form that appearead when logging in??
2- how to create calender appointment form to register different teachers' schedule (by data entery employee) and every teacher could find his/her schedule??
For those who are using VS 2013, go to "Service-based Database" under the data category. "Local Database" doesn't exist in VS 2013.
Thx guys, your video very good
Daaaattaaa Base :P
really helpful..Thank you.
very good,thank for help
Thanks so much, helped out heaps
PLZ make tutorial on Visual Studio 2017 for LocalDB .
Great video, thanks again!
Great tutorial! Thanks
Thanxx alot....!!!!!! Very helpful :)
thank your so much sirr.............
In Visual Community 2015 I don't see "Local database" with sdf suffix. Only "service based database" with mdf suffix. Should I use mdf ?
use Visual Studio 2012 ;)
can not drag local database to form any more in Visual Studio 2015? Thanks. I am newbie of C#
Heyy, it's a nice and easy understanding Video. Great Job. Can show us, how you can add a photo to the database?
What do you do if you wish to have a combobox rather than a texbox?
Are there any good videos where they explain what they are doing? Like the 'why' of how a certain command is written, best practices, etc?
Have you done video for VS 2013 ?
Thank You For that Great Tutorial :)
Thanks for the tutorial!
Thank you for the very clear idea for the database...
i want to ask can i use the local database consept for windows compact embedded application which i and making c#...
Thank you
great tutorial
i was looking for this!
can we use entity and linq with local database if so show us how
thank you very much
Are there any more formats of the database to it? like .dbs for example
thanks a lot. superb
In order to use locadb do i need to install SQL Server Management Studio?
Hi its really helpful. i want to know if i want to run the database on another system. will it work? if i copy all the files.
It's working. Thank you
right did it connected it to the database however how do you update the database from visual studio
Thnx so much sir
hey dude! is this local storage database supports multi connections? like server and client based applications?
very useful, thanks!
If i want to use the c# project on another computer, will the database be saved if i copy and paste the project on the other computer? I'm asking this question because i see that the database is local.
+Kristina Naneva no, and that is my issue
if you are using local database ,is it possible to see this database on remote location? or we need server for this.
Great One
this doesn't save any changes to the database.
You select the Employee.mdf(or .sdf) and under the tab "properties", you select as "Copy to Output Directory" the "Copy if newer" option. That worked for me.
build the project i guess
Use command builder.
For those who do not see "local data base " in add new item go to msdn.microsoft.com/en-us/library/ms233763.aspx - it helped me 100% to use with this tutorial.
(as well as msdn.microsoft.com/en-us/library/ms171890.aspx )
Have you wrote the backend code there??
which version of sql server management studio is for free or did u get ?
why does this man sound like he's about to call and tell me there's something wrong with my computer
Quality shitpost right here...
Rid Z pajeet, my son
shitpost steve who the fk is pajeet?
Rid Z my son
shitpost steve nice. say hi to him for me.
It really help a lot. Can I have a request for making a user activity log using MySql. really need it in making a good c# project. Thanks
can you do a video on storing webpages / articals in a database and to search them via search box ?
Thank you so much
in sql server the database is named Employeeinfo , but in Visual Studio you named it Employee.sdf , would not this cause a problem as they should be named the same ?
can you see all the data you created from different computer you used ?
can i use mysql for this one too? instead of ms sql?
Great tutorial work fine until i save to windows explorer save all the file apart from employee,sdf is it because I'm not using visual studio 2010 professional ? I'm using visual Ultimate
is it ok if we use service based instead of local database
yes
can a local data base be used to generate reports?
Can you make a tutorial regarding dynamic/runtime connection with MySQL in C#.
"LocalDataBase" (SDF) Item will Disappear when you select Net Frame 3.0 or below ... so be aware
Can I use .mdb file instead of .sdf ? Thanks
Yes you can. Just drag the mdf file into your project and create the new connection string
please help me, am using visual studio 2012 and am not finding the option on which i have to use to add a data source. Can i get help on how i can proceed.
the video is tooo old. the local database feature is not there on visual studio 2012 upwards . you need to update this video please
I can drag my dataset over to display on my form.. Problem is, I am not getting the arrows or save or delete button on mine like yours has.... So there is no way I can navigate through the data..
can you also make a video of creating invoice autnum? like atuto increment number. example is: PO1, PO2, PO3 and so on ...
do i need sql server to run an app with sql compact at another pc?
can you share this local database to other computer for multiple users to have the ability to read and write unto this single local database?
can i import existing .bak files using this tutorial?
Very good video!
Dear Sir,
How can we fetch data from Multiple table from local database.
like (select statement from sql).
can we use select query for fetch data.
great tutorial... keep it up :)
Hi, thanks your sharing.
Can i reupload some videos in your channel?.
thanks a lot sir!!!!
I have following problem:
visual studio 2013 doesn't show me 'lacal database' in the list.
how can i install it on my pc (win 8.1, 64 bit) ?
I have fresh new instalation of Visual studio 2013 BUT I don't have "Local database" template o.0
StuartLittleJr Same here
StuartLittleJr Try using "Service-based Database" under the data category.
***** ok I will
Can you suggest me how to change the collation of the service based DB to utf8_general_ci, because I'd like to work cyrillic symbols ? (thanks)
***** 10x :)
I cant find the local database in the add new item tab, any solutions? I'm using visual studio 2015.
Show tables not working? Giving an exception why??
Hello Sir, I have two computer and server, i need a local database sync with server. Is it Possible, when server rows updated it's want to update the local database automatically.