public string connectionString = "Data Source=" + File.ReadAllText(Path.GetDirectoryName(Application.ExecutablePath) + "\\PCName.txt").ToString() + ";Integrated Security=SSPI;Initial Catalog=" + File.ReadAllText(Path.GetDirectoryName (Application.ExecutablePath) + "\\DBSName.txt"); use a this code in your Program,and make a notepad file in your one of the drive in your computer. just write your computer name in notpad the save it and close. :) if you don't have database, you don't write DBSName.txt in codesource.

using the following code you write.

using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;
using System.Data.SqlClient;

DataTable dataset = new DataTable();

dataset = Ds.DataTab("select M.*,P.Name,P.Id From Pay P Mem M where M.Id = " + Ds.TrueInt(Member.Text));

dataset = Ds.DataTab("select * from Pay where Member =" + Ds.TrueInt(Member.Text + ""));

dataset = Ds.DataTab(string.Format("select (Name+' ' + FName) as fullName from Mem where Id = '{0}'", Convert.ToInt32(Member.Text)));
NameFName.Text = dataset.Rows[0].Field<string>("fullName");

With this command you can use the SQL table at your disposal form (C #)