Using Results Outside Of DbContext
Mar 23, 2012[code]How can I compare the results of qperson to qyou? Since the results "disappear" once End Using is executed?
View 3 Replies
ADVERTISEMENT
Asp.net Mvc - Saving A Nested Collection With MVC 3, EF 4.1, DbContext, And AutoMapper
Apr 29, 2011I am having difficulty getting a nested collection (Tags in my case) to commit back to the database after being passed into my controller. I am using EF 4.1 with the DbContext API, MVC 3, and Automapper.
My Models:
Partial Public Class Proposal
Public Property Id As Integer
Public Property Memo As String
[Code].....
VB - Entity Framework 4.1: Describe Relationship Into The DbContext Definition Using A Fluent Code First Approach?
Dec 5, 2011I have in my database a table (AccessControl) that describes a sort of users "access control list" for the informations contained in the table Customers and other tables.Example: the entity CUSTOMER is marked by the EntityId #1. If a user belongs to the department #6, he can access the records of customer #16 and #31, but he can't for #14, that can viewed by user in department #3:
[code]...
How can I describe this relationship into the DbContext definition using a fluent Code First approach?
Show The Final Results Instead Of The Results Real-time
Sep 28, 2010I have a form that allows users to select file and then it reads the contents, parses the data and then executes a sql insert statement to add it to a database. What I am having issues with is showing real-time results. Currently, I have the import operation take place on the import form within the OnLoad event. The problem with this is it only shows the final results instead of the results real-time. Is there anyway to do this without creating a seperate thread and delegates?
View 1 RepliesProgram - Results For The Quit Command Input Of -999 But Rather Just To Quit Without The Results?
Jul 22, 2009How can I make this program not to give me the results for the quit command input of -999 but rather just to quit without the results?
Sub Main()
Dim TempIncelsius As Double
Dim TempInput As Double
Dim Formula As Double
[CODE]...
Different Results - Step-Through Vs Run
Feb 15, 2012I have created a program that randomly produces simple maths questions and saves them to a SQL Server (SQL Server 2008 R2). The code looks fine and works if I step through the program. Each pass it creates a random question answer and saves them to the database. However, if I run it (Debug/Release), the program produces a question and answer but repeats it in the database.
[Code]...
Get Raw Xml Results From A Web Service?
Apr 11, 2011how to get raw xml results from a web service.
So for instance i have Dim mWeb as new WebServiceName
mWeb.SearchParameter1 = "12345"
How can i turn in the results to raw xml?
Handle Results Of More Than 1 Row
May 6, 2009I am having a SP run in my VB application every 10 seconds to check for any new rows that have been inserted to the database since the last check. What is the best way to do this? Most likely it will be 0 or 1 rows, but I am afraid at random times it maybe more than 1 and so I thought I would fill it in a DataSet, but I came in here to see if there are any other better ways. If dataset is the best way, how do I do a For Each Row in the dataset to process some VB code for each row?
View 20 RepliesLinq To Xml - No Results Sometimes?
Jul 13, 2011Ok i have a query i use to parse an xml file to get an id number of a movie that allows me to get more detailed information about that movie from a database.Now the problem is the id is returned correctly with xml files stored on my hard drive (c:\desktop\movies)but when i try and parse an xml file on an external drive it dont get a hit on the <id>1123</id> node.
query
Function movieID(ByVal directory)
'Get the movie name
[code].....
Need All Results From Query
Mar 15, 2011I have setup an OleDbConnection and my query works just fine but the problem I am facing is that I want the entire query not just a certain row or column. I also would like to place this entire query into a blank excel spread sheet.[code]
View 1 RepliesNo Results From Build?
Jun 20, 2011I am running VB from VS2005. I just had to change a program to revises the logon info for a database. When I run build, I get success and there are no errors in the error page. The only thing I can think is that the first two times I ran the build I have the configuration set for 2 copies. It never bothered me before but some update may have come in and changed that. I reset it to 5 and that did not help. I closed VS and re-opened, no help. I created a new folder and moved the contents of the release folder out so that nothing was left. After running the build several more times, the release folder is still blank.
View 5 RepliesWant To Put The Results In A Datagrid?
Apr 14, 2010Im creating a search button, and want to put the results in a datagrid. I want to view specific records depending on the keyword inputed by the user. Im having errors when I use this query
View 27 Replies2 SQL Statements The Same? Will They Produce The Same Results?
Aug 22, 2011Are the following 2 SQL statements the same? Will they produce the same results?
sql1 = "SELECT * FROM [StudentDetials] WHERE ([Subject1] LIKE '" & Subject(0) & "' OR [Subject2] LIKE '" & Subject(0) & "') AND ([Day1] LIKE '" & TabDay & "' OR [Day2] LIKE '" & TabDay & "') AND ([Time1] >= '" & Time(0) & "' AND [ETime1] <= '" & Time(1) & "' OR [Time2] >= '" & Time(0) & "' AND [ETime2] <= '" & Time(1) & "')"
sql1 = "SELECT * FROM [StudentDetials] WHERE ([Subject1] LIKE '" & Subject(0) & "' AND [Day1] LIKE '" & TabDay & "' AND [Time1] >= '" & Time(0) & "' AND [ETime1] <= '" & Time(1) & "') OR ([Subject2] LIKE '" & Subject(0) & "' AND [Day2] LIKE '" & TabDay & "' AND [Time2] >= '" & Time(0) & "' AND [ETime2] <= '" & Time(1) & "')"
In my case they simply produce the same results but that's because of the data i'm using.
Equation With Multiple Possible Results
Jul 30, 2011I have a decent understanding of the logic, the content. I'm working on a puzzle and I'd like to write a short program. I'm looking to fill in the following variables: AB.CDE FG.HIJ (they're part of coordinates, and the puzzle is part of a geocache)
The puzzle asks you to determine which numbers correspond to certain colors, like this:
[code...]
I need to define A-J as >= 0 and <=9. I also need to say that each color is >= 0 and <=9, but that no color can be equal to another color (purple ≠yellow, orange, etc). some number combinations won't work. Purple and yellow can't be 2 and 5 respectively, because that'd produce a negative number. I'm guessing that there will be more than one possible result. So how do I create an equation that calculates this.
.net - Identical If() And If Yield Different Results
Dec 22, 2010What is the difference in the two blocks of code below? I expected them to return the same result, but they don't.
In the case where xml.@Type = "null", I want PatientMetricTypeID (a nullable Integer) to end up being Nothing.
Block #1: If()
In this case, it ends up as 0. It looks like Nothing is being treated as an Integer and converted to 0. I can sort of see why this might happen but not fully... I would like to understand exactly how this works, and if there is a workaround.
Dim PatientMetricTypeID As Integer? = If(xml.@Type = "null",
Nothing,
CType([Enum].Parse(GetType(PatientMetricTypes), xml.@Type), Integer))
Block #2: If
In this case, it ends up as Nothing -- expected behavior.
Dim PatientMetricTypeID As Integer?
If xml.@Type = "null" Then
[CODE]...
.net - Results Different When Break Into The Code?
Nov 21, 2011I created a small vb.net console app in visual studio 2008 trying to learn .net but my results show differently when I break in the code and press F11 to step through. If I do it this way, the results I expect to get show but if I don't break into the code the results aren't what I'm expecting.
Basically everytime I click a button i want to write four numbers that are random. If I break into the code, these show random numbers i.e. 1 3 4 3 but if i don't break into the code. my numbers are all the same i.e.1 1 1 1. Here is my code, like I said I'm still learning so the logic is probably not correct.
[Code]...
Asp.net - Dropdownlist Results In Gridview?
Aug 19, 2009I'm having some trouble getting the results of the drop-downs in a gridview, and haven't found any helpful articles for VB code.
What I'm trying to do is build a site for tests. So far I have the gridview built w/the extra column for a drop-down list where the true/false answer will be selected. When the test is completed, there is a submit button. All is well except I need to be able to get the results of each drop-down list on post-back to a variable or array (each test contains 10 questions) so the results can be checked/graded. When the results are determined I would like to display a label in it's place and change the text value accordingly (correct or incorrect), so I'll need to be able to enumerate these as well (i.e. label1.text="Correct!", label2.text="Incorrect!", etc...).
Code so far.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" BackColor="White" BorderColor="#3366CC"
BorderStyle="None" BorderWidth="1px" CellPadding="1">[code].......
The preceding code loads 10 rows, 2 columns (column1:Question | column2-[DropDownLists]:Answer). I'm a freshman when it comes to development, so if you need additional info let me know.
Bitwise Shift - Getting Different Results In C#.net Vs PHP
May 15, 2011When I run this command in PHP, I get:
[Code]...
The interesting thing is, that when I try to shift any number greater than int32 in .net, it yields bad results.. Every number under int32 (2147483647) yields the same results from php and c#.net or vb.net Is there a workaround for this in .net?
C# - Control.PointToScreen Gives Different Results?
May 26, 2009I have some Label controls sitting on Panel controls on a Form. I want to get the labels'positions relative to the form's origin so that at run time I can hide the panel and the labels and draw some other text in their place directly onto the form.Basically, I'm doing the following calculation: Get the absolute screen position of a label withControl.PointToScreen() and convert it back to a relative position with
View 2 RepliesCannot Use SB_GETTEXT (results In A Crash)
Jul 30, 2010I'm currently trying to send the SB_GETTEXT message to a status bar, but it always crash and I don't why (the SB_GETTEXTLENGTH works fine, but not the SB_GETTEXT). Below is a VBA code I tried to use in Excel to read the status bar text of Worpad. The first code using WM_GETTEXT works well, but the second code that uses SB_GETTEXT always crashes.
'------------------------------------------------------------------------------------------------------------------------
' VBA - Excel 2007
'------------------------------------------------------------------------------------------------------------------------
'API & CONSTANTS declaration
[code]....
Copy SP Results To Clipboard?
Sep 21, 2011This is kind of a two part question. I'm trying to make a very simple automated program that will run two stored procedures (one that updates, one that displays the new results) and then copies the results to the clipboard and pastes it in a new e-mail. I already have the e-mail generating and grabbing whatever is on the clipboard, but I need help with the store procedures.
Every guide I look at on Google seems to show a slightly different way of working with SQL, but I threw this together and need to know if it's working. I don't get any errors and the program "hangs" about as long as it takes for the actualy SP to run, but how do I get the "rows affect" output into a textbox or something?[code]...
Counting Results In Object?
Feb 3, 2012Counting results in Object?
View 7 RepliesDifferent Results On Subsequent Runs
Jan 6, 2012I have made a program that minimizes a function of several variables. My question is why I keep getting diffrent results on subsequent runs? The inputs of all runs are same.
View 3 RepliesDisplay SQL Results In MsgBox?
Mar 12, 2012I need to ba able to display the results from sql into a MsgBox and have the option Yes/No.
My SQl is : SELECT account FROM Ta Where cost=0.
this will return about 10-15 rows, i need to see te accounts with o cost befor i continue.
Display Results In Listbox
Mar 17, 2010[code]I have a listbox, 4 radio buttons,a textbox and a button. I want the user to type in a number into the textbox, click on 1 radio button(multiplication) and then click on the button to show the number entered into the textbox multiplied up to 3 times. [code]
View 1 RepliesDisplaying SQL Results With An Condition DGV?
Jan 30, 2010My problem consist in show values into a cell of a DGV control, for example:MySQL Table:
ID - Name - Price - Type
1 Mouse Pad 2.85$ - a
2 Keyboard 10.50$ - a
[code].....
Displaying The Wrong Results?
Dec 12, 2009I'm attempting the following code to calculate how many quarters, dimes, nickels and pennies a user should get as change, and display them in four labels, when buying an item from a machine. The user inserts the amount paid and the cost of the item in two textboxes.My code is as follows:
Code:
Private Sub btnCalc_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalc.Click
[code].....
Formatting SQL Query Results?
Feb 3, 2009If this is in the wrong section, I have a program that queries a database and puts the info in a specific format in a txt file. Now my problem comes w/ how to format the date.
Should I format the date in the SQL query OR is there a way to take the result from the query and format sometime before it is writen to the txt file? I'm not exactly sure how to do either. Would I need a subquery to get the desired date format?
[Code]...
Get Results Of Shell Function?
Jan 27, 2010Is there a way to get the results of the shell function?
for example:
shell("test.bat")
i want to get the results of this shell command and pass it to a richtextbox.
Get Results To Post To One Row In A List Box?
Nov 20, 2009i am trying to get my results to post to one row in a list box for each one but instead it just keep adding up with a million rows and adding each result properly,
Dim A08count As String
Dim A01count As String
Dim totalA08 As Integer
[Code].....
