SQL Command Wrapper class and configuration instance in web.config - .NET (Core and Framework) Discussion Boards

Starkie7013-Oct-09 9:01

13-Oct-09 9:01

Ok, I first want to say that I am VERY new to visual studio 2008. So, this may be an easy question to answer for many of you. I have created 10 forms and what I noticed is that 7 of the forms have the same controls. The other 3 forms have have the controls as well but 3 addition controls have been added to the form. My question is 2 fold. One, how do I copy or clone one of these forms including the code to another new form. I have tried a few things in the past but the controls do not stay in the same location so I am sure I have yet to find the right way to do it. The second question would be what way would you handle this situation. Let's say you have your form and that form has 4 controls. You need another form that has all the same controls and properties as the previous form but with an additional 2 controls. Is the parent/child method the only way to do this and if so what limitations with classes and objects. Considering, I am a begginer any help would be appreciated.

Thanks

Re: Cloning winforms

Henry Minute13-Oct-09 10:11

Henry Minute

13-Oct-09 10:11

What you are talking about is called 'Visual Inheritance' in .Net/VS.

You didn't say which language but here is a link[^] for VB.Net, it uses a previous version but is still relevant, and another[^] for C#.

If you google for vb.net visual inheritance or c# visual inheritance you will find lots of help.

And here[^] is a sort of tutorial with code download for both languages.

Hope this helps! Smile | :)

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.”

how do my Windows forms buttons change their border appearance at runtime?

mnemonic6913-Oct-09 0:41

mnemonic69

13-Oct-09 0:41

Very confused here!

I can't work out how the runtime changes the border of my button to orange from blue when the mouse pointer hovers over it!

Because no mouse event handlers are defined in the application, so where is this behaviour coming from??

Clearly if this was a web app, I could easily guess that some client script was doing this, but it is simply an ordinary .NET 3.5 windows app!

Re: how do my Windows forms buttons change their border appearance at runtime?

Richard MacCutchan13-Oct-09 1:14

Richard MacCutchan

13-Oct-09 1:14

mnemonic69 wrote:
Because no mouse event handlers are defined in the application, so where is this behaviour coming from??

This is the default behaviour of the control. Take a look at this information on MSDN[^] for further details.

Re: how do my Windows forms buttons change their border appearance at runtime?

mnemonic6913-Oct-09 2:12

mnemonic69

13-Oct-09 2:12

Hi,
I did take a look at MSDN and it doesn't explain what that 'standard behaviour' is or how that 'standard behaviour works'

Thats why I thought, someone on here might know the answer!! D'Oh! | :doh:

Re: how do my Windows forms buttons change their border appearance at runtime?

Richard MacCutchan13-Oct-09 2:54

Richard MacCutchan

13-Oct-09 2:54

mnemonic69 wrote:
I did take a look at MSDN and it doesn't explain what that 'standard behaviour' is

Yes, sorry, but as usual Microsoft tend to hide this sort of detail deep in the reference guides. I had assumed that a link to the Button control would give you what information you sought. Suffice to say that you can overrirde almost everything in your application just by changing properties and/or implementing event handlers.

BTW, does the lack of this information prevent you from completing some part of your work?

Re: how do my Windows forms buttons change their border appearance at runtime?

Shameel19-Oct-09 0:05

Shameel

19-Oct-09 0:05

I think you are talking about the Luna theme in Windows XP. It is taken care by Windows XP and you don't have to worry about it. Change your Windows theme to Classic and you will see what is happening.

Regards,
Shameel

SQL Command Wrapper class and configuration instance in web.config

NICE TO MEET13-Oct-09 0:29

NICE TO MEET

13-Oct-09 0:29

;?xml version="1.0" encoding="utf-8"?&gt;
&lt;dataConfiguration&gt;
   &lt;xmlSerializerSection type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"&gt;
         &lt;enterpriseLibrary.databaseSettings xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" defaultInstance="Database Instance" xmlns="http://www.microsoft.com/practices/enterpriselibrary/08-31-2004/data"&gt;
            &lt;databaseTypes&gt;
                  &lt;databaseType name="Sql Server" type="Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase, Microsoft.Practices.EnterpriseLibrary.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" /&gt;
            &lt;/databaseTypes&gt;
            &lt;instances&gt;
                  &lt;instance name="Database Instance" type="Sql Server" connectionString="Server=awsqlt25vs01;Database=SW2_phone_interview;Integrated Security=true;" /&gt;
            &lt;/instances&gt;
            &lt;connectionStrings&gt;
                  &lt;connectionString name="Server=awsqlt25vs01;Database=SW2_phone_interview;Integrated Security=true;"&gt;
                     &lt;parameters&gt;
                           &lt;parameter name="database" value="SW2_phone_interview" isSensitive="false" /&gt;
                           &lt;parameter name="Integrated Security" value="true" isSensitive="false" /&gt;
                           &lt;parameter name="server" value="awsqlt25vs01" isSensitive="false" /&gt;
                     &lt;/parameters&gt;
                  &lt;/connectionString&gt;
            &lt;/connectionStrings&gt;
         &lt;/enterpriseLibrary.databaseSettings&gt;
   &lt;/xmlSerializerSection&gt;
&lt;/dataConfiguration&gt;

I have the above code snippet in my windows application. Now in some methods I am getting tome out exception. So I need to add one more instance for Microsoft.Practices.EnterpriseLibrary.Data.SQL.SQLCommandWrapper to set the connection time out property for a constant value in config file

Please advise

Thanks in advance.

Stored procedure

krishnaveer12-Oct-09 21:36

krishnaveer

12-Oct-09 21:36

Hi,

I have written a stored procedure in which some insert and update statements are there. This SP i'm running in my local PC and inserting & updating some tables from remote sql server to my local sqlserver.

Now the problem is that this SP is taking too much time to execute, app. 5-7 min.

Now plz advice me some optmize solution for this.

Thanx...

krishna veer singh

Re: Stored procedure

Pete O'Hanlon12-Oct-09 21:52

Pete O'Hanlon

12-Oct-09 21:52

There's far too little information here for anybody to offer you reasonable help. If I were you, I'd look to run a SQL profiler on the stored procedure and analyze the results from this. This will tell you where your holdups are.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

WPF DataGrid without database

Nick Alexeev12-Oct-09 9:57

Nick Alexeev

12-Oct-09 9:57

Colleagues,

I would like to populate WPF DataGrid with data that my program generates on the fly and without a database or a file. Could you suggest me how to do it?

Tips, hints, references, insight are all appreciated!

Cheers,
- Nick

Re: WPF DataGrid without database

Pete O'Hanlon12-Oct-09 10:25

Pete O'Hanlon

12-Oct-09 10:25

Create a business model and populate it into an ObservableCollection. That's the most basic thing I can think of for you. There are plenty of tutorials around that demonstrate how to do this.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

VB.Net Socket Questions

raineym12-Oct-09 5:12

raineym

12-Oct-09 5:12

I am in the middle of creating a program for people that play pen-and-paper RPGs to roll dice on their computer (like this program), but utilizes a server/client based-IM portion to send the die roll results to all the clients and I am going to modify the following code as given here: http://www.devx.com/dotnet/Article/28253/0/page/2 to do that.

As this is my first time creating a program that utilizes anything having to do with sockets, I have a couple of questions that I have yet to find an answer about on Google, various programming sites, or other forums. Here are my questions:

The server will not be static, as in not always on the same LAN and with the same IP address. I intend for the person acting as the server to be able to start the server and act as the server on any LAN they happen to be attached to. How do I get the server to broadcast its IP/HOSTNAME so that clients can attach to it without the person who is acting as the server having to give the others the information to log in. For example, the person starting the server may be on a LAN with a network address of 192.168.xxx.xxx and another time on one that has an address of 10.1.xxx.xxx.
That leads to the next question. How do I get the clients to detect the server? If there happens to be more than one "server" on the network (i.e., large gaming conventions and the like), I would like for the person trying to connect to be able to detect all of them and choose the correct one. Sort of like the person starting the server to give it a name like "[b][i]Big Al's Gaming Group[/i][/b]", not just using the Host Name of the computer.
Just for the sake of my curiosity and knowledge, and I probably know the answer to this and have a way to send the rolls to the clients already, but can you send different datatypes other than strings over the connection and have them arrive as the same datatype? I currently have the rolls going into an arraylist to be displayed in a listview control, and would love the arraylist to be sent over the connection.

I have all but this portion of the program coded and operational.

Mike Rainey
--------------------------------

Re: VB.Net Socket Questions

N a v a n e e t h12-Oct-09 16:51

N a v a n e e t h

12-Oct-09 16:51

IMO, server need not broadcast it's details. Just start the server and listen on a specific port. Also server should prompt to enter a name for it. This name will be send to clients for displaying. Make sure all your clients know the port which server is using.

When each client is starting, it should send a message asking for the server to provide details. UDP is the appropriate protocol for broadcasting such kind of messages. .NET framework has a UdpClient[^] class which can be useful. Your client will broadcast a message something like SERVER_DETAILS. The server program should be able to grab this message and send the servers IP, name and other required details. Receive this details on the client and show the details.
Data will be send as bytes always. You need a wrapper to convert the bytes to appropriate data type. There are open-source initiatives like protocol buffers[^] which will allow to send messages by providing type safety. But in reality, for a highly scalable application, designing your own message protocol works well.

Array list can be send after serializing it to bytes. Read about BinaryFormater class.

raineym wrote:
I am going to modify the following code as given here: http://www.devx.com/dotnet/Article/28253/0/page/2 to do that.

That is too naive way of doing a scalable networking application. You should work with Sockets directly rather than with wrapper classes like TcpListener or TcpClient. I suggest this[^] MSDN article.

Smile | :)

Navaneeth

How to use google | Ask smart questions

Label position in the Listview

lbs.allies11-Oct-09 20:39

lbs.allies

11-Oct-09 20:39

I want to get the label position of the listview,i want to avoid that position when mouse hover event is raised ..pls help me..

Get moving mouse position

lbs.allies11-Oct-09 20:06

lbs.allies

11-Oct-09 20:06

I have two windows forms and I need to get the changing mouse position at the same time in the next form. I am using a function in the mouse move event ,so how should i properly do that..pls help me

Re: Get moving mouse position

freakyit11-Oct-09 22:36

freakyit

11-Oct-09 22:36

you only get the mouse position by overriding the MouseMove event and only if the Form has the focus!

there could by only one MousePosition at system, never saw two mouse cursors at one screen Big Grin | :-D

to get the current mouse position use GetMousePosition from win32 api or set a gobal mouse hook to retrieve the current position of the mouse if your form is not focused.

hope i could help

Re: Get moving mouse position

Luc Pattyn12-Oct-09 0:20

Luc Pattyn

12-Oct-09 0:20

Also: Control.MousePosition gives the mouse position (in screen coordinates) any time you call it.

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Local announcement (Antwerp region): Lange Wapper? Neen!

Re: Get moving mouse position

freakyit12-Oct-09 1:04

freakyit

12-Oct-09 1:04

thats right didn't mind Smile | :)

and never used till now Smile | :)

Getting cd/dvd drive information

offroaderdan11-Oct-09 4:42

offroaderdan

11-Oct-09 4:42

Hi,

I have made (or making) a program that features a lot of mini videos. I would like to put the program on a disc and be a able to play the program on ANY windows pc.

However i don't know what the code is to retrieve the drive information which the disc would be in. e.g on computer A the disc might be in drive "D" and on computer B it might be in drive "F"..........

I am a beginner ish programmer, and if anybody could help me that would be very kind and am using vb.net

Many thanks

Dan

Re: Getting cd/dvd drive information

Henry Minute11-Oct-09 5:12

Henry Minute

11-Oct-09 5:12

One way to get the information you need is to use the WMI classes in .Net.

It is too complicated to give detailed information in a forum like this but if you google on vb.net wmi disk information you will get lots of relevent hits. Smile | :)

There are other ways, but this is the most comprehensive.

Re: Getting cd/dvd drive information

offroaderdan11-Oct-09 5:39

offroaderdan

11-Oct-09 5:39

thanks for the quick reply!!!

I want the program to find the drive automatically, the wmi disk information on google seem to be a form with all the information on it. I don't really want to do that.

i found some information which you might be able to turn around and point me in the right direction.

code

for each curDrive as IO.DriveInfo in My.Computer.FileSystems.Drives

'this bit i want to do something like
if curDrive.name = c then lblDriveName = "C:\" ' i can then add it to the links later on.

is this possible or do i use the wmi way??

many thanks

Dan

Re: Getting cd/dvd drive information

Henry Minute11-Oct-09 6:00

Henry Minute

11-Oct-09 6:00

I use VB.Net so rarely that I had forgotten all about My.Computer.FileSystem. Blush | :O

Take a look at this page[^]. **NOTE** you will have to scroll in the text box to reach the code (I say this because it didn't show up too well on my system, not cos I think you might be a bit dim Smile | :)

)

I think that it has the solution for your problem. I found it by googling for vb.net find dvd drive, in case that one is not quite right for you.

Good Luck! Smile | :)

Re: Getting cd/dvd drive information [modified]

Luc Pattyn11-Oct-09 6:12

Luc Pattyn

11-Oct-09 6:12

Apart from WMI, there is no managed code only solution to this. However you could use P/Invoke technology to call a native function inside kernel32.dll; in C# it would look somewhat like this:

// start file with
using System.Runtime.InteropServices;		// DllImport

// and inside one class, put:

[DllImport("kernel32.dll")]
public static extern int GetDriveType(string rootPathName);

public void CheckAllDrives() 
    foreach(string deviceLetter in Environment.GetLogicalDrives()) {
        if (GetDriveType(deviceLetter)==5) Console.WriteLine(deviceLetter+" is a CD or DVD drive");
    }
}

and in VB.NET it would resemble this (not tested):

' start file with
Imports System.Runtime.InteropServices         ' DllImport

' and inside one class, put:

Declare Shared int GetDriveType Lib "kernel32.dll" (ByVal rootPathName As String)

public Sub CheckAllDrives()
    For Each(deviceLetter as String in Environment.GetLogicalDrives())
        if (GetDriveType(deviceLetter) = 5) Console.WriteLine(deviceLetter & " is a CD or DVD drive");
    Next
End Sub

BTW: there might be multiple CD/DVD drives in a system.

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Local announcement (Antwerp region): Lange Wapper? Neen!

modified on Sunday, October 11, 2009 12:18 PM

Re: Getting cd/dvd drive information

Alan N11-Oct-09 6:43

Alan N

11-Oct-09 6:43

Hi,
If I have interpreted the question correctly then the program is executed from the the disc that you are trying to find. In that case there are several ways to get the path information.

1) System.Environment.CurrentDirectory[^]
2) System.Windows.Forms.Application.StartupPath[^]
3) System.Reflection.Assembly.GetEntryAssembly.Location[^]

In all cases you could use System.IO.Path.GetPathRoot to extract the root directory.

Alan.

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