Connection String - نسخه قابل چاپ

کد:

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 System.Configuration;

using System.Data.SqlClient;

using System.Data;



namespace CS_WebConfig

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        DataTable dt;



        private void Form1_Load(object sender, EventArgs e)

        {

        }



        public string GetString()

        {

            return ConfigurationManager.AppSettings["ConnectionString"].ToString();

        }



        private void button1_Click(object sender, EventArgs e)

        {

            SqlConnection con = new SqlConnection(GetString());

            SqlDataAdapter sqlda = new SqlDataAdapter("select * from TableInfo", con);

            dt = new DataTable();

            sqlda.Fill(dt);

            dataGridView1.DataSource = dt;

        }

    }

}

کد:

public void CreateSqlConnection() { SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer;Connect Timeout=30"; myConnection.Open(); }