-----------------------------------------------------------

New Message on MumbaiUserGroup

-----------------------------------------------------------
From: chandrakant_parmar
Message 3 in Discussion


Thanx Jeff 
here is the code....


-----------------------------------------------------Data 
grid in aspx page

<asp:datagrid id="DgCon" 
AutoGenerateColumns="False" HeaderStyle-BackColor="#eeeeee" 
ShowFooter="False"
 Width="95%" ItemStyle-HorizontalAlign="Center" 
ItemStyle-CssClass="subheader" 
HeaderStyle-HorizontalAlign="Center"
 HeaderStyle-CssClass="header" 
Runat="server" EnableViewState="True">
 <ItemStyle 
HorizontalAlign="Center" 
CssClass="subheader"></ItemStyle>
 <HeaderStyle 
HorizontalAlign="Center" CssClass="header" 
BackColor="#EEEEEE"></HeaderStyle>
 <Columns>
 <asp:TemplateColumn>
  <ItemTemplate>
   <asp:Label 
Runat="server" ID="lblSelectedCityConvArea" Text='<%# 
DataBinder.Eval(Container.DataItem, "city")%>' Visible=False 
></asp:Label>
   <asp:CheckBox Runat="server" 
ID="chkDeleteConArea" Checked="True" 
EnableViewState="True"></asp:CheckBox>
  </ItemTemplate>
 </asp:TemplateColumn>
 <asp:TemplateColumn 
HeaderText="City/ 
Country">
  <ItemTemplate>
   <%# 
DataBinder.Eval(Container.DataItem, "city") 
%>
  </ItemTemplate>
 </asp:TemplateColumn>
 <asp:TemplateColumn 
HeaderText="Date">
  <ItemTemplate>
   <asp:Label 
id="lblDate" runat="server" text='<%# 
DataBinder.Eval(Container.DataItem("date"), "date", "{0:dd/MM/yyyy}") %>' 
></asp:Label>
  </ItemTemplate>
 </asp:TemplateColumn>
 </Columns>
 </asp:datagrid>
-----------------------------------------------------Code behind 
......

Private Sub Page_Load(ByVal sender As 
System.Object, ByVal e As System.EventArgs) Handles 
MyBase.Load
    objConn = New 
SqlConnection(ConfigurationSettings.AppSettings("connectionString"))
If Not 
IsPostBack Then
    BindDataConvenienceArea()
End 
If

End Sub

Protected Sub 
BindDataConvenienceArea()
    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()
     DgCon.DataSource = 
objDataS
     DgCon.DataBind()
End 
Sub
Regards.
Chandrakant.
----- Original Message ----- 

  From: 
  jeff 
  To: MumbaiUserGroup 
  Sent: Tuesday, August 19, 2003 5:53 
  PM
  Subject: Re: Check box State 
Problem
  

  
    
      
      New Message on MumbaiUserGroup
    
      

  Check box 
    State Problem


    
      
      
        Reply

        
          
            
            
               
              Reply to Sender   Recommend 
              Message 2 in 
                Discussion 
      
        
          
            
            
              From: jeff 
            
              
Hi Chandru,
Are u binding the 
                datagrid before postback or the datagrid is bound on every 
                page_load event.
Also if possible do paste the code u have 
                used in your 
      page.

Regards,
Jeff
View other groups in this 
    category. 



-----------------------------------------------------------

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]

Reply via email to