Data Presentation Controls

Freezing the gridview header

radha_chirthanuru — Wed, 25 Nov 2009 11:17:06 GMT

Hi All,

i am using ASP.NET 3.0 with c#.

in my application i have master page and content pages based on master page.

in content page i am displaying the organization details in a gridview.it contains many rows.

my requirement is while seeing the records from grid view,i want to freez the gridview header.so that if the cursor down to see the last records, the gridview header will not move.

for that i wrote the java script function as

its working fine with normal asp.net page. but it is not working in content pages.

Help me in this

Thanks In Advance

Radha

File Downloads from a GridView

Depthcharge — Mon, 23 Nov 2009 22:16:33 GMT

I've got a dynamic data GridView with an unbound "Open Document" ASP:ButtonField column. When you click the button I want it to open a "Save As" dialog so you can download a pdf document associated with that record.

FRONT END
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
     <ContentTemplate>
          <iframe id="iFrameHidden" style="display: block;" runat="server" />

          <asp:GridView ID="GridView1" runat="server"
               DataSourceID="GridDataSource"
               OnRowCommand="GridView1_OnRowCommand">
                    <Columns>
                         <asp:ButtonField CommandName="OpenDocument" 
                              Text="Open Document" />
                    </Columns>                
          </asp:GridView>

          <asp:LinqDataSource ID="GridDataSource" runat="server"/>
     </ContentTemplate>
</asp:UpdatePanel>

BACK END
protected void GridView1_OnRowCommand(object sender,
     GridViewCommandEventArgs e)
{
     switch (e.CommandName)
     {
          case "OpenDocument":
          {
               GridView gv = sender as GridView;

               int key = Convert.ToInt32( 
                    gv.DataKeys[Convert.ToInt32(e.CommandArgument)].Value);

               using (MyWebServices serv = new (MyWebServices())
               {
                    DataTable dt = serv.GetAssignmentById(key);

                    // GetPaths
                    string path =
                         "/AssignmentDocuments/MyFile1.pdf"; 
                         
                    string name =
                         Path.GetFileName(path);
                            
                     // Load File in hidden IFrame
                     iFrameHidden.Attributes["src"] = path;

                     Response.AppendHeader(
                          "Content-Disposition", 
                          string.Format("attachment; filename={0}", name));
                            
                     Response.ContentType = "Application/pdf";
                     Response.WriteFile(path);
                     Response.End();

                     break;
               }
          }
     }
}

When I click the link I can confirm that my path is correct because I can get the PDF document to load inside of the iFrame but beyond that nothing else happens. If I try to open the file download first then I get no download and nothing appears in the iFrame. What am I doing wrong here? I've tried all day to get this to work and I just can't figure it out.

-DC

How to keep db value is new one is not provided?

cubangt — Fri, 27 Nov 2009 03:59:47 GMT

I have a page within my clients admin console.. i have it with a multiview setup. I have 3 views.. "Add" Modify" and "Delete"

Add view works fine..

Modify view is where i cant figure out the right solution. I have a gridview within this view and it lists out all the records each with an "Edit" option. Click on Edit you get all 3 fields in edit mode, this works great.. it displays the data and then allows you to edit with no problem ( AS LONG AS I CHANGE ALL 3 FIELDS )

#1 Field = Brief Summary
#2 Field = Uploaded PDF
#3 Field = UPloaded Video File

Now if i need to just update the Summary, i dont need to upload my files again, but if i dont select a file to upload, when the update occurs, the data in that field gets updated with nothing.. so i lose my path to the uploaded file.

I tried setting a session to the values returns when the gridview is onrowdatabound="GridView1_RowDataBound" but that doesnt seem to work, or it might, i just may have my code in the wrong order or if conditions are not checking correctly. Below is my GridView Row DataBound event. Now i do have some code that sets the session IF the upload button is clicked so as to capture the information for the file that was uploaded. But since im not clicking those buttons, why is the gridview code not working as i think it should?

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            DataRowView drv = e.Row.DataItem as DataRowView;

            if (drv["pdfupload"].ToString() != "")
            {
                Session["sessPDF"] = drv["pdfupload"].ToString();
            }
            else
            {
                Session["sessPDF"] = "";
            }

            if (drv["clipupload"].ToString() != "")
            {
                Session["sessCLIP"] = drv["clipupload"].ToString();
            }
            else
            {
                Session["sessCLIP"] = "";
            }

        }
    }

Custom sorting a bound GridView

fyathyrio8 — Mon, 23 Nov 2009 21:46:57 GMT

Here's the scenario:

I have a GridView that is bound to a MSSQL table. I need to sort it based on a column; however, I need to implement a custom comparison to be used for sorting. It is a varchar column with entries such as (1, 2... 300... 1000... 504-2). I have a comparison in place that I use in other applications to sort the versioning strings; however I can't seem to find a way to use it with the GridView. If I use the built-in sorting, I get the typical problem of 1000's being tossed in with 100's and such. Any ideas are greatly appreciated.

Displaying images from database

manir0209 — Wed, 25 Nov 2009 12:19:50 GMT

I've stored images in database in varbinary format... Now i want display it in the GridView Image Field... How can i do it...

Thanks in Advance...

Grid View

bhanu2217 — Wed, 18 Nov 2009 11:07:50 GMT

I am looking out for a free open grid view where i can implement these functinalities

1. Sorting with arrow images.

2. Paging controls.

3. Edit

Thanks in advance.

Total Column in Gridview

Bobby-Z — Mon, 23 Nov 2009 21:31:01 GMT

I have a gridview that is an Invoice with four columns, ItemID, Description, Price, Quantity but I want to add another column that multiplies the UnitPrice by the Quantity. The math thing is easy, but what type of column do I create and how do I display it.

Focus the child gridview in parent gridview

radha_chirthanuru — Thu, 26 Nov 2009 05:21:17 GMT

Hi All,

i am developing an application using ASP.NET 3.0 with c#.

in my application i have a nested gridview. i.e i placed a child grid in template field of parent grid.

when run the application, the parent grid will binded up.in parent gridview i took one button in the item template. when i click the button from the parent gridview,the child grid will binded up.

and my parent grid contains more records.when i scroll down the page to select the last row of parent gridview,the child grid will binded up.here i want that when i click the any row of parent gridview,the corresponding child gridview will focus.

for that i had written the code in parent gridview rowcommand as

foreach (GridViewRow gRow in gvorganization.Rows)
        {

                int commandIndex = Convert.ToInt32(e.CommandArgument.ToString());
                int RowIndex = gRow.RowIndex;
                Button b = (Button)gvorganization.Rows[RowIndex].Cells[1].FindControl("imgbtn");
                GridView gv = (GridView)gvorganization.Rows[RowIndex].Cells[2].FindControl("gvchild");
                if (commandIndex == RowIndex)
                {
                    if (b.Text == "+")
                    {
                        string fileno = "";
                        fileno = ((Label)gvorganization.Rows[RowIndex].Cells[0].FindControl("lblfileno")).Text;
                        Session["FileNo"] = fileno;
                        string strPkid = ((Label)gvorganization.Rows[commandIndex].Cells[9].FindControl("lblid")).Text;
                        Session["ID"] = strPkid;
                        string strNoofsites = ((Label)gvorganization.Rows[commandIndex].Cells[5].FindControl("lblnoofsites")).Text;
                        if (strNoofsites == "0")
                        {
                            gv.Focus();
                            gvorganization.Rows[commandIndex].Focus();
                        }
                        DataSet ds1 = new DataSet();
                        ds1 = objcommon.getsubsites(fileno,int.Parse(RadioButtonList1.SelectedValue.ToString()));
                        if (ds1 != null && ds1.Tables[0].Rows.Count != 0)
                        {
                            gv.DataSource = ds1.Tables[0];
                            gv.DataBind();
                            gv.Visible = true;
                            gv.Focus();
                            gvorganization.Rows[commandIndex].Focus();



                        }
                        b.Text = "-";
                    }
                    else if (b.Text == "-")
                    {
                        gv.Visible = false;
                        b.Text = "+";
                    }
                }
                else
                {

                    gv.Visible = false;
                    gv.Focus();
                    gvorganization.Rows[commandIndex].Focus();
                    b.Text = "+";
                }

}

here i had focus the child gridview as gv.Focus().

then also it is not working.

help me in this

Thanks in Advance

Radha.

Problem with repeater in usercontrol

andreyaz — Wed, 25 Nov 2009 06:51:09 GMT

I have the following business object structure:

I'm trying to create UserControl which allows edit of attributes on any IObjectWithAttributeValues, given a set of possible attributes with IObjectWithAttributes. On usercontrol i've placed a repeater, and wrapped attribute and its value into single structure (see BindableAttribute in codebehind file).

The problem is that when i place my control on page, i can get values from DB (NHibernate ORM'ed to business classes), but cannot post them back for some reason (on other pages almost same code works fine). How can i enable saving to DB in my case? It seems that control values are not retained on postback, but i'm too unexperienced with ASP.NET to say exactly.

UserControl ASPX source:

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="AttributeEdit.ascx.cs"
	Inherits="Resources_Controls_AttributeEdit" %>
<%@ Import Namespace="MedDB.DataModel.Core" %>
<asp:Repeater ID="rptAttributes" runat="server" OnItemDataBound="Xxx">
	<HeaderTemplate>
		<table>
	</HeaderTemplate>
	<FooterTemplate>
		</table></FooterTemplate>
	<ItemTemplate>
		<tr>
			<td width="30%">
				<asp:Label runat="server" CssClass="formlabel" Text='<%# Eval("Attribute.Name") %>'></asp:Label>
			</td>
			<td>
				<asp:PlaceHolder runat="server" Visible='<%# (AttributeValueType)Eval("Attribute.ValueType")==AttributeValueType.Float %>'>
					<asp:TextBox runat="server" ID="DoubleValue" Text='<%# Bind("Value") %>' EnableViewState="False" /> </asp:PlaceHolder>
				<asp:PlaceHolder runat="server" Visible='<%# (AttributeValueType)Eval("Attribute.ValueType")==AttributeValueType.Int %>'>
					<asp:TextBox runat="server" ID="IntValue" Text='<%# Bind("Value") %>' EnableViewState="False" /> </asp:PlaceHolder>
				<asp:PlaceHolder runat="server" Visible='<%# (AttributeValueType)Eval("Attribute.ValueType")==AttributeValueType.Select %>'>
					<asp:DropDownList runat="server" ID="ExactValue" DataSource='<%# Eval("Attribute.Values") %>' DataTextField="Value"
						DataValueField="Id" AppendDataBoundItems="true" SelectedValue='<%# Bind("Value") %>' EnableViewState="False">
						<asp:ListItem Value="" Text="--Не указано--" />
					</asp:DropDownList>
				</asp:PlaceHolder>
				<asp:PlaceHolder runat="server" Visible='<%# (AttributeValueType)Eval("Attribute.ValueType")==AttributeValueType.Text %>'>
					<asp:TextBox runat="server" ID="TextValue" Text='<%# Bind("Value") %>' EnableViewState="False" /> </asp:PlaceHolder>
			</td>
		</tr>
	</ItemTemplate>
</asp:Repeater>

UserControl CodeBehind:

using System;
using System.Collections.Generic;
using System.Globalization;
using System.Linq;
using MedDB.DataModel;
using MedDB.DataModel.Client;
using MedDB.DataModel.Core;
using AttributeValue=MedDB.DataModel.Client.AttributeValue;

public partial class Resources_Controls_AttributeEdit:System.Web.UI.UserControl {
	protected void Page_Load(object sender,EventArgs e) {
		
	}
	protected void Xxx(object sender,EventArgs e){
		
	}

	public IObjectWithAttributeValues ValuesDataSource {
		get;
		set;
	}
	public object DataSource {
		get { return rptAttributes.DataSource; }
		set {
			if(value is IObjectWithAttributes)
				rptAttributes.DataSource=Wrap(((IObjectWithAttributes)value).Attributes);
			else if(value is ICollection<MedDB.DataModel.Core.Attribute>)
				rptAttributes.DataSource=Wrap((ICollection<MedDB.DataModel.Core.Attribute>)value);
			else
				throw new ArgumentException("DataSource must be MedDB.DataModel.Core.IObjectWithAttributes or ICollection<MedDB.DataModel.Core.Attribute>");
		}
	}

	private List<BindableAttribute> Wrap(ICollection<MedDB.DataModel.Core.Attribute> attributes) {
		List<BindableAttribute> list=new List<BindableAttribute>();
		foreach(MedDB.DataModel.Core.Attribute attribute in attributes){
			list.Add(new BindableAttribute(attribute,this));
			
		}
		return list;
	}

	public override void DataBind() {
		rptAttributes.DataBind();
		base.DataBind();
	}


	public class BindableAttribute{
		public BindableAttribute(MedDB.DataModel.Core.Attribute attribute,Resources_Controls_AttributeEdit obj) {
			this.attribute=attribute;
			this.obj=obj;
		}
		private MedDB.DataModel.Core.Attribute attribute;
		private Resources_Controls_AttributeEdit obj;

		public MedDB.DataModel.Core.Attribute Attribute{get {return attribute;}}
		public object Value {
			get {
				IObjectWithAttributeValues @object=obj.ValuesDataSource;
				if(@object==null)
					return null;
				foreach(AttributeValue attributeValue in @object.AttributeValues) {
					if(attributeValue.Attribute==Attribute)
						return GetAttributeValue(attributeValue);
				}
				return null;
			}
			set{
				IObjectWithAttributeValues @object=obj.ValuesDataSource;
				if(@object==null)
					return;
				AttributeValue avalue=@object.AttributeValues.FirstOrDefault(x=>x.Attribute==Attribute);
				if(value==null||value.Equals("")){
					if(avalue!=null) @object.AttributeValues.Remove(avalue);
					return;
				}
				if(avalue==null){
					switch(Attribute.ValueType){
						case AttributeValueType.Float:
							avalue=new FloatAttributeValue();
							break;
						case AttributeValueType.Int:
							avalue=new IntAttributeValue();
							break;
						case AttributeValueType.Text:
							avalue=new TextAttributeValue();
							break;
						case AttributeValueType.Select:
							avalue=new ExactAttributeValue();
							break;
						default:
							throw new ArgumentException("Unknown AttributeValueType");
					}
					avalue.Attribute=attribute;
					@object.AttributeValues.Add(avalue);
				}
				switch(Attribute.ValueType){
					case AttributeValueType.Float:
						((FloatAttributeValue)avalue).Value=float.Parse(value.ToString().Replace(",",NumberFormatInfo.CurrentInfo.NumberDecimalSeparator).Replace(".",NumberFormatInfo.CurrentInfo.NumberDecimalSeparator));
						break;
					case AttributeValueType.Int:
						((IntAttributeValue)avalue).Value=int.Parse(value.ToString());
						break;
					case AttributeValueType.Text:
						((TextAttributeValue)avalue).Value=value.ToString();
						break;
					case AttributeValueType.Select:{
						((ExactAttributeValue)avalue).Value=Attribute.Values.First(x => x.Value.Equals(value.ToString()));
						break;
					}
				}
			}
		}

		private static object GetAttributeValue(AttributeValue value) {
			if(value is ExactAttributeValue)
				return ((ExactAttributeValue)value).Value.Id;
			if(value is FloatAttributeValue)
				return ((FloatAttributeValue)value).Value;
			if(value is IntAttributeValue)
				return ((IntAttributeValue)value).Value;
			if(value is TextAttributeValue)
				return ((TextAttributeValue)value).Value;
			return null;

		}
	}
	
}

How i insert control in page:

					<td colspan="3"><xx:AttributeEdit runat="server" DataSource='<%# Utility.GetAttributeContainer("Admission") %>' ValuesDataSource='<%# fvRecord.DataItem %>' /></td>

Sorting in Gridview master details

radha_chirthanuru — Wed, 25 Nov 2009 05:38:44 GMT

Hi All,

i am using ASP.NET 3.0 with c# and sqlserver2005 as backend database.

in my application i have a gridview with bound fields,template fields and buttom field.

and i have another grid view in the item template of parent gridview i.e i have a child gridview in the item template of parent grid view.

here i want to apply sorting for parent gridview and child gridview.

i don't know how to do this.

need it urgently.

help me with any code

Thanks in Advance

Radha.

Accessing Data In FormView

iLes — Thu, 26 Nov 2009 23:58:42 GMT

I have my labels in the Form View which bind data to them. And in template mode I added a button beside each label.

If I have lets say Label1 and Button1 on the row beside each other.

After page load, I want to have VB.net to run something like, the code, but it wont work. How can I programically access those labels and buttons. Thanks!

If Label1 Is Nothing Then

Button1.Visible = True

Else

Button1.Visible = False

End If

Must declare the scalar variable "@id" problem. + dictionary problem.

sapator — Wed, 25 Nov 2009 03:33:35 GMT

This occurs when i try to update a field on a formview.

I have DataKeyNames="id"

I have also both on edit and ItemTemplate

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

I also use an sqldatasource and i have tried to do this:

 <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:megatest2ConnectionString %>" 
        SelectCommand="SELECT id, name, petyears FROM Animals"
        ConflictDetection="CompareAllValues"
OldValuesParameterFormatString="original_{0}">
<UpdateParameters>           
            <asp:Parameter Name="id" Type="Int64" />
        </UpdateParameters>
        </asp:SqlDataSource>

Now if i use CompareAllValues i get this problem "You have specified that your update command compares all values on SqlDataSource 'SqlDataSource1', but the dictionary passed in for oldValues is empty. Pass in a valid dictionary for update or change your mode to OverwriteChanges."

Of course i want to use CompareAllValues.

Second problem is that to pass the CompareAllValues error for further testing i have specified OvewriteChanges.

Well it gives the Must declare the scalar variable "@id" problem..

I have tried declaring "id" in the markup, declaring "id" in the code, declare both in markup and code etc (will give gode in a sec), it will actually update the values when i have it on OverwriteChanges and then when the code block ends (FormView1_ItemUpdating) will though the must declare exception.. I was thinking if this has something to do with the mode changing back to readonly but it is just a thought and i don't know what can i do.

So to sum it up i need to MANUALLY pass the UpdateParameters values (no problem if "id" is passed in the markup alone), to have it on OverwriteChanges as a serious developer should have and to find out why it gives me the Must declare the scalar variable "@id" error.

The code that matters on FormView1_ItemUpdating (note that i have played with this code, changing CompareAllValues, removing the add id value and putting it on markup etc. But this is what i generally use)

 SqlDataSource1.ConflictDetection = ConflictOptions.CompareAllValues
        SqlDataSource1.UpdateCommand = "UPDATE animals SET [name] = @Name , petyears =@petyears WHERE ([id] = @id)"

        SqlDataSource1.UpdateParameters.Add("id", FormView1.DataKey("id"))
        SqlDataSource1.UpdateParameters.Add("name", TypeCode.String, txtname.Text)
        SqlDataSource1.UpdateParameters.Add("petyears", TypeCode.Int32, txtpetyears.Text)

Dim i As Integer = SqlDataSource1.Update ....

how to check that there is how many rows in a table

demoninside9 — Wed, 25 Nov 2009 08:02:01 GMT

hi all,

       On a button click event I am taking values of 5 rows from a table.
this is my code..

protected void Button3_Click(object sender, EventArgs e)
    {
        OleDbConnection con1 = new OleDbConnection(ConfigurationManager.ConnectionStrings["contest"].ConnectionString);
        con1.Open();
        string strSql = "select * from tblIssue_temp";
        OleDbCommand com1 = new OleDbCommand(strSql,con1);
        OleDbDataAdapter da = new OleDbDataAdapter(com1);
        DataTable dt = new DataTable();
        da.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            lblItem1.Text = dt.Rows[0]["SItem"].ToString();
            lblItem2.Text = dt.Rows[1]["SItem"].ToString();
            lblItem3.Text = dt.Rows[2]["SItem"].ToString();
            lblItem4.Text = dt.Rows[3]["SItem"].ToString();
            lblItem5.Text = dt.Rows[4]["SItem"].ToString();
            lblSize1.Text = dt.Rows[0]["ISize"].ToString();
            lblSize2.Text = dt.Rows[1]["ISize"].ToString();
            lblSize3.Text = dt.Rows[2]["ISize"].ToString();
            lblSize4.Text = dt.Rows[3]["ISize"].ToString();
            lblSize5.Text = dt.Rows[4]["ISize"].ToString();
            lblQuantity1.Text = dt.Rows[0]["Quantity"].ToString();
            lblQuantity2.Text = dt.Rows[1]["Quantity"].ToString();
            lblQuantity3.Text = dt.Rows[2]["Quantity"].ToString();
            lblQuantity4.Text = dt.Rows[3]["Quantity"].ToString();
            lblQuantity5.Text = dt.Rows[4]["Quantity"].ToString();


        }

    }

there is no condition that there should always 5 rows exists, there could be 1 or 2 or 3 or 4 or 5 rows may exists but not more than 5 rows.

when there are 5 rows than this is working fine, but whevever there are rows less than 5 than, suppose there are only 2 rows in table, it shows error "There is no row at position 2." on bolded line

how can I place a check.

and I also wants save these labels's value (which labels are having value) in another table, cos I dont know that how many labels will having value, So how can i write insert query.

let me know pls....

thanks

delete a row from grid view based up on auto generated column.

gorla.naveen — Fri, 27 Nov 2009 03:54:28 GMT

i create a data table dynamically and binded to grid view with auto generate column.Now i want to delete a row from grid view based upon auto generate column.

Please give me the suggestion.it's really breaking my head.

Gridview delete commandfield confirmation

sarathi125 — Thu, 26 Nov 2009 03:31:26 GMT

Hi All,

I developing a web application with a gridview control I used a delete command field in that gridview as the below markups.

I used the text to show a image in it, I need a java script confirmation to delete the record.

<asp:CommandField DeleteText="<img alt='' src='images/delete.gif' />" ShowDeleteButton="True" HeaderText="Delete"></asp:CommandField>

Any idea let me know that.

Thanks in advance......

Filtering GridView based on CheckBoxList

IranianCuriousBoy — Thu, 19 Nov 2009 16:41:09 GMT

I have a CheckBoxList that is bound to the database with a DataSource control. A GridView also is bound with another DataSource control. Is there a way to filter GridView based on what is checked in CheckBoxList control?

Thanks

how to print a PDF file without promting any dialog window?

mezzanine74 — Thu, 26 Nov 2009 09:09:52 GMT

Can you please advise how to print a PDF file without promting any dialog window?

I have many pdf files in different folders. I need a button which will print any specified PDF in a silence by using DEFAULT printer of client computer.

Thanks

Editable grid

Jelmer850i — Wed, 25 Nov 2009 10:35:03 GMT

Hi,

I think this is a stupid question but i still develop my own add, delete etc. tools.
This can be smaterter i guess. Right now i'm using tooo mutch code for developing something easy.

Isn't there a control witch can add items to a table, also delete, and modify it ?
If it looks a bit nice it would be cool.

the code i'm using right now is :

<asp:Repeater ID="repMovieCategories" runat="server"
                    onitemcommand="repMovieCategories_ItemCommand">
                    <HeaderTemplate>
                        <table>
                    </HeaderTemplate>
                    <ItemTemplate>
                        <tr>
                            <td style="width:75px"><asp:LinkButton ID="lnkAanpassen" runat="server" Text="Aanpassen" CommandName="Edit" CommandArgument='<%# Eval("ID") %>'></asp:LinkButton></td>
                            <td style="width:75px"><asp:LinkButton ID="lnkDelete" runat="server" Text="Verwijderen" CommandName="Delete" CommandArgument='<%# Eval("ID") %>' OnClientClick="return confirm('Weet u zeker dat u dit wilt verwijderen?');"></asp:LinkButton></td>
                            <td style="width:400px"><asp:Label ID="lblName" runat="server" Text='<%# Eval("Name") %>'></asp:Label><asp:TextBox ID="txtName" runat="server" Text='<%# Eval("Name") %>' Visible="false"></asp:TextBox></td>
                            <td><asp:LinkButton ID="lnkUpdate" runat="server" Text="Opslaan" Visible="false" CommandName="Update" CommandArgument='<%# Eval("ID") %>'></asp:LinkButton></td>
                        </tr>
                    </ItemTemplate>
                    <AlternatingItemTemplate>
                        <tr>
                            <td style="width:75px"><asp:LinkButton ID="lnkAanpassen" runat="server" Text="Aanpassen" CommandName="Edit" CommandArgument='<%# Eval("ID") %>'></asp:LinkButton></td>
                            <td style="width:75px"><asp:LinkButton ID="lnkDelete" runat="server" Text="Verwijderen" CommandName="Delete" CommandArgument='<%# Eval("ID") %>' OnClientClick="return confirm('Weet u zeker dat u dit wilt verwijderen?');"></asp:LinkButton></td>
                            <td style="width:400px"><asp:Label ID="lblName" runat="server" Text='<%# Eval("Name") %>'></asp:Label><asp:TextBox ID="txtName" runat="server" Text='<%# Eval("Name") %>' Visible="false"></asp:TextBox></td>
                            <td><asp:LinkButton ID="lnkUpdate" runat="server" Text="Opslaan" Visible="false" CommandName="Update" CommandArgument='<%# Eval("ID") %>'></asp:LinkButton></td>
                        </tr>
                    </AlternatingItemTemplate>
                    <FooterTemplate>
                        </table>
                    </FooterTemplate>
                </asp:Repeater>

    protected void repMovieCategories_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        try
        {
            int ID = int.Parse(e.CommandArgument.ToString());

            LinkButton lnkUpdate = (LinkButton)e.Item.FindControl("lnkUpdate");
            Label lblName = (Label)e.Item.FindControl("lblName");
            TextBox txtName = (TextBox)e.Item.FindControl("txtName");

            if (e.CommandName == "Edit")
            {
                tblMovieCategory m = dftv.movies.getMovieCategories().Single(i => i.id == ID);

txtName.Text = m.CategoryName;
lnkUpdate.Visible = true;

                Bind();
            }
            else if (e.CommandName == "Delete")
            {
                dftv.movies.DeleteMovieCategories(ID);

                lnkUpdate.Visible = false;
                txtName.Visible = false;
                lblName.Visible = true;

                Bind();
            }
        }
        catch (Exception ex)
        {
            mailError(ex, lblError);
        }
    }

I hope there is a smart control for it... , it should be free, or not to pricy.

return cell value from gridview when row selected

tcl4p — Fri, 27 Nov 2009 02:37:59 GMT

I added a select button to my gridview to allow me to retrieve a value from a cell when the row is selected. I using the rowcommand event, which fires OK and used the code below to try and get the cell value. What happens is I can get the value if the cell value is a string value, but what I want is to get a cell value from a cell that is not visible and is of the integer type, in this case the ID value from the data row. I've seen reference to the DataKeys property, but can't seem to find it using the intellisence.

Could sure use some help here.

Thanks,
Tom

Protected Sub grdVehicle_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles grdVehicle.RowCommand

Dim s As Integer
        s = e.CommandArgument
        Dim row As GridViewRow = grdVehicle.Rows(s)
        Dim c As String
        c = row.Cells(0).Text

ListView Delete Problems? Solved why delete doesn't work - duh VS2008 code generation...

luappy13 — Mon, 07 Sep 2009 13:04:46 GMT

Okay so I made a datasource (specifically a concurrency enabled ObjectDataSource) and hooked it up to a GridView. Delete, Update works... hunky dory! However....

I then replaced GridView with a ListView based on exactly the same ObjectDataSource - bang! Delete no longer works.

In short - Visual Studio 2008 generates Eval binding statements in the ItemTemplate so when the control tries to set 'Delete' parameter objects for the ObjectDataSource they cannot be populated (Eval = 1 way binding duh!)

To fix: replace eval with bind in ItemTemplate. Surely this cannot be the first time someone has noticed this but couldn't find a direct reference to this problem so thought I'd post.

HTH

Paul

How to add custom user controls to a listview inside another user control?

s_nesh — Wed, 25 Nov 2009 15:43:03 GMT

For a website application i m creating a web form that has a few user controls. At one place i m using a user controls (UC2) within another usercontrol(UC1) to create a particular desgin. UC1 has a button which when clicked adds a new UC2 to it. UC2 has a radio button, a textbox and a button. I want to be able to add input text to the textbox, and check/uncheck the radio button.

Which control to use for displaying this design, A Repeater or a Listview ?
I tried with a listview control (i admit i am not good at data controls) and added Itemtemplates and insertitemtemplates to it. But it did not work. Any help on this woudl be appreciated.

Also FYI i am binding the source control (either a repeater or a lsitview) to a custom collection obejct.

How can i accomplish these tasks?

How to implement paging for GridView when using List as DataSource

dule19_69 — Tue, 24 Nov 2009 15:00:23 GMT

hello guys, this is my question. i already have a .dll in my Bin folder which contains all the logic for getting data from the database and wrapping it into a list of custom business objects (List<CustomBusinessObject>) so i am wondering how to implement the paging, is it possible? thank you in advance

Export sub gridview from rowdatabound to PDF using itextsharp

kabb415 — Wed, 25 Nov 2009 15:19:53 GMT

I am able to export regular gridview to itextsharp PDF format, but unable to create or extract data from the sub grid from the rowdatabound method,

anyone has a solution?

exporting a label value into sql server

ziako — Wed, 25 Nov 2009 15:04:31 GMT

Hi
I have this code in my colde behind file: LoggedInUserLabel.Text = Context.User.Identity.Name

This is the value of a person logged into a system.

I want to take that value of the same person recording an enquiry and export that name into a Sql server database table. The table is called enquires and consists of enquiryid, date and customerid.

The code behind file that exports the person making the enquiry is:

Protected Sub commitChangesButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles commitChangesButton.Click

        Dim connectionString As String = ConfigurationManager.ConnectionStrings("Unlicensed").ConnectionString
        Dim conn As New SqlConnection(connectionString)
        Dim comm As New SqlCommand("INSERT INTO Enquiries (EnquiryId, Date, CustomerID) VALUES (@EnquiryId, @Date, @CustomerId)", conn)

comm.Parameters.Add("@EnquiryID", Data.SqlDbType.VarChar, 50)
comm.Parameters("@EnquiryId").Value = enquiryIdTextBox.Text

comm.Parameters.Add("@Date", Data.SqlDbType.Date)
comm.Parameters("@Date").Value = DateAndTime.Now()

        comm.Parameters.Add("@CustomerId", Data.SqlDbType.VarChar, 50)
        comm.Parameters("@CustomerId").Value = accountIdTextBox.Text
        Try
            conn.Open()
            comm.ExecuteNonQuery()
        Finally
            conn.Close()
        End Try

Dim comm2 As New SqlCommand("copyTableData", conn)

comm2.CommandType = Data.CommandType.StoredProcedure

        comm2.Parameters.Add(New SqlParameter("@AccountId", Data.SqlDbType.VarChar, 50))
        comm2.Parameters("@AccountId").Value = accountIdTextBox.Text
        Try
            conn.Open()
            comm2.ExecuteNonQuery()
        Finally
            conn.Close()
        End Try

        Dim comm3 As New SqlCommand("deleteTempData", conn)
        comm3.CommandType = Data.CommandType.StoredProcedure
        Try
            conn.Open()
            comm3.ExecuteNonQuery()
        Finally
            conn.Close()
        End Try

        accountIdTextBox.Text = ""
        findProductTextBox.Text = ""
        findAccountTextBox.Text = ""
        customerNameTextBox.Text = ""
        customerAddressTextBox.Text = ""
        customerPhoneNumberTextBox.Text = ""

Dim comm4 As New SqlCommand("pullEnquiryId", conn)
Dim enquiryId As Integer

        comm4.CommandType = Data.CommandType.StoredProcedure
        comm4.Parameters.Add("@EnquiryId", Data.SqlDbType.Int)
        comm4.Parameters("@EnquiryId").Direction = Data.ParameterDirection.Output

conn.Open()
comm4.ExecuteNonQuery()

        enquiryId = comm4.Parameters("@EnquiryId").Value
        enquiryIdTextBox.Text = enquiryId
        conn.Close()

Dim returnEnquiryId As Integer = enquiryIdTextBox.Text
returnEnquiryId = (returnEnquiryId + 1)

Label1.Text = returnEnquiryId

Dim comm5 As New SqlCommand("alterEnquiryId", conn)

comm5.CommandType = Data.CommandType.StoredProcedure

        comm5.Parameters.Add(New SqlParameter("@EnquiryId", Data.SqlDbType.Int))
        comm5.Parameters("@EnquiryId").Value = Label1.Text
        conn.Open()
        comm5.ExecuteNonQuery()
        conn.Close()

End Sub

Converting System.Drawing.Image to Server control Image

BJackal — Fri, 27 Nov 2009 00:11:10 GMT

I am trying to access image data from Ms SQL database. Retrive Images are in the form of System.Drawing.Image form how can I display these image in ASPX page. I would appreciate any help.