|
From your code you will still have to log in as a user with admin rights in order to create a new login and user. The login information will go in the connection string (or it can be set to a trusted connection, in which case the user running the application will need the rights to create logins in the database)
You can run pretty much any SQL code through the SqlCommand object, so the commands will be the same.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|
|
OK - I give up. I really don't see why this would be voted 1. It answers the question without handholding this guy through a set of commands he probably wouldn't understand.
|
|
|
|
|
I just reported is in the suggestions.
There are really "small" people around here! 
What makes it even poorer is that it has to be a gold member of the community!
All the best,
Martin
|
|
|
|
|
|
using System.Reflection;
using System.Runtime.CompilerServices;
using System.Runtime.InteropServices;
// General Information about an assembly is controlled through the following
// set of attributes. Change these attribute values to modify the information
// associated with an assembly.
[assembly: AssemblyTitle("ClassLibrary1")]
[assembly: AssemblyDescription("caliculates the balance and amount")]
[assembly: AssemblyConfiguration("")]
[assembly: AssemblyCompany("cnn technologies")]
[assembly: AssemblyProduct("ClassLibrary1")]
[assembly: AssemblyCopyright("Copyright © 2007")]
[assembly: AssemblyTrademark("")]
[assembly: AssemblyCulture("us-en")]
// Setting ComVisible to false makes the types in this assembly not visible
// to COM components. If you need to access a type in this assembly from
// COM, set the ComVisible attribute to true on that type.
[assembly: ComVisible(false)]
// The following GUID is for the ID of the typelib if this project is exposed to COM
[assembly: Guid("f5d5a4ac-9064-4829-a781-f90668feba4b")]
// Version information for an assembly consists of the following four values:
//
// Major Version
// Minor Version
// Build Number
// Revision
//
// You can specify all the values or you can default the Revision and Build Numbers
// by using the '*' as shown below:
[assembly: AssemblyVersion("1.0.0.0")]
[assembly: AssemblyFileVersion("1.0.0.0")]
there is no assembly key file in this assembly
hi
|
|
|
|
|
Right click on the Project, select Properties, go to the Signing tab.
|
|
|
|
|
Hello,
Is there a way to find out if there is an opened data reader associated with a given connection. I searched through all properties of the SqlCommand and it's associated SqlConnection, but I could't find anything is there a way to find out?
Thank you!
drinking beer is fun 
|
|
|
|
|
you can check it in sql server query analyser by using this query
SELECT * FROM master.dbo.sysprocesses<br />
WHERE DB_NAME(dbid) = 'DATABASE NAME'
Regards,
Sylvester G
If we don't succeed, we run the risk of failure
|
|
|
|
|
Hi
I assume you want to do this to prevent the error about Multiple Active Result Sets on one connection by checking if the connection already has an open DataReader, and if it does, closing it.
If this is the case set MultipleActiveResultSets = true in your connection string to allow you to have more than one open DataReader on a connection.
If it isn't please describe in more detail what you are trying to do.
There are 10 types of people in the world, those who understand binary and those who dont.
|
|
|
|
|
Indeed that was the reason i was asking for help
Thank you, regards!
drinking beer is fun
|
|
|
|
|
On changing the index of the combo box giving the following exception
Invalid operation Exception:
List that this enumerator is bound to has been modified. An enumerator can only be used if the list does not change.
why this exception is coming pls help me!
|
|
|
|
|
Somewhere in that code your enumerating through a collection. Whilst you are doing this you cannot change the enumeration in any way. If you do you'll get that error.
|
|
|
|
|
Hi everybody!!!
How I can use ErrorProvider in DataGrid??? (It is for notice when the input data in some field is failur. In this case you mast see blinking of ErrorProvider in some field)
|
|
|
|
|
Hello,
I need to be urgent.
I need a Solution for the Following Proble.
I need to Export Data in Excel but record size is mre then 65536
which is more than the predefined size of the excel.so i need to
add remaining record in sheet2 when record size is greater than 65526.
Thanks in Advance.
Regards,
Rahul
|
|
|
|
|
rsp7023 wrote: I need to be urgent.
Not nice, considered rude around here.
rsp7023 wrote: I need to Export Data in Excel but record size is mre then 65536
which is more than the predefined size of the excel.so i need to
add remaining record in sheet2 when record size is greater than 65526.
Export out until you have Sheet1 filled up, then create Sheet2 and continue.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
hi,
this is probably not a good thing to ask, but i need help because i'm not an experienced programmer. I am working on writing a 'framework' that allows you to write applications that works on multitouch tables (or surface computers). now the code isn't complicated so most of you would not have trouble understanding it, even if you've never worked with multitouch applications.
no my question is: could someone please have a look at my code and tell me if there is a better, more efficient way to do what i'm doing? or if i could get better performance? or if there is a better approach?
all the application does is load 3 photos, and allow you to rotate/scale/drag is on the screen with your fingers.
the code is available here: http://www.whitespaced.co.za/WPF_MTPhotoApp_SOURCE.zip it won't compile, you'll need more files, but let me know if you wish to compile, then i'll add the link to those files
the code works as follows:
the TouchFramework class gets the finger events from a managed c++ wrapper for unmanaged c++ fingertracker. the is raises the events, any class that has those events get raises as well, in this case TouchCanvas. TouchCanvas checks to see which object was touched and the raises it's own event and passing as parameter the UIElement that was touched. Now all the other classes that has a reference to the current canvas gets that event and checks to see if it is the object that was touched(TouchImage) and does something about it. now this works fine, but the coding is bad, i don't know is a interface would be better. and i also feel to many events are being passed around. (ex. if there are 300 images on screen and you press your finger on any one, all 300 will check if it was the one touched after the TouchCanvas already figured out what was touched.
I would really appreciate any help on this subject as i want to write this as best as possible. i also want the 'framework' to be easily extensible by added new classes, like TouchVideo and so.
Thank you
Donovan
rather have something you don't need, than need something you don't have
|
|
|
|
|
Is there a particular part of your code you are having trouble with?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
ah,great quote!
no i'm not having trouble with the code.i just feel the touchframework and touchcanvas code can be improved,it all just feels so innefficient. i want to find the code issues at the beginning of the project,rather than the end.
rather have something you don't need, than need something you don't have
|
|
|
|
|
Hi all,
I'm creating a program that generates an Excel sheet and am trying to add password protection to it.
I want to make it so when the user initially opens the the Excel file it prompts for a password (so they see no data unless the password is correct).
i've tryed the following code based on a VB example I found but have had little success.
_oWB.Password = "Cmore";
_oWB.SetPasswordEncryptionOptions(
"Microsoft RSA SChannel Cryptographic Provider",
"RC4",
128,
true );
_oSheet.SaveAs( @sFileName,
Excel.XlFileFormat.xlXMLSpreadsheet,
_oWB.Password,
Missing.Value,
Missing.Value,
Missing.Value,
Missing.Value,
Missing.Value,
Missing.Value,
Missing.Value );
Cheers,
Mark
|
|
|
|
|
MarkBrock wrote: I found but have had little success
What is happening? Be a bit more specific.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
If you have Excel.
Click Tools > Options > Security - I'm trying to programmically set the "password to open" under this tab.
If correct. Excel should prompt you to enter a password before you are allowed to view the spreadsheet.
The code above is (my attempt at...) a c# equivalent of the code in this article...
[^]
Mark
|
|
|
|
|
Hi, i've got a problem here. i can't figure out why my form background and also the button change its color when i call the function below. how can i ensure that only the background changes? besides that, in the form i also need to draw and show some circles. How to ensure that when the background color changes, it still there?
public void b1_click(object sender, EventArgs e)
{
clg.ShowDialog();
this.BackColor = clg.Color;
}
|
|
|
|
|
Objects on your form inherit their background color from their container. In other words, if you place a button on your form, the background color will inherit from the form you put it on, unless you set the background color for the button (for example to 'Red').
Try setting the background color of your button to red and your code will work fine.
|
|
|
|
|
|
Hello,
The stringclass itselfe provides some usefull methods, but I think for that purpose you need "using System.Text.RegularExpressions"
All the best,
Martin
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
