HOW TO: Get Started with Microsoft JDBC

HOW TO: Get Started with Microsoft JDBC: "HOW TO: Get Started with Microsoft JDBC"

MySQL Bugs: #16126: Unable to use MySql as datasource for the ASP.NET 2.0 SqlDataSource object

MySQL Bugs: #16126: Unable to use MySql as datasource for the ASP.NET 2.0 SqlDataSource object: "Unable to use MySql as datasource for the ASP.NET 2.0 SqlDataSource object"


I tested the code of my first post with the connector 5.0.1 and it works fine.There is another thing that it may be usefull (this is a feature request).With Visual Studio 2005 there are many wizard, one of these is "Connect to datasource"under Tools menu.In this wizard there is the list of data provider registered but MySQL doesn't appear inthe list :(



www.visli.com

MySQL .NET With C# - Lesson 03: Introduction to SQL and ADO.NET

MySQL .NET With C# - Lesson 03: Introduction to SQL and ADO.NET: "MySqlCommand"



private void cmdLoad_Click(object sender, System.EventArgs e)
{
MySqlConnection conDatabase = new
MySqlConnection("Data Source=localhost;Persist Security Info=yes;");
MySqlCommand cmdDatabase = new MySqlCommand(SQL Code, conDatabase);

conDatabase.Open();

cmdDatabase.ExecuteNonQuery();
conDatabase.Close();
}

www.visli.com

Database Connectivity in C# mySql Database asp.net 2.0

First download connector and copy MySql.Data.dll in bin folder

http://dev.mysql.com/downloads/connector/net/5.1.html

Put
using MySql.Data.MySqlClient;

after that for select from database use following

MySqlDataAdapter myDataAdapter;
string strSQL;
string myConnection = String.Format("server=localhost; user id=dostind; password=123456; database=visli; pooling=false;");
strSQL = "SELECT * FROM UserDetails;";
myDataAdapter = new MySqlDataAdapter(strSQL, myConnection);
DataSet myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet, "UserDetails");
MySQLDataGrid.DataSource = myDataSet;
MySQLDataGrid.DataBind();

for insert/update use following code:

MySqlDataAdapter myDataAdapter;
string strSQL;
string myConnection = String.Format("server=localhost; user id=dostind; password=123456; database=visli; pooling=false;");
strSQL = "insert UserDetails value (4,'test','3','4','5',6)";
myDataAdapter = new MySqlDataAdapter(strSQL, myConnection);
DataSet ds = new DataSet();
myDataAdapter.Fill(ds);

www.visli.com buy online.

Using MySQL database with C# and NET 2.0

Using MySQL database with C# and NET 2.0: "Using MySQL with .NET Application"

How to connect to MySQL 5.0. via C# .Net and the MySql Connector/Net

How to connect to MySQL 5.0 using c# and mysql connector/net!: "How to connect to MySQL 5.0. via C# .Net and the MySql Connector/Net"

This article and tutorial describes and demonstrates how you can connect to MySQL in a c# application.
First, you need to install the mysql connector/net, it is located at: http://dev.mysql.com/downloads/connector/net/1.0.html
Next create a new project
Next add reference to: MySql.Data
Next add "using MySql.Data.MySqlClient;"
Finally add the following code to your application:

{
string MyConString = "SERVER=localhost;" +"DATABASE=mydatabase;" +"UID=testuser;" +"PASSWORD=testpassword;";
MySqlConnection connection = new MySqlConnection(MyConString);
MySqlCommand command = connection.CreateCommand();
MySqlDataReader Reader;
command.CommandText = "select * from mycustomers";
connection.Open();
Reader = command.ExecuteReader();
while (Reader.Read())
{
string thisrow = "";
for (int i= 0;ithisrow+=Reader.GetValue(i).ToString() + ",";
listBox1.Items.Add(thisrow);
}
connection.Close();
}

www.visli.com

Philips DVDR 3305 won`t finalise disc - Club CDFreaks - Knowledge is Power

Philips DVDR 3305 won`t finalise disc - Club CDFreaks - Knowledge is Power: "Philips DVDR 3305 won`t finalise disc"


There are two options:
1. On older Philips units, the 'force finalise' procedure was this: open the drawer of the recorder and insert the DVD+R disc. Do not close the drawer! Press and hold the '4' button on the remote control of the recorder until the drawer closes. The display should show "Finalize", and after a few minutes it's complete.
2. If you have a PC with DVD rewriter, then you can just write any old short text file to the disc and finalise it with the burning software (eg Nero).

www.visli.com

How do I password protect my files and folders in Windows?

How do I password protect my files and folders in Windows?: "How do I password protect my files and folders in Windows?"


www.visli.com

ObjectdataSource, SQL-Server and ASP.NET Ajax-Extensions

ObjectdataSource, SQL-Server and ASP.NET Ajax-Extensions: "ObjectdataSource, SQL-Server and ASP.NET Ajax-Extensions"

www.visli.com

ASP.NET AJAX meets Virtual Earth

ASP.NET AJAX meets Virtual Earth – Part Four


www.visli.com

Starter Kits and Community Projects : The Official Microsoft ASP.NET Site

Starter Kits and Community Projects : The Official Microsoft ASP.NET Site: "Starter Kits and Community Projects"

Managing Configuration Data Programmatically in ASP.NET 2.0

Managing Configuration Data Programmatically in ASP.NET 2.0: ASP Alliance

www.visli.com

Dropdown Box Using AJAX.

CodeProject: Dropdown Box Using AJAX. Free source code and programming help: "Dropdown Box Using AJAX"


www.visli.com

Getting Started with the ListView Control

http://www.gridviewguy.com/ArticleDetails.aspx?articleID=396_Getting_Started_With_The_ListView_Control

Tool to convert your C# to VB and your VB to C#

Tool to convert your C# to VB and your VB to C#: "Tool to convert your C# to VB and your VB to C#"


www.visli.com