Swapnil Mahangare

Saturday, 13 July 2013

foreign key allow null

foreign key only allow null values if primary key also allow the null data to insert
it can have null values but have to satisfied this condition

Normalization and denormalization

Normalization:- create relation between the table
Denormalization :- we add the required column to the table to retrive records

Types of view

1)simple view:- refresh and update data every time view run.
2)materialized view :- used to set time base updation of view data. we set particular time to refresh the data of view.

Wednesday, 5 June 2013

Modal Dialog Boxes with AJAX

http://msdn.microsoft.com/en-us/magazine/cc164247.aspx

Friday, 19 April 2013

print one part in form asp.net

No print preview, but this will print only the specified <div> tag:

<form id="Form1" method="post" runat="server">
<div id="Div1">
Printable content
</div>
<input type="button" value="Print" onclick="JavaScript:printPartOfPage('Div1');">

<script type="text/javascript">

</script>

</form>

Asp.net TextBox watermark in JQuery

This short article demonstrates how to create a watermark effect on your TextBox and display instructions to users, without taking up screen space. This article is a sample chapter from my EBook called 51 Tips, Tricks and Recipes with jQuery and ASP.NET Controls. The chapter has been modified a little to publish it as an article.
Note that for demonstration purposes, I have included jQuery code in the same page. Ideally, these resources should be created in separate folders for maintainability.
Let us quickly jump to the solution and see how we can create a watermark effect on your TextBox using client-side code.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>TextBox WaterMark</title>
<script type="text/javascript"
src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js">
</script>

<style type="text/css">
.water
{
font-family: Tahoma, Arial, sans-serif;
color:gray;
}
</style>

<script type="text/javascript">
$(function() {

$(".water").each(function() {
$tb = $(this);
if ($tb.val() != this.title) {
$tb.removeClass("water");
}
});

$(".water").focus(function() {
$tb = $(this);
if ($tb.val() == this.title) {
$tb.val("");
$tb.removeClass("water");
}
});

$(".water").blur(function() {
$tb = $(this);
if ($.trim($tb.val()) == "") {
$tb.val(this.title);
$tb.addClass("water");
}
});
});

</script>
</head>
<body>
<form id="form1" runat="server">
<div class="smallDiv">
<h2>TextBox Watermark Demonstration</h2> <br />
<asp:TextBox ID="txtFNm" class="water" Text="Type your First Name"
Tooltip="Type your First Name" runat="server"></asp:TextBox><br />
<asp:TextBox ID="txtLNm" class="water" Text="Type your Last Name"
Tooltip="Type your Last Name" runat="server"></asp:TextBox>
<br /><br />
<asp:Button ID="btnSubmit" runat="server" Text="Submit" />
<br /><br />
Tip: Click on the TextBox to start typing. The watermark
text disappears.
</div>
</form>
</body>
</html>

Nested grid view example

write below code to the NetedGrid.aspx page

<asp:GridView ID="gvParent" runat="server" AutoGenerateColumns="False"
BackColor="White" BorderColor="White" BorderStyle="Ridge" BorderWidth="2px"
CellPadding="3" CellSpacing="1" GridLines="None"
onrowcommand="gvParent_RowCommand">
<Columns>
<asp:BoundField DataField="Grp_Id" HeaderText="ID" SortExpression="Grp_Id" />
<asp:BoundField DataField="GrpNm" HeaderText="Name" SortExpression="GrpNm" />
<asp:TemplateField HeaderText="Group">
<ItemTemplate>
<asp:Button ID="btnShowChild" runat="server"
CommandArgument='<%# Bind("Grp_Id") %>' CommandName="ShowChild" Text="+" />
<asp:Button ID="btnHideChild" runat="server"
CommandArgument='<%# Bind("Grp_Id") %>' CommandName="HideChild" Text="-" Visible="false" />
<asp:GridView ID="gvChild" runat="server" AutoGenerateColumns="False">
<Columns>
<asp:BoundField DataField="Acct_Id" HeaderText="AcctId"
SortExpression="Acct_Id" />
<asp:BoundField DataField="PartyNm" HeaderText="Party Name"
SortExpression="PartyNm" />
<asp:BoundField DataField="TempAdd" HeaderText="Address"
SortExpression="TempAdd" />
</Columns>
</asp:GridView>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" />
<PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />
<RowStyle BackColor="#DEDFDE" ForeColor="Black" />
<SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />
</asp:GridView>

code for NestedGrid.aspx.cs file

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class NestedGrid : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["adv"].ConnectionString);
string query = null;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindParentGrid();
}
}
public void BindParentGrid()
{
query = "SELECT [Grp_Id] ,[GrpNm] FROM [dbo].[tbl_Group]";
SqlDataAdapter sdap = new SqlDataAdapter(query, con);
DataSet ds = new DataSet();
sdap.Fill(ds);
gvParent.DataSource = ds;
gvParent.DataBind();
ds.Clear();
}
protected void gvParent_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName== "ShowChild")
{
query = "SELECT * FROM [dbo].[tbl_AccountMaster] where [Grp_Id]="+e.CommandArgument.ToString()+"";
SqlDataAdapter sdap = new SqlDataAdapter(query, con);
DataSet ds = new DataSet();
sdap.Fill(ds);
for (int i = 0; i < gvParent.Rows.Count; i++)
{
if (e.CommandArgument.ToString() == (gvParent.Rows[i].Cells[0].Text))
{
((GridView)gvParent.Rows[i].FindControl("gvChild")).DataSource = ds;
((GridView)gvParent.Rows[i].FindControl("gvChild")).DataBind();
((Button)gvParent.Rows[i].FindControl("btnShowChild")).Visible = false;
((Button)gvParent.Rows[i].FindControl("btnHideChild")).Visible = true;
}
}
}
if (e.CommandName == "HideChild")
{

for (int i = 0; i < gvParent.Rows.Count; i++)
{
if (e.CommandArgument.ToString() == (gvParent.Rows[i].Cells[0].Text))
{
((GridView)gvParent.Rows[i].FindControl("gvChild")).DataSource = null;
((GridView)gvParent.Rows[i].FindControl("gvChild")).DataBind();
((Button)gvParent.Rows[i].FindControl("btnShowChild")).Visible = true;
((Button)gvParent.Rows[i].FindControl("btnHideChild")).Visible = false;
}
}
}
}
}