Search:
Type: Posts; User: half flung pie
Search:
Search took 0.06 seconds.
-
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...
-
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...
-
Got it.
INSERT INTO [B] ([AID], [Toggle]) SELECT [Id], 1 FROM @TheIDs
-
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...
-
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]
...
-
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]
...
-
Please delete this post. (Employer is mad I posted bits of company code)
-
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,...
-
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...
-
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...
-
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...
-
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...
-
I have the following function
/// <summary>
/// Pulls info from CSV file and stores each entry as list of string arrays
/// </summary>
/// <param...
-
Excellent, thanks for the lesson! That was exactly what I was looking for.
-
I know for certain the method I posted works, I'm wondering why you say it isn't good.
-
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...
-
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...
-
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] ...
-
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 ...
-
I have an array like
public static string[,] ColumnIndex = {
{"AcademicInterestCD1Act","25"},
...
-
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...
-
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\": {";
...
-
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...
-
I have the code below
SqlConnection sqlConn = new SqlConnection("user id=myusername;" +
"password=mypassword;server=localhost;" +
...
-
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...
-
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:
...
-
I'm not finding any up-to-date tutorials on how to install that database.
-
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?
-
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...
-
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...
-
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...
-
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
-
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...
-
-
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,...
-
Anonymous access is enabled, yes
-
-
That's correct.
I'm running this on my windows 2008 r2 sp1 server with IIS 7.5
-
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...
-
<authentication mode="Forms">
<forms loginUrl="~/Account/Login.aspx" timeout="2880" />
</authentication>
|
Click Here to Expand Forum to Full Width
|