I have this table in SQL that I'm trying to do some comparison work with Ok, onto the schema. It's like this:
[Code]....
Now, what I want to do is query my database in this manner:Display any records that conflict only Non-priority conflict based on: priority based on the time of day
[Code]....
I can't find the answer to this easy question, because I don't know the terminology I am looking to use. I have 2 tables, one that is a Users Table, and another (UserProfiles) that extends the Users table to include more info, like Age, Sex, Weight, etc.I am using the Entity Framework as my model, and the UserProfiles inherits from the Users table on a 1:1 basis.
All I need to do is the learn the syntax, that allows LINQ to Entities to query only some of the data from UserProfiles. For example, maybe I only need Sex and Weight, but not Age.
[Code]....
I just uploaded all my aspx files including web config file to the server. I received a notice saying the web.config file has been removed from the server due to its conflict with their server. The aspx files are working fine without the web config file. But the email form from my site is not working. I have a few questions regarding this.
1. Is web.config necessary to run aspx pages?
2. What are the possible reason web.config files is conflicting with the server?
3. As mentioned, the email form is not working. I am predicting the reason is it is unable to access the mail setting in web.config file.
I need to write a query to populate a gridview with minimum rates in ascending order for a month from three tables.For example i have three tables A,B,C as follows
TABLE A TABLE B
TABLE C
Id id id
Quote_no Quote_no Quote_ no
Name Rate1 Equip_name
Rate2 E_rate
Date R1_rate
R2_rate
Date
Now if the data is as follows
I need to get the Name from Table A ,minimum Rate1 and Rate2 values for a month in a dropdownlist from date field from Table B and the corresponding minimum rate(E_rate) for Equipment E1 and E2 only from Table C for the month in ascending order group by Name.
TABLE A
id
Quote_no
Name
1
101
XYZ
2
102
ABC
TABLE B
id
Quote_no
Rate1
Rate2
Date
1
101
105
200
12/11/2010
2
102
90
210
15/11/2010
TABLE C
id
Quote_no
Equip_name
E_rate
R1_rate
R2_Rate
Date
1
101
E1
60
0
0
12/11/2010
1
101
R1
0
110
0
12/11/2010
1
101
E2
80
0
0
12/11/2010
2
102
R2
0
0
300
15/11/2010
2
102
E2
100
0
0
15/11/2010
2
102
R1
0
60
0
15/11/2010
2
102
E1
230
0
0
15/11/2010
i want to retrieve latest 10 values from my table,i use sql server 2000.. how can i query my database?
View 4 RepliesI am stuck with an issue. I have around 200 rows in a table with a particular database. I want to copy those values to another table in a different database.
View 3 Repliesquery if @lo=1, i am inserting all of the child records for the corresponding 'InsurID' into 'tbLocal' table. I used to store it individualy if it has two child records by using cursor.But i could not insert the values into tbLocal
table.
[Code]...
I have a table in which there is one column named "Address1"
Now in this column all the data in this displaying as follow:-
sector-2, Guj,676
Sector-4,AHD,8989
Now i want to modify all the data in this column,
if there is any "," comma found in the data,
it should delete that comma from the data?
I have one SP in sql server which takes the data from user and inserts into three tables. My problem is if multiple users call the same SP in same time it throwing error..(I guess one user at a time can access the table and table will be locked, that is why remaning users getting error)how to handle this situation. it is a web application, so at a time so many people can call the same SP.How can many users insert data in the same table in the same time?
View 5 RepliesI created a aesthetic control that creates two lists in seperate div tags organized with a table for each. The control always the user to click on the img tag associated with each item to move it between the two lists. I am doing all the movement between the lists via javascript and want to have a good method for obtaining the values and storing them in two lists upon Postback. I thought of doing something like storing the indexes/classes in hidden values and them reading them to find the items but that seems messy. Also, thought there might be a clever way of traversing the DOM via FindControl() but not sure. Any input would be great.
One other thing is that this is not a composite control. All the tags are being rendered in the RenderContents() method. So I don't know if there is a way to even tack on a runat="server" attribute to an elem like I normally would if I wanted code behind access to an html element.
Here is the HTML that is generated. I don't think there is need to post the server side code since it does nothing more than generate the html at this point.
<div class="DualListPanel" id="test1">
<div key="test1_Unassigned">
<table class="DLPTable">
<tr>
<td>Item 1</td>
<td><img src="..." onclick="Move(this)" /></td>
</tr>
<tr>
<td>Item 2</td>
<td><img src="..." onclick="Move(this)" /></td>
</tr>
</table>
</div>
<div key="test1_Assigned">
<table class="DLPTable">
</table
</div>
</div>
I'm having a gridview in my aspx page with checkbox, User can select one or more than one record(s) at a time and clicks on delete button, Then i'm constructing an object of my DTO and adding all the checked row's Primary Key (DataKeyNames - GUID's in case) to a serializable class and generating an XML and sending it as parameter to the Stored Procedure.
My Doubt is, can i bulk delete all the rows from database table those are present in my XML document??
If it works, I can do bulk update with XML only, i already did bulk insertion by generating an XML..
My Another Question is, Will it affect the performance? Each time when i construct an DTO object and adding it to the Generic List??
WHich one is better, I mean ObjectDataSource or SQLDataSource or my XML method?
My XML will be like this
<root>
<Customer>
<CustomerID>GUID1</CustomerID>
<CustomerID>GUID2</CustomerID>
<CustomerID>GUID3</CustomerID>.....
On our web server we have a search form that fires off multiple searches and combines the results into 1 page. The main search is of the indexing catalog for our web site. We have used this for several years and it works just fine. The company just sponsored a weight loss program and we have discovered that the word "weight" returns an error. The word "weigh" works fine but if we add that "t" on the end it fails. Here is the error:
Incorrect syntax near 'weight'. Expected '!', '(', NOT, ISABOUT, FORMSOF, STRING, PREFIX_STRING. SQLSTATE=42000
This is the query at the time of execution:Select DocTitle,URL from SCOPE() where (CONTAINS(CONTENTS, 'weight') OR CONTAINS(DocTITLE, 'weight')) order by Rank DescDoes anyone have an idea of how to get past this problem? I'm guessing that "weight" is probably a key word or something similar.
I have an Ajax auto complete textbox in my .NET 4.0 asp.net page via a web service, but the browser auto complete dropdownlist feature shows up on top of my .net auto complete dropdownlist.
Is there a way to make sure the browsers auto complete feature does not popup on this textbox? Almost like an override to make sure the browser ?
In my web application I am using NHibernate.dll. This has a dependency on folowing assembly.
'Antlr3.Runtime, Version=3.1.0.39271,
Culture=neutral,
PublicKeyToken=3a9cab8f8d22bfb7'
Now in the same project for another requirement I have to introduce Antlr3.StringTemplate.dll. Which has a dependency on another version of the above assembly.
If I use the version of Antlr3.Runtime.dll which satisfies NHibernate , Antlr3.StringTemplate starts complaining and vice-versa.
I would like to store some business flags (like: isFavorite, isOnLive etc.) per an html table row that won't be visible to user.
In practice, I have a simple ADO.Net DataTable on my code-behind which is used as a data-source for a asp.Net GridView control.
This table contains some business flags on its 0th, 1st, 2nd columns.
I need to store those columns on the rendered HTML of the grid-view -so that I can reach them via JavaScript- but I do not want them to be visible.
I am fairly new to ASP.Net and web programming in general and I am having issues trying to add values from a dropdown list in my gridview to another table.
Here is my scenario. I have 2 tables in my SQL Express DB. When editing the values of table2 in a gridview, I would like to show some data from table1 in a dropdown so users can select a value from table 1 and enter that value in table 2.
I have the Gridview setup to show table2 data.
I created a field template and inserted my dropdown list and linked it to my table1 data source.
When I run my web form, I can click to edit one of the fields in the gridview, and my dropdown list correctly displays the data from table 1, but when I try to update the table2 with the dropdown value, it doesn't correctly update. The row in table2 never updates.
posting the dropdown value from table 1 into the appropriate field in table2..
Again, I am new to this and have been following the tutorials etc on this site, but can't find one pertaining to this topic.
One of the libraries I am including in my project makes use of System.Web.Extensions 3.5.0.0, which conflicts with my Framework 2.0 application, which uses (C:Program FilesMicrosoft ASP.NETASP.NET 2.0 AJAX Extensionsv1.0.61025System.Web.Extensions.dll). I can think of 3 possible solutions:
Ignore the warning and don't change anything. I am not sure what the application does to handle this.
Add an assembly binding element to my web.config (see below) Configure the application explicitly to use different assemblies (I think this is possible, but don't know how to do it).
However, I am unsure of the implications of each of these decisions. The application seems to work perfectly fine even when I ignore the warnings (solution 1), but ignoring warnings that I don't fully understand bugs me...as does having warnings like this show up at all.
[URL]
I downloaded MVC2 Futures and referenced it to my current MVC2 Project. However, if I want to call an HtmlHelper from MVC2 Futures I need to <%@ Import Namespace="Microsoft.Web.Mvc" %>
So I decided to add it on my Web.Config:
[code]....
but, this caused me errors. Could this assemblies co-exist? If yes, How?
I'm working on an asp.net app and I have some controls that are created dynamically on the OnInit event. One of that controls is an asp button that has been working fine until now. When I add a ScriptManager to my page, that same button is unable to postback. It's only working if a take the ScriptManager out. Has anything like this ever appened to somebody else? Am I invalidating the page somehow? Edit: This is my script manager tag:
<asp:ScriptManager ID="ScriptManager1" runat="server"
EnablePageMethods="true" EnableScriptGlobalization="true"
EnableScriptLocalization="true">
</asp:ScriptManager>
//My Dynamic Button:
Button button1 = new Button
{
ID = "button1",
Text = "Ok"
};
button1.Click += new EventHandler(Button1_Click);
i'v an enquiry form, user is operator as Role users fill enquiry form (enquiry.aspx) and view enquiry list done by thmselvs in viewEnquiry.aspx page in GridView im testing using different users accssing this application same time The Problem:
user1 has done 10 enquiries, and in viewEnquiry.aspx able to see is 8 enquiries the 2 remaining enquiries is reflecting in user2's profile or (in viewEnquiry.aspx page as logged in user2) what i'v done: i'v used "public static string UserName;" in Global class file clGlobal.cs in App_Code when user done login successful i stored UserName = dr.GetValue(2).toString(); and clGlobal.UserName = "" on Logout and on master page Load of User im checking (if clGlobal.UserName == "") then redirct to Login.aspx
i am using this query but it is giving syntax error,
insert
into Logistics.DisInventory
values
select *
from Logistics_v1.DisInventory)
I need to pass a table type parameter to a user-defined table valued function in SQL Server 2005.How would I do this?
My function name is udf_t_GetSales ( @financialYearMonthsData as table)
The table @financialYearMonthsData has 3 columns ( MonthId int, DisplayText nvarchar(500), CalendarYear int)
my main intention is that, the exsisting table of sql server database(.dbo) with 1000's of records, that should be import to a new access database table(.mdb).for example if we want to had a new table in db2, of exsisting table in db1 with some conditions by using "select * into New_Tabel from (select * from Exsisting_Table where <Condition>) as objectName". Here the new table is created and records inserted in one execution in db2. The same work should be done for access(sqlserver db --> Access db).Here the new access database table with given name (as string_sysdate) must be created dynamically by clicking a button (multiples time creating new table).Is there any query or c# code for sql server database to access database.
View 2 RepliesI have the following code for the SelectedIndexChanged event of a drop down list. This works fine as it is but this entity has a relationship to another entity (Genre). if i change the select statement to { m, m.Genre.MovieGenre }).ToList(); it doesnt work as contains anonomyous types.
[code].....
I have an SQL database which I wish to query, I have the queries set out and working using the SQLDataSource Control.Is there any way of using web methods to query an SQL Database.I realize this may not be ideal when the SQLDataSource control offers such functionality but it is for a piece of college work and I am not entirely sure which way they want it to work, as all it says is to "Implement a client application and a set of web services".
So is it possibile to use a WebMethod to perform SQL based queries or queries which are not SQL based and if so how do you go about creating them?