Dear Friends,,..
please find the below code
static void Main(string[] args)
{
string sConnectionString;
sConnectionString = "Data Source=ADP-CHN-SRV47;Integrated Security=true;Initial Catalog=ESS4_CPayIntegration";
SqlConnection objConn
= new SqlConnection(sConnectionString);
try
{
objConn.Open();
SqlDataAdapter daCmpnyMaster
= new SqlDataAdapter("Select * From IntegrationCompanyMaster", objConn);
DataSet dsCmpnyMas = new DataSet("CompanyMaster");
daCmpnyMaster.FillSchema(dsCmpnyMas, SchemaType.Source, "CompanyMaster");
daCmpnyMaster.Fill(dsCmpnyMas, "CompanyMaster");
DataTable tblAuthors;
...
Go to the complete details ...