How to make connection visual studio with sql server

May 15, 2013

How to make connection visual studio with sql server

How to make connection visual studio with sql server

How to make connection visual studio with sql server

How to make connection visual studio with sql server

 <connectionStrings>

  <add name="waki" connectionString="Data Source=WAQEEH\SQLEXPRESS;Initial Catalog=waki new;Integrated Security=True" providerName="System.Data.SqlClient"/>

</connectionStrings>




  How to make connection visual studio with sql server


How to make connection visual studio with sql server

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;



namespace VPProject
{
    class studentclass
    {
        
         public DataTable GetData(string a)
        {
            DataTable dt;
            using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["waki"].ConnectionString))
            {
                using (SqlCommand command = new SqlCommand())
                {
                    command.CommandText = a;

                    command.Connection = con;
                    con.Open();

                    SqlDataReader sqlDataReader = command.ExecuteReader();

                    dt = new System.Data.DataTable();
                    dt.Load(sqlDataReader);
                    con.Close();
                }
            }
            return dt;
        }

        public void SetData(string Querry)
        {
            using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["waki"].ConnectionString))
            {
                using (SqlCommand command = new SqlCommand())
                {
                    command.CommandText = Querry;

                    command.Connection = con;
                    con.Open();

                   command.ExecuteNonQuery();
                    con.Close();
                }
            }
        }
        }
    }




  How to make connection visual studio with sql server

How to make connection visual studio with sql server


 var srchquery = string.Format("select * from [waqeeh 1] where Name = '{0}'",textBox1.Text);
            studentclass s = new studentclass();
            dataGridView1.DataSource =   s.GetData(srchquery);


How to make connection visual studio with sql server


You Might Also Like

0 comments

Popular Posts

Like us on Facebook

Flickr Images