Pabitra@Microsoft.Research

Monday, 28 August 2017

Jquery : asp.net button click event in Jquery

<asp:Button ID="btnSave" runat="server" Text="Submit" />

<script type="text/javascript" language="javascript">
$(document).ready(function()
{
$('#<%= btnSave.ClientID %>').click(function(e)
{
return true;
});
});
</script>

Thursday, 24 August 2017

calling dropdownlist SelectedIndexChanged inside user define function in asp.net c#

void LoadPersonalDetail(string Emp_Id)
{
DataTable dtData = new DataTable();
dtData = new BLL().FillDataTable("select * from Mst_Emp where Emp_Code='"+Emp_Id+"'");
BindCountry();
ddlCountry.SelectedValue = dtData .Rows[0]["Country_Id"].ToString();
object sender=new object();
EventArgs e=new EventArgs();
ddlCountry_SelectedIndexChanged(sender,e);// for bind state
ddlState.SelectedValue = dtData .Rows[0]["State_Id"].ToString();

}

Tuesday, 22 August 2017

alter column size in sql query

I have a table with name "Mst_Student" having column Name with length 20 and I want to increase size
upto 50 below is the code I write in sql interface

ALTER TABLE Mst_Student
ALTER COLUMN Name varchar(50)

Tuesday, 1 August 2017

save image in image datatype in asp.net , using byte array ado.net

Here is the data table what I prepare .

create table tblStudent
(id int primary key identity(1,1),St_Photo image)

select * from tblStudent
SELECT St_Photo FROM tblStudent WHERE Id =1

DESIGN

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="SaveImage.aspx.cs" Inherits="SaveImage" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title></title>

</head>

<body>

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

<asp:FileUpload ID="fuPhoto" runat="server" />

<br />

<asp:HiddenField runat="server" ID="hfPhoto" Value="" />

<asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="btnSubmit_Click" />  

<asp:Button ID="btnShow" runat="server" Text="Show" OnClick="btnShow_Click" />

<asp:Image ID="imgShow" runat="server" />

</form>

</body>

</html>

CODE:

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

using System.IO;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

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

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnSubmit_Click(object sender, EventArgs e)

{

if (fuPhoto.HasFile)

{

byte[] bytesPhoto = null;

Stream fs = fuPhoto.PostedFile.InputStream;

BinaryReader br = new BinaryReader(fs);

bytesPhoto = br.ReadBytes(Convert.ToInt32(fs.Length));

SqlConnection sql = new SqlConnection(@"server=.;uid=sa;pwd=nic;database=master;");

sql.Open();

SqlCommand cmd = new SqlCommand("insert into tblStudent(St_Photo)values(@St_Photo)", sql);

cmd.Parameters.Add("@St_Photo", SqlDbType.Image).Value = bytesPhoto;

cmd.ExecuteNonQuery();

sql.Close();

}

protected void btnShow_Click(object sender, EventArgs e)

{

DataTable dt = new DataTable();

SqlConnection con = new SqlConnection(@"server=.;uid=sa;pwd=nic;database=master;");

con.Open();

SqlDataAdapter sda = new SqlDataAdapter("SELECT St_Photo FROM tblStudent WHERE Id =1",con);

sda.Fill(dt);

con.Open();

byte[] bytes = (byte[])dt.Rows[0][0];

string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);

imgShow.ImageUrl = "data:image/png;base64," + base64String;

}

Friday, 28 July 2017

sql query to get table definition

sp_help 'tableName'
example : sp_help 'Category'

OR

select Table i.e.
Category
and press Alt+F1

OR

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Category'

OR Customize query

SELECT COLUMN_NAME as 'Column', DATA_TYPE as 'Data Type', CHARACTER_MAXIMUM_LENGTH as 'Max Length' ,IS_NULLABLE as 'IS Null Status'
FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Category'

What is test or testing ?

In general testing is a process to find out how well something works. In computer software its mean that whether the object is same as the analysis is done before developing the software or the list of functionality is working properly and giving the proper out put or not.

Tuesday, 25 July 2017

c# :string reverse

Using pure c#

string StrInput ="PABITRA";
string StrReverse = "";
int Len = StrInput.Length - 1;
for (int i = Len; i>=0; i--)
StrReverse = StrReverse + StrInput[i];
//Console.Write(StrReverse);
//Console.ReadLine();

Response.Write(StrReverse);

OR

string StrInput ="PABITRA";
string StrReverse = "";
int Len = StrInput.Length - 1;
while (Len >= 0)
{
StrReverse = StrReverse + StrInput[Len]; Len--;
}
//Console.Write(StrReverse);
//Console.ReadLine();

Response.Write(StrReverse);

Using IEnumerable
IEnumerable<char> c = "pabitra".Reverse();
string rev = string.Empty;
foreach (var v in c)
{
if (rev == string.Empty)
rev = v + "\n";
else
rev = rev + v + "\n";

}
Console.Write(rev);
Console.ReadLine();

OR

Using Linq
string reverse = string.Join(" ", "pabitra".Split(' ').Select(x => new string(x.Reverse().ToArray())));
Console.Write(reverse);
Console.ReadLine();