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 convert Bitmap to a Base64 string?

// Your Bitmap Image Bitmap bImage = newImage; System.IO.MemoryStream ms = new MemoryStream(); bImage.Save(ms, ImageFormat.Jpeg); byte[] byteImage = ms.ToArray(); // Get Base64 var SigBase64= Convert.ToBase64String(byteImage);

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...

ShamsiTech

Search This Blog