C# , Asp.net, SQL Server, .Net , CSS, HTML

Tuesday, October 16, 2018

Calculate Due and Advance amount in ASP.NET C#

HTML

Total Amount :

<asp:TextBox ID="txtTotalAmount" runat="server" AutoPostBack="true"

ontextchanged="txtTotalAmount_TextChanged"></asp:TextBox><br /><br />

Paid Amount : <asp:TextBox ID="txtPaidAmount" runat="server" AutoPostBack="true"

ontextchanged="txtTotalAmount_TextChanged"></asp:TextBox><br /><br />

Due Amount : <asp:TextBox ID="txtDueAmount" runat="server" AutoPostBack="true"

ontextchanged="txtTotalAmount_TextChanged"></asp:TextBox><br /><br />

Advance Amount : <asp:TextBox ID="txtAdvanceAmount" runat="server" AutoPostBack="true"

ontextchanged="txtTotalAmount_TextChanged"></asp:TextBox><br /><br />

C# Code

protected void txtTotalAmount_TextChanged(object sender, EventArgs e)

{

try

{

decimal a=0, b=0, c = 0, d=0;

if (txtTotalAmount.Text != "")

{

a = Convert.ToDecimal(txtTotalAmount.Text);

}

if (txtPaidAmount.Text != "")

{

b = Convert.ToDecimal(txtPaidAmount.Text);

}

if (a > b)

{

c = a - b;

d = 0;

txtDueAmount.Text = c.ToString();

txtAdvanceAmount.Text = d.ToString();

}

else

{

if (a < b)

{

d = b - a;

c = 0;

txtDueAmount.Text = c.ToString();

txtAdvanceAmount.Text = d.ToString();

}

else

{

c = 0;

d = 0;

txtDueAmount.Text = c.ToString();

txtAdvanceAmount.Text = d.ToString();

}

catch (Exception)

{

}

Saturday, October 13, 2018

Bind Drop Down List With Month Name and Year without Database Using ASP.NET C#

HTML

<asp:DropDownList ID="ddlMonthName" runat="server" class="form-control">

</asp:DropDownList>

<asp:DropDownList ID="ddlYearsList" runat="server" class="form-control">

</asp:DropDownList>

C# Code

using System.Globalization;

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

//Month Name

var months = CultureInfo.CurrentCulture.DateTimeFormat.MonthNames;

for (int i = 0; i < months.Length; i++)

{

ddlMonthName.Items.Add(new ListItem(months[i], i.ToString()));

}

// Year List

for (int i = DateTime.Now.Year; i >= 2014; i--)

{

ddlYearsList.Items.Add(i.ToString());

}

ddlYearsList.Text = DateTime.Now.ToString("yyyy");

}

Friday, October 12, 2018

how to add year in drop down from past 2 year till present year in asp.net c#

HTML

<asp:DropDownList ID="ddlYear" runat="server" >
</asp:DropDownList>

c# code

protected void Page_Load(object sender, EventArgs e)
{

if (!Page.IsPostBack)
{
for (int i = DateTime.Now.Year; i >= 2016; i--)
{
ddlYear.Items.Add(i.ToString());

}
ddlYear.Text = DateTime.Now.ToString("yyyy");
}
}

Thursday, October 11, 2018

print div in javascript , print div content using jquery

javascript

<html>

<head>

<title>Print div content using jquery</title>

function PrintDiv() {

var contents = document.getElementById("dvContents").innerHTML;

var frame1 = document.createElement('iframe');

frame1.name = "frame1";

frame1.style.position = "absolute";

frame1.style.top = "-1000000px";

document.body.appendChild(frame1);

var frameDoc = frame1.contentWindow ? frame1.contentWindow : frame1.contentDocument.document ? frame1.contentDocument.document : frame1.contentDocument;

frameDoc.document.open();

frameDoc.document.write('<html><head>');

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

//Append the external CSS file.

//frameDoc.document.write('<link href="css/font-awesome.css" rel="stylesheet">');

frameDoc.document.write('<link href="css/style.css" rel="stylesheet" type="text/css" />');

frameDoc.document.write('<link href="css/tabletrtd.css" rel="stylesheet" type="text/css" />');

// frameDoc.document.write('<link href="css/bootstrap.min.css" rel="stylesheet" type="text/css" />');

frameDoc.document.write(contents);

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

frameDoc.document.close();

setTimeout(function () {

window.frames["frame1"].focus();

window.frames["frame1"].print();

document.body.removeChild(frame1);

}, 500);

return false;

}

</script>

</head>

<body>

<div id="dvContents">

<h2>

Print div content using jquery

</h2>

<p>

C# Soft Code

</p>

</div>

<input type="button" id="btnPrint" value="Print" onclick="PrintDiv();" class="btn btn-xs btn-success warning_4" /></div>

</body>

</html>

Sunday, October 7, 2018

how to add new row in gridview in asp.net dynamically using c#

HTML

1.Add new row Gridview

<asp:Label ID="lblError2" runat="server" ForeColor="red"></asp:Label>

<asp:GridView runat="server" ID="GridView2" AlternatingRowStyle-BackColor="#cccccc"

ShowFooter="true" AutoGenerateColumns="false" Width="100%">

<asp:BoundField DataField="RowNumber" HeaderText="Serial No" HeaderStyle-Width="50px" />

<asp:TemplateField HeaderText="Name" HeaderStyle-Width="100px">

<asp:TextBox ID="txtName" runat="server" CssClass="form-control" MaxLength="100"></asp:TextBox>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Email Id" HeaderStyle-Width="100px">

<asp:TextBox ID="txtEmail_Id" runat="server" CssClass="form-control" MaxLength="50"></asp:TextBox>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Mobile No" HeaderStyle-Width="100px">

<asp:TextBox ID="txtMobileNo" runat="server" CssClass="form-control" MaxLength="10"></asp:TextBox>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Address" HeaderStyle-Width="150px">

<asp:TextBox ID="txtAddress" runat="server" CssClass="form-control" MaxLength="100"></asp:TextBox>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderStyle-Width="50px">

<asp:Button ID="ButtonAdd" runat="server" Text="Add Row" OnClick="ButtonAdd_Click" />

</FooterTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<asp:Button ID="btnSave" runat="server" Text="Save" CssClass="btn btn-primary btn-lg"

OnClick="btnSave_Click" />

C# Code

using System.Data.SqlClient;

using System.Data;

using System.Configuration;

public static SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conStringsql"].ConnectionString.ToString());

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

SetInitialRow();

BindGridView();

}

private void SetInitialRow()

{

DataTable dt = new DataTable();

DataRow dr = null;

dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));

dt.Columns.Add(new DataColumn("Column1", typeof(string)));

dt.Columns.Add(new DataColumn("Column2", typeof(string)));

dt.Columns.Add(new DataColumn("Column3", typeof(string)));

dt.Columns.Add(new DataColumn("Column4", typeof(string)));

dr = dt.NewRow();

dr["RowNumber"] = 1;

dr["Column1"] = string.Empty;

dr["Column2"] = string.Empty;

dr["Column3"] = string.Empty;

dr["Column4"] = string.Empty;

dt.Rows.Add(dr);

//Store the DataTable in ViewState

ViewState["CurrentTable"] = dt;

GridView2.DataSource = dt;

GridView2.DataBind();

}

private void SetPreviousData()

{

int rowIndex = 0;

if (ViewState["CurrentTable"] != null)

{

DataTable dt = (DataTable)ViewState["CurrentTable"];

if (dt.Rows.Count > 0)

{

for (int i = 0; i < dt.Rows.Count; i++)

{

TextBox txtName = (TextBox)GridView2.Rows[rowIndex].Cells[1].FindControl("txtName");

TextBox txtEmail_Id = (TextBox)GridView2.Rows[rowIndex].Cells[2].FindControl("txtEmail_Id");

TextBox txtMobileNo = (TextBox)GridView2.Rows[rowIndex].Cells[3].FindControl("txtMobileNo");

TextBox txtAddress = (TextBox)GridView2.Rows[rowIndex].Cells[4].FindControl("txtAddress");

txtName.Text = dt.Rows[i]["Column1"].ToString();

txtEmail_Id.Text = dt.Rows[i]["Column2"].ToString();

txtMobileNo.Text = dt.Rows[i]["Column3"].ToString();

txtAddress.Text = dt.Rows[i]["Column4"].ToString();

rowIndex++;

}

private void AddNewRowToGrid()

{

int rowIndex = 0;

if (ViewState["CurrentTable"] != null)

{

DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];

DataRow drCurrentRow = null;

if (dtCurrentTable.Rows.Count > 0)

{

for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)

{

//extract the TextBox values

TextBox txtName = (TextBox)GridView2.Rows[rowIndex].Cells[1].FindControl("txtName");

TextBox txtEmail_Id = (TextBox)GridView2.Rows[rowIndex].Cells[2].FindControl("txtEmail_Id");

TextBox txtMobileNo = (TextBox)GridView2.Rows[rowIndex].Cells[3].FindControl("txtMobileNo");

TextBox txtAddress = (TextBox)GridView2.Rows[rowIndex].Cells[4].FindControl("txtAddress");

drCurrentRow = dtCurrentTable.NewRow();

drCurrentRow["RowNumber"] = i + 1;

dtCurrentTable.Rows[i - 1]["Column1"] = txtName.Text;

dtCurrentTable.Rows[i - 1]["Column2"] = txtEmail_Id.Text;

dtCurrentTable.Rows[i - 1]["Column3"] = txtMobileNo.Text;

dtCurrentTable.Rows[i - 1]["Column4"] = txtAddress.Text;

rowIndex++;

}

dtCurrentTable.Rows.Add(drCurrentRow);

ViewState["CurrentTable"] = dtCurrentTable;

GridView2.DataSource = dtCurrentTable;

GridView2.DataBind();

}

else

{

Response.Write("ViewState is null");

}

//Set Previous Data on Postbacks

SetPreviousData();

}

protected void ButtonAdd_Click(object sender, EventArgs e)

{

message.Visible = false;

AddNewRowToGrid();

}

protected void btnSave_Click(object sender, EventArgs e)

{

try

{

foreach (GridViewRow g1 in GridView2.Rows)

{

string Name = (g1.FindControl("txtName") as TextBox).Text;

string Email_Id = (g1.FindControl("txtEmail_Id") as TextBox).Text;

string MobileNo = (g1.FindControl("txtMobileNo") as TextBox).Text;

string Address = (g1.FindControl("txtAddress") as TextBox).Text;

con.Open();

SqlCommand cmd = new SqlCommand("insert into tbl_Insert_Gridview_Values values('" + Name + "','" + Email_Id + "','" + MobileNo + "','" + Address + "')", con);

cmd.ExecuteNonQuery();

con.Close();

}

message.Visible = true;

BindGridView();

GridView2.DataSource = null;

GridView2.DataBind();

}

catch (Exception ex)

{

message.Visible = false;

lblError.Visible = true;

lblError.Text = ex.ToString();

}

2.Bind Gridview

<asp:Label ID="lblMessage" runat="server" CssClass="mylabel" Font-Bold="True" ForeColor="Red"></asp:Label>

<asp:GridView ID="GridView1" Border="1" Style="border: 1px solid #ccc;" GridLines="None"

AllowPaging="false" PageSize="10" Width="100%" HeaderStyle-BackColor="#06D995"

AutoGenerateColumns="false" runat="server">

<asp:TemplateField HeaderText="Sr.No." ControlStyle-Width="10">

<asp:Label ID="srLabel" runat="server" Text='<%#Container.DataItemIndex+1 %>'></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="Email_Id">

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

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Mobile_No">

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

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Address">

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

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

C# Code

private void BindGridView()

{

try

{

SqlCommand cmd = new SqlCommand("select * from tbl_Insert_Gridview_Values ", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

DataTable dt = ds.Tables[0];

GridView1.DataSource = dt;

if (dt.Rows.Count > 0)

{

GridView1.Visible = true;

lblMessage.Visible = false;

GridView1.DataSource = dt;

GridView1.DataBind();

}

else

{

GridView1.Visible = false;

lblMessage.Visible = true;

lblMessage.Text = "No records found";

}

catch (Exception ex)

{

lblMessage.Visible = true;

lblMessage.Text = ex.Message.ToString();

}

Tuesday, October 16, 2018

HTML

C# Code

Saturday, October 13, 2018

HTML

C# Code

Friday, October 12, 2018

HTML

c# code

Thursday, October 11, 2018

javascript

Sunday, October 7, 2018

HTML

1.Add new row Gridview

C# Code

2.Bind Gridview

C# Code

Also Read