C# Discussion Boards - CodeProject

Re: Convert a pdf file to picture format with the best quality

4-Mar-09 14:36

check ImageMagick's documentation or forum.

Yusuf

Christian Graus4-Mar-09 16:20

Christian Graus

4-Mar-09 16:20

I suggest you hire someone to do this for you, you really don't seem to have any semblance of a clue.

Christian Graus

Driven to the arms of OSX by Vista.

c# call ddl visualc++

mateecom4-Mar-09 11:03

mateecom

4-Mar-09 11:03

I have problem
at c#
i created interface that have signature OtherFrame(ref Byte[] data) and build for create dll
at visual c++
i use dll interface from c# I dont know function that have same signature interface

virtual void FirstFrame(array<Byte>^% frame)
{
unsigned char *tmp = new unsigned char [frame->Length];
for(int i = 0; i > frame->Length; i++)
tmp[i] = frame[i];
changepicture(tmp);
delete[] tmp;
}
i create function. it work but It cannot past by referrence becase of
a picture on picture box at c# it not change.
any one can help me
thank you

[Message Deleted]

Michael Halsig4-Mar-09 9:41

Michael Halsig

4-Mar-09 9:41

[Message Deleted]

Re: TextBox Context Menu Strip adding my items.

Yusuf4-Mar-09 10:27

Re: TextBox Context Menu Strip adding my items.

4-Mar-09 10:27

you did not specify your framework, so assuming you working with 3.5 see here[^]

Yusuf

Michael Halsig4-Mar-09 11:06

Michael Halsig

4-Mar-09 11:06

I am using .Net Framework 2.0 sorry I should have included that in my original post.

System.Net.Mail setup

dptalt4-Mar-09 8:51

dptalt

4-Mar-09 8:51

When using this class how come the examples I see on the internet do not include statements for port number, username and password, and servername?

I'm going to be using this class on a client app and I think I need to supply this information but do not know how to code it.

fly9044-Mar-09 9:12

fly904

4-Mar-09 9:12

You need to use System.Net.Mail.SmtpClient[^] and then SmtpClient.Credentials[^].

Simple credential:

client.Credentials = new System.Net.NetworkCredential(username, password);

hmmm pie

PauloCastilho4-Mar-09 9:20

PauloCastilho

4-Mar-09 9:20

System.Net.Mail.SmtpClient smtp = new System.Net.Mail.SmtpClient([Host], [Port]);
smtp.Credentials = new System.Net.NetworkCredential([UserName], [Password]);

If you prefer, use the config file (web.config, app.config).

<system.net>
	<mailSettings>
		<smtp>
			<network host="" port="" userName="" password="" />
		</smtp>
	</mailSettings>
</system.net>

Yusuf4-Mar-09 9:23

4-Mar-09 9:23

I have seen many that give examples, but they wont give you real working one.

See here[^] and here[^] for code examples

Yusuf

dptalt4-Mar-09 10:01

dptalt

4-Mar-09 10:01

The code file in the second link is very cool. Thanks!

Yusuf4-Mar-09 10:14

4-Mar-09 10:14

use it responsibly.

Yusuf

Populating combobox with values from Table using C#

Dave Kreskowiak4-Mar-09 9:51

Dave Kreskowiak

4-Mar-09 9:51

System.Net.Mail is not a class, but is a namespace.

Documentation...[^]

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

haroon19804-Mar-09 8:05

haroon1980

4-Mar-09 8:05

Hi,

I have following function below but is not populating values from the table product?

private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
 
                database = new OleDbConnection(connectionString);
 
                // Create a command object and then a query which accepts a papameter
                System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("Select * from Products", database);
                database.Open();
                System.Data.OleDb.OleDbDataReader dr;
                dr=cmd.ExecuteReader();
 
                while (dr.Read())
                {
                    //comboBox3.Items.AddRange(new object[] { dr[1].ToString() });  //Change the index according to the values you want to populate in the combobox.
                    comboBox3.Items.Add(dr["ProductName"]);
 
                }
            }
                catch (Exception ex)
            {
 
                MessageBox.Show(ex.Message);
                return;
            }
                
               
               }

regards,

Re: Populating combobox with values from Table using C# [modified]

Jimmanuel4-Mar-09 8:41

Jimmanuel

4-Mar-09 8:41

- you probably want to clear out the old values from the combo box before you populate it with new data
- don't forget to close dr and database after you're finished using them otherwise you'll leak resources
- what happens when you step through this in the debugger? does your while loop properly iterate through all the rows in the DB?
- if the only column you're using from the DB table is ProductName then doing a Select * is rather inefficient.
- just for my own curiosity, why are you doing this in the SelectedIndexChanged event handler for the combo box?

Last modified: after originally posted -- grammar correction

Re: Populating combobox with values from Table using C#

haroon19804-Mar-09 9:18

haroon1980

4-Mar-09 9:18

Hi Jimmanuel,
...What else method or way u recommend instead of SelectedIndexChanged ? can u pls gimme example?
... I have 3 fields in that table so why it is inefficient?

i have changed code and following is here: to include dr.close method..

 private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {

                database = new OleDbConnection(connectionString);

                // Create a command object and then a query which accepts a papameter
                System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("Select distinct ProductName from Products", database);
                database.Open();
                System.Data.OleDb.OleDbDataReader dr;
                dr = cmd.ExecuteReader();

                while (dr.Read())
                {
                    //comboBox3.Items.AddRange(new object[] { dr[1].ToString() });  //Change the index according to the values you want to populate in the combobox.
                    comboBox3.Items.AddRange(new Object[] { dr[1].ToString() });
                    
                }
                dr.Close();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
                return;
            }
}

please help

Re: Populating combobox with values from Table using C#

Jimmanuel4-Mar-09 9:44

Jimmanuel

4-Mar-09 9:44

How often is the DB Table going to change? If it doesn't change or rarely changes then you really only need to populate the combo box values once - when the form loads. If it does change frequently then there are lots of good ways to keep the combo box up to date. You could use a timer to reload the values every so often, put a button on the form that allows the user to refresh whenever they want or work out some way of receiving a notification any time that the table changes.

database.Close() is just as important. That closes the connection to the DB, otherwise it gets orphaned. A using[^] statement would be helpful in making sure that everything gets cleaned up whether an exception is thrown or not.

Say your table has 10 rows; that means that all you want from it is 10 product names but a select * statement is giving you back the 10 product names plus 20 other values that you aren't using. That's 3 times as much network traffic as you actually need. It might not be a big deal now but what if there were 10,000 rows? What if later on the table changes and more columns get added? For each column that's added that's more unnecessary traffic between your app and your DB and more time and memory required to handle your select. Select distinct ProductName is the way to go here. In fact, I can't recall a time that I've ever used select *.

Re: Populating combobox with values from Table using C#

Yusuf4-Mar-09 9:26

Re: Populating combobox with values from Table using C#

4-Mar-09 9:26

why are you populating comboBox3 from db when something got selected on the same combobox?

You know showing any other thing except populating your combobox. You need to do this only once or when ever the data changes.

Yusuf

haroon19804-Mar-09 10:54

haroon1980

4-Mar-09 10:54

thanks Yusuf, i just want to see the product names in this comboBox thats all..and which will come from Products Table...

regards,

Confused | :confused:

C# Referencing Cell on DataGrid

Wheels0124-Mar-09 6:06

Wheels012

4-Mar-09 6:06

Good afternoon.

I am trying to reference the cell on a datagrid.

The Description column is hidden, but I want the description to populate a text box when the user clicks on a specific row.

I have the following so far:
rtxtDescription.Text = DataGridView1.Rows[index].Cells[2].Value.ToString();

The column is 2 and the row would depended on which row is selected.

I am using Visual Studio 2008.

Any suggestions?

WHEELS

dan!sh 4-Mar-09 6:08

dan!sh

4-Mar-09 6:08

CellClick event?

Time is the best teacher; unfortunately it kills all of its students.

जय हिंद

Wheels0124-Mar-09 6:40

Wheels012

4-Mar-09 6:40

It is actually in a method:

public void PopulateDataGrid()
{
ds = new DataSet();
ds = d.FillDataGrid(this.cboDepartment.SelectedValue.ToString(), this.txtAcronym.Text);
DataGridView1.Columns.Clear();
if (ds != null && ds.Tables.Count != 0)
{
BindingSource bs = new BindingSource();
bs.DataSource = ds;
bs.DataMember = ds.Tables[0].TableName;
DataGridView1.DataSource = bs;
//return;
}
foreach (DataGridViewColumn col in DataGridView1.Columns)
{
if (col.HeaderText == constrDescrColumn) { col.Visible = false; }
}
//MessageBox.Show(DataGridView1.CurrentRow.Cells.IndexOf(.ToString());
int index = 0;
rtxtDescription.Text = DataGridView1.Rows[index].Cells[2].Value.ToString();

}

led mike4-Mar-09 7:13

led mike

4-Mar-09 7:13

Wheels012 wrote:
It is actually in a method:

In your first post you asked for suggestions and the reply was "CellClick event"

Now I could be wrong, but if I am correct it appears you have completely missed the point.