C# Discussion Boards - CodeProject

seoamitk1-Sep-09 23:06

1-Sep-09 23:06

hi

?xml version="1.0" encoding="utf-8" ?
<configuration>
<appSettings>
<add key="Accesskey" value="Data source=.;Initial catalog=kirti;user id=sa;Password=./>
</appSettings>
</configuration>

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WindowsApplication9
{
public partial class Form1 : Form
{
SqlConnection connection;
string con;
public Form1()
{
con = System.Configuration.ConfigurationSettings.AppSettings["Accesskey"].ToString();
connection = new SqlConnection(con);
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{

}

private void button1_Click(object sender, EventArgs e)
{
try
{
connection.Open();
SqlCommand commad = new SqlCommand("select *from " + textBox1.Text.ToString() + "", connection);
SqlDataAdapter ad = new SqlDataAdapter(commad);
DataSet ds = new DataSet();
ad.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];

}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
connection.Close();
}
}
}
}

This code is writren in C# you have just convert into VB.NET.

Getting DBMS/Database server list using C#

AhmedMasum1-Sep-09 3:59

AhmedMasum

1-Sep-09 3:59

Hi all,
Can some one tell me how can I get a list of different DBMS/ Database server, those are installed in a computer using C#.

Re: Getting DBMS/Database server list using C#

Henry Minute1-Sep-09 4:17

Henry Minute

1-Sep-09 4:17

For SqlServer only:

private void GetServerList()
{
    DataTable dt;

    // Set local server as default
    dt = SmoApplication.EnumAvailableSqlServers(false);
    if (dt.Rows.Count > 0)
    {
        // Load server names into combo box
        foreach (DataRow dr in dt.Rows)
        {
            ServerNamesComboBox.Items.Add(dr["Name"]);
        }

        // Default to this machine
        ServerNamesComboBox.SelectedIndex
            = ServerNamesComboBox.FindStringExact(
            System.Environment.MachineName);

        // If this machine is not a SQL server
        // then select the first server in the list
        if (ServerNamesComboBox.SelectedIndex < 0)
        {
            ServerNamesComboBox.SelectedIndex = 0;
        }
    }
    else
    {
        ExceptionMessageBox emb = new ExceptionMessageBox();
        emb.Text = Properties.Resources.NoSqlServers;
        emb.Show(this);
    }
}

cannot help with non-SqlServer DBMSs.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: Getting DBMS/Database server list using C#

AhmedMasum1-Sep-09 4:28

AhmedMasum

1-Sep-09 4:28

Thanks for reply.
But I can not run this because of the following errors:

Error 2 The name 'SmoApplication' does not exist in the current context

Error 3 The type or namespace name 'ExceptionMessageBox' could not be found (are you missing a using directive or an assembly reference?)

Error 4 The type or namespace name 'ExceptionMessageBox' could not be found (are you missing a using directive or an assembly reference?)

Error 5 'WindowsApplication1.Properties.Resources' does not contain a definition for 'NoSqlServers'

Re: Getting DBMS/Database server list using C#

Henry Minute1-Sep-09 4:38

Henry Minute

1-Sep-09 4:38

All of the code can be run using standard .NET Framework references.

Google, or search MSDN, for smoapplication. From there you will find links to information that will help you to get it running.

As part of the process you will have to add references to the following assemblies:

// SMO namespaces
using Microsoft.SqlServer.Management.Common;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer;
using Microsoft.SqlServer.MessageBox;

The code comes from one of the SqlServer samples downloads, from MSDN.

Re: Getting DBMS/Database server list using C#

AhmedMasum2-Sep-09 3:29

AhmedMasum

2-Sep-09 3:29

Thanks I m getting the result of your code. But it is not providing me the actual result that I needed.

Memory leakage in c# multithreading application windows service application

susantasamanta851-Sep-09 3:42

susantasamanta85

1-Sep-09 3:42

I have a windows service multithreaded application for indexing purpose which have six threads. It is working fine except memory leakage. Actually when the service is started, then the service is consuming 12,584kb memory, after some time it is taking memory of 61,584 kb. But after indexing process is complete it is not releasing memory. I need it come back to its previous position after the indexing is complete, that is it should take the memory with which it started e.g. 12,584kb in this case. I have used garbage collection but it is not doing what I want.

Can anyone please help me?

Re: Memory leakage in c# multithreading application windows service application

DaveyM691-Sep-09 3:46

DaveyM69

1-Sep-09 3:46

Are you sure it's actually using that memory. Task Manager reports the amount of memory a process has reserved, not how much it's using. If that memory is needed elsewhere and your app isn't using it, it will be reclaimed.

In case it is, make sure that any objects you are using that have a Dispose method have that called once you are done with them [Edit] or better still, if possible use using blocks [/Edit]. If you are using any PInvoke, make sure you are releasing any unmanaged resources too.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Re: Memory leakage in c# multithreading application windows service application

Dave Kreskowiak1-Sep-09 5:12

Dave Kreskowiak

1-Sep-09 5:12

Task Manager is telling you how much memory is reserved for the .NET CLR your app is running under. It's entirely possible for the CLR to reserve that much memory even though your app is not using it. The reason for this is because the CLR watches what your app has done and since it already allocated a large amount of memory, it'll keep the memory around in case your app wants it again. It's fast to allocate an object with memory that is already in the Managed Heap than it is to wait for the CLR to request memory from Windows, add it to the Managed Heap, then make the allocation.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

webbrowser stealing focus

yeah10001-Sep-09 3:14

yeah1000

1-Sep-09 3:14

Hello,
i am using a webbrowser control on my form together with textboxes. What i need is that when i load the form the cursor will be in textbox, but instead the webbrowser "steals focus". I have tried using the Focus() property for the textbox in just about anywhere now but it still wont work. Also i have tried creating event handlers for webbrowser's different events (GotFocus, Validated etc) but nothing seems to work.

The only thing that worked was the DocumentCompleted handler, which can make the cursor go to the textbox but not when the form loads, which is strange, since i have the browser go to a web page when the form loads (after InitializeComponent).
TY

Re: webbrowser stealing focus

OriginalGriff1-Sep-09 3:38

OriginalGriff

1-Sep-09 3:38

What you need to do is set the Tab Order. This indicates which controls get the input focus in which order when you press tab to switch between them. The lowest tab order control gets the focus first on form load. Simple.
Tab order is initialy assigned in order of control creation, so if you create your browser first, then create the textboxes, the browser gets the focus.

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Re: webbrowser stealing focus

yeah10001-Sep-09 3:42

yeah1000

1-Sep-09 3:42

I forgot to mention it, but tab order has been set properly. The cursor still goes to google.com's search bar (google.com is the site being automatically loaded into webbrowser at startup).

Re: webbrowser stealing focus

OriginalGriff1-Sep-09 4:24

OriginalGriff

1-Sep-09 4:24

Just tried it, with a browser docked in a panel, and a textbox with button outside the panel. Set URL to "http:\\www.Google.co.uk" in design properties, TabIndex is Textbox = 0, button = 1, panel = 2.0
Works fine, Cursor in textbox on form load. How is this different from yours?

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Re: webbrowser stealing focus [modified]

yeah10001-Sep-09 19:35

yeah1000

1-Sep-09 19:35

Its not different. When i do the same thing, the cursor automatically goes to webbrowser Frown | :(

I just discovered that the problem exists only with some pages (google, orkut, youtube, hotmail etc). When i use any of my local sites (.ee) then it works just fine.

Why is that so? google and microsoft using some fancy scripts?

modified on Wednesday, September 2, 2009 2:54 AM

Prevent the ^ character from beeing entered in textbox.

xkrja1-Sep-09 3:10

xkrja

1-Sep-09 3:10

How can I prevent the ^ character from being typed in a textbox? The problem seems to be that the character is not added before another keydown/keyup event.

For some other keys I used the following code to prevent them from being typed:

void textBox_KeyUp(object sender, KeyEventArgs e)
        {
            if ((Keyboard.Modifiers & ModifierKeys.Alt) == ModifierKeys.Alt)
            {
                if (e.PlatformKeyCode <= 12)
                    e.Handled = true;

                switch (e.PlatformKeyCode)
                {
                    case 226:
                        e.Handled = true;
                        break;
                }
            }
            else if ((Keyboard.Modifiers & ModifierKeys.Shift) == ModifierKeys.Shift)
            {
                switch (e.PlatformKeyCode)
                {
                    case 52:
                        e.Handled = true;
                        break;
                    case 186:
                        e.Handled = true;
                        break;
                }
            }
        }

However, this does not work for the ^ character.

Thanks for help!

Re: Prevent the ^ character from beeing entered in textbox.

stancrm1-Sep-09 3:27

stancrm

1-Sep-09 3:27

private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
  if(e.KeyChar == '^')
  {
    e.Handled = true;
  }
}

Re: Prevent the ^ character from beeing entered in textbox.

OriginalGriff1-Sep-09 3:31

OriginalGriff

1-Sep-09 3:31

Couple of things:
1) KeyUp is probably not a good place to disable keys, as KeyPress happens repeatedly before KeyUp occurs. Try handling KeyDown, KeyPress and KeyUp with Console.WriteLine in each to show the flow of events.
2) If you are going to use magic numbers then comment the damn things so the next poor sod stands a chance of understanding what you are doing:

// Disable '%' key
case 52:

is a lot more useful than

case 52:

By preference, use '%' instead of magic numbers, or constants with sensible names, or even "Keys."
3) Use KeyPress to disable your code:

private void textBox_KeyPress(object sender, KeyPressEventArgs e)
    {
    if (e.KeyChar == '^')
        {
        e.Handled = true;
        }
    }

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Re: Prevent the ^ character from beeing entered in textbox.

xkrja1-Sep-09 3:37

xkrja

1-Sep-09 3:37

Thanks for the replies guys. Sorry, but I forgot to mention that I work in Silverlight. I can't get to the KeyPress event. Only KeyDown and KeyUp.

Thanks again.

Re: Prevent the ^ character from beeing entered in textbox.

Henry Minute1-Sep-09 4:23

Henry Minute

1-Sep-09 4:23

In that case you should probably post your question in the SilverLight Forum.

client side validation for server control

dotnetcsharpdev1-Sep-09 2:47

dotnetcsharpdev

1-Sep-09 2:47

I need to have a popup window asking user for yes and no when he selects delete if he says yes i go ahead and delete otherwise i return back to screen and do other things.

Can I write a javascript method and call it in onclick of my delete button?
will it work?

not sure as delete linkbutton runat="server".

Re: client side validation for server control

stancrm1-Sep-09 2:49

stancrm

1-Sep-09 2:49

wrong forum -> goto ASP.NET

Wrong path.

yuneyev1-Sep-09 2:33

yuneyev

1-Sep-09 2:33

Hi everyone.

I'm having an error in my application that is confusing me.
The error is this one:

Could not find a part of the path "C:\CrkBusinessplatform\Aplicacao\Publico\sistemas\ccs\CRK.Monitores\sistemas\ccs\CRK.Monitores\monitor_arquivos\xslt\ACCS001.xslt"

Here are the facts: The correct path would be C:\CrkBusinessplatform\Aplicacao\Publico\sistemas\ccs\CRK.Monitores\xslt\ACCS001.xslt -> A part of the path is coming twice.
The archive ACCS001 is in this correct path.

The code line of the error is like this:
xslt.Load(Page.Request.PhysicalApplicationPath+"/monitor_arquivos/xslt/ACCS001.xslt");

I'm using .NET 1.1 on IIS 6.
The folder CRK.Monitores is a virtual directory in IIS. So the code should return the right path, right?

Oh, one more thing. The DLL of this page is the same here and there(I have checked it). And the error does not occur here.

Thanks in advance. Smile | :)

Re: Wrong path.

stancrm1-Sep-09 2:50

stancrm

1-Sep-09 2:50

wrong forum -> goto ASP.NET

Re: Wrong path.

Luc Pattyn1-Sep-09 4:48

Luc Pattyn

1-Sep-09 4:48

you seem to be mixing slashes and backslashes, Windows doesn't like that very much. Try using backslashes consistently.

Smile | :)

Luc Pattyn

Badger | [badger,badger,badger,badger...]

Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.

Re: Wrong path.

Tony Richards1-Sep-09 9:09

Tony Richards

1-Sep-09 9:09

Have you tried echoing Page.Request.PhysicalApplicationPath to confirm that what you think it outputs is what it actually outputs? To me, this looks like you're making a false assumption about the returned value.

My Blog: This Blog

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.