ASP.NET

Datagrid - how to avoid adding an item

6-Sep-06 14:20

The link[^] can give you some ideas.

thowra6-Sep-06 6:36

thowra

6-Sep-06 6:36

Hi,

I'm populating a datagrid in ASP.NET 1.1 and after binding it to a collection, the ItemDataBound event allows me to access the data after it's entered as a row into the grid. I can add tooltips to the individual cells depending on the cell value and so on, which is very useful. However, I also have need to exclude some of my items from ever being displayed in the grid and so I'd like to handle an event which occurs before each row in the datagrid is populated. In this way I can filter the contents of my datagrid rather than apply any filtering to the collection class which for one reason or another, I don't wish to do.

Is there any way of capturing the item *before* it's added to the grid to stop it ever being displayed? In other words, can I filter a grid at this level?

Evil cannot be conquered in the world... It can only be resisted within oneself.

Re: Datagrid - how to avoid adding an item

minhpc_bk6-Sep-06 14:23

delete confirm in asp.net with vb.net 1.1

6-Sep-06 14:23

Hi there,
In this case, you can think of hiding the datagrid row (DataGridItem) using the Visible property, so depending on the databound bound to the row you can set either the specific cells of the row or the entire row invisible, and the user does not see that displayed on the grid.

amaneet6-Sep-06 6:26

amaneet

6-Sep-06 6:26

Sir,
I want to confirm before deleting the row in the datagrid.By givig the message Are u sure u want to delete the record.
For that I am using the following code.

Select Case e.Item.ItemType
Case ListItemType.AlternatingItem, ListItemType.EditItem, ListItemType.Item
Dim b As Button
b = e.Item.FindControl("b")
b.Attributes.Add("onclick", "return confirm('Are you sure you want to delete ?');")
End Select
Now the problem My code for deleting the record is written in ItemCommand function of datagrid but control is not going after i press the ok botton of the messagebox.
Please help.
Thank You.

Re: delete confirm in asp.net with vb.net 1.1

postmaster@programmingknowledge.com6-Sep-06 14:38

postmaster@programmingknowledge.com

6-Sep-06 14:38

In ItemDataBound event add code below:

If e.Item.ItemType <> ListItemType.Header And e.Item.ItemType <> ListItemType.Footer Then <br />
       Dim obj As Object = e.Item.Cells(4).Controls(0) <br />
       Dim item As String = "this item"  <br />
<br />
obj.Attributes("onclick") = String.Format("javascript:return confirm('Are you sure you want to delete {0}?')", item) <br />
<br />
End If

For more detail visit:
http://www.programmingknowledge.com/simpleDataGrid.aspx[^]

GridView / ObjectDataSource problem [modified]

Robin C6-Sep-06 5:53

Robin C

6-Sep-06 5:53

I have a Repeater which is bound to an ObjectDataSource. Its item template contains a Gridview and ObjectDataSource, displaying details for each item in the repeater. The Repeater's ObjectDataSource has three parameters, a date range and name. I set the default value of name to '%'. Everything displays fine, but when you try to edit a row in on of the grids, the page posts back, but the row is not in edit mode... I tried setting the parameters programmatically, which got my edit working, but when the name field was empty and I passed '%' in, I get unexpected results (different than what my table adapter returns with the same parameters when I preview the data through the designer). Anyone have some insight on this?

-- modified at 12:16 Wednesday 6th September, 2006

Just noticed something, if I use control parameters and enter the value '%' in the name text box, then the edit works correctly... But '%' is the default value for that parameter, so how is that any different?

-- modified at 14:19 Wednesday 6th September, 2006

I just discovered the reason the edit workes when the name textbox has a value. It causes the execution of the select method on my repeater's ObjectdataSource. Any ideas why that would affect the editing?

Re: GridView / ObjectDataSource problem

minhpc_bk6-Sep-06 20:08

Re: GridView / ObjectDataSource problem

6-Sep-06 20:08

I guess that your sample code to build the gridview control relies on something such as the data binding expression ... that requires the Repeater's ObjectDataSource to execute its Select command. Below is a working sample with the two tables Categories and Products of the Northwind:

<asp:Repeater ID="Repeater1" runat="server" DataSourceID="ObjectDataSource1">
    <ItemTemplate>
        <%# Eval("CategoryName") %>
        <br />
            <asp:Label runat="server" ID="lblCategoryID" Visible="false" Text='<%# Eval("CategoryID") %>'></asp:Label>
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="ObjectDataSource2">
            <Columns>
                <asp:CommandField ShowEditButton="True" />
                <asp:BoundField DataField="ProductID" HeaderText="ProductID" />
                <asp:BoundField DataField="ProductName" HeaderText="ProductName" />
                <asp:BoundField DataField="UnitPrice" HeaderText="UnitPrice" />
            </Columns>
        </asp:GridView>
        <asp:ObjectDataSource ID="ObjectDataSource2" runat="server" SelectMethod="GetProducts"
            TypeName="Samples.AspNet.ObjectDataSource.NorthwindData">
            <SelectParameters>
                <asp:ControlParameter ControlID="lblCategoryID" Name="categoryID" PropertyName="Text" Type="Int32" />
            </SelectParameters>
        </asp:ObjectDataSource>
    </ItemTemplate>
</asp:Repeater>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" OnSelecting="ObjectDataSource1_Selecting"
    SelectMethod="GetCategories" TypeName="Samples.AspNet.ObjectDataSource.NorthwindData">
    <SelectParameters>
        <asp:Parameter DefaultValue="%" Name="name" Type="String" />
    </SelectParameters>
</asp:ObjectDataSource>
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="ObjectDataSource2">
    <Columns>
        <asp:BoundField DataField="CategoryID" HeaderText="CategoryID" />
    </Columns>
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSource2" runat="server" SelectMethod="GetCategories"
    TypeName="Samples.AspNet.ObjectDataSource.NorthwindData">
    <SelectParameters>
        <asp:Parameter DefaultValue="%" Name="name" Type="String" />
    </SelectParameters>
</asp:ObjectDataSource>

You might want to post your code snippets if you still cannot figure it out.

Robin C7-Sep-06 11:12

Robin C

7-Sep-06 11:12

Thanks for the reply, though I don't see what is different about the what I am doing and my edit does not work...

<asp:repeater id="repCommunities" runat="server" datasourceid="odsCommunity" enableviewstate="false">
<ItemTemplate>
<asp:HiddenField ID="txtID" runat="server" Value='<%# Eval("community_id") %>' />
<asp:GridView ID="gvCommunity" runat="server" AutoGenerateColumns="False" DataKeyNames="delay_id" DataSourceID="odsDelay">
<Columns>
<asp:BoundField DataField="delay_id" HeaderText="delay_id" InsertVisible="False" ReadOnly="True" SortExpression="delay_id" />
<asp:BoundField DataField="delay_day" HeaderText="delay_day" SortExpression="delay_day" />
<asp:BoundField DataField="delay_creator" HeaderText="delay_creator" SortExpression="delay_creator" />
<asp:BoundField DataField="delay_date" HeaderText="delay_date" SortExpression="delay_date" />
<asp:BoundField DataField="community_id" HeaderText="community_id" SortExpression="community_id" />
<asp:BoundField DataField="delay_action" HeaderText="delay_action" SortExpression="delay_action" />
<asp:BoundField DataField="delay_lot" HeaderText="delay_lot" SortExpression="delay_lot" />
<asp:BoundField DataField="delay_reason" HeaderText="delay_reason" SortExpression="delay_reason" />
<asp:CommandField ShowEditButton="true" />
</Columns>
</asp:GridView>
<br />
<asp:ObjectDataSource ID="odsDelay" runat="server" OldValuesParameterFormatString="original_{0}" TypeName="daSQL" SelectMethod="GetDelaysByCommunityAndDateRange" UpdateMethod="UpdateDelayAction" DeleteMethod="DeleteCommunity" InsertMethod="InsertDelay">
<SelectParameters>
<asp:ControlParameter ControlID="txtID" PropertyName="Value" DefaultValue="1" Name="communityID" />
<asp:ControlParameter ControlID="txtFrom" PropertyName="Text" DefaultValue="" Name="from" />
<asp:ControlParameter ControlID="txtTo" PropertyName="Text" DefaultValue="" Name="to" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="delay_lot" Type="String" />
<asp:Parameter Name="delay_day" Type="Int32" />
<asp:Parameter Name="delay_reason" Type="String" />
<asp:Parameter Name="delay_action" Type="String" />
<asp:Parameter Name="original_delay_id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="lot" Type="String" />
<asp:Parameter Name="day" Type="Int32" />
<asp:Parameter Name="creator" Type="String" />
<asp:Parameter Name="reason" Type="String" />
<asp:Parameter Name="communityID" Type="Int32" />
</InsertParameters>
</asp:ObjectDataSource>
</ItemTemplate>
</asp:repeater>
<asp:objectdatasource id="odsCommunity" runat="server" oldvaluesparameterformatstring="original_{0}"
selectmethod="GetUpdatedCommunitiesByDateRange" typename="QuadrantTableAdapters.communityTableAdapter"
deletemethod="Delete" insertmethod="Insert" updatemethod="Update" enableviewstate="False">
<DeleteParameters>
<asp:Parameter Name="Original_community_id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="community_name" Type="String" />
<asp:Parameter Name="community_active" Type="Boolean" />
<asp:Parameter Name="Original_community_id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="community_name" Type="String" />
<asp:Parameter Name="community_active" Type="Boolean" />
</InsertParameters>
<SelectParameters>
<asp:ControlParameter ControlID="txtFrom" Name="from" PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtTo" Name="to" PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtCommunity" Name="name" PropertyName="Text" Type="String" DefaultValue="%" />
</SelectParameters>
</asp:objectdatasource>

Re: GridView / ObjectDataSource problem

minhpc_bk7-Sep-06 22:56

Infragistics ultrawebgrid

7-Sep-06 22:56

The only difference is that you disable the ViewState that causes data is bound to the control late after the postback event is processed, and as a result of that the the GridView control is changed to the Edit mode. If you set the EnabledViewState property to false, you need to make sure that the control is recreated on postback based on the bound data, and it should appear early before the postback event is processed.

shivarishxxxx6-Sep-06 4:17

Re: Infragistics ultrawebgrid

6-Sep-06 4:17

Can anybody help me to bind data to Ultrawebgrid at runtime dynamically?
I dont want to create it at design time at all.

When I bind ultrawebgrid just like datagrid, it says, object reference not set to an instance of an object.

using Infragistics.WebUI.UltraWebGrid;

protected Infragistics.WebUI.UltraWebGrid.UltraWebGrid grid1 ;
grid1 = new Infragistics.WebUI.UltraWebGrid.UltraWebGrid();
grid1.DataSource = dataset;
grid1.DisplayLayout.AutoGenerateColumns = true;
grid1.DataBind();

Please help

rmr

g00fyman6-Sep-06 4:43

Re: Infragistics ultrawebgrid

6-Sep-06 4:43

ok that should work although i normally set the DataMember Property as well,

so, it must be taht your dataset is not instantiated?

can you post more complete code, including funcitons called from?

my best practice for this is to use the designer to bind to a dataset at design time, then change the reference in Pre_Render() like so:

this.dataset = new DataSet();

// 
// fill ds here
//

this.ultraGrid1.DataSource = this.dataset;
this.ultraGrid1.DataMemeber = "DataTable";
this.ultraGrid1.DataBind();

obviously "DataTable" is the name of the table the band is bound to in the grid.

regs,
g00fy

shivarishxxxx6-Sep-06 5:05

6-Sep-06 5:05

Hi, Here is the code . And when i debug, the dataset is getting populated.
The error 'Object reference not set to an instance of an object' pops up at
grid1.DisplayLayout.AutoGenerateColumns = true; line in the code.

Am now having the grid in design time..and am giving this also
<%@ Register TagPrefix="igtbl" Namespace="Infragistics.WebUI.UltraWebGrid" Assembly="Infragistics.WebUI.UltraWebgrid.v2">

Please help.

using Infragistics.WebUI.UltraWebGrid;
using System.Data.SqlClient;

namespace A
{
public class sample : System.Web.UI.Page
{

protected Infragistics.WebUI.UltraWebGrid.UltraWebGrid grid1 ;

private void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
LoadContent();
}
}
private void LoadContent()
{
string strConnectionString = "data source=abc" +
"Database=Sample;User Id=a;Password=a;";

SqlConnection cnn;
cnn = new SqlConnection(strConnectionString);
try
{
cnn.Open();
}
catch (Exception ex)
{
throw ex;
}
grid1 = new Infragistics.WebUI.UltraWebGrid.UltraWebGrid();
SqlDataAdapter da;
DataSet ds1;
string s = "select * from a";
ds1 = new DataSet();
da = new SqlDataAdapter (s,cnn);

da.Fill(ds1, "Grid");
grid1.DataSource = ds1;
grid1.DisplayLayout.AutoGenerateColumns = true;
grid1.DataBind();

}
private void grid1_InitializeLayout(object sender,LayoutEventArgs e)
{
grid1.Width = System.Web.UI.WebControls.Unit.Pixel(400);
grid1.Height = System.Web.UI.WebControls.Unit.Pixel(400);

grid1.Bands[0].AllowAdd = Infragistics.WebUI.UltraWebGrid.AllowAddNew.No;
grid1.Bands[0].AllowDelete = Infragistics.WebUI.UltraWebGrid.AllowDelete.No;
grid1.DisplayLayout.AllowSortingDefault = AllowSorting.OnClient;
grid1.DisplayLayout.AllowColSizingDefault = Infragistics.WebUI.UltraWebGrid.AllowSizing.Free;
grid1.DisplayLayout.RowSizingDefault = Infragistics.WebUI.UltraWebGrid.AllowSizing.Free;
grid1.DisplayLayout.RowHeightDefault = System.Web.UI.WebControls.Unit.Pixel(22);
grid1.DisplayLayout.HeaderStyleDefault.Height = System.Web.UI.WebControls.Unit.Pixel(20);

grid1.Columns.FromKey("reportTitle").HeaderText = "Report Title";
grid1.Columns.FromKey("reportTitle").Width = System.Web.UI.WebControls.Unit.Pixel(550);
grid1.Columns.FromKey("reportTitle").AllowUpdate = AllowUpdate.No;

grid1.Columns.FromKey("reportName").HeaderText = "Report Title";
grid1.Columns.FromKey("reportName").Width = System.Web.UI.WebControls.Unit.Pixel(550);
grid1.Columns.FromKey("reportName").AllowUpdate = AllowUpdate.No;

}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}

///

/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///

private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

private void InitializeGridComponent()
{
this.grid1.InitializeLayout += new Infragistics.WebUI.UltraWebGrid.InitializeLayoutEventHandler(this.grid1_InitializeLayout);
//this.grid1.UpdateCellBatch += new Infragistics.WebUI.UltraWebGrid.UpdateCellBatchEventHandler(this.grid1_UpdateCellBatch);
//this.gridDocLink.UpdateCellBatch += new Infragistics.WebUI.UltraWebGrid.UpdateCellBatchEventHandler(this.gridDocLink_UpdateCellBatch);
// this.gridDocLink.DeleteRowBatch += new Infragistics.WebUI.UltraWebGrid.DeleteRowBatchEventHandler(this.gridDocLink_DeleteRowBatch);
// this.gridDocLink.AddRowBatch += new Infragistics.WebUI.UltraWebGrid.AddRowBatchEventHandler(this.gridDocLink_AddRowBatch);

}
}
}

rmr

RuntimeTabstrip Control

shivarishxxxx6-Sep-06 3:22

Re: RuntimeTabstrip Control

6-Sep-06 3:22

Can we design dynamic tabstrip control at runtime without creating tabstrip control at design time? Am trying to do it by adding
%@ Register TagPrefix="iewc" Namespace="Microsoft.Web.UI.WebControls" Assembly="Microsoft.Web.UI.WebControls" %> at asp.net design page (.aspx)

and

Microsoft.Web.UI.WebControls.TabStrip tabControl = new Microsoft.Web.UI.WebControls.TabStrip();

at code behind.

Microsoft.Web.UI.WebControls.Tab tab=new Microsoft.Web.UI.WebControls.Tab();

tab.Text= " ok" ;
tab.ID = "1" ;
tabControl.Items.Add(tab);

Am not getting anything on page. Can somebody help???

rmr

g00fyman6-Sep-06 3:50

Re: RuntimeTabstrip Control [modified]

6-Sep-06 3:50

You need to add the control to the Page's Control collection

Page.Controls.Add(tabControl);

regs
g00fy

shivarishxxxx6-Sep-06 4:13

Re: RuntimeTabstrip Control

6-Sep-06 4:13

Thanks for the reply.
But am not still able to get the tabcontrol. Please help

Design :

<%@ Register TagPrefix="iewc" Namespace="Microsoft.Web.UI.WebControls" Assembly="Microsoft.Web.UI.WebControls" %>

Code :
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here

Microsoft.Web.UI.WebControls.TabStrip tabControl = new Microsoft.Web.UI.WebControls.TabStrip();

Microsoft.Web.UI.WebControls.Tab tab=new Microsoft.Web.UI.WebControls.Tab();

tab.Text= " ok" ;
tab.ID = "1" ;
tabControl.Items.Add(tab);
Page.Controls.Add(tabControl);

}

-- modified at 10:20 Wednesday 6th September, 2006

rmr

g00fyman6-Sep-06 4:41

Re: Authentication Problems

6-Sep-06 4:41

ok i don't have that assembly and have never used it but this code works

protected void Page_Load(object sender, EventArgs e)
  {
    Table table = new Table();
    table.Rows.Add(new TableRow());
    table.Rows[0].Cells.Add(new TableCell());
    table.Rows[0].Cells[0].Controls.Add(new LiteralControl("cell 0"));

    Page.Controls.Add(table);
  }

and this code doesn't work

protected void Page_Load(object sender, EventArgs e)
  {
    Table table = new Table();
    table.Rows.Add(new TableRow());
    table.Rows[0].Cells.Add(new TableCell());
    table.Rows[0].Cells[0].Controls.Add(new LiteralControl("cell 0"));

    //Page.Controls.Add(table);
  }

hope that helps

g00fy

Authentication Problems

HRiazi6-Sep-06 3:18

HRiazi

6-Sep-06 3:18

Hi Guys;

Here is the problem.
Im trying to Authenticate a user to my site but the function

User.Identity.IsAuthenticated always returns false

what could be the problem.

I also checked the web.config file with another project of mine which works fine there were no differences!!

Thanks in advance
Riazi

g00fyman6-Sep-06 4:49