1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77
| using System;
using System.ComponentModel;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using System.Data.OleDb;
using System.Data;
using System.Collections;
using System.Windows.Forms;
namespace Webpart_acces_bdd.VisualWebPart1
{
[ToolboxItemAttribute(false)]
public class VisualWebPart1 : WebPart
{
// Visual Studio peut mettre à jour automatiquement ce chemin lorsque vous modifiez l'élément de projet Composant Visual Web Part.
private const string _ascxPath = @"~/_CONTROLTEMPLATES/Webpart_accès_bdd/VisualWebPart1/VisualWebPart1UserControl.ascx";
protected override void CreateChildControls()
{
System.Web.UI.Control control = Page.LoadControl(_ascxPath);
Controls.Add(control);
}
private string messagePerso = "A Quelle Base De Donnée Voulez-Vous Vous Connecté?";
public string AfficheMessage
{
get { return messagePerso; }
set { messagePerso = value; }
}
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
writer.Write(AfficheMessage);
}
}
public class VisualWebPart2 : WebPart
{
protected void Connecter_OnClick(object sender, EventArgs e)
{
System.Web.UI.WebControls.Button Button1 = new System.Web.UI.WebControls.Button();
Button1.Width = 120;
Button1.Text = "Button test ";
Button1.Click += new EventHandler(bt_click);
}
protected void bt_click(object sender, EventArgs e)
{
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data source= C:\Documents.mdb";
try
{
conn.Open();
System.Web.UI.HtmlTextWriter writer = new HtmlTextWriter(null);
writer.Write("C'est bon vous êtes Connectés");
}
catch (Exception)
{
System.Web.UI.HtmlTextWriter writer = new HtmlTextWriter(null);
writer.Write("Erreur");
}
finally
{
System.Web.UI.HtmlTextWriter writer = new HtmlTextWriter(null);
writer.Write("BDD close");
}
}
}
} |
Partager