Kandy Steps

Send simple notification to Android

2017-09-19T22:07:00.001-07:00

Send simple notification to Android

public string SendNotification(string DeviceToken, string message)

{

var value = message;

WebRequest tRequest;

tRequest = WebRequest.Create("https://android.googleapis.com/gcm/send");

tRequest.Method = "post";

tRequest.ContentType = " application/x-www-form-urlencoded;charset=UTF-8";

tRequest.Headers.Add(string.Format("Authorization: key={0}", Common.GoogleAppID));

tRequest.Headers.Add(string.Format("Sender: id={0}", Common.SENDER_ID));

string postData = "collapse_key=score_update&time_to_live=108&delay_while_idle=0&data.message=" + value + "&data.time=" + System.DateTime.Now.ToString() + "&registration_id=" + DeviceToken + "";

Console.WriteLine(postData);

Byte[] byteArray = Encoding.UTF8.GetBytes(postData);

tRequest.ContentLength = byteArray.Length;

Stream dataStream = tRequest.GetRequestStream();

dataStream.Write(byteArray, 0, byteArray.Length);

dataStream.Close();

WebResponse tResponse = tRequest.GetResponse();

dataStream = tResponse.GetResponseStream();

StreamReader tReader = new StreamReader(dataStream);

String sResponseFromServer = tReader.ReadToEnd();

tReader.Close();

dataStream.Close();

tResponse.Close();

return sResponseFromServer;

}

Post Data on URL using Asp.net C#

2017-02-26T21:36:00.000-08:00

Post Data on URL using Asp.net C

C# code :

private void PostForm()

{

string remoteUrl = "Posted_Url";

string MobileNo = "11";

string EmailId = "11";

string Registrationno = "11";

string PackageName = "11";

string ExpiryDate = "1-12-2017";

string TransactionId = "11";

string memberCode = "11";

string CoverageDetails = "11";

string Status = "11";

string PartnerName = "11";

HttpWebRequest request = (HttpWebRequest)WebRequest.Create(remoteUrl);

request.Method = "POST";

request.ContentType = "application/x-www-form-urlencoded";

string postData = string.Format("MobileNo={0}&EmailId={1}&Registrationno={2}&PackageName={3}&ExpiryDate={4}&TransactionId={5}&memberCode={6}&CoverageDetails={7}&Status={8}&PartnerName={9}", MobileNo, EmailId, Registrationno, PackageName, ExpiryDate, TransactionId, memberCode, CoverageDetails, Status, PartnerName);

byte[] bytes = Encoding.UTF8.GetBytes(postData);

request.ContentLength = bytes.Length;

Stream requestStream = request.GetRequestStream();

requestStream.Write(bytes, 0, bytes.Length);

WebResponse response = request.GetResponse();

Stream stream = response.GetResponseStream();

StreamReader reader = new StreamReader(stream);

var result = reader.ReadToEnd();

stream.Dispose();

reader.Dispose();

}

Send Fire base notification to Android using Asp.net C#

2017-02-26T21:31:00.001-08:00

Send Fire base notification to Android using Asp.net C#

C# Code :

public String SendNotificationFromFirebaseCloud(string DeviceToken, string Content)

{

string YOUR_FIREBASE_SERVER_KEY = "Please_put_server_key_Here";

var result = "-1";

var webAddr = "https://fcm.googleapis.com/fcm/send";

var httpWebRequest = (HttpWebRequest)WebRequest.Create(webAddr);

httpWebRequest.ContentType = "application/json";

httpWebRequest.Headers.Add("Authorization:key=" + YOUR_FIREBASE_SERVER_KEY);

httpWebRequest.Method = "POST";

using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))

{

// string json = "{\"to\":\"c6olDNPubCw:APA91bFbaqwHFHTcnny_PHXRBnAQ7w0ajkedasNaaowP858qXUUzO3X13MSR07A0Uuj721S5TpT_k7UOkMYl0UosV5E_1HM-RlyxX_-FkvR8B2zMp9iSKnCQ4ta5R5kxpN_g_oVRJ2cj\",\"data\":{\"body\": \"{^Type^:^1^,^message^:^Test Message^,^imageurl^:^http://punchmobility.com/wp-content/uploads/2014/08/push-notification-mobile-shopping-app-do-and-dont.png^,^title^:^Tring Tring Tring^,^fragmentName^:^com.crossroadshelpline.poss.FragmentAppointment^}\",\"title\": \"Title\"}}";

string json = "{\"to\":\"" + DeviceToken + "\",\"data\":" + Content + "\",\"title\": \"Title\"}}";

// string json = "{\"to\":\"" + DeviceToken + "\",\"data\":" + Content + "}";

streamWriter.Write(json);

streamWriter.Flush();

}

var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();

using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))

{

result = streamReader.ReadToEnd();

}

return result;

}

Post data and Redirect on URL in Asp.net

2017-02-12T23:40:00.001-08:00

Post data and Redirect on URL in Asp.net

C# Code:

NameValueCollection data = new NameValueCollection();

data.Add("UserName", "val1");

data.Add("MobileNo", "val2");

HttpHelper.RedirectAndPOST(this.Page, "http://mobileapp.co.in:8000/website/responsive", data);

Get Real Time Distance and ETA in asp.net using Google API

2017-02-12T23:34:00.001-08:00

Get Real Time Distance and ETA in asp.net using Google API

C# Code :

public bool Getdistance()

{

string result = "";

WebRequest request = null;

HttpWebResponse response = null;

String url = "https://maps.googleapis.com/maps/api/directions/xml?origin=28.668186,77.2301363&destination=28.603156,77.1773745";

request = WebRequest.Create(url);

response = (HttpWebResponse)request.GetResponse();

Stream stream = response.GetResponseStream();

Encoding ec = System.Text.Encoding.GetEncoding("utf-8");

StreamReader reader = new

System.IO.StreamReader(stream, ec);

result = reader.ReadToEnd();

XmlDocument xml = new XmlDocument();

xml.LoadXml(result); // suppose that str string contains "<Names>...</Names>"

XmlNodeList xnListDuration = xml.SelectNodes("/DirectionsResponse/route/leg/duration");

foreach (XmlNode xn in xnListDuration)

{

string val = xn.LastChild.InnerText;

Response.Write("Duration : " + val.ToString());

}

XmlNodeList xnListDistance = xml.SelectNodes("/DirectionsResponse/route/leg/distance");

foreach (XmlNode xn in xnListDistance)

{

string val = xn.LastChild.InnerText;

Response.Write("Distance : " + val.ToString());

}

return true;

}

Remove First and last comma from string in SQl

2016-11-07T20:58:00.001-08:00

Remove First and last comma from string in SQl

declare @Str nvarchar(max)=',kandy,'

if(right(rtrim(@Str),1) = ',')

begin

set @Str= substring(rtrim(@Str),1,len(rtrim(@Str))-1)

end

if(left(ltrim(@Str),1) = ',')

begin

set @Str=Substring(@Str, 2, (len(@Str)))

end

select @Str

Replace Enter key from string in Sql

2016-11-04T03:34:00.000-07:00

Replace Enter key from string in Sql

declare @C nvarchar(max)

set @C='kandy

deol'

select @C as WithEnterKey

select REPLACE(REPLACE(@C, CHAR(13), ''), CHAR(10), '') as WithOutEnterKey

Create and save QR code in asp.net with C#

2016-09-15T23:50:00.002-07:00

Create and save QR code in asp.net with C#

Download Dll from given link

https://drive.google.com/drive/folders/0B2VobjpburSGdFBaZzBZSEJic0E?usp=sharing

.Aspx Page

<form id="form1" runat="server">

        <asp:TextBox ID="txtInput" runat="server"></asp:TextBox>

        <asp:Button ID="btnGenerate" runat="server" Text="Generate" OnClick="btnGenerate_Click" />

        <hr />

        <asp:PlaceHolder ID="plQRCode" runat="server" />

    </form>

.Cs Page

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using QRCoder;

using System.IO;

using System.Drawing;

public partial class CS : System.Web.UI.Page

{

protected void btnGenerate_Click(object sender, EventArgs e)

{

string code = txtInput.Text;

QRCodeGenerator qrGenerator = new QRCodeGenerator();

QRCodeGenerator.QRCode qrCode = qrGenerator.CreateQrCode(code, QRCodeGenerator.ECCLevel.Q);

System.Web.UI.WebControls.Image imgBarCode = new System.Web.UI.WebControls.Image();

imgBarCode.Height = 250;

imgBarCode.Width = 250;

using (Bitmap bitMap = qrCode.GetGraphic(20))

{

using (MemoryStream ms = new MemoryStream())

{

bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png);

byte[] byteImage = ms.ToArray();

imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage);

string result = Convert.ToBase64String(byteImage, 0, byteImage.Length); ;

CreateImage(result.ToString());

}

plQRCode.Controls.Add(imgBarCode);

}

public string CreateImage(string Byt)

{

try

{

byte[] data = Convert.FromBase64String(Byt);

var filename = Convert.ToString(System.Guid.NewGuid()).Substring(0, 5) + Convert.ToString(System.Guid.NewGuid()).Substring(0, 5) + System.DateTime.Now.ToString("FFFFFF") + System.DateTime.Now.Minute + ".png";// +System.DateTime.Now.ToString("fffffffffff") + ".png";

var file = HttpContext.Current.Server.MapPath("~/AppImages/" + filename);

System.IO.File.WriteAllBytes(file, data);

string ImgName = ".../profileimages/" + filename;

return filename;

}

catch (Exception e)

{

return "Error";

}

It Will Look like :-

Create and Save Bar Code in asp.net with C#

2016-09-15T23:41:00.002-07:00

Create and Save Bar Code in asp.net with C#

Please download "IDAutomationHC39M" font online.

.Aspx Page :

<asp:TextBox ID=" txtInput " runat="server"></asp:TextBox>

<asp:Button ID="btnGenerate" runat="server" Text="Generate" OnClick="btnGenerate_Click" />

<hr />

<asp:PlaceHolder ID="plBarCode" runat="server" />

</form>

.Cs Page :

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Drawing;

using System.Drawing.Imaging;

using System.IO;

using OnBarcode.Barcode;

//using Zen.Barcode;

public partial class BarCode : System.Web.UI.Page

{

protected void btnGenerate_Click(object sender, EventArgs e)

{

string barCode = txtInput.Text;

System.Web.UI.WebControls.Image imgBarCode = new System.Web.UI.WebControls.Image();

using (Bitmap bitMap = new Bitmap(barCode.Length * 30, 60))

{

using (Graphics graphics = Graphics.FromImage(bitMap))

{

Font oFont = new Font("IDAutomationHC39M", 20);

//Font oFont = new Font("Code 3 de 9", 50);

//Font oFont = new Font("Code 128", 80);

//Font oFont = new Font("Code 2 of 5 interleaved", 40);

//Font oFont = new Font("barcode font", 70);

PointF point = new PointF(2f, 2f);

SolidBrush blackBrush = new SolidBrush(Color.Black);

SolidBrush whiteBrush = new SolidBrush(Color.White);

graphics.FillRectangle(whiteBrush, 0, 0, bitMap.Width, bitMap.Height);

graphics.DrawString("*" + barCode + "*", oFont, blackBrush, point);

}

using (MemoryStream ms = new MemoryStream())

{

bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png);

byte[] byteImage = ms.ToArray();

string result = Convert.ToBase64String(byteImage);

CreateImage(result.ToString());

imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage);

}

plBarCode.Controls.Add(imgBarCode);

}

public string CreateImage(string Byt)

{

try

{

byte[] data = Convert.FromBase64String(Byt);

var file = HttpContext.Current.Server.MapPath("~/AppImages/" + filename);

System.IO.File.WriteAllBytes(file, data);

string ImgName = ".../profileimages/" + filename;

return filename;

}

catch (Exception e)

{

return "Error";

}

It Will look like :

Auto Complete Textbox with ItemId in asp.net C#

2016-09-06T00:27:00.003-07:00

Auto Complete Textbox with ItemId in asp.net C#

Download References Js and .css form this link:-

https://drive.google.com/folderview?id=0B2VobjpburSGMmxJVXZUNlF5OWM&usp=sharing

.Aspx Page

<%--<script type="text/javascript" src="js/jquery.1.11.1.js"></script>--%>

var TotalCount = 1;

$(function () {

$("[id$=txtSearch]").autocomplete({

source: function (request, response) {

$.ajax({

url: '<%=ResolveUrl("AutoComplete.aspx/GetDetails") %>',

data: "{ 'prefix': '" + request.term + "'}",

dataType: "json",

type: "POST",

contentType: "application/json; charset=utf-8",

success: function (data) {

response($.map(data.d, function (item) {

return {

label: item.split('-')[0],

val: item.split('-')[1]

}

}))

error: function (response) {

alert(response.responseText);

failure: function (response) {

alert(response.responseText);

}

});

select: function (e, i) {

debugger;

alert(i.item.val);

minLength: 1

});

</script>

</head>

<body>

<div>

<asp:TextBox ID="txtSearch" runat="server" placeholder="Location" Style="color: black" />

</div>

</form>

</body>

</html>

.CS Page

[WebMethod]

public static string[] GetDetails(string prefix)

{

SQLHelper sq=new SQLHelper ();

List<string> customers = new List<string>();

using (SqlConnection conn = new SqlConnection())

{

conn.ConnectionString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

using (SqlCommand cmd = new SqlCommand())

{

cmd.CommandText = "select Area_ID, Area_name from area_master where Area_name like @SearchText + '%'";

cmd.Parameters.AddWithValue("@SearchText", prefix);

cmd.Connection = conn;

conn.Open();

using (SqlDataReader sdr = cmd.ExecuteReader())

{

while (sdr.Read())

{

customers.Add(string.Format("{0}-{1}", sdr["Area_name"], sdr["Area_ID"]));

}

conn.Close();

}

return customers.ToArray();

}

It Will look like :-

Bind Content of page on scrolling using asp.net c#

2016-09-05T22:35:00.003-07:00

Bind Content of page on scrolling using asp.net c#

.Aspx Page

$(function () {

InfiniteScroll();

});

function InfiniteScroll() {

$('#divPostsLoader').html('<img src="images/loader.gif">');

//send a query to server side to present new content

$.ajax({

type: "POST",

url: "scroll.aspx/GetData",

data: "{}",

contentType: "application/json; charset=utf-8",

dataType: "json",

success: function (data) {

if (data != "") {

debugger;

$('.divLoadData:last').after(data.d);

}

$('#divPostsLoader').empty();

}

})

};

$(window).scroll(function () {

if ($(window).scrollTop() == $(document).height() - $(window).height()) {

InfiniteScroll();

}

});

</script>

</head>

<body>

</div>

</form>

</body>

</html>

.CS Code :-

static int RecordCount, FirstCount = 0;

[WebMethod]

public static string GetData()

{

RecordCount = RecordCount + 10;

DataTable dt = new DataTable();

string Sql = "SELECT complaint_id,Cust_Lat_Code,Cust_Long_Code,Address FROM Complaint_Log WHERE Cust_Lat_Code IS NOT NULL ORDER BY complaint_id OFFSET " + FirstCount + " ROWS FETCH NEXT 10 ROWS ONLY";

FirstCount = RecordCount;

StringBuilder sb = new StringBuilder();

dt = new DataTable();

SQLHelper sq = new SQLHelper();

DataSet ds = sq.RunSqlReturnDs(Sql);

dt = ds.Tables[0];

DataView dv = dt.DefaultView;

foreach (DataRowView row in dv)

{

sb.AppendFormat("<p>lat " + " <strong>" + row["Cust_Lat_Code"] + "</strong>");

sb.AppendFormat("<p>Long" + " <strong>" + row["Cust_Long_Code"] + "</strong>");

sb.AppendFormat("<p>Address" + " <strong>" + row["Address"] + "</strong>");

sb.AppendFormat("<hr/>");

}

sb.AppendFormat("<divstyle='height:15px;'></div>");

return sb.ToString();

}

Read and Write XML in asp.net C#

2016-09-05T03:11:00.001-07:00

Read and Write XML in asp.net C#

//Create a datatable to store XML data

DataTable DT = new DataTable();

DT.Columns.Add("FirstName");

DT.Columns.Add("LastName");

DT.Columns.Add("Gender");

DT.Columns.Add("Age");

DT.Rows.Add(new object[] { "Sam", "deol", "male", 20 });

DT.Rows.Add(new object[] { "kandy", "deol", "male", 20 });

//Create a dataset

DataSet DS = new DataSet();

//Add datatable to this dataset

DS.Tables.Add(DT);

//Write dataset to XML file

DS.WriteXml(Server.MapPath("~/test.xml"));

DataSet ds1 = new DataSet();

ds1.ReadXml(Server.MapPath("~/test.xml"));

DataTable dt1 = ds1.Tables[0];

Convert DataTabel to Json in Asp.net

2015-04-07T04:01:00.000-07:00

Convert DataTabel to Json in Asp.net

protected void Page_Load(object sender, EventArgs e)

{

DataTable dt = DtTable();

string change = ReturnJSON(dt);

}

public DataTable DtTable()

{

DataTable table = new DataTable() { TableName = "Customer" };

DataColumn keyColumn = table.Columns.Add("Id", typeof(System.Int32));

table.Columns.Add("Name", typeof(System.String));

table.Columns.Add("Address", typeof(System.String));

table.PrimaryKey = new DataColumn[] { keyColumn };

table.Rows.Add(new object[] { 1, "Customer 1", "Address1" });

table.Rows.Add(new object[] { 2, "Customer 2", "Address2" });

table.Rows.Add(new object[] { 3, "Customer 3", "Address3" });

table.Rows.Add(new object[] { 4, "Customer 4", "Address4" });

table.Rows.Add(new object[] { 5, "Customer 5", "Address5" });

table.AcceptChanges();

return table;

}

public string ReturnJSON(DataTable dt)
{
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();

List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>();

Dictionary<string, object> row;

foreach (DataRow dr in dt.Rows)

{
row = new Dictionary<string, object>();

foreach (DataColumn col in dt.Columns)

{

row.Add(col.ColumnName, dr[col]);

}

rows.Add(row);

}
string ret = serializer.Serialize(rows);

return ret;

}

Call .Cs method on .Aspx Page

2015-03-25T00:09:00.003-07:00

Call .Cs method on .Aspx Page

Step 1: Method on .Cs page

public string GetFileName()

{

return "kandy";

}

Step 2: Calling from .aspx Page

$(document).ready(function () {

var Filename = '<%= GetFileName() %>';

debugger;

alert(Filename);

});

</script>

Convert DataTable to Xml and Vice-Versa

2015-02-08T22:30:00.003-08:00

Convert DataTable to Xml and Vice-Versa

protected void Page_Load(object sender, EventArgs e)

{

DataTable dt = DtTable();

string change = ConvertDatatableToXML(dt);

DataTable dtret = ConvertXMLtoDataTable(change);

}

public string ConvertDatatableToXML(DataTable dt)

{

MemoryStream str = new MemoryStream();

dt.WriteXml(str, true);

str.Seek(0, SeekOrigin.Begin);

StreamReader sr = new StreamReader(str);

string xmlstr;

xmlstr = sr.ReadToEnd();

return (xmlstr);

}

public DataTable DtTable()

{

DataTable table = new DataTable() { TableName = "Customer" };

DataColumn keyColumn = table.Columns.Add("Id", typeof(System.Int32));

table.Columns.Add("Name", typeof(System.String));

table.Columns.Add("Address", typeof(System.String));

table.PrimaryKey = new DataColumn[] { keyColumn };

table.Rows.Add(new object[] { 1, "Customer 1", "Address1" });

table.Rows.Add(new object[] { 2, "Customer 2", "Address2" });

table.Rows.Add(new object[] { 3, "Customer 3", "Address3" });

table.Rows.Add(new object[] { 4, "Customer 4", "Address4" });

table.Rows.Add(new object[] { 5, "Customer 5", "Address5" });

table.AcceptChanges();

return table;

}

public DataTable ConvertXMLtoDataTable(string status)

{

string response = status;

DataSet ds = new DataSet();

using (StringReader stringReader = new StringReader(response))

{

ds = new DataSet();

ds.ReadXml(stringReader);

}

DataTable RetDt = ds.Tables[0];

return RetDt;

}

Move cursor on next control on complete filled

2014-11-19T01:02:00.005-08:00

Move cursor on next control on complete filled

function ChangeControl(CurrentControl, NextControl) {

debugger;

if (CurrentControl.value.length >= CurrentControl.maxLength) {

document.getElementById(NextControl).focus();

}

</script>

.txtwidth

{

width: 40px;

}

</style>

</head>

<body>

<div>

Please Enter Card Number :     

<asp:TextBox ID="txt1" runat="server" MaxLength="4" onkeyup="ChangeControl(this, 'txt2')"

ClientIDMode="Static" CssClass="txtwidth"></asp:TextBox> 

<asp:TextBox ID="txt2" runat="server" MaxLength="4" onkeyup="ChangeControl(this, 'txt3')"

CssClass="txtwidth"></asp:TextBox> 

<asp:TextBox ID="txt3" runat="server" MaxLength="4" onkeyup="ChangeControl(this, 'txt4')"

CssClass="txtwidth"></asp:TextBox> 

<asp:TextBox ID="txt4" runat="server" MaxLength="4" CssClass="txtwidth" onkeyup="ChangeControl(this, 'txt5')"></asp:TextBox>

<br />

Please Confirm Card Number :

<asp:TextBox ID="txt5" runat="server" MaxLength="4" onkeyup="ChangeControl(this, 'txt6')"

ClientIDMode="Static" CssClass="txtwidth"></asp:TextBox> 

<asp:TextBox ID="txt6" runat="server" MaxLength="4" onkeyup="ChangeControl(this, 'txt7')"

CssClass="txtwidth"></asp:TextBox> 

<asp:TextBox ID="txt7" runat="server" MaxLength="4" onkeyup="ChangeControl(this, 'txt8')"

CssClass="txtwidth"></asp:TextBox> 

<asp:TextBox ID="txt8" runat="server" MaxLength="4" CssClass="txtwidth"></asp:TextBox>

</div>

</form>

</body>

</html>

It will look like :-

Convert first letter of word to Capital

2014-09-30T01:54:00.000-07:00

Convert first letter of word to Capital

function FirstCaps(id) {

var txt = document.getElementById(id);

txt.value = txt.value.replace(/\w\S*/g, function (txt) { return txt.charAt(0).toUpperCase() + txt.substr(1).toLowerCase(); });

}

</script>

</head>

<body>

<div>

<asp:TextBox ID="TextBox1" runat="server" onkeyup="FirstCaps(this.id)"></asp:TextBox>

</div>

</form>

</body>

</html>

It will look like

Create Alphabetic control and fetch its value on click in Asp.net c#

2014-09-24T02:43:00.001-07:00

Create Alphabetic control and fetch its value on click in Asp.net c#

Step 1:Desgin web form .aspx page

<div>

<asp:Panel ID="pnlAlphabate" runat="server" Style="border-color: Black; border-width: 1px;

border-style: solid; width: 200px; margin-bottom: 20px;">

</asp:Panel>

</div>

</form>

Step 2:Logic on .Cs page

protected void Page_Load(object sender, EventArgs e)

{

string str = "A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V, W, X, Y, Z, ALL";

string[] spt = str.Split(',');

foreach (string strAccountId in spt)

{

if (strAccountId.Trim() != string.Empty)

{

LinkButton lnkButton = new LinkButton();

lnkButton.Text = strAccountId;

lnkButton.ID = "lnkId" + strAccountId;

lnkButton.Attributes.CssStyle.Add("text-decoration", "none");

lnkButton.Click += new EventHandler(lnkButton_Click);

pnlAlphabate.Controls.Add(lnkButton);

}

void lnkButton_Click(object sender, EventArgs e)

{

string str = ((System.Web.UI.WebControls.LinkButton)(sender)).Text;

Response.Write(str);

}

It will look like :-

While loop with comma separated values in sql server

2014-07-03T05:51:00.004-07:00

While loop with comma separated values in sql server

DECLARE @valueList varchar(8000)

DECLARE @pos INT

DECLARE @len INT

DECLARE @value varchar(8000)

SET @valueList = 'sam,delhi,kandy,'

set @pos = 0

set @len = 0

WHILE CHARINDEX(',', @valueList, @pos+1)>0

BEGIN

set @len = CHARINDEX(',', @valueList, @pos+1) - @pos

set @value = SUBSTRING(@valueList, @pos, @len)

PRINT @value

set @pos = CHARINDEX(',', @valueList, @pos+@len) +1

END

How Can find Master page control on Derived Page in Asp.net

2014-06-23T02:18:00.002-07:00

How Can find Master page control on Derived Page in Asp.net

Logic On Derived Page :-

Label lblHeading = this.Master.FindControl("lblHeading") as Label;

if (lblHeading != null)

lblHeading.Text = "Kandy";

MS Captcha with refresh button in asp.net

2014-05-29T02:51:00.003-07:00

MS Captcha with refresh button in asp.net

Step 1: Design web from .aspx Page

<div>

<asp:ScriptManager ID="sm" runat="server">

</asp:ScriptManager>

<asp:UpdatePanel ID="up1" runat="server">

<cc1:CaptchaControl ID="Captcha1" runat="server" CaptchaBackgroundNoise="Low" CaptchaLength="6"

CaptchaHeight="80" CaptchaWidth="350" CaptchaLineNoise="None" CaptchaMinTimeout="5"

CaptchaMaxTimeout="240" FontColor="CadetBlue" />

<asp:LinkButton ID="lnkrefresh" runat="server" OnClick="_Click" Text="Refresh" CausesValidation="false"> </asp:LinkButton>

</ContentTemplate>

</asp:UpdatePanel>

</div>

<asp:TextBox ID="txtCaptcha" runat="server" Width="350px"></asp:TextBox>

<br />

<asp:Button ID="btn" runat="server" Text="Check" OnClick="btn_Click" BackColor="YellowGreen" />

<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="*Required"

ControlToValidate="txtCaptcha"></asp:RequiredFieldValidator>

<br />

<asp:Label ID="lblmsg" runat="server" Font-Names="Arial" Text=""></asp:Label>

</form>

Step 2: Logic on .Cs page.

protected void btn_Click(object sender, EventArgs e)

{

Captcha1.ValidateCaptcha(txtCaptcha.Text.Trim());

if (Captcha1.UserValidated)

{

lblmsg.ForeColor = System.Drawing.Color.Green;

lblmsg.Text = "Sucess";

}

else

{

lblmsg.ForeColor = System.Drawing.Color.Red;

lblmsg.Text = "Fail";

}

protected void _Click(object sender, EventArgs e)

{ }

It Will Look like :-

Change Tab order of controls inside Gridview

2014-05-19T22:52:00.000-07:00

Change Tab order of controls inside Gridview

Normally tab order for controls inside Gridview is always next from its previous control .
But in some scenario if you want to change tab order according to your requirement,you can use this approach.

Step 1: Design Web form .aspx page

<div>

<asp:GridView ID="gv" runat="server" AutoGenerateColumns="false"

BorderWidth="0" GridLines="None" CssClass="w100p grid form" OnRowDataBound="gv_RowDataBound" AlternatingRowStyle-BackColor="WhiteSmoke">

<asp:TemplateField HeaderText="#">

<%#Container.DataItemIndex+1 %>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="First Name">

<asp:TextBox ID="txtDbaName" runat="server" MaxLength="100" placeholder="First Name"></asp:TextBox>

<asp:HiddenField ID="hdAccountId" Value='<%# Bind("Name") %>' runat="server" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Last Name">

<asp:TextBox ID="txtLegalName" runat="server" MaxLength="100" placeholder="Last Name"></asp:TextBox>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Enrolment ID">

<asp:TextBox ID="txtTaxId" runat="server" MaxLength="9" placeholder="Enrolment ID"></asp:TextBox>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Address">

<asp:TextBox ID="txtAddress" runat="server" placeholder="Address" MaxLength="100"

ToolTip="Address"></asp:TextBox> 

<asp:TextBox ID="txtPhone" placeholder="Phone" class="small" runat="server" ToolTip="Phone"></asp:TextBox>

<br />

<asp:TextBox ID="txtCity" runat="server" placeholder="City" MaxLength="50" ToolTip="City"></asp:TextBox> 

<asp:DropDownList ID="drdState" runat="server" class="CustomDropDownSmallActivation">

</asp:DropDownList>

 <asp:TextBox ID="txtZip" runat="server" class="Zip" placeholder="Zip" MaxLength="10"

ToolTip="Zip"></asp:TextBox>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</div>

Step 2: Logic on .Cs page

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{ Bind_Gr(); }

}

public void Bind_Gr()

{

DataTable dt = new DataTable();

dt.Columns.Add("Name");

dt.Rows.Add("Kandy");

dt.Rows.Add("Sam");

dt.Rows.Add("Izhar");

dt.Rows.Add("Vineet");

gv.DataSource = dt;

gv.DataBind();

}

protected void gv_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

try

{

#region "Set Tabing"

DropDownList drdState = e.Row.FindControl("drdState") as DropDownList;

HiddenField hdStateId = e.Row.FindControl("hdStateId") as HiddenField;

TextBox dbaName = e.Row.FindControl("txtDbaName") as TextBox;

TextBox txtDbaName = (TextBox)e.Row.FindControl("txtDbaName");

TextBox txtLegalName = (TextBox)e.Row.FindControl("txtLegalName");

TextBox txtTaxId = (TextBox)e.Row.FindControl("txtTaxId");

TextBox txtAddress = (TextBox)e.Row.FindControl("txtAddress");

TextBox txtPhone = (TextBox)e.Row.FindControl("txtPhone");

TextBox txtCity = (TextBox)e.Row.FindControl("txtCity");

TextBox txtZip = (TextBox)e.Row.FindControl("txtZip");

int i = e.Row.RowIndex * 8;// here 8 is number of control

txtDbaName.Attributes.Add("tabindex", (i + 1).ToString());

txtLegalName.Attributes.Add("tabindex", (i + 2).ToString());

txtTaxId.Attributes.Add("tabindex", (i + 3).ToString());

txtAddress.Attributes.Add("tabindex", (i + 4).ToString());

txtCity.Attributes.Add("tabindex", (i + 5).ToString());

drdState.Attributes.Add("tabindex", (i + 6).ToString());

txtZip.Attributes.Add("tabindex", (i + 7).ToString());

txtPhone.Attributes.Add("tabindex", (i + 8).ToString());

if (e.Row.RowIndex == 0)

dbaName.Focus();

#endregion "Set Tabing"

}

catch (Exception ex)

{

throw ex;

}

It will look like :-

Count Number of Online user in Asp.net Application.

2014-05-14T23:07:00.001-07:00

Count Number of Online user in Asp.net Application.

For getting count of User in your application, you need to add Global.aspx File in your project.

After adding Global file just follow these simple 4 steps.

Step 1:- Application setting code in Global.asax

Global.asax

<%@ Application Language="C#" %>

<%@ Import Namespace="Telerik_controls_test" %>

void Application_Start(object sender, EventArgs e)

{

// Code that runs on application startup

Application["usercount"] = 0;

}

void Application_End(object sender, EventArgs e)

{

// Code that runs on application shutdown

}

void Application_Error(object sender, EventArgs e)

{

// Code that runs when an unhandled error occurs

}

void Session_Start(object sender, EventArgs e)

{

Application.Lock();

Application["usercount"] = (int)Application["usercount"] + 1;

Application.UnLock();

}

void Session_End(object sender, EventArgs e)

{

Application.Lock();

Application["usercount"] = (int)Application["usercount"] - 1;

Application.UnLock();

}

</script>

Step 2:- Design web form .aspx page

</head>

<body>

<div>

<asp:Label ID="lblno_of_user" runat="server"></asp:Label>

</div>

</form>

</body>

</html>

Step 3:- Logic on .Cs Page

protected void Page_Load(object sender, EventArgs e)

{

lblno_of_user.Text = "Count Login User: " +

Convert.ToString(Application["usercount"]);

}

Step 4:- Configuration in .Webconfig file

<system.web>

</system.web>

It will look like :-

Set Maxlength to Multiline Textbox using J-Query

2014-05-14T22:33:00.002-07:00

Set Maxlength to Multiline Textbox using J-Query

function Check(textBox, maxLength) {

if (textBox.value.length > maxLength) {

alert("You cannot enter more than " + maxLength + " characters.");

textBox.value = textBox.value.substr(0, maxLength);

}

</script>

</head>

<body>

<div>

<asp:TextBox ID="TxtNotes" runat="server" Rows="2" TextMode="MultiLine" Width="450px"

TabIndex="8" Height="100px" onkeyup="javascript:Check(this, 1000);" onchange="javascript:Check(this, 1000);"></asp:TextBox>

</div>

</form>

</body>

It will look like :-

Dropdown with checkbox List Control in Asp.net

2014-05-05T01:49:00.005-07:00

Dropdown with checkbox List Control in Asp.net

Step 1: Design Web form .aspx page

Css for Controls

.PnlDesign

{

background-color: #FFF;

border: 1px solid #8D8D8D;

min-height: 71px;

color: #333333 !important;

font-family: 'HelveticaNeueRegular' ,Arial,Helvetica,sans-serif !important;

font-size: 12px !important;

font-weight: normal !important;

line-height: 20px !important;

outline: medium none !important;

padding-left: 4px !important;

padding-top: 2px;

text-decoration: none !important;

text-indent: 0.01px;

text-overflow: "";

overflow: auto;

width: 110px !important;

float: left !important;

text-align: left !important;

}

.PnlDesign table

{

float: left !important;

}

.txtbox

{

background-image: url("Images/downArrowGray20.fw.png") !important;

background-position: 94px center !important;

background-repeat: no-repeat !important;

border-color: #8D8D8D #D9D9D9 #D9D9D9 #8D8D8D;

border-style: solid;

border-width: 1px;

color: #333333 !important;

font-family: 'HelveticaNeueRegular' ,Arial,Helvetica,sans-serif !important;

font-size: 12px !important;

font-weight: normal !important;

height: 20px !important;

line-height: 20px !important;

outline: medium none !important;

padding-left: 4px !important;

padding-top: 2px;

text-decoration: none !important;

text-indent: 0.01px;

text-overflow: "";

width: 90px !important;

padding-right: 20px !important;

}

</style>

<div>

<asp:ScriptManager ID="sm" runat="server">

</asp:ScriptManager>

<asp:TextBox ID="txtFO" Text="" runat="server" Style="cursor: Pointer;" ReadOnly="true"

onkeypress="return false;" CssClass="txtbox" Height="20px"></asp:TextBox>

<asp:Panel ID="PnlCust" runat="server" CssClass="PnlDesign">

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

</asp:CheckBoxList>

</asp:Panel>

<asp:PopupControlExtender ID="PceSelectCustomer" runat="server" TargetControlID="txtFO"

PopupControlID="PnlCust" Position="Bottom">

</asp:PopupControlExtender>

<asp:Button ID="Btn" runat="server" Text="Fetch Values" OnClick="Btn_Click" />

</div>

Step 2 : Logic on .Cs page

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

bind_CHkLIst();

}

public void bind_CHkLIst()

{

DataTable dt = new DataTable();

dt.Columns.Add("Id", typeof(int));

dt.Columns.Add("Name", typeof(string));

dt.Rows.Add(1, "Kandy");

dt.Rows.Add(2, "Sam");

dt.Rows.Add(3, "Delhi");

cblFOList.DataSource = dt;

cblFOList.DataTextField = "Name";

cblFOList.DataValueField = "Id";

cblFOList.DataBind();

txtFO.Text = "Select";

}

protected void Btn_Click(object sender, EventArgs e)

{

string Name = string.Empty;

string Id = string.Empty;

for (int i = 0; i < cblFOList.Items.Count; i++)

{

if (cblFOList.Items[i].Selected == true)

{

Name += cblFOList.Items[i].Text.ToString() + ",";

Id += cblFOList.Items[i].Value.ToString() + ",";

}

Response.Write(Name);

Response.Write(Id);

}

Kandy Steps

Send simple notification to Android

Send simple notification to Android

Post Data on URL using Asp.net C#

Post Data on URL using Asp.net C

C# code :

Send Fire base notification to Android using Asp.net C#

Send Fire base notification to Android using Asp.net C#

C# Code :

Post data and Redirect on URL in Asp.net

Post data and Redirect on URL in Asp.net

Get Real Time Distance and ETA in asp.net using Google API

Get Real Time Distance and ETA in asp.net using Google API

C# Code :

Remove First and last comma from string in SQl

Remove First and last comma from string in SQl

Replace Enter key from string in Sql

Replace Enter key from string in Sql

Create and save QR code in asp.net with C#

Create and save QR code in asp.net with C#

.Aspx Page

<form id="form1" runat="server"> <asp:TextBox ID="txtInput" runat="server"></asp:TextBox> <asp:Button ID="btnGenerate" runat="server" Text="Generate" OnClick="btnGenerate_Click" /> <hr /> <asp:PlaceHolder ID="plQRCode" runat="server" /> </form> .Cs Page

It Will Look like :-

Create and Save Bar Code in asp.net with C#

Create and Save Bar Code in asp.net with C#

.Aspx Page :

.Cs Page :

It Will look like :

Auto Complete Textbox with ItemId in asp.net C#

Auto Complete Textbox with ItemId in asp.net C#

.Aspx Page

.CS Page

It Will look like :-

Bind Content of page on scrolling using asp.net c#

Bind Content of page on scrolling using asp.net c#

.CS Code :-

Read and Write XML in asp.net C#

Read and Write XML in asp.net C#

Convert DataTabel to Json in Asp.net

Convert DataTabel to Json in Asp.net

Call .Cs method on .Aspx Page

Call .Cs method on .Aspx Page

Step 1: Method on .Cs page

Step 2: Calling from .aspx Page

Convert DataTable to Xml and Vice-Versa

Move cursor on next control on complete filled

Move cursor on next control on complete filled

It will look like :-

Convert first letter of word to Capital

Convert first letter of word to Capital

It will look like

Create Alphabetic control and fetch its value on click in Asp.net c#

Create Alphabetic control and fetch its value on click in Asp.net c#

Step 1:Desgin web form .aspx page

Step 2:Logic on .Cs page

It will look like :-

While loop with comma separated values in sql server

While loop with comma separated values in sql server

How Can find Master page control on Derived Page in Asp.net

How Can find Master page control on Derived Page in Asp.net

Logic On Derived Page :-

MS Captcha with refresh button in asp.net

MS Captcha with refresh button in asp.net

Step 1: Design web from .aspx Page

Step 2: Logic on .Cs page.

It Will Look like :-

Change Tab order of controls inside Gridview

Change Tab order of controls inside Gridview

Normally tab order for controls inside Gridview is always next from its previous control .But in some scenario if you want to change tab order according to your requirement,you can use this approach.

Step 1: Design Web form .aspx page

Step 2: Logic on .Cs page

It will look like :-

Count Number of Online user in Asp.net Application.

Count Number of Online user in Asp.net Application.

Step 1:- Application setting code in Global.asax

Global.asax

Step 2:- Design web form .aspx page

Step 3:- Logic on .Cs Page

Step 4:- Configuration in .Webconfig file

It will look like :-

<form id="form1" runat="server">

<asp:TextBox ID="txtInput" runat="server"></asp:TextBox>

<asp:Button ID="btnGenerate" runat="server" Text="Generate" OnClick="btnGenerate_Click" />

<hr />

<asp:PlaceHolder ID="plQRCode" runat="server" />

</form>

.Cs Page

Normally tab order for controls inside Gridview is always next from its previous control .
But in some scenario if you want to change tab order according to your requirement,you can use this approach.