where do basic SQL questions go?
and what does SSIS stand for?
View Complete Post
I have never tried a group by with linq, now I do and I'm stuck.
I try to convert this sql statement to its linq counterpart :
SELECT COUNT(tb_Mailer_Smses.Id) AS [cnt], tb_Mailer_mailing.Id As [Id]
,SUM( CASE WHEN tb_Mailer_smses.DLRStatus = 200 THEN 1 ELSE 0 END) As [Delivered]
,SUM(CASE WHEN DLRStatus BETWEEN 300 AND 499 THEN 1 WHEN DLRStatus BETWEEN 800 AND 899 THEN 1 END) AS [Errors]
FROM tb_Mailer_mailing INNER JOIN
tb_Mailer_Smses ON tb_Mailer_mailing.Id = tb_Mailer_Smses.MailingId
WHERE tb_Mailer_mailing.ApplicationId = 1
GROUP BY tb_Mailer_mailing.Id
Is there some one who can me show me the convertion process ?
I'm new to ASP.NET, so please excuse my stupid questions^^
I have already done many tutorials but i don't understand how to work with that membership thing.
If I click on my project and select ASP.Net Configuration I can Setup Users, Roles and so on. But where do they get saved?
How does this ASP.Net Configuration behave after the page goes live, i don't want anybody who knows the adress of this "backend" to access it.
Many Questions, perhaps easy answers...
Maybe you have a good tutorial for me, beacause i didn't find one that explained the whole security subject to me.
Can anyone help me please?
I have been producing a registration form using html and asp. I have managed to get it to send an email having copied script from a previous website which someone developed for me. I now get the response going to the old address and with then old text. How can I change it all to the new site?
This has been very frustrating as I am sure someone is going to say all I have to do is ...
In MVC I can't find this option.
I mean with no any framework (entity framework, Sub sonic, Link to SQL etc')
I look for basic application that works with data but with no fw.
C# Soup To Nuts (the best series ever)
I watch some of the MVC video, seems that the music store is good but I have to wait to the other part.
Does any one know and recommend a Microsoft MVC tutorial?
I am running Windows 7 and I have gone into Control Panel and activated all of the IIS Functions.
The web application I am running was downloaded from the net (and has worked on other machines previously). Once I downloaded it, I moved it into C:/inetpub/wwwroot/code/main.asp
I am a bit of a novice at this! But I am hoping someone can point me in the right direction!
I get the following error when I try and run the web application through IE:
"An error occurred on the server when processing the URL. Please contact the system administrator. If you are the system administrator please click here to find out more about this error."
(When i click the "click here" button it just goes to the IIS site).
Appreciate any help I can get!
I created a getter and Setter in Visual Basic. I have some questions though. Please look at the code below.Here are my questions.
A.) At line 1 below, should "pieces" be declared as Private?B.) In the IDE at lines 4 and 7 the IDE keeps changing those variables to uppercase so that the property name "Pieces" is the same as the variable name "pieces".Should I instead define the integer pieces with an underscore: _pieces ?That is the only way I can get around the IDE forcing the variable to become uppercase.
1 Dim pieces As Integer
2 Public Property Pieces() As String3 Get
4 Return pieces5 End Get
6 Set (ByVal values As String)7 pieces=value8 End Set9 End Property
Visual Studio 2010 lets you create applications that target versions of the Microsoft .NET Framework from 2.0 to 4, and each step in between. We take a look at how multi-targeting works in Visual Studio today, and explain how you should approach multi-targeting in your projects.
MSDN Magazine June 2010
Learn about what's new in Visual Basic 10 straight from a program manager on Microsoft's Visual Basic team. Jonathan Aneja demonstrates time-saving features that help developers get more done with fewer lines of code.
MSDN Magazine April 2010