GridDataitem retrival issue - ASP.NET Discussion Boards

You have missed the link Big Grin | :-D

What does it mean ' am not able to read the data from the template field '? Did you get any error? exception ?? or anything ? Unless you provide any information how could people help you ?? Laugh | :laugh:

Thanks,
Arindam D Tewary

we have a set of images to be displayed in order so v have put a table and used to specify image inspite of giving proper width height the image is being showed in a very large size that it is very difficult to view.
How to make it fit to our size?
I am giving my coding for reference if any error please tell me

<asp:tablerow id="TableRow9" horizontalalign="Center" verticalalign="Middle" runat="server">
<asp:tablecell id="TableCell10" horizontalalign="Center" verticalalign="Middle" runat="server">

<asp:image id="Image7" runat="server" imagealign="Middle">

If you want to fix the size of image then, there is a Height & Width properties in asp:Image control which you can set like

<asp:image id="Image7" runat="server" height="100px" widht="100px" imagealign="Middle">

Hope the help.

Viral
My Site

Save Our Tigers

Inspite of specifying the height and width it is being seen in a large view that is the problem.

since u suggested i had tried <asp:image id="Image7" runat="server" imagealign="Middle" height="100px" width="100px">
after specifying this the image itself is invisible

thank you for your help It worked

give the height and width of Image control

Hi,
I have an editformtemplate in a grid. The edit form contains 2 radiobuttons along with other controls. During itemdatabound , i convert the values of this column in grid to yes/no. Now on itemdatabound , when the form goes into edit mode i want to get the yes/no value and after converting to true/false want to populate radiobuttons. I am having problem retrieving the Cell data from the grid in edit mode. The exception is:

Telerik.Web.UI.GridNotSupportedException: Item in insert mode does implement indexer only when the edit form is autogenerated at Telerik.Web.UI.GridEditFormInsertItem.get_Item(String columnUniqueName)

Code:

'ItemDatabound code snippet


	Select Case e.Item.ItemType

                    Case Telerik.Web.UI.GridItemType.Item, GridItemType.AlternatingItem

                        Dim item As Telerik.Web.UI.GridDataItem = e.Item
                        'display Yes/No instead of flag 1,0
                        If CType(item("IsNewProduct").Text, Boolean) = False Then
                            item("IsNewProduct").Text = "NO"
                        Else
                            item("IsNewProduct").Text = "YES"
                        End If



                    Case GridItemType.EditFormItem 'inside template edit form 

                        If e.Item.IsInEditMode Then

                            'populate controsl on  template edit form
                            Dim item As Telerik.Web.UI.GridEditableItem = e.Item
                            Dim editFormItem As GridEditFormItem = CType(e.Item, GridEditFormItem)

                            'Below line throws error, i am trying to retrieve yes, no and chose the correct radiobutton accordingly
                            Dim IsNewProductValue As String = CType(item("IsNewProduct").Text, String) 
                           'Exception is : Telerik.Web.UI.GridNotSupportedException: Item in insert mode does implement indexer only
			' when the edit form is autogenerated at Telerik.Web.UI.GridEditFormInsertItem.get_Item(String columnUniqueName)

i have tried setting item as

Dim editFormItem As GridEditFormItem = CType(e.Item, GridEditFormItem)
Dim item As Telerik.Web.UI.GridEditableItem = Ctype(editFormItem.ParentItem,GridDataItem)

but this also didnt work

Please provide help in this regard. Thanks ...

Regards

These looks like a Telerik grid control related issue. Telerik offers forum for helping out developers who have been using their product. You might get a quick work around if you post this query in telerik forum. Try here [http://www.telerik.com/automated-testing-tools/community/forums/aspnet-ajax/grid/accessing-value-in-onitemdatabound-item-in-insert-mode-does-implement-indexer-only-when-the-edit-form-is-autogenerated.aspx]

Thanks,
Arindam D Tewary

Learn Windows Azure at your own pace, in your own time and without travel headaches. Special Windows Azure one week pass (expires 26 April) provided so you can put Windows Azure and SQL Azure through their paces. NO credit card required. You can start the Boot Camp any time during April 19th -26th & work at your own pace. http://blogs.technet.com/webtech/archive/2010/04/16/windows-azure-one-week-virtual-boot-camp.aspx

GoAzure wrote:
Learn Windows Azure at your own pace

How someone is going to learn anything about azure in 1 week, at their own pace ? Confused | :confused:

There are rumors that there will be additional Azure Boot Camps in the near future so if you need more time to learn then get another free token from a future Boot Camp.

Free Windows Azure pass via Virtual Boot Camp III starting May 3rd
After the huge success of the Windows Azure Virtual Boot Camp I and II, here comes…
Virtual Boot Camp III Learn Windows Azure at your own pace, in your own time and without travel headaches.
Windows Azure one week pass is provided so you can put Windows Azure and SQL Azure through their paces.
NO credit card required. You can start the Boot Camp any time during May 3rd and May 10th and work at your own pace.
The Windows Azure virtual boot camp pass is valid from 5am USA PST May 3rd through 6pm USA PST May 10th
More information at http://blogs.technet.com/webtech/archive/2010/04/26/windows-azure-one-week-virtual-boot-camp.aspx

modified on Monday, May 3, 2010 6:22 PM

Hello,

I have written a page that accepts new information and then repopulates the page when a button is clicked. This is a simple task in C#, but seems very complicated in ASP.net. The code seems to work fine on the first click, but the after the first click, the page no longer repopulates. Closer examination reveals that although the values are changed on the page, the actual values held in memory remain the same; ergo, new results are the same as the old. Now...I see that on some controls (such as RadioButton) there is an automatic postback feature, however, I cannot find this for a button. Of course, I am presuming that the Postback is the problem....OR... perhaps it's something else? My preference is not to use javascript, but I of course will if that is the only way. I am still amazed that (after all this time) ASP still has to rely on Javascript for certain features. Any ideas both welcomed and appreciated.

Thank You, Pat

Show us your Page_Load function.

Dave,

Thank you for your reply. I have pasted the Page_Load info below. This page is brought up from a click event on another page's GridView and is supposed to populate information accordingly.

protected void Page_Load(object sender, EventArgs e)
    {
        medDate = CreateMedicalDate(medDate);

        //Load the results for the requested AE

        //Pass the values for the selected AE from the AE Summary Page
        id = Request.QueryString["Id"];
        Screening_Number = Request.QueryString["Screening_Number"];
        Site_Number = Request.QueryString["Site_Number"];
        Version_Id = Request.QueryString["Version_Id"];
        Version = Request.QueryString["Version"];
        AE = Request.QueryString["Ae"];
        Serious = Request.QueryString["Serious"];

        GetLastVersion();

        //Create a new SQL Connection Object
        SqlConnection Conn = new SqlConnection(CONNSTR);

        try
        {
            string Sql = "SELECT [Id],[Period] , [Screening_Number] , [Site_Number] , " +
            "[Version_Id],[Version] , [Ae] , [Frequency] , [Visit] , [VisitNumber] , [Date_Onset] , " +
            "[Ongoing] , [Date_Ended] , [CTCAE] , [Serious] , [Related] , [Action] , [Outcome] , " +
            "[NewConMedsY], [NewConMedsN], [SubBy] , [SubOn] , [Sae_Rpt_Status] " +
            "FROM Adverse_Events WHERE [Version_Id] = @Version_Id AND [Version] = @LastVersion ";

            //Set Command Object Headers
            SqlCommand Comm = new SqlCommand(Sql, Conn);
            Comm.CommandType = CommandType.Text;

            //Comm Paramemters
            Comm.Parameters.Clear();
            Comm.Parameters.AddWithValue("@Version_Id", Version_Id);
            Comm.Parameters.AddWithValue("@LastVersion", lastCompletedVersion);

             //Create a Dataset
            SqlDataAdapter da = new SqlDataAdapter(Comm);
            DataSet ds = new DataSet();
            da.Fill(ds);

            //Send results to the controls 
            LabelPeriod.Text = ds.Tables[0].Rows[0]["Period"].ToString();
            LabelScreeningNumber.Text  = ds.Tables[0].Rows[0]["Screening_Number"].ToString();
            LabelVersion.Text = ds.Tables[0].Rows[0]["Version"].ToString();
            LabelId.Text = ds.Tables[0].Rows[0]["Id"].ToString();
            LabelAe.Text = ds.Tables[0].Rows[0]["Ae"].ToString();
            LabelFrequency.Text = ds.Tables[0].Rows[0]["Frequency"].ToString();
            LabelVisit.Text = ds.Tables[0].Rows[0]["Visit"].ToString();
            LabelVisitNum.Text = ds.Tables[0].Rows[0]["VisitNumber"].ToString();
            LabelDateStarted.Text = ds.Tables[0].Rows[0]["Date_Onset"].ToString();
            LabelOngoing.Text = ds.Tables[0].Rows[0]["Ongoing"].ToString();
            LabelDateStopped.Text = ds.Tables[0].Rows[0]["Date_Ended"].ToString();
            LabelCtcae.Text = ds.Tables[0].Rows[0]["CTCAE"].ToString();
            LabelSerious.Text = ds.Tables[0].Rows[0]["Serious"].ToString();
            LabelRelated.Text = ds.Tables[0].Rows[0]["Related"].ToString();
            LabelAction.Text = ds.Tables[0].Rows[0]["Action"].ToString();
            LabelOutcome.Text = ds.Tables[0].Rows[0]["Outcome"].ToString();
            RadioButtonConMedY.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["NewConMedsY"].ToString());
            RadioButtonConMedN.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["NewConMedsN"].ToString());
            LabelSubBy.Text = Session["Name"].ToString();
            LabelSubOn.Text = medDate;          
            
        }
        catch (Exception ex)  //Catch Errors
        {
            Console.WriteLine("Error : " + ex.Message);
        }

        SetDateDropdownBoxes();

    }

There is a button on the page that is supposed to decrement a value in the LabelVersion label and re run the Sql thereby re populating the page with new information. As I said, it works on the first click, but not afterwards. Thanks for your attention. Best, Pat

And where is the button click event? Without checking for IsPostback all this will do is repopulate the controls from the database and overwrite the value you expect.

I would refactor this code to extract the all the SQL lookup code to a method so It can be called from multiple places in your code. Such as from the PageLoad event and from the button click handler

I know the language. I've read a book. - _Madmatt

Thank you for your help, Mark. Here is the full text:

//The Button Code

protected void ButtonGoBack_Click(object sender, EventArgs e)
{
    LoadPreviousVersion();
}

//The Method Call

private void LoadPreviousVersion()
   {
       //Get requested version and test result
       int requestedVersion = (int.Parse(LabelVersion.Text)) - 1;
       if (requestedVersion < 1)
           requestedVersion = 1;

       //Set Label for new version
       LabelVersion.Text = requestedVersion.ToString();

       //Determine Edit Button availability
       if (int.Parse(LabelVersion.Text) != int.Parse(lastCompletedVersion))
           ButtonEdit.Enabled = false;
       else
           ButtonEdit.Enabled = true;

       //Create Medical Date
       medDate = CreateMedicalDate(medDate);

       //Load the results for the requested AE

       //Create a new SQL Connection Object
       SqlConnection Conn = new SqlConnection(CONNSTR);

       try
       {
           string Sql = "SELECT [Id],[Period] , [Screening_Number] , [Site_Number] , " +
           "[Version_Id],[Version] , [Ae] , [Frequency] , [Visit] , [VisitNumber] , [Date_Onset] , " +
           "[Ongoing] , [Date_Ended] , [CTCAE] , [Serious] , [Related] , [Action] , [Outcome] , " +
           "[NewConMedsY], [NewConMedsN], [SubBy] , [SubOn] , [Sae_Rpt_Status] " +
           "FROM Adverse_Events WHERE [Version_Id] = @Version_Id AND [Version] = @RequestedVersion ";

           //Set Command Object Headers
           SqlCommand Comm = new SqlCommand(Sql, Conn);
           Comm.CommandType = CommandType.Text;

           //Comm Paramemters
           Comm.Parameters.Clear();
           Comm.Parameters.AddWithValue("@Version_Id", Version_Id);
           Comm.Parameters.AddWithValue("@RequestedVersion", requestedVersion);

           //Create a Dataset
           SqlDataAdapter da = new SqlDataAdapter(Comm);
           DataSet ds = new DataSet();
           da.Fill(ds);

           //Send results to the controls
           LabelPeriod.Text = ds.Tables[0].Rows[0]["Period"].ToString();
           LabelScreeningNumber.Text = ds.Tables[0].Rows[0]["Screening_Number"].ToString();
           LabelVersion.Text = ds.Tables[0].Rows[0]["Version"].ToString();
           LabelId.Text = ds.Tables[0].Rows[0]["Id"].ToString();
           LabelAe.Text = ds.Tables[0].Rows[0]["Ae"].ToString();
           LabelFrequency.Text = ds.Tables[0].Rows[0]["Frequency"].ToString();
           LabelVisit.Text = ds.Tables[0].Rows[0]["Visit"].ToString();
           LabelVisitNum.Text = ds.Tables[0].Rows[0]["VisitNumber"].ToString();
           LabelDateStarted.Text = ds.Tables[0].Rows[0]["Date_Onset"].ToString();
           LabelOngoing.Text = ds.Tables[0].Rows[0]["Ongoing"].ToString();
           LabelDateStopped.Text = ds.Tables[0].Rows[0]["Date_Ended"].ToString();
           LabelCtcae.Text = ds.Tables[0].Rows[0]["CTCAE"].ToString();
           LabelSerious.Text = ds.Tables[0].Rows[0]["Serious"].ToString();
           LabelRelated.Text = ds.Tables[0].Rows[0]["Related"].ToString();
           LabelAction.Text = ds.Tables[0].Rows[0]["Action"].ToString();
           LabelOutcome.Text = ds.Tables[0].Rows[0]["Outcome"].ToString();
           RadioButtonConMedY.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["NewConMedsY"].ToString());
           RadioButtonConMedN.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["NewConMedsN"].ToString());
           LabelSubBy.Text = Session["Name"].ToString();
           LabelSubOn.Text = medDate;

       }
       catch (Exception ex)  //Catch Errors
       {
           Console.WriteLine("Error : " + ex.Message);
       }

       //Response.Write("<script>document.forms[0].submit();</script>");

   }

I may be confused, both posts together are the code you are using correct? If so, then as I said, you need to use IsPostBack in the PageLoad event so the controls are not overwritten each time the page is loaded, i.e. during a postback caused by the button click. And again, abstract the database code to a separate method. It will save you a lot of typing and cut & paste errors and debugging.

I know the language. I've read a book. - _Madmatt

Yes,Yes,Yes,Yes....OK....."I SEE" said the blind man. Both you and David were right Mark, and now I GET it. When the page re posts, it is running the load event all over again, and that is overwriting the method so it appears that it is unchanged. I am so sorry that I did not understand. You are both saying the same thing.....it took a moment for it to sink in. THANK YOU both very much. I scripted it a bit different, but it is working now. I will try to mark both answers correct, as they both are. If it is not allowed, I guess I will have to stamp Mark's first only since his was sent first. I greatly appreciate the time and skill from both of you, and I hope you will sign in for me again in the future. Best regards, Pat

PDTUM wrote:
I have written a page that accepts new information and then repopulates the page when a button is clicked. This is a simple task in C#, but seems very complicated in ASP.net. The code seems to work fine on the first click, but the after the first click, the page no longer repopulates.

PDTUM wrote:
This page is brought up from a click event on another page's GridView and is supposed to populate information accordingly.

Well I might be a little confused on exactly which is the first click.
But anyways what you need is code like this ...

protected void Page_Load(object sender, EventArgs e)    {
    if (Page.IsPostBack)
            { 
                LabelVersion label gets deincremented here
            }     

    medDate = CreateMedicalDate(medDate);
        //Load the results for the requested AE
        //Pass the values for the selected AE from the AE Summary Page        
id = Request.QueryString["Id"];
        Screening_Number = Request.QueryString["Screening_Number"];
        Site_Number = Request.QueryString["Site_Number"];

and so on ...

Yes,Yes,Yes,Yes....OK....."I SEE" said the blind man. Both you and Mark were right David, and now I GET it. When the page re posts, it is running the load event all over again, and that is overwriting the method so it appears that it is unchanged. I am so sorry that I did not understand. You are both saying the same thing.....it took a moment for it to sink in. THANK YOU both very much. I scripted it a bit different, but it is working now. I will try to mark both answers correct, as they both are. If it is not allowed, I guess I will have to stamp Mark's first only since his was sent first. I greatly appreciate the time and skill from both of you, and I hope you will sign in for me again in the future. Best regards, Pat

hi, iam using asp.net with c#, with sql server 2000

in my gridview iam displaying data from view at page load event
the 1st column is checkbox in template field,2nd is categorynamee,3rd is itemkey, 4th is itemkeyname
5th is currentqty, 6th is salesprice,7th is quantity, 8th is total

i have to insert into two tables

1st table orders

orderno int primary key autoincrement,

username nvarchar(50) ,

shopname nvarchar(50),

email nvarchar(100)

2nd table is Orderdetails

serialno int primarykey autoincrement,

orderno int foreignkey,

categorynamee nvarchar(50),

itemkey nvarchar(50),

itemkeyname nvarchar(50),

currentqty decimal,

salesprice decimal,

quantity int,

total decimal

when user selects any no of the checkboxes that rows should be added in both tables, iam getting errors

can you give examples which helps me

So at the time of subit, Iterate throgh all the gridview rows and which row has checkbox checked, save it in database.You can save the data in both the table using query.

Where are you actually facing problem?

Cheers!!
Brij
Check my latest Article :Exploring ASP.NET Validators

Easy, your code is wrong - what else do you expect it to be?

Without seeing your code or knowing what errors you are getting someone is meant to help you fix the problem. Can you see where the problem really lies?

Bob
Ashfield Consultants Ltd