How to Place a Checkbox Into a DBGrid

There are numerous ways and reasons to customize the output of a DBGrid in Delphi. One way is to add checkboxes so that the result is more visually attractive. By default, if you have a boolean field in your dataset, the DBGrid displays them as True or False depending on the value of the data field. However, it looks much better if you choose to use a true checkbox control to enable editing the fields. Create a Sample Application Start a new form in Delphi, and place a TDBGrid, TADOTable, and TADOConnection, TDataSource. Leave all the component names as they are when they were first dropped into the form (DBGrid1, ADOQuery1, AdoTable1, etc.). Use the Object Inspector to set a ConnectionString property of the ADOConnection1 component (TADOConnection) to point to the sample QuickiesContest.mdb MS Access database. Connect DBGrid1 to DataSource1, DataSource1 to ADOTable1, and finally ADOTable1 to ADOConnection1. The ADOTable1 TableName property should point to the Articles table (to make the DBGrid display the records of the Articles table). If you have set all the properties correctly, when you run the application (given that the Active property of the ADOTable1 component is True) you should see, by default, the DBGrid display the boolean fields value as True or False depending on the value of the data field. CheckBox in a DBGrid To show a checkbox inside a cell of a DBGrid, well need to make one available for us at run time. Select the Data controls page on the Component Palette and pick a TDBCheckbox. Drop one anywhere on the form - it doesnt matter where, since most of the time it will be invisible or floating over the grid. Tip: TDBCheckBox is a data-aware control that allows the user to select or deselect a single value, which is appropriate for boolean fields. Next, set its Visible property to False. Change the Color property of DBCheckBox1 to the same color as the DBGrid (so it blends in with the DBGrid) and remove the Caption. Most importantly, make sure the DBCheckBox1 is connected to the DataSource1 and to the correct field. Note that all the above DBCheckBox1s property values can be set in the forms OnCreate event like this: procedure TForm1.FormCreate(Sender: TObject);begin DBCheckBox1.DataSource : DataSource1; DBCheckBox1.DataField : Winner; DBCheckBox1.Visible : False; DBCheckBox1.Color : DBGrid1.Color; DBCheckBox1.Caption : ; //explained later in the article DBCheckBox1.ValueChecked : Yes a Winner!; DBCheckBox1.ValueUnChecked : Not this time.; end; What comes next is the most interesting part. While editing the boolean field in the DBGrid, we need to make sure the DBCheckBox1 is placed above (floating) the cell in the DBGrid displaying the boolean field. For the rest of the (non-focused) cells carrying the boolean fields (in the Winner column), we need to provide some graphical representation of the boolean value (True/False). This means you need at least two images for drawing: one for the checked state (True value) and one for the unchecked state (False value). The easiest way to accomplish this is to use the Windows API DrawFrameControl function to draw directly on the DBGrids canvas. Heres the code in the DBGrids OnDrawColumnCell event handler that occurs when the grid needs to paint a cell. procedure TForm1.DBGrid1DrawColumnCell( Sender: TObject; const Rect: TRect; DataCol: Integer; Column: TColumn; State: TGridDrawState); const IsChecked : array[Boolean] of Integer (DFCS_BUTTONCHECK, DFCS_BUTTONCHECK or DFCS_CHECKED);var DrawState: Integer; DrawRect: TRect;beginif (gdFocused in State) thenbeginif (Column.Field.FieldName DBCheckBox1.DataField) thenbegin DBCheckBox1.Left : Rect.Left DBGrid1.Left 2; DBCheckBox1.Top : Rect.Top DBGrid1.top 2; DBCheckBox1.Width : Rect.Right - Rect.Left; DBCheckBox1.Height : Rect.Bottom - Rect.Top; DBCheckBox1.Visible : True; endendelsebeginif (Column.Field.FieldName DBCheckBox1.DataField) thenbegin DrawRect:Rect; InflateRect(DrawRect,-1,-1); DrawState : ISChecked[Column.Field.AsBoolean]; DBGrid1.Canvas.FillRect(Rect); DrawFrameControl(DBGrid1.Canvas.Handle, DrawRect, DFC_BUTTON, DrawState); end; end; end; To finish this step, we need to make sure DBCheckBox1 is invisible when we leave the cell: procedure TForm1.DBGrid1ColExit(Sender: TObject);beginif DBGrid1.SelectedField.FieldName DBCheckBox1.DataField then DBCheckBox1.Visible : Falseend; We need just two more events to handle. Note that when in editing mode, all keystrokes are going to the DBGrids cell, we have to make sure they are sent to the CheckBox. In the case of a CheckBox we are primarily interested in the [Tab] and the [Space] key. [Tab] should move the input focus to the next cell, and [Space] should toggle the state of the CheckBox. procedure TForm1.DBGrid1KeyPress(Sender: TObject; var Key: Char);beginif (key Chr(9)) then Exit; if (DBGrid1.SelectedField.FieldName DBCheckBox1.DataField) thenbegin DBCheckBox1.SetFocus; SendMessage(DBCheckBox1.Handle, WM_Char, word(Key), 0); end;end; It could be appropriate for the Caption of the checkbox to change as the user checks or unchecks the box. Note that the DBCheckBox has two properties (ValueChecked and ValueUnChecked) used to specify the field value represented by the checkbox when it is checked or unchecked. This ValueChecked property holds Yes, a Winner!, and ValueUnChecked equals Not this time. procedure TForm1.DBCheckBox1Click(Sender: TObject);beginif DBCheckBox1.Checked then DBCheckBox1.Caption : DBCheckBox1.ValueChecked else DBCheckBox1.Caption : DBCheckBox1.ValueUnChecked;end; Run the project and youll see the checkboxes all over the Winner fields column.

Baseball And The American Civil War Essay - 2363 Words

Baseball, a game played between two teams of nine on a field with a diamond-shaped series of four bases. A prestige and unique game that is played all over the world but most beloved in the United States, hence, why people refer to it as the national pastime due to its tradition and popularity. Baseball consists of many complex rules and an extended history. In order for one to fall in love with the game such as America has, one must understand the rules and history of baseball. Baseball originates back to 1800s, from a man named Abner Doubleday, who was a Union Officer during the American Civil War. Some say he invented the game in Cooperstown, New York, in 1839. There’s limited amount of information and facts on Doubleday being the original creator of the game. A more accurate response to the question of how baseball originates would be that many scholars believe that baseball was invented way before we can tell. In ancient cultures, such as those of the Persians and Egyptians, there is evidence of games being played with balls and sticks. Games similar to baseball continued to be played by civilizations throughout history but it was not until the early 1600s that Europeans first brought games involving a ball and a stick to the Americas. There were a number of various games played with a ball and a stick but the one that most resembled baseball was an English game called Rounders. The rules of Rounders are a lot simpler than the ones of modern day baseball but it was fromShow MoreRelatedBaseball And The American Civil War999 Words   |  4 Pagespolicy of Manifest Destiny (Iber et al., 2011). Latin America’s passion of baseball allegedly began at the end of the American Civil War and just before Cuba’s struggle for independence recognized as the Ten Years War from 1868 through 1878 (Arbena, 2011). According to Regalado (1987), this collective memory started when American sailors, who were stationed in Havana, persuaded a few local Cubans to take part in a game of baseball. Other scholars cite Cuban upper-class students such as Esteban BellanRead MoreWhy Baseball Is The National Pastime937 Words   |  4 Pagesenjoyment rather than for work. The Civil War soldiers are strong examples as to why baseball is the national pastime. The nervous anticipation that grips a solider as they prepare for battle. Their job consists of tasks that if performed incorrectly could result in fatalities. It is hard to imagine that an individual could block out the death and suffering that goes along with the job of being a civil war solider. This is why the stories of solider using baseball as a recreational pastime are amazingRead MoreA Brief History of America’s National Pastime679 Words   |  3 Pages19th Century Baseball website, author Eric Miklich writes that America’s pastime may have originated in Canada. Miklich tells the story of Dr. Adam E. Ford who wrote a letter about a game which had been played in 1838 which was described to have several key differences than baseball. Many people believe that baseball evolved from games played in England- mainly cricket and rounders. Others believe the German game of town ball is where it all started. October 6, 1845 was the first baseball game on recordRead More316 (4-5). Ms. Matthews . English Iv. 24 April 2017 . How1096 Words   |  5 Pages2017 How Baseball Changed Over Time Baseball changed over time when African Americans were able to join the game of baseball in the early 1840s when the game of baseball started. Only African American were able to play the game of baseball due to segregation. Most people did not even want African Americans to play baseball in the MLB they could have their own league but,not with whites because no blacks were allowed to communicate with them. Alexander Cartwright invented the game of baseball and theRead MoreJackie Robinson And The American Dilemma882 Words   |  4 PagesIn the biography Jackie Robinson and the American Dilemma by John R. M. Wilson, it tells the story of racial injustice done after world war II and explains how Jackie Robinson was pioneer of better race relations in the United States. The obstacles Jackie Robinson overcame were amazing, he had the responsibility to convert the institutions, customs, and attitudes that had defined race relations in the United States. Seldom has history ever placed so m uch of a strain on one person. I am addressingRead MoreAmerica s Favorite Pastime And Jackie Robinson Essay1661 Words   |  7 PagesAmerica’s Favorite Pastime and Jackie Robinson The game of baseball has been intertwined in our history. It has been there through the wars and the civil rights movements. The game has seen it all. There have been great players who have put their career’s on hold to fight for their country. â€Å"More than 500 major league baseball players during World War II, including stars like Ted Williams, Stan Musial and Joe DiMaggio†. There is one player that didn’t have to put his career on hold to fight for hisRead MoreCivil Rights Movement : Jackie Robinson1477 Words   |  6 PagesCivil rights was an important American issue through the late 40s through the 60s. During this time period Baseball was â€Å"America’s Pastime, â€Å"and a major social get together for white Americans. However in 1947 both of these event were combined when the Brooklyn Dodgers gave Jackie Robinson a chance to play professional baseball. Jackie Robinson is the target of my biography. Robinson not only was the first African Amer ican baseball player, but he also had a hall of fame career, and eventually hadRead MoreJim Crow Laws For African Americans From Performing The Same Daily Activities1704 Words   |  7 PagesJim Crow laws prevented African-Americans from performing the same daily activities as whites did. Some of these activities included African-Americans not being able to use the same bathrooms, entrances, or water fountains as whites. Jim Crow laws had a large impact on baseball. African-Americans were not able to play in Major League Baseball. Because of this many all black baseball teams were formed. These teams eventually led to the formation of many negro baseball leagues throughout the United StatesRead MoreEssay on Baseball613 Words   |  3 PagesBaseball As I sat and watched the college world series this weekend I began to wonder about baseball and several questions came to mind: where did we get the game of baseball? Who should we give credit to for the formation of the game we see today? How has it withstood the tests of wartime? And what helped this game thrive to what it is today, the nation’s pastime? Baseball grew out of various ball and stick games that had been played throughout the United States during the first halfRead MoreEssay on A Brief History of America’s National Pastime1708 Words   |  7 PagesYankees were up two games to none on the Chicago Cubs. In the fifth inning, with the score tied four-four, many of the nearly 50,000 fans, and even players in the Chicago dugout, began taunting and heckling the batter. What happened next went down in baseball history as one of the most famous and controversial at-bats. The batter was none other than Babe Ruth, who, with two strikes and two balls, stepped out of the batters box and gestured toward the outfield as if to show where he was going to hit the

Understanding Customer Relations for Optus Pty. Ltd -myassignmenthelp

Question: Discuss about theUnderstanding Customer Relations for Optus Pty. Ltd. Answer: Introduction The kings of the market are the customers and hence developing relation with them has been considered as one of the empirical task for any of the business organization. Establishing and enhancing relations with the customers will be proven beneficial for the business entity on various grounds. In simple terms, the concept of CRM (customer relationship management) has been referred to the tools, mechanisms, practices and procedures adopted by the business enterprises for interacting and analyzing the data of the customers throughout the customer lifecycle. The prime objective of this mechanism is enhancing the services offered to the customers and thus driving desired outcomes (Fitzgerald, Kruschwitz, Bonnet and Welch, 2014). In todays era, every organisation needs a digital technology to promote its services and products and enhances the visibility of an organisation. These tools enhance customers behaviour by improving their experiences and building trust among customers. The below presented report analyses the use of digital technology, social media and websites for advancing the CRM and also the relationships with the customers of the Optus Pty. Ltd is second largest telecommunication brand name in Australia. Use digital technologies for enhancing the visibility Organisation use digital technology to enhance the visibility by using apps, websites or social media platforms. Digital technology helps an organisation to reach to wider audience and learn more about the competitors market. These technologies are also used to promote the goods by launching new programs to reach to larger customers and gain branding. Digital marketing is an easy tool or better marketing and creating awareness among the audience. It impacts the customer behaviour by boosting customer experience. It helps in building loyal customers that improves customer engagement (Sia, Soh and Weill, 2016). These tools help an organisation to design plans accordingly to the competitors. Numerous digital technologies are available but focusing on social media platforms to develop customer relationship management. Social media platform touches every door of customers. For business perception social media helps in making good profit by showcasing the products online. Social media plat forms also allow users to give feedback so that improvement can be made. Social media is a cost effective approach as marketing plans are designed according to the customers interest (Matt, Hess and Benlian, 2015). Products and services are advertised on social media platforms, as everyone is present on the social media sites so that they will become aware about the services. Optus Pty. Ltd use these digital technologies to improve its services by gaining responsible growth in the society. They promote their services for economic growth and have beaten their competitors in the market. As Optus has started developing new digital products and services by providing new ways to people for communicating the information. For example, previously things which were done are now done electronically (Barrett, Davidson, Prabhu and Vargo, 2015). Optus use various digital technologies for exploring the products digitally. They develop products and services using mobile devices by suitable applications. The digital portfolio of the company is also available that covers all the cloud based services available like online storage and backup plans. They have effective digital services available which enable them to take proper backups. They offer their services on any device may be mobile phones or computers. The business organizations have a need of to evolve for addressing the changing business trends and landscapes (Barrett, Davidson, Prabhu and Vargo, 2015). And generally, making expenses on IT has been considered as the fulfilment of one of the basic and prime requirement for any of the business corporations and same is with Optus. As Optus is a telecommunication brand the digital platform will be proven advantageous on various grounds. Digital transformation has been defined as the methodology in which the business corporations transform and develop business models, and cultures by utilizing digital technologies. The below presented are some of the advantages that will be attained by Optus in terms of enhancing customer relation by adopting digital technology: Empower employees to work better, smarter and faster One of the basic needs for any of the business organization is that the employees should work smarter, faster and better and this is to be done for attaining the expected goals. And this is made possible by providing them with innovative solutions for interacting collaborating and exchanging data without any restrictions (Fitzgerald, Kruschwitz, Bonnet and Welch, 2014). Being innovative worker will be leading the employees towards advancements in their performance and productivity and delivery of services. Better performance and delivery of services within Optus will tend to bring an enhancement in the services offered and establishment of strong bonds will also be made possible. The below presented are some of the methodologies through which the digital technology will be advancing the customer relations within Optus: The objective of Optus in terms of customers relations management is creating steadfastness. There's no preferable method to do that over to offer quality items and benefits and to be receptive to the clients. Be that as it may, as new innovations have come to market to make it less demanding for organizations to give client benefit, they may likewise be expanding the quantity of channels through which the workers cooperate with clients and the multifaceted nature of those connections (Valentine and Stewart, 2015). Accenture, the innovation counselling firm, recommends that organizations that need to utilize innovation to raise the nature of their client benefit centre around the accompanying: Data administration and examination: Utilizing information gathered from client to break down their inclinations. Insight-driven advertising: Picking up bits of knowledge into your business from client information so you would more be able to successfully target showcasing. Marketing computerization. Streamlining and robotizing business procedures to enhance proficiency and minimize expenses (Straker, Wrigley and Rosemann, 2015). Self-benefit advancement: Discovering routes for clients to associate with your business when they need. Workforce viability: Urging your staff to grasp new ways enhancing client treatment by giving apparatuses and preparing to convey better administration. Optus maintains the customer relationship management by serving the products that meet the expectations of customers by delivering the services in a way that long term trust is built. As for Optus customers satisfaction is the major concern (Rodriguez, Peterson and Ajjan, 2015). They maintain the relation by keeping them in touch and introducing new ideas to beat the challengers serving the same products. Moreover, there are some prime areas in which the digital technology will be providing advantages to the business corporations in engendering customer loyalty by advancing the customer services: Websites: Optus Pty. Ltd should provide feedbacks and also allowing ground and space to the customer where they are able to revert and give their opinions freely and seek answers from others will be proven a significant step in developing relations with the customers (Jaber and Simkin, 2017). Emails: Making use of emails for regular interactions with the customers, replying on their queries and acknowledging their feedbacks will be proven an advantageous step for Optus in terms of developing and advancing relations with the customers. Communications: Amalgamating communications will be proven beneficial for the entity as in case if the customers have sent a voice note with the email few days ago. Use of social media for advancing customer value and experience, building customer loyalty Considering social media platforms like Facebook and twitter, they are used for promoting services delivered by Optus as these sites are easy to use and have engaged audience of every kind. Facebook can be considered as the most active social media platform because majority of population is active on Facebook all day long (Palacios, Pealvo, Stantchev and Misra, 2017). Other than that twitter is also useful as it engages customers by simply posting services and gaining interest from audience. These channels are beneficial for Optus to gain more customers. Digital marketing can be treated as a best marketing channel for engaging new customer or keeping the old customers stable. Social media marketing helps in expanding the business by providing various facilities through promotion. Optus being a telecommunication company helps in nurturing the customer relationship by promoting the services and offers in the section where wider audience are present. The business organization focuses on keeping the customers stable and for a longer run this is attained by posting the offers on regular basis (Mozaheb, Alamolhodaei and Ardakani, 2015). This helps in pitching the customers by actually providing what they want. Moreover, social media plays a significant role in increasing and driving the value and experience of the customers (Kaur, 2016). Driven by innovation, the client journey has been considered not any more consecutive. It's hard to achieve clients given the quantity of channels accessible to them on the web. The sheer volume of messages went for leaders makes it trying to emerge among contenders and a since quite a while ago, divided purchasing venture makes it hard to remain best of brain. Basically, the purchaser is presently in full control (Kumar, 2015). Social media will offer Optus the capacity to affect a client's choices and conduct at each phase of the purchasing venture, so it's nothing unexpected that social is turning into a favoured channel for organizations around the globe. As per Hootsuite and We Are Social's recent Digital in 2018 report, worldwide online networking use has expanded by 13% over the most recent a year, achieving 3.2 billion clients (Maven 2018). This implies 80% of the world's web clients are likewise dynamic online networking clients. This dynamic has perpetually adjusted the client travel as customers and B2B experts progressively lead explore, settle on purchasing choices, look for help, and suggest marks on social. One of the biggest and empirical organizational goal of any of the business firm is not only creating customer satisfaction but also developing and generating customer value. There are some factors or elements that can be provided by Optus for offering and increasing customer value: Quality products and services Value pricing Unique and differential services and products Offering a feeling of belongingness and togetherness by making them feel that they are part of the firm or are a part of the group (Nair, Khasgiwala, Mishra and Student, 2016). Social media has been considered as a supporting marketing strategy that can be adopted by the business corporation for increasing the customer value. Social media can be an integral element a supportive marketing strategy and communication channel for spreading information about the features and characteristics of the products and services (Josiassen, Assaf and Cvelbar, 2014). It has been observed that the customer largely trusts and depends on the opinions posted on the social networks and platforms as compared to the commercial messages. This as a whole will also lead the customer to show their repeat intention and will result in an increase in the customer loyalty. Implications of digital technology tools for systems and processes and strategic customer management Digital technology has been proven as a revolutionary concept and has provided the business environment with varied range of advantages. One of the prime benefits of the making adoption of this mechanism is proper management and advancement of the customer relationship (Dar and Ahmad, 2015). Optus one of the leading brand names in the sector of telecommunication and for attaining high peaks of success and growth implementation of digital technology will be proven an effective step towards advancing the relations with customers. Moreover, making use of other mechanisms and tools of digital technology such as e-mails, social media will also aid the entity in enhancing the relations with the customers all over the globe. Conclusion In the limelight of the above executed analysis it has been inferred that making use of digital technology for enhancing the customer relations and increasing their value and experience will be proven an advantageous step. Optus a telecommunication brand in Australia needs to make adoption of digital technological tools for developing CRM. Bibliography Barrett, M., Davidson, E., Prabhu, J. and Vargo, S.L. (2015) Service innovation in the digital age: key contributions and future directions. MIS quarterly, 39(1), pp.135-154. Colomo-Palacios, R., Garca-Pealvo, F.J., Stantchev, V. and Misra, S. (2017) Towards a social and context-aware mobile recommendation system for tourism. Pervasive and Mobile Computing, 38, pp.505-515. Dar, W.M. and Ahmad, M. (2015) Impact of Customer Relationship Management Capabilities on Organizational Performance with CRM Technology as Mediator. Arabian Journal of Business and Management Review (Oman Chapter), 4(10), p.30. Josiassen, A., Assaf, A.G. and Cvelbar, L.K. (2014) CRM and the bottom line: Do all CRM dimensions affect firm performance?. International Journal of Hospitality Management, 36, pp.130-136. Fitzgerald, M., Kruschwitz, N., Bonnet, D. and Welch, M. (2014) Embracing digital technology: A new strategic imperative. MIT sloan management review, 55(2), p.1. Jaber, F. and Simkin, L. (2017) Unpicking antecedents of CRM adoption: a two-stage model. Journal of Strategic Marketing, 25(5-6), pp.475-494. Kaur, S. (2016) Importance of Customer Relationship Management (CRM) in the Indian banking Sector. Imperial Journal of Interdisciplinary Research, 2(12). Kumar, V. (2015) Customer relationship management (CRM) in services companies. International Research journal of Management Sociology Humanities, 6, pp.521-525. Matt, C., Hess, T. and Benlian, A. (2015) Digital transformation strategies. Business Information Systems Engineering, 57(5), pp.339-343. Maven, M. (2018) Marketings role in driving customer value through social media [Online]. Available from: https://www.martechadvisor.com/articles/social-media-marketing-2/marketings-role-in-driving-customer-value-through-social-media-2/ [Accessed on 12th April 2018]. Mozaheb, A., Alamolhodaei, S.M.A. and Ardakani, M.F. (2015) Effect of customer relationship management (CRM) on performance of small-medium sized enterprises (SMEs) using structural equations model (SEM). International Journal of Academic Research in Accounting, Finance and Management Sciences, 5(2), pp.42-52. Nair, A., Khasgiwala, R., Mishra, S. and Student, S.S. (2016) Improving Customer Relationship Management Using Data Mining. International Journal of Scientific Engineering Research, 7(2). Rodriguez, M., Peterson, R.M. and Ajjan, H. (2015) CRM/social media technology: impact on customer orientation process and organizational sales performance. In Ideas in Marketing: Finding the New and Polishing the Old (pp. 636-638). Germany: Springer, Cham. Sia, S.K., Soh, C. and Weill, P. (2016) How DBS Bank Pursued a Digital Business Strategy. MIS Quarterly Executive, 15(2). Straker, K., Wrigley, C. and Rosemann, M. (2015) The role of design in the future of digital channels: Conceptual insights and future research directions. Journal of Retailing and Consumer Services, 26, pp.133-140. Valentine, E. and Stewart, G. (2015) January. Enterprise Business Technology Governance: Three competencies to build board digital leadership capability. In System Sciences (HICSS), 2015 48th Hawaii International Conference on (pp. 4513-4522). IEEE.