Asp.Net Ado.Net, C#.Net,Javascript Jquery Entity Framework,Ajax,MVC..! Happy coding..! :)

Every Question..What does it mean? Why is this? How it works?
Microsoft .Net (pronounced dot (.) net) may be a package element that runs on the Windows software package. .Net provides tools and libraries that change developers to form Windows package a lot of quicker and easier. Microsoft describes it as:".Net is that the Microsoft internet Service strategy to attach data, people, system and devices through software".I'm Choulla Naresh..!

Wednesday, July 16, 2014

Binding Dropdowns Using Single Method.. and At A time inserting Dataset to Database... Xml tag Creation... temp table creation

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Xml;

using System.Data;

using System.Data.SqlClient;

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

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnSubmit_Click(object sender, EventArgs e)

{

XmlDocument XmlDocObj = new XmlDocument();

XmlDocObj.Load(Server.MapPath("BookStore.xml"));

XmlNode RootNode = XmlDocObj.SelectSingleNode("bookstore");

XmlNode bookNode = RootNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "book", ""));

bookNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "Title", "")).InnerText = tbTitle.Text;

bookNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "Author", "")).InnerText = tbAuthor.Text;

bookNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "Year", "")).InnerText = tbYear.Text;

bookNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "Price", "")).InnerText = tbPrice.Text;

XmlDocObj.Save(Server.MapPath("BookStore.xml"));

gridDataBind();

//bind();

}

//private void bind()

//{

//}

public void sessionusername(DataSet ds)

{

Session["username"] = ds;

DataSet ds1 = (DataSet)Session["username"];

}

public void gridDataBind()

{

DataSet ds = new DataSet();

ds.ReadXml(Server.MapPath("BookStore.xml"));

gvBookStoreRecords.DataSource = ds;

gvBookStoreRecords.DataBind();

SqlConnection con = new SqlConnection("Data Source=KCLINK-45-PC\\SQLEXPRESS;Initial Catalog=naresh;Integrated Security=True");

SqlCommand cmd = new SqlCommand();

cmd.Connection = con;

con.Open();

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = "Sp_title1";

//SqlDataAdapter dap = new SqlDataAdapter(cmd);

//DataSet ds = new DataSet();

//dap.Fill(ds);

cmd.Parameters.AddWithValue("@datacontainer", ds.Tables[0]);

cmd.ExecuteNonQuery();

filldropdown(drp, ds,"Title","Price");

filldropdown(DropDownList1, ds,"Author","Price");

filldropdown(DropDownList2, ds,"Year","Price");

}

public void filldropdown(DropDownList drp, DataSet ds,string text,string value)

{

drp.DataSource = ds;

drp.DataTextField = text;

drp.DataValueField = value;

drp.DataBind();

}

<%@ 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>

<div>

<br />

<tr>

Title:

</td>

<td>

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

</td>

</tr>

<tr>

Author:

</td>

<td>

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

</td>

</tr>

<tr>

Year:

</td>

<td>

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

</td>

</tr>

<tr>

Price:

</td>

<td>

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

</td>

</tr>

<tr>

</td>

<td>

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

</td>

</tr>

<tr>

<td>

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

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

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

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

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

</td>

</tr>

</table>

<asp:GridView ID="gvBookStoreRecords" runat="server" CellPadding="4" ForeColor="#333333"

GridLines="None">

</asp:GridView>

</div>

</form>

</body>

</html>

<?xml version="1.0" encoding="utf-8"?>

<book>

<Author>dsfffg</Author>

</book>

<book>

<Author>ersfser</Author>

</book>

<book>

<Author>ersfser</Author>

</book>

<book>

</book>

<book>

<Author>naresh</Author>

</book>

<book>

<Author>naresh</Author>

</book>

<book>

<Year>dfgfd</Year>

<Price>dfgdfg</Price>

</book>

<book>

<Title>naresh</Title>

<Year>asdfasd</Year>

<Price>sadfasdf</Price>

</book>

<book>

<Title>cghbn</Title>

<Year>vbncv</Year>

<Price>vbncv</Price>

</book>

<book>

<Year>fdghs</Year>

</book>

<book>

<Title>gbdcnc</Title>

<Year>vbndf</Year>

</book>

<book>

<Title>bncvb</Title>

<Year>vbncbn</Year>

<Price>vcbnc</Price>

</book>

<book>

</book>

<book>

</book>

<book>

<Title>fgbfg</Title>

<Author>cvbcv</Author>

</book>

<book>

<Author>naresh</Author>

</book>

<book>

<Title>esdfs</Title>

<Author>sdfsd</Author>

<Year>sdfsd</Year>

<Price>sdfsdf</Price>

</book>

<book>

<Title>dfgdsfg</Title>

<Author>sdfgdsfg</Author>

<Year>sdfgdsfg</Year>

</book>

<book>

<Title>asdasd</Title>

<Author>asdasd</Author>

<Year>asdasd</Year>

</book>

<book>

<Title>dfghdfgh</Title>

<Author>hjkhjk</Author>

<Year>gvbnvc</Year>

</book>

<book>

<Author>sdfasdfg</Author>

<Year>sdfgdsfg</Year>

</book>

<book>

<Title>dfgdfsg</Title>

<Author>sdfgsdfg</Author>

<Year>dsfgdsfg</Year>

</book>

<book>

<Title>asdfasdf</Title>

<Author>asdfsadf</Author>

<Year>asdfsadf</Year>

</book>

</bookstore>
-----------------------------------------------------------------------------------

create table title(Title varchar(50),Author varchar(50),Year varchar(50),Price varchar(50))

create type title1 as table(Title varchar(50),Author varchar(50),Year varchar(50),Price varchar(50))

create procedure Sp_title

@datacontainer as title1 readonly

begin

insert into title select * from @datacontainer

end

select * from title

Tuesday, July 15, 2014

Temporary Table -SQL Server

This example Shows you how to create temporary table in SqlServer, Insert values in them, Check their existence and finally Drop them.

Create Temp Table

This one is declared as Global Temporary Table

create table ##YourTempTable (YourTableField1 bigint,YourTableField2 varchar(50))

This one is declared as Local Temporary Table

create table #YourTempTable (YourTableField1 bigint,YourTableField2 varchar(50))

Insert Values in Your Temporary Table

insert into ##YourTempTable

SELECT * FROM YourDesiredTable

Check Existence of Temporary table

if exists(select * from tempdb.dbo.sysobjects where ID=object_ID(N'tempdb..##YourTempTable '))

Check Existence n Then Drop Temporary Table

if exists(select * from tempdb.dbo.sysobjects where ID=object_ID(N'tempdb..##YourTempTable '))

BEGIN

DROP TABLE ##YourTempTable

END

Show Total in GridView Footer

Design:

<asp:TemplateField HeaderText="Total Pcs">

<asp:Label ID="lbltotpcs" runat="server" Text='<%# Bind("totpcs") %>'></asp:Label>

</ItemTemplate>

Total : <asp:Label ID="lbltotqty" runat="server" Text="Label"></asp:Label>

</FooterTemplate>

</asp:TemplateField>

Populate the RowDataBound event of Gridview where you have to do the main calculation.

int totqty=0;

protected void gvCrate_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

Label totpcs = (Label)e.Row.FindControl("lbltotpcs");

totqty = totqty + (Convert.ToInt32(totpcs.Text));

}

if (e.Row.RowType == DataControlRowType.Footer)

{

((Label)e.Row.FindControl("lbltotqty")).Text = totqty.ToString();

TxtTotalpcs.Value = totqty.ToString();

}

NOTE:

Enable "ShowFooter" as True in Gridview's property.

Add Month To any Given Date

using System.Globalization;

protected void DropEMISchedule_SelectedIndexChanged(object sender, EventArgs e)

{

DateTime dt;

int calcy = Convert.ToInt32(DropEMISchedule.SelectedValue) * Convert.ToInt32(txttenure.Text);

if (DateTime.TryParseExact(txtEMIStartDate.Text, "dd/MM/yyyy",new CultureInfo("en-US"), System.Globalization.DateTimeStyles.None, out dt))

{

TextBoxend.Text = "";

DateTime dtshow = dt.Date.AddMonths(calcy);

TextBoxend.Text = (dtshow).ToString("dd/MM/yyyy");

}

error code 0x8007045D

Meaning of Error 0x8007045d is "ERROR_IO_DEVICE" i.e. "The request could not be performed because of an I/O device error. There are various cause for this error like :

May be the brand of the disc is incompatible with the burner.
May be the disc is defective.Use another one .
May be the burner have malfunctioned.

In summary, "error code 0x8007045D" simply means the media is bad.