Hi All,
I made a small Form Designer and I want to add the "SnapLines" feature like
Visualstudio 2005+ Windows Forms Designer
I look for any sample or algorithm
Any Help !!
Thanks in advance
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 just installed NetBeans, and want to try it out. Some context tips (popup javadoc stuff) work, but nothing detailed. It says "Javadoc not found...".
However, I use Eclipse (my current IDE) and it has no problem showing detailed context tips.
Do I HAVE to download the 100+mb zip file to get the javadoc, or can I have Netbeans point to whatever Eclipse is already aware of?
I want to add a Check Constraint to a table for server 2005 but cannot work it out.
MemberId ClubId MeetingId
1 100 10
2 100 10
3 100 10
7 101 10 <-This would throw a check constraint
1 100 11
2 100 11
I do not want to have more than one ClubId for a single MeetingId
Basically a ClubId can only belong to a single MeetingId but can have more than one member assigned.
How do I achieve this?
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?
I have an Excel Spreadsheet that contains all my data that I need to put into an SQL Server database. I am fairly new o ASP.NET and have never had to export from Excel to SQL Server before.
My Excel spreadsheets looks like this
Trade Heading - ArtID - BusinessName - AdStyleCode - Address - Suburb
In SQL Server I have created a table named "Listings" which is in this format
intListingID - intCategoryID - BusinessName - ArtID - intAdCode -Address - Suburb
What would be the best way to export the data from Excel and then import it into SQLServer 2005.
Thanks...
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?
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 ?
Hello,
are there free, recommendable Tools for data modeling?
ERM/ORM Diagrams
Creating database models (SQL SERVER
2005)
Simple to use like Visio(no license
here)
Code generation is only a nice to
have (VB.Net)
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 would like to ask if there is a way to include the total number of rows, as an additional column, in the returned result sets from a TSQL query using also the Row_Number (SQL 2005) command.
For example, getting the results set from a query against Book table in a form similar to this:
RowNum BookId BookTitle TotalRows
--------------------------------------------
1 1056 Title1 5
2 1467 Title2 5
3 121 Title3 5
4 1789 Title4 5
5 789 Title5 5
I have the following tables/columns:
Parent:
ParentID
Child:
ChildID
ParentID
SubChild:
SubChildID
ChildID
Date
Parent has 1 to Many relationship with Child
Child has 1 to Many relationship with SubChild
For every Parent, I need to get the SubChild with the most recent Date value.
How can I do this using SQL. I've tried using MAX(Date),
but I can't seem to figure out how to join Parent and Child successfully.
The ideal result set would contain all the Parents joined with all the SubChild columns of the latest record.
Note: using MS SQL 2005+
I have a Qt exe built from visualstudio 2005(after taking the .cpp, .h, .moc, ui_ files)
I have done some simple QSqlite queries. It works fine in my development pc. But in another pc it crashes for the line below:
QSqlDatabase mSqlDb
How to run the exe so that it can interact with sqlite from another pc. [Any other gui application runs just fine.]
So which things are necessary to deploy a sqlite-qt application ?
Hello,
We have an .NET client app working against SQL Server 2005 (clustered), do I need to do something special in the client app to make it cluster aware?
Thanks.
I have been struggling in fixing this code, wonder what is wrong at all...
var tips = "<p class="adobe-reader-download">Most computers will open PDF documents automatically, but you may need to download <a title='Link to Adobe website-opens in a new window'";
tips +=" href='http://www.adobe.com/products/acrobat/readstep2.html' target='_blank'>Adobe Reader</a>.</p>";
if($("div#maincontent a[href*='.pdf']").length>0){
$("div#maincontent").children(":last-child").after(tip);
What is the best way to produce several tables of unknown size on the same worksheet? Values will be pulled from an oracle database and are used as values on several tables. Is it possible to create dynamic named ranges or is some other method desirable? I have some experience with c# but do not have access to VSTO 2005.
Any help or suggestions would be greatly appreciated.
I am willing to explain the problem further if requested.
I'm new to SSRS. We'll have two slightly different chunks of XML in a single row of an SQL Server database table. In an SSRS report we'll want to show only the differences between the XML chunks. I don't know how to do this, but I suspect the XML Type in SQLServer 2005 might be useful, or XSLT transformations in SSRS. Could anyone point me in the right direction?
Hi, I have a simple application in C# (Visual Studio 2005) that display a Crystal Reports report (Crystal Reports X1 R2). When I compiled the application it appears the following message: The report you requested requires further information. I want to set the connection info in the code so the application doesn't ask the user for the database password. It's a Oracle database.
I'm trying to do some cryptography for SQL Server 2000, and I know that only SQL 2005+ comes with built-in functionality for doing this natively.
Do you know any open source implementation that I can use for free of RSA-2048 cryptography?
I have two tables with the same column definitions. I need to move (not copy) a row from one table to another. Before I go off and use INSERT INTO/DELETE (in a transaction), is there a smarter way?
SQL Server 2005
Hi there,
I'm using VisualStudio2005 and have a DataTable with two columns and some rows that I want to output to the console. I hoped there would be something like:
DataTable results = MyMethod.GetResults();
Console.WriteLine (results.ToString());
What's the best way (i.e. least amount of coding from me) to convert a simple DataTable to a string?
Thanks,
Mark.
I want to use a standard dialog to solicit user input of an ADO.net connection string. It is trivial to do for the oledb connection string as described here:
MSDN Article on MSDASC.DataLinks().Prompt
I've also found examples that use Microsoft.Data.ConnectionUI.dll and MicrosoftData.ConnectionUI.Dialog.dll from VS (HOWTO: Using the Choose Data Source dialog of VisualStudio2005 from your own code).
Unfortunately these DLLs are not licensed for redistribution.
Is there a standard dialog for choosing a data source that can be distributed with my application?
I seem to remember seeing some neat way of calling InvokeRequired and Invoke to avoid repeating too much code in every event handler but I can't remember what that was.
So does anyone know a neat way of writing that code?
Preferably for VB.Net 2005.