Embedded PDF and Excel Files

I want to upload PDF and Excel files to the Report Server database. I
would like to display them in a custom web application. When working
with the ReportViewer control, I can easily show reports. I can't
figure out the process on how to show a PDF to a user. In particular,
if the user selects a PDF ( I can check the MIMETYPE), then, how do I
get the file from Report Server so I can stream it to the user?On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> I want to upload PDF and Excel files to the Report Server database. I
> would like to display them in a custom web application. When working
> with the ReportViewer control, I can easily show reports. I can't
> figure out the process on how to show a PDF to a user. In particular,
> if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> get the file from Report Server so I can stream it to the user?
If you create a report that has the same format and output as the PDF
and Excel files, you could call the report and automatically render it
to PDF or Excel with a download prompt via URL. Here are a couple
examples.
http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Render&Param1=SomeValue&rs:Format=PDF
-or-
http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Render&Param1=SomeValue&rs:Format=Excel
Here's the URL format:
http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Render&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Oct 10, 8:36 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> > I want to upload PDF and Excel files to the Report Server database. I
> > would like to display them in a custom web application. When working
> > with the ReportViewer control, I can easily show reports. I can't
> > figure out the process on how to show a PDF to a user. In particular,
> > if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> > get the file from Report Server so I can stream it to the user?
> If you create a report that has the same format and output as the PDF
> and Excel files, you could call the report and automatically render it
> to PDF or Excel with a download prompt via URL. Here are a couple
> examples.http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=
=3DRend...
> -or-http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=3DRe=
nd...
> Here's the URL format:
> http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=3DR=
ende=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/CSV/XML/Excel/=MHTML>
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
These are generic PDF files, not based on a report so they cannot be
rendered. We are using Reporting Services to provide security not
only to reports, but also some ancillary PDF and Excel files.|||Where does an uploaded pdf get stored'
Our uploaded pdf changes every week and rather than reupload everytime I was
hoping we could just save changes to the location it was uploaded to.
Many Thanks
"google@.landy.net" wrote:
> On Oct 10, 8:36 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> >
> > > I want to upload PDF and Excel files to the Report Server database. I
> > > would like to display them in a custom web application. When working
> > > with the ReportViewer control, I can easily show reports. I can't
> > > figure out the process on how to show a PDF to a user. In particular,
> > > if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> > > get the file from Report Server so I can stream it to the user?
> >
> > If you create a report that has the same format and output as the PDF
> > and Excel files, you could call the report and automatically render it
> > to PDF or Excel with a download prompt via URL. Here are a couple
> > examples.http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Rend...
> > -or-http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Rend...
> >
> > Here's the URL format:
> > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Rende-r&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
> > Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant
> These are generic PDF files, not based on a report so they cannot be
> rendered. We are using Reporting Services to provide security not
> only to reports, but also some ancillary PDF and Excel files.
>

Embed ASP page INSIDE my report

I would like to embed an .ASP page INSIDE my report...
I know I can add images inside through URL. But can add an asp page?
Can I do that with custom assembly?
If not, what version of reporting services would allow us to do so.
ThanksNo way I know of doing this. People have asked to be able to embed other
controls in a report which we'll look at doing but nothing concrete right
now.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407151625.4b36183f@.posting.google.com...
> I would like to embed an .ASP page INSIDE my report...
> I know I can add images inside through URL. But can add an asp page?
> Can I do that with custom assembly?
> If not, what version of reporting services would allow us to do so.
> Thanks

Email Notification with Custom Attachments using Notification Services 2005

Hi All,

I am using Notification Services 2005.I have done with the configuration and deployment of Notification Services 2005.Now i wanted to know how to send notifications via email with custom attachments.

Please help me out in this issue.

Amby

Hi Amby -

[copied for a reply to your newsgroup posting]

The built-in SMTP delivery protocol doesn't support attachments. But
you do have a couple of options:

1) you can build a custom delivery protocol that uses SMTP to send
notifications with attachments. I don't have Shyam Pather's SQLNS book
in front of me at the moment, but I think he goes through a similar
example in it. It's for v2.0, not 2005, but the same concepts should
apply.

2) I've also sent notifications via SMTP that have a link to a
resource that they need rather than including it as an attachment. For
example, rather than attaching a PDF, I place the PDF on a web site
and then send a link to the PDF in the notification. This has worked
well for me.

HTH....

--
Joe Webb
SQL Server MVP
http://www.sqlns.com

~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)

E-mail custom reports to different users

Does anyone know whats the best way to automate the e-mailing of
reports (say at the end of every month) to a list of people based on a
certian criteria for each report.
We have different sales people and we want to automate thier sales
comission report that needs to be generated and e-mailed to them (at
the end of every month) . We use thier "sales id" to query the
datbase and compile the report, so every sales person will have a
dfferent report.
Is there any suggestions to do this in one process instead of running
individual reports and e-mailing it to them seperately.
TIA
ChuckData driven subscriptions are what you are looking for. Information can be
found here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chuck" <chuck@.yeshcom.com> wrote in message
news:a4000eeb.0409011253.4429edee@.posting.google.com...
> Does anyone know whats the best way to automate the e-mailing of
> reports (say at the end of every month) to a list of people based on a
> certian criteria for each report.
> We have different sales people and we want to automate thier sales
> comission report that needs to be generated and e-mailed to them (at
> the end of every month) . We use thier "sales id" to query the
> datbase and compile the report, so every sales person will have a
> dfferent report.
> Is there any suggestions to do this in one process instead of running
> individual reports and e-mailing it to them seperately.
> TIA
> Chuck

Editing views in 2005 Management Studio

It was always the custom in Enterprise Manager, when creating a view, to
create a dummy view, e.g.:
SELECT 1
save it, then go back and edit the view. This way, you could edit the view
definition without Enterprise Manager destroying your formatting, and you
can add comments.
Now using "Microsoft SQL Server Management Studio", there is no longer a
"Properties" option if i right-click a view name.
So where is the option to edit a vew in MS?
(Is "MS" what we're abbreviating "Management Studio" these days?)Right click the view name in Management Studio and select Modify from
the context sensitive pop-up menu. Personally I always write creation &
alter scripts for every DDL object I create - that way you don't have
some GUI changing all your formatting etc. (also it's good for getting
the DDL syntax in your head).
I think Management Studio is commonly abbreviated SSMS (SQL Server
Management Studio). It seems to be the way Microsoft have marketed the
SQL 2005 products:
SSMS - SQL Server Management Studio
SSAS - SQL Server Analysis Service
SSIS - SQL Server Integration Services
SSRS - SQL Server Reporting Services (although I've often seen this as
just RS)
etc.
Although now that I think about it I've never seen Service Broker
abbreviated and I've seen Reporting & Notification Services abbreviated
as RS & NS (in fact I can't remember ever seeing Notification Services
abbreviated SSNS). Hmmm...
*mike hodgson*
http://sqlnerd.blogspot.com
Ian Boyd wrote:

>It was always the custom in Enterprise Manager, when creating a view, to
>create a dummy view, e.g.:
> SELECT 1
>save it, then go back and edit the view. This way, you could edit the view
>definition without Enterprise Manager destroying your formatting, and you
>can add comments.
>Now using "Microsoft SQL Server Management Studio", there is no longer a
>"Properties" option if i right-click a view name.
>
>So where is the option to edit a vew in MS?
>(Is "MS" what we're abbreviating "Management Studio" these days?)
>
>|||Do you mean using the query building tool? If you just want to edit in
text, click on Script View, Create As, To New Query Window and edit it
there. I tend to do that with all objects in SSMS
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
news:OWljNm4KGHA.3984@.TK2MSFTNGP14.phx.gbl...
> It was always the custom in Enterprise Manager, when creating a view, to
> create a dummy view, e.g.:
> SELECT 1
> save it, then go back and edit the view. This way, you could edit the view
> definition without Enterprise Manager destroying your formatting, and you
> can add comments.
> Now using "Microsoft SQL Server Management Studio", there is no longer a
> "Properties" option if i right-click a view name.
>
> So where is the option to edit a vew in MS?
> (Is "MS" what we're abbreviating "Management Studio" these days?)
>|||Not completely. BIDS is Business Intelligence Studio (though it could be
SSBIDS :)
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message
news:%23f$o554KGHA.1312@.TK2MSFTNGP09.phx.gbl...
Right click the view name in Management Studio and select Modify from the
context sensitive pop-up menu. Personally I always write creation & alter
scripts for every DDL object I create - that way you don't have some GUI
changing all your formatting etc. (also it's good for getting the DDL syntax
in your head).
I think Management Studio is commonly abbreviated SSMS (SQL Server
Management Studio). It seems to be the way Microsoft have marketed the SQL
2005 products:
SSMS - SQL Server Management Studio
SSAS - SQL Server Analysis Service
SSIS - SQL Server Integration Services
SSRS - SQL Server Reporting Services (although I've often seen this as just
RS)
etc.
Although now that I think about it I've never seen Service Broker
abbreviated and I've seen Reporting & Notification Services abbreviated as
RS & NS (in fact I can't remember ever seeing Notification Services
abbreviated SSNS). Hmmm...
mike hodgson
http://sqlnerd.blogspot.com
Ian Boyd wrote:
It was always the custom in Enterprise Manager, when creating a view, to
create a dummy view, e.g.:
SELECT 1
save it, then go back and edit the view. This way, you could edit the view
definition without Enterprise Manager destroying your formatting, and you
can add comments.
Now using "Microsoft SQL Server Management Studio", there is no longer a
"Properties" option if i right-click a view name.
So where is the option to edit a vew in MS?
(Is "MS" what we're abbreviating "Management Studio" these days?)|||"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message
news:%23f$o554KGHA.1312@.TK2MSFTNGP09.phx.gbl...
> Right click the view name in Management Studio and select Modify from
> the context sensitive pop-up menu. Personally I always write creation &
> alter scripts for every DDL object I create - that way you don't have
> some GUI changing all your formatting etc. (also it's good for getting
> the DDL syntax in your head).
That doesn't work. It shows me the SQL of the view, but not the view
defintion itself. And if i modify the SQL formatting, or add comments, the
formatting is destroyed and comments are removed.
Any other suggestions?|||> Do you mean using the query building tool? If you just want to edit in
> text, click on Script View, Create As, To New Query Window and edit it
> there. I tend to do that with all objects in SSMS
i want the equivalent of Enterprise Manager's
Right-Click->Properties
i don't want to have to script the view, and then run a drop-create.
Everyone, it's okay to admit that it cannot be done in SSMS.|||> Everyone, it's okay to admit that it cannot be done in SSMS.
Sorry, just trying to figure out what you want and fit an answer to your
request.
If you are asking is the paradigm of SSMS the same as EM. No, not at all.
(And I don't like query editors at all, so I would never have used it in EM
either.) SSMS uses an editing paradigm of files, and you start one by
scripting objects to the file.
Instead of scripting it as CREATE, script is as ALTER and you can save
changes by just executing the batch.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Ian Boyd" <ian.msnews010@.avatopia.com> wrote in message
news:eWlEZi$KGHA.1236@.TK2MSFTNGP10.phx.gbl...
> i want the equivalent of Enterprise Manager's
> Right-Click->Properties
> i don't want to have to script the view, and then run a drop-create.
> Everyone, it's okay to admit that it cannot be done in SSMS.
>|||"Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
news:ellSfRALGHA.2780@.tk2msftngp13.phx.gbl...
> If you are asking is the paradigm of SSMS the same as EM. No, not at all.
> (And I don't like query editors at all, so I would never have used it in
> EM either.)
i also don't like query editors, and always created and edited view DDL
directly

> Sorry, just trying to figure out what you want and fit an answer to your
> request.
...which was different from Right-Click->Design View|||Yeah, OK. Looks like the Modify menu option is about as close as SSMS
gets to the old SQLEM view properties. But you're right - it reformats
stuff (don't you hate it when tools do that!).
The easiest thing for you to do (doesn't require hand-crafting scripts)
is to just right click the view name and select Script View As | ALTER
To | New Query Editor Window. That will automatically generate the
ALTER VIEW script for you from the actual view schema (ie. it'll keep
whatever comments & whitespace were in the code). All you have to do is
change the bits you want changed and then execute the ALTER VIEW
statement. You don't even have to save the script if you don't want
(although, personally, I would always keep a record of what I changed in
the DDL). And since it's an ALTER statement it'll keep dependencies,
permissions & all those other things that tend to disappear and get
forgotten when you DROP VIEW... CREATE VIEW...
That's about as close as I can suggest to simulate the old View
Properties dialog box in SQLEM.
*mike hodgson*
http://sqlnerd.blogspot.com
Ian Boyd wrote:

>"Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
>news:ellSfRALGHA.2780@.tk2msftngp13.phx.gbl...
>
>i also don't like query editors, and always created and edited view DDL
>directly
>
>
>
>
>...which was different from Right-Click->Design View
>
>|||use Script as Alter.
EM scripts the view to the properties window using a CREATE, so it ran a
drop-create under the hood, and restored permissions.
The only thing the properties window gave you that scripting doesn't is
the permissions button.
But if you script as alter instead, you don't have to worry about losing
permissions, so that's moot.
The advantages of having the script (you can search, it's not a modal
window, it's far easier to read, you can save to a file directly from
it, etc.) far outweight the EM properties window. [i rap knuckles around
here when i see people using EM props window :)]
Ian Boyd wrote:
>
> i want the equivalent of Enterprise Manager's
> Right-Click->Properties
> i don't want to have to script the view, and then run a drop-create.
> Everyone, it's okay to admit that it cannot be done in SSMS.
>

Editing User Defined Data type

Is there an easy way to edit an existing User Defined Data type ? For instance i have a custom data type address of base type nvarchar with a length of 40, I want to increase this custom data types length to 50, is there a way to do it or is it even supported?

The SQL Server 2005 Mangement Studio does not allow you do it..is there a work around for this?

Thanks,

Krishna

There is no easy way to do this without dropping and recreating the user-defined data type. You can do this via TSQL. I do not know about the GUI. You might want to ask this question in the SQL Server Tools forum.|||

Thanks, its the same with GUI, its not editable, it just allows us to either delete them and re-create them. Also before deleting them it makes us to remove all references, so its a bit of work..

Regards,

Krishna

Editing Underlying boolean data without making cells Editable

I'm having a real hard time coming up with a solution to this problem. I created a custom gridview control from Dino Esposito's "Extending Gridview" article which autogenerates a checkbox column that allows for multiple record selection. Once a user checks a box, the entire row gets selected. I added a dropdown list on the top of the page that has only two options, "Yes" or "No". What I'm trying to do is update a boolean column called "contract" (I'm using the Pubs sample database) for all selected rows (via checkboxes checked) depending on whether the user selects "Yes" or "No" from the drop down menu.

For example,

1) the user selects "No" in the dropdown

2) The user checks all rows in the checkbox column for which he wants the all the values"contract" field set to "No"

3) The user then clicks on a button called "Submit" and all selected records get updated to "No" under the "contracts" column.

The idea is to allow the user to change the boolean values from a field for multiple records. Hence, making individual cells editable is pointless. Anybody have an idea how to go about this?

Yes, do you have code you can post? Post it and I'll help.

|||

Ok I included the aspx and the aspx.cs code. I'm pretty new with asp.net so the code might not be all that great. Pay no heed to the MenuItems. The Post Back Button is what is supposed to trigger the updates after the selections are made. I appreciate your help.

<%@. Page Language="C#" AutoEventWireup="true" CodeFile="TestSSLServer.aspx.cs" Inherits="TestSSLServer" %><%@. Register Namespace="MsdnMag.CuttingEdge.Controls" TagPrefix="x" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" ><head id="Head1" runat="server"> <title>Untitled Page</title></head><body> <form id="form1" runat="server"> <div> <asp:Menu ID="Menu1" runat="server" BackColor="#E0E0E0" DynamicHorizontalOffset="2" Font-Names="Verdana" Font-Size="8pt" ForeColor="#284E98" Orientation="Horizontal" StaticSubMenuIndent="10px" OnMenuItemClick="Menu1_MenuItemClick"> <StaticMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" /> <DynamicHoverStyle BackColor="#284E98" ForeColor="White" /> <DynamicMenuStyle BackColor="#B5C7DE" /> <StaticSelectedStyle BackColor="#507CD1" /> <DynamicSelectedStyle BackColor="#507CD1" /> <DynamicMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" /> <Items> <asp:MenuItem Text="Personal notes" Value="Notes"></asp:MenuItem> <asp:MenuItem Text="Orders" Value="Orders"></asp:MenuItem> </Items> <StaticHoverStyle BackColor="#284E98" ForeColor="White" /> </asp:Menu> <hr /> <asp:DropDownList ID="DropDownList1" runat="server" Width="133px"> <asp:ListItem Value="True">Yes</asp:ListItem> <asp:ListItem Value="False">No</asp:ListItem> </asp:DropDownList><br /> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:PUBSConnectionString%>" SelectCommand="SELECT [au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract] FROM [authors]" /> <x:GridView runat="server" ID="GridView1" AutoGenerateCheckBoxColumn="True" DataSourceID="SqlDataSource1" AllowPaging="True" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" onrowupdating="GridView1_RowUpdating" Font-Names="Verdana" Font-Size="8pt" GridLines="Horizontal" AutoGenerateColumns="False" DataKeyNames="au_id"> <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" /> <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" /> <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" /> <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" /> <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" /> <AlternatingRowStyle BackColor="#F7F7F7" /> <Columns> <asp:BoundField DataField="au_id" HeaderText="au_id" ReadOnly="True" SortExpression="au_id" /> <asp:BoundField DataField="au_lname" HeaderText="au_lname" SortExpression="au_lname" /> <asp:BoundField DataField="au_fname" HeaderText="au_fname" SortExpression="au_fname" /> <asp:BoundField DataField="phone" HeaderText="phone" SortExpression="phone" /> <asp:BoundField DataField="address" HeaderText="address" SortExpression="address" /> <asp:BoundField DataField="city" HeaderText="city" SortExpression="city" /> <asp:BoundField DataField="state" HeaderText="state" SortExpression="state" /> <asp:BoundField DataField="zip" HeaderText="zip" SortExpression="zip" /> <asp:TemplateField HeaderText="contract" SortExpression="contract"> <itemtemplate> <asp:Label ID="Label1" runat="server" Text='<%# changeTrueFalseToYesNo(Eval("contract"))%>'></asp:Label> </itemtemplate> </asp:TemplateField> </Columns> </x:GridView> <asp:Button runat="server" ID="Button1" Text="Just post back" OnClick="Button1_Click" /> <hr /> <asp:Label ID="Results" runat="server" Text=""></asp:Label> </div> </form></body></html>

using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partialclass TestSSLServer : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e) { }// end Page_Load // The following method displays the string depending on whether the user // clicked on Notes or Orders. There is commented just adds the 0-based // index of the row the the txt string. This is just to check if the indexes // are correct when needed.protected void Menu1_MenuItemClick(object sender, MenuEventArgs e) {string txt ="";if (e.Item.Value =="Notes") txt ="Show personal notes for the following indices:<br>";else txt ="Show orders for the following indices:<br>";foreach (int indexin GridView1.GetSelectedIndices()) {string key = (string)GridView1.DataKeys[index].Value; txt += key +", ";// txt += index + ", "; } Results.Text = txt; }// The following method displays the record when the user // enters the submit button.protected void Button1_Click(object sender, EventArgs e) {// Get the GridViewRow object that represents the row being edited // from the Rows collection of the GridView control.foreach (int indexin GridView1.GetSelectedIndices()) { GridViewRow row = GridView1.Rows[index]; Label contractLabel = (Label)row.FindControl("contract");if (contractLabel.Text.Equals("Yes")) { e.NewValues["contract"] ="No"; }// end else ifelse if (contractLabel.Text.Equals("No")) { e.NewValues["contract"] ="Yes"; }// end else if }// end foreach }// end Button1_Clickprotected string changeTrueFalseToYesNo(object o) {string myString;if (Convert.ToBoolean(o) ==true) { myString ="Yes"; }// end ifelse { myString ="No"; }// end elsereturn myString; }// end changeTrueFalseToYesNo}// end of class

"MsdnMag.CuttingEdge.Controls" TagPrefix="x" %>

|||

I edited the code so that it is more readable. It's easier to see what I'm trying to do. Omit the Gridview1_updating in the markup. Sorry, about the messy code.