GridView In asp.net

Question

0.00/5 (No votes)

See more:

CSS

This Output File:
fileName fileType fileSize filepath createdOn
Asp notes.docx .docx 13539 2013-04-04-05-52\ 4/4/2013 5:52:20 PM
Asp.net.docx .docx 14041 2013-04-04-05-52\ 4/4/2013 5:52:20 PM

I want Display Output like this in GridView1.Combine with fileType and fileSize in same columns in GridView1..

CSS

fileName    fileType&fileSize   filepath     createdOn
Asp notes.docx  .docx 13539  2013-04-04-05-52\   4/4/2013 5:52:20 PM
Asp.net.docx    .docx 14041  2013-04-04-05-52\   4/4/2013 5:52:20 PM

CSS

display in the gridView1
filename,fileType&filesize,filepath,CreatedOn.

Output Like This:

SQL

select fileId,userId,fileName,(fileType + ' ' + fileSize)as fourthcolumn,filepath,createdOn,statusId,lastModifiedOn from fileInfo

In here fileType and FileSize is merge in the fourthColumn..
I want Display in filetype and next line in the fileSize in the same row...

please say
 correct solution Friends!

Advance Thanks Friends!

Posted 7-Apr-13 23:00pm

Rekhash

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

*Karthik Harve* · Answer 1 · 2013-04-07T23:10:00

Solution 1

Hi,

modify the query like below.

SQL

select fileId,userId,fileName,(fileSize + '<BR>' + fileType)as fileInfo,filepath,createdOn,statusId,lastModifiedOn from fileInfo</br>

and use label in the Item Template of the GridView.

[Edit]

take a template column for a gridview, and in the item template of that template column, add the label like below.

ASP.NET

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

where "fileInfo" is a new column gives the concatenated data.

hope it works.

Posted 7-Apr-13 23:10pm

Karthik Harve

Updated 8-Apr-13 0:31am

v3

Comments

Rekhash 8-Apr-13 5:13am

@Karthik Harve it is not working..

Karthik Harve 8-Apr-13 5:19am

can you show your gridview html source ? and your code of binding the gridview.

Rekhash 8-Apr-13 5:27am

@Karthik Harve.
ya sure.. it display value like this filesize<BR>filetype
Can give any ideas about output comes like this
filesize
filetype

Karthik Harve 8-Apr-13 5:45am

are you using bound field or Template Field (Item Template - label) ? if <BR> is not working then try with "<br/>", but <br/> gives error sometimes when you used ajax.

Rekhash 8-Apr-13 6:02am

@Karthik Harve. i am bind values in gridview1 in code Behind

Rekhash 8-Apr-13 6:07am

public partial class user_info : System.Web.UI.Page
{

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindData();
}
}
private void BindData()
{
string key = Session["email"].ToString();

string query = "select f.fileName,(f.fileType + '' + f.fileSize)as fileInfo,f.filepath,f.createdOn,f.statusId,s.statusName from fileInfo As f left join status As s on f.statusId=s.statusId where userId=(select userId from userInfo where email ='" + key + "')";

da = new SqlDataAdapter(query, Connection);
table = new DataTable();
da.Fill(table);
GridView1.DataSource = table;
GridView1.DataBind();

}
}
}

Rekhash 8-Apr-13 6:08am

@Karthik Harve
HI did u ask in source code... i post here check that and say correct answer..

Karthik Harve 8-Apr-13 6:16am

ok. the code seems fine. can you show your html source of the gridview ?

Rekhash 8-Apr-13 6:18am

@Karthik Harve html source code
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="user_info.aspx.cs" Inherits="jQueryUploadTest.user_info" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Uploaded Files</title>
</head>
<body>
<form runat="server">
<asp:GridView ID="GridView1" runat="server" OnRowDataBound="GridView1_RowDataBound" >

</form>
</body>
</html>

Karthik Harve 8-Apr-13 6:31am

check with my updated solution.

Rekhash 8-Apr-13 6:54am

@Karthik Harve
it is not runing,... please suggest any other ways,..

PRAKASH9 8-Apr-13 7:01am

@Rekhash check my solution

PRAKASH9 · Answer 2 · 2013-04-08T19:59:00

use this it is simple to use stored procedure

SQL

Create PROCEDURE usp_getAlldata
(
   @Key varchar(50)
)
AS
BEGIN
select f.fileName,(CONVERT(varchar(50),f.fileType) + '<br>' + CONVERT(varchar(50),f.fileSize)) as fileInfo,f.filepath,f.createdOn,f.statusId,s.statusName from fileInfo As f left join status As s on f.statusId=s.statusId where userId=(select userId from userInfo where email = @Key)
END
GO

</br>

C#

protected void Page_Load(object sender, EventArgs e)
{
    string emailkey = "put your key here";
    DataSet ds = new DataSet();
    SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
    cn.Open();
    SqlCommand cmd = new SqlCommand("usp_getAlldata", cn);
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.AddWithValue("@Key", emailkey);
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    da.Fill(ds);
    cmd.ExecuteNonQuery();

    GridView1.DataSource = ds;
    GridView1.DataBind();
}

Chinmaya C · Answer 3 · 2013-04-08T20:48:00

You can you template column in gridview and put both the fields in that column.

Please try with the following gridview design fragment:

XML

<asp:TemplateField HeaderText="File Info">
      <ItemTemplate>
           <asp:Label ID="lnkfileType" runat="server" Text='<%# Eval("fileType") %>' ></asp:Label>&nbsp
           <asp:Label ID="lnkfilesize" runat="server" Text='<%# Eval("fileSize") %>' ></asp:Label>&nbsp
      </ItemTemplate>
</asp:TemplateField>

PRAKASH9 · Answer 4 · 2013-04-07T23:49:00

Solution 2

use this code

SQL

select fileId,userId,fileName,(fileSize + CHAR(10) + fileType)as fourthcolumn,filepath,createdOn,statusId,lastModifiedOn from fileInfo

Posted 7-Apr-13 23:49pm

PRAKASH9

v2

Comments

Rekhash 8-Apr-13 6:05am

@PRAKASH9 it is not working,..

Rekhash 8-Apr-13 6:22am

@PRAKASH9 will U suggest another answer...

PRAKASH9 8-Apr-13 7:00am

@Rekhash check my solution

PRAKASH9 · Answer 5 · 2013-04-08T00:52:00

use this solution

SQL

Create PROCEDURE usp_getAlldata
AS
BEGIN
select fileId,userId,fileName,(CONVERT(varchar(50),fileSize ) + '<br>' + CONVERT(varchar(50),fileType)) as fourthcolumn,filepath,createdOn,statusId,lastModifiedOn from fileInfo
END
GO
</br>