C# Discussion Boards - CodeProject

falles0122-Nov-07 12:06

22-Nov-07 12:06

Adelaide. Not really close to brisbane at all. The opposite side of Australia actually.

falles0122-Nov-07 14:03

22-Nov-07 14:03

You mean concatenate the skills into one field using sql? How do you do that? My sql statement gets all the correct skills but how do you get it into one field? wouldn't I need some c# code for that?

Vikram A Punathambekar22-Nov-07 15:25

Vikram A Punathambekar

22-Nov-07 15:25

Without seeing your code, there's no way I can tell you how to do it. Perhaps you should google for this stuff, it's fairly simple.

Tip: You need to add a new DataColumn that will contain the skills to your DataTable.

Cheers,
विक्रम

And sleep will come, it comes to us all
And some will fade and some will fall

falles0122-Nov-07 16:25

22-Nov-07 16:25

Thanks. I never ask a question on a forum unless I hae thoroughly searched google and haven't found anything or I don't know what I'm searching for, hence the question.

In regards to your tip, I already have a skills column which works fine but just displays each new skills in a new row. Do you mean create another column for skills?

falles0122-Nov-07 18:54

How can I select a whole when I click on CheckBox in DataGridView?

22-Nov-07 18:54

Sorry but I'll give you my code so oyu can see what I currently do.

string sql = "bla bla ";<br />
<br />
SqlDataAdapter myCommand = new SqlDataAdapter(sql, myConnection);<br />
<br />
 //Create dataset and fill it with employee data<br />
  DataSet ds = new DataSet();<br />
  myCommand.Fill(ds);<br />
//bind employee data to datagrid <br />
DataView Source = ds.Tables[0].DefaultView;<br />
 Source.Sort = sortField;<br />
 dgSearchResults.DataSource = ds.Tables[0];<br />

After this would I then create a new datacolumn?
I found this link. Is it something like that? and then I have to concatenate string somehow? Smile | :)

http://msdn2.microsoft.com/en-US/library/system.data.datacolumn.aspx">http://msdn2.microsoft.com/en-US/library/system.data.datacolumn.aspx

T4AMD21-Nov-07 13:56

T4AMD

21-Nov-07 13:56

I added a CheckBox column to my DataGridView and here is the code:
private void Form1_Load(object sender, EventArgs e)
{
try
{
SqlDataAdapter DataAdapter1 = new SqlDataAdapter("select EmployeeID,LastName,FirstName from Employees", dbProfiles);
DataTable DataTable1 = new DataTable();

DataAdapter1.Fill(DataTable1);
dgvResults.DataSource = DataTable1;
//dgvResults.DataBindings.Add(DataTable1);
DataGridViewCheckBoxColumn col = new DataGridViewCheckBoxColumn();
col.Name = "Column1";
dgvResults.Columns.Add(col);
}

catch (Exception ex)
{
MessageBox.Show("Error");
this.Close();
}
}

How should I edit this code inorder to select the whole row using the CheckBox?

Re: How can I select a whole when I click on CheckBox in DataGridView?

Michael Sync21-Nov-07 15:51

Michael Sync

21-Nov-07 15:51

Have you tried "FullRowSelect" property?

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."

Delete Key Trapping?

jasper01821-Nov-07 13:16

jasper018

21-Nov-07 13:16

Hello I have a data grid view and when I press the delete key, even though I have a message box to confirm the delete, the delete happens either way. Any ideas on trapping the delete key?

thanks j

private void dataGridView_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e)
{
DialogResult yn = MessageBox.Show("Are you sure you want to delete this row?", "DataGridView Delete", MessageBoxButtons.YesNo);

if (yn == DialogResult.Yes)
{

}
if (yn == DialogResult.No)
{
MessageBox.Show("record was not deleted");
}

}

Re: Delete Key Trapping?

Anthony Mushrow21-Nov-07 14:28

Anthony Mushrow

21-Nov-07 14:28

Just use the KeyDown event for your datatgrid. The keydown event gets fired before the control knows about a key being pressed.

Then you can check if the key pressed was the delete key, and then if you want to cancel the delete, set e.Handled to true.

My current favourite word is: PIE!

Good ol' pie, it's been a while.

Re: Delete Key Trapping?

jasper01827-Nov-07 4:04

jasper018

27-Nov-07 4:04

Thanks I am going to give that a try!

J

C# Modules/Plugins loaded dynamically - UserControl or others

Fabricio Miranda21-Nov-07 12:43

Fabricio Miranda

21-Nov-07 12:43

Hello all,
im having a bit of a big problem with some modules/plugins that i want to add to my c# project on VS2005...

Im trying to load a UserControl from another assembly loaded by the /bin folder of my .NET application.
Iv found some methods but none of them worked !
Im looking for a way to load a form, or a UserControl because it can became another sub-application to my main application, but i want to load it dynnamicly, so i can just copy/past another module/plugin and the program will recognize it automatically...

So UserControl seems a good choice, it can have controls and i can code freely inside of it, all i have to do is to add it to my main page and i have a sub-application inside my main one.

SO!

how can i do that??!?!
is there another way better than UserControl ?

remembering that i DO NOT want the fixed name of my control "mycontrol.ascx".. i just want to PASTE my assembly on my bin folder and load it...

i was able to find the assembly, find the Type of my usercontrol but when i try to load it with:
Activator.CreateInstance(theType);
it doesnt work.... it loads, but no control is visible when i call add() ...

but!

if i could just get the filename of my Type ( of my ascx class inside the Assembly ) i could just do it using:
UserControl uc = (UserControl)LoadControl(controlPath);
PlaceHolder1.Controls.Add(uc);

and done! ... but i wasnt able to find the filename of the ".ascx" file...

so, im stuck.... Hmmm | :|

anyone can help me? Confused | :confused:

thanks!

GReed

DirectInput / XInput Articles

MasterSharp21-Nov-07 11:50

MasterSharp

21-Nov-07 11:50

Does anyone know any really good DirectX / XInput articles or sites, anything? Thanks.

- "Achieving all knowledge does not mean achieving all wisdom." some wise dude

- I love D-flat!

Show proccess window

Scalee21-Nov-07 10:20

Scalee

21-Nov-07 10:20

Im trying to open a minimized window,
How would i do this?

I tryed sendmessage(handle, 0x0112, ** , 0)

** = WM_SHOWWINDOW and WM_SETFOCUS both didnt work.

Help please.

Re: Show proccess window

Mark Greenwood21-Nov-07 10:33

Mark Greenwood

21-Nov-07 10:33

On my wrong computer right now so don't have access to MSDN - but try WM_RESTOREWINDOW(or whatever it's called) or WM_MAXIMIZE - essentially Show Window is used when the window is hidden (different from minimized), and set focus just set's the focus, it won't restore it from it's minimized position.

Re: Show proccess window

Skippums21-Nov-07 11:07

Skippums

21-Nov-07 11:07

[DllImport("user32.dll")]
private static extern bool ShowWindow(IntPtr winHandle, uint op);

public enum SW : uint {
  HIDE            = 0,
  SHOWNORMAL      = 1,
  NORMAL          = 1,
  SHOWMINIMIZED   = 2,
  SHOWMAXIMIZED   = 3,
  MAXIMIZE        = 3,
  SHOWNOACTIVATE  = 4,
  SHOW            = 5,
  MINIMIZE        = 6,
  SHOWMINNOACTIVE = 7,
  SHOWNA          = 8,
  RESTORE         = 9,
  SHOWDEFAULT     = 10,
  FORCEMINIMIZE   = 11
}

...
ShowWindow(handle, (uint)SW.SHOW);
...

Jeff

Re: Show proccess window

Scalee22-Nov-07 12:00

Scalee

22-Nov-07 12:00

Thanks!
Works perfectly!

textbox(es)

Assaf8221-Nov-07 9:48

Assaf82

21-Nov-07 9:48

Hello
I have a form where there is plenty of textbox after sving the data
I want to empty all these textbox.
how I can do that by foreach statment

or if any one have another idea, will be greatly appreciated
instead of empty each one alone

thanks in advance

Assaf

Re: textbox(es)

J$21-Nov-07 9:58

21-Nov-07 9:58

In your form you could do something like:

foreach (Control control in this.Controls)
{
    if (control is TextBox)
       control.Text = string.Empty;
}

Re: textbox(es)

Giorgi Dalakishvili21-Nov-07 10:04

Giorgi Dalakishvili

21-Nov-07 10:04

<br />
foreach (Control c in this.controls)<br />
{<br />
    if (c is TextBox)<br />
        c.Text="";<br />
}<br />

#region signature
my articles
#endregion

Re: textbox(es)

Anthony Mushrow21-Nov-07 10:12

Anthony Mushrow

21-Nov-07 10:12

foreach (Control c in this.Controls)
{
    if (c is TextBox)
    c.Text = new string('0', 0);
}

Sorry

My current favourite word is: PIE!

Good ol' pie, it's been a while.

pass value from sub form to parent form

madEG21-Nov-07 8:32

madEG

21-Nov-07 8:32

Sigh. I feel like such a newb.

Ok, as the subject suggests I have a parent form that passes two values to a sub form. I want to edit the values on the sub form, and pass these updated values back to the parent form.

I can get the values to the sub form, but not back to the parent form... I just can't figure out how to make this happen. I get two errors:

Error 1 An object reference is required for the nonstatic field, method, or property 'WindowsApplication7.Form2.stAptUnitNum'

Error 2 An object reference is required for the nonstatic field, method, or property 'WindowsApplication7.Form2.stAddress'

I presume this means I am a rookie, er, I mean that I am doing something fundementally wrong, because to be honest even after googling this problem for over an hour I can't find an explanation that I understand. I thought making the two variables public on form2 would allow me to get their value when back to form1, but perhaps not.

On the main form:

<br />
private void fxn_reevaluate()<br />
        {<br />
            // check text box address1 and address2 for length and continue on submit<br />
            Form2 frm = new Form2(stAptUnitNum, stAddress);<br />
            frm.ShowDialog();<br />
            stAptUnitNum = Form2.stAptUnitNum;  // error1 here...<br />
            stAddress = Form2.stAddress;   // error2 here...<br />
        }

which then calls the sub form...

<br />
public Form2(string Address1, string Address2)<br />
        {<br />
            InitializeComponent();<br />
            textBoxAddr1.Text = Address1;<br />
            textBoxAddr2.Text = Address2;<br />
        }<br />
<br />
public string stAptUnitNum;<br />
public string stAddress;<br />
<br />
private void btnSubmit_Click(object sender, EventArgs e)<br />
        {<br />
                // set the variables to be picked up by the parent form after the window closes.<br />
                stAptUnitNum = textBoxAddr1.Text.Trim();<br />
                stAddress = textBoxAddr2.Text.Trim();<br />
                this.Close();<br />
        }<br />

Any help would be greatly appreciated.

Thanks!
-Matt G.

Kristian Sixhøj21-Nov-07 8:37

Kristian Sixhøj

21-Nov-07 8:37

Perhaps this article could help you:

http://www.codeproject.com/dotnet/passingvaluesbetweenforms.asp[^]

Kristian Sixhoej

"Failure is not an option" - Gene Kranz

madEG21-Nov-07 8:47

madEG

21-Nov-07 8:47

You know, I really did read this article, and unless I am overlooking something, or failing to infer something, all I see here is pass value from parent to child (which I thankfully have working), update child from parent when child form is open (cool, but I am not there yet...) and passing values from children to child (sibling to sibling).

Am I overlooking something that shows how to get a value back from a child to the parent?

Thanks!
-Matt G.

[edited for spelling...]

Kristian Sixhøj21-Nov-07 8:58

Kristian Sixhøj

21-Nov-07 8:58

Yes, read the 'Sibling to Sibling' chapter.
"... This also demonstrates passing between the child and the parent."

Kristian Sixhoej

"Failure is not an option" - Gene Kranz