C# Discussion Boards - CodeProject

30-Jan-07 21:37

I installed Multi SQL(sql 2000 and sql 2005) at home.
I want to get everyone of sql instance's name.
ex:in sql server manager,has a ServerName list
ServerName list:
vs\sql2k
vs\sql05
VS\SQLEXPRESS
"vs" is my computer's name.
I want to get ServerName list.
Thanks for anybody who give me help.

jason_mf30-Jan-07 22:11

30-Jan-07 22:11

Please help me anybody!Thanks.

jdkulkarni30-Jan-07 22:20

30-Jan-07 22:20

Please do not post multiple messages for the same question. Instead wait for some time.
You can check this code.
http://www.codeproject.com/cs/database/SubmitSQLInfoEnumerator.asp[^] Smile | :)

Jayant D. Kulkarni
Brainbench Certified Software Engineer in C#, ASP.NET, .NET Framework and ADO.NET

jason_mf31-Jan-07 1:48

31-Jan-07 1:48

Thanks.
otherwise, I ain't intentional for it that post multiple messages for the same question.

Colin Angus Mackay30-Jan-07 22:40

Colin Angus Mackay

30-Jan-07 22:40

You waited a whole 36 minutes between initial posting and repeat plea for help. If you need help that fast then I suggest you phone Microsoft support. for a fee they will answer any question on their products.

If you don't want to pay then you are at the whim of people who are giving up their time to help because they like to help, not because they are paid to help.

Upcoming events:
* Glasgow Geek Dinner (5th March)
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

jason_mf31-Jan-07 1:43

Add a extra row to a datagrid which you can edit an bind

31-Jan-07 1:43

oh,sorry. I ain't intentional. Frown | :(

thanks remind.

peggy70630-Jan-07 21:28

peggy706

30-Jan-07 21:28

Hi,
I have a problem with a datagrid.
I want to add an extra row to it, this works fine by building tablecells and add them to the grid for each entry in the grid.
The extra rows can be edited by the user, but I don't know how I can bind this extra rows to my datagrid, so the changes of the user are recognized by the webform. Frown | :(

can you please help me with my Problem, or is it impossible to add extra rows, that can be edited by a user?

thank you for your help
Peggy

Re: Add a extra row to a datagrid which you can edit an bind

jdkulkarni30-Jan-07 22:10

30-Jan-07 22:10

You do not need to do anything extra. You create a datatable and bind it to datagrid. Allow user to add a row to datagrid. When user says update then you just use SqlCommanBuilder object to perform the insert operation. You can also refer my article http://www.codeproject.com/useritems/DataGridView_manipulation.asp[^] Smile | :)

Jayant D. Kulkarni
Brainbench Certified Software Engineer in C#, ASP.NET, .NET Framework and ADO.NET

Use GAC Assembly.

Rahul.RK30-Jan-07 21:23

30-Jan-07 21:23

Hello Friends,

I want to know how to use assembly which is registered in GAC(Global Assembly Cache).

I have Created an assembly name dellMe.dll and i have registered it with same name but different

version 1.0.0.0 abd 1.0.0.1. Can i load the any one of the assembly at runtime.

Basically, i want to know how to do this refering of assembly in our C#.Net application.

Any Example will be helpfull.

Thanks In Advance.

Rahul Kulkarni

jdkulkarni30-Jan-07 22:18

30-Jan-07 22:18

You can do it using reflection.

Assembly asm = Assembly.Load("System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089");

Jayant D. Kulkarni
Brainbench Certified Software Engineer in C#, ASP.NET, .NET Framework and ADO.NET

Rahul.RK30-Jan-07 23:20

30-Jan-07 23:20

For this i have to copy the assembly. Right?

how can i keep different versions of assembly of same name?

Thanks.

Rahul Kulkarni

jdkulkarni30-Jan-07 23:29

30-Jan-07 23:29

If you check the code carefully then you will come to know that System.Data is from GAC only. Now I have .NET 1.1 and .NET 2.0 installed on my machine. Both contains System.Data but with different versions. That is the speciality of GAC. You need to create a strong name and change the version. Then you can copy your assembly in GAC. You do not need to copy it to your application.

Jayant D. Kulkarni
Brainbench Certified Software Engineer in C#, ASP.NET, .NET Framework and ADO.NET

Rahul.RK30-Jan-07 23:37

30-Jan-07 23:37

Thanks ....It works nice.

Thank You Very much

Rahul Kulkarni

Rahul.RK31-Jan-07 0:03

31-Jan-07 0:03

As per you said all working fine.

even we can create instatance of the class of the assembly.

How can we call function of that class. It is not giving intellisense.

what is the solution.?

Rahul Kulkarni.

jdkulkarni31-Jan-07 0:16

31-Jan-07 0:16

Can do like this.

Assembly asm = Assembly.Load("System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089");
            Type[] tps = asm.GetTypes();
            foreach (Type tp in tps)
            {
                if (tp.IsClass)
                {
                    MethodInfo[] methods = tp.GetMethods();
                    object abc = Activator.CreateInstance(tp);
                    if (!methods[0].IsStatic)
                    {
                        methods[0].Invoke(tp, new object[] { });
                    }
                }    
            }

Jayant D. Kulkarni
Brainbench Certified Software Engineer in C#, ASP.NET, .NET Framework and ADO.NET

jdkulkarni31-Jan-07 1:08

31-Jan-07 1:08

Here is a sample code that will open a connection to sql server using reflection.

string connString = "Server = localhost; Database = EmployeePortal; User ID = abc; Password = abc; Trusted_Connection = False;";
            Assembly asm = Assembly.Load("System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089");
            
            Type[] tps = asm.GetTypes();
            foreach (Type tp in tps)
            {
                if (tp.IsClass)
                {
                    if (tp.Name == "SqlConnection")
                    {
                        Console.WriteLine("Sql connection found...");
                    }
                    MethodInfo[] methods = tp.GetMethods();
                    object abc = null;
                    try
                    {
                         abc = Activator.CreateInstance(tp, connString);
                    }
                    catch (Exception ex)
                    {
                    }
                    foreach (MethodInfo method in methods)
                    {
                        if (tp.Name == "SqlConnection" && method.Name == "Open")
                        {
                            Console.WriteLine(method.Name);
                            method.Invoke(abc, null);
                        }
                    }
                }    
            }

Jayant D. Kulkarni
Brainbench Certified Software Engineer in C#, ASP.NET, .NET Framework and ADO.NET

Rahul.RK31-Jan-07 2:05