Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Datagrid Control > Newbie, gridview problem ASP.net 2005

Reply
Thread Tools

Newbie, gridview problem ASP.net 2005

 
 
verci
Guest
Posts: n/a
 
      08-19-2006
Hi
Can anyone help me I'm running Win XP Pro SP2, VS2005 Team, .Net Framework
2.0 and SQL Server2005, I can't delete records using the gridviews
deletecommand, the updatecommand works fine, edit and calcel all works fine
the problem is the delete part, I get the message:

-----------------------------------------------ERROR
MESSAGE----------------------------------------------------------------------------------------
Must declare the scalar variable "@productid".
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Must declare the
scalar variable "@productid".
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


Here's my default3.aspx source code so far I've been stuck two days, thanks
and best regards.

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default3.aspx.vb"
Inherits="Default3" %>
!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 runat="server">

<title>Untitled Page</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$
ConnectionStrings:NwindConnectionString %>"

SelectCommand="SELECT p.ProductID, p.ProductName, p.CategoryID,
c.CategoryName FROM Products p inner join Categories c on p.CategoryID =
c.CategoryID"

UpdateCommand="Update Products Set ProductID=@ProductID,
ProductName=@ProductName, CategoryID=@CategoryID where ProductID=@ProductID"

DeleteCommand="delete from products where productid=@productid">

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$
ConnectionStrings:NwindConnectionString %>"

SelectCommand="SELECT [CategoryID], [CategoryName] FROM [Categories]">

</asp:SqlDataSource>

</div>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333"
GridLines="None" AllowPaging="True">

<Columns>

<asp:CommandField ButtonType="Image" CancelImageUrl="~/Images/Cancel.gif"
EditImageUrl="~/Images/WRITE2.gif"

ShowEditButton="True" UpdateImageUrl="~/Images/Update.gif"
DeleteImageUrl="~/Images/waste-trash.gif" ShowDeleteButton="True" />

<asp:TemplateField SortExpression="ProductID">

<EditItemTemplate>

<asp:Label ID="TextBox1" runat="server" Text='<%# Bind("ProductID")%>'
Visible=false></asp:Label>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="Label2" runat="server" Text='<%# Bind("ProductID") %>'
Visible=false></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:BoundField DataField="ProductName" HeaderText="ProductName"
SortExpression="ProductName" />

<asp:TemplateField HeaderText="CategoryID" SortExpression="CategoryID">

<EditItemTemplate>

<aspropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource2"

DataTextField="CategoryName" DataValueField="CategoryID" SelectedValue='<%#
Bind("CategoryID") %>' >

</aspropDownList>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryName")
%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

</Columns>

<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

<SelectedRowStyle BackColor="#D1DDF1" ForeColor="#333333" Font-Bold="True"
/>

<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center"
/>

<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

<AlternatingRowStyle BackColor="White" />

<RowStyle BackColor="#EFF3FB" />

<EditRowStyle BackColor="#2461BF" />

</asp:GridView>

</form>

</body>

</html>


 
Reply With Quote
 
 
 
 
Bruno Alexandre
Guest
Posts: n/a
 
      08-19-2006
you have missed a lot of commands

<asp:GridView ... DataKeyNames="ProductID" ...

and add the DeleteParameters, UpdateParameters and InsertParameters (if you
want to insert) in the DataSource




--

Bruno Alexandre
"a Portuguese in KÝbenhav, Danmark"



"verci" <(E-Mail Removed)> escreveu na mensagem
news:%(E-Mail Removed)...
> Hi
> Can anyone help me I'm running Win XP Pro SP2, VS2005 Team, .Net Framework
> 2.0 and SQL Server2005, I can't delete records using the gridviews
> deletecommand, the updatecommand works fine, edit and calcel all works
> fine the problem is the delete part, I get the message:
>
> -----------------------------------------------ERROR
> MESSAGE----------------------------------------------------------------------------------------
> Must declare the scalar variable "@productid".
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
>
> Exception Details: System.Data.SqlClient.SqlException: Must declare the
> scalar variable "@productid".
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>
> Here's my default3.aspx source code so far I've been stuck two days,
> thanks and best regards.
>
> <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default3.aspx.vb"
> Inherits="Default3" %>
> !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 runat="server">
>
> <title>Untitled Page</title>
>
> </head>
>
> <body>
>
> <form id="form1" runat="server">
>
> <div>
>
> <asp:SqlDataSource ID="SqlDataSource1" runat="server"
> ConnectionString="<%$ ConnectionStrings:NwindConnectionString %>"
>
> SelectCommand="SELECT p.ProductID, p.ProductName, p.CategoryID,
> c.CategoryName FROM Products p inner join Categories c on p.CategoryID =
> c.CategoryID"
>
> UpdateCommand="Update Products Set ProductID=@ProductID,
> ProductName=@ProductName, CategoryID=@CategoryID where
> ProductID=@ProductID"
>
> DeleteCommand="delete from products where productid=@productid">
>
> </asp:SqlDataSource>
>
> <asp:SqlDataSource ID="SqlDataSource2" runat="server"
> ConnectionString="<%$ ConnectionStrings:NwindConnectionString %>"
>
> SelectCommand="SELECT [CategoryID], [CategoryName] FROM [Categories]">
>
> </asp:SqlDataSource>
>
> </div>
>
> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
> DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333"
> GridLines="None" AllowPaging="True">
>
> <Columns>
>
> <asp:CommandField ButtonType="Image" CancelImageUrl="~/Images/Cancel.gif"
> EditImageUrl="~/Images/WRITE2.gif"
>
> ShowEditButton="True" UpdateImageUrl="~/Images/Update.gif"
> DeleteImageUrl="~/Images/waste-trash.gif" ShowDeleteButton="True" />
>
> <asp:TemplateField SortExpression="ProductID">
>
> <EditItemTemplate>
>
> <asp:Label ID="TextBox1" runat="server" Text='<%# Bind("ProductID")%>'
> Visible=false></asp:Label>
>
> </EditItemTemplate>
>
> <ItemTemplate>
>
> <asp:Label ID="Label2" runat="server" Text='<%# Bind("ProductID") %>'
> Visible=false></asp:Label>
>
> </ItemTemplate>
>
> </asp:TemplateField>
>
> <asp:BoundField DataField="ProductName" HeaderText="ProductName"
> SortExpression="ProductName" />
>
> <asp:TemplateField HeaderText="CategoryID" SortExpression="CategoryID">
>
> <EditItemTemplate>
>
> <aspropDownList ID="DropDownList1" runat="server"
> DataSourceID="SqlDataSource2"
>
> DataTextField="CategoryName" DataValueField="CategoryID"
> SelectedValue='<%# Bind("CategoryID") %>' >
>
> </aspropDownList>
>
> </EditItemTemplate>
>
> <ItemTemplate>
>
> <asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryName")
> %>'></asp:Label>
>
> </ItemTemplate>
>
> </asp:TemplateField>
>
> </Columns>
>
> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
>
> <SelectedRowStyle BackColor="#D1DDF1" ForeColor="#333333" Font-Bold="True"
> />
>
> <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center"
> />
>
> <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
>
> <AlternatingRowStyle BackColor="White" />
>
> <RowStyle BackColor="#EFF3FB" />
>
> <EditRowStyle BackColor="#2461BF" />
>
> </asp:GridView>
>
> </form>
>
> </body>
>
> </html>
>
>



 
Reply With Quote
 
 
 
 
Bruno Alexandre
Guest
Posts: n/a
 
      08-19-2006


--

Bruno Alexandre
"a Portuguese in KÝbenhav, Danmark"



"verci" <(E-Mail Removed)> escreveu na mensagem
news:%(E-Mail Removed)...
> Hi
> Can anyone help me I'm running Win XP Pro SP2, VS2005 Team, .Net Framework
> 2.0 and SQL Server2005, I can't delete records using the gridviews
> deletecommand, the updatecommand works fine, edit and calcel all works
> fine the problem is the delete part, I get the message:
>
> -----------------------------------------------ERROR
> MESSAGE----------------------------------------------------------------------------------------
> Must declare the scalar variable "@productid".
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
>
> Exception Details: System.Data.SqlClient.SqlException: Must declare the
> scalar variable "@productid".
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>
> Here's my default3.aspx source code so far I've been stuck two days,
> thanks and best regards.
>
> <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default3.aspx.vb"
> Inherits="Default3" %>
> !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 runat="server">
>
> <title>Untitled Page</title>
>
> </head>
>
> <body>
>
> <form id="form1" runat="server">
>
> <div>
>
> <asp:SqlDataSource ID="SqlDataSource1" runat="server"
> ConnectionString="<%$ ConnectionStrings:NwindConnectionString %>"
>
> SelectCommand="SELECT p.ProductID, p.ProductName, p.CategoryID,
> c.CategoryName FROM Products p inner join Categories c on p.CategoryID =
> c.CategoryID"
>
> UpdateCommand="Update Products Set ProductID=@ProductID,
> ProductName=@ProductName, CategoryID=@CategoryID where
> ProductID=@ProductID"
>
> DeleteCommand="delete from products where productid=@productid">
>
> </asp:SqlDataSource>
>
> <asp:SqlDataSource ID="SqlDataSource2" runat="server"
> ConnectionString="<%$ ConnectionStrings:NwindConnectionString %>"
>
> SelectCommand="SELECT [CategoryID], [CategoryName] FROM [Categories]">
>
> </asp:SqlDataSource>
>
> </div>
>
> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
> DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333"
> GridLines="None" AllowPaging="True">
>
> <Columns>
>
> <asp:CommandField ButtonType="Image" CancelImageUrl="~/Images/Cancel.gif"
> EditImageUrl="~/Images/WRITE2.gif"
>
> ShowEditButton="True" UpdateImageUrl="~/Images/Update.gif"
> DeleteImageUrl="~/Images/waste-trash.gif" ShowDeleteButton="True" />
>
> <asp:TemplateField SortExpression="ProductID">
>
> <EditItemTemplate>
>
> <asp:Label ID="TextBox1" runat="server" Text='<%# Bind("ProductID")%>'
> Visible=false></asp:Label>
>
> </EditItemTemplate>
>
> <ItemTemplate>
>
> <asp:Label ID="Label2" runat="server" Text='<%# Bind("ProductID") %>'
> Visible=false></asp:Label>
>
> </ItemTemplate>
>
> </asp:TemplateField>
>
> <asp:BoundField DataField="ProductName" HeaderText="ProductName"
> SortExpression="ProductName" />
>
> <asp:TemplateField HeaderText="CategoryID" SortExpression="CategoryID">
>
> <EditItemTemplate>
>
> <aspropDownList ID="DropDownList1" runat="server"
> DataSourceID="SqlDataSource2"
>
> DataTextField="CategoryName" DataValueField="CategoryID"
> SelectedValue='<%# Bind("CategoryID") %>' >
>
> </aspropDownList>
>
> </EditItemTemplate>
>
> <ItemTemplate>
>
> <asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryName")
> %>'></asp:Label>
>
> </ItemTemplate>
>
> </asp:TemplateField>
>
> </Columns>
>
> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
>
> <SelectedRowStyle BackColor="#D1DDF1" ForeColor="#333333" Font-Bold="True"
> />
>
> <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center"
> />
>
> <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
>
> <AlternatingRowStyle BackColor="White" />
>
> <RowStyle BackColor="#EFF3FB" />
>
> <EditRowStyle BackColor="#2461BF" />
>
> </asp:GridView>
>
> </form>
>
> </body>
>
> </html>
>
>



 
Reply With Quote
 
Bruno Alexandre
Guest
Posts: n/a
 
      08-19-2006
You are missing a lot of commands to perform such task

first you need to especify the DataKeyNames in the GridView itself and them
add the DeleteParameters and UpdateParameters on the DataSource

<asp:GridView DataKeyNames="productID" ...

<DeleteParameters>
<asparameter Name="productID" Type="Decimal" />
</DeleteParameters>

<UpdateParameters>
<asparameter Name="productID" Type="Decimal" />
<asparameter Name="ProductName" Type="Decimal" />
<asparameter Name="CategoryID" Type="Decimal" />
</UpdateParameters>

I dont know if your columns are Decimal or not, but change it to the proper
data type

--

Bruno Alexandre
"a Portuguese in KÝbenhav, Danmark"



"verci" <(E-Mail Removed)> escreveu na mensagem
news:%(E-Mail Removed)...
> Hi
> Can anyone help me I'm running Win XP Pro SP2, VS2005 Team, .Net Framework
> 2.0 and SQL Server2005, I can't delete records using the gridviews
> deletecommand, the updatecommand works fine, edit and calcel all works
> fine the problem is the delete part, I get the message:
>
> -----------------------------------------------ERROR
> MESSAGE----------------------------------------------------------------------------------------
> Must declare the scalar variable "@productid".
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
>
> Exception Details: System.Data.SqlClient.SqlException: Must declare the
> scalar variable "@productid".
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>
> Here's my default3.aspx source code so far I've been stuck two days,
> thanks and best regards.
>
> <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default3.aspx.vb"
> Inherits="Default3" %>
> !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 runat="server">
>
> <title>Untitled Page</title>
>
> </head>
>
> <body>
>
> <form id="form1" runat="server">
>
> <div>
>
> <asp:SqlDataSource ID="SqlDataSource1" runat="server"
> ConnectionString="<%$ ConnectionStrings:NwindConnectionString %>"
>
> SelectCommand="SELECT p.ProductID, p.ProductName, p.CategoryID,
> c.CategoryName FROM Products p inner join Categories c on p.CategoryID =
> c.CategoryID"
>
> UpdateCommand="Update Products Set ProductID=@ProductID,
> ProductName=@ProductName, CategoryID=@CategoryID where
> ProductID=@ProductID"
>
> DeleteCommand="delete from products where productid=@productid">
>
> </asp:SqlDataSource>
>
> <asp:SqlDataSource ID="SqlDataSource2" runat="server"
> ConnectionString="<%$ ConnectionStrings:NwindConnectionString %>"
>
> SelectCommand="SELECT [CategoryID], [CategoryName] FROM [Categories]">
>
> </asp:SqlDataSource>
>
> </div>
>
> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
> DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333"
> GridLines="None" AllowPaging="True">
>
> <Columns>
>
> <asp:CommandField ButtonType="Image" CancelImageUrl="~/Images/Cancel.gif"
> EditImageUrl="~/Images/WRITE2.gif"
>
> ShowEditButton="True" UpdateImageUrl="~/Images/Update.gif"
> DeleteImageUrl="~/Images/waste-trash.gif" ShowDeleteButton="True" />
>
> <asp:TemplateField SortExpression="ProductID">
>
> <EditItemTemplate>
>
> <asp:Label ID="TextBox1" runat="server" Text='<%# Bind("ProductID")%>'
> Visible=false></asp:Label>
>
> </EditItemTemplate>
>
> <ItemTemplate>
>
> <asp:Label ID="Label2" runat="server" Text='<%# Bind("ProductID") %>'
> Visible=false></asp:Label>
>
> </ItemTemplate>
>
> </asp:TemplateField>
>
> <asp:BoundField DataField="ProductName" HeaderText="ProductName"
> SortExpression="ProductName" />
>
> <asp:TemplateField HeaderText="CategoryID" SortExpression="CategoryID">
>
> <EditItemTemplate>
>
> <aspropDownList ID="DropDownList1" runat="server"
> DataSourceID="SqlDataSource2"
>
> DataTextField="CategoryName" DataValueField="CategoryID"
> SelectedValue='<%# Bind("CategoryID") %>' >
>
> </aspropDownList>
>
> </EditItemTemplate>
>
> <ItemTemplate>
>
> <asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryName")
> %>'></asp:Label>
>
> </ItemTemplate>
>
> </asp:TemplateField>
>
> </Columns>
>
> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
>
> <SelectedRowStyle BackColor="#D1DDF1" ForeColor="#333333" Font-Bold="True"
> />
>
> <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center"
> />
>
> <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
>
> <AlternatingRowStyle BackColor="White" />
>
> <RowStyle BackColor="#EFF3FB" />
>
> <EditRowStyle BackColor="#2461BF" />
>
> </asp:GridView>
>
> </form>
>
> </body>
>
> </html>
>
>



 
Reply With Quote
 
verci
Guest
Posts: n/a
 
      08-19-2006
Hey many thanks Bruno!!, that did it.


"Bruno Alexandre" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You are missing a lot of commands to perform such task
>
> first you need to especify the DataKeyNames in the GridView itself and
> them add the DeleteParameters and UpdateParameters on the DataSource
>
> <asp:GridView DataKeyNames="productID" ...
>
> <DeleteParameters>
> <asparameter Name="productID" Type="Decimal" />
> </DeleteParameters>
>
> <UpdateParameters>
> <asparameter Name="productID" Type="Decimal" />
> <asparameter Name="ProductName" Type="Decimal" />
> <asparameter Name="CategoryID" Type="Decimal" />
> </UpdateParameters>
>
> I dont know if your columns are Decimal or not, but change it to the
> proper data type
>
> --
>
> Bruno Alexandre
> "a Portuguese in KÝbenhav, Danmark"
>
>
>
> "verci" <(E-Mail Removed)> escreveu na mensagem
> news:%(E-Mail Removed)...
>> Hi
>> Can anyone help me I'm running Win XP Pro SP2, VS2005 Team, .Net
>> Framework 2.0 and SQL Server2005, I can't delete records using the
>> gridviews deletecommand, the updatecommand works fine, edit and calcel
>> all works fine the problem is the delete part, I get the message:
>>
>> -----------------------------------------------ERROR
>> MESSAGE----------------------------------------------------------------------------------------
>> Must declare the scalar variable "@productid".
>> Description: An unhandled exception occurred during the execution of the
>> current web request. Please review the stack trace for more information
>> about the error and where it originated in the code.
>>
>> Exception Details: System.Data.SqlClient.SqlException: Must declare the
>> scalar variable "@productid".
>> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>
>>
>> Here's my default3.aspx source code so far I've been stuck two days,
>> thanks and best regards.
>>
>> <%@ Page Language="VB" AutoEventWireup="false"
>> CodeFile="Default3.aspx.vb" Inherits="Default3" %>
>> !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 runat="server">
>>
>> <title>Untitled Page</title>
>>
>> </head>
>>
>> <body>
>>
>> <form id="form1" runat="server">
>>
>> <div>
>>
>> <asp:SqlDataSource ID="SqlDataSource1" runat="server"
>> ConnectionString="<%$ ConnectionStrings:NwindConnectionString %>"
>>
>> SelectCommand="SELECT p.ProductID, p.ProductName, p.CategoryID,
>> c.CategoryName FROM Products p inner join Categories c on p.CategoryID =
>> c.CategoryID"
>>
>> UpdateCommand="Update Products Set ProductID=@ProductID,
>> ProductName=@ProductName, CategoryID=@CategoryID where
>> ProductID=@ProductID"
>>
>> DeleteCommand="delete from products where productid=@productid">
>>
>> </asp:SqlDataSource>
>>
>> <asp:SqlDataSource ID="SqlDataSource2" runat="server"
>> ConnectionString="<%$ ConnectionStrings:NwindConnectionString %>"
>>
>> SelectCommand="SELECT [CategoryID], [CategoryName] FROM [Categories]">
>>
>> </asp:SqlDataSource>
>>
>> </div>
>>
>> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
>> DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333"
>> GridLines="None" AllowPaging="True">
>>
>> <Columns>
>>
>> <asp:CommandField ButtonType="Image" CancelImageUrl="~/Images/Cancel.gif"
>> EditImageUrl="~/Images/WRITE2.gif"
>>
>> ShowEditButton="True" UpdateImageUrl="~/Images/Update.gif"
>> DeleteImageUrl="~/Images/waste-trash.gif" ShowDeleteButton="True" />
>>
>> <asp:TemplateField SortExpression="ProductID">
>>
>> <EditItemTemplate>
>>
>> <asp:Label ID="TextBox1" runat="server" Text='<%# Bind("ProductID")%>'
>> Visible=false></asp:Label>
>>
>> </EditItemTemplate>
>>
>> <ItemTemplate>
>>
>> <asp:Label ID="Label2" runat="server" Text='<%# Bind("ProductID") %>'
>> Visible=false></asp:Label>
>>
>> </ItemTemplate>
>>
>> </asp:TemplateField>
>>
>> <asp:BoundField DataField="ProductName" HeaderText="ProductName"
>> SortExpression="ProductName" />
>>
>> <asp:TemplateField HeaderText="CategoryID" SortExpression="CategoryID">
>>
>> <EditItemTemplate>
>>
>> <aspropDownList ID="DropDownList1" runat="server"
>> DataSourceID="SqlDataSource2"
>>
>> DataTextField="CategoryName" DataValueField="CategoryID"
>> SelectedValue='<%# Bind("CategoryID") %>' >
>>
>> </aspropDownList>
>>
>> </EditItemTemplate>
>>
>> <ItemTemplate>
>>
>> <asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryName")
>> %>'></asp:Label>
>>
>> </ItemTemplate>
>>
>> </asp:TemplateField>
>>
>> </Columns>
>>
>> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
>>
>> <SelectedRowStyle BackColor="#D1DDF1" ForeColor="#333333"
>> Font-Bold="True" />
>>
>> <PagerStyle BackColor="#2461BF" ForeColor="White"
>> HorizontalAlign="Center" />
>>
>> <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
>>
>> <AlternatingRowStyle BackColor="White" />
>>
>> <RowStyle BackColor="#EFF3FB" />
>>
>> <EditRowStyle BackColor="#2461BF" />
>>
>> </asp:GridView>
>>
>> </form>
>>
>> </body>
>>
>> </html>
>>
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbie, gridview problem Asp.net 2005 verci ASP .Net Datagrid Control 2 08-28-2006 06:36 AM
Newbie, gridview problem Asp.net 2005 verci ASP .Net Building Controls 2 08-28-2006 06:36 AM
Newbie, gridview problem ASP.net 2005 verci ASP .Net 4 08-19-2006 06:29 PM
GridView Hierarchical View - Gridview in Gridview =?Utf-8?B?bWdvbnphbGVzMw==?= ASP .Net 1 05-09-2006 06:48 PM
ISC'2005 Industrial Simulation Conference, Berlin June 2005, CFP Philippe Geril VHDL 0 11-19-2004 04:13 PM



Advertisments