User Profile

Collapse

Profile Sidebar

Collapse
ilearneditonline
ilearneditonline
Last Activity: Nov 8 '10, 11:28 PM
Joined: Jul 11 '07
Location: Atlanta
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ilearneditonline
    replied to How to execute a stored procedure in C#
    in .NET
    Code:
     
using (SqlConnection cn = new SqlConnection(<your connection string>)
{ 
SqlCommand cmd = new SqlCommand("spPastelConfig", cn);
cmd.Parameters.Add("@ServerName", SqlDbType.VarChar, 50).Value = this.ServerName;
cmd.Parameters.Add("@dbName", SqlDbType.VarChar, 50).Value = this.DatabaseName;
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
cmd.ExecuteNonQuery();
    ...
    See more | Go to post

      Leave a comment:

    • ilearneditonline
      replied to hi
      in .NET
      Actually, i don't believe this would work as they are using a standard HTML textbox, not an asp:textbox. If they are using standard HTML, then when the form is posted they would need to do a request.

      Code:
      variable = Request.Form["TextBox1"].ToString().Trim(); //c#, vb would be slightly different.
      I would switch to an <asp:textbox> control then you could get the value as you mentioned above. I would also make...
      See more | Go to post

        Leave a comment:

      • ilearneditonline
        replied to Repeater Control - ASP.NET
        in .NET
        Do you have a Data Source associated with it? If you are doing it from ASP.NET, then you would have a DataSourceID in your tag.
        [CODE=ASP]
        <asp:Repeater runat="server" ID="rpt" DataSourceID="o bjMovies">
        <ItemTemplate >
        <asp:TextBox runat="server" ID="txtTitle" Text='<%# Eval("DVDTitle" ) %>' /><br />
        </ItemTemplate>
        ...
        See more | Go to post

          Leave a comment:

        • ilearneditonline
          replied to ASP (not .NET) server-side timer
          in ASP Classic
          Alot of hosting providers allow you to set up cron jobs. Are you positive yours does not allow it??...
          See more | Go to post

            Leave a comment:

          • ilearneditonline
            replied to ASP - new line
            in ASP Classic
            Have you tried using... I am not sure it will work but I got in the habit of using "\n" when i wanted a new line.
            [PHP]
            strBodyText = "Dear somebody" & "\n"
            strBodyText = strBodyText &"Thank you," & "\n"
            strBodyText = strBodyText & "text" [/PHP]...
            See more | Go to post

              Leave a comment:

            • ilearneditonline
              replied to asp and asp.net
              in ASP Classic
              Can you provide some additional details, maybe the error that you are receiving? I know you had ASP.NET enabled, but are you sure that Classic ASP is enabled....
              See more | Go to post

                Leave a comment:

              • ilearneditonline
                replied to asp and asp.net
                in ASP Classic
                You have to enable ASP in IIS Management. Under Web Service Extensions, ensure that Active Server Pages is enabled....
                See more | Go to post

                  Leave a comment:

                • ilearneditonline
                  replied to ASP Error
                  in ASP Classic
                  Can you please provide the code that you are using. The error is pretty self explanatory, but without seeing what you are doing, there isn't really any way to see why....
                  See more | Go to post

                    Leave a comment:

                  • ilearneditonline
                    replied to SQL Query Pause
                    in SQL Server
                    Great. This fixed my issue. Anyone else looking at this, the MS LINK...
                    See more | Go to post

                      Leave a comment:

                    • ilearneditonline
                      replied to Recordset Problem / asp, vbscript, Ms Access
                      in ASP Classic
                      I would split out the inner queries and write a couple of functions. Then I would call the functions from the loop.
                      See more | Go to post

                        Leave a comment:

                      • ilearneditonline
                        started a topic SQL Query Pause
                        in SQL Server

                        SQL Query Pause

                        I have 2 insert statements that I have to run at the end of a stored procedure.

                        But I need to pause for 5 seconds between the first and the second. Is there any way to do this?
                        See more | Go to post
                        • ilearneditonline
                          replied to Where is the submit button?
                          in ASP Classic
                          I would think it is on the page. But if it isn't showing, there is probably something else besides this piece of code for the button. Can you provide some additional details....
                          See more | Go to post

                            Leave a comment:

                          • ilearneditonline
                            replied to Database Linking (DBF)
                            in ASP Classic
                            You may want to try this LINK to have a look at the connection string....
                            See more | Go to post

                              Leave a comment:

                            • ilearneditonline
                              replied to Peculiar data mismatch SQL Statement issue in ASP...
                              in ASP Classic
                              Try ...

                              [code=asp]SQLQuery = "select description,qty ,price from purchase where Username = '"&UserName& "' AND orderNo = "&orderNo[/code]
                              Since orderNo is a number, you don't use the single quotes. Single quotes makes it a string value and that would be a data type mismatch....
                              See more | Go to post

                                Leave a comment:

                              • ilearneditonline
                                replied to Need Help with WHERE and ORDER BY in code. New to ASP
                                in ASP Classic
                                You don't really need to add the ASC as that is the default. Unless you were doing something like ORDER BY date DESC, id ASC
                                See more | Go to post

                                  Leave a comment:

                                • ilearneditonline
                                  replied to Need Help with WHERE and ORDER BY in code. New to ASP
                                  in ASP Classic
                                  Microsoft Link
                                  The main problem i see is that you were adding your WHERE and ORDER BY clauses after the ActiveConnectio n oject. Plus you spelled ORDER incorrectly.

                                  [CODE=asp]
                                  SELECT * FROM "&tableName &" WHERE "&strCriteriaBy &"=202 ORDER BY "&StrOrderB y, DB, 1, 3
                                  [/CODE]...
                                  See more | Go to post

                                    Leave a comment:

                                  • ilearneditonline
                                    replied to Looking for a way to connect to MS Access using server-side JavaScript ASP
                                    in ASP Classic
                                    Here is something from an app i did years ago with JavaScript as the server side code in ASP.

                                    I can tell you from my personal experience, don't do this with JavaScript. Use VBScript or you will spend hours trying to get anything to work and there are so few people that walked this path.

                                    [CODE=asp] Response.Expire s = 0;
                                    Response.Buffer = true;
                                    var conn = Server.CreateOb ject("ADODB.Con nection");...
                                    See more | Go to post

                                      Leave a comment:

                                    • ilearneditonline
                                      replied to Calling a Stored Procedure in an ASP Page
                                      in ASP Classic
                                      If this is classic ASP, then the solution Jared recommended would be the easiest to implement. If this is ASP.NET, then you just associate the method with the button. If it is vb.net then it would be something like...

                                      [CODE=vb] Protected Sub Button1_Click(B yVal sender As Object, ByVal e As System.EventArg s) Handles Button1.Click
                                      ' call you stored procedure
                                      End Sub[/CODE]

                                      c#
                                      [code=c]// in the asp.net...
                                      See more | Go to post

                                        Leave a comment:

                                      • ilearneditonline
                                        replied to submitting form with javascript
                                        in Javascript
                                        I am far from a javascript expert and would not even rate myself at intermediate. But whenever I reference a form element, I always do..

                                        [code=javascript]
                                        document.frm_in dex.method="pos t";
                                        document.frm_in dex.action="Log in_amit.asp?mod e=login";
                                        document.frm_in dex.submit();

                                        // not
                                        // frm_index.metho d="post"
                                        [/code]

                                        I don't know if it actually makes...
                                        See more | Go to post

                                          Leave a comment:

                                        • ilearneditonline
                                          replied to Updating a record
                                          in ASP Classic
                                          Also, depending on the database, this query would not work if the eventid is a numeric value. In that case it would be
                                          [code=asp]sql="SELECT * FROM shows WHERE EventID=" & cid[/code]

                                          Also, when I am having problems like this, I would print out the SQL rather than execute it. Then I would run the output directly against the database with whatever interface is available. MS SQL i would use query analyzer. This way...
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...