C # වැඩ්ඩන්ට

[weerasinghe]

මචංලා මට C # වලට MYSql සම්භන්ද කරලා හදපු පොඩි Project File එකක් හරි, Connect කරන හැටි හරි කියල දෙන්න බැරිද....?

හදිස්සියි මචංලා....... Please​

 

[SanjayaDX8]

http://www.planet-source-code.com/

Me site eka ona tharam source code thiyanav. Mama nam C# danna naha. VB.NET dannee!!!

 

[sachith19920726]

Dream in Code පැත්තෙ සංචාරයක් දාල බැලුවේ නැත්තෙ ඇයි ?

http://www.dreamincode.net/code/snippet1677.htm

 

[DragonFox]

Mcn u must download and install the mysql .NET connector first then try the following

Then Add a referance to MySQL

then use the following code

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql.Data;
using MySql.Data.MySqlClient;
using MySql.Data.Types;

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

private void btnConnect_Click(object sender, EventArgs e)
{
string MyConString = "SERVER=localhost;" +
"DATABASE=mydatabase;" +
"UID=testuser;" +
"PASSWORD=testpassword;";
MySqlConnection connection = new MySqlConnection(MyConString);
MySqlCommand command = connection.CreateCommand();
connection.Close();
}

}
}


Project File

 

[¤--bACarDi--¤]

downlad & installll mysql connecter/NEt & google for connection codin

 

[weerasinghe]

http://www.planet-source-code.com/

Me site eka ona tharam source code thiyanav. Mama nam C# danna naha. VB.NET dannee!!!

Dream in Code පැත්තෙ සංචාරයක් දාල බැලුවේ නැත්තෙ ඇයි ?

http://www.dreamincode.net/code/snippet1677.htm

මම TRY කරලා බලන්නම්​

 

[weerasinghe]

Mcn u must download and install the mysql .NET connector first then try the following

Then Add a referance to MySQL

then use the following code

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql.Data;
using MySql.Data.MySqlClient;
using MySql.Data.Types;

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

private void btnConnect_Click(object sender, EventArgs e)
{
string MyConString = "SERVER=localhost;" +
"DATABASE=mydatabase;" +
"UID=testuser;" +
"PASSWORD=testpassword;";
MySqlConnection connection = new MySqlConnection(MyConString);
MySqlCommand command = connection.CreateCommand();
connection.Close();
}

}
}


Project File

Thanks Machan... Mama Try Karala balannam..
​

 

[weerasinghe]

downlad & installll mysql connecter/NEt & google for connection codin

MySQL OLEDB Connector
MySQL ODBC Connector
MYSQL
MySQL .Net Connector
MySQL Administrator And Query Browser

Me Serama Install Karala thiyenne..​

 

[DragonFox]

mcn i think what u miss is adding a reference to My SQL

In solution explorer right click on Reference and in the .NET tab select MySql.Data and Click Add that will give you all the required assemblies

Then try above code