استعمال DbConnectionStringBuilder في قواعد البيانات

djelal 8/2/2021, 10:28 am

استعمال DbConnectionStringBuilder في قواعد البيانات
بسم الله الرحمن الرحيم

الكود:: using System.Data.Common; using System.Data.OleDb; namespace Database_Builder { ....public partial class Form1 : Form ....{// اعلان عام للمتغيرات ........DbConnectionStringBuilder builder; ........OleDbConnection con1; ........string string1; // من نوع سلسلة حرفية او رقمية ........string string2; ........string string3; ........public Form1() ........{ ............builder = new DbConnectionStringBuilder(); ............builder.Add("Provider", "Microsoft.Jet.Oledb.4.0"); ............builder.Add("Data Source", @"c:\MyData\MyDb.mdb"); ............builder.Add("Jet OLEDB:Database Password", ""); ............string1 = builder.ConnectionString; ............builder.Clear(); ............builder["Provider"] = "Microsoft.Jet.Oledb.4.0"; ............builder["Data Source"] = "c:\\MyData\\MyDb.mdb"; ............string2 = builder.ConnectionString; ............builder.Clear(); ............builder.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=c:\\MyData\\MyDb.mdb"; ............string3 = builder.ConnectionString; ............builder.Clear(); ............con1 = new OleDbConnection(string3); ............InitializeComponent(); ........} ........private void button1_Click(object sender, EventArgs e) ........{ ............MessageBox. Show(string1); ............MessageBox. Show(string2); ............MessageBox. Show(string3); ............if (con1.State == ConnectionState.Closed) ................con1.Open(); ............MessageBox. Show(con1.State.ToString()); ........} ....} }