C# Tutorial 1:Getting Started and Mysql database Connection

I cannot find mysql.data.dll

brother you are so much helpful, don't have words to pay thanks

how do I make visual studio recognize the database I just created ? I added the reference mysql.data.dll and also added the line using mysql.. still visual studio does not recognize the database name..

I like your c# videos

Sir! Can you upload computer networking ?

You are a modern day juggernaut! Can't thank you enough sir!

Why are you using MySql and nor SQL Server?

I don't have mysql m using Microsoft sql server 2017 edition what should I do?

just a little confusion, can any one tell me : "is it necessary to learn windows form(c# gui based) application before moving to asp.net web forms? or just to know c# on console itself is enough to move towards asp.net web form ? plz help 🙂

Bro MySqlConnection nahi hora mery 2013 ma, sqlconnection hota hora ha , par phir adp.SelectCommand("select * from database.edata" , conn); par error

Thanks for the video! Very helpful. Just want to give my two cents. I usually use dotConnect to access database applications @t and I am pretty satisfied with it.

Importing a excel file to Mysql Database using C# .net please

you need to dawn lode MySQL Connector https://dev.mysql.com/downloads/file/?id=476984
to show Mysql . data

make video on how to Populate Combobox Depending On Another Combobox In C#

i have visual studio 2017 and i followed the video but it says ssl connection not available
plz help how to fix this

//I have to write it
try
{
string myConnection = "datasource=localhost;port=3306;username=root;password=root";
MySqlConnection myConn = new MySqlConnection(myConnection);
MySqlDataAdapter myDataAdapter = new MySqlDataAdapter();
myDataAdapter.SelectCommand = new MySqlCommand("select * database.edata ;", myConn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(myDataAdapter);
myConn.Open();
DataSet ds = new DataSet();
MessageBox.Show("Connected");
myConn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

what is the code for the connection?

sir can you please make a tutorial that has only three attempts in login…thank you in advance sir C# MySql

Why do we use MYSQL workbench if we have option of Creating Database connection in MV studio 2013?

Hi sir, I really appreciate your struggles. Please make a video tutorial on serialization in C#.
If it already exists then please send me the link.

Hello. I just wanted to take out time to say thank you, i have greatly improved in C# through the help of this tutorials. thanks alot.. i'll love to keep in good communication with you if thats okay. Thanks. My email is efosaodigie@outlook.com

After Compliments
i would like to request the following
1) – Save image on system (not in database)
2) – and how to retrieve that image in reference of the record against which the image was saved

please help

with regards

what if its sql server management studio? code will be different? can anyone please help on this?

just three words ….you are awesome

hi Sir :
one problem i have in database :

how to save text(comment) and pdf file in sql to show in visual studio using c#

please help me

try this MySQL connector, it's awesome https://www.devart.com/dotconnect/mysql/

MySqlConnection conDataBase = new MySqlConnection(constring);// constring is showing error in update ,delete bottom but in insert buttom it is not showing any error

Sir, i want to add subscript and superscript string in label. how can i do it? please help me.

hello sir my visual stdio me my sql data nahi milta hai please

There is error which provide exception. So, replace first line in block 'try' by this:
String myConnection = "SERVER=localhost;UID=root;PASSWORD=root;";

Don't know if it matters, but tutorial #3 is missing (assuming it's not supposed to go from #2 to #4)

so how the database work on another PC means i build the software package, then the SQL where stored in them computer.

This caused me some errors with the syntax. Below is a link to the correct syntax:

http://stackoverflow.com/questions/31230445/windows-form-application-mysql-cannot-convert-from-string

Lis ten I cannot get that MySql.Data in the "References -> Add References" dialog! Only the MySql.Data.Entity can I get. Can someone pls help me with this?

Lisren I used your code exactly as you had typed it out but got the error msg. when I clicked the button that said "Keyword Not Supported:'datasource' " How do I fix this problem?

using System;
using MySql.Data.MySqlClient;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace MyWinFormApp1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
try
{
string myConn = "datasource = localhost;port = 3306; username = root; password = steve";
SqlConnection myConnection = new SqlConnection(myConn);
SqlDataAdapter mda = new SqlDataAdapter();
mda.SelectCommand = new SqlCommand(" select * from MyDatabase.atable;", myConnection);
SqlCommandBuilder cb = new SqlCommandBuilder(mda);
myConnection.Open();
DataSet ds = new DataSet();
MessageBox.Show("I am totally connected!");
myConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);

}

}
}
}

such a relief! Thanks bro 🙂

i've tried this and it seems work and shows "data saved" message box, but when i check on my sql the data wasn't saved. any help?

Watch it in Speed:1.5

an 18 minute video showing a single block of fucking code are you serious