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

Recommended Answers

All 5 Replies

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...

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....

Hi its like 2005

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

KOUROSH NIKZAD

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();
    }
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.