Help On Grid View Binding

ok what is exactly your problem ? Does your Union when ran in SQL Brings data ? please explain clearly

Thank you for posting at Dotnetfunda
[Administrator]

Vijayar, if this helps please login to Mark As Answer. | Alert Moderator

yes,when i run the query i am getting the data as required in sql.But when i am unable to bind the same query to grid view.Help Me in this issue
how to bind it to grid view.Explain me to get in above format

vijaya

Vijayar, if this helps please login to Mark As Answer. | Alert Moderator

Let me see your C# code that you attempted to write

Thank you for posting at Dotnetfunda
[Administrator]

Vijayar, if this helps please login to Mark As Answer. | Alert Moderator

private void BindGridView()
{

try
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings[""].ToString();

conn.Open();
//SqlDataAdapter da = new SqlDataAdapter("SELECT * From MailTemplate ", conn);

SqlDataAdapter da = new SqlDataAdapter("Select 'MC'+Cast(CategoryId as varchar)id , CategoryId as CategoryId,CategoryName from MailCategory UNION Select 'S'+Cast(TemplateId as varchar)tempID ,MailTempCategory,MailTempName from MailTemplate order by CategoryId,ID", conn);
DataSet ds = new DataSet();
da.Fill(ds);


gvmailtemp.DataSource = ds;
gvmailtemp.DataBind();
}
catch (Exception ex)
{
ex.Message.ToString();
}
}

vijaya

Vijayar, if this helps please login to Mark As Answer. | Alert Moderator

Greetings,

Could you please share the table structure. please dont use the inline query as it impacts the performance instead you
can use strored procedure. it is best practice too.

Thanks,

Vijayar, if this helps please login to Mark As Answer. | Alert Moderator

Can i see the html of your gridview

Thanks

Thank you for posting at Dotnetfunda
[Administrator]

Vijayar, if this helps please login to Mark As Answer. | Alert Moderator

<asp:GridView ID="gvmailtemp" runat="server" AutoGenerateColumns="False" Width="100%"
AllowPaging="True" OnRowCommand="gvmailtemp_RowCommand" CssClass="datatable"
CellPadding="0" CellSpacing="0" BorderWidth="0" GridLines="None">
<Columns>
<asp:TemplateField HeaderText="S.No" HeaderStyle-CssClass="first" ItemStyle-CssClass="first">
<ItemTemplate>
<%# Container.DataItemIndex+1 %>
<asp:Label ID="lblSerialNo" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>

<asp:BoundField DataField="CategoryName" HeaderText="CategoryName" Visible="false">
</asp:BoundField>
<asp:BoundField DataField="MailTempName" HeaderText=" Mail Temp Name" Visible="false">
</asp:BoundField>
<asp:TemplateField HeaderText="categoryname/mail temp name">
<ItemTemplate>

<asp:Label ID="Label1" runat="server" Text="">
<%# Eval("CategoryName") + "<br> " + "____________" + "<br>" + Eval("MailTempName")%>
</asp:Label>
</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Edit" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:ImageButton ID="Edit" runat="server" Text="Edit" ForeColor="#000066" CausesValidation="false"
CommandName="MyEdit" CommandArgument='<%#Eval("TemplateId") %>' ImageUrl="~/Pages/images/1303308225_edit.png"
ToolTip="Edit" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:ImageButton ID="Delete" runat="server" Text="Delete" ForeColor="#000066" CausesValidation="false"
CommandName="MyDelete" OnClientClick="return confirm('Are you sure you want to delete Template?') "
CommandArgument='<%#Eval("TemplateId") %>' ImageUrl="~/Pages/images/1303308433_edit-delete.png"
ToolTip="Delete" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>


Help Me in designing grid view also

vijaya

Vijayar, if this helps please login to Mark As Answer. | Alert Moderator

Mail Category Table

categoryid,categoryname

mailTemplate------------------TemplateId
[MailTempCategory]
[MailTempName]

[MailMessage] ,the common field is categoryid(the name in another table is mailtempcategory)

vijaya

Vijayar, if this helps please login to Mark As Answer. | Alert Moderator

For now lets test this , change your gridview to look like this and test if there are any records in the grid when you run it

<asp:GridView ID="gvmailtemp" runat="server" AutoGenerateColumns="true" Width="100%" 

AllowPaging="True" OnRowCommand="gvmailtemp_RowCommand" CssClass="datatable" 

CellPadding="0" CellSpacing="0" BorderWidth="0" GridLines="None"> 

 

</asp:GridView> 

Thank you for posting at Dotnetfunda
[Administrator]

Vijayar, if this helps please login to Mark As Answer. | Alert Moderator