I have come across a Web UI form editor in Visual Studio 2005+ which helps in creating the aspx forms. Similarly is there any creator for web forms for JSP?
How can i implement Excel COMBIN function in SQL 2005, either in a store procedure or in a function. About COMBIN function in Excel follow this Link.
Thanks.
Sorry if this has been asked.
Just like I can select in C# project that I want it to build for .NET 2.0 runtime, is it possible for native c++ project to be built against older CRT, let's say one from visual studio 2005?
I would like this because I have external SDK that was build with VS2005, but I'd like to use newer IDE.
I want to add an email notification to an SSIS 2005 package event handler. I've added a Send Mail task to the event handler. I'd like to customize the email body to include things like the error description. I've tried including @[System::ErrorDescription] in the MessageSource field, but the mail message doesn't include the value of ErrorDescription only the name of the variable.
We have a big portal that needs user registration to allow them use its services. It's already done in .NET and SOL Server 2005. we are in the phase now of discovering all the problems of the current registration system to build a new robust flexible one that can be extended easily and can be more usable for all services.
Could any help me find best practices and design patterns to help me rebuild this using good architectural practices?
I have a varchar column that has generally has a decimal value, but some times there is some garbage text characters in that field.
Is it possible to filter in the WHERE clause for rows that sucessfully convert to a decimal value?
I am using sql-server 2005
I m working on Microsoft Visual Stdio 2005. I am working on ASP.NET. I added project to VSS. I found this project correctly, but other user can't access this. show this error message. and this web project cannot working in vss
I'm opening a 2005 SSIS pakage and also an old C# project..both are in this solution here. I'm missing namespaces and I can't find the assemblies to add back to my references folder for my C# Project
Microsoft.SqlServer.Dts.Pipeline
for example is not one I find in the list of references in the .NET references tab. So how the hell do I get these SQL Server assemblies? Do I have to install the SQL Server 2008 sdk?
Lost.
Hi all.
i m working sql server 2005.
My query is:
SELECT (
SELECT COUNT(1) FROM Seanslar WHERE MONTH(tarihi) = 4
GROUP BY refKlinik_id
ORDER BY refKlinik_id) as dorduncuay
And the error:
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.
How can i use order by in a sub query?
In SSMS 2008, when I expand the tables folder, all i see is the "System Tables" folder.
In SSMS 2005, when I connect to the exact same database with same account, I expand the tables folder and see all my tables. Has something changed with which tables are displayed by default? Does it only show tables in the default schema by default?
When I attempt to make a connection from my console app to my sqlExpress. I get the following error:
The user is not associated with a trusted SQL Server connection.
I have:
Switched users
Switched passwords
Switched Servers
Switched Databases
I always get the same error. I am using VS 2010 and Sql Server 2005
Here is my current connection string
SqlDatabase sqlDatabase = new SqlDatabase(@"Server=localmachineName\SQLEXPRESS;database=database1;user id=username password=mypassword;");
"Only one instance of a Script Manager can be added to the page. " Such Error occurs when I use Script Manager in my vb.net 2005 application. What should I Do?
We are in the process of moving databases from older 32 bit hardware running sql 2005 to newer hardware with sql 2008 64 bit. My question is if the database is automatically converted to 64bit after it is reattached on the new server or if it is running in 32bit mode on a 64bit instance. Is there a way to tell?
Hi Experts,
I am using asp.net and C#.
I have deployed my application on the server and now I come to know that my server don't have a ip address, is their any way I could send sms without smtp details.
I can use bot asp.net3.5 with C# or SQL Server 2005 to send mail.
Thanks in advance
I am aware of:
SELECT @@ERROR
but it will give me only an ERROR CODE (a number) and I need a full text message like:
Cannot insert duplicate key row in object 'dbo.TABLE_NAME' with unique index 'IX_ID_unique'.
The statement has been terminated.
How can I do that in MS Sql Server 2005 ?
Given the recent release of VS 2010 I was shocked to see the pricing structure for the different versions of the product. I was lucky enough to receive free versions of VS 2005 and 2008 from attending various MS events. For the hacking I do at home I'm not sure I'm going to spend the money to purchase the IDE and wanted to see what others were using.
Like
SharpDevelop
MonoDevelop
Expess Editions
Hi All,
I made a small Form Designer and I want to add the "SnapLines" feature like
Visual studio 2005+ Windows Forms Designer
I look for any sample or algorithm
Any Help !!
Thanks in advance
I have following data and using SQL Server 2005
UserID UserName LogTime LogDate
1 S 9:00 21/5/2010
1 S 10:00 21/5/2010
1 S 11:00 21/5/2010
1 S 12:00 21/5/2010
1 S 14:00 21/5/2010
1 S 17:00 21/5/2010
Need Output as:-
1 S 9:00 10:00 21/5/2010
1 S 11:00 12:00 21/5/2010
1 S 14:00 17:: 21/5/2010
I had used ROW_NUMBER function in query but its showing error
When setting up a new ASP.NET MVC Web Application, the default connection string inside Web.Config is something like this:
connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
I'm just wanting to play around with logging in and registering, etc but when I run the app it obviously can't find a SQL database. What database with what tables do I need to setup to do this?
I have SQL Server 2005 Standard installed on my system, is that enough?
Thanks.
I am using Visual Studio 2005 with Team Foundation Server.
When I right click a file under the source control and choose "compare" VS appears to freeze until I hit escape. My guess is that the window that is supposed to be popping up is somewhere I can't get to. I tried minimizing all the windows that I can and it is nowhere to be found.
I used ChapterTool from Apple, but it's broken and discontinued since 2005..
Is there any other similar command line tool, or library (I'm writing in ruby..) ?
I really want to learn how to program. A friend suggested I buy vs 2005 or a newer version if I'm serious about it. Is there a cheaper route? I would like to start with c#.
Hi,
I have created a Report using Crystal Report(Visual Studio 2005 and .NET Framework 2.0). In the Report Header section I have added a TextBox control to display header for the report. But when I execute the application the Text in the Report Header section is not displayed.
What should I do to view the text entered in the report header section?
Thanks in advance!