Kunwar On .Net,PHP and more...

Resolving- Client does not support authentication protocol

noreply@blogger.com (Kunwar Singh) — Mon, 26 Dec 2011 10:34:00 +0000

Here are the steps that one needs to follow in order to resolve the "Client does not support authentication protocol" issue

1. Login to phpmyadmin
2. Select the database to which you want to connect via PHP
3. Click on the SQL Link and execute the follwoing query

SET PASSWORD FOR 'username' = OLD_PASSWORD('password')

replace username with the username for the database
replace password with the password for the database

The above issue will be resolved

Happy Coding :

Convert String to Camel Case C#

noreply@blogger.com (Kunwar Singh) — Wed, 28 Jul 2010 09:58:00 +0000


private string ConvertToCamelCase(string phrase)
        {
            string[] splittedPhrase = phrase.Split(' ', '-', '.');
            var sb = new StringBuilder();
            //sb.Append(splittedPhrase[0].ToLower());
            //splittedPhrase[0] = string.Empty;

            foreach (String s in splittedPhrase)
            {
                char[] splittedPhraseChars = s.ToCharArray();
                if (splittedPhraseChars.Length > 0)
                {
                    splittedPhraseChars[0] = ((new String(splittedPhraseChars[0], 1)).ToUpper().ToCharArray())[0];
                }
                sb.Append(new String(splittedPhraseChars));
            }
            return sb.ToString();
        }

SQL Lite Class for Ado.Net

noreply@blogger.com (Kunwar Singh) — Mon, 26 Jul 2010 13:26:00 +0000

SQL Lite Class for Ado.Net


public static DataTable GetDataTable (string sql)
   {
    DataTable dt = new DataTable();
    try
    {
    SQLiteConnection cnn = new SQLiteConnection("Data Source=C:CheckoutWorldDominator.s3db");
    cnn.Open();
    SQLiteCommand mycommand = new SQLiteCommand(cnn);
    mycommand.CommandText = sql;
    SQLiteDataReader reader = mycommand.ExecuteReader();
    dt.Load(reader);
    reader.Close();
    cnn.Close();
    } catch {
    // Catching exceptions is for communists
    }
    return dt;
 }
public static int ExecuteNonQuery(string sql)
{
    SQLiteConnection cnn = new SQLiteConnection("Data Source=C:CheckoutWorldDominator.s3db");
    cnn.Open();
    SQLiteCommand mycommand = new SQLiteCommand(cnn);
    mycommand.CommandText = sql;
    int rowsUpdated = mycommand.ExecuteNonQuery();
    cnn.Close();
    return rowsUpdated;
}
public static string ExecuteScalar(string sql)
{
    SQLiteConnection cnn = new SQLiteConnection("Data Source=C:CheckoutWorldDominator.s3db");
    cnn.Open();
    SQLiteCommand mycommand = new SQLiteCommand(cnn);
    mycommand.CommandText = sql;
    object value = mycommand.ExecuteScalar();
    cnn.Close();

if (value != null)
    {
        return value.ToString();

    }
    return "";

}

Passing Queystring to Hyperlink using NavigateURL

noreply@blogger.com (Kunwar Singh) — Tue, 20 Jul 2010 17:22:00 +0000


<ItemTemplate>
<asp:HyperLink ID="storyLink" runat="server" Text='<%#Bind("Title") %>' NavigateUrl='<%#"ViewUploadedStory.aspx?story="+DataBinder.Eval(Container.DataItem,"StoryId")+"&author="+DataBinder.Eval(Container.DataItem,"AuthorName")+"&filename="+DataBinder.Eval(Container.DataItem,"FullPath")%>'></asp:HyperLink>
</ItemTemplate>

Generate SQL Create Statements using SQL Query For SQL Server 2005

noreply@blogger.com (Kunwar Singh) — Sat, 26 Jun 2010 16:29:00 +0000


select  'create table [' + so.name + '] (' + o.list + ')' + CASE WHEN tc.Constraint_Name IS NULL THEN '' ELSE 'ALTER TABLE ' + so.Name + ' ADD CONSTRAINT ' + tc.Constraint_Name  + ' PRIMARY KEY ' + ' (' + LEFT(j.List, Len(j.List)-1) + ')' END
from    sysobjects so
cross apply
    (SELECT 
        '  ['+column_name+'] ' + 
        data_type + case data_type
                when 'sql_variant' then ''
                when 'text' then ''
                when 'decimal' then '(' + cast(numeric_precision_radix as varchar) + ', ' + cast(numeric_scale as varchar) + ')'
                else coalesce('('+case when character_maximum_length = -1 then 'MAX' else cast(character_maximum_length as varchar) end +')','') end + ' ' +
        case when exists ( 
        select id from syscolumns
        where object_name(id)=so.name
        and name=column_name
        and columnproperty(id,name,'IsIdentity') = 1 
        ) then
        'IDENTITY(' + 
        cast(ident_seed(so.name) as varchar) + ',' + 
        cast(ident_incr(so.name) as varchar) + ')'
        else ''
        end + ' ' +
         (case when IS_NULLABLE = 'No' then 'NOT ' else '' end ) + 'NULL ' + 
          case when information_schema.columns.COLUMN_DEFAULT IS NOT NULL THEN 'DEFAULT '+ information_schema.columns.COLUMN_DEFAULT ELSE '' END + ', ' 

     from information_schema.columns where table_name = so.name
     order by ordinal_position
    FOR XML PATH('')) o (list)
left join
    information_schema.table_constraints tc
on  tc.Table_name               = so.Name
AND tc.Constraint_Type  = 'PRIMARY KEY'
cross apply
    (select '[' + Column_Name + '], '
     FROM       information_schema.key_column_usage kcu
     WHERE      kcu.Constraint_Name     = tc.Constraint_Name
     ORDER BY
        ORDINAL_POSITION
     FOR XML PATH('')) j (list)
where   xtype = 'U'
AND name        NOT IN ('dtproperties')

Read Word Doc/Docx files in One line of code using Google Docs

noreply@blogger.com (Kunwar Singh) — Mon, 17 May 2010 07:44:00 +0000

For more Info visit http://digitizor.com

Example:-


<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <iframe src="http://docs.google.com/gview?url=http://franchiseforindia.com/Sample.docx&embedded=true" style="width:500px; height:500px;" frameborder="0″></iframe>
    </div>
    </form>
</body>
</html>

Access Resource from DataBase using IHTTPHandler

noreply@blogger.com (Kunwar Singh) — Mon, 01 Feb 2010 11:31:00 +0000


<%@ webhandler language="C#" class="NWEmpPhotoHandler" %>
using System; 
using System.Web; 
using System.Data; 
using System.Data.SqlClient; 
public class NWEmpPhotoHandler : IHttpHandler 
{ 
    public bool IsReusable { get { return true; } } 
    
    public void ProcessRequest(HttpContext ctx) 
    { 
        string id = ctx.Request.QueryString["id"]; 

        SqlConnection con = new SqlConnection(<INSERT CONNECTION STRING HERE>); 
        SqlCommand cmd = new SqlCommand("SELECT Photo FROM Employees WHERE EmployeeID = @EmpID", con); 
        cmd.CommandType = CommandType.Text; 
        cmd.Parameters.Add("@EmpID", id); 
        
        con.Open(); 
        byte[] pict = (byte[])cmd.ExecuteScalar(); 
        con.Close(); 

        ctx.Response.ContentType = "image/bmp"; 
        ctx.Response.OutputStream.Write(pict, 78, pict.Length - 78); 
    } 
}

URL rewriting using IHttpHandler

noreply@blogger.com (Kunwar Singh) — Mon, 01 Feb 2010 10:05:00 +0000

By-Jeffery Palermo
Refer this as well-
well-Tracking access to media resources with HttpHandlers


public class ProductHandler: IHttpHandler, IRequiresSessionState

    {

        public bool IsReusable

        {

            get { return true; }

        }

 

        public void ProcessRequest(HttpContext context)

        {

            context.Items["originalQuerystring"] = context.Request.QueryString.ToString();
            context.Items["originalPathInfo"] = context.Request.PathInfo;

            string productCode = {some code to derive your product code};

            string page = "~/product.aspx";

            string queryString = "productCode=" + productCode;

            foreach(string key in context.Request.QueryString.Keys)

            {

                if(key != "productCode")

                {

                    queryString += string.Format("&{0}={1}", key, context.Request.QueryString[key]);

                }

            }

           

            context.RewritePath(context.Request.Path, string.Empty, queryString);

           

            Page hand = (Page)PageParser.GetCompiledPageInstance(page, context.Server.MapPath(page), context);

            // Listen for event to rewrite url back before the page renders.

            hand.PreRenderComplete += new EventHandler(hand_PreRenderComplete);

           

            hand.ProcessRequest(context);           

        }

 

        void hand_PreRenderComplete(object sender, EventArgs e)

        {

            HttpContext.Current.RewritePath(HttpContext.Current.Request.Path, 
               HttpContext.Current.Items["originalPathInfo"].ToString(), 
               HttpContext.Current.Items["originalQuerystring"].ToString());

        }

    }

Integrate You Tube Video In Your Blog/WebSite

noreply@blogger.com (Kunwar Singh) — Mon, 01 Feb 2010 06:44:00 +0000

Just use the Object tag provided by you tube


   <object width="425" height="350">
    <param name="movie" value="http://www.youtube.com/v/crfrKqFp0Zg"></param>
    <param name="wmode" value="transparent"></param>
    <embed src="http://www.youtube.com/v/crfrKqFp0Zg" type="application/x-shockwave-flash" wmode="transparent" width="425" height="350"></embed>
    </object>

ASP.NET 2.0: URL Mapping with RegEx Support

noreply@blogger.com (Kunwar Singh) — Fri, 29 Jan 2010 12:47:00 +0000

By Chris Pietschmann
The one big limitation of the URL Mapping functionality built in to ASP.NET 2.0 is that it doesn't support regular expressions. I ported my v1.1 URL Mapping implementation over to v2.0 and added support for regular expressions. It really wasn't too difficult; I only had to modify two lines of code to port it over to ASP.NET 2.0. Then I had to modify 4 lines of code to add RegEx support. My implementation works just like the ASP.NET 2.0 URL Mapping functionality with the addition of RegEx.

My code allows to create Url Mappings similar to the following:
~/Chris.aspx to ~/Default.aspx?p=chris
~/Show154.aspx to ~/Default.aspx?p=154

Some Performance tips for using this code:

1. Use as few Url Mapping definitions as possible since it parses them from the first to the last and stops when it finds a match. If a page requested doesn't match any of the definitions it will go through all of them before moving on to complete the page request.

2. Put the most frequently used Url Mappings first in the list so that they the ones that are parsed first.

3. The first Url Mapping in placed in my code () is a little trick that allows all requests for the Default.aspx page in the root or any sub-folder of the application to be completed with out having to parse through the entire list of Url Mappings.

Regular expression support just seems logical in the v2.0 URL Mapping functionality, but I don't know why Microsoft didn't add it. I guess they wanted me to have something to do. :)

Enjoy!

Code for this implementation listed below:
/App_Code/RegExUrlMappingBaseModule.vb



 using Microsoft.VisualBasic;

 using System.Web;

 namespace RegExUrlMapping_HTTPModule
 {
    
     public class RegExUrlMappingBaseModule : System.Web.IHttpModule
     {
        
        
         public void Init(HttpApplication app)
         {
            
                
             app.AuthorizeRequest += this.BaseModuleRewriter_AuthorizeRequest;
         }
        
         public void Dispose()
         {
            
         }
        
         public void BaseModuleRewriter_AuthorizeRequest(object sender, EventArgs e)
         {
            
             HttpApplication app = (HttpApplication)sender;
            
                
             Rewrite(app.Request.Path, app);
         }
        
         public virtual void Rewrite(string requestedPath, HttpApplication app)
         {
            
         }
        
     }
 }

/App_Code/RegExUrlMappingConfigHandler.vb


using Microsoft.VisualBasic;

using System.Configuration;

using System.Xml;

namespace RegExUrlMapping_HTTPModule
{
    
    public class RegExUrlMappingConfigHandler : IConfigurationSectionHandler
    {
        
        
        XmlNode _Section;
        
        public object Create(object parent, object configContext, System.Xml.XmlNode section)
        {
            
            _Section = section;
            
                
            return this;
        }
        
        /// Get whether url mapping is enabled in the app.config
        
        internal bool Enabled()
        {
            
            if (_Section.Attributes("enabled").Value.ToLower == "true") {
                
                    
                return true;
            }
            else {
                
                    
                return false;
                
            }
        }
        
        /// Get the matching "mapped Url" from the web.config file if there is one.
        
        internal string MappedUrl(string url)
        {
            
            XmlNode x = default(XmlNode);
            
            Regex oReg = default(Regex);
            
            foreach (var x in _Section.ChildNodes) {
                
                oReg = new Regex(x.Attributes("url").Value.ToLower);
                
                if (oReg.Match(url).Success) {
                    
                        
                    return oReg.Replace(url, x.Attributes("mappedUrl").Value.ToLower);
                    
                }
            }
            
                
            return "";
        }
        
    }
}

/App_Code/RegExUrlMappingModule.vb



using Microsoft.VisualBasic;

using System.Web;

using System.Configuration;

namespace RegExUrlMapping_HTTPModule
{
    
    public class RegExUrlMappingModule : RegExUrlMappingBaseModule
    {
        
        
        public override void Rewrite(string requestedPath, HttpApplication app)
        {
            
            //'Implement functionality here that mimics the 'URL Mapping' features of ASP.NET 2.0
            
            RegExUrlMappingConfigHandler config = (RegExUrlMappingConfigHandler)ConfigurationManager.GetSection("system.web/RegExUrlMapping");
            
            string pathOld = null;
            string pathNew = "";
            
            if (config.Enabled) {
                
                pathOld = app.Request.RawUrl;
                
                //'Get the request page without the querystring parameters
                
                string requestedPage = app.Request.RawUrl.ToLower;
                
                if (requestedPage.IndexOf("?") > -1) {
                    
                        
                    requestedPage = requestedPage.Substring(0, requestedPage.IndexOf("?"));
                }
                
                //'Format the requested page (url) to have a ~ instead of the virtual path of the app
                
                string appVirtualPath = app.Request.ApplicationPath;
                
                if (requestedPage.Length >= appVirtualPath.Length) {
                    
                    if (requestedPage.Substring(0, appVirtualPath.Length).ToLower == appVirtualPath.ToLower) {
                        
                        requestedPage = requestedPage.Substring(appVirtualPath.Length);
                        
                        if (requestedPage.Substring(0, 1) == "/") {
                            
                                
                            requestedPage = "~" + requestedPage;
                        }
                        else {
                            
                                
                            requestedPage = "~/" + requestedPage;
                            
                        }
                        
                    }
                }
                
                //'Get the new path to rewrite the url to if it meets one
                
                //'of the defined virtual urls.
                
                pathNew = config.MappedUrl(requestedPage);
                
                //'If the requested url matches one of the virtual one
                
                //'the lets go and rewrite it.
                
                if (pathNew.Length > 0) {
                    
                    if (pathNew.IndexOf("?") > -1) {
                        
                        //'The matched page has a querystring defined
                        
                        if (pathOld.IndexOf("?") > -1) {
                            
                                
                            pathNew += "&" + Strings.Right(pathOld, pathOld.Length - pathOld.IndexOf("?") - 1);
                            
                        }
                    }
                    else {
                        
                        //'The matched page doesn't have a querystring defined
                        
                        if (pathOld.IndexOf("?") > -1) {
                            
                                
                            pathNew += Strings.Right(pathOld, pathOld.Length - pathOld.IndexOf("?"));
                            
                        }
                    }
                    
                    //'Rewrite to the new url
                    
                        
                    HttpContext.Current.RewritePath(pathNew, false);
                    
                }
                
            }
        }
        
    }
}

/Web.Config


<configuration>

<!-- Declare the custom 'RegExUrlMapping' section and handler -->

<configSections>

<sectionGroup name="system.web">

<section name="RegExUrlMapping" type="RegExUrlMapping_HTTPModule.RegExUrlMappingConfigHandler"/>

</sectionGroup>

</configSections>

<system.web>

<!-- Tell ASP.NET to use the RegEx URL Mapping HTTP Module -->

<httpModules>

<add type="RegExUrlMapping_HTTPModule.RegExUrlMappingModule" name="RegExUrlMappingModule"/>

</httpModules>

<!-- The RegEx URL Mapping parser goes through these in sequential order. -->

<RegExUrlMapping enabled="true">

<add url="~/(.*)default\.aspx" mappedUrl="~/$1default.aspx" />

<add url="~/Chris.aspx" mappedUrl="~/Default.aspx?p=chris"/>

<add url="~/show(.*)\.aspx" mappedUrl="~/Default.aspx?p=$1&section=3"/>

</RegExUrlMapping>

</system.web>

</configuration>

Accessing an XML Web Service Asynchronously in Managed Code

noreply@blogger.com (Kunwar Singh) — Fri, 07 Aug 2009 08:48:00 +0000

Accessing an XML Web Service Asynchronously in Managed Code
Asynchronous Programming Design Patterns

How to: Use Components That Support the Event-based Asynchronous Pattern

How to: Run an Operation in the Background

Communicating with XML Web Services Asynchronously

Asynchronous Method Invocation - By mikeperetz

Convert DataTable To XML

noreply@blogger.com (Kunwar Singh) — Tue, 28 Jul 2009 11:01:00 +0000


public static string ToStringAsXml(DataTable dt)
  {
  StringWriter sw = new StringWriter();
  dt.WriteXml(sw, XmlWriteMode.IgnoreSchema);
  string s = sw.ToString();
  return s;

  }

Calling Java Code from ASP.NET Web Applications

noreply@blogger.com (Kunwar Singh) — Fri, 17 Jul 2009 10:58:00 +0000

Calling Java Code from ASP.NET Web Applications

Parent Child in One DataGridView Windows Forms

noreply@blogger.com (Kunwar Singh) — Wed, 15 Jul 2009 12:36:00 +0000


public class NestedDgvColumn : DataGridViewColumn 
{ 
    
    public NestedDgvColumn() : base(new NestedDgvCell()) 
    { 
    } 
    
    public override DataGridViewCell CellTemplate { 
        get { return base.CellTemplate; } 
        set { 
            
            // Ensure that the cell used for the template is a DataGridViewCell. 
            if ((value != null) && !value.GetType().IsAssignableFrom(typeof(NestedDgvCell))) { 
                throw new InvalidCastException("Must be a NestedDgvCell"); 
            } 
            base.CellTemplate = value; 
        } 
        
    } 
} 

public class NestedDgvCell : DataGridViewCell 
{ 
    
    private DataGridView dgv = new DataGridView(); 
    
    private void SetupDGVToDraw() 
    { 
        
        //reachrishikh edit 
        //if you're like me and want to modify the looks of your nested datagridview, 
        //you can use the code as below. 
        dgv.BackgroundColor = SystemColors.Control; 
        dgv.Size = new Size(400, 100); 
        dgv.AllowUserToAddRows = false; 
        dgv.RowHeadersVisible = false; 
        dgv.ColumnHeadersVisible = false; 
        dgv.SelectionMode = DataGridViewSelectionMode.FullRowSelect; 
        dgv.BorderStyle = Windows.Forms.BorderStyle.None; 
        dgv.AutoGenerateColumns = false; 
        //end reachrishikh edit 
        
        if ((Value) is DataTable) { 
            //reachrishikh edit 
            //if you simply want to add columns to the nested datagridview as per the schema 
            //of the datatable you're binding to it, then use the code below 
            //dgv.Columns.Clear() 
            //For Each column As DataColumn In CType(Value, DataTable).Columns 
            // dgv.Columns.Add(column.ColumnName, column.ColumnName) 
            //Next 
            //end reachrishikh edit 
            
            //reachrishikh edit 
            //else use this code if you want to custom format your columns 
            DataTable table = (DataTable)Value; 
            dgv.Columns.Clear(); 
            DataGridViewTextBoxColumn dgvColumn = default(DataGridViewTextBoxColumn); 
            foreach (DataColumn column in table.Columns) { 
                dgvColumn = new DataGridViewTextBoxColumn(); 
                dgvColumn.Name = column.ColumnName; 
                dgvColumn.HeaderText = column.ColumnName; 
                dgvColumn.DefaultCellStyle.Format = "C2"; 
                dgvColumn.ValueType = typeof(decimal); 
                dgv.Columns.Add(dgvColumn); 
            } 
            //end reachrishikh edit 
            
            foreach (DataRow datarow in ((DataTable)Value).Rows) { 
                dgv.Rows.Add(datarow.ItemArray); 
            } 
            
        } 
    } 
    
    protected override void Paint(System.Drawing.Graphics graphics, System.Drawing.Rectangle clipBounds, System.Drawing.Rectangle cellBounds, int rowIndex, System.Windows.Forms.DataGridViewElementStates cellState, object value, object formattedValue, string errorText, System.Windows.Forms.DataGridViewCellStyle cellStyle, System.Windows.Forms.DataGridViewAdvancedBorderStyle advancedBorderStyle, 
    System.Windows.Forms.DataGridViewPaintParts paintParts) 
    { 
        base.Paint(graphics, clipBounds, cellBounds, rowIndex, cellState, value, formattedValue, errorText, cellStyle, advancedBorderStyle, 
        paintParts); 
        graphics.FillRectangle(new SolidBrush(cellStyle.BackColor), cellBounds); 
        
        SetupDGVToDraw(); 
        Bitmap abbreviation = new Bitmap(cellBounds.Width, cellBounds.Height); 
        dgv.DrawToBitmap(abbreviation, new Rectangle(0, 0, cellBounds.Width, cellBounds.Height)); 
        graphics.DrawImage(abbreviation, cellBounds, new Rectangle(0, 0, abbreviation.Width, abbreviation.Height), GraphicsUnit.Pixel); 
    } 
    
    public override void InitializeEditingControl(int rowIndex, object initialFormattedValue, DataGridViewCellStyle dataGridViewCellStyle) 
    { 
        
        // Set the value of the editing control to the current cell value. 
        base.InitializeEditingControl(rowIndex, initialFormattedValue, dataGridViewCellStyle); 
    } 
    
    public override Type EditType { 
// Return the type of the editing contol that DgvCell uses. 
        get { return typeof(DgvEditingControl); } 
    } 
    
    public override System.Type ValueType { 
        get { return typeof(object); } 
        set { } 
        
    } 
    
} 

class DgvEditingControl : DataGridView, IDataGridViewEditingControl 
{ 
    
    private DataGridView dataGridViewControl; 
    private bool valueIsChanged = false; 
    private int rowIndexNum; 
    
    public object EditingControlFormattedValue { 
        
        get { return this.RowCount; } 
        
        set { } 
        //If TypeOf value Is String Then 
        // Me.RowCount = Convert.ToInt32(value) 
        //End If 
    } 
    
    
    public object GetEditingControlFormattedValue(DataGridViewDataErrorContexts context) 
    { 
        
            
        return this.RowCount; 
    } 
    
    public void ApplyCellStyleToEditingControl(DataGridViewCellStyle dataGridViewCellStyle) 
    { 
        
        this.Font = dataGridViewCellStyle.Font; 
        this.ForeColor = dataGridViewCellStyle.ForeColor; 
        this.BackgroundColor = dataGridViewCellStyle.BackColor; 
    } 
    
    public int EditingControlRowIndex { 
        
        get { return rowIndexNum; } 
        set { rowIndexNum = value; } 
    } 
    
    
    public bool EditingControlWantsInputKey(Keys key, bool dataGridViewWantsInputKey) 
    { 
        
        // Let the nested DataGridView handle the keys listed. 
        switch (key & Keys.KeyCode) { 
            case Keys.Left: 
            case Keys.Up: 
            case Keys.Down: 
            case Keys.Right: 
            case Keys.Enter: 
            case Keys.Escape: 
            case Keys.Tab: 
                
                return true; 
            
            default: 
                return false; 
            
        } 
    } 
    
    public void PrepareEditingControlForEdit(bool selectAll) 
    { 
        
        // No preparation needs to be done. 
        
    } 
    
    public bool RepositionEditingControlOnValueChange { 
        
        get { return false; } 
    } 
    
    
    public DataGridView EditingControlDataGridView { 
        
        get { return dataGridViewControl; } 
        set { dataGridViewControl = value; } 
    } 
    
    
    public bool EditingControlValueChanged { 
        
        get { return valueIsChanged; } 
        set { valueIsChanged = value; } 
    } 
    
    
    public Cursor EditingControlCursor { 
        
        get { return base.Cursor; } 
    } 
    Cursor IDataGridViewEditingControl.EditingPanelCursor { 
        get { return EditingControlCursor; } 
    } 
    
    
}

Data Binding for Windows Forms

noreply@blogger.com (Kunwar Singh) — Mon, 13 Jul 2009 09:24:00 +0000

Data Binding for Windows Forms

noreply@blogger.com (Kunwar Singh) — Mon, 13 Jul 2009 09:24:00 +0000

Data Binding for Windows Forms

Consuming a Web Service using ASP.NET Ajax

noreply@blogger.com (Kunwar Singh) — Fri, 03 Jul 2009 18:41:00 +0000

Consuming a Web Service using ASP.NET Ajax

RegisterClientScriptArray using ClientScriptManager

noreply@blogger.com (Kunwar Singh) — Tue, 23 Jun 2009 13:10:00 +0000


protected void Grid_PreRender(object sender, EventArgs e)
        {

            ClientScriptManager cs = Page.ClientScript;

            foreach (GridViewRow grdrow in Grid_Appeal.Rows)
            {
                TextBox txtxScheduleDate = (TextBox)grdrow.FindControl("txtxScheduleDate");
                TextBox txtxScheduleFrom = (TextBox)grdrow.FindControl("txtxScheduleFrom");
                TextBox txtxScheduleTo = (TextBox)grdrow.FindControl("txtxScheduleTo");
                TextBox txtxMailingDate = (TextBox)grdrow.FindControl("txtxMailingDate");
                HtmlInputButton BtnPickDate = (HtmlInputButton)grdrow.FindControl("BtnPickDate");
                Button btnPrintSave = (Button)grdrow.FindControl("btnPrintSave");
                //HtmlInputButton BtnMailDate = (HtmlInputButton)grdrow.FindControl("BtnMailDate");
                
                cs.RegisterArrayDeclaration("grd_ScheduleDate", String.Concat("'", txtxScheduleDate.ClientID, "'"));
                cs.RegisterArrayDeclaration("grd_ScheduleFrom", String.Concat("'", txtxScheduleFrom.ClientID, "'"));
               
                cs.RegisterArrayDeclaration("grd_MailingDate", String.Concat("'", txtxMailingDate.ClientID, "'"));
                cs.RegisterArrayDeclaration("grd_PickDate", String.Concat("'", BtnPickDate.ClientID, "'"));
              
                cs.RegisterArrayDeclaration("grd_Print", String.Concat("'", btnPrintSave.ClientID, "'"));
                

            }
            
        }


//Javascript
function EnableCtrl()
{
 if(typeof(grd_ScheduleDate)!='undefined')
 {
    for(j=0;j<grd_ScheduleDate.length;j++)
        {
            var obj = document.getElementById(grd_ScheduleDate[j]);
            obj.readOnly=true;
            
        }
    for(j=0;j<grd_ScheduleFrom.length;j++)
        {
            var obj = document.getElementById(grd_ScheduleFrom[j]);
            obj.readOnly=true;
            
        }

        for(j=0;j<grd_MailingDate.length;j++)
        {
            var obj = document.getElementById(grd_MailingDate[j]);
            obj.readOnly=true;
            
        }
        for(j=0;j<grd_PickDate.length;j++)
        {
            var obj = document.getElementById(grd_PickDate[j]);
            obj.disabled=true;
            
        }
        for(j=0;j<grd_Print.length;j++)
        {
            var obj = document.getElementById(grd_Print[j]);
            obj.disabled=true;
            
        }

    }
        
}

Remove duplicate values from Comma Seperated string

noreply@blogger.com (Kunwar Singh) — Fri, 19 Jun 2009 06:49:00 +0000


protected string RemoveDuplicateValues(string strCsv)
        {
            // create string to hold values
            string strTempString = string.Empty;

            // remove , from the end of passed string (if required)
            strCsv.TrimEnd(',');

            // create array to hold values
            ArrayList splitArray = new ArrayList();

            // split comma seperated values and put in string array
            string[] splitString = strCsv.Split(',');

            // loop through string array
            for (int x = 0; x < splitString.Length; x++)
            {
                // if the array does not already contain string array value, add to array
                if (!splitArray.Contains(splitString[x]))
                {
                    splitArray.Add(splitString[x]);
                }
            }

            // sort array
            splitArray.Sort();

            // loop through array list
            foreach (string item in splitArray)
            {
                // add item to strTempString followed by a ,
                strTempString += item + ",";
            }

            // trim , from the end of the string
            strTempString = strTempString.TrimEnd(',');

            // return strTempString
            return strTempString;
        }

Get List of Modified Procedures and tables in Last N days

noreply@blogger.com (Kunwar Singh) — Thu, 18 Jun 2009 14:27:00 +0000

List of modified procedure in One day

 
SELECT name,modify_date

FROM sys.objects

WHERE type = 'P' AND DATEDIFF(D,modify_date, GETDATE()) < 1

List of Tables modified in Three weeks

 
SELECT name,modify_date

FROM sys.objects

WHERE type = 'U' AND DATEDIFF(D,modify_date, GETDATE()) < 21

Encrypt Web.Config File

noreply@blogger.com (Kunwar Singh) — Wed, 17 Jun 2009 12:41:00 +0000

http://www.developerfusion.com/code/5263/encrypting-webconfig-sections-in-aspnet-20/

Add Sr # with Paging Option in DataGrid

noreply@blogger.com (Kunwar Singh) — Fri, 12 Jun 2009 05:02:00 +0000



Font-Underline="False" HorizontalAlign="Center" />
<%#dgResult.PageSize*dgResult.CurrentPageIndex + Container.ItemIndex + 1%>

Font-Underline="False" BackColor="Navy" ForeColor="White" HorizontalAlign="Center" />

Get Top Record from each group SQL Server 2005

noreply@blogger.com (Kunwar Singh) — Mon, 08 Jun 2009 12:52:00 +0000

select s.CustId,s.Meter from
(Select ROW_NUMBER() OVER (partition by CustId ORDER BY CustId) [rnum],CustId,Meter from TempTable)
s where s.rnum=1

How to Bridge the Client-Server Gap using AJAX and jQuery

noreply@blogger.com (Kunwar Singh) — Mon, 08 Jun 2009 07:13:00 +0000


How to Bridge the Client-Server Gap using AJAX and jQuery

Stop Parent Events when Child Events are called in Javascript

noreply@blogger.com (Kunwar Singh) — Fri, 05 Jun 2009 07:15:00 +0000

You can stop the events in the inner elements to prevent the parent event handler.
Like this:


function doSomething(e)
{
      if (!e) var e = window.event;
      e.cancelBubble = true;
      if (e.stopPropagation) e.stopPropagation();
}