hi.
Microsoft Visual Studio 2008 Service pack 1 comes with Visual Basic Powerpacks which has the DataRepeater control.
I used this control in my c# winform application. in my system everything is running fine. now i copied the debug folder to other system which has only .Net Framework 3.5 SP1 installed. in this system is giving me error cannot…
There are two numbers, which are both between 1 and 30 inclusive. Person A knew the addition of the two numbers; Person B knew the multiplication of the two numbers;
A said:"do you know what numbers are they?"
B replied:"I don't know, do you know?"
A:"I don't know either" then
B said:"so, I knew already" then
A said:"I knew either"
What are…
Hey guys,
I have an Excel document which has a list of students and their group names. I have another sheet within the the same excel document which is called comments. In this sheet, I would like to have a list of individual team names listed.
There are 65 students and 14 defined groups.
Is there a way to select the 14 group names, without…
I have been trying to find info on the web about the differences between these statements, and it seems to me they are identical but I can't find confirmation of that or any kind of comparison between the two.
What is the difference between doing this:
BEGIN
-- Some update, insert, set statements
END
and doing this
BEGIN TRANS
--…
I allways used php 5.2.3 version ,but now I updated php to 5.3.2 version.
I have problem with mssql,I can`t connect to mssql server.
I have downloaded a sql server driver for php 1.1
There are a lot of files, i used 'php_sqlsrv_53_ts_vc9'
Put it on php/ext directory 'php_sqlsrv_53_ts_vc9'
I have added -…
Hello, I have some Regex, it looks like this:
string regexForDrop = @"^((%27)|'|(\-\-))\s*(d|%64|%44)(r|%72|%52)(o|%6F|%4F)(p|%70|%50)$";
It works fine, when i write to the input "--drop", but it does not works, when i write "drop table users" or something like that. I need that it would be working, no…
I've been using SQL Server since version 6.5 and I've always been a bit amazed at the fact that the tools seem to be targeted to DBAs rather than developers. I liked the simplicity and speed of the Query Analizer for example, but hated the built-in editor, which was really no better than a syntax…
I have a database on line with Godaddy (who uses SQL Server 2005). They provide basic management tools, but tell you that for more advanced tools you can connect directly using SSMS. I followed their instructions to ensure my online database will accept remote connections, and can apparently log…
I want to draw several graphs and combine them into one figure. I will explain the problem in an example. Let's say that I want to draw two graphs with these points:
Graph #1 (X and Y are defining a coordinate).
X - Y
_____
1 - 5
2 - 5
5 - 7
9 - 10
Graph #2
X - Y
_____
6 - 8
8 - 12
9 - 7…
Hello All:
How to pass a large number of parameters (say 20+) to stored procedure from code.
Like we can group all the parameters in one class object and then pass it across, but how to implement such this in case of stored procedures.
Currently I have to create 20+ variables to pass…
I have a function that writes 3 lines into a empty table like so:
INSERT [dbo].[yaf_ForumAccess] ([GroupID], [ForumID], [AccessMaskID]) VALUES (1, 8, 1)
INSERT [dbo].[yaf_ForumAccess] ([GroupID], [ForumID], [AccessMaskID]) VALUES (2, 8, 4)
INSERT [dbo].[yaf_ForumAccess] ([GroupID],…
i am reading this article:
http://www.juiceanalytics.com/writing/bubble-trouble/
i would like to make a chart that looks like this in excel.
is vba a requirement?
can anyone help me to start?
Is anyone can tell me where is mistake in this query
ALTER TABLE Countries
ADD (
HasPhotoInReadyStorage bit,
HasPhotoInWorkStorage bit,
HasPhotoInMaterialStorage bit,
HasText bit);
ALTER TABLE Regions
ADD ( HasPhotoInReadyStorage bit,
HasPhotoInWorkStorage bit,
…
hi.
Microsoft Visual Studio 2008 Service pack 1 comes with Visual Basic Powerpacks which has the DataRepeater control.
I used this control in my c# winform application. in my system everything is running fine. now i copied the debug folder to other system which has only…
Hi ,
My questing is related to population of modified date time field in AX during any posting. Suppose I have a server at singapore and i am working in India,and the current time in singapore is 12 p.m and that in India is 9 a.m. Then while I am posting any…
Hi,
I've got an Access application with an update query with the following syntax:
UPDATE TABLE1, TABLE2 SET
TABLE2.VALUE1 = TABLE1.VALUE1,
TABLE2.VALUE2 = TABLE1.VALUE2,
TABLE2.VALUE3 = TABLE1.VALUE3,
TABLE2.VALUE4 = TABLE1.VALUE4
The query is working…
I have a very large table in my database and I am starting to get this error
Could not allocate a new page for database 'mydatabase' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup,…
Why are UNIQUE Constraints needed in database ?
Can you provide any examples ?
Primary Key is UNIQUE by default... Understandable as they are referred in other tables as Foreign keys... relation is needed to connect them for rdbms platform...
but why…
I have this:
SELECT Product.ProductID, Product.Name, Product.GroupID, Product.GradeID, AVG(tblReview.Grade) AS Grade
FROM Product left Join tblReview ON Product.GroupID = tblReview.GroupID
WHERE (Product.CategoryID = @CategoryID)…
I'm considering using PostgreSQL with a .Net web app. Basically 3 reasons:
Mature Geo Queries
Small footprint + Linux
Price
I'm wondering a bit about tools though, SQL Server Profiler and query plans and performance monitors have been helpful. How is…
What is the correct way to get the Series of a char in PPT 2010.
I tried
PowerPoint.SeriesCollection mySeriesCollection = (PowerPoint.SeriesCollection)
myChart.SeriesCollection(1);
throws the…
Hi,
I have a table with 6 columns containing HTML content with some markups in it and now when moving to a new designed site most of this HTML code has to be deleted. More or less all tags except and .
Is there a nice way of doing this, identify all…
I am using a simple table with 6 columns, 3 of which are of XML type, not schema-constrained.
When the table reaches a size around 120,000 or 150,000 rows, I see a dramatic performance cost in doing any query in the table. For comparison, I have…