|
Then execute those statements via ADO.net
Also note that I modified my response -- see if SQLCMD will do what you want.
|
|
|
|
|
I tried to excute other statments via ADO.net which is:
EXEC sp_attach_single_file_db @dbname = N'{'databasename'}' , @physname = N'{'path'}'
but an exception is occured
|
|
|
|
|
Don't you think including the exception would be helpful 
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
The Exception is:
DBAttachException: Cannot create file 'Database (LDF) Path' because it already exists. Change the file path or the file name, and retry the operation.
Could not open new database 'Database name'. CREATE DATABASE is aborted.
File activation failure. The physical file name "Path of my project of .Net" may be incorrect.
I hope that to be helpful !! 
|
|
|
|
|
Have you tried the statements I suggested?
What code did you use when you tried?
|
|
|
|
|
I tried your instruction using ADO, and it works..
Thank you very much.
But I want to show you the main reason of my problem, I was using sp_attach_single_file_db
but this instruction attach the database to SQL just if you have already attached it then deattached it !
But if you use this command to attach database for the first time to SQL it thow an exception
Thank you Mr.PIEBALDconsult you were helpful.
|
|
|
|
|
|
Hi to all,
I have made a set up of a project which use some dll files.When I install the setup with version say 1.0, it is installed properly.
I have another set up of same project but this updated say 2.0
Now I nstall 2.0 without uninstalling 1.0 to the same path(path of 1.0).
2.0 replace the 1.0 but those dll files are not replacing, still there are dll files of 1.0 are present.
Please guide me how to solve the problem.
Thanks in adv.
|
|
|
|
|
Have you ensured the assembly versions are being updated in the AssemblyInfo.cs file?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Thanks for ur replay.
I have changed the version in AssemblyInfo.cs.
Let me tell what are the versions-
Initially there was 1.0.0.0 version and then I changed it to 1.0.3.0.
Please can u tell me what settings we do in installer so that older overwrites the new.
|
|
|
|
|
I just had a similar problem.
Get Orca, a program which is part of the Microsoft SDK.
Open your .msi installer file in Orca.
Select properties from the left hand side.
Insert a new row into the table:
- Property: REINSTALLMODE
- Value: amus
This will cause your installer to overwrite previous versions when installing.
Remember for each release that you need to update the Version property for the Setup project, which (in VS 2008) will prompt you to create a new ProductCode GUID.
|
|
|
|
|
Hi,
I'm looking for the (class / property / etc) naming rules in c#. I thought 'surely the language specification must have them' and 'surely Google can tell me', problem is I keep finding naming conventions etc etc.
I need the RULES, e.g. You may not start a property name with a number. The stuff that makes the compiler break...
I don't care about upper case vs lower case etc, those are conventions...
____________________________________________________________
Be brave little warrior, be VERY brave
|
|
|
|
|
|
Hi, thanks for your reply but I am not looking for design patterns (I am familiar with a vast array of them already), I'm looking for a definitive list of rules for naming in c#
____________________________________________________________
Be brave little warrior, be VERY brave
|
|
|
|
|
Ah, i thought design patterns would be ah good basis how to name classes at least. Sorry if my answer couldn't help you.
|
|
|
|
|
You might find the ECMA Spec for C# useful. It's available here[^].
|
|
|
|
|
Another alternative is on MSDN[^] 
I are Troll 
|
|
|
|
|
See section 2.4.2 Identifiers of the CSharp Language Specification available from MSDN at http://msdn.microsoft.com/en-us/library/ms228593.aspx[^]
Generally speaking, identifiers must start with a letter or underscore and can follow with almost any unicode character. If the identifier is a keyword, it must be prefixed with an '@' character.
|
|
|
|
|
dear all
float nwidth = (ImageBW8 .Width / ImageBW8.ImageWidth);
float nheight =((ImageBW8 .Height / ImageBW8.ImageHeight);
ImageBW8 .Width ,ImageBW8.ImageWidth,
ImageBW8 .Height ,ImageBW8.ImageHeight, all got value, but however nwidth and nheight are 0.0. anyone can help me? why nwidth and nheight are only 0.0, instead of exact values there. thanks a lot.
|
|
|
|
|
Hi, maybe like this:
float nwidth = Convert.ToSingle(ImageBW8.Width) / Convert.ToSingle(ImageBW8.ImageWidth);
float nheight = Convert.ToSingle(ImageBW8.Height) / Convert.ToSingle(ImageBW8.ImageHeight);
|
|
|
|
|
Hi,
You can try :
float nwidth = (float)ImageBW8.Width / (float)ImageBW8.ImageWidth;
float nheight = (float)ImageBW8.Height / (float)ImageBW8.ImageHeight;
|
|
|
|
|
if those properties are integers, you get integer division.
And if 0 < Width < ImageWidth, you would get zero for nwidth.
You assigning the quotient to a float variable does not influence how an expression gets evaluated.
|
|
|
|
|
I’m apparently trying to do something stupid, because the C# help file says that I can’t, and that usually means my design is all jacked up.
Here’s a version of what I’m trying to do:
I have a base class, ItemBase, and I want to give it the method
public class ItemBase
{
public abstract static List<string> GetAvaliableUpgrades();
}
Then, I have three classes
public class Car : ItemBase { }
public class Van : ItemBase { }
public class Truck : ItemBase { }
(they implement GetAvaliableUpgrades())
And finally, I have a control
public class MyItemDisplay<T> : UserControl where T : ItemBase
{
public void SetUpgrades()
{
foreach (string s in T.GetAvaliableUpgrades())
listBox1.Items.Add(s);
}
}
Now I know that I can’t do that in C#, but I’m wondering if there is another way to implement this type of process. Since the Upgrades List is a property of the class itself and not unique to each instance, I want to make the GetAvaliableUpgrades() method static, and I don’t want to repeat myself, so I want the SetUpgrades() method in the Control to work on any ItemBase.
I know I can make something similar work by doing:
public class ItemBase
{
protected abstract List<string> GetMyUpgrades();
public static List<string> GetAvaliableUpgrades<T>() where T : ItemBase, new()
{
T item = new T();
return item.GetMyUpgrades();
}
}
public class MyItemDisplay<T> : UserControl where T : ItemBase
{
public void SetUpgrades()
{
foreach (string s in ItemBase.GetAvaliableUpgrades<T>())
listBox1.Items.Add(s);
}
}
But that feels sloppy and incorrect, since I’ve got to make an instance of a class to get a property about that class. Is there some kind of design pattern I can research that will allow me to get the kind of functionality that I’m looking for in C#? Or is there another way to allow me to have one control that works on a family of classes, without having to copy-paste a bunch of code? Thank you all in advance for your time!
Matt
|
|
|
|
|
Right, statics can't be polymorphic so they can't be abstract.
How will you get the upgrades? Are they plug-ins? Maybe you need an upgrade manager class?
|
|
|
|
|
I was going to have each class that : ItemBase have it hard coded, or maybe load from a file. My ultimate goal is to be able to create class AnyNewItem : ItemBase that I can just drop in to my program and will work with MyItemDisplay<T> : UserControl where T : ItemBase without me having to modify MyItemDisplay<T>.
Again, I could make the GetAvaliableUpgrades() non-static, but it doesn't feel right since the Upgrades are a propery of the class itself and not any specific instance.
Any ideas? =/
Thanks in advance,
Matt
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
