I 'm gonna query database for photo records. each record include "photo path" where imagesURL stored in string format
I Choses my favorite Juqery plugin to show images. Plugin needs some lines of code like below.
How could I generate these lines
[Code]....
I have used the script as follows to display simple alert and confirmation. On confirmation if the result is true i have to execute button click code that was written but i am unable to do thatÂ
<script type="text/javascript">
$(document).ready(function () {
$("#btn").click(function () {
var inputs = document.getElementsByTagName("input");
[Code].....
How do i generate another computed column that will contail the result of GrandTotal/Total,
where GrandTotal is another value comes from computed column and the Total would be the sum of the Total within SchedularID.
And thats what i have done so far: [Code]....
I 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" }
I need to create a slide Gallery on multiple rows (two) with jquery.There is already made some plugin, or can give me an example to be able to realize?
View 1 RepliesAfter insert a grid or any other tool into an aspx page it generates enough code for that tool(for ex.): <dx:ASPxGridView ID=ASPxGridView1 runat="server"></dx:ASPxGridView>...
But,after adding any property to this control (like Show group Panel) it generates more than 3000 lines of code in aspx page () and after adding any other tool the code is increasing in a enormous way...
How can I reduce the code, maybe there is a property(settings) in DevExpress option...
I am trying to display this query result in an aspx page.
It is very slow in loading. Here is the query. The inner query inside the outer quesry is the problem.(Please see the underlined part in the query) - (If I remove that part it is very fast.)
select
top 500
--This column is the issue
,Governing_Class=( case when exists (select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.appid and tqc.class_code not in('8742' ,'8810','7380')
order by tqcm.premium_amt desc
)
then ( select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.
appid
order by tqcm.premium_amt desc
)
......... From tables
i have tow query in one stored procedure
first query and the second one every of them return only value
i want to copy the result of tow values in a new row in new table
as i want to check on this tow values in ado.net
i want to get only this tow values as a row not first and secon query
only a row has result of first and second query results
[Code]....
I would like to loop through my result set and generate a menu structure like this:
page
page
subpage
subpage
page
page
[code]....
Not sure if this is the right forumn for this kind of question.Basically I have just started with MVC and also have done simple programming and have not used Interfaces earlier.I encountered this 3 line code used in my company application and was wondering if someone can explain me this. Thanks.
[code]...
For a reporting stored procedure that returns multiple result sets that don't map to
any database tables, I'm able to use SqlConnection(), fill a DataSet, and name the
different tables uniquely (as opposed to the default Table, Table1, Table2).
However, I want to make the returned DataTables to be strongly typed.
There's plenty of articles out there about strongly typed DataSets, etc.,
[Code]....
I've been moving lines around and going over and over this bit of code for ages and I can't work out what's wrong with it...
In the header text I need to get an output of two lines. The top one in Spanish an the lower one in english. Is there a way to break a line?
[Code]....
My datasource returns up to 3 different values for each item: a contact name, a company name, and an email address
The problem is, this ends up returning the same company names multiple times in the returned list of suggestions
Is there a way to weed these duplicate items out using JQuery or is there another method I should use?
Here is my implementation
[Code]....
Any quick way to get a count on all the lines in a project?
That way you can use the info to try and convey the complexity of a project to a Customer.
Visual Studio 2010
I use the follwoing code to get a value from the SQL query. But now i would like to use some sql function like Sum() count() ... and i would like to get the result of that.
vb Code:
Dim constg As New SqlConnection
constg.ConnectionString = "Data Source=m......."
constg.Open()
Dim payrollquery As String '= ("SELECT * FROM xxxxx.nnnnn WHERE ID IN(" & ID & " ) AND sent = 'U' ")
Dim cmd3 As New SqlCommand(sqlstr, constg)
Dim reader As SqlDataReader = cmd3.ExecuteReader
I want to store the following code into the database:
[Code]....
and then get it back in the dataset and display on a page.
As of now I have successfully stored the questions with varchar(MAX) datatype but when I try to get it in the dataset i get the following error:
Failed To Enable Constraints. One Or More Rows Contain Values Violating Non-null, Unique, Or Foreign-key Constraints.
I am doing this in a ASP.NET web application.
EDIT:
Here is the Table definition of the table I am inserting the data into
The query I am using to insert the data into the table:
[Code]....
And finally the code by which I am extracting the data from the dataset
[Code]....
I have an annoying problem with Visual Studio 2008.
When I run the "format code" command ("control+k, control+d") -- it will insert a carriage return. How do I get it to stop doing this?
For example:
<label for="shipCompanyName">Company Name:</label>
undesirably becomes
<label for="shipCompanyName">
Company Name:<label />
i need to make 2 funtions on an ASP.NET c# page working with an SQL server (using Visual Web Developer 2010 Express) the 1st one is a simple serach and i've done the 2nd thing is an update , the sp is like:(it works in SQL)
UPDATE [lens] SET [qty] = @b+@c WHERE [id] = @a
@a is the id which user input in the textbox1
@b is an number user input in the textbox2
now @c should be the result of an query "select [qty] from [lens] where [id] = @a"
so ,the new value of [qty] will be the "old valus"+"valus in textbox2"
I'm trying to use SemWeb library to make my SPARQL queries on an remote SPARQL endpoint.
this is what i'm using fort testing, since this is an example that came with Semweb
SparqlHttpSource source = new SparqlHttpSource("my_endpoint");
source.RunSparqlQuery("SELECT * WHERE {?entity dcterms:title 'someentity' }", new SparqlXmlQuerySink(Console.Out));
Now, what happens is that my query isn't returning xml, but javascript, how do i know that?
using this simpler example:
SparqlHttpSource source = new SparqlHttpSource("my_endpoint");
source.RunSparqlQuery("SELECT * WHERE {?entity dcterms:title 'someentity' }", Console.Out);
So my question is, how do i tell semweb to get my results in xml format?
I have convert code from C# to vb.net, I have done some type tweaks, but the code still does not work. I need code in vb.net.I have created a test project here: http://www.screencast.com/t/M2Y2MzVkZDIFile : 20MB (GeoIP data files is the reason for the size)Please run the project and run the test pages. Could you help me fix the code and please make NOTES ON YOUR CHANGES.I need the final result in vb.netThe code uses maxmind.com free GeoIP database to get country and city etc from an IPAddress.
View 3 RepliesI want to export the sql query result to excel workbook. Diffrent query results in diffrent work sheets but in a same excel sheet.
View 3 RepliesWhat would it be the simplest way to merge a result like this from a sql query to be displayed in an asp.net gridview?
NULL Tarde Fer W. Lunes
Mañana NULL Fer W. Lunes
I need the result to look like this
Mañana Tarde Fer W. Lunes
In my asp.net application i wanted to export the SQL query result to Excel and that excel should be avaliable to the user as a download.
View 3 Replies
