Posts by Ramy Mahrous

Greate, Sknake

Open new query document and copy the script and paste it there.

You don't avoid injection just from application, but to run any code against the SP + it's not maintainable and this is the big risk in business application development, I'm sure for every scenario use think I must use dynamic SQL there's better solution by not it.

Sure it must exist!
How to tell SQL Server create windows authentication login to windows user which doesn't exist?!

what is the name of hte new login Im creating?

??????????????? I don't know, I can't tell you that piece of information?? And how can I!! If you need more details about SQL Login read post about it http://ramymahrous.wordpress.com/2009/04/28/how-to-create-sql-server-login-programmatically/

There's not user called CF5\MyLogin on your machine!!
Do you have this user?! Sure you don't!

Yes you need some tutorial in T-SQL as said, please contact me to provide you with some books.

edi843, You have lack in your logic design! how you need to achieve wrapping to class without accessing its methods?!

It's not override at all! it's wrapping classes with different names...

public class Parent
    {
        public void Add(object o) { //some code }

    }
    public class Child : Parent
    {
        public void Aggungi(object o)
        {
            base.Add(o);
        }
    }

*seems[text]

doesn't work!
[/text]

I want to override methodA of classA, but not with the name methodA, but with a different name,

So why do you need to override it :)?? method with different implementation with different name!!!

You've million dozens of examples for method overloading, and if you develop business applications you'll feel that. But let me give you an example; object initiation, you need some object(s) or none to initiate object, let's see SqlCommand class constructors, it let the developer initiate the class with whatever proper of objects he has\likes...

Here you're http://blogs.msdn.com/tess/archive/2008/04/17/how-does-the-gc-work-and-what-are-the-sizes-of-the-different-generations.aspx

http://www.testingreflections.com/node/view/5635

public interface IFunction
{
public void Function1();
public void Function2();
}

Your syntax isn't correct. Do you have intension to learn OOP from scratch by asking a lot of questions?!
Please mark all previous threads as solved included this one.

What do you mean by external assembly?? if you mean a dll, it just a methodology to keep some related functions in assembly to be reusable by many different applications.

Nothing would happen. but for more clarification what will happen when?!
An example what would happen if you didn't override ToString method?! Nothing it'd return the name of the class.

I need to have it as byte values, so the permutation needs to be 0a0b0c

It means that abc the binary file = 0a0b0c??
To get string bytes have a look
http://msdn.microsoft.com/en-us/library/system.text.asciiencoding.getbytes(VS.71).aspx

Check the Inner Exception, what it says?
It works with me...

Here you're as I promised
Again you need to add references
1- Microsoft.SqlServer.Smo
2- Microsoft.SqlServer.ConnectionInfo
3- Microsoft.SqlServer.SqlEnum

Server sqlServerInstance = new Server(
                new Microsoft.SqlServer.Management.Common.ServerConnection(
                new System.Data.SqlClient.SqlConnection("Data Source=.;Initial Catalog=Master;Integrated Security=True")));// your connection string I place mine for illustration..
            Login loginObj = new Login(sqlServerInstance, @"DomainName\UserName");
            loginObj.DefaultDatabase = "Master";
            loginObj.LoginType = LoginType.WindowsUser;
            loginObj.Create("password"); //set the password
//there're many properties to do some tasks related to Login object...

looooooooooool, really looooooool, I didn't say please please I beg you I beg you give me reputation point :D, I said mark it as solved :)

Thanks, Mahendrabilla for the great article :)

Use BackgroundWorker component which is use for multithreading tasks you can call the method by name and send the parameters in array of objects.

You can discuss that in MySQL forum http://www.daniweb.com/forums/forum126.html please help moderators to keep the Daniweb organized.

If you're satisfied, I'm happy, so please mark it as solved!

If you execute SQL Statement against SQLite, add distinct!! DataSet hasn't do to any much work over it carries data for you!

Seems you added wrong assemblies, you should add
Micrsoft.SqlServer.Smo and Microsoft.SqlServer.ConnectionInfo

I'm going to do a sample and in couple of hours I'll show you how to do it using SMO.

If you tell me how you generate the permutations of length 6 (C# code) , I tell you how to do so with 4 and 5

Did you search on this error as it's?

DataSet?! SQLite doesn't have Distinct keyword?

Before binding

List<Object> dataAsObj = new List<Object>();
foreach(var x in Data)
{
if(!dataAsObj.Contains(x))
dataAsObj.Add(x);
}
cbb_City.DataSource = dataAsObj;
cbb_City.DisplayMember = "Accounts.City";
cbb_City.ValueMember = "Accounts.City";

Daniweb just shows everything 32 days ago... please check this!

http://forums.devx.com/showthread.php?t=137415
http://www.csoft.co.uk/faq/ota.htm

using System.Text.RegularExpression;

Imports System.Text.RegularExpression

From TextBox properties set MaxLength to 3
Or textBox1.MaxLength = 3;

Application not ApplicationClass!
== Microsoft.Office.Interop.Excel.Application xl = new Microsoft.Office.Interop.Excel.Application();

What I meant is your code has syntax errors!

If you've local copy of MSDN
Create Login using SQL statement
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/eb737149-7c92-4552-946b-91085d8b1b01.htm
Create Login using SMO
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/smo9mref/html/b327d041-e7c3-6396-8a72-200e9507f97b.htm

Online MSDN
Create Login using SQL statement
http://msdn.microsoft.com/en-us/library/ms189751.aspx
Create Login using SMO
http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.login.create.aspx

Add using Microsoft.Office.Interop.Excel;

Yes, you can create Stored Procedure and pass any parameters you need to create login

Generic solution http://fci-h.blogspot.com/2008/04/how-to-save-image-in-sql-server.html

See the documentation of finger print device and see its API section.

Dynamic SQL is very risky!!

Mark it as solved and thank you very much for adding the link :)

Please use this forum Database Design http://www.daniweb.com/forums/forum142.html in such type of questions.
Ensure all columns trainid, and journeyid have the same data type, all in all it should work.

Or they can post their question to http://www.daniweb.com/forums/forum18.html to keep our forums organized.

I recommend you to normalize your table first then we can engage with SQL.

Search on video processing in C# you'll find more.

Danny, send me the link of some of his videos. Let's think in something else coding :D

- CLR inside .NET Framework, right?
- Right.
- Can you install it on Linux?
- No.
- JVM is installing on any platform, right?
- Right.
- So, you, can run any Java-made application on any platform
- What about Mono?
- It solves the problem, but it's not supported by MS.
- Is platform independence true meaning??
- NO, you need to do a lot of work to customize your application on the distribution OS.
- Can you (Ramy Mahrous) count the features of C#?
- I can't.

Java applications run on many platform, Serkan, I don't know how you ask this question!!
C# as it produces .exe so it runs on Windows.
We don't want to get the asker to mad. let us discuss that away this thread.
All in all, in my personal opinion if my son tell me, what to learn Papa, I'll recommend for him C#

OK, so mark it as solved!