dotnet: May 2014

Tuesday, 27 May 2014

Saturday, 24 May 2014

How to Bind Country, State, City using Ajax Update Panel

http://www.c-sharpcorner.com/uploadfile/rohatash/dropdownlist-with-country-state-and-city-in-asp-net/http://www.c-sharpcorner.com/uploadfile/c210df/how-to-bind-country-state-city-using-ajax-update-panel/

Monday, 19 May 2014

SQL Joins with C# LINQ

http://www.dotnet-tricks.com/Tutorial/linq/UXPF181012-SQL-Joins-with-C

http://www.dotnetperls.com/join

Sunday, 18 May 2014

1).Solution Exporer----------> Create Bin Folder----->Right Click the Bin folder----> Add Reference......> Browse----->Add 'AjaxControlToolkit'

2)In aspx design source file,
Add Register Directive as below
<%@ Register %>

3)Then within the <%@ Register %> add Tag Prefix, Assembly, NameSpace ....

4) <%@ Register TagPrefix="SRI" Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" %>

5) Assembly---> Simply Goto Solution Explorer---> Bin ----> AjaxControlToolkit.dll then copy the AjaxControlToolkit and then give that name to Assembly and Name space...

6) Add the Script Manager in aspx page

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

</asp:ScriptManager>

7) Add the UpdatePanel , then ContentTemplate and Within the contentTemplate add the controls as below

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

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

<SRI:FilteredTextBoxExtender ID="TextBox1_FilteredTextBoxExtender"

runat="server" Enabled="True" TargetControlID="TextBox1">

</SRI:FilteredTextBoxExtender>

</ContentTemplate>

</asp:UpdatePanel>

Friday, 16 May 2014

Stored procedure with output parameter in sql server

CREATE TABLE [dbo].[userinformation](

[Uid] [int] IDENTITY(1,1) PRIMARY KEY,

[UserName] [varchar](50) NULL,

[Password] [varchar](50) NULL,

[FirstName] [varchar](50) NULL,

[LastName] [varchar](50) NULL,

[Email] [varchar](50) NULL,

[PhoneNo] [varchar](50) NULL,

[Location] [varchar](50) NULL,

[CreatedBy] [varchar](50) NULL,

[Error] [varchar](50) NULL

)

CREATE proc [dbo].[sp_userinformation]

(

@UserName varchar(20),

@Password varchar(20),

@FirstName varchar(20),

@LastName varchar(20),

@Email varchar(20),

@PhoneNo varchar(20),

@Location varchar(20),

@CreatedBy varchar(20),

@ERROR VARCHAR(30) OUT

)

BEGIN

SET NOCOUNT ON;

if not exists(select *from userinformation where UserName=@UserName)

begin

INSERT INTO userinformation (UserName,Password,FirstName,LastName,Email,PhoneNo,Location,CreatedBy)values(@UserName,@Password,@FirstName,@LastName,@Email,@PhoneNo,@Location,@CreatedBy)

set @ERROR=@UserName + 'Registered Successfully'

END

else

set @ERROR=@UserName + 'Already exists'

end

protected void btnsubmit_Click(object sender, EventArgs e)

{

string message = "";

if (txtpwd.Text == txtcnmpwd.Text)

{

cmd = new SqlCommand("sp_userinformation", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@UserName", txtuser.Text);

cmd.Parameters.AddWithValue("@Password ", txtpwd.Text);

cmd.Parameters.AddWithValue("@FirstName", txtfname.Text);

cmd.Parameters.AddWithValue("@LastName", txtlname.Text);

cmd.Parameters.AddWithValue("@Email", txtEmail.Text);

cmd.Parameters.AddWithValue("@PhoneNo", txtphone.Text);

cmd.Parameters.AddWithValue("@Location", txtlocation.Text);

cmd.Parameters.AddWithValue("@CreatedBy", txtuser.Text);

cmd.Parameters.Add("@ERROR", SqlDbType.Char, 30);

cmd.Parameters["@ERROR"].Direction = ParameterDirection.Output;

con.Open();

cmd.ExecuteNonQuery();

message = (string)cmd.Parameters["@ERROR"].Value;

con.Close();

}

else

{

Page.RegisterStartupScript("UserMsg", "<Script language='javascript'>alert('" + "Password mismatch" + "');</script>");

}

lblErrorMsg.Text = message;

}

<tr>

</td>

<b>Registration Form</b>

</td>

</tr>

<tr>

<asp:Label ID="lbluser" runat="server" Text="Username"></asp:Label>

</td>

<td>

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

</td>

</tr>

<tr>

<asp:Label ID="lblpwd" runat="server" Text="Password"></asp:Label>

</td>

<td>

<asp:TextBox ID="txtpwd" runat="server" TextMode="Password"></asp:TextBox>

</td>

</tr>

<tr>

<asp:Label ID="lblcnfmpwd" runat="server" Text="Confirm Password"></asp:Label>

</td>

<td>

<asp:TextBox ID="txtcnmpwd" runat="server" TextMode="Password"></asp:TextBox>

</td>

</tr>

<tr>

<asp:Label ID="lblfname" runat="server" Text="FirstName"></asp:Label>

</td>

<td>

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

</td>

</tr>

<tr>

<asp:Label ID="lbllname" runat="server" Text="LastName"></asp:Label>

</td>

<td>

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

</td>

</tr>

<tr>

<asp:Label ID="lblemail" runat="server" Text="Email"></asp:Label>

</td>

<td>

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

</td>

</tr>

<tr>

<asp:Label ID="lblCnt" runat="server" Text="Phone No"></asp:Label>

</td>

<td>

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

</td>

</tr>

<tr>

<asp:Label ID="lbladd" runat="server" Text="Location"></asp:Label>

</td>

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

</td>

</tr>

<tr>

 </td>

 </td>

</tr>

<tr>

<td align="left" ><asp:Button ID="btnsubmit" runat="server" Text="Save"

onclick="btnsubmit_Click" />

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

LINQ INSERT UPDATE DELETE IN GRIDVIEW

public class Empp

{

public int ID{get;set;}

public string UserName{get;set;}

public string Pass { get; set; }

public string Gender { get; set; }

public string Email { get; set; }

}

public List<Empp> Filldata()

{

DataClassesDataContext obj = new DataClassesDataContext();

var s = from a in obj.Employees

select new Empp

{

UserName=a.UserName,

Gender=a.Gender,

Pass=a.Pass,

ID=a.ID,

Email=a.Email

};

return s.ToList();

}

public void k()

{

GridView1.DataSource = Filldata();

GridView1.DataBind();

}

protected void Btn_Save_Click(object sender, EventArgs e)

{

DataClassesDataContext obj = new DataClassesDataContext();

if (Btn_Save.Text == "Save")

{

Employee tblem = new Employee();

int Id = 0;

if (tblem.ID == 0)

{

tblem.UserName = txt_User.Text;

tblem.Pass = txt_Pwd.Text;

tblem.Email = txt_Email.Text;

tblem.Gender = DDL_Gender.SelectedItem.Text;

obj.Employees.InsertOnSubmit(tblem);

obj.SubmitChanges();

k();

}

else

{

DataClassesDataContext obj1 = new DataClassesDataContext();

int Empid=Convert.ToInt32(Session["ID"]);

Employee tblemp = new Employee();

tblemp= obj1.Employees.Where(s => s.ID == Empid).FirstOrDefault();

if (tblemp != null)

{

tblemp.UserName = txt_User.Text;

tblemp.Pass = txt_Pwd.Text;

tblemp.Email = txt_Email.Text;

tblemp.Gender = DDL_Gender.SelectedItem.Text;

obj1.SubmitChanges();

k();

}

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)

{

if (e.CommandName == "Edit")

{

int index = Convert.ToInt32(e.CommandArgument);

Session["ID"] = GridView1.DataKeys[index].Value.ToString();

txt_User.Text = GridView1.Rows[index].Cells[0].Text.Trim();

txt_Pwd.Text = GridView1.Rows[index].Cells[1].Text.Trim();

txt_Email.Text = GridView1.Rows[index].Cells[2].Text.Trim();

DDL_Gender.SelectedItem.Text = GridView1.Rows[index].Cells[3].Text.Trim();

Btn_Save.Text = "Update";

}

else if (e.CommandName == "Delete")

{

DataClassesDataContext obj = new DataClassesDataContext();

int index = Convert.ToInt32(e.CommandArgument);

Session["ID"] = GridView1.DataKeys[index].Value.ToString();

int id = Convert.ToInt32(Session["ID"].ToString());

Employee th = new Employee();

var ss=(from a in obj.Employees.Where(s=>s.ID== id) select a).FirstOrDefault();

obj.Employees.DeleteOnSubmit(ss);

obj.SubmitChanges();

k();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

}

dotnet

Thursday, 29 May 2014

Constructor, Static Class

Abstract Class, Interface, Partial Class

Tuesday, 27 May 2014

Triggers-sql-server

Saturday, 24 May 2014

How to Bind Country, State, City using Ajax Update Panel

Monday, 19 May 2014

SQL Joins with C# LINQ

Sunday, 18 May 2014

Preleminary of Ajax

Friday, 16 May 2014

Stored procedure with output parameter in sql server

LINQ INSERT UPDATE DELETE IN GRIDVIEW