Search:

Type: Posts; User: half flung pie

Page 1 of 9 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    1
    Views
    2,310

    3.0/LINQ Re: Trouble mapping objects

    Figured it out, actually.

    At the time of doing my .Select, dbResults was still an IQueryable. I think that caused the IQueryable to try to convert the TryParse to SQL. I simply snuck a...
  2. Replies
    1
    Views
    2,310

    3.0/LINQ [RESOLVED] Trouble mapping objects

    dbResults is an IQueryable of type CUSTOMER which is an entity framework model of the table "CUSTOMER". In the table, the SSN field is a varchar. I'm trying to map these to my application's Customer...
  3. Re: [SQL] Insert multiple rows into table, where one column of values is a table

    Got it.


    INSERT INTO [B] ([AID], [Toggle]) SELECT [Id], 1 FROM @TheIDs
  4. [RESOLVED] [SQL] Insert multiple rows into table, where one column of values is a table

    I have generated a local table

    DECLARE @TheIDs TABLE (Id int)

    and populated it full of integers.

    I want to be able to insert into table B, rows where the first column is from those IDs, and...
  5. Replies
    1
    Views
    732

    4.0 Re: List XML Serialization

    Actually, I figured it out. It never fails that after posting here, I figure out a different way to word my question and search for the answer.

    Here's what I'm using now:

    [XmlRoot]
    ...
  6. Replies
    1
    Views
    732

    4.0 [RESOLVED] List XML Serialization

    I have a permissions xml file which I am able to serialize and deserialize, but it is rather verbose and I was hoping someone could help me with that.

    Here's what I'm using

    [XmlRoot]
    ...
  7. Thread: Delete

    by half flung pie
    Replies
    0
    Views
    828

    Delete

    Please delete this post. (Employer is mad I posted bits of company code)
  8. Re: setting picturebox.image with valid image, nothing happens

    It's located in a button's press event. The code is definitely being executed because temp.Save definitely writes to the filesystem. I set up a breakpoint on picMapImage.Image = temp; and it was hit,...
  9. [RESOLVED] setting picturebox.image with valid image, nothing happens

    I have some code that generates an image, and apparently that works fine. I can save the image and open it in paint, for example, and it looks correct. However, when I set my picturebox's image...
  10. Re: [SQL] Need help getting time between rows

    Kind of forgot I was supposed to be making a view... so I had to restructure things. Eventually figured it out though.

    ALTER VIEW [StageLengths]
    AS
    WITH rows AS
    (
    SELECT *, ROW_NUMBER() OVER...
  11. Re: StreamReader readline() split only at newlines that are not encapsulated in quote

    So what I ended up doing is creating an extension on StreamReader to read it line-by-line until the number of double quotes in it is even.

    Here is my extensions class:

    public static class...
  12. [SQL] Need help getting time between rows

    I've almost got what I need already, except for one minor (yet important) detail.

    I have a table
    SELECT [ID_NUM]
    ,[HIST_STAGE]
    ,[JOB_TIME]
    FROM [STAGE_HISTORY_TRAN]
    WHERE...
  13. [RESOLVED] StreamReader readline() split only at newlines that are not encapsulated in quotes

    I have the following function

    /// <summary>
    /// Pulls info from CSV file and stores each entry as list of string arrays
    /// </summary>
    /// <param...
  14. Re: [SQL] Update table A with values from table B

    Excellent, thanks for the lesson! That was exactly what I was looking for.
  15. Re: [SQL] Update table A with values from table B

    I know for certain the method I posted works, I'm wondering why you say it isn't good.
  16. Re: [SQL] Update table A with values from table B

    I think I actually just figured out problem 1, could I get confirmation that this is a logical way to do this?


    UPDATE [ExistingTBL] SET [TheColumn] = (SELECT [IncomingTBL].[TheColumn] FROM...
  17. [SQL] Update table A with values from table B

    I have two tables with identical column structure. One is a holding table for import processes. The other is a live data table. Both tables have an [ID] column (int). For the sake of this post, I'll...
  18. Re: [Query] Join two tables and count

    Nevermind...


    SELECT DISTINCT dh.[EXIT_REASON], td.[TABLE_DESC], COUNT(dh.[EXIT_REASON])
    FROM [DEGREE_HISTORY] as dh
    LEFT JOIN [TABLE_DETAIL] as td
    on dh.[EXIT_REASON] = td.[TABLE_VALUE] ...
  19. [RESOLVED] [Query] Join two tables and count

    I'm having trouble constructing a SQL statement to report the following

    Exit code
    Exit Description
    Count of people with that code


    I can get the exit codes and the count by running ...
  20. Replies
    1
    Views
    1,136

    [RESOLVED] searching in a 2D array

    I have an array like

    public static string[,] ColumnIndex = {
    {"AcademicInterestCD1Act","25"},
    ...
  21. Re: Need advice parsing SQL data into a specific format

    I managed to get it working, but I'm sure there must be a much better way to do this...


    private string get7DayFlotDataset()
    {
    string theHTML = "";
    SqlConnection...
  22. Need advice parsing SQL data into a specific format

    I have a SQL table that logs pageviews. It has columns ,[page] ,[userguid] ,[ip] ,[datetimeaccessed].

    Ultimately, I need the data to end up like this:

    theHTML += "\"about\": {";
    ...
  23. VS 2010 Re: Login failed for user 'IIS APPPOOL\asptest'.

    Apparently my connection string was wrong. I just changed it to this and it worked fine.


    SqlConnection sqlConn = new SqlConnection("Data Source=localhost;Initial Catalog=mydb;User...
  24. VS 2010 [RESOLVED] Login failed for user 'IIS APPPOOL\asptest'.

    I have the code below

    SqlConnection sqlConn = new SqlConnection("user id=myusername;" +
    "password=mypassword;server=localhost;" +
    ...
  25. VS 2010 Confusion with labels in master file

    In my site.master file, I have

    <asp:Label ID="lblreal_name" runat="server"></asp:Label>

    In the codebehind, site.master.cs, I'm trying to do something like

    protected void Page_Load(object...
  26. VS 2010 Re: Login via credentials stored in SQL table

    Excellent, thanks. I was able to install the membership database. Now I'm running into another issue. My asp web site is not able to connect to SQL Server.

    I edited my web.config to say this:

    ...
  27. VS 2010 Re: Login via credentials stored in SQL table

    I'm not finding any up-to-date tutorials on how to install that database.
  28. VS 2010 Re: Login via credentials stored in SQL table

    Yes, but how would I use that to connect to my 'accounts' table and use columns 'id', 'username', and 'password'? And how would I pull the currently-logged-in-user's id?
  29. VS 2010 [RESOLVED] Login via credentials stored in SQL table

    I would like to create a site that allows people to log in. I would like to have the ability, in my codebehind, to say things like

    if(userIsLoggedIn){ //then whatever }
    and to be able to get the...
  30. Replies
    0
    Views
    1,829

    [RESOLVED] access denied

    I've written a program that pulls a directory from a registry key, then tries to delete all files in that directory.

    I keep getting this message:
    Access to the path...
  31. VS 2010 Re: Problem with IIS setup, perhaps?

    I am the IT department :p


    Users was not originally listed in the security settings for this folder. I have added it with "Read & execute," "List folder contents," and "Read" permissions and IT...
  32. VS 2010 Re: Problem with IIS setup, perhaps?

    Sorry, I'm not following you


    Unfortunately I have only one server to work with, but others have tried the zip I posted earlier on their IIS installations and it works for them
  33. VS 2010 Re: Problem with IIS setup, perhaps?

    The asptest site is using the asptest Application Pool

    The asptest Application Pool is set to .NET Framework v4.0.30319, Integrated, Start application pool immediately

    Permissions for...
  34. VS 2010 Re: Problem with IIS setup, perhaps?

    Sure thing, here you go
  35. VS 2010 Re: Problem with IIS setup, perhaps?

    I just poured through the event viewer after refreshing the site. There are no events in any of the categories from 8:14, which is when I refreshed the page. There have been no events since then,...
  36. VS 2010 Re: Problem with IIS setup, perhaps?

    Anonymous access is enabled, yes
  37. VS 2010 Re: Problem with IIS setup, perhaps?

    No change
  38. VS 2010 Re: Problem with IIS setup, perhaps?

    That's correct.

    I'm running this on my windows 2008 r2 sp1 server with IIS 7.5
  39. VS 2010 Re: Problem with IIS setup, perhaps?

    HTTP Error 401.3 - Unauthorized

    You do not have permission to view this directory or page because of the access control list (ACL) configuration or encryption settings for this resource on the Web...
  40. VS 2010 Re: Problem with IIS setup, perhaps?

    <authentication mode="Forms">
    <forms loginUrl="~/Account/Login.aspx" timeout="2880" />
    </authentication>
Results 1 to 40 of 324
Page 1 of 9 1 2 3 4



Click Here to Expand Forum to Full Width