Hello Friends....
Welcome to this Blog...This Blog is specially for the .Net Developers where all developers can discuss the .Net and Sql Articles.
"And will you succeed? Yes! You will indeed!(98 and 3/4 percent guaranteed)."

Sunday, September 12, 2010

Adding Template Fields to a GridView Control.

A TemplateField is used in cases where authors need complete control over the
contents of a GridView column. The TemplateField is declared with an
<ItemTemplate> element, which in turn is used to define the content that will be
rendered for each row in the column. The ItemTemplate can include any valid HTML.

To add a template column:-

1.Set the GridView control's AutoGenerateColumns property to false.

<asp:GridView id="myGrid" runat="server"
   autogeneratecolumns=false
   ...
>
2. Within the GridView declaration, declare a <Columns> element.
3.Within the Columns element, define the <asp:TemplateField> 
control, along with the required <ItemTemplate> element.
4.Within the ItemTemplate, define the HTML or server control that 
will contain the field value.
To display the value of a field in an item template,
use DataBinding 
Expression Syntax
5.Optionally set the <asp:TemplateField> control's 
other properties.
For syntax, see GridView Control Syntax
 
<columns>
 <asp:templatefield>

   <itemtemplate>
     <img width=60 align="top" 
src='<%# Eval ("title_id", "../images/title-{0}.gif" )%>'>
   </itemtemplate>

  </asp:templatefield>
   ...
</columns>

Friday, September 3, 2010

Dynamic Gridview Bind

First You have to Drag Gridview Tool From your Toolbox
and place it to your design .aspx Page:-

Then at  the Code behind page in .cs file like Gridview.aspx.cs file
call  the following function to your button_click event:-

void BindData()
{
try
{
SqlConnection con = new SqlConnection(@"server=.\sqlexpress;
database=TestDB;Integrated Security=SSPI;");
 
DataSet ds = new DataSet();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select id,name,flag 
from EmpData", con); 
 
da.Fill(ds);
BoundField BC1 = new BoundField();
BC1.HeaderText = "ID";
BC1.DataField = "id";
GridView1.Columns.Add(BC1);
BoundField BC2 = new BoundField();
BC2.HeaderText = "Name";
BC2.DataField = "name";
GridView1.Columns.Add(BC2); 
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
catch (Exception e)

{
Response.Write(e.Message.ToString());
con.Close();
}

Enjoy  :-)

Create File Uploader (Visual Studio)

By this Coding you can create File Uploader 
and the is file will uploaded into Foder:- 
 
 Design Source Code:- 
 
<form id="form1" runat="server">
    <asp:FileUpload id="FileUploadControl" runat="server" />
    <asp:Button runat="server" id="UploadButton" text="Upload" 
     onclick="UploadButton_Click" />
    <br /><br />
    <asp:Label runat="server" id="StatusLabel" text="Upload 
     status: " />
</form>
Coding C#:
protected void UploadButton_Click(object sender, EventArgs e)
{
if(FileUploadControl.HasFile)
{
try
{
string filename = Path.GetFileName(FileUploadControl.FileName);
FileUploadControl.SaveAs(Server.MapPath("~/Folderpath") + filename);
StatusLabel.Text = "Upload status: File uploaded!";
}
catch(Exception ex)
{
StatusLabel.Text = "Upload status: The file could not be uploaded.
The following error occured: " + ex.Message;
}
}
}

Creating New Web Page in Asp.net

Creating New Web Page in Asp.net

1.Open your Visual Studio 2.0 or 3.5 version
2.Go to File Menu---->New------>Website
3.On the Templates,Select ASP.NET Website.
4.In this diolog box set ur Language as C#.
5.Click Ok and your Website gets open.
6.Start working with web pages...