SharePoint

Showing posts with label DotNet. Show all posts

How to Expand and Collapse asp TreeView Using Button

I want to Expand and Collapse Asp TreeView control using button, In page load i expand all nodes. button will show "hide". While clicking hide it will show "Show" all nodes will Collapse.

In Ascx page:

<asp:Button runat="server" ID="btnhide" OnClick="btnhide_onclick" Text="Hide" />

<asp:TreeView ID="TreeViewID" runat="server">

</asp:TreeView>

In Pageload:

TreeViewID.ExpandAll();

Button OnClick

protected void btnhide_onclick(object sender, EventArgs e)

{

if (btnhide.Text == "Hide")

{

TreeViewID.CollapseAll();

btnhide.Text = "Show";

}

else

{

if(btnhide.Text == "Show all")

{

TreeViewID.ExpandAll();

btnhide.Text = "Hide all";

}

Phani Kumar 14:31 Add Comment

In this article i wll explain how to insert data using stored procedure in c#.

I am creating a table in sqlsever.

USE [dotnetdb]

/****** Object: Table [dbo].[Employee] Script Date: 12/25/2013 14:25:42 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[Employee](

[EmpId] [nvarchar](50) NOT NULL,

[EmpName] [nvarchar](50) NOT NULL,

[EmpAddress] [nvarchar](50) NOT NULL,

[EmpDesignation] [nvarchar](50) NULL

) ON [PRIMARY]

For this table I am creating a Stored procedure as shown.

USE [dotnetdb]

/****** Object: StoredProcedure [dbo].[SP_InsertEmpinfo] Script Date: 12/25/2013 14:27:00 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

Create procedure [dbo].[SP_InsertEmpinfo]

(

@EmpId nvarchar(50),

@EmpName nvarchar(50),

@EmpAddress nvarchar(50),

@EmpDesignation nvarchar(50)

)

As Begin

Insert into Employee (EmpId,EmpName,EmpAddress,EmpDesignation) values (@EmpId,@EmpName,@EmpAddress,@EmpDesignation)

end

Now I am designing UI.

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="AspExample.WebForm1" %>

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

</head>

<body>

<div>

<label>EmpId</label>

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

</div>

<div>

<label>EmpName</label>

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

</div>

<div>

<label>EmpAddress</label>

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

</div>

<div>

<label>EmpDesignation</label>

<asp:DropDownList ID ="ddlempdes" runat = "server">

<asp:ListItem>Select</asp:ListItem>

<asp:ListItem>SE</asp:ListItem>

<asp:ListItem>TL</asp:ListItem>

<asp:ListItem>PL</asp:ListItem>

</asp:DropDownList>

</div>

<div>

<asp:Button ID ="btnsubmit" Text ="Submit" runat ="server"

onclick="btnsubmit_Click" />

</div>

</form>

</body>

</html>

In code behind I am implementing the logic as shown below.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

namespace AspExample

{

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

{

SqlConnection con = new SqlConnection("Data Source=Chinnu;Database=dotnetdb;User Id=sa;Password=password123;");

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnsubmit_Click(object sender, EventArgs e)

{

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

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@EmpId", SqlDbType.NVarChar).Value = txtempid.Text;

cmd.Parameters.Add("@EmpName", SqlDbType.NVarChar).Value = txtempname.Text;

cmd.Parameters.Add("@EmpAddress", SqlDbType.NVarChar).Value = txtempaddress.Text;

cmd.Parameters.Add("@EmpDesignation", SqlDbType.NVarChar).Value = ddlempdes.SelectedValue;

con.Open();

cmd.ExecuteNonQuery();

con.Close();

}

In web.config give the database connection.

</connectionStrings>

Phani Kumar 14:44 2 Comments

Hi Today one of my friend attened interview on .net,he was having 2+ years of exprience.

These all the he faced in the Interview.I hope those who trying for job i will help full.

Tell me about Yourself?

Tell About Your Project?

Why we are using RDLC Reports?

Life Cycle of .net?

CLR?

CTS?

Method overloading and Method Overriding?

Why they are updating HTML4 to HTML5?

How to select the second highest salaried employee from table?

Ways to debug JavaScript?

Ado.net architecture?

Tell about .net framework 4.0 and 4.5 ?

We are having so many technologies like Java,PHP then why we have to go for .net?

What is Sealed Class?

How to pass text box values using java script and jquery?

Program based on oops concepts?

Ways to connect database with .net?

What is the Use of Abstract class?

When you will use Abstract class and Interface?

What is the Difference between Abstract class and Interface?

What is the Difference between Session and Application?

How to display images in gridview from database using asp.net

Phani Kumar 19:32 1 Comment

In this Article I will explain how to display images in gridview from database

I Created a table with Name Display_Images as shown below.

USE [chinnu]

/****** Object: Table [dbo].[Display_Images] Script Date: 11/07/2013 05:40:28 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[Display_Images](

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

[ImageName] [nvarchar](max) NOT NULL,

[ImagePath] [nvarchar](max) NOT NULL

) ON [PRIMARY]

Now I am creating an empty web application with name UpLoadimages,After that I am adding a web form with name

DisplayImages.aspx.

I am designing a UI with FileUplod Control ,Button and Grid view.

In DisplayImages.aspx page

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DisplayImages.aspx.cs" Inherits="UpLoadimages.DisplayImages" %>

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

</head>

<body>

<div>

<asp:FileUpload ID="FileUpload1" runat="server" />

<asp:Button ID = "BtnUploadImages" runat = "server" Text = "UploadImages"

onclick="BtnUploadImages_Click" />

</div>

<div>

<asp:GridView ID="gridview" runat="server" AutoGenerateColumns = "false">

<asp:BoundField DataField="Id" HeaderText="Id"/>

<asp:BoundField DataField="ImageName" HeaderText="ImageName"/>

<asp:ImageField DataImageUrlField = "ImagePath" ControlStyle-Height = "50" ControlStyle-Width = "50" HeaderText="Image Preview" />

</Columns>

</asp:GridView>

</div>

</form>

</body>

</html>

In DisplayImages.aspx.cs I am writing the logic to display images in grid view

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

using System.Configuration;

using System.IO;

namespace UpLoadimages

{

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

{

SqlConnection con = new SqlConnection("Data Source=DotNetSharePoint;Database=Chinnu;User Id=sa;Password=Password123;");

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindGridData();

}

private void BindGridData()

{

try

{

SqlCommand command = new SqlCommand("SELECT * from Display_Images", con);

SqlDataAdapter da = new SqlDataAdapter(command);

DataTable dt = new DataTable();

da.Fill(dt);

gridview.DataSource = dt;

gridview.DataBind();

}

catch (Exception ex)

{

}

protected void BtnUploadImages_Click(object sender, EventArgs e)

{

if (FileUpload1.PostedFile != null)

{

string ImageName = Path.GetFileName(FileUpload1.PostedFile.FileName);

FileUpload1.SaveAs(Server.MapPath("DisplayImages/" + ImageName));

string Query = "Insert into Display_Images(ImageName,ImagePath)" + "values(@ImageName,@ImagePath)";

SqlCommand cmd = new SqlCommand(Query);

cmd.Connection = con;

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

cmd.Parameters.AddWithValue("@ImagePath", "DisplayImages/" + ImageName);

cmd.CommandType = CommandType.Text;

con.Open();

cmd.ExecuteNonQuery();

con.Close();

}

In Web.config iam giving the database connection string

</connectionStrings>

After completing all the steps,Press F5

we can see the output as fallows.

SharePoint

How to Expand and Collapse asp TreeView Using Button

insert data using stored procedure in c#

Asp.net Real time Interview questions

How to display images in gridview from database using asp.net

Labels