Create gridview from Codebehind (C#)

-
Create gridview from C# with boundfields


BFixturePlayer obj = new BFixturePlayer();
                                    obj.FixtureKey = int.Parse(DR["Fixture_Key"].ToString());
                                    DataTable dt = obj.TeamSheet_SelectTeamPlayers();
                                    if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
                                    {
                                        HtmlGenericControl fieldSet = new HtmlGenericControl("fieldset");
                                        HtmlGenericControl legend = new HtmlGenericControl("legend");
                                        fieldSet.Controls.Add(legend);
                                        fieldSet.Style.Add("border-color", "000000");
                                        fieldSet.Style.Add("border-top-left-radius", "5px");
                                        fieldSet.Style.Add("border-top-right-radius", "5px");
                                        fieldSet.Style.Add("padding", "5px");
                                        fieldSet.Style.Add("height", "auto");
                                        fieldSet.Style.Add("border-style", "solid");
                                        fieldSet.Style.Add("border-width", "1px");
                                        legend.Style.Add("text-align", "left");
                                        legend.Style.Add("font-weight", "bold");
                                        legend.Style.Add("font-color", "#639b31");
                                        //legend.Style.Add("display", "inline");
                                        //legend.Style.Add("position", "relative");

                                        GridView dgTeamSheet = new GridView();
                                        dgTeamSheet.AutoGenerateColumns = false;
                                        dgTeamSheet.EmptyDataText = "No records to display";
                                        dgTeamSheet.ShowHeader = true;
                                        dgTeamSheet.ShowHeaderWhenEmpty = true;
                                        BoundField SNo = new BoundField();
                                        SNo.HeaderText = "Sl.NO";
                                        //SNo.DataField = "";
                                        dgTeamSheet.Columns.Add(SNo);

                                        TemplateField tmfmemberimg = new TemplateField();
                                        tmfmemberimg.HeaderText = "";
                                        tmfmemberimg.ItemTemplate = new ImageColumn();
                                        dgTeamSheet.Columns.Add(tmfmemberimg);
                                        BoundField MName = new BoundField();
                                        MName.HeaderText = "Member Name";
                                        MName.DataField = "Member_Name";
                                        dgTeamSheet.Columns.Add(MName);

                                        TemplateField tmfresponseimg = new TemplateField();
                                        tmfresponseimg.HeaderText = "Response";
                                        tmfresponseimg.ItemTemplate = new ResponseColumn();
                                        dgTeamSheet.Columns.Add(tmfresponseimg);


                                        Table tbl = new Table();
                                        TableRow venuerow = new TableRow();
                                        TableCell tcv1 = new TableCell();
                                        tcv1.Text = "Venue:";
                                        TableCell venuecell = new TableCell();
                                        venuerow.Cells.Add(tcv1);
                                        venuerow.Cells.Add(venuecell);
                                        tbl.Rows.Add(venuerow);

                                        TableRow row1 = new TableRow();
                                        TableCell tc11 = new TableCell();
                                        tc11.Text = "Umpire:";
                                        TableCell umpirecell = new TableCell();
                                        row1.Cells.Add(tc11);
                                        row1.Cells.Add(umpirecell);
                                        tbl.Rows.Add(row1);

                                        TableRow row2 = new TableRow();
                                        TableCell tc21 = new TableCell();
                                        tc21.Text = "Scorer:";
                                        TableCell scorercell = new TableCell();
                                        row2.Cells.Add(tc21);
                                        row2.Cells.Add(scorercell);
                                        tbl.Rows.Add(row2);
                                        TableRow row3 = new TableRow();
                                        TableCell tc31 = new TableCell();
                                        tc31.Text = "Start Time:";
                                        TableCell starttimecell = new TableCell();
                                        row3.Cells.Add(tc31);
                                        row3.Cells.Add(starttimecell);
                                        tbl.Rows.Add(row3);
                                        TableRow row4 = new TableRow();
                                        TableCell tc41 = new TableCell();
                                        tc41.Text = "Meet Details:";
                                        TableCell meetdetailscell = new TableCell();
                                        row4.Cells.Add(tc41);
                                        row4.Cells.Add(meetdetailscell);
                                        tbl.Rows.Add(row4);
                                        TableRow row5 = new TableRow();
                                        TableCell tc51 = new TableCell();
                                        tc51.Text = "Notes :";
                                        TableCell notescell = new TableCell();
                                        row5.Cells.Add(tc51);
                                        row5.Cells.Add(notescell);
                                        tbl.Rows.Add(row5);
                                        BFixture objFixture = new BFixture();
                                        objFixture.FixtureKey = int.Parse(DR["Fixture_Key"].ToString());
                                        objFixture.Fill();
                                        if (objFixture.home)
                                        {
                                            venuecell.Text = "Home";
                                        }
                                        else
                                        {
                                            venuecell.Text = objFixture.AwayLocation;
                                        }

                                        umpirecell.Text = objFixture.Umpire;
                                        scorercell.Text = objFixture.Scorer;
                                        starttimecell.Text = objFixture.FixtureTime;
                                        meetdetailscell.Text = objFixture.MeetTime;
                                        notescell.Text = objFixture.Notes;
                                        legend.InnerText = Convert.ToDateTime(objFixture.FixtureDate).ToString("dd-MMM-yyyy") + ": " + objFixture.TeamName + " " + "Teamsheet";

                                        dgTeamSheet.DataKeyNames = new string[] { "Member_Key", "Member_Name" };
                                        dgTeamSheet.RowDataBound += new GridViewRowEventHandler(dgTeamSheet_RowDataBound);
                                        dgTeamSheet.DataBound += new EventHandler(dgTeamSheet_DataBound);
                                        dgTeamSheet.RowCommand += new GridViewCommandEventHandler(dgTeamSheet_RowCommand);
                                        dgTeamSheet.DataSource = dt;
                                        dgTeamSheet.DataBind();

                                        fieldSet.Controls.Add(dgTeamSheet);
                                        fieldSet.Controls.Add(tbl);
                                        ph.Controls.Add(fieldSet);

Comments

Post a Comment

Popular posts from this blog

WCF interview questions

-
Windows Communication Foundation is... Some Important points I have collected from MSDN site are: A part of the .NET Framework that provides a unified programming model for rapidly building service-oriented applications that communicate across the web and the enterprise. The global acceptance of Web services, which includes standard protocols for application-to-application communication, has changed software development. For example, the functions that Web services now provide include security, distributed transaction coordination, and reliable communication. The benefits of the changes in Web services should be reflected in the tools and technologies that developers use. Windows Communication Foundation (WCF) is designed to offer a manageable approach to distributed computing, broad interoperability, and direct support for service orientation. WCF simplifies development of connected applications through a new service-oriented programming model. WCF supports many styles of...
Read more

The term 'Connect-MsolService' is not recognized as the name of a cmdlet, function, script file, or operable program

-
Following worked for me: Uninstall the previously installed ‘Microsoft Online Service Sign-in Assistant’ and ‘Windows Azure Active Directory Module for Windows PowerShell’. Install 64-bit versions of ‘Microsoft Online Service Sign-in Assistant’ and ‘Windows Azure Active Directory Module for Windows PowerShell’. https://littletalk.wordpress.com/2013/09/23/install-and-configure-the-office-365-powershell-cmdlets/ If you get the following error  In order to install Windows Azure Active Directory Module for Windows PowerShell, you must have Microsoft Online Services Sign-In Assistant version 7.0 or greater installed on this computer , then install the Microsoft Online Services Sign-In Assistant for IT Professionals BETA:  http://www.microsoft.com/en-us/download/details.aspx?id=39267 Copy the folders called MSOnline and MSOnline Extended from the source C:\Windows\System32\WindowsPowerShell\v1.0\Modules\ to the folder C:\Windows\SysWOW64\WindowsPowerShell\v1.0...
Read more

what is Event Cache table in sharepoint

-
Every Content database in SharePoint Contains an EventCache table that is the change log for objects contained in the database. Each row in this table is depicting a change in an object where columns usually contain information such as the date and time of a change, the type of object that was changed, the nature of the change, and a unique identifier for the object. EventCache table is important because it stores the list of site events for which users might have requested alerts.
Read more