C# Tutorial - Connect to SQL Database | FoxLearn

[@nguyencanh8369]

public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void connectionToolStripMenuItem_Click(object sender, EventArgs e) { try { using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString)) { if (cn.State == ConnectionState.Closed) { cn.Open(); MessageBox.Show("connection successful"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }

[@danzsoft]

Excellent as always :) Waiting for the next video.

[@foxlearn]

Thank you so much !

[@zaylen8389]

Полезно для новичков. Хотелось бы больше видео по этой теме, а также по ms sql

[@foxlearn]

OK. Thank you for your suggestion !

[@dextermus6ep360]

Any advice for beginners who wants to learn c# how can we learn faster and in a good way? ❤ thanks

[@maikelgutierrez8558]

Thank you so much for showing us this way of connection to sql 😍. Might you please show us how to make a backup and restore of a Postgresql database? I can connect and do all kind of transactions but I don't find how to make a backup and restore from C# code :( I want to create a method that executive itself when the user log out of my application. Thank you in advance 😍

[@foxlearn]

OK. Thank you for your suggestion !

[@JohanFire]

Thanks! Is there a way to load data into the DataGrid but periodically? I mean, if I have a table with more than +500 rows, need to load the whole 500 rows and then it shows, that can be slow and if it has a lot of pictures of high quality makes it even slower, that can be sometimes maddening. Is there a way to load the data periodically? like it loads the first rows that can be see and when you scroll down the dataGrid it start to load the other rows. Thank you for your videos!

[@foxlearn]

500 rows i don't think it slow. You can add paging to datagridview

[@JohanFire]

@@foxlearn paging the dataGrid I think can be useful. Thanks! Keep doing videos :)

[@nguyencanh8369]

thanks

[@bluephenix6027]

Thank You Very Much

[@foxlearn]

Thank you so much !

[@boborahimyuldashev9346]

Hi there. I got a message (The configuration system did not pass initialization).

[@martinantoniodejesuslopezm4883]

Gracias

[@foxlearn]

Thank you !

[@TonyRodrigues27]

is there any intelisense option?

[@foxlearn]

OK. Thank you for your suggestion. I'll update soon !

[@Adamszsz]

gj like always

[@foxlearn]

Thank you so much !

[@srilankann5947]

How to create barcode rdlc report c# qty based generate barcode

[@foxlearn]

Next, Video. Thank you !

[@johnarnoldcatedrilla4378]

my menu strip is blank how can i insert the query?

[@foxlearn]

You should add menu to your menustrip

[@johnarnoldcatedrilla4378]

@@foxlearn its still blank :(

[@stefanypatrick95]

Sqlcommand? Inserte or update? Jajaj 😁😁

[@foxlearn]

Insert update delete select