Click here to Skip to main content
15,890,690 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Color.Translator.FromHtml inside off @Html.DisplayFor Issue -Razor Pin
poongunrans28-May-13 20:04
poongunrans28-May-13 20:04 
GeneralRe: Color.Translator.FromHtml inside off @Html.DisplayFor Issue -Razor Pin
Alem.B29-May-13 21:51
Alem.B29-May-13 21:51 
AnswerRe: Color.Translator.FromHtml inside off @Html.DisplayFor Issue -Razor Pin
Richard Deeming29-May-13 2:49
mveRichard Deeming29-May-13 2:49 
GeneralRe: Color.Translator.FromHtml inside off @Html.DisplayFor Issue -Razor Pin
Alem.B29-May-13 21:50
Alem.B29-May-13 21:50 
GeneralRe: Color.Translator.FromHtml inside off @Html.DisplayFor Issue -Razor Pin
Alem.B29-May-13 21:50
Alem.B29-May-13 21:50 
QuestionHow to use i frame in asp.net with dynamic height Pin
Chirag Baroliya R28-May-13 1:44
Chirag Baroliya R28-May-13 1:44 
AnswerRe: How to use i frame in asp.net with dynamic height Pin
poongunrans28-May-13 19:54
poongunrans28-May-13 19:54 
QuestionGridview data bind from DB with stored procedure Pin
Diana Tsilidi27-May-13 15:14
Diana Tsilidi27-May-13 15:14 
Hi everyone! I have a page in an e-shop where i would like someone to be able to view his orders. So i want to display data from an orders table in DB using a stored procedure and checking the userid session, so that the user who is logged in can see his orders. Here is my code:


ASP.NET
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
    DataKeyNames="order_id" DataSourceID="SqlDataSource1">
    <Columns>
        <asp:BoundField DataField="order_id" HeaderText="order_id" 
            InsertVisible="False" ReadOnly="True" SortExpression="order_id" />
        <asp:BoundField DataField="order_date" HeaderText="order_date" 
            SortExpression="order_date" />
        <asp:BoundField DataField="order_value" HeaderText="order_value" 
            SortExpression="order_value" />
        <asp:BoundField DataField="order_status" HeaderText="order_status" 
            SortExpression="order_status" />
    </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:BoardGamesConnectionString %>" 
    SelectCommand="'OrderInfo'" SelectCommandType="StoredProcedure">
    <SelectParameters>
        <asp:Parameter Name="order_id" Type="Int32" />
        <asp:Parameter Name="order_value" Type="String" />
        <asp:Parameter Name="order_date" Type="String" />
        <asp:Parameter Name="order_status" Type="String" />
        <asp:SessionParameter Name="UserID" SessionField="UserID" 
            Type="Int32" />
    </SelectParameters>
</asp:SqlDataSource>


Stored Procedure looks like this:

ALTER PROCEDURE [dbo].[Orderinfo]

    @order_id int,
    @order_value nvarchar(max),
    @order_date nvarchar(max),
    @order_status nvarchar(max),
    @UserID int
   
    
AS

   Select order_id, order_date, order_value, order_status from Orders Where UserID=@UserID And order_status='Εκκρεμεί'


What am i doing wrong? Thanks in advance! Smile | :)
AnswerRe: Gridview data bind from DB with stored procedure Pin
Prince Sagayaraj28-May-13 9:49
professionalPrince Sagayaraj28-May-13 9:49 
QuestionProblem with SmarterStats webservice Pin
Jassim Rahma27-May-13 11:57
Jassim Rahma27-May-13 11:57 
AnswerRe: Problem with SmarterStats webservice Pin
Richard MacCutchan27-May-13 21:13
mveRichard MacCutchan27-May-13 21:13 
AnswerRe: Problem with SmarterStats webservice Pin
Bernhard Hiller28-May-13 22:37
Bernhard Hiller28-May-13 22:37 
Questionattach multiple attachments to the mail dynamically Pin
revathilavi26-May-13 18:52
revathilavi26-May-13 18:52 
AnswerRe: attach multiple attachments to the mail dynamically Pin
Richard MacCutchan26-May-13 21:57
mveRichard MacCutchan26-May-13 21:57 
GeneralRe: attach multiple attachments to the mail dynamically Pin
revathilavi27-May-13 1:52
revathilavi27-May-13 1:52 
AnswerRe: attach multiple attachments to the mail dynamically Pin
Blikkies27-May-13 0:46
professionalBlikkies27-May-13 0:46 
GeneralRe: attach multiple attachments to the mail dynamically Pin
revathilavi27-May-13 1:52
revathilavi27-May-13 1:52 
AnswerRe: attach multiple attachments to the mail dynamically Pin
Aatif Ali from Bangalore12-Jul-13 1:11
professionalAatif Ali from Bangalore12-Jul-13 1:11 
AnswerRe: attach multiple attachments to the mail dynamically Pin
Aatif Ali from Bangalore12-Jul-13 1:12
professionalAatif Ali from Bangalore12-Jul-13 1:12 
QuestionMVC4 Cascading DropDownList - reference selected value Pin
Andy_L_J26-May-13 3:04
Andy_L_J26-May-13 3:04 
QuestionSys.WebForms.PageRequestManagerServerErrorException: Input string was not in a correct format. IE 10 Pin
Vimalsoft(Pty) Ltd24-May-13 9:05
professionalVimalsoft(Pty) Ltd24-May-13 9:05 
AnswerRe: Sys.WebForms.PageRequestManagerServerErrorException: Input string was not in a correct format. IE 10 Pin
Vimalsoft(Pty) Ltd24-May-13 11:26
professionalVimalsoft(Pty) Ltd24-May-13 11:26 
QuestionAsp.net Pin
Tejas_9124-May-13 0:31
Tejas_9124-May-13 0:31 
QuestionRe: Asp.net Pin
ZurdoDev24-May-13 4:28
professionalZurdoDev24-May-13 4:28 
AnswerRe: Asp.net Pin
wikizhao27-May-13 21:22
wikizhao27-May-13 21:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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