Re: Datagridview - C# Discussion Boards

Re: can not load mscorwks.dll?

9-Jul-08 1:31

Sounds like .NET is not installed, or in your PATH.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

George_George9-Jul-08 22:00

George_George

9-Jul-08 22:00

Thanks leppie,

.Net is installed. Do you mean the %PATH% when you say "in your PATH"? If yes, could you post your %PATH% please? I want to check whether mine is correct by comparing with a correct one.

(BTW: if not using Windbg, my C# application can run without any issues, so I do not think it is PATH issue, anyway, it is good to check the PATH with you to learn something more.)

regards,
George

Datagridview

benjamin yap8-Jul-08 23:48

benjamin yap

8-Jul-08 23:48

Hi, i got a datagridview and the column ID 6 is a column which shows the price and columnID 0 have a checkbox.

How do i calculate the price when the check box is ticked or unticked.

I tried at a timer with interval of 1 second to check

private void timeCountPrice_Tick(object sender, EventArgs e)
{
    double price = 0.0;
    foreach (DataGridViewRow dgw in dataGridProduct.Rows)
    {
        DataGridViewCheckBoxCell datacell = dgw.Cells[0] as DataGridViewCheckBoxCell;

        try
        {
            if ((bool)datacell.Value == true)
            {

                price += Convert.ToDouble(dgw.Cells[6].Value.ToString());
                lblTotalPrice.Text = "Total Price : $ " + price;
            }
        }
        catch (Exception exc)
        {
        }
    }
}

But it dont seems to work

leppie9-Jul-08 0:07

9-Jul-08 0:07

benjamin yap wrote:
But it dont seems to work

What does not work?

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

benjamin yap9-Jul-08 0:34

benjamin yap

9-Jul-08 0:34

When i tick the checkbox in first column of datagrid, the lblTotalPrice does not update.

And also i want it when its being untick, it will minus the value from totalprice

benjymous9-Jul-08 1:30

benjymous

9-Jul-08 1:30

You could subscribe to the DataGridView's CellClick event, so that you know when a cell's actually been clicked. Inside the handler you get told the row and column so you can work out if it's a checkbox cell, then update your totals accordingly.

--
Help me! I'm turning into a grapefruit!
Buzzwords!

benjamin yap9-Jul-08 2:02

benjamin yap

9-Jul-08 2:02

Okay, 1 more question

I have a form called ModifyOrder. Basically my form have 2 hashtable. I called orderTable and the other is productTable.

My orderTable stores an Order object. Below is my class for Order.cs

namespace EBMS
{
    public class Order
    {
        private string refNumber;
        private string custName;
        private string destAdd;
        private string destCity;
        private string orderDate;
        private double totalPrice;
        private Hashtable itemList;

I got a attribute which store a list of items( from the productTable) into a hashtable called itemList inside my Order class

I have a datagridview which shows all the record i have in my productTable and the first columm of the datagrid is a checkbox.

When the user enter the Order's Ref Number to be modify, the datagrid wil show all the productTable. I want the first column(checkbox) to be checked if the product exists inside the Order class itemList.

How do i go about it?

I tried this code, but it does not tick the checkbox

if (orderTable.ContainsKey(tbxSearchRefNum.Text))
{
    tbxRefNumber.Text = ((Order)orderTable[tbxSearchRefNum.Text]).RefNumber;
    tbxCustName.Text = ((Order)orderTable[tbxSearchRefNum.Text]).CustName;
    tbxCity.Text = ((Order)orderTable[tbxSearchRefNum.Text]).DestCity;
    tbxAddress.Text = ((Order)orderTable[tbxSearchRefNum.Text]).DestAdd;

    this.dataGridProduct.Rows.Clear();
    int currentRow = 0;
    foreach (Product p in productTable.Values)
    {
        this.dataGridProduct.Rows.Add();
        this.dataGridProduct.Rows[currentRow].Cells["colProductName"].Value = p.Name;
        this.dataGridProduct.Rows[currentRow].Cells["colModelNumber"].Value = p.ModelNumber;
        this.dataGridProduct.Rows[currentRow].Cells["colCategory"].Value = p.Category;
        this.dataGridProduct.Rows[currentRow].Cells["colDesc"].Value = p.Description;
        this.dataGridProduct.Rows[currentRow].Cells["colMSRP"].Value = p.MSRP;
        this.dataGridProduct.Rows[currentRow].Cells["colRetailPrice"].Value = p.RetailPrice;

        foreach (DataGridViewRow dgw in dataGridProduct.Rows)
        {
            DataGridViewCheckBoxCell datacell = dgw.Cells[0] as DataGridViewCheckBoxCell;
            try
            {
                Order newOrder = new Order();
                newOrder = (Order)orderTable[tbxRefNumber.Text];
                uint modelNumber = Convert.ToUInt32(newOrder.ItemList[p.ModelNumber]);

                if (dgw.Cells[2].Value.ToString() == Convert.ToString(modelNumber))
                {
                    this.dataGridProduct.Rows[currentRow].Cells["colSelect"].Value = true;
                }

            }
            catch (Exception exc)
            {
            }
        }
        //MessageBox.Show(dataGridProduct.Rows[currentRow].Cells["colSelect"].Value.ToString());
        currentRow++;
    }

}

Grid Combo Un-Select

Syed Shahid Hussain8-Jul-08 23:36

Syed Shahid Hussain

8-Jul-08 23:36

hi,

how to de select grid combo when value is selected in combo.

thanks

Syed Shahid Hussain

Combobox problem

Vibin Venugopal8-Jul-08 23:30

Vibin Venugopal

8-Jul-08 23:30

HI,
Am trying to retreive some data into the Visual Studio C#.net (Winforms) combobox from a access database, but when i run it, i get only the first record, Please help me out.

Thanks

Vibin

private void Form2_Load(object sender, System.EventArgs e)
{
int count=0, b=0;
try
{
con=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\\JET PRINT LIMITED\\JET PRINT LIMITED.mdb");
da=new OleDbDataAdapter("select * from STOCKDET",con);
con.Open();
ds=new DataSet();
da.Fill(ds,"STOCKDET");

comm.Connection=con;
comm.CommandType=CommandType.Text;

da=new OleDbDataAdapter(comm);
dr=ds.Tables [0].Rows [b];
comboBox1.Items.Add (dr[1].ToString());

MessageBox.Show("data into Combobox successfuly!!!");

MessageBox.Show("Connected successfuly!!!");

}
catch(Exception k)
{
MessageBox.Show(k.Message);
}
}

Gareth H8-Jul-08 23:52

Gareth H

8-Jul-08 23:52

You are always returning the first row...

int count=0, b=0;
dr=ds.Tables[0].Rows[b];
comboBox1.Items.Add (dr[1].ToString());

Regards,
Gareth.

(FKA gareth111)

Vibin Venugopal9-Jul-08 0:55

Vibin Venugopal

9-Jul-08 0:55

Thanks for the reply
Please guide me on what i should include to get all the data in that particular column.

Kjetil Svendsen9-Jul-08 2:34

Kjetil Svendsen

9-Jul-08 2:34

Hi.

You should databind:

Combobox1.DataSource = ds.Tables[0];
Combobox1.DisplayMember = "Column name for column to display";
Combobox1.ValueMember = "Column name for ID column";

Kjetil

How to detect all usb device removal?

Vimalsoft(Pty) Ltd9-Jul-08 3:02

Vimalsoft(Pty) Ltd

9-Jul-08 3:02

firstly you are using a reader with a dataset and that confuses more.
if you want to retrieve what is in the command object and in future you won't manipulate the data, you should use only a datareader.so you have combined dataset and a datareader. your code above can be written like this

OleDbConnection con=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\\JET PRINT LIMITED\\JET PRINT LIMITED.mdb");
OleDbDataReader dr; 
OleDbCommand comm = new SqlCommand(); 
comm.Connection=con;
comm.CommandType=CommandType.Text;
comm.CommandText = "select * from STOCKDET";

con.Open();
 
dr=comm.ExecuteReader();

con.Close();

comboBox1.Datasource=dr;

MessageBox.Show("data into Combobox successfuly!!!");

MessageBox.Show("Connected successfuly!!!");

Hope it helps

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

lovnin8-Jul-08 23:12

lovnin

8-Jul-08 23:12

I'm trying to make a program what can let me know when a USB device is removed from a system. If anyone has any ideas or help that would be
great!

Thanks in advnace,

Virtual memory problem

B!Z8-Jul-08 22:25

B!Z

8-Jul-08 22:25

hello

I m getting an error "Virtual memory is to low"; while running my real-time application that is developed in C#.In our application, we are capturing the Live video and transmitting on LAN as well. IS IT ANY hARDWARE PROBLEM

B!z

Re: Virtual memory problem

leppie8-Jul-08 22:35

Re: Virtual memory problem

8-Jul-08 22:35

B!Z wrote:
IS IT ANY hARDWARE PROBLEM

No, your application is probably causing a memory leak. Monitor it with Process Explorer.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

S. Senthil Kumar8-Jul-08 23:03

S. Senthil Kumar

8-Jul-08 23:03

Also check the max page file size (My Computer -> Properties -> Advanced -> Performance -> Settings -> Advanced -> Virtual Memory) and see if you are close to that limit (Task Manager -> Performance -> PF Usage).

Regards
Senthil [MVP - Visual C#]
_____________________________
My Blog | My Articles | My Flickr | WinMacro

Re: Virtual memory problem

Alan Balkany9-Jul-08 4:55

Alan Balkany

9-Jul-08 4:55

It's helpful to call the Dispose () method on large objects (like bitmaps) that your program no longer needs. This allows .NET to use memory more efficiently.

Also see the standard dispose pattern. Here's a good discussion of it: http://www.codeproject.com/KB/dotnet/idisposable.aspx[^]

Whats wrong with DebuggerDisplay in Visual Studio 2008

MarkPhB8-Jul-08 22:05

MarkPhB

8-Jul-08 22:05

Hi, i discoverd the DebuggerDisplayAttribute don't work in Visual Studio 2008, at leat in mine.

In Visual Studio 2005 did that work

[DebuggerDisplay( "{FirstName} {LastName}" )]
class Person {
   public String FirstName { get; set; }
   public String LastName { get; set; }
}

i searched for that problem already but i didnt found something about that.

That why my question: Can you acknowledge that bug ?

Re: Whats wrong with DebuggerDisplay in Visual Studio 2008

leppie8-Jul-08 22:32

Re: Whats wrong with DebuggerDisplay in Visual Studio 2008

8-Jul-08 22:32

MarkPhB wrote:
In Visual Studio 2005 did that work

I noticed that too, personally I just override ToString() Smile | :)

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

MarkPhB8-Jul-08 22:45

MarkPhB

8-Jul-08 22:45

Ok and how do we inform Mircosoft about that bug ?

Re: Whats wrong with DebuggerDisplay in Visual Studio 2008

leppie8-Jul-08 22:49

How To Use HASP Device Security

8-Jul-08 22:49

IIRC: connect.microsoft.com

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Thaer Hamael8-Jul-08 21:46

Thaer Hamael

8-Jul-08 21:46

Hi All
I wount to use the HASP Security Device By Using C#.Net .
But I Dont Know How i Can Use It .
How can hellp me About US .
if Any body have Dll About it Sent it To Me .
Thanks for any body hellp me Rose | [Rose]

Thaer

Re: How To Use HASP Device Security

leppie8-Jul-08 22:31