C#

private void btnQuery_Click(object sender, EventArgs e)
        {
            PwdSecurity p = new PwdSecurity();
            uipc = this.Parent as UIPCMainForm;
            const string constrallowedBlockTypes = "allowedBlockTypes";
            DAL d = new DAL(uipc.StrUserName, p.base64Decode(uipc.StrPassword));

            //Clear dgv if it needs it
            dgv.DataSource = null;
            dgv.Refresh();

            bs = new BindingSource();
            bs.DataSource = d.AllowedTypes(constrallowedBlockTypes);
            dgv.ScrollBars = ScrollBars.Both;
            dgv.DataSource = bs; 
        }

        private void btnUpdate_Click(object sender, EventArgs e)
        {
            dgv.Update();
            //dgv.Update(bs.DataSource);
        }

public DataSet AllowedTypes(string Type)
        {
            string SQL = String.Empty;
            ds = new DataSet();
            try
            {
                SqlCmd = new SqlCommand("spGET_ALLOWED_TYPE", myConnection);
                SqlCmd.CommandType = CommandType.StoredProcedure;

                SqlCmd.Parameters.Add("@Type", SqlDbType.VarChar, 50);
                SqlCmd.Parameters["@Type"].Value = Type;

                if (myConnection != null) { myConnection.Close(); }

                myConnection.Open();
                SqlAdapt = new SqlDataAdapter(SqlCmd);
                SqlAdapt.Fill(ds);
            }
            catch (Exception e)
            {
                MessageBox.Show("DAL Layer / AllowedTypes method error. \n\r \n\r" +
                    e.Message.ToString() + " \n\r \n\r" + SQL);
            }
            finally
            {
                if (myConnection != null) { myConnection.Close(); }
                if (SqlCmd != null) { SqlCmd.Dispose(); }
                if (SqlAdapt != null) { SqlAdapt.Dispose(); }
            }
            
            return ds;
        }

<asp:SqlDataSource ID="FAR15DataSource" runat="server" 
        ConnectionString="<%$ ConnectionStrings:Cost_ModelConnectionString %>"  
        SelectCommand="SELECT Service_Tower_Code, WBS_Code, Ownertype, Compensation_Code, Compensation_Rate, Far_East_FTE, Hawaii_FTE,Mid_Atlantic_FTE, NCR_FTE, North_Midwest_FTE, Northeast_FTE, South_FTE, Southwest_FTE
FROM fn_enterprise_positions(1)"
        UpdateCommand="UPDATE  <%=Session["TableName"]%>  SET Far_East_FTE = @Far_East_FTE, Hawaii_FTE = @Hawaii_FTE, Mid_Atlantic_FTE = @Mid_Atlantic_FTE, NCR_FTE = @NCR_FTE, North_Midwest_FTE = @North_Midwest_FTE, Northeast_FTE = @Northeast_FTE, South_FTE = @South_FTE, Southwest_FTE = @Southwest_FTE
                WHERE Service_Tower_Code = @Service_Tower_Code AND WBS_Code = @WBS_Code AND Compensation_Code = @Compensation_Code AND worker_code = @worker_code">
                <UpdateParameters>
                <asp:FormParameter Name="Service_Tower_Code" FormField="Service_Tower_Code" />
                <asp:FormParameter Name="WBS_Code" FormField="WBS_Code" />
                <asp:FormParameter Name="Compensation_Code" FormField="Compensation_Code" />
                <asp:FormParameter Name="worker_code" FormField="worker_code" />
                <asp:FormParameter Name="Compensation_Rate" FormField="Compensation_Rate" />
                <asp:FormParameter Name="Far_East_FTE" FormField="Far_East_FTE" />
                <asp:FormParameter Name="Hawaii_FTE" FormField="Hawaii_FTE" />
                <asp:FormParameter Name="Mid_Atlantic_FTE" FormField="Mid_Atlantic_FTE" />
                <asp:FormParameter Name="NCR_FTE" FormField="NCR_FTE" />
                <asp:FormParameter Name="North_Midwest_FTE" FormField="North_Midwest_FTE" />
                <asp:FormParameter Name="Northeast_FTE" FormField="Northeast_FTE" />
                <asp:FormParameter Name="South_FTE" FormField="South_FTE" />
                <asp:FormParameter Name="Southwest_FTE" FormField="Southwest_FTE" />
                </UpdateParameters>
</asp:SqlDataSource>

        public void CreateFileColumn(ArrayList array, Array Numbe)<br />
        {<br />
            object missing = System.Reflection.Missing.Value;<br />
            object fileName = "normal.dot";<br />
            object newTemplate = false;<br />
            object docType = 0;<br />
            object isVisible = true;<br />
            Object oUnit = Word.WdUnits.wdCell;<br />
<br />
<br />
            wordApp = new Word.ApplicationClass();<br />
            wordDoc = wordApp.Documents.Add(ref fileName, ref newTemplate, ref docType, ref isVisible);<br />
            wordApp.Visible = true;<br />
            wordDoc.Activate();<br />
            <br />
            //draw table into document<br />
            wordApp.Selection.Tables.Add(wordApp.Selection.Range, 1, 8, ref missing, ref missing);<br />
           <br />
            wordApp.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft;<br />
            wordApp.Selection.Font.Bold = (int)Word.WdConstants.wdToggle;<br />
<br />
<br />
            //replace each number with picture then add to document<br />
            foreach (string part in Numbe)<br />
            {<br />
                wordApp.Selection.InlineShapes.AddPicture(@"C:\Users\Jon\Documents\Nick\Chin Font Files\" + part + ".jpg", ref missing, ref missing, ref missing);<br />
                //wordApp.Selection.InlineShapes.AddPicture(@"C:\Documents and Settings\All Users\Documents\nick\Chin Font Files\" + part + ".jpg", ref missing, ref missing, ref missing);<br />
                wordApp.Selection.MoveRight(ref oUnit, ref missing, ref missing);<br />
            }<br />
<br />
<br />
            <br />
<br />
        }