My Blog

protected DataTable GetData()
    {
        SqlConnectionStringBuilder scBuilder = new SqlConnectionStringBuilder();
        scBuilder.DataSource = DBServer;
        scBuilder.InitialCatalog = DBName;
        scBuilder.UserID = DBUser;
        scBuilder.Password = DBPass;

        using (SqlConnection conn = new SqlConnection(scBuilder.ConnectionString))
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                conn.Open();

                cmd.Connection = conn;
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = "select ID, Name, FileName, FilePath, ParentID, Type, IsDeleted from [redmine].[dbo].[ReportTemplate] with (nolock);";
                cmd.CommandTimeout = 0;


                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataTable dt = new DataTable();
                da.Fill(dt);

                return dt;
            }
        }
    }