Solved

DataGrid and CheckBoxes works but cant get each cell info

Posted on 2004-09-12
3
248 Views
Last Modified: 2010-04-15
I am working on the rainbow portal and am able to include checkboxes in my datagrid. I want to dynamically have the checkboxes to put either a tick or stay unchecked depending on my database table.
I have already created a stored procedure and all to get the value from the datatable. But the problem is that i want to feed in some parameters in to the stored procedure at the Page_Load section of the page, and over there, it does not know what the DataGridEventsCommand arguments are..:
 Here is what I mean :

private void Page_Load(object sender, System.EventArgs e)
            {
                  // Put user code to initialize the page here
                  CDesignStoreDB oDS = new CDesignStoreDB();
                  DataGrid1.DataSource = oDS.GetInformation(ModuleID);
                  DataGrid1.DataBind();

                  DataGrid2.DataSource = oDS.GetLoanDetails(ModuleID);
                  DataGrid2.DataBind();

                  CheckBox hasTaken;
                  CheckBox hasReturned;
                  
                  //TableCell itemSN = e.Item.Cells[2]; //IT DOES NOT KNOW WHAT THIS IS
                  //TableCell itemPD = e.Item.Cells[3];//THIS WORKS ELSEWHERE IN EVENTS                                //                                                                             FUNCTIONS
            /*      string PackDescr = itemPD.Text;
                  string StudNo = itemSN.Text;
                  foreach(DataGridItem dgi in this.DataGrid2.Items)
                  {
                        hasTaken = (CheckBox) dgi.Cells[0].Controls[1];
                        
                        string hT = oDS.GetHasTaken(10239, PackDescr, StudNo);
                        if(hT == "YES")
                        {
                              hasTaken.Checked = Convert.ToBoolean(1);
                        }
                  }
            */      
                  if(!IsPostBack)
                  {
                        DataGrid1.DataSource = oDS.GetInformation(ModuleID);
                        DataGrid1.DataBind();

                        DataGrid2.DataSource = oDS.GetLoanDetails(ModuleID);
                        DataGrid2.DataBind();
                  }
            
            }

TableCell itemSN = e.Item.Cells[2]; does not know what 'e' in the context of the datagrid is. So, how can i get the values from the datagrid to assign the strings to them and feed them to the stored procedure function..!!???

Thanks
0
Comment
Question by:saumathur
3 Comments
 
LVL 23

Accepted Solution

by:
rama_krishna580 earned 500 total points
ID: 12037915
0
 

Author Comment

by:saumathur
ID: 12038708
i dont have a webform here, its a web user control, and the datagrid is on that, and even had a look at those pages, still cant work out how to select one particular cell in the datagrid to correspond to the checkbox associated with that row.
0
 

Expert Comment

by:shilpa2784
ID: 12041746
what is the specific row in the datagrid from which you want to take the values and feed to the sp ??
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In order to hide the "ugly" records selectors (triangles) in the rowheaders, here are some suggestions. Microsoft doesn't have a direct method/property to do it. You can only hide the rowheader column. First solution, the easy way The first sol…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question