-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: parmar_CP
Message 1 in Discussion
<asp:datagrid id="DgConvArea"
OnEditCommand="DgConvArea_EditCommand"
OnUpdateCommand="DgConvArea_UpdateCommand"
OnCancelCommand="DgConvArea_CancelCommand"
AutoGenerateColumns="False"
HeaderStyle-BackColor="#eeeeee"
ShowFooter="True" Width="95%"
ItemStyle-HorizontalAlign="Center"
ItemStyle-CssClass="subheader"
HeaderStyle-HorizontalAlign="Center"
HeaderStyle-CssClass="header"
Runat="server">
<Columns>
<asp:EditCommandColumn
ButtonType="LinkButton" UpdateText="Update" HeaderText="Edit"
CancelText="Cancel"
EditText="Edit"></asp:EditCommandColumn>
<asp:TemplateColumn
HeaderText="Delete">
<HeaderTemplate>
<asp:CheckBox
Font-Name="Verdana" Font-Size="8" Runat="server"
ID="chkSelectAll"></asp:CheckBox>
</HeaderTemplate>
<ItemTemplate>
<asp:Label
ID="ConvenienceID" runat="server" Text='<%#
Container.DataItem("ConvenienceID") %>' Visible=False CssClass="text"
/>
<asp:CheckBox Font-Name="Verdana"
Font-Size="8" Runat="server"
ID="chkDelete"></asp:CheckBox>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn
HeaderText="City">
<ItemTemplate>
<%#
DataBinder.Eval(Container.DataItem, "City")
%>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn
HeaderText="Unite
Price">
<ItemTemplate>
<%#
DataBinder.Eval(Container.DataItem, "Qty")
%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox
ID="txtEditQty" runat="server" Text='<%# Container.DataItem("Qty") %>'
Columns="10" EnableViewState="True"
/>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn
HeaderText="Total
Price">
<ItemTemplate>
<%#
DataBinder.Eval(Container.DataItem, "currency")
%>
<%# DataBinder.Eval(Container.DataItem,
"Total")
%>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid>
Here is the code to bind the data
grid
If Not IsPostBack
Then
BindDataConvenienceArea()
End
If
Protected Sub
BindDataConvenienceArea()
' Create
the DataTable.
Dim objDataTable As
New
System.Data.DataTable("ConvenienceAreaItem")
' Add columns to the table -- one Integer, one String, and one
DateTime.
objDataTable.Columns.Add("Gp_Id",
System.Type.GetType("System.Int32"))
objDataTable.Columns.Add("productid",
System.Type.GetType("System.Int32"))
objDataTable.Columns.Add("productname",
System.Type.GetType("System.String"))
objDataTable.Columns.Add("unitprice",
System.Type.GetType("System.Double"))
objDataTable.Columns.Add("Qty",
System.Type.GetType("System.Double"))
objDataTable.Columns.Add("Currency",
System.Type.GetType("System.String"))
objDataTable.Columns.Add("total",
System.Type.GetType("System.Double"))
objDataTable.Columns.Add("ConvenienceID",
System.Type.GetType("System.Int32"))
objDataTable.Columns.Add("city",
System.Type.GetType("System.String"))
objDataTable.Columns.Add("country",
System.Type.GetType("System.String"))
' Add two rows of data.
Dim dr As
System.Data.DataRow
Dim
objDataCommand As SqlCommand
Dim
objDataReader As SqlDataReader
objDataS = New
System.Data.DataSet("ConvenienceAreaDataSet")
objDataS.Tables.Add(objDataTable)
Dim StrSql As String
StrSql = "sp_SelectGPconvenienceArea
"
objDataCommand = New
SqlCommand
objDataCommand.CommandText =
StrSql
objConn.Open()
objDataCommand.Connection =
objConn
objDataCommand.CommandType
= CommandType.StoredProcedure
objDataCommand.Parameters.Add("@userid",
SqlDbType.Text)
objDataCommand.Parameters("@userid").Value =
Session("userid")
objDataReader =
objDataCommand.ExecuteReader()
While objDataReader.Read()
'setting the values in the
row
dr =
objDataTable.NewRow()
dr("Gp_Id") =
objDataReader("Gp_Id")
dr("productid") =
objDataReader("productid")
dr("productname") =
objDataReader("productname")
lblproductName.Text =
objDataReader("productname")
dr("unitprice") =
objDataReader("productprice")
dr("Qty") =
objDataReader("Qty")
dr("Currency") =
objDataReader("Currency")
dr("total") = objDataReader("Qty") *
objDataReader("productprice")
dr("ConvenienceID") =
objDataReader("ConvenienceID")
dr("city") =
objDataReader("shipcity")
dr("country") =
objDataReader("shipcountry")
lblShipto.Text =
objDataReader("shipcountry")
objDataTable.Rows.Add(dr)
intShoppingProductCount = intShoppingProductCount +
1
' Add
the DataTable to a new DataSet.
End While
'End
If
If objConn.State Then
objConn.Close()
DgConvArea.DataSource = objDataS
DgConvArea.DataBind()
End
Sub
Regards.
Chandrakant.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
