I have a stored procedure which returns me maximum value of a column in the database table i.e. it returns me a single int value.
What syntax of linq to sql can be used in service.svc.cs so that I can use this value in xaml.cs?
When you create a Silverlight enabled WCF service, the following line is placed in the source file -
[AspNetCompatibilityRequirements(RequirementsMode =
AspNetCompatibilityRequirementsMode.Allowed)]
What does it do?
I am very new to silverlight application. I have to create silverlight based website . Each page contains each silverlight application. Let me know how to do that. How to integrate on single webpage.
View 2 RepliesI am reading an integer named "CostIndex" from a database table.I need to cast it to an integer and then pad the result withleading zeroes.So if CostIndex is only one digit then I need to pad it with 3 leading
blanks: 0007I know how to find the length, using LEN,but I don't know what to do beyond that? select CAST(CostIndex AS VARCHAR(4)) from TableRoot
I have a gridview and having trouble with display when the webpage is saved as pdf. I can see just the first page of gridview. If I dont do pagination and save the file, the gridview just breaks up and half is displayed on firstpage and half on next page. is there a way that if the gidview cannot fit on one page, I can break it and display rest of it on nextpage?
View 5 RepliesI am having dataset and I want to validate particular column for Integer(Numeric) value.
e.g.
ErrorRows = dt.Select("LEN(Year) <> 4 ")
Above I have to validate Year column for Numeric value otherwise it should give me erroneous records which have data other than numeric.
So far, I've seen (and I'm using the following) scripts to show/hide a div or other controls depending on another control in ASP.NET
$('[id$=myRadio_0]').click(function() { $('[id$=myDiv]').show(); });
$('[id$=myRadio_1]').click(function() { $('[id$=myDiv]').hide(); });
and of course, my div in html like
<div id="myDiv" runat="server" visible="false">
and that works fine when the user selects either option of the radiobuttonlist. However, when I assign that radiobuttonlist a value of 1 or yes on my Page_Load on code behind, that isn't (and probably can't be) caught by jQuery, and my div remains invisible even though the control has a value of Yes/1. So, do I need to set the visibility of that div from code behind, or is there a way in jQuery to force a scan of these dependencies after i've set the values for the main controls in code behind?
is there a way using Spring.net to run a select query and have it return a single value. If there is a way, how do I go about doing it?
View 2 RepliesI have a stringvariabel in a form I shall insert in a SQL database in a integer field. I try to convert it in the parameterlist:
myComm.Parameters.Add("@UtstyrID",
SqlDbType.Int).Value =
Convert.ToInt32(e.Record["UtstyrID)"]);
but it only store the value 0 and not the value of the e.Record["UtstyrID)"])
There is one table which primary key is ID and its data type is Integer with auto increment. Gradually the value has increased and I want to change it to hold large amount of value.
So, Which in data type I have to change from Integer without effecting the previous values?
I have a statement like this;
insert destinationtable(col1,col2,col3)
select col,col2,col3
from sourcetable t1
where not exists(select * from destinationtable t2 where t1.col1 = t2.col1)
I would like to insert into destinationtable which is MS SQL and the sourcetable is Oracle. Is there a way to do this?
if we are trying to add the several columns in select statement and only one condition in group by.
how can we do that ?
Example:
[code].....
I have three ListBoxes each representing a single field database table. They are presented side by side on the ASP.NET page. Is there any way to group them so that only a single item from any of the boxes can be selected at a time?edit - ie, if item 3 in box 1 is selected, selecting any item in box 2 must unselect it
View 1 RepliesTechies@StackOverFlow,i am researching on a logic, by which i can select a text in a single right mouse click. What I want to say is that , I want to implement, the double click text selection, but in a other way that is in single click and right click.
For example if you double click on the text displaying anywhere on this web, the text will get selected. Similar thing i want to implement. I prefer Javascript as i am implementing it on web.
I am using MS SQL Server 2005 & here is my problem: I need to assign values to the multiple variables in a single select. But each value is depend on the certain value of the other column of the table.
declare @i1 Int, @i2 Int, @i3 Int;
select
case Table.column1
when 'red' then @i1 = Table.column2
when 'green' then @i2 = Table.column2
when 'blue' then @i3 = Table.column2
end
from
dbo.Table
how to achieve this in a single select?
Anyone came across a date & time control? I'm looking for one that allows user to select a date (dd/MM/yyyy) and time (hh:mm) into a single textbox.
View 1 RepliesI want to create a Rich Internet Application in Silverlight. One of the requirements is that the back-end of the application should work with different database providers (SQLServer, PostgreSQL, Oracle). I'm planning to use Entity Data Model to represent database objects and Domain Services to expose these objects to the client.The problem is that I don't have a clue if the same data model can be used with different database providers and how sophisticated that would be to change the provider without recreating all the model.I want the application to be reusable on different environments, so that i can import the same database schema to any existing database, change the provider in the ASP.NET web application and that's it.Is it doable? Or maybe there are other ways to achieve similar functionality?
View 1 RepliesI have a dropdownlist with multi-select which I am using to filter a gridview. My problem is it only uses the first selected item for filter.
If I select one works fine, if I select 2 items the grid is filtered by the first item selected.
[Code]....
I need to run a select statement on log in event and store the value of the select statement (returning one item) in a session variable.Do I have to u sqldatasource for this.. or is there someway I can run a single select statement and store the resulting value in a variable?
View 7 RepliesI tried nested ListViews but can get the display wanted.In my database I have a Category Table and a Product table.They share the CG_ID value.I want to make a stored procedure that will use two select statements to produce a single table.that can be used as a ListView DataSource.
[code]...
i have problem while connecting to my MSAccess Database in App_Data Folder in Ajax enabled website.
How to bind Gridview with MsAcess Databse in Ajax enabled website?
I'm using vwd 2008 express
I need to display a single field from an sqlserver table, do I need to use sqlDataSource ect. or is there a simpler way (like msaccess's LookUp) for single values.
When can I use Stored Procedure? Is this useful for looping into multiple SELECT statements to return single value? How? Can anyone post some sample codes? I have text query and notice that my web application is slow and want to find ways to speed it up. Is there any possible ways aside from Stored Procedures?
View 4 RepliesI'm creating some url rewriting for asp.net. Now I am tobbing if I should include the id in url or just the title. Do you guys know if it's a significant performance hit to lookup an item by title instead of id?
View 4 RepliesI have a table and i want to use this table in asp.net page
how i will call the stored procedure on the basis
of Stored procedure's Action .
CREATE TABLE Std_Enquiry(
StdID int IDENTITY(1,1) PRIMARY KEY CLUSTERED ,
FirstName varchar(50) ,
LastName varchar(50) ,
[Code].....