0

How to create Database connectivity for sql server express edition 2008?
plz Help me.. i am confused so much...

6
Contributors
5
Replies
6
Views
7 Years
Discussion Span
Last Post by paslanmaz
0

it will look like this

Data Source=your db sever name\SQLEXPRESS;Initial Catalog=databasename;Integrated Security=True
=======================================================================

How to create Database connectivity for sql server express edition 2008?
plz Help me.. i am confused so much...

1

Server=ServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;

For "Server" go to Sql management studio and copy the whole thing like......KM\\SQLEXPRESS........but remember to write it as KM\SQLSERVER in the Server....Hope this helps....

0

Hi its like 2005

connection string
"ServerName;Initial Catalog=DataBaseName;User ID=username;password= password"

KOUROSH NIKZAD

0

I am adding a code previously used

<appSettings>
    <add key="Baglanti" value="data source=ip;UID=; pwd=;initial Catalog="/>  
  </appSettings>
 public static SqlConnection sqlBaglanti = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["Baglanti"]);

delete insert update 
 public static void Sorgu_Calistir(string sql)
    {


        SqlCommand sqlCommand = new SqlCommand(sql, sqlBaglanti);
        if (sqlCommand.Connection.State == ConnectionState.Closed)
        {
            sqlBaglanti.Open();
        }

        sqlCommand.ExecuteNonQuery();
        sqlBaglanti.Close();
    }
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.