Re: .net equivalent of ddx + q about anchoring - C# Discussion Boards

Re: Loop through combobox items

5-Aug-05 0:21

The combobox has an Items collection. Each item in the collection has properties for the text and value.

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

fady_sayegh5-Aug-05 0:29

fady_sayegh

5-Aug-05 0:29

thanks to your reply,

i tried to use the items but i doesn't work because my combo is binded with a dataset

comboBox1.DisplayMember = "LIBL";
comboBox1.ValueMember = "ID";
comboBox1.DataSource = oDs.Tables[0];

the dataset is filled through a stored procedure

best regards,

fady

Re: Loop through combobox items

Guffa5-Aug-05 4:43

capturing the right click and paste mouse events

5-Aug-05 4:43

When you bind the data, the Items collection is populated. Then it doesn't matter where the data came from.

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

pjoseph9994-Aug-05 23:33

pjoseph999

4-Aug-05 23:33

Could someone please give me an example in c# on capturing the right click and paste mouse events from any forms/applications. I can capture/monitor this using the keyboard but cannot do so when using mouse cut/copy and paste. Need help please.

I looked at the Globalhooksdemo (project in code project) in c# but only helped me on keyboard cut/copy and paste.

Thanks in advance

.net equivalent of ddx + q about anchoring

roel_4-Aug-05 22:58

roel_

4-Aug-05 22:58

Hi,

I'm quite new to c# and windows.forms, so these are probably very basic questions Smile | :)

The first one is: what's the .net equivalent of ddx in mfc? Meaning, how do I associate the values of textboxes and checkboxes etc on forms with members of that forms? I've found ControlBindingsCollection and friends but that seems to be only for binding to databases, I want to bind to normal variables.

Secondly, in my dialog I have the following:

|---|       |---|
| A |  XXX  | B |
|---|       |---|

where the two squares A and B are list boxes and the XXX is a button. Now what I want is when the dialog is resized that the button stays the same size and that the two listboxes take up the rest of the space, so that the distance between the right of A and the left of the button stays the same, and the distance between the left of B and the right of the button stays the same as well. I cannot simply set the 'Anchor' property of A and B to 'Left,Top,Right' because that will make them overlap each other, which in turn is caused by the fact that the Anchor is relative to the parent container which is the dialog in this case. How do I do this? (Apart from overriding the dialog's OnSize and positioning everything manually).

cheers,

roel

Pradyumna Gogte5-Aug-05 0:17

Pradyumna Gogte

5-Aug-05 0:17

Hi Roel,

First you have a much better option in c# than the one offered by MFC through the ddx functions. c# or .net controls on your form are true objects and not wrappers as in case of the of MFC. You could directly access the value of the control so in a sence there is no real need to have another variable in the form to store it. You could do something like TextBox.Text to access the value any time you want. However if you still wanted the MFC like functionality then you could probably hook the form validate event and code the actual transfer of data from control to variable manually. Why have this over head when you can access the values directly?

For the second problem you cannot do this through setting properties. You have to do this programatically.

Cheers,
Prady

roel_5-Aug-05 1:17

roel_

5-Aug-05 1:17

Hello Pradyumna,

Thank you for your explanation. The reason I wanted to save to another variable was first because I thought that the controls would not be available anymore once the dialog is closed, and secondly because I'd like to encapsulate the type of control (if I decide to change a textbox with a combobox I'd have to go around around change calls to .Text with calls to .SelectedText). But I've found another way to encapsulate the functionality that I require in my dialog, so for now this problem is not relevant to me any more - but still, it's good to know for the future that there is no equivalent to ddx and that I'll have to save data manually.

As for the second part, that's too bad, I thought that with windows forms we'd have layout managers that would be just as powerful as those in eg Java's AWT or in the GTK toolkit. Looks like I was wrong Frown | :(

Thanks for your time!

cheers,

roel

Pradyumna Gogte5-Aug-05 2:01

Pradyumna Gogte

5-Aug-05 2:01

Roel,

The version 2.0 for the .net framework has the layout mangers in the forms. So may be you can wait for that.

Prady

how to define length of double dimension array

Dan Neely5-Aug-05 2:04

Dan Neely

5-Aug-05 2:04

roel_ wrote:
As for the second part, that's too bad, I thought that with windows forms we'd have layout managers that would be just as powerful as those in eg Java's AWT or in the GTK toolkit. Looks like I was wrong

.net 2 is supposed to have a much more complete layout manager. Until then however you're stuck with doing it the hardway if you want anything complex.

Anonymous4-Aug-05 22:48

Anonymous

4-Aug-05 22:48

I want to define an array and will redfine on recieving the values from database.But I dont know how to redefine the string array.

string[][] TestArray;

/// now how to define the dimensions like I want it this way after getting records--- TestArray[5][2] - which shows 5 records and two values + latter if I fetch more values the array should be redefined with last values saved + new added values which will make it like TestArray[10][2]

Re: how to define length of double dimension array

mav.northwind4-Aug-05 22:58

mav.northwind

4-Aug-05 22:58

Try this:

string[,] TestArray;<br />
TestArray = new string[10,2];

Regards,
mav

Re: how to define length of double dimension array

Anonymous4-Aug-05 23:08

Anonymous

4-Aug-05 23:08

Thanks it worked fine. One last thing how to preserve the previous values while re-defining the length. Like I am building this array in a while loop and on each turn I have to add one string node. but it initialize complete array every time.

Thanks in Advance

Re: how to define length of double dimension array

Guffa4-Aug-05 23:52

Delete related record problem

4-Aug-05 23:52

You can't change the size of an array. You could create a new array and copy everything from the old array, but that would be quite slow, and scales horribly bad.

Use an ArrayList or similar class, that has built in functionality to grow. As a list is one dimensional, you would put arrays in the list.

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

Ming Luo4-Aug-05 22:33

Ming Luo

4-Aug-05 22:33

Hello Everyone!
I have two related table Customer and Address, one customer may have several address. The source database is in access. I use the following code to populate the dataset and define the relationship between customer table and address table.

<br />
cus_adaptr.SelectCommand = cn.CreateCommand();<br />
cus_adaptr.SelectCommand.CommandText = "Select * from Customer";<br />
cus_adaptr.MissingSchemaAction = MissingSchemaAction.AddWithKey;<br />
cus_adaptr.Fill(ds, "Customer");<br />
new OleDbCommandBuilder(cus_adaptr);	<br />
DataTable customer = ds.Tables["Customer"];<br />
<br />
addr_adaptr.SelectCommand = cn.CreateCommand();<br />
addr_adaptr.SelectCommand.CommandText = "Select * from Address";<br />
addr_adaptr.MissingSchemaAction = MissingSchemaAction.AddWithKey;<br />
addr_adaptr.Fill(ds, "Address");<br />
new OleDbCommandBuilder(addr_adaptr);<br />
DataTable address = ds.Tables["Address"];<br />
<br />
DataRelation cus_addr = new DataRelation("cus_addr",customer.Columns["cus_id"], address.Columns["cus_id"]);			<br />
ds.Relations.Add(cus_addr);<br />

Then I defined a function to store the changes made in the dataset.

<br />
public static void save_to_database(string table)<br />
{<br />
    System.Data.OleDb.OleDbDataAdapter <br />
	dbAdaptr = new OleDbDataAdapter("Select * from "+table, cn);<br />
    new OleDbCommandBuilder(dbAdaptr);<br />
    DataTable atable = ds.Tables[table].GetChanges();<br />
    int i = main_form.ds.Tables["Customer"].Rows.Count;<br />
    try <br />
    {<br />
	dbAdaptr.Update(ds, table);				<br />
    } 			<br />
    catch (Exception er)<br />
    {<br />
	MessageBox.Show("Cannot update invoice.mdb! " + er.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Stop);<br />
    }<br />
    ds.Tables[table].AcceptChanges();<br />
}<br />

When I delete a customer record from the customer table then save it as:
save_to_database("Customer");
save_to_database("Address");
An error happens when save the address table which says:
"Concurrency Violation: the delete command affected 0 records." Does anybody know how to avoid this happen?
Also I can loop a field in address table if I delete any record, it says "can't access the deleted rows." Does anybody know how to bypass the deleted row so I still can loop the rows which are not deleted?

Thanks in advance

Asura

Sql Paraments C#

| Muhammad Waqas Butt |4-Aug-05 21:39

| Muhammad Waqas Butt |

4-Aug-05 21:39

Please tell how we can give Parameters in sqladapter.

this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param2", System.Data.SqlDbType.NVarChar, 18, "Press_job_order"));

sqlDataAdapter1.Fill(dataSet11);
where i give paramenter @Param2 value and how.

J4amieC4-Aug-05 22:14

J4amieC

4-Aug-05 22:14

Couple of ways.

1) Create the param first

SqlParameter pressJobOrderParam = new SqlParameter("@Param2", SqlDbType.NVarChar, 18, "Press_job_order");<br />
pressJobOrderParam.Value = 123;<br />
this.sqlSelectCommand1.Parameters.Add(pressJobOrderParam);

2) Add the param, as you did, then refer to it by name.

this.sqlSelectCommand1.Parameters.Add(new SqlParameter("@Param2", SqlDbType.NVarChar, 18, "Press_job_order"));<br />
this.sqlSelectCommand1.Parameters["@Param2"].Value = 123;

| Muhammad Waqas Butt |4-Aug-05 22:32

| Muhammad Waqas Butt |

4-Aug-05 22:32

Thanks for Help?

Do you have any idea about crystal report field hide and show. And date format in crystal i select date field from sql database i need to store date in dd/MMMM/yyyy format and also show in crystal report in this format. Any Idea?

....Thank again.

J4amieC4-Aug-05 23:44

J4amieC

4-Aug-05 23:44

if "myDate" is of type DateTime i think to format it you use

myDate.ToString("dd/MMMM/yyyy");

Guffa4-Aug-05 23:55

4-Aug-05 23:55

The Add method returns a reference to the parameter, so you can set it's value.

this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param2", System.Data.SqlDbType.NVarChar, 18, "Press_job_order")).Value = "42";

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