private void button4_Click(object sender, EventArgs e) { PinfoDataContext con = new PinfoDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\gadgets planet\Desktop\SalimProject\ClubManagementSystem\ClubDatabase.mdf;Integrated Security=True;Connect Timeout=30"); var str = from a in con.ProfileInfos select a; ProfileInfo s = str.Where(obj => obj.Id == Int32.Parse(textBox1.Text)).First(); dataGridView1.DataSource = str.Where(obj => obj.Id == Int32.Parse(textBox1.Text)); }
public Database() { con = new PinfoDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\User\Desktop\Project\ClubManagementSystem\ClubDatabase.mdf;Integrated Security=True;Connect Timeout=30"); }