I need to find the Sum of the Cost ,I tried doing it , but i am not aware of the syntax.
var pss = new PrintingServiceDataContext();
var strActualvalue = pss.PrintJobs.Where(s => s.OwnerID == txtOwnerID.Text && s.CreatedOn >= firstDay && s.CreatedOn <= today).Select(s => Sum(new {PCost = s.Cost }));
In my asp.net application, I want to show the user that when he is submitting the form how much time does that stored procedure is going to take. Is there any way I can find out from asp.net application? Just like we have estimated query plan with estimated cost in sql server. Can we show it on asp.net webpage?
View 2 RepliesOne of my relatives is going to start a small salon. I would like to develop a small web-site (that is pretty basic: display information, book an appointment, display product/service information, show directions to the salon, etc). I can use a XML file as a basic data storage and am not intended to use any database for this. I can deal with the coding development of the web site, but I have not developed any web-site independently and have no detailed knowledge about how to host the site, etc. factors. I also would like to know that whether it's possible to develope such a web site using ASP.BET (Visual Web Developer) with NO cost?
View 8 RepliesPossible Duplicate:
Performance Cost Of ‘try’
I am being told that adding a try catch block adds major performance cost in the order of 1000 times slower than without, in the example of a for loop of a million. Is this true?
Isn't it best to use try catch block as much as possible?
I have a user defined function GetAddress which takes address id (int) as a parameter and returns a address which may contain some 200 to 300 characters...In the execution plan for that function it is displaying cluster index seek cost as 100%...I have clustered index for address id in the address table..is that costing the resources more...How to decrease the cost of the function or a query...!!
View 1 RepliesApproximate cost of the project Duration of the project ( There are 2 Developers ) Can I charge the client for software license ( like Visual Studio license since I have purchased it by paying a hefty amount)
My profile as a developer is as follows:
I am a C#, .net, ASP.net developer with 3 years experience in enterprise class web and desktop projects. I can work 20 hours a week
The brief requirements of the project are as follows::
I have to develop an Ecommerce website. The website is meant for buyers, sellers, advertisers and bidders ( I would say it is Business to Business and also Business to Customer site ) The HTML's will be given by the client. The website will have all the features of any Ecommerce site like buying products, selling them, searching products, sorting them,etc The website should conform to W3C standards
I am trying to create strogly typed datasets for my project. When I right click on the xsd file that I need to generate a strongly typed dataset for I can't find the 'Advanced' properties as described in the below article (almost half way down)[URL]As I do not see the Advanced properties option I can't find the 'Custom Tool' property/option to set its value to 'MSDatasetGenerator'. Do I have to install some kind of patch on my VS 2005?
View 5 RepliesI want to change the text of the user name text box which is inside a log in view on selected index chaged event of a drop down list.
this is my code:
[Code]....
but both ddl and tb are null
Anyone knows how can I find the controls in code behind?
guess it's straightforward. On page load, i wanna check the group of which a particular belong to. Say, someADNameeckham belongs to Account. In that case, I only wanna get "Account". But I have no idea how to get the group name of a particular user belong to. It's for LAN web portal so I guess security is not a very big concern here.
View 5 RepliesI am working Asp.net(c#)+sql server.I have one id--> textbox and one next--> button,when I am input a id then if id match my datatable then display message match id in ur datatable if not match then next match id display in textbox.
View 4 RepliesI am Working on an asp.net c# application.
I wish to find the url of the application. For example, my application is NRCME I want to return http://localhost:4833/NRCME/ when running locally. From the server I want to return
http://servername/NRCME/
I used to use datasets instead of sqldatareaders and I used to be able to do something like this
If dataset.tables(0).Rows(0)(1).ToString()) = "N" Then
lbl.Text = dataset.tables(0).Rows(0)(2).ToString())
Else
'Do Nothing
End If
This obviously doesn't work with sqldatareaders.I have code to see if the SQLDatareader has any rows but was wondering if there was a way to get the value of each rowI'm guessing this is possible and i've had a look around but can't seem to find anything
Dim conn As SqlConnection = New SqlConnection("server='h'; user id='w'; password='w'; database='w'; pooling='false'")
conn.Open()
Dim query As New SqlCommand("DECLARE @investor varchar(10), @sql varchar(1000) Select @investor = 69836 select @sql = 'SELECT * FROM OPENQUERY(db,''SELECT * FROM table WHERE investor = ''''' + @investor + ''''''')' EXEC(@sql)", conn)
Dim oDR As SqlDataReader = query.ExecuteReader()
If oDR.HasRows or dataset.tables(0).Rows(0)(1).ToString()) = "N" Then
lbl.Text = dataset.tables(0).Rows(0)(2).ToString())
Else
'Do Nothing
End If
That is the code I have at the moment which obviously doesn't work
had table indatalist and I had to find id of tr in table I did my code but error apeared (object refrence...).
<asp:DataList ID="DataList2" runat="server" RepeatColumns="4"
RepeatDirection="Horizontal" onitemdatabound="DataList2_ItemDataBound">
<ItemTemplate>
<table width="90%" border="0" cellspacing="0" cellpadding="2">
<tr id="AllText" runat="server">
[code]...
c#
i have string. string source ="my sweet babe stef" ;
i want cut this string to be 2 word. should be like ="my sweet";
how can i find this two word and cut other?
I am scraping a page from the net and I have the page HTML code in a string, now I want to find the value MIAMI which is in here:
<A HREF="test2.cgi?city=MIAMI">MIAMI</a></td> <td>
Now Miami will be dynamic, so how can I search for like the text between...
<A HREF="test2.cgi?city= and ">
i need to find the remote users ip address using asp.net and also i need clarification whether multiusers have same ip address
View 2 Replies1. How would I be able to find a certain row by a column name and be able to get all its data?2. How to exclude the last row from the Min and Max methods?Actually, my two questions are for one action.
What I need to do in finding a row is to go to the end of the data table and get the row before the end, then get the data for that row, at the same time, I want to exclude the value of the last row from my min and max used methods.
[code]...
How do I find my web server name on my pc?
View 2 RepliesI am a beginner of C# programming. I have read a few books about C#.net. But I cannot find some exercises in the books. Someone told me to build up a blog to practice my coding.
But it is a huge task for a beginner. I just want some tasks to have a step by step learning process.
I need to look for specific types in all assemblies in a web site or windows app, is there an easy way to do this? Like how the controller factory for ASP.NET MVC looks across all assemblies for controllers.
View 3 RepliesI have migrated a database from one server to another and following the migration had an orphaned user (WholeSystem_webuser), which has been fixed using the auto_fix option of sp_change_users_login
•The WholeSystem_webuser account is used by ASP.NET pages to connect to the database and run stored procedures.
•I can log in to Management Studio as WholeSystem_webuser OK and execute the sp's from there
•When I try to run my ASP.NET page it was saying “Can’t find stored procedure [procedure name]”
•If I drop the sp and create it as [dbo].[GetContactsCount] instead of [WholeSystem_ webuser]. [GetContactsCount] it says “The EXECUTE permission was denied on the object 'GetContactsCount', database 'WholeSystem', schema 'dbo'.” (which is what I’d expect as the connection string is using the WholeSystem_webuser account??) –does that show that the web user is logging into the database OK??
•If I try and configure the SqlDataSource in VWD to see what it is looking at though, it won’t let me get beyond the connection string window and says “Default schema could not be retrieved for this connection”
•I tried setting up a new login/user/connection string but still get the
“Default schema could not be retrieved for this connection” error
IN SQL Server:
•Users mapped to the login WholeSystem_webuser - WholeSystem_webuser, default schema dbo
•User WholeSystem_webuser has default schema dbo and db_dataread and db_datawrite permissions
•There is a schema dbo whose owner is dbo, and a schema WholeSystem_webuser whose owner is WholeSystem_webuser
I am new to .NET dev and I cut and paste a lot of code. One strugel i have is when I I use a class name, I need to find out what I need to add in the reference (using clause at the top) and what DLL to use. Is their a easy way to find out what class is on what DLL. My pc is littered with 500 - 600 .NET dll.
View 4 RepliesWe plan to develop a ASP.NET ( VS 2010 ) web site.We need to know if there are any ready made startup ASP.NET web sites so we can get them and adjust / upgrade according to our needs.
View 1 RepliesI have Downloaded the sample from codeplex,where in the ex. says 1.Add the RssDataSource and RssHyperLink to the Toolbox in Visual Studio How do I do it? I dont find the file to add? what file is it?
View 2 RepliesI usually use expressions like this
CommandArgument='<%# Container.DataItemIndex.ToString() %> '
But I could not find Container in the msdn,
