C# Discussion Boards - CodeProject

Soot22-Aug-06 10:24

22-Aug-06 10:24

Ok I have got my page to display the data I need using a store procedure etc. What I need to know is, how do I create an input text form box (IE: Enter ID here Smile | :)

with a submit button and pass that variable to the (ident = 1) below to make it (ident = textboxvariable). Any help would be appreciated thanks! =)

<%Dim ident

'select your product_id
ident = 1
Dim connection
Dim rs

'create the connection
connection = Server.CreateObject("adodb.connection")
'create the connection (here we used a DSN - use any standard connection
connection.open("Driver={SQL Server};Server=X;Database=trd;Uid=X;Pwd=X;")

'create the recordset
rs = Server.CreateObject("adodb.recordset")

'open the recordset, passing in the variable
'note that the variable product_id does not have to be name the same as in the stored procedure, it just needs to be the same data type.

rs.Open("Exec GETID " & ident, connection)

'display the recordset
Do Until rs.EOF
For Each ident In rs.Fields
Response.Write(ident.value & "<br />")
Next
Response.Write("<br />")
rs.MoveNext()
Loop
rs.close()
connection.close()%>

Jesse Myer
jessemyer06@aol.com

-- modified at 16:24 Tuesday 22nd August, 2006

Re: ASP ADO Variable Problem

Guffa22-Aug-06 11:18

Guffa

22-Aug-06 11:18

Please don't cross post.

---
b { font-weight: normal; }

Objects, Databases and best practice

martin_hughes22-Aug-06 9:39

martin_hughes

22-Aug-06 9:39

Hi All,

I have a business object, an "Asset", which takes it's data from a database table. Now, the "Asset" has a field called CompanyID, which is an int. This is great for the database, program and developer(me), but users might baulk at having to refer to numbers. Naturally, CompanyID is a relation to another table in the database.

So my question is: what's the best way of including a human friendly CompanyName in the Asset object? I could create a property which is filled in when the object is created from the db data, or I could have the object look up it's CompanyName whenever required or... What's the best thing to do?

Thanks,

Martin.

Re: Objects, Databases and best practice

Christian Graus22-Aug-06 11:24

Christian Graus

22-Aug-06 11:24

I'd expect the class to have a private ID and a public string for the name. Any object once read is disconnected from the database unless you re-read it, generally I think it's accepted that what you're looking at is the object at the moment you first requested it.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: Objects, Databases and best practice

Guffa22-Aug-06 11:53

Guffa

22-Aug-06 11:53

What I usually do is to join in the company table, so that I can fetch the company id and the company name in the query. Then I create a Company object from those, and store that object in the asset object.

To access the name of the company, I use: theAsset.Company.Name

---
b { font-weight: normal; }

Re: Objects, Databases and best practice

Ennis Ray Lynch, Jr.22-Aug-06 12:12

Ennis Ray Lynch, Jr.

22-Aug-06 12:12

You now have two choices lazy or earlier instantiation

Early:

public class Asset{
    private Company company = null;
}//end Asset

Have the DAL immediately load company

or lazy:

public class Asset{
    private Int32? companyID = null;
    private Company company = null;

    public Company Company{
        get{
            if(this.company == null && this.companyID != null){
                ... Get it
            }
            return this.company;
        }
    }

}

in early your DAL will just fill the company

On two occasions I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question. - Charles Babbage

Compiling through Shell Execution Code

zaigham_chaudhry22-Aug-06 9:10

zaigham_chaudhry

22-Aug-06 9:10

Hi there:
As you know we can compile a C Sharp program at DOS prompt like

csc MyProgram.cs

Where MyProgram.cs is the source code file.

Now i want to perform the same compilation through another C Sharp Program. Like i made a program named ShellExecution, which tries to compile another C Sharp Source Code File called "First.cs" lying in my c directory. The program runs fine without any exceptions; it opens the dos window and runs csc, but nothing happens and seems like the file name "First.cs" is not being passed to the csc.exe as a parameter. I have used the following code for executing the compilation process:

System.Diagnostics.Process process = new System.Diagnostics.Process();
process.StartInfo.FileName = "C:\\WINDOWS\\Microsoft.NET\\Framework\\v2.0.50727\\CSC.exe";
process.StartInfo.Arguments = "C:\\First.cs";
process.StartInfo.UseShellExecute = true;
process.StartInfo.RedirectStandardOutput = false;
process.StartInfo.CreateNoWindow = false;
process.Start();
process.WaitForExit();

Please help me out!!!!

Re: Compiling through Shell Execution Code

Ed.Poore22-Aug-06 12:02

Ed.Poore

22-Aug-06 12:02

Why don't you take a look at the Microsoft.CSharp namespace? That's got some wrappers around the compiler.

As of how to accomplish this I wouldn't have a clue at the moment and I'm too lazy to google it

Re: Compiling through Shell Execution Code

zaigham_chaudhry24-Aug-06 5:54

zaigham_chaudhry

24-Aug-06 5:54

No, i dont have to use Microsoft.CSharp.
Its a requirement to use shell execution either through ShellExecute API or through the System.Diagnostics.Process namespace(as i have done in my code). Please anyone help me. I'm stuck.

Re: Compiling through Shell Execution Code

Ed.Poore24-Aug-06 6:51

Ed.Poore

24-Aug-06 6:51

You're code works fine on my machine (but had to change WINDOWS to WINNT).

As of how to accomplish this, have you ever tried Google?

Get Running Processes Using A Library [modified]

Aaron Dilliard22-Aug-06 9:03

Aaron Dilliard

22-Aug-06 9:03

I was wondering if there was a way to determine application dependencies at runtime..

I have several applications sharing a managed library registered in the GAC. When I need to update that library (not changing its version info, so that I dont have to recompile the programs to use the updated library), I need a way to see what open processes are using that library so I can kill them before the update.

If anyone has any suggestions, please let me know.

Thanks is advance,
Aaron

Re: Get Running Processes Using A Library

Nader Elshehabi22-Aug-06 12:12

Nader Elshehabi

22-Aug-06 12:12

Hello

If you already know all the applications that could possibly be using that library, you could look the up using Process.GetProcesses Method. Otherwise reboot in safe mood, then replace it.

Regards Rose | [Rose]

HTML Page from Windows

kalyanPaladugu22-Aug-06 8:44

kalyanPaladugu

22-Aug-06 8:44

I want to open a HTML Page from Windows forms.
Iam using System.Diagnostic.process Api to do that.

First is there any other way to do it.
Second i want to control the size of the internetexplorer
window when i open it. Is there a way to do that

Thanks
Kal

Re: HTML Page from Windows

Jun Du22-Aug-06 8:52

Jun Du

22-Aug-06 8:52

kalyanPaladugu wrote:
I want to open a HTML Page from Windows forms.

Within your window form, or to a web browser?

If you want to open it to a web browser, you choose among Process.Start(), ShellExec(), or ShellFileOperation().

If you want to open it on your window form, add a web browser control to the form and call its Navigate().

Best,
Jun

Re: HTML Page from Windows

kalyanPaladugu22-Aug-06 8:57

kalyanPaladugu

22-Aug-06 8:57

1.Iam thinking of web browser. I want to resize the web browser
it opens in

2. Since you asked the question. Can i open it in windowsform it self and
use the print functionality of the opened HTML page inside windows forms.
If possible how to open it inside windows forms

Re: HTML Page from Windows

Jun Du22-Aug-06 9:09

Jun Du

22-Aug-06 9:09

See my modified previous post.

Best,
Jun

Re: HTML Page from Windows

kalyanPaladugu22-Aug-06 9:13

kalyanPaladugu

22-Aug-06 9:13

With the Process.Start() how do i control the size of the web form
which is opened

Thanks
Kal

Re: HTML Page from Windows

Jun Du22-Aug-06 9:50

Jun Du

22-Aug-06 9:50

ProcessStartInfo supports limited options on the opened window: hiden, minimized, maximized, normal. Other window styles have to go through the client program, "iexplore", for example.

Best,
Jun

serial port

Yustme22-Aug-06 8:25

Yustme

22-Aug-06 8:25

Hi,

Im trying to make a program to communicate with something that is connected with the serial port.

The device i wanna connect to the serial port knows several commands.

So basically there needs to be a simple connection with the port so that i can put commands in the console and the device reply's me and sets its output on the console.

So far i got this:

static SerialPort serialPort;

public static void Main()
{
serialPort = new SerialPort("COM1", 19200, Parity.None, 8, StopBits.One);
}

I hope someone could help me a bit.

Thanks in advance!

Re: serial port

Nader Elshehabi22-Aug-06 12:20

Nader Elshehabi

22-Aug-06 12:20

hello

Yustme wrote:
I hope someone could help me a bit.

With what?? Where is your question?

Regards Rose | [Rose]

Some Questions about Compact Framework and TabControl

RizwanSharp22-Aug-06 8:11

RizwanSharp

22-Aug-06 8:11

Hello Devs,
I'm new to Compact Framework Programming. I'm porting a Chat application to Window Mobile. I noticed that whenever I create and oshow a new instance f Form, its shown as a seperate procees in Running Prgrams. 10 forms means 10 Processes in Running Programs WTF | :WTF:

.
To avoid this to happen, I thought to work with tab controls and adding a tab page to the tab control when a user initiates chat with a new person.
What I want is that I want to add and remove pages dynamically. For this when I tap and hold on the node of the tab page (equal to Right Click) a context menu should open "Close Tab" and Taping this menu item that specific Tabpage should be closed. I have tried to do it with Context Menu but It does appear when you tap and hold on the tab page, not its node Cry | :((

I have tried to be clear in telling my problem but even if you need some more clarity and info please ask me.

I really want to get a solution (Its so urgent)
I hope to get a positive response from you people.

Best Regards,
Rizwan

Re: Some Questions about Compact Framework and TabControl

Nader Elshehabi22-Aug-06 12:03

Nader Elshehabi

22-Aug-06 12:03

Hello

dotnetdev83 wrote:
but It does appear when you tap and hold on the tab page, not its node

It depends on which event you handled. Either TabControl.MouseDown, or TabPage.MouseDown. In your case you probably consumed TabPage's not the TabControl's event.

Handle TabControl.MouseDown event and check TabControl.SelectedIndex
Regards Rose | [Rose]

Help with treeview and icons

Anthony Mushrow22-Aug-06 7:57

Anthony Mushrow

22-Aug-06 7:57

Quite simply, i can't find out how to add them.

All i know is, well, nothing really, i have a treeview, and it has nodes in it, and there are no pictures.

...

Re: Help with treeview and icons

Nader Elshehabi22-Aug-06 11:56

Nader Elshehabi

22-Aug-06 11:56

Hello

1- Make an ImageList
2- Add images to it using ImageList.Images.Add() method
3- Change the Treeview.ImageList to the above ImageList
4- Change the TreeView.ImageIndex to the index of the default icon
5- Change the Treenode.ImageIndex property of each node

Regards

want example code , select , insert .update ,delete for SQLserver on windows form with c# 2005

tanapop22-Aug-06 6:48

tanapop

22-Aug-06 6:48

Example
Search in database

using DataGite

using change colum name listview in thai

lmjojopjkopkop

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