Using gridview onrowcommand on saving and displaying the data? - ASP.NET Discussion Boards

Member 1006079517-Dec-13 21:04

17-Dec-13 21:04

i am displaying records gridview vertically by converting rows into column hence i want column wise paging in gridview. thanks in advance

Re: I want column wise gridview paging

thatraja17-Dec-13 23:25

thatraja

17-Dec-13 23:25

Use Google[^], I found this[^]

EDIT
-----------------
Better way is bring resultset from database using the PageNo & Start-End. Check this article
SQL Server 2005 Paging Results[^]

For Row to Column/Column to Row use PIVOT-UNPIVOT
Using PIVOT and UNPIVOT[^]
Pivoting data in SQL Server - (Alternate ways)[^]

Combine the above two things & customize. That's it but to get perfect version, you need to spend some time on this. And don't forget to share your final version here.

thatraja

Code converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute

modified 18-Dec-13 8:04am.

Re: I want column wise gridview paging

Snehasish_Nandy18-Dec-13 1:37

Snehasish_Nandy

18-Dec-13 1:37

I think OP asked for paging..conversion part is already over..

Re: I want column wise gridview paging

thatraja18-Dec-13 2:05

thatraja

18-Dec-13 2:05

I won't blame my last coffee, it's my mistake. Sometime it happens. Thanks for the headsup.

thatraja

Re: I want column wise gridview paging

joginder-banger25-Dec-13 15:41

joginder-banger

25-Dec-13 15:41

I am not try this type but i sure this link will be help you. try this link http://forums.asp.net/t/1274497.aspx[^]

New

tsunamigang17-Dec-13 17:27

tsunamigang

17-Dec-13 17:27

Dim fourthOfJuly As New Date(1776, 7, 4)
Dim inTheMorning As New Date(1776, 7, 4, 9, 45, 30)

Why it has been declared like this?? what is the meaning??
cant we give it as simply date??

Re: New

thatraja17-Dec-13 23:35

thatraja

17-Dec-13 23:35

Choose right forum for your question. You should have posted this question in Visual Basic forum[^]

tsunamigang wrote:
Dim fourthOfJuly As New Date(1776, 7, 4)
Dim inTheMorning As New Date(1776,
7, 4, 9, 45, 30)

Didn't the ToopTip tell you when you put left parathesis in VS?
Those're parameters like Year, Month, Day, Hour, Minute, Second., And there're many overloads.

Check this one to learn more
DateTime Structure[^]

thatraja

Using gridview onrowcommand on saving and displaying the data?

Member 840570017-Dec-13 1:38

Member 8405700

17-Dec-13 1:38

I'm using nested gridview for saving and displaying comments and replies on my webforms. Reason why I used nested gridview for my comment section page is because I have reply option and I want to display the replies under the comment that has been replied to. The replies are displayed from the ChildGridview and I'm saving the replies using the ParentGridView onrowcommand.

I noticed that everytime you use the gridview onrowcommand event, the gridview will automatically do postback like you reload the page so what happen is the user can't see his reply immediately because the page has postedback and he has to go back to click the reply button in order to see his reply. I want it to be static and automatically load its reply on the page after posting it.

Refer this link for more example: http://money.msn.com/exchange-traded-fund/3-reasons-to-invest-in-made-in-usa

Did you see the comments with reply on there?If you try to reply some comments on that link you will immediately see your reply because it did not reload or postback that you need to find the comment where you reply and click the reply button just to see your reply because the reply you post will automatically be loaded. How do I do like that same on that link. Any suggestions? I hope you'll be able to figure out what I meant...Thanks

Re: Using gridview onrowcommand on saving and displaying the data?

Tom Marvolo Riddle17-Dec-13 2:05

Tom Marvolo Riddle

17-Dec-13 2:05

Use Updatepanel to overcome this.

Quote:
If you try to reply some comments on that link you will immediately see your reply because it did not reload or postback

No.It will postback to the server.It looks like it doesn't because of updatepanel or something else(but surely it process the postback)

To learn all there is to know. I know I'll be disappointed one day, but I've made a good start, and the eventual disappointment is likely to be brief.
-Roger Wright

Never doubt that a small group of thoughtful, committed people can change the world. Indeed, it is the only thing that ever has.-Margaret Mead

Re: Using gridview onrowcommand on saving and displaying the data?

Member 840570017-Dec-13 6:28

Member 8405700

17-Dec-13 6:28

Jas24 wrote:
Use Updatepanel to overcome this.

Hi!

I haven't tried to use Updatepanel eversince yet so I was kind of getting difficulty on how to deal the Updatepanel with my gridview to overcome this. How do I use updatepanel with gridview control to deal this kind of scenario. I'm gonna give you my mark-up and I hope you'll be able to help me resolve this issue...Thanks
Here's my mark-up below:

ASP.NET

asp:GridView ID="gvParentGrid" runat="server" Width="395px"
AutoGenerateColumns="false"  GridLines="None" BorderStyle="Solid" BorderWidth="0px" 
            BorderColor="White" DataKeyNames="ID" onrowcommand="gvParentGrid_RowCommand"
            onrowdatabound="gvParentGrid_RowDataBound" >

<Columns>
<asp:TemplateField >
<ItemTemplate>

 <tr>
     <td id ="comment" class ="highlightab" style ="border-bottom :2px solid Blue;border-bottom-color :Gray; border-left :0px; border-left-color :White; border-right :0px; border-right-color :White; border-top :0px; border-top-color :White;background-color :White;border-bottom :2px solid Blue;border-bottom-color :Gray; border-left :0px; border-left-color :White; border-right :0px; border-right-color :White; border-top :0px; border-top-color :White;background-color :White; height :100px; width :395px; margin-bottom :5px">
              
               <asp:Image ID="Image1" runat="server" style="  margin-right :5px; background-image :url('Image/imagebackground.png');"  ImageAlign ="Left" Height ="60px" Width="60px" />
               <asp:Label ID ="ComID" runat ="server" style="display :none" Text =' <%#Eval("ID") %>' /> 
              <asp:Label ID="name" runat="server"  Font-Bold="True" Text='<%# Eval("Name")%>' ForeColor="Blue"></asp:Label>           
             <p id ="content" class="minimize" style =" border-radius: 4px 4px 4px 4px; max-width :395px; min-height :5px; margin-top :5px; margin-bottom :5px; margin-left :65px; display :block; background-color: #CCCCFF;"> <%# DataBinder.Eval(Container.DataItem,"Comments").ToString() %> </p> 
           <a href="JavaScript:divexpandcollapse('div<%# Eval("ID") %>');" style ="margin-left :65px; margin-top :1px" >
             <input id="btndiv<%# Eval("ID") %>" type="button" value="Reply" style ="border:0px; background-color :White; color :blue; cursor :pointer " />     
          </a> 
               
     </td>                     
 </tr>
                      
</ItemTemplate>
</asp:TemplateField>

<asp:TemplateField>
<ItemTemplate>

  <!--This is the child gridview -->
<div id="div<%# Eval("ID") %>" style="display: none; position:relative; left: 65px; overflow: auto; margin-top :1px">

<asp:GridView ID="gvChildGrid" runat="server" AutoGenerateColumns="false" BorderStyle="Double"  BorderColor="white" GridLines="None" Width="325px" onrowcommand="gvChildGrid_RowCommand" onrowdatabound="gvChildGrid_RowDataBound">

<Columns >

<asp:TemplateField >
<ItemTemplate >
<tr>
  <td style ="border-bottom :2px solid Blue;border-bottom-color :Gray; border-left :0px; border-left-color :White; border-right :0px; border-right-color :White; border-top :0px; border-top-color :White;background-color :White; height :100px; width :325px">
  
 <asp:Image ID="Image1" runat="server" style=" margin-right :5px; background-image :url('Image/imagebackground.png');"  ImageAlign ="Left" Height ="60px" Width="60px" />
 
 <asp:Label ID="name" runat="server"  Font-Bold="True" Text='<%# Eval("Name")%>' ForeColor="Blue"></asp:Label>           
 <p id ="content" class="minimize" style =" border-radius: 4px 4px 4px 4px; max-width :325px; min-height :5px; margin-top :5px; margin-left :65px; display :block; background-color: #CCCCFF;"> <%# DataBinder.Eval(Container.DataItem,"Replies").ToString() %> </p> 
    
  </td>
</tr>
</ItemTemplate>
</asp:TemplateField>
  
</Columns>

</asp:GridView>

<asp:Label ID="Label1" runat="server" Text="Name"></asp:Label>
   <br />
  <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
  <br />
  <asp:TextBox ID="TextBox2" Height ="200px" Width ="325px" TextMode ="MultiLine" runat="server"></asp:TextBox>
  <br />
  <asp:Button ID="Button1" runat="server" Text="Post Reply" onclick="Button1_Click" />         

</div>

</ItemTemplate>
</asp:TemplateField>
</Columns>

</asp:GridView

Re: Using gridview onrowcommand on saving and displaying the data?

Tom Marvolo Riddle17-Dec-13 17:44

Tom Marvolo Riddle

17-Dec-13 17:44

Hi!
It not a big issue
Place ScriptManager or ToolScriptManager(Ajax) inside the form tag.
Then paste the gridview codeblock inside it.

Try this:

<asp:UpdatePanel ID="UpdatePanel1" runat="server">
    <ContentTemplate>
     //Your gridview code here(<asp:gridview ID="gvParentGrid" runat="server">......</asp:gridview>)
   </ContentTemplate>
    </asp:UpdatePanel>

modified 18-Dec-13 0:55am.

Re: Using gridview onrowcommand on saving and displaying the data?

Member 840570018-Dec-13 5:32

Member 8405700

18-Dec-13 5:32

I tried to use the new mark-up you gave me and I also tried to put the child gridview inside the updatepanel and the last mark up I finally came up to is shown below so I was modifying the mark-up for the third time but none of them works, the problem is getting worse because my gvParentGrid_RowCommand is not firing anymore and it does nothing no matter how many times you click the button. What did we miss from this? Here's my update mark-up on my webform...

ASP.NET

asp:GridView ID="gvParentGrid" runat="server" Width="395px"
AutoGenerateColumns="false"  GridLines="None" BorderStyle="Solid" BorderWidth="0px"
            BorderColor="White" DataKeyNames="ID" onrowcommand="gvParentGrid_RowCommand"
            onrowdatabound="gvParentGrid_RowDataBound" >

<Columns>
<asp:TemplateField >
<ItemTemplate>

 <tr>
     <td id ="comment" class ="highlightab" style ="border-bottom :2px solid Blue;border-bottom-color :Gray; border-left :0px; border-left-color :White; border-right :0px; border-right-color :White; border-top :0px; border-top-color :White;background-color :White;border-bottom :2px solid Blue;border-bottom-color :Gray; border-left :0px; border-left-color :White; border-right :0px; border-right-color :White; border-top :0px; border-top-color :White;background-color :White; height :100px; width :395px; margin-bottom :5px">
              
               <asp:Image ID="Image1" runat="server" style="  margin-right :5px; background-image :url('Image/imagebackground.png');"  ImageAlign ="Left" Height ="60px" Width="60px" />
               <asp:Label ID ="ComID" runat ="server" style="display :none" Text =' <%#Eval("ID") %>' />
              <asp:Label ID="name" runat="server"  Font-Bold="True" Text='<%# Eval("Name")%>' ForeColor="Blue"></asp:Label>
             <p id ="content" class="minimize" style =" border-radius: 4px 4px 4px 4px; max-width :395px; min-height :5px; margin-top :5px; margin-bottom :5px; margin-left :65px; display :block; background-color: #CCCCFF;"> <%# DataBinder.Eval(Container.DataItem,"Comments").ToString() %> </p>
           <a href="JavaScript:divexpandcollapse('div<%# Eval("ID") %>');" style ="margin-left :65px; margin-top :1px" >
             <input id="btndiv<%# Eval("ID") %>" type="button" value="Reply" style ="border:0px; background-color :White; color :blue; cursor :pointer " />
          </a>
               
     </td>
 </tr>
                      
</ItemTemplate>
</asp:TemplateField>

<asp:TemplateField>
<ItemTemplate>

 <asp:UpdatePanel ID="UpdatePanel1" runat="server">
       <ContentTemplate>
  <!--This is the child gridview -->
<div id="div<%# Eval("ID") %>" style="display: none; position:relative; left: 65px; overflow: auto; margin-top :1px">

<asp:GridView ID="gvChildGrid" runat="server" AutoGenerateColumns="false" BorderStyle="Double"  BorderColor="white" GridLines="None" Width="325px" onrowcommand="gvChildGrid_RowCommand" onrowdatabound="gvChildGrid_RowDataBound">

<Columns >

<asp:TemplateField >
<ItemTemplate >
<tr>
  <td style ="border-bottom :2px solid Blue;border-bottom-color :Gray; border-left :0px; border-left-color :White; border-right :0px; border-right-color :White; border-top :0px; border-top-color :White;background-color :White; height :100px; width :325px">
  
 <asp:Image ID="Image1" runat="server" style=" margin-right :5px; background-image :url('Image/imagebackground.png');"  ImageAlign ="Left" Height ="60px" Width="60px" />
 
 <asp:Label ID="name" runat="server"  Font-Bold="True" Text='<%# Eval("Name")%>' ForeColor="Blue"></asp:Label>
 <p id ="content" class="minimize" style =" border-radius: 4px 4px 4px 4px; max-width :325px; min-height :5px; margin-top :5px; margin-left :65px; display :block; background-color: #CCCCFF;"> <%# DataBinder.Eval(Container.DataItem,"Replies").ToString() %> </p>
    
  </td>
</tr>
</ItemTemplate>
</asp:TemplateField>
  
</Columns>

</asp:GridView>


<!-- This is the inputbox and the reply button -->
<asp:Label ID="Label3" runat="server" Text="Name"></asp:Label>
   <br />
  <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
  <br />
  <asp:TextBox ID="TextBox4" Height ="200px" Width ="325px" TextMode ="MultiLine" runat="server"></asp:TextBox>
  <br />
  <asp:Button ID="Button2" runat="server" Text="Post Reply" CommandName="reply" />

</div>
</ContentTemplate>
<Triggers>
  <asp:AsyncPostBackTrigger ControlID="Button2" />
</Triggers>
    </asp:UpdatePanel>   

</ItemTemplate>
</asp:TemplateField>
</Columns>

</asp:GridView

Re: Using gridview onrowcommand on saving and displaying the data?

Tom Marvolo Riddle18-Dec-13 17:23

Tom Marvolo Riddle

18-Dec-13 17:23

I tried a similar one it works fine for me.
Try like this:

    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
        asp:GridView ID="gvParentGrid" runat="server" Width="395px"
AutoGenerateColumns="false"  GridLines="None" BorderStyle="Solid" BorderWidth="0px" 
            BorderColor="White" DataKeyNames="ID" onrowcommand="gvParentGrid_RowCommand"
            onrowdatabound="gvParentGrid_RowDataBound" >
 
<Columns>
<asp:TemplateField >
<ItemTemplate>
 
 <tr>
     <td id ="comment" class ="highlightab" style ="border-bottom :2px solid Blue;border-bottom-color :Gray; border-left :0px; border-left-color :White; border-right :0px; border-right-color :White; border-top :0px; border-top-color :White;background-color :White;border-bottom :2px solid Blue;border-bottom-color :Gray; border-left :0px; border-left-color :White; border-right :0px; border-right-color :White; border-top :0px; border-top-color :White;background-color :White; height :100px; width :395px; margin-bottom :5px">
              
               <asp:Image ID="Image1" runat="server" style="  margin-right :5px; background-image :url('Image/imagebackground.png');"  ImageAlign ="Left" Height ="60px" Width="60px" />
               <asp:Label ID ="ComID" runat ="server" style="display :none" Text =' <%#Eval("ID") %>' /> 
              <asp:Label ID="name" runat="server"  Font-Bold="True" Text='<%# Eval("Name")%>' ForeColor="Blue"></asp:Label>           
             <p id ="content" class="minimize" style =" border-radius: 4px 4px 4px 4px; max-width :395px; min-height :5px; margin-top :5px; margin-bottom :5px; margin-left :65px; display :block; background-color: #CCCCFF;"> <%# DataBinder.Eval(Container.DataItem,"Comments").ToString() %> </p> 
           <a href="JavaScript:divexpandcollapse('div<%# Eval("ID") %>');" style ="margin-left :65px; margin-top :1px" >
             <input id="btndiv<%# Eval("ID") %>" type="button" value="Reply" style ="border:0px; background-color :White; color :blue; cursor :pointer " />     
          </a> 
               
     </td>                     
 </tr>
                      
</ItemTemplate>
</asp:TemplateField>
 
<asp:TemplateField>
<ItemTemplate>
 
  <!--This is the child gridview -->
<div id="div<%# Eval("ID") %>" style="display: none; position:relative; left: 65px; overflow: auto; margin-top :1px">
 
<asp:GridView ID="gvChildGrid" runat="server" AutoGenerateColumns="false" BorderStyle="Double"  BorderColor="white" GridLines="None" Width="325px" onrowcommand="gvChildGrid_RowCommand" onrowdatabound="gvChildGrid_RowDataBound">
 
<Columns >
 
<asp:TemplateField >
<ItemTemplate >
<tr>
  <td style ="border-bottom :2px solid Blue;border-bottom-color :Gray; border-left :0px; border-left-color :White; border-right :0px; border-right-color :White; border-top :0px; border-top-color :White;background-color :White; height :100px; width :325px">
  
 <asp:Image ID="Image1" runat="server" style=" margin-right :5px; background-image :url('Image/imagebackground.png');"  ImageAlign ="Left" Height ="60px" Width="60px" />
 
 <asp:Label ID="name" runat="server"  Font-Bold="True" Text='<%# Eval("Name")%>' ForeColor="Blue"></asp:Label>           
 <p id ="content" class="minimize" style =" border-radius: 4px 4px 4px 4px; max-width :325px; min-height :5px; margin-top :5px; margin-left :65px; display :block; background-color: #CCCCFF;"> <%# DataBinder.Eval(Container.DataItem,"Replies").ToString() %> </p> 
    
  </td>
</tr>
</ItemTemplate>
</asp:TemplateField>
  
</Columns>
 
</asp:GridView>
 
<asp:Label ID="Label1" runat="server" Text="Name"></asp:Label>
   <br />
  <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
  <br />
  <asp:TextBox ID="TextBox2" Height ="200px" Width ="325px" TextMode ="MultiLine" runat="server"></asp:TextBox>
  <br />
  <asp:Button ID="Button1" runat="server" Text="Post Reply" onclick="Button1_Click" />         
 
</div>
 
</ItemTemplate>
</asp:TemplateField>
</Columns>
 
</asp:GridView
       </ContentTemplate>
        </asp:UpdatePanel>

Re: Using gridview onrowcommand on saving and displaying the data?

Member 840570019-Dec-13 4:44

Member 8405700

19-Dec-13 4:44

How does it works for you? Does it the same behavior from the link I gave if you make reply on any comments? Using that mark-up won't still behave the same from that link when you comment I don't know why? I tried also to rebind the ChildGridview after the posting the reply but still the same it won't reload the ChildGridview automatically but you still need to reload the page and go back to reply button before you can see your new reply.

Customize MVC Help

shki17-Dec-13 0:19

shki

17-Dec-13 0:19

Hi,

I am new to MVC but have a basic idea of model, View and Controller. If anybody help me for the following.

1. MVC Tutorials with database first
2. Register using SQL Server Database etc.

Material should help me to start a project with Already created database in MSSQL Server 2008. You can share useful material in form of websites or complete project as well.

Thanks for your cooperation in this regard.

Thanks and Regards
Shakeel

modified 17-Dec-13 8:12am.

Re: Customize MVC Help

JV999917-Dec-13 0:23

JV9999

17-Dec-13 0:23

You didn't even search did you?: http://lmgtfy.com/?q=asp.net+mvc+4+database+first[^]. Because the first 10 google hits on pretty much every possible way you can ask this question, answer your question properly.

I can't really understand how people can develop applications, but can't use google. A developer should be able to use google shouldn't (s)he?

Re: Customize MVC Help

Kornfeld Eliyahu Peter17-Dec-13 0:28

Kornfeld Eliyahu Peter

17-Dec-13 0:28

JV9999 wrote:
A developer should be able to use google shouldn't (s)he?

A developer should be able to tie (s)he's shoes alone, shouldn't (s)he? But in the room with me half of the people going around with untied shoes!!!
With developers nothing obvious...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is (V).

Re: Customize MVC Help

JV999917-Dec-13 0:31

JV9999

17-Dec-13 0:31

What's wrong with sneakers Frown | :(

But true, get your point...

Re: Customize MVC Help

OriginalGriff17-Dec-13 0:44

OriginalGriff

17-Dec-13 0:44

But that's too much like hard work!
You have to, like, work out how to get to google, innit? Then you have to, like, fink of sumfing to look for, innit? Then - horror - you have to, like, read answers and fink bout which might be best, innit?
Then you have to, like, do it, innit? While your pants are, like, round your knees, like, making it difficult to walk, like, innit?

Ask here and they'll do all the finking stuff for you... Sigh | :sigh:

innit?

Re: Customize MVC Help

devenv.exe17-Dec-13 0:35

devenv.exe

17-Dec-13 0:35

This is customized MVC Help for you http://www.asp.net/mvc[^]

"Coming soon"

Re: Customize MVC Help

Pete O'Hanlon17-Dec-13 0:44

Pete O'Hanlon

17-Dec-13 0:44

Well, you're in luck. You have come to the right place. CodeProject is an excellent place to find articles[^] on all sorts of subjects including learning ASP.NET MVC. If you can't find what you want in the plethora of free articles here, then you could always go on over to here[^] for the paid option. If it's developing for mobile applications you're interested in, then take a look at Syncfusion's Succinctly[^] series of books.

Re: Customize MVC Help

Chris Maunder17-Dec-13 2:11

Chris Maunder

17-Dec-13 2:11

And that, my friends, is what we call a gentleman.

Re: Customize MVC Help

Simon Lee Shugar17-Dec-13 1:40

Simon Lee Shugar

17-Dec-13 1:40

I've been learning MVC over the past few weeks as I am using it for my next personal project and to update my CV / portfolio. I would recommend this playlist on Plural sight.

http://pluralsight.com/training/Player?author=scott-allen&name=mvc4-building-m4-data-i&mode=live&clip=0&course=mvc4-building[^]

The tutorial is actually code first but still has a lot of useful informaiton in.

The microsoft ASP MVC site is the best for tutorials as far as I can find.

http://www.asp.net/mvc/tutorials[^]

Simon Lee Shugar (Software Developer)
www.simonshugar.co.uk

"If something goes by a false name, would it mean that thing is fake? False by nature?" By Gilbert Durandil

Re: Customize MVC Help

Rahul Rajat Singh19-Dec-13 18:25

Rahul Rajat Singh

19-Dec-13 18:25

Try these:

Beginner's Guide for Designing ASP.NET MVC Applications using SQL Server and Entity Framework[^]
An Absolute Beginner's Tutorial on ASP.NET MVC for Web Forms Developers[^]
Complete CRUD Operations in MVC 4 using Entity Framework 5 Without Writing a Single Line of Code[^]

Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore, Dream. Discover.

Allow / Deny IP Address via Web.config

Member 947380916-Dec-13 23:05

Member 9473809

16-Dec-13 23:05

Hi,
My host server is :
windows server 2003 and IIS6.
How can i block an Ip Address or allow in webconfig?
I have seen this code but not used for IIS6.

<location path="Default Web Site">
<system.webServer>
<security>
<ipSecurity>
<add ipAddress="192.168.100.1" />
<add ipAddress="169.254.0.0" subnetMask="255.255.0.0" />
</ipSecurity>
</security>
</system.webServer>
</location>

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.