Re: Urgent -Please Help - C# Discussion Boards

20-Mar-07 16:54

You're looking for the Process[^] class.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Urgent -Please Help

Nermeenez20-Mar-07 15:07

Nermeenez

20-Mar-07 15:07

Hi,

I need to change a Cell Value in a DataGridView which gets its data from DataBase, the problem is the type of the data I need to change is int16 in SQL and I need to change it in the dataview to string example:
if (this.dataGridView1.Rows[0].Cells[1].Value.ToString() == "0")/// its type is int16
{
/////////////////////// I need to change it from 0 to "Exist"
this.dataGridView1.Rows[1].Cells[2].Value = Int16.Parse("Exists", null);/// throw an exception
this.dataGridView1.Rows[0].Cells[2].Value =5 ; /// this works as I give it int , but this is not what I need :S
}

Thanks,
Nena

sean.m20-Mar-07 15:30

sean.m

20-Mar-07 15:30

DataGridView just displays information, am I right? Can't you just directly edit the Value of a cell?

Nermeenez20-Mar-07 22:16

Nermeenez

20-Mar-07 22:16

Hi Sean,

my main problem is that the column I need to edit its value is Short in the DataBase.
Therefore each type I pass string to this Column an Expection is throw Input is not in the correct form, That's way i was trying to convert string to int16 but still I can't do it.
This is so annoying to me , I don't want to change the field in the DataBase all I need is to change the Display instead of "0" to a string "Exists".

Hope i made it clear this time.

Thanks a lot
Nena
Egypt

Keshav V. Kamat20-Mar-07 18:19

Keshav V. Kamat

20-Mar-07 18:19

Hi nena,

I hope this helps.

string Value;
string Exists="Exists";
Value= Datagrid1.Rows[1].Cells[1].Value.ToString();
if (Value=="0")
Datagrid1.Rows[1].Cells[1].Value = Exists;

be careful of the cell that you are working on. But it should work.
You can use a for loop for the rows and the columns. If you are searching in both rows and and columns for the value 0 then use something like this.

string Value;
string Exists="Exists";
for(int i=0; i<LoggerDatagrid.Columns.Count; i++)
{
for(int j=0;j<LoggerDatagrid.Rows.Count;j++)
{
Value= Datagrid1.Rows[j].Cells[i].Value.ToString();
if (Value=="0")
Datagrid1.Rows[j].Cells[i].Value = Exists;
}
}

hope it works.

Keshav Kamat Smile | :)

India

Nermeenez20-Mar-07 22:14

Nermeenez

20-Mar-07 22:14

Hi Keshav,

This works only if the original data given to the DataGrid was string , my main problem is that the column I need to edit its value is Short in the DataBase.
Therefore each type I pass string to this Column an Expection is throw Input is not in the correct form, That's way i was trying to convert string to int16 but still I can't do it.
This is so annoying to me , I don't want to change the field in the DataBase all I need is to change the Display instead of "0" to a string "Exists".

Hope i made it clear this time. Waiting for your help

Thanks a lot
Nena
Egypt

joon _vh.20-Mar-07 22:44

joon _vh.

20-Mar-07 22:44

I can't really shake a solution out of my sleeve, but I know a workaround that I often use.
Somewhere in your application you are probably using a Stored Procedure, or a SQL Query.

SELECT * FROM table

you could change it to this

 <br />
(SELECT [Name], 'Exists' <br />
FROM [Table]<br />
WHERE [Field] = 0)<br />
<br />
UNION<br />
<br />
(SELECT [Name], [Field]<br />
FROM [Table]<br />
WHERE [Field] <> 0)<br />

Another option would be to add a new column to your dgv, and place it in place of the other one, and populate it with the desired values.

Visual Studio can't evaluate this, can you?

public object moo<br />
        {<br />
__get { return moo; }<br />
__set { moo = value; }<br />
}

Add-in's and Extensions [modified]

Keshav V. Kamat21-Mar-07 1:10

Keshav V. Kamat

21-Mar-07 1:10

Int16 Value;
string Exists="Exists";
for(int i=0; i<LoggerDatagrid.Columns.Count; i++)
{
for(int j=0;j<LoggerDatagrid.Rows.Count;j++)
{
Value= (Int16)Datagrid1.Rows[j].Cells[i].Value.ToString();
if (Value=='0')
     Datagrid1.Rows[j].Cells[i].Value = Exists;
}
}

please check if this works.

Keshav Kamat Smile | :)

India

Saikek20-Mar-07 13:15

Re: Add-in's and Extensions

20-Mar-07 13:15

Hello !
Can You tell me, what add-ins are you using, and what they do ?
Add-in's to Visual studio 2005

-- modified at 2:50 Wednesday 21st March, 2007

One nation - underground

Dave Kreskowiak20-Mar-07 16:50

20-Mar-07 16:50

Add-In's to what?

Dave Kreskowiak
Microsoft MVP - Visual Basic

[Message Deleted]

Saikek20-Mar-07 13:09

20-Mar-07 13:09

[Message Deleted]

pbraun20-Mar-07 14:11

pbraun

20-Mar-07 14:11

What OS are you using? What type of hardware are you using?

Phil

Dave Kreskowiak20-Mar-07 16:50

20-Mar-07 16:50

If Windows XP, open a CMD prompt and type:

C:\WINDOWS>sc query type= driver

Make sure you put in the space between type= and driver.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Saikek20-Mar-07 20:49

20-Mar-07 20:49

I am using windows XP, but i want to get list of drivers using c#. Can you tell me some functions or methods?

One nation - underground

joon _vh.20-Mar-07 23:22

joon _vh.

20-Mar-07 23:22

these might be helpful then:

Get Hardware Information[^]
Hardware Properties[^]

Visual Studio can't evaluate this, can you?

public object moo<br />
        {<br />
__get { return moo; }<br />
__set { moo = value; }<br />
}

Dave Kreskowiak21-Mar-07 1:37

21-Mar-07 1:37

Sorry! I thought we were in the O/S Forum...:->

Dave Kreskowiak
Microsoft MVP - Visual Basic

Luc Pattyn21-Mar-07 14:35

Luc Pattyn

21-Mar-07 14:35

Hi, have a look at ServiceController.GetDevices() Smile | :)

Luc Pattyn

[My Articles]

Saikek21-Mar-07 22:11

21-Mar-07 22:11

Thank you, very much!!!

One nation - underground

Dictionary

Saikek20-Mar-07 12:49

20-Mar-07 12:49

Good day to everyOne !!!
Can AnyOne tell me:
- in what format should i keep words in the dictionaries?
- how to keep the vocabluaries, how to make read/write ?

One nation - underground!

Re: Dictionary

joon _vh.20-Mar-07 23:24

joon _vh.

20-Mar-07 23:24

Could you specify a little clearer what you are looking for?

Are you talking about actual dictionaries, with words and explanations or translations?
Or are you talking about the Dictionary class...?

Visual Studio can't evaluate this, can you?

public object moo<br />
        {<br />
__get { return moo; }<br />
__set { moo = value; }<br />
}

Re: Dictionary

Saikek21-Mar-07 6:17