View Complete Post
I've used the automatic Many-to-Many generation as described here: http://msdn.microsoft.com/en-us/library/dd742359.aspx
But that doesn't seem to allow a quantity to be attached to orders (in the example it would be courses). I have many customers and many products, I would like a customer to be able to order more than one product. Right now I get a grid of checkboxes. I would like instead a field where I could enter a number.
Is this possible?
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 currently creating a program that accesses a mysql package to add data to a few tables. I'm currently getting an error that says "
These lines are
42: INSERT INTO WP_PROJECTS_USERS (PROJECT_USERS_ID, FIELD_UNIT_ID, PROJECT_ID, USER_ID, START_DATE, DESCRIPTION)
and 177:add_team_members(V_PROJECT_ID, V_START_DATE, v_FISC_YEAR, V_MEMBERS ,V_NUM_MEMBERS,'add');
Checking these variables in my asp.net page they are all receiving parameters.
Is there a way to see what the database is actually receiving from the asp.net page?
Or is there another thing to be looking at?
I am using fluent NHibernate with WebForms and I am trying to build a page where I allow a user to post a status update on their profile page and I a using a .asmx WebService to post the data to the database and then returnig a StatusUpdate instance to the page to be used by jQuery. I have a couple problems.
1) First off when I return a string from the WebService(i was testing) the textbox where the user enters their status doesnt empty the contents. And since the page doesnt refresh even if I manally clear out the textbox and put in something else, it still posts the previous status to the database again. How do I fix this?
2) Secondly, when I return the StatusUpdate Object from the Webservice I cant the results to display anything. Like I sad, Im using jQuery to make an AJX call to the WebService.
Here is my code:
User Profile Page:
Status: <asp:Label ID="status" runat="server"></asp:Label><span style="font-size:.7em;"><asp:Label ID="statustime" runat="server"></asp:Label></span><br />
<textarea id="statusBox" rows="3" cols="40"></textarea><br />
<input type="button" value="Update Status" onclick="SetStatus(); return false;
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
Windows Azure is already helping many companies move their apps into the cloud. We'll share some of the tips and tricks that we discovered working with customers on real-world migrations.
George Huey, Wade Wegner
MSDN Magazine August 2010
SOA makes application scalability easier, but getting the best performance out of your SOA means paying close attention to the details. We'll give you some tips for coding your app more effectively and using distributed caching to remove data access bottlenecks.
MSDN Magazine June 2010