I have two tables --- Table1 has an identity column ID and a team name column and Table2 has columns where one column is one team's ID# and another column with the second teams ID# and other columns with scores for each team for that week.want to do a query to show that week's result but instead of the ID#, show the teams' names.
View 4 Replies
I have projects table which have project starting date and end date in datetime() format.every project have some report day which is friday and saturday(which is fixed),the problem is i want to show which project is falling in this week's reports, i think i have to compare project starting date and ending date with this week dates...so i have create function in sql to get week date... but i don't know how can i show...i am totally confused
View 3 RepliesI have a page url say [URL]. So in that page I have links like "About us" "Contact us" etc. So when it comes to development, I have folders called "ContactUS" "AboutUS" and in them I have pages called "ContactUs.aspx" and "AboutUs.aspx". So by default, when you click on the "About us" link from the website, you would be directed to a url, [URL] But in my case, for any web pages, I dont want to show the last part of the page name. So the url should look like [URL] So how do I do this?
View 2 Repliesi'm trying to read a sql file like the following and bind it to a listbox and display the names of the stored procedures the procedures that should be binded onto a listbox in this example are...
prc_site_map_sectionsprc_site_selector_site_listing
[Code]....
my sp return resultset with different column names based on different parameters passed to sp and now i want to show that data in asp.net(c#) gridview so how can i achieve this
View 1 RepliesIīve got a chart control (column type) and must show many elements at y axis, but when system generates the chart draw, itīs shows only odd elements: For example: My chart must show a colunm containing systems (x) and error incidences (y):
1. SIEMP
2. SISOUT
3. SIGTI
4. SISFIN
5. SISPL
6. SISTER
But itīs only shows:
1. SIEMP
2.
3. SIGTI
4.
5. SISPL
6.
I must set a parameter that forces "all" series to be showed.
function log(message) {
$("<div/>").text(message).prependTo("#log");
$("#log").attr("scrollTop", 0);
$("#city").autocomplete({
source: function (request, response) {
But my auto complete doesn't show up the result? am i doing anything wrong
I have data list in mypage  and i have table in my DB that have 30 row with data
I want my datalist just show 10 row of my Table in 5 column i set Repeat column=5 for my datalist but i don't know how i can set that show just 10 row of my table from my data base
i dont need other row i just want show 10 row that i define in my procedure ...
i have a requirement in which the user can search for other user he enters three char of the name clicks on the search button and a new window is opened and he can see all the search results in a gridview he can select one of them and this closes the new window and the details are populated on the previous page.
View 6 RepliesI have one asp.net dropdownlist which consist A,B values. If user Select A in dropdownlist i need to bind this query to Gridview. Select FirstSelection from Tablname else Select SecondSelection from Tablename. How to do so..?
View 7 RepliesI have a textbox1 and button1 and panel1 (which is used as a popup control)
i want if textbox1.text="show" then modalpopup control whose id is panel1 will be visible on buttonclick event other wise .... modal popup control panel1 will not be shown ...
how to do this ? using vb.net ?
I have a view.On which i have two partial viewMy m ain is like this ->.(Note i am using
Ajax.BeginForm here.)
[Code]....
butmy issue is this that i have a button in SearchRequestCriteria partial view on which a function from my controller is called.And the result is bind into the SearchRequestResults partial view.but from when i am using Ajax,BeginForm is does not bind the result to thisSearchRequestResults Partial view.I have debug the program & found that the result is came into the SearchRequestModel & but it does shows in the
SearchRequestResults partial view.i want the result in this by using Ajax.
I have a listview. Inside the EditItemTemplate of this listiview I want to show a Checkboxlist that has 5 checkboxes; S, M, L, XL, XXL. The values (checked / unchecked) of these checkboxes are dependent on a linq query. The linq query just retrieves the values from columns in a table. The columns are S, M, L, XL, XXL (same name as checkboxes for convenience) and all have datatypes bit. What I want now is to be able to databind this query result to this CheckBox list.
View 4 RepliesI have a database that has names and months of birth. I would like to have a Choose Month: with a drop down menu to select the month of your choice, then have the results show in a gridview at the bottom of the page. I thought this would be fairly simple but my grid doesn't show anything.
<%@ Page language="C#" masterpagefile="MainContent.master" title="HomeSign OutVehicle CalendarProj" %>
<asp:Content id="Content1" runat="server" contentplaceholderid="Content">
<div id="Rightside">
<form><asp:Label runat="server" Text="Choose Month:" id="Label1"></asp:Label> <asp:DropDownList runat="server" id="Month">
<asp:listitem>Choose Month</asp:listitem>
<asp:listitem>January</asp:listitem>
<asp:listitem>February</asp:listitem>
<asp:listitem>March</asp:listitem>
<asp:listitem>April</asp:listitem>
<asp:listitem>May</asp:listitem>
<asp:listitem>June</asp:listitem>
<asp:listitem>July</asp:listitem>
<asp:listitem>August</asp:listitem>
<asp:listitem>September</asp:listitem>
<asp:listitem>October</asp:listitem>
<asp:listitem>November</asp:listitem>
<asp:listitem>December</asp:listitem>
</asp:DropDownList><br /><hr />
<asp:GridView runat="server" id="GridView1" AutoGenerateColumns="False" DataSourceID="AccessDataSource1">
<Columns>
<asp:boundfield DataField="FullName" HeaderText="FullName" SortExpression="FullName">
</asp:boundfield>
<asp:boundfield DataField="Month" HeaderText="Month" SortExpression="Month">
</asp:boundfield>
</Columns>
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="browser.mdb" SelectCommand="SELECT [FullName], [Month] FROM [EmployeeDates] WHERE ([Month] = ?)">
<SelectParameters>
<asp:controlparameter ControlID="Month" Name="Month" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
</form>
</div>
</asp:Content>
Im struggling to find week start and week end date based on week number of the year. I have written this following sql to calculate that but it fails when year is 2012... The logic should count week number starting from first monday of the year. But it gives me wrong start date and end date when year is 2012, 2018....
[Code]....
I am stored date in "smalldatetime" datatype as in databse.How can i particular textbox entered date(dd-mm-yyyy) used to fetch the row information from databse and shown in a gridview.
View 1 Repliesheavy operation which takes long time to be completed in my asp.net application. I don't want to run the entire operation in one request which may result in a TimeOut error. Instead I want to invoke the operation in a separate thread and poll for the result every x seconds. How can I do this?If the operation gets completed I need to register a script in the ajax postback to hide the loading panel and show the content. However I'm not able to register new scripts and invoke it during ajax postbacks.
View 2 Repliesmy query is like this " select product_id, product_price, purchase_amout from purcases"
and on my formview i tried to add a "total purchase"
i tried using <asp:Label ID="total_purchase" runat="server" Text='<%# string.format(cint(eval("product_price")*eval("purchase_amout")),"{ Rp 0:###,###,###,###,###}")%>'>
the total amount show the correct calculation result, but the string format dont work.... so it display 20000 instead of Rp 20,000
btw. "Rp" is the currency symbol in my country... i dont use {0:c} coz the server user US currency
I have an update command with variables, is there a way to see the query after the variables are set?To see the full query as it sends to the DB. (i know in Java hibernate you could add some log file)
View 2 RepliesI have this ListView that has a Drop Down List.Everything works fine (I think/hope) except that the drop down list are not showing its result correctly.This is the code.
Front-End
[Code]....
The code behind consist of the page_load and the ItemDataBound
[Code]....
I'm having a problem with my Linq to XML query. I'm getting the result data I want, but it's nested so deep that there must be a better way.Here is my XML:
[Code]....
I'm trying to get a list (simple string[]) of all Item IDs where Category Names contains "Other".Here is my Linq:
[Code]....
[Code]....
Here is a snapshot of my result from Visual Studio:The results I want are there ("item100", "item400", "item500"), but buried so deeply in the results var.
How can I get the query to return a simple
string[] = { "item100", "item400", "item500" }
How to show Razor View in J Query Light box give me a full example.
View 10 Replies I have a big query that it execute in 4 minutes. (for example an important trigger)
I want to show situation of query or count of records that is affected in every 10 second in to a web page.
what should I do? (complete explain)
Best way to show the SQL trace of a LINQ query to Entity Framework 3.5? I am using ASP.net and EF 3.5.
Dim dbo As Web.Portal.RBMEntities = New Web.Portal.RBMEntities
Dim Query = From RoleAllocations In dbo.RoleAllocations Where RoleAllocations.user_id = _ID And RoleAllocations.expire_date > Today Select RoleAllocations
Console write the SQL trace?
What is the best way to show a date on the query string for a friendly url. I pull the date from a database in this format sample (15/03/09).
The problem I have is that would be 3 different parameters and I would like it to be one.
