C# Discussion Boards - CodeProject

Re: need help

Lutosław13-Jun-10 12:26

Lutosław

13-Jun-10 12:26

aaga5 wrote:
Syntax error in UPDATE statement.how can slove it

You can read a documentation of the UPDATE statement here[^]. Stick to the syntax described there and everything should be OK. If not, please tell us what was the query.

Greetings - Jacek

Re: need help

Abhinav S13-Jun-10 18:18

Abhinav S

13-Jun-10 18:18

This is the C# forum.

My signature "sucks" today

Problem to use letters ( c: , d:) with the physical drive:

muteb13-Jun-10 7:32

muteb

13-Jun-10 7:32

Hi
I'm trying to use the name of a logical drive (c: and d Smile | :)

. I can't use them to get access to the physical drive in order to get the type, the model, the interface, the capacity, sectors and cylinders.

My code :

private void Form1_Load(object sender, EventArgs e)
{

ManagementObjectSearcher mosDisks = new ManagementObjectSearcher("SELECT * FROM Win32_LogicalDisk");
foreach (ManagementObject moDisk in mosDisks.Get())
{
comboBox2.Items.Add(moDisk["DeviceID"].ToString());
}

}

private void button4_Click_1(object sender, EventArgs e)
{
listView2.Items.Clear()
ManagementObjectSearcher mosDisks = new ManagementObjectSearcher("SELECT * FROM Win32_DiskDrive WHERE DeviceID = '" + comboBox2.SelectedItem + "'");
foreach (ManagementObject moDisk in mosDisks.Get())
{

ListViewItem item = listView2.Items.Add("Type: " + moDisk["MediaType"].ToString());
ListViewItem item2 = listView2.Items.Add("Model: " + moDisk["Model"].ToString());
ListViewItem item3 = listView2.Items.Add("Interface: " + moDisk["InterfaceType"].ToString());
ListViewItem item4 = listView2.Items.Add("Capacity: " + moDisk["Size"].ToString() + " bytes (" + Math.Round(((((double)Convert.ToDouble(moDisk["Size"]) / 1024) / 1024) / 1024), 2) + " GB)");
ListViewItem item5 = listView2.Items.Add("Partitions: " + moDisk["Partitions"].ToString());
ListViewItem item6 = listView2.Items.Add("Signature: " + moDisk["Signature"].ToString());
ListViewItem item7 = listView2.Items.Add("Cylinders: " + moDisk["TotalCylinders"].ToString());
ListViewItem item8 = listView2.Items.Add("Sectors: " + moDisk["TotalSectors"].ToString());
ListViewItem item9 = listView2.Items.Add("Heads: " + moDisk["TotalHeads"].ToString());
ListViewItem item10 = listView2.Items.Add("Tracks: " + moDisk["TotalTracks"].ToString());
ListViewItem item11 = listView2.Items.Add("Bytes per Sector: " + moDisk["BytesPerSector"].ToString());
ListViewItem item12 = listView2.Items.Add("Sectors per Track: " + moDisk["SectorsPerTrack"].ToString());
ListViewItem item13 = listView2.Items.Add("Tracks per Cylinder: " + moDisk["TracksPerCylinder"].ToString());
ListViewItem item14 = listView2.Items.Add("Description: " + moDisk["Description"].ToString());

}
}

I have used this code and it worked fine but I can't get the letters instead of the Model in the combox
private void Form1_Load(object sender, EventArgs e)
{

ManagementObjectSearcher mosDisks = new ManagementObjectSearcher("SELECT * FROM Win32_DiskDrive");
foreach (ManagementObject moDisk in mosDisks.Get())
{
comboBox2.Items.Add(moDisk["Model"].ToString());

}

}

private void button4_Click_1(object sender, EventArgs e)
{
listView2.Items.Clear();

ManagementObjectSearcher mosDisks = new ManagementObjectSearcher("SELECT * FROM Win32_DiskDrive WHERE Model = '" + comboBox2.SelectedItem + "'");
foreach (ManagementObject moDisk in mosDisks.Get())
{

ListViewItem item = listView2.Items.Add("Type: " + moDisk["MediaType"].ToString());
ListViewItem item2 = listView2.Items.Add("Model: " + moDisk["Model"].ToString());
ListViewItem item3 = listView2.Items.Add("Interface: " + moDisk["InterfaceType"].ToString());
ListViewItem item4 = listView2.Items.Add("Capacity: " + moDisk["Size"].ToString() + " bytes (" + Math.Round(((((double)Convert.ToDouble(moDisk["Size"]) / 1024) / 1024) / 1024), 2) + " GB)");
ListViewItem item5 = listView2.Items.Add("Partitions: " + moDisk["Partitions"].ToString());
ListViewItem item6 = listView2.Items.Add("Signature: " + moDisk["Signature"].ToString());
ListViewItem item7 = listView2.Items.Add("Cylinders: " + moDisk["TotalCylinders"].ToString());
ListViewItem item8 = listView2.Items.Add("Sectors: " + moDisk["TotalSectors"].ToString());
ListViewItem item9 = listView2.Items.Add("Heads: " + moDisk["TotalHeads"].ToString());
ListViewItem item10 = listView2.Items.Add("Tracks: " + moDisk["TotalTracks"].ToString());
ListViewItem item11 = listView2.Items.Add("Bytes per Sector: " + moDisk["BytesPerSector"].ToString());
ListViewItem item12 = listView2.Items.Add("Sectors per Track: " + moDisk["SectorsPerTrack"].ToString());
ListViewItem item13 = listView2.Items.Add("Tracks per Cylinder: " + moDisk["TracksPerCylinder"].ToString());
ListViewItem item14 = listView2.Items.Add("Description: " + moDisk["Description"].ToString());

}
}

Re: Problem to use letters ( c: , d:) with the physical drive:

Henry Minute13-Jun-10 8:14

Henry Minute

13-Jun-10 8:14

I am not sure that you can get the drive letters using the PhysicalDrive. Look up Win32_MappedLogicalDisk in the WMI documentation. From memory it is much easier to get the drive letters that way.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
Why do programmers often confuse Halloween and Christmas? - Because 31 Oct = 25 Dec.
Business Myths of the Geek #4 'What you think matters.'

Re: Problem to use letters ( c: , d:) with the physical drive:

Luc Pattyn13-Jun-10 8:21

Luc Pattyn

13-Jun-10 8:21

The logical drives (drive letters) identify partitions, not physical devices. It takes a couple of WMI objects to get most of the information you want; you will probably discover that the very physical characteristics (such as number of cylinders) don't make sense any more as they are virtualized within the drive itself; the local intelligence just makes the disk look like one heap of sectors.

Also, the latest versions of Windows (Vista, 7) are likely to refuse full access, even read access, at the device level unless you are an elevated escalated super-administrator.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

The Lion has roared

Connection string

humayunlalzad13-Jun-10 3:01

humayunlalzad

13-Jun-10 3:01

connectionString1 = @"
            server = .\sqlexpress;
            integrated security = true;
            database = C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\NORTHWND.MDF;
user instance = true";

connectionString2 =  @"
            server = .\sqlexpress;
            integrated security = true;
            database = northwind";

connectionString1 is working fine and connectionString2 is giving the message "Cannot open database northiwnd. login failed for user XYZ".
Can someone tell me whats the difference

Re: Connection string

Abhinav S13-Jun-10 3:27

Abhinav S

13-Jun-10 3:27

humayunlalzad wrote:
atabase = C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\NORTHWND.MDF;user instance = true";

humayunlalzad wrote:
database = northwind";

The difference lies in the user instance = true part of the sql.
Read about user instances here.

My signature "sucks" today

Re: Connection string

humayunlalzad13-Jun-10 3:51

humayunlalzad

13-Jun-10 3:51

@"
            server = .\sqlexpress;
            integrated security = true;
            database = northwind;
            user instance = true";

I am sorry I should have mentioned before hand, that even the above string with "user instance = true" added is not working

crystal report and list<>

reza assar12-Jun-10 21:39

reza assar

12-Jun-10 21:39

hi all
i have an win application form suppose to show some reports in CrystalReportView i have no idea how to assign a list<> of class to MyCrystalReport

   public Form1()
{
    InitializeComponent();
    StdList = new List<studants>();
    StdList.Add(new studants("1", "1", 1));
    StdList.Add(new studants("2", "2", 2));
    StdList.Add(new studants("3", "3", 3));
    StdList.Add(new studants("4", "4", 4));
    StdList.Add(new studants("5", "5", 5));
}

private void Form1_Load(object sender, EventArgs e)
{
    CrystalReport1 cr = new CrystalReport1();
    cr.SetDataSource(StdList);
    crystalReportViewer1.ReportSource = cr;
}

but i have not assigned any table with CrystalReport1 it`s all because of i have not any dataset or database or ... and i do not know how to assign add or assign a list<> of objects to my crytalReport Project (CrystalReport1) how can i assign it and work on it

i should definitely use list<>
please help me!!!!!!!!!!

Re: crystal report and list

Mycroft Holmes13-Jun-10 19:55

Mycroft Holmes

13-Jun-10 19:55

Does CR support List<> as a datasource? I have not used that POS in a few years but I doubt it has moved that fast.

I suggest you do some research on the Business Object web site.

Never underestimate the power of human stupidity
RAH

Need to add 1 to a cache value

Randall Hall12-Jun-10 18:07

Randall Hall

12-Jun-10 18:07

I have a label called lblsite that I'm trying to give a value from a cached value.

protected void Page_Load(object sender, System.EventArgs e)<br />
    {<br />
        lblsite.Text = (Cache("locid") + 1);<br />
    }

The "locid" is set on the previous page.

protected void btnaddaddress_Click(object sender, System.EventArgs e)<br />
    {<br />
       Cache["locid"] = gvaddressmax.SelectedRow.Cells[0].Text;<br />
       Response.Redirect("btnaddaddress.aspx");<br />
    }

However, the lblsite.Text = (Cache("locid") + 1); gives me the following error and results in a null value.

'System.Web.Caching.Cache' is a Type, but being used like a variable

How can I get this to work?

Re: Need to add 1 to a cache value

Dan Mos12-Jun-10 18:21

Dan Mos

12-Jun-10 18:21

You should have posted in the asp forum. Anyway, I think it's the parenthesis.

try (Cache)("locid") +1;

even better

(yourType)((Cache)("locid")) +1;

You did not mentioned what you stored in the previous page.

Just an irritated, ranting son of ... an IT guy.
At your trolling services

Re: Need to add 1 to a cache value

Pete O'Hanlon13-Jun-10 4:44

Pete O'Hanlon

13-Jun-10 4:44

Randall Hall wrote:
(Cache("locid") + 1)

This is the problem. Cache provides indexer access to object values, so you need to extract the value back out before you attempt to work with it. Try changing this instead to:

int value;
if (int.TryParse(Cache["locid"], out value))
{
  lblsite.Text = ++value;
}

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Tab Control with Exit Button

royk12312-Jun-10 10:04

royk123

12-Jun-10 10:04

Hi,

I'm interested in adding a small exit button to the top part of the active Tab Page (like the one in the IE's Tabs), in order to enable users to close tabs more easily.

I'd appreciate any info on how to acomplish this (probably involves owner drawn tab control + more), or if anyone has already implemented such Tab Contol/Tab Page - a link to it...

tnx

roy

Re: Tab Control with Exit Button

Dan Mos12-Jun-10 16:18

Dan Mos

12-Jun-10 16:18

I assume Winforms so here is one of the many results here on CP:
link1

Search is the key
Smile | :)

Just an irritated, ranting son of ... an IT guy.
At your trolling services

Re: Tab Control with Exit Button

royk12313-Jun-10 2:09

royk123

13-Jun-10 2:09

Exactly what i was looking 4..

Tnx
Roy

Re: Tab Control with Exit Button

Amar Chaudhary12-Jun-10 17:09

Amar Chaudhary

12-Jun-10 17:09

If its web you may look forward to coolite [^]toolkit.

My Startup!!!!

Profile@Elance - feedback available too

Setting Datagridview combobox column value to null.

priyamtheone12-Jun-10 6:14

priyamtheone

12-Jun-10 6:14

There's an editable datagridview populated from a table say tblItems. Among the columns of the datagridview there's a combobox column named 'Category'. This column is populated by the respective 'Category' column of tblItems. Now in the 'Category' column of the datagridview I want to set the value of a certain cell to Null programmatically. Suppose when I press keyboard Delete button over the cell or some other button on the form, the value of the cell becomes Null. Datagridview.keydown event isn't working as when the cell is selected the focus is actually on the editingcontrol of the cell and not the datagridview. Also the combobox editingcontrol doesn't have any 'SelectedIndex' property that can be set to -1. Any idea plz? Regards.

Re: Setting Datagridview combobox column value to null.

Mycroft Holmes12-Jun-10 15:53

Mycroft Holmes

12-Jun-10 15:53

Add an item to your list in position 0 with a value 0 and a label of string.empty.
Set the selected index to 0.
Deal with the 0 value on the way out, when you write to the database.

Never underestimate the power of human stupidity
RAH

Re: Setting Datagridview combobox column value to null. [modified]

priyamtheone14-Jun-10 5:43

priyamtheone

14-Jun-10 5:43

The thing is, the EditingControl property of the grid and the e.Control property in the EditingControlShowing event handler are both type Control, because they have to be able to refer to any control. If you're currently editing a combo box column though, you know that the actual object is type ComboBox (to be more precise, type DataGridViewComboBoxEditingControl) so you have to cast it as that type in order to access members of that type. This is the case no matter what objects you're dealing with: you must have a reference of the correct type to access members of that type. E.g.

ComboBox cbx = (ComboBox)myDataGridView.EditingControl;

cbx.SelectedIndex = -1;

modified on Monday, June 14, 2010 12:11 PM

Re: Setting Datagridview combobox column value to null.

Mycroft Holmes14-Jun-10 12:10

Mycroft Holmes

14-Jun-10 12:10

You missed the point, this is all about managing your data not the control. The control does not deal with null so supply an alternative. It is your data, decide how you can do this, I would add a default data item into the underlying dataset and use that as the null substitue.

Never underestimate the power of human stupidity
RAH

Accessing CheckBox on row in Datagridview

Smith#12-Jun-10 4:09

Smith#

12-Jun-10 4:09

Why on earth it's so difficult to find a sample on the web for this topic? Nobody has ever tried putting a checkbox on a datagridview on a winform? Or my search is wrong? This thread's subject has been my search key. Gettin nothin.

What's wrong with the below code?

<br />
      DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)dataGridView1.Rows[0].Cells[0];<br />
      if (chk.Selected)<br />
      {<br />
          MessageBox.Show("Selected!");<br />
       }<br />

It's always checking the "cells" selected state. I want to know if the check box has been selected(Checked!) or not.
Yes, I added column 0 to be a DataGridViewCheckBoxCell.

Anybody can help?

Re: Accessing CheckBox on row in Datagridview

dan!sh 12-Jun-10 4:25

dan!sh

12-Jun-10 4:25

The Value property would give the checked state of the cell. Smile | :)

BTW, instead of casting, you can use as keyword along with the null check.

Re: Accessing CheckBox on row in Datagridview

Smith#12-Jun-10 4:49

Smith#

12-Jun-10 4:49

How do I access it's value? The below attempt is successfuly throwing a cast exception.

<br />
  if (CheckState.Checked == (CheckState)dataGridView1.Rows[0].Cells[0].Value)<br />
                {<br />
                    MessageBox.Show("ok");<br />
                }<br />

Re: Accessing CheckBox on row in Datagridview

Luc Pattyn12-Jun-10 5:01

Luc Pattyn

12-Jun-10 5:01

so look at dataGridView1.Rows[0].Cells[0].Value.ToString() to discover what might be wrong.
everything responds well to ToString(), except null of course.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read formatted code with indentation, so please use PRE tags for code snippets.

I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.