Learn C# ASP.NET MVC WCF SQL Angular

Sunday, May 22, 2016

Insert Update Delete In GridView in asp.net c# using stored procedure

In this article , I am going to explain how to insert , update and delete in grid view using stored procedure.

For these operation we require a table, the given below code snippet for creating table in sql.

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[userdtl](

[Id] [int] IDENTITY(1,1) NOT NULL,

[Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Age] [int] NULL,

[Department] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

PRIMARY KEY CLUSTERED

(

[Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

Now, given below aspx code copy in your aspx page

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<legend>Add/Edit Employee</legend>

<table>

<tr>

<td>Employee Name:</td>

<asp:HiddenField ID="hdnid" runat="server" />

</td>

</tr>

<tr>

<td>Employee Age:</td>

</tr>

<tr>

<td>Employee Department:</td>

</tr>

<tr>

<asp:Button ID="btnSave" runat="server" Text="Save" onclick="btnSave_Click" />

<asp:Label ID="lblErrormsg" runat="server" ForeColor="Red"></asp:Label>

<asp:Label ID="lblSuccessmsg" runat="server" ForeColor="Green"></asp:Label>

</td>

</tr>

</table>

</fieldset>

<legend>Emp Detail</legend>

<asp:GridView ID="gvempdtl" runat="server" AutoGenerateColumns="False"

BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px"

CellPadding="3">

<asp:TemplateField HeaderText="Id">

<asp:Label ID="lblId" runat="server" Text='<%#Eval("Id") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Name">

<asp:Label ID="lblName" runat="server" Text='<%#Eval("Name") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Age">

<asp:Label ID="lblAge" runat="server" Text='<%#Eval("Age") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Department">

<asp:Label ID="lblDepartment" runat="server" Text='<%#Eval("Department") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField>

<asp:Button ID="btnEdit" runat="server" Text="Edit" onclick="btnEdit_Click"/>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField>

<asp:Button ID="btnDelete" runat="server" Text="Delete" onclick="btnDelete_Click" OnClientClick="return confirm('Are you sure, you want to delete');"/>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</fieldset>

</form>

</body>

</html>

Then , copy the give below cs code in your aspx.cs file.

using System;

using System.Data;

using System.Data.SqlClient;

using System.Web.UI.WebControls;

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

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindEmployeeDeatil();

}

private void BindEmployeeDeatil()

{

SqlConnection con = new SqlConnection("Data Source=.;Persist Security Info=True;User ID=sa;Password=pramod");

con.Open();

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

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@mode", "S");

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

if (ds != null && ds.Tables.Count > 0)

{

gvempdtl.DataSource = ds.Tables[0];

gvempdtl.DataBind();

}

private void Reset()

{

hdnid.Value = string.Empty;

txtname.Text = string.Empty;

txtdept.Text = string.Empty;

txtAge.Text = string.Empty;

btnSave.Text = "Save";

BindEmployeeDeatil();

}

protected void btnSave_Click(object sender, EventArgs e)

{

try

{

lblSuccessmsg.Text = string.Empty;

lblErrormsg.Text = string.Empty;

string mode, Id = string.Empty;

if (string.IsNullOrEmpty(hdnid.Value))

{

mode = "I";

Id = "0";

}

else

{

mode = "U";

Id = hdnid.Value;

}

SqlConnection con = new SqlConnection("Data Source=.;Persist Security Info=True;User ID=sa;Password=pramod");

con.Open();

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

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@mode", mode);

cmd.Parameters.AddWithValue("@Id", Id);

cmd.Parameters.AddWithValue("@Name", txtname.Text);

cmd.Parameters.AddWithValue("@Age", txtAge.Text);

cmd.Parameters.AddWithValue("@Department", txtdept.Text);

int result = cmd.ExecuteNonQuery();

if (result > 0)

{

if (btnSave.Text.Trim() == "Save")

{

lblSuccessmsg.Text = "Saved Successfully";

}

else if (btnSave.Text.Trim() == "Update")

{

lblSuccessmsg.Text = "Updated Successfully";

}

Reset();

}

else

{

lblErrormsg.Text = "Please Contact to Administrator";

}

catch (Exception ex)

{

lblErrormsg.Text = ex.Message;

}

protected void btnEdit_Click(object sender, EventArgs e)

{

try

{

lblSuccessmsg.Text = string.Empty;

lblErrormsg.Text = string.Empty;

Button btn = sender as Button;

GridViewRow row = (GridViewRow)btn.NamingContainer;

hdnid.Value = (row.FindControl("lblId") as Label).Text;

txtname.Text = (row.FindControl("lblName") as Label).Text;

txtAge.Text = (row.FindControl("lblAge") as Label).Text;

txtdept.Text = (row.FindControl("lblDepartment") as Label).Text;

btnSave.Text = "Update";

}

catch (Exception ex)

{

lblErrormsg.Text = ex.Message;

}

protected void btnDelete_Click(object sender, EventArgs e)

{

try {

lblSuccessmsg.Text = string.Empty;

lblErrormsg.Text = string.Empty;

Button btn = sender as Button;

GridViewRow row = (GridViewRow)btn.NamingContainer;

SqlConnection con = new SqlConnection("Data Source=.;Persist Security Info=True;User ID=sa;Password=pramod");

con.Open();

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

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@mode", "D");

cmd.Parameters.AddWithValue("@Id", (row.FindControl("lblId") asLabel).Text);

int result = cmd.ExecuteNonQuery();

if (result > 0)

{

lblSuccessmsg.Text = "Deleted Successfully";

Reset();

}

else {

lblErrormsg.Text = "Please Contact to Administrator";

}

catch (Exception ex)

{

lblErrormsg.Text = ex.Message;

}

Now run your website, Output is

Thursday, May 19, 2016

Show or Hide div on checkbox click JavaScript

In this article, I am going to explain how to div show and hide on checkbox click in ASP. Net using JavaScript

Suppose You have a checkbox with the name of "chkselect" and you want to show or hide div on checkbox click , Here aspx code which provide you such facility

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

function showhide() {

var select = document.getElementById("chkselect");

if (select.checked) {

document.getElementById("showhide").setAttribute("style", "display:inline");

}

else {

document.getElementById("showhide").setAttribute("style", "display:none");

}

</script>

</head>

<body>

<asp:CheckBox ID="chkselect" runat="server" onchange="return showhide();"/>

</fieldset>

<span style="color:Red">Welcome at http://www.dotnetdarpan.blogspot.com/</span>

</div>

</form>

</body>

</html>

Output

Wednesday, May 18, 2016

Code for forgot password using ADO.Net and C#

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace WindowsFormsApplication21

{

public partial class Form2 : Form

{

public Form2()

{

InitializeComponent();

}

SqlDataAdapter da;

DataSet ds;

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)

{

comboBox1.Items.Add("nickname");

}

private void Form2_Load(object sender, EventArgs e)

{

da = new SqlDataAdapter("select * from login1", "data source=MKS-PC\\SQLEXPRESS;Initial Catalog=master;integrated security=true");

ds = new DataSet();

da.Fill(ds);

}

private void button1_Click(object sender, EventArgs e)

{

bool b = true;

foreach (DataRow dr in ds.Tables[0].Rows)

{

if (dr[0].ToString().Trim() == textBox1.Text && dr[3].ToString().Trim() == textBox2.Text)

{

MessageBox.Show(dr[1].ToString());

b = false;

}

if (b)

{

MessageBox.Show("Wrong uid or ans");

}

Output

Click on "forgetpassword" button a new window will be open now fill "uid","select ques", "ans" Information and click on submit button

Tuesday, May 17, 2016

Print DIV content using JavaScript in asp.net

In this article I am going to explain how to print div content in ASP. net c#

Code of aspx page to print div

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<table>

<tr>

<td style="padding:10px; color:#FF99CC; font-size:14px; font-weight:bold;">Hello ! Welcome at www.dotnetDarpan.blogspot.com</td>

</tr>

<tr>

<td>Note: For any query mail us on <b>gupta.sharad2010@gmail.com</b></td>

</tr>

</table>

</div>

<asp:Button ID="btnPrint" Text="Print" runat="server" OnClientClick="PrintDiv();"/>

</form>

function PrintDiv() {

var PrintDiv = document.getElementById("PrintDiv").innerHTML;

var printWindow = window.open('', '', 'height=200,width=400');

printWindow.document.write('<html><head><title>DIV Print DEMO</title>');

printWindow.document.write('</head><body >');

printWindow.document.write(PrintDiv);

printWindow.document.write('</body></html>');

printWindow.document.close();

printWindow.print();

}

</script>

</body>

</html>

Function to print div

function PrintDiv() {

var PrintDiv = document.getElementById("PrintDiv").innerHTML;

var printWindow = window.open('', '', 'height=200,width=400');

printWindow.document.write('<html><head><title>DIV Print DEMO</title>');

printWindow.document.write('</head><body >');

printWindow.document.write(PrintDiv);

printWindow.document.write('</body></html>');

printWindow.document.close();

printWindow.print();

}

</script>

Output

Monday, May 16, 2016

AcceptChanges and Rejectchanges

Acceptchanges –

We can accept the changes by using AcceptChanges method of the DataRow, Datatable and dataset , this method set the current row value to be original value and also acceptchanges method accept all the changes for entire datatable.

Syntax of the Acceptchanges

ds.Tables[0].Rows[0].AcceptChanges();

RejectChanges –

By using the Rejectchanges method to the datarow the old value become discard .

Syntax of the Rejectchanges

ds.Tables[0].Rows[0].Rejectchanges();