SQL SERVER – Find Row Count in Table – Find Largest Table in Database

Select a.Name as TblName,Sum(b.Rows) as RowsCount from Sys.Tables as a,Sys.Partitions as b where a.Object_Id=b.Object_Id Group By a.Name Order By Sum(Rows) Desc

Comments

Working With a Binding Navigator Control in Windows Forms

Definition : BindingNavigator control Provide user interface with a simple data navigation and manipulation on the form . it is used for Binding the Database Tables values to the control (Datagridview,Text Box, label etc.). BindingNavigator with the BindingSource enable users to move through data records on a form and interact with the records. There are few buttons in binding Navigator listed below: 1. Move First--------------- à Go first record of the table 2. Move Next--------------- à Go Next record of the table with respect to current record. 3. Move Previous---------- à Go previous record of the table. 4. Move Last---------------- à Go Last record of the table. 5. Delete---------------------- à Delete selected row (record). 6. Add New-------------------- à Add New Row. 7. ...

How to Pass Data from one Form to other Form in windows Form Application C#

Introduction: Hi Guys! In this tutorial we learn how to pass data from one form to other form in windows form application using c#. Let’s Follow the Step and create windows form application. Step1: Visual studio- à File- à New- à Project à windows Form Application- à Ok Step2: Click on ToolBox- à Drag and drop Label and TextBox. I creat a Form with 3 Labels and TextBox as shown in fig. Step 3: I have Name,Fname,Address Label on Form .so I take a three global variable .Write this code on the Form1.cs public static string SetValueForText1 = "" ; public static string SetValueForText2 = "" ; public static string SetValueForText3 = "" ; Step4: Project- à Add Windows Form- à Click on Add Step 5: After Creating Form Double Click on Submit button on windows Form1 and Write the Cod...

Autocomplete TextBox in Windows Form Application using SQL Server

Autocomplete TextBox in Windows Form Application using SQL Server. In this article we Lear how to create autocompelete textbox on the basis of sql server data. Step 1: First open visual Studio ---->File---->New---->Project----->Windows From Application---->Ok Drag and Drop label and TextBox. Step 2: Now Double Click on Windows Form and write the following Code : SqlConnection con = new SqlConnection ( @"Data Source=IS9;Initial Catalog=practice;User ID=sa;Password=abc" ); public void loadData() { con.Open(); AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection (); ...

ShamsiTech

Search This Blog