Skip to content

Utilizando o MySqlLiteDBProvider C# .NET

rafaelrferreira edited this page May 19, 2013 · 1 revision

#Consultando dados no Page_Load

using LiteMySqlDBProvider.MySqlDataAccessLayer;
using MySql.Data.MySqlClient;

namespace Sample.NET
{
public partial class MySqlDataLayer : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string erroMsg;
gvTeste.DataSource = MySqlDBProvider.InstanceDataTable(“providerMySql”, “connectionStringMySql”,"SELECT * FROM Municipio WHERE Cod_Mun = @Cod_Mun", out erroMsg, MySqlDbParametro.Parametro("Cod_Mun", 3101, MySqlDbType.Int32));
gvTeste.DataBind();
}
}
}

#Configurando o web.config

Clone this wiki locally