1. 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]...
Server Error in '/staff' Application. Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. Source Error:
[Code]....
Stack Trace:
[Code]....
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
Firstly, here is the software I am using locally (which runs my program perfectly): vista home premium sp2vs2008 sp1sql server 2008 enterprise edition sp1iis 7 The server is using: sql server 2008 enterprise edition rtmiis 5.1 I encountered a problem days ago that I have so far been unable to fix. The project runs an asp.net web app perfectly locally. However when I uploaded the solution and the database to the server, it will not connect to the database.
I get the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. SQLExpress database file auto-creation error: The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:
If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist. If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database.
Sql Server Express must be installed on the machine. The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts. I thought that the problem was the connection string so I changed the connection string locally to connect to the server database, and it works. But whatever I try I cannot get the program to connect to the server database from the server's wwwroot.
I just published my web site, and the problem is, that table can't be found. I'm using SQL Server 2008. I created new user, which is not sa, that I se to work with Sql Server 2008 Express manager. I tried to create sa user ass well on hosting server, but it is not possible, because it's already exists.
I think the problem is, that newuser, can't find dbo. tables, which are created by sa user. If that is problem, how can I solve it? I can't create sa user on hosting machine. Is there maybe some solution in right connectionString?
I'm using this kind of ConnectionString on hosting server:
[Code]....
How do I find my web server name on my pc?
View 2 RepliesCreate a user Define value to find the last column and last row value make a UDF in sql server
Table1
ID Name
Address
1 A
Delhi
2 B
Noida
3 C
GZB
4 D
Bihar
i say this way
Declare @v varchar(50)
Select @v = address
from Table
print @v
then he say me if rotate the colums like this it will never work
Table1
ID Address Name
1 Delhi
A
2 Noida
B
3 GZB
C
4 Bihar
D
then how would you do this then i say that i don't want the job in this company
I have an ASP.NET MVC site that is running into some conditions that it is pegging the processor on the iss boxes it's running on. I don't have access to these servers (it's a farm of about 5 iis6 boxes behind a netscalar). I am doing some logging to a sql database, but the problem is that when the cpu pegs my database starts timing out. The iis servers are hosted in house, but I can't get access to them.
And to make things ever more complicated, I can't reproduce any of these issues in my qa environment (which I don't have access to either). QA is setup to similarly to our prod environment, but it runs on a single box that isn't behind a netscalar.
I have a query that finds the winner of an election:
[Code]....
[Code]....
[Code]....
After this I need to find every occasionID that are not TopVote or not dr[0], i.e. all the losers, to delete them. The only suggestion I can think of is making a parameter of !TopVote (does NOT work). How should I do it instead?:
[Code]....
occasionID is declared earlier, that's not the problem...
I'm trying to define the parameters of my data source using a stored procedure. My Stored Procedure Syntax is perfect and i'm happy with that, i've just got trouble with connecting my parameters to my controls. I have 19 Parameters, of which i've managed to connect 17 to controls within my ASP.Net form (some to text boxes, some to ddls etc...)
However, i'm trying to connect a particular parameter to a control, but when i drop down my list of controls it's not visible? The control is within a hidden panel so i've un-hidden it and it's still not there. I've even commented out the panel and tried that but i can't find this control! I just cant seem to get this control to appear in the list.
Has any one seen anything like this before at all?
I am trying to find a code snippet that reads a sql server db and retrieves an image from a table and converts it into a thumbnail image. I'm looking for VB.Net code that does this and I can't find anything.
View 23 Repliesi have developped an application localy that can browse excel files, pictures etc... and display them, the thing is, that on my PC when a user upload a picture it will be saved under local disk C: and to browse it i will access C:idpicture and display it, that easly. the problem is when i deployed the application on iis 7.5 it's not working anymore giving me an error saying that the path is wrong or the name of the file is changed etc...
i have understood that i can't put it on local disk C: because the picture or the excel file must be shared on all the PC's, so i have created a map network drive (PUBLIC X:) which is availble on all PC's, that way i will browse in X:idpicture but that is not working aswell.
my question is: what is the proper path to use to access file on the server (PUBLIC X: or C:) using IIS?
Table1
Col1(varchar)
japan
taiwan
china
malaysia
singapore
japan
china
How to find the row index of "china" occuring first in the column. I need to get 3 as result for the query ?
I have a one sql table, it contain 5 column id, ipaddress, status, datetime, value. I need to find distinct rows as per ipaddress column basic..
View 7 Repliesi am facing a problem like this. i have a insert dynamic Column through procedure .
Now i want To retrive
[Code]....
This error is showed when I upload the web page,thisThe control 'ctl00_Contenido1_Nametxt' type 'TextBox' must be placed into a label of the form with runat=server.]This is the code that I'm using...
<%@ Page Language="VB" MasterPagefile="~/IMAMaster.master" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@ Register Assembly="System.Web.DynamicData, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
Namespace="System.Web.DynamicData" TagPrefix="cc2" %>
[code]...
I just went to the Get Started page and downloaded the package, I was following the exercises untill i got to one where I have to open SQLServer, which i donīt have installed, in the example the SQL management Studio is inside the Microsoft SQL Server 2008 R2 folder, but I donīt have it in this folder i try to download it again but the Dowload Manager says there are no files to download.
View 9 RepliesI want to find all data before current week. Is any query have this function?
View 10 RepliesSo I developed a web application in ASP.NET and SQL Server 2008. Part of the SQL code I implemented as a .NET assembly (instead of t-sql) because it is performing intense calculations that are better written in C#.
Now I am ready to deploy my application, but I am stuck looking for a hosting company that allows this. Scratch out Discount ASP (see this forum post). I tried emailing other hosting companies and I either get no reply or they say they will not support it.
Any recommendations? What's the big deal with having CLR enabled in SQL Server?
I try to run each control and then check what html did it render.
But this seems to me as an inaccurate method as whenever we add or remove the properties, or events of the control,the rendered HTML changes. Is there any book/tutorial/article to explain what is the standard HTML rendered by each asp.net control.
find the names of tables refered in a perticular stored procedure
View 10 RepliesI have come accross a scott's blog today;
http://weblogs.asp.net/scottgu/archive/2010/06/30/new-embedded-database-support-with-asp-net.aspx
what is exactly Sql server compact edition? it says that I do not need a sql server to store my databases if I use that in my bin folder? so I can use my mdf databases in app_data folder. is that true?
how to find and replace substring in select query
DATA RELEASE FORM $LSB$DRF$RSB$
Say on website1 there is a link to website2(asp.net)ites are unlrelated to each other, different servers and different domains.Website1 may even be php.The link on website1 is <a href='http://www.website2.com/default.aspx' >LINK to website2</a>Question: Can I in codebehind in website2/default.aspx read were the link came from, thats is determine it came from www.website1.com, when default.aspx was selected into browser?
View 2 Repliesi have a server button control i use from
'<%= MyControl.ClientID %> to access client id in java script
but ,if my id is a string variable in javascript how to access to thid control client id
i use from
var strClientID =
"<%= %>" + ServerID +
"<%.ClientID %>";
Or
var strClientID =
"<%= " + ServerID +
".ClientID %>";
not work properly
In my application when I click on one of my button in the page it is giving error like this..
Could not find a part of the path 'V:UserEnterTrailorVideosluck.swf'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:
System.IO.DirectoryNotFoundException:
Could not find a part of the path 'V:UserEnterTrailorVideosluck.swf'.
There is No folder ("EnterTrailorVideos") in my project. But it is showing like this .
This the code:
string path = Page.MapPath("../../User/VideoOut/"+sFile);
FileUplvideo.PostedFile.SaveAs(path);
Session["oldfile"] = path;