Get All Details from Database and tables with rows and Db size

SET NOCOUNT ON 

DBCC UPDATEUSAGE(0)

--Check DB size.

EXEC sp_spaceused

-- Table row counts and sizes.

CREATE TABLE #Temptable

(

    [name] NVARCHAR(128),

    [rows] CHAR(11),

    reserved VARCHAR(18),

    data VARCHAR(18),

    index_size VARCHAR(18),

    unused VARCHAR(18)

)

INSERT # Temptable EXEC sp_msForEachTable 'EXEC sp_spaceused ''?'''

-- # select data from table

SELECT * FROM  # Temptable

-- # Count tatal rows

SELECT SUM(CAST([rows] AS int)) AS [rows]FROM   # Temptable

-- # Drop Temp Table

DROP TABLE # Temptable

Check Table fields size and Data_types in sql server 2008r2 Table Wise (All tables of selected database)

//sql query

select TABLE_NAME, SUM(

 case

when DATA_TYPE='float' then 8

when DATA_TYPE='int'  then 8

when DATA_TYPE='datetime'  then 8

when DATA_TYPE='real'  then 4

when DATA_TYPE='decimal'  then 8

when DATA_TYPE='bigint'  then 8

when DATA_TYPE='smallint'  then 8

when DATA_TYPE='tinyint'  then 8

when DATA_TYPE='char'  then CHARACTER_MAXIMUM_LENGTH*1

when DATA_TYPE='bit'  then 1

when DATA_TYPE='nchar'  then CHARACTER_MAXIMUM_LENGTH*2

when DATA_TYPE='varchar'  then CHARACTER_MAXIMUM_LENGTH*2

else CHARACTER_MAXIMUM_LENGTH*2 end )as ttt  from INFORMATION_SCHEMA.COLUMNS

 where TABLE_NAME in (select TABLE_NAME  from INFORMATION_SCHEMA.TABLES where TABLE_TYPE='BASE TABLE')

  group by TABLE_NAME

Check Table fields size and Data_types in sql server 2008r2 Columns Wise

--//Sql Queries

select DATA_TYPE,

 SUM(

 case

when DATA_TYPE='float' then 8

when DATA_TYPE='int'  then 8

when DATA_TYPE='datetime'  then 8

when DATA_TYPE='real'  then 4

when DATA_TYPE='decimal'  then 8

when DATA_TYPE='bigint'  then 8

when DATA_TYPE='smallint'  then 8

when DATA_TYPE='tinyint'  then 8

when DATA_TYPE='char'  then CHARACTER_MAXIMUM_LENGTH*1

when DATA_TYPE='bit'  then 1

when DATA_TYPE='nchar'  then CHARACTER_MAXIMUM_LENGTH*2

when DATA_TYPE='varchar'  then CHARACTER_MAXIMUM_LENGTH*2

else CHARACTER_MAXIMUM_LENGTH*2 end )as [Data_Type_Sizes],

count (DATA_TYPE)as [No Of Data_Types]

 from INFORMATION_SCHEMA.COLUMNS  where TABLE_NAME='Table Name'

 group by DATA_TYPE

Select certain columns from a data table using c#

string[] selectedColumns = new[] { "Columns1"," Columns2"," Columns3" };

DataTable Dt = new DataView(ds.Tables["dt"]).ToTable(false, selectedColumns);

ASP.NET CheckBoxList Operations with jQuery

jQuery.

Let’s have following aspx code:

<asp:CheckBoxList ID="CheckBoxList1" runat="server">

</asp:CheckBoxList>

<input type="button" value="OK" id="demo" /> 

On server side:

Dictionary<int,string>  dictItems = new Dictionary<int,string>();

 dictItems.Add(1, "Item-1");

 dictItems.Add(2, "Item-2");

 dictItems.Add(3, "Item-3");

 dictItems.Add(4, "Item-4");

 dictItems.Add(5, "Item-5");

 CheckBoxList1.DataSource = dictItems;

 CheckBoxList1.DataTextField = "Value";

 CheckBoxList1.DataValueField = "Key";

 CheckBoxList1.DataBind();

1. Get Value of Selected Items:

//Get value of selected items

$("#demo").click(function () {     

    var selectedValues = [];

    $("[id*=CheckBoxList1] input:checked").each(function () {          

        selectedValues.push($(this).val());

    });

    if (selectedValues.length>0) {

        alert("Selected Value(s): " + selectedValues);

    } else {

        alert("No item has been selected.");

    }

});




2. Get Index of selected items:

//Get index of selected items

   $("#demo").click(function () {

       var $ctrls = $("[id*=CheckBoxList1] input:checkbox");

       $("[id*=CheckBoxList1] input:checked").each(function () {

          alert($ctrls.index($(this)));

       });      

   });




It will display 0 based index of selected items. Suppose I select Item-1,Item-3,Item-4 then It’ll give output 0,2,3 in alert boxes.

3. Get Text of Selected Items:

//Get text of selected items

 $("#demo").click(function () {      

     $("[id*=CheckBoxList1] input:checked").each(function () {

         alert($(this).next().html());

     });

 });




As you’ve seen, Text is placed in label control(next of checkbox) in rendered HTML. So,$(this).next().html() is used to get text.

4. Check/Uncheck All Checkboxes:

$("[id*=CheckBoxList1] input:checkbox").prop('checked',true); //To check all

$("[id*=CheckBoxList1] input:checkbox").prop('checked',false);// To uncheck all




Note: For jQuery 1.6+,use prop and for older version use attr.

Read Also: jQuery .attr() vs .prop()

5. Check Items By Index:

//Check Items by index

   var selIndex = [0, 2, 3];

   for (var i = 0; i < selIndex.length; i++) {

       $("[id*=CheckBoxList1] input:checkbox").eq(selIndex[i]).prop('checked', true);

   }




Similarly, you can uncheck items by setting false in prop.

6. Check Items By Value:

//Check Items by value

   var selValue = [1, 2, 4];

   var $ctrls = $("[id*=CheckBoxList1]");

   for (var i = 0; i < selValue.length; i++) {

       $ctrls.find('input:checkbox[value=' + selValue[i] + ']').prop('checked', true);

   }




In above code, checkbox is selected if value exist in selValue array.

7. Check Items By Text:

//Check Items by Text

    var selText = ['Item-1','Item-3'];

    var $ctrls = $("[id*=CheckBoxList1]");

    for (var i = 0; i < selText.length; i++) {

        $ctrls.find('label:contains("' + selText[i] + '")').prev().prop('checked', true);

    }




In this Label text is compared and if text exists then corresponding checkbox is checked. The above code will select Item-1 and Item-3.

8. Max Selection Limit:

The following code limits the number of checkboxes a user can select simultaneously

$("[id*=CheckBoxList1] input:checkbox").change(function () {

          var maxSelection = 3;

          if ($("[id*=CheckBoxList1] input:checkbox:checked").length > maxSelection) {

              $(this).prop("checked", false);

              alert("Please select a maximum of " + maxSelection + " items.");

          }

      })

reff-http://techbrij.com/checkboxlist-jquery-asp-net-operations