Thursday, July 14, 2016

Convert dictionary to list collection in C#

using linq
accountTypes.Select(kvp => new
            {
                account_type_no = kvp.Key,
                account_type_name = kvp.Value
            }).ToList()
using loop
foreach (var item in accountTypes)
{
    accountTypeList.Add(item.Key);
}

Friday, March 4, 2016

How to get schema from stored procedure sql server

ADO.NET

DataTable schema = reader.GetSchemaTable();

SQL


SELECT * FROM sys.dm_exec_describe_first_result_set ('qualified.storedprocname', @params, 0) ;

How to submit / save changes in LinqPad

void Main()
{
    var students = Student.Select(st => st);
    foreach (var student in students)
    {
        student.FatherName = "Father";
    }
    SubmitChanges();
}

Monday, February 29, 2016

How to change a value of a DataItem in a GridViews RowDataBound Event

if (e.Row.RowType == DataControlRowType.DataRow)
{
 DataRow row = ((DataRowView)e.Row.DataItem).Row;
 for (int i = 0; i < row.ItemArray.Length; i++)
 {
  var obj = row.ItemArray[i];
  if (obj.GetType().Name == "DateTime")
  {
   e.Row.Cells[i + 1].Text = ((DateTime)obj).ToShortDateString();
  }
  else if (obj.GetType().Name == "Boolean")
  {
   e.Row.Cells[i + 1].Text = ((Boolean)obj).ToYesNo();
  }
 }
}