C# Discussion Boards - CodeProject

First Prev Next

Re: About Combobox's ValueMember and DisplayMember

CKnig5-Dec-07 20:13

CKnig

5-Dec-07 20:13

This is very easy in your example: just add a property - let's say

<br />
public string DisplayValue<br />
{ get { return Name + ", " + Number; } }<br />

to your PhoneContact class and use

<br />
combobox1.DisplayMember="DisplayValue";<br />

that's it.

Re: About Combobox's ValueMember and DisplayMember

Zerox MXI5-Dec-07 20:23

Zerox MXI

5-Dec-07 20:23

Yes I've tried that myself,

the only catch is that after you have selected one of values in that concatenated form from the drop down list, the textbox field is populated with "Name, Number", where what I would liked was just the number itself in the textbox field.

Eventually, what I need is just the number value where for some reason can't just get from SelectedValue property.

In a case where no number exists in the drop down list, SelectedValue property will be null or empty if some other number was entered into the textbox field of the combobox.

string number = string.Empty;

If (combobox1.SelectedValue == null)
number = combobox1.Text;
else
number = combobox1.SelectedValue.ToString();

And that's exactly why after the selection from the drop down list, I only want a number and not the concatenated string of "Name, Number" to be in the number variable.

Re: About Combobox's ValueMember and DisplayMember

CKnig5-Dec-07 23:30

CKnig

5-Dec-07 23:30

then use

<br />
number = combobox1.Text.Substring(0,combobox1.Text.IndexOf(','));<br />

in the case where SelectedValue == null !

Re: About Combobox's ValueMember and DisplayMember

Zerox MXI6-Dec-07 3:10

Zerox MXI

6-Dec-07 3:10

Hmmm... never thought of that... I appreciate this... thanks a million.

how to export datagridview contents to excel

Nitin Raj5-Dec-07 19:56

Nitin Raj

5-Dec-07 19:56

I have to export the data present in the datagridview to Microsoft Excel. It is a window application using c#. Does anyone know how to do it. Please help.

Thanks

Re: how to export datagridview contents to excel

DKalepu5-Dec-07 22:49

DKalepu

5-Dec-07 22:49

Hi,

you can go through this link

http://nishantpant.wordpress.com/2006/11/02/exporting-data-to-excel-from-a-windows-forms-net-application/[^]

Regards.

Strength is life, Weakness is death.

--- Swami vivekananda

How To : coerce a ref to an enum into a ref to an int.

urbane.tiger5-Dec-07 18:59

urbane.tiger

5-Dec-07 18:59

I have a method in a common base class thus :

protected bool SetFlag(bool _new, ref int _flags, int _flag, string _pName)
{
bool __cancelled = false;
bool __old = ((_flags & _flag) == _flag);
if (!__old.Equals(_new)
{
if (!(__cancelled = this.RaisePropertyChanging(__old, _new, pName)))
{
_flags = (_new) ? _flags | _flag : _flags & ~flag;
this.RaisePropertyChanged(__old, _new, pName);
}
}
return __cancelled;
}

In derivatives of the common base I want to use SetFlags as is shown in the example at the end of this post, but I get a message telling me that it can't cast a ref to an AmbientState to an int etc.

If I give SetFlag a Type argument then I can only constrain it to a class(reference type) or struct(value type), but in that case I get compile errors stating that bitwise operations cannot be performed on T objects, ie structs.

The content of _flags (ambientState in the example) must be changed BEFORE PropertyChanged handlers are invoked.

I have a work-around - The _flags parameter is not passed by reference and I've added a delegate method argument to SetFlag that gets invoked between the "flags = ...." and the "this.RaisePropertyChanged...." statements, the delegate looks like

private void saveFlags(int _flags) { this.ambientState = (AmbientState) _flags; )

But like all workarounds its ugly and necessitates documenting why the delegate exists etc.

Rgds PhilD -- Sample usage of SetFlags follows

public class MyClass : CommonBase
{
AmbientState ambientState = AmbientState.ZeroValue;

public bool Morning
{
get { return ((this.ambientState & AmbientState.Morning) == AmbientState.Morning); }
set { this.SetFlag(value, (int) ref this.ambientState, AmbientState.Morning, "Morning"; }
}
[Flags]
private enum AmbientState : int
{
ZeroValue = 0x0

Morning = 0x1
Afternoon = 0x2
Evening = 0x4
Night = 0x8

ClearSky = 0x10
CirrusSky = 0x02
etc
}
}

Re: How To : coerce a ref to an enum into a ref to an int.

Skippums6-Dec-07 10:39

Skippums

6-Dec-07 10:39

The most obvious solution is to set an int value, call the method with a ref to that value, then reset it to the ambientState property, as follows:

public bool Morning {
    get { ... }
    set {
        int as = (int)this.ambientState;
        this.SetFlag(value, ref as, ...);
        this.ambientState = (AmbientState)as;
    }
}

Another solution I see is doing the reverse, which is probably better, since you cut down on the responsibility of the user, and to impede type checking for your enum type. Do this as follows:

protected bool SetFlag(bool _new, ref AmbientState _flags, AmbientState _flag, string _pName)
{
    int flag = (int)_flag;
    int flags = (int)_flags;
    bool __cancelled = false;
    bool __old = ((flags & flag) == flag);
    if (!__old.Equals(_new)
    {
        if (!(__cancelled = this.RaisePropertyChanging(__old, _new, pName)))   
        {
            flags = (_new) ? flags | flag : flags & ~flag;
            this.RaisePropertyChanged(__old, _new, pName);
            _flags = (AmbientState)flags;
        }
    }
    return __cancelled;
}

And finally, the RECOMMENDED way of doing this, is setting the FlagsAttribute on the enumeration as follows:

[FlagsAttribute]
public enum AmbientState {
    ...
}

This final way allows you to use &, |, and ^ on the values of the enumeration. I'm not sure if you can use ~, but you can always go to find out! Hope this helps,

-Jeff

[Message Deleted]

rockz...5-Dec-07 18:52

rockz...

5-Dec-07 18:52

[Message Deleted]

Re: Serial No. for rows in datagrid

Sathesh Sakthivel5-Dec-07 19:00

Sathesh Sakthivel

5-Dec-07 19:00

Hi you have some options.
1) use the fields in your datagrid. Attention, this method might be slow.
Just itterate throug your rows:

<br />
<br />
<br />
foreach (DataGridViewRow row in settingDataGridView.Rows)<br />
<br />
            { <br />
                runningtotal += decimal.Parse(row.Cells[columnIndex].ToString();<br />
            }<br />

2) get the data from the data behind the DataGridView

<br />
documentlinebindingsource.EndEdit();<br />
<br />
foreach (DataRow row in ds.DocumentLine.Select("documentId=" + documentId))<br />
<br />
     {<br />
<br />
    if (row.RowState != DataRowState.Deleted)<br />
<br />
             {<br />
                 ds.DocumentLineRow docLineRow = (ds.DocumentLineRow)row;<br />
<br />
...<br />
runningtotal += row.documentLineTotal;<br />
<br />
}<br />
<br />
}<br />
<br />

Hope this will help you.

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

Re: Serial No. for rows in datagrid

dan!sh 5-Dec-07 19:28

dan!sh

5-Dec-07 19:28

You can add a column to your datatable with autoincrement property set to true.This would give you serial number.I haven't tested it but it might work.

Until you realize this message has nothing to say, its too late to stop reading

how to populate a single column from a table to a datagridview

kssknov5-Dec-07 18:46

kssknov

5-Dec-07 18:46

hi i am a beginner!

I need to know how to populate a single column from a table to a datagridview.

my code is

DataSet Ds=new Dataset()
........//here i retrived data from table and filled the dataset with data adapter.
da.fill(ds);
DatGridVw1.DataSource = ds;
DatGridVw1.DataBindings();

suggest me!
thanks in advance

kssk

Re: how to populate a single column from a table to a datagridview

Sathesh Sakthivel5-Dec-07 18:55

Sathesh Sakthivel

5-Dec-07 18:55

The Databind is a method for the gridview for Asp .Net and databindings is to assign data to a control (this is usually a field value)
So remove the databindings line.

Are you sure that your dataset is getting populated?

Try running into debug mode and check the contents of your dataset before you set the data source of the gridview.

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

Re: how to populate a single column from a table to a datagridview

kssknov5-Dec-07 19:06

kssknov

5-Dec-07 19:06

ya i checked my dataset, its populated.

but datagridview is empty

kssk

Re: how to populate a single column from a table to a datagridview

I.explore.code5-Dec-07 23:49

I.explore.code

5-Dec-07 23:49

hi ,

if i may ask, what code your are writing for retrieval ?

if ur dataset is getting populated, then use : DataGridVw1.DataSource=ds.Tables[0];
and remove the data bindings line. and then check ?

Print data from webbrowser used on windows form

D i x y5-Dec-07 18:09

D i x y

5-Dec-07 18:09

Printing data in C#.NET from webbrowser used on windows form.
No other data will be printed except webbrowser

Java script using windows form

Satish - Developer5-Dec-07 17:53

Satish - Developer

5-Dec-07 17:53

Hi, I have requirement like this..

I have one windows form which contains datagrid which displays the data.
And another button is there outside of grid in winform. If i click on button, the datagrid has to be printed...

so, i need to call window.print() in button click..
Ho can i call javascript in button click.

Thanks in advance

Re: Java script using windows form

Sathesh Sakthivel5-Dec-07 17:58

Sathesh Sakthivel

5-Dec-07 17:58

I have also faced the same situation i solved this by calling
Page_ClientValidate() function before printing. Don't directly call
window.print() instead

<br />
<br />
private void Page_Load(object sender, System.EventArgs e)<br />
{<br />
StringBuilder myScript = new StringBuilder();<br />
<br />
myScript.Append("<script language='Javascript'>");<br />
myScript.Append(" function PrintForm(){");<br />
myScript.Append(" if (Page_ClientValidate()){");<br />
myScript.Append(" window.print();}");<br />
myScript.Append("}");<br />
myScript.Append("</script>");<br />
<br />
this.RegisterStartupScript("MyScript", myScript.ToString());<br />
<br />
Button2.Attributes.Add("onclick","javascript:PrintForm();");<br />
}<br />
<br />

this should help.

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

Re: Java script using windows form

Satish - Developer5-Dec-07 18:09

Satish - Developer

5-Dec-07 18:09

My Requirement is in Windows form..not in webform.

In windows, we dont have Page_load , REgisterclientscriptblock etc..

Can u suggest me regarding windows form..

Re: Java script using windows form

Sun Rays5-Dec-07 18:36

Sun Rays

5-Dec-07 18:36

Hi,
you can check this...

Link1[^]

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

A tiny issue with ".NET Snap To Screen Form"

EEssam5-Dec-07 17:48

EEssam

5-Dec-07 17:48

Hi,

The code here is working very good when the ForBorderStyle is NOT set to "None":

http://www.codeproject.com/KB/vb/SnapForm.aspx

In my application, it's set to None... And I move the form by holding down the right mouse button and moving it. The code still partially work, but when I approach the taskbar from the clock side it's not completely sticked to the corners.

I tried to figure out what wrong with code but no luck (and no experience).

The complete code is attached. Just create a new project and paste it.

Your help would be greatly appreciated.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Runtime.InteropServices;

namespace WindowsFormsApplication11
{
public partial class Form1 : Form
{
public const int WM_NCLBUTTONDOWN = 0xA1;
public const int HT_CAPTION = 0x2;

[DllImportAttribute("user32.dll")]
public static extern int SendMessage(IntPtr hWnd,
int Msg, int wParam, int lParam);
[DllImportAttribute("user32.dll")]
public static extern bool ReleaseCapture();

public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{

}

# region SnapToDesktopBorder

private const int mSnapOffset = 35;
private const int WM_WINDOWPOSCHANGING = 70;

[StructLayout(LayoutKind.Sequential)]
public struct WINDOWPOS
{
public IntPtr hwnd;
public IntPtr hwndInsertAfter;
public int x;
public int y;
public int cx;
public int cy;
public int flags;
}

protected override void WndProc(ref Message m)
{
// Listen for operating system messages
switch (m.Msg)
{
case WM_WINDOWPOSCHANGING:
{
SnapToDesktopBorder(this, m.LParam, 0);
}
break;
}

base.WndProc(ref m);
}

public static void SnapToDesktopBorder(Form clientForm, IntPtr LParam, int widthAdjustment)
{
if (clientForm == null)
{
// Satisfies rule: Validate parameters
throw new ArgumentNullException("clientForm");
}

// Snap client to the top, left, bottom or right desktop border
// as the form is moved near that border.

try
{
// Marshal the LPARAM value which is a WINDOWPOS struct
WINDOWPOS NewPosition = new WINDOWPOS();
NewPosition = (WINDOWPOS)System.Runtime.InteropServices.Marshal.PtrToStructure(LParam, typeof(WINDOWPOS));

if (NewPosition.y == 0 || NewPosition.x == 0)
{
return;
// Nothing to do!
}

// Adjust the client size for borders and caption bar
Rectangle ClientRect = clientForm.RectangleToScreen(clientForm.ClientRectangle);
ClientRect.Width += SystemInformation.FrameBorderSize.Width - widthAdjustment;
ClientRect.Height += (SystemInformation.FrameBorderSize.Height + SystemInformation.CaptionHeight);

// Now get the screen working area (without taskbar)
Rectangle WorkingRect = Screen.GetWorkingArea(clientForm.ClientRectangle);

// Left border
if (NewPosition.x >= WorkingRect.X - mSnapOffset && NewPosition.x <= WorkingRect.X + mSnapOffset)
{
NewPosition.x = WorkingRect.X;
}

// Get screen bounds and taskbar height
// (when taskbar is horizontal)
Rectangle ScreenRect = Screen.GetBounds(Screen.PrimaryScreen.Bounds);
int TaskbarHeight = ScreenRect.Height - WorkingRect.Height;

// Top border (check if taskbar is on top
// or bottom via WorkingRect.Y)
if (NewPosition.y >= -mSnapOffset && (WorkingRect.Y > 0 && NewPosition.y <= (TaskbarHeight + mSnapOffset)) || (WorkingRect.Y <= 0 && NewPosition.y <= (mSnapOffset)))
{
if (TaskbarHeight > 0)
{
NewPosition.y = WorkingRect.Y;
// Horizontal Taskbar
}
else
{
NewPosition.y = 0;
// Vertical Taskbar
}
}

// Right border
if (NewPosition.x + ClientRect.Width <= WorkingRect.Right + mSnapOffset && NewPosition.x + ClientRect.Width >= WorkingRect.Right - mSnapOffset)
{
NewPosition.x = WorkingRect.Right - (ClientRect.Width + SystemInformation.FrameBorderSize.Width);
}

// Bottom border
if (NewPosition.y + ClientRect.Height <= WorkingRect.Bottom + mSnapOffset && NewPosition.y + ClientRect.Height >= WorkingRect.Bottom - mSnapOffset)
{
NewPosition.y = WorkingRect.Bottom - (ClientRect.Height + SystemInformation.FrameBorderSize.Height);
}

// Marshal it back
System.Runtime.InteropServices.Marshal.StructureToPtr(NewPosition, LParam, true);
}
catch (ArgumentException ex)
{
}
}

# endregion

private void Form1_MouseMove(object sender, MouseEventArgs e)
{
if (e.Button == MouseButtons.Left)
{
ReleaseCapture();
SendMessage(Handle, WM_NCLBUTTONDOWN, HT_CAPTION, 0);
}
}
}
}

Is it possible to record the voice from phone using tapi with C#.Net ?

Gopal.S5-Dec-07 17:28

Gopal.S

5-Dec-07 17:28