Re: datagrid save - C# Discussion Boards

Re: Discover a Device in C#

26-Jul-07 23:54

Hello,

In .Net < 2.0 you have to use System.Management functionalities.

ArrayList drives = new ArrayList();

using(ManagementObjectSearcher DriveSearch = new ManagementObjectSearcher(new SelectQuery("Select * from Win32_LogicalDisk")))
{
using(ManagementObjectCollection moDriveCollection = DriveSearch.Get())
{
        foreach(ManagementObject mo in  moDriveCollection)
        {
            LogicalDriveInfo driveinfo = new LogicalDriveInfo(mo);
            if(this[driveinfo.Name] == null)
                drives.Add(driveinfo);
            mo.Dispose();
        }
}
}

For .Net >= 2.0 you could use DriveInfo.GetDrives()[^]

All the best,

Martin

Amjath Rahman29-Jul-07 14:51

Amjath Rahman

29-Jul-07 14:51

Hi Martin,

Thanks for ur valuable inputs.
i will explain in detail wat i want, i have 1 details connected to my pc that device associate to many wireless clinet, i want get the information abt that wireless devices,

how can i do that

With Regards
Amjath

printing a complete datagrid having paging and sorting

samparadise26-Jul-07 23:36

samparadise

26-Jul-07 23:36

Does anyone have a simple example or steps on how to print a datagrid with paging and sorting? I would like to attach the function to a button control on the form and then once clicked send the entire datagrid with whole data to the printer

sameer Gupta

datagrid save

csharpgal26-Jul-07 23:16

csharpgal

26-Jul-07 23:16

i use datagrid and i make changes and add new rows. and i want to save all of this changes and new rows with pressing a button, or without pressing a button when i make changes it will be save, may be it can be save when going another row

Re: datagrid save

Christian Graus27-Jul-07 0:26

Control inside listbox C# .Net

27-Jul-07 0:26

YOu don't say where the data comes from. Basically, if it's a database, you need to grab the new data and store it there, just like you had to pull the old data out.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: datagrid save

csharpgal27-Jul-07 1:41

csharpgal

27-Jul-07 1:41

thank you for your reply.
how will i do it, i dont know. i try this code but i can change or add new row at one time.

my present code id like this:

private void button2_Click(object sender, System.EventArgs e)
{
int satir;
satir=dataGrid4.CurrentRowIndex;

if(dG4SatirSay==satir)
{
DataTable tablo;
DataRow kayit;
tablo=alPersOzluk.Tables[0];
kayit=tablo.NewRow();
kayit[1]=dataGrid4[satir,1];

string kaynakGor="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=vt1.mdb";
OleDbConnection baglantiGor=new OleDbConnection(kaynakGor);
baglantiGor.Open();

string gorevAdi=dataGrid4[satir,2].ToString();
string sorguGor="SELECT GorevNo FROM PGorev Where Gorev='"+gorevAdi+"'";
OleDbCommand komutGor=new OleDbCommand(sorguGor,baglantiGor);
OleDbDataReader ordGor= komutGor.ExecuteReader();
ordGor.Read();
kayit[2]=ordGor[0].ToString();

ordGor.Close();
baglantiGor.Close();

kayit[3]=dataGrid4[satir,3];
kayit[4]=dataGrid4[satir,4];
kayit[5]=dataGrid4[satir,5];
kayit[6]=dataGrid4[satir,6];
kayit[7]=dataGrid4[satir,7];
kayit[8]=dataGrid4[satir,8];

string kaynakPrs="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=vt1.mdb";
OleDbConnection baglantiPrs=new OleDbConnection(kaynakPrs);
baglantiPrs.Open();

string sorguPrs=@"Insert Into PersonelOzluk(AdiSoyadi,Gorevi,TelefonNo,Adresi,TCKimlikNo,VergiNo,DogumTarihi,KanGrubu) Values ('"+kayit[1]+"','"+kayit[2]+"','"+kayit[3]+"','"+kayit[4]+"','"+kayit[5]+"','"+kayit[6]+"','"+kayit[7]+"','"+kayit[8]+"')";
OleDbCommand komutPrs=new OleDbCommand(sorguPrs,baglantiPrs);

komutPrs.ExecuteNonQuery();
baglantiPrs.Close();
}
else
{
DataTable tablo;
DataRow kayit;
tablo=alPersOzluk.Tables[0];
kayit=tablo.NewRow();
kayit[0]=dataGrid4[satir,0];
kayit[1]=dataGrid4[satir,1];

string kaynakGor="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=vt1.mdb";
OleDbConnection baglantiGor=new OleDbConnection(kaynakGor);
baglantiGor.Open();

string gorevAdi=dataGrid4[satir,2].ToString();
string sorguGor="SELECT GorevNo FROM PGorev Where Gorev='"+gorevAdi+"'";
OleDbCommand komutGor=new OleDbCommand(sorguGor,baglantiGor);
OleDbDataReader ordGor= komutGor.ExecuteReader();
ordGor.Read();
kayit[2]=ordGor[0].ToString();

ordGor.Close();
baglantiGor.Close();

kayit[3]=dataGrid4[satir,3];
kayit[4]=dataGrid4[satir,4];
kayit[5]=dataGrid4[satir,5];
kayit[6]=dataGrid4[satir,6];
kayit[7]=dataGrid4[satir,7];
kayit[8]=dataGrid4[satir,8];

string kaynakPrs="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=vt1.mdb";
OleDbConnection baglantiPrs=new OleDbConnection(kaynakPrs);
baglantiPrs.Open();

string sorguPrs="Update PersonelOzluk Set AdiSoyadi='"+kayit[1]+"',Gorevi='"+kayit[2]+"',TelefonNo='"+kayit[3]+"',Adresi='"+kayit[4]+"',TCKimlikNo='"+kayit[5]+"',VergiNo='"+kayit[6]+"',DogumTarihi='"+kayit[7]+"',KanGrubu='"+kayit[8]+"' Where PersonelNo="+kayit[0]+"";
OleDbCommand komutPrs=new OleDbCommand(sorguPrs,baglantiPrs);

komutPrs.ExecuteNonQuery();
baglantiPrs.Close();
}
}

drweb8626-Jul-07 22:53

drweb86

26-Jul-07 22:53

Hello.

I have a problem
I've developed control CompressionItemControl and want to add it to listbox as an item, but it doesn't show it(it only shows that smth added)

Could you help me to create list of controls in listbox?

Thanks, Sergey

Christian Graus26-Jul-07 23:08

26-Jul-07 23:08

You can't add child windows to a ListBox, a list item is a predefined thing, and it renders text and perhaps an icon.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

drweb8626-Jul-07 23:32

drweb86

26-Jul-07 23:32

So i have to develop a separate control to show such controls? or there is a standard decision???

Thanks

Christian Graus26-Jul-07 23:36

26-Jul-07 23:36

Yes, if you want a list of controls, you need to create something. Or, just render/position the controls in a row, I guess.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Showing an icon in a gridview (WPF)

drweb8626-Jul-07 23:45

drweb86

26-Jul-07 23:45

Thank you very much!!!

Johan Lombaard26-Jul-07 22:51

Johan Lombaard

26-Jul-07 22:51

I need to display icons next to items in a listview (using gridview) with WPF. Does anyone have a sample of this ?

Johan Lombaard

Only two things are infinite, the universe and human stupidity, and I'm not sure about the former - Albert Einstein

Re: Showing an icon in a gridview (WPF)

kubben27-Jul-07 1:42

kubben

27-Jul-07 1:42

Normally I would suggest using an asp:Image control, but I am not sure if the ImageUrl support Icon files. Why wouldn't you use gif or jpg files instead? Anyway, it might work with icon files. First create a new column that is a template column in your gridview. Once you have a template column you have an ItemTemplate and an EditTemplate. Create an asp:Image control in the itemtemplate and bind it to the correct variable that has the imageurl in it. If you allow editing to your grid view you will need to add it there as well if you want the image to be seen when editing.

Hope that helps.
Ben

convert to ASCII

Sunshine Always26-Jul-07 22:47

Sunshine Always

26-Jul-07 22:47

hi how can i convert a decimal value to its ASCII equivalent in C#?
thanks

Re: convert to ASCII

Christian Graus26-Jul-07 23:07

26-Jul-07 23:07

Probably char c = 65 would do it.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: convert to ASCII

Hari Om Prakash Sharma26-Jul-07 23:09

Hari Om Prakash Sharma

26-Jul-07 23:09

try this code:

<br />
        private string ConvertToAscii(decimal value)<br />
        {<br />
            Encoding ascii = Encoding.UTF32;<br />
<br />
            char chr = (char)value;<br />
            Byte[] bty = ascii.GetBytes(chr .ToString());<br />
<br />
            return ascii.GetString((bty));<br />
        }<br />

First and the Foremost: FIGHT TO WIN

MySite:
http://hariomprakash.info

Re: convert to ASCII

Christian Graus26-Jul-07 23:25

Eventhandler in C# - How to send parameter

26-Jul-07 23:25

Why on earth does it take a decimal ?

This looks like a convoluted mess to me. I just did this and traced in the debugger:

int n = (int)'C';
char c = (char)n;

it worked just fine.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Vikas K.26-Jul-07 22:14

Vikas K.

26-Jul-07 22:14

Hi,

My question is "How to send a user defined variable value while calling eventhandler.

Pls go thru the below example:

1. I have an array of Pictureboxes arranged on a Panel
2. I have handled the Click event on PictureBoxes as below but dont know:
how to pass "string FilePath" as part of "Object sender"

<br />
/* I have a string value (FilePath) parameter which I want to send to the  function ClickHandler which gets invoked whenerever someone clicks on a PictureBox <br />
*/<br />
string FilePath; //Has file path info<br />
picBoxes[index].Click += new System.EventHandler(ClickHandler);<br />
<br />
...<br />
...<br />
<br />
// Signature of ClickHandler method is as follows<br />
public void ClickHandler(Object sender, System.EventArgs e)<br />
{<br />
  // I can get the handle to the PictureBox which was clicked by the user<br />
  // as follows<br />
<br />
  PictureBox pbx = new PictureBox();<br />
  pbx = (PictureBox) ((System.Windows.Forms.PictureBox)sender);<br />
<br />
  // How do I access FilePath ?<br />
<br />
}<br />
<br />

Thanks

Re: Eventhandler in C# - How to send parameter [modified]

Martin#26-Jul-07 22:38

26-Jul-07 22:38

Hello,

I think what you want to do is only possible with an Inherited class and the usage of Custom Eventargs.

1) Inherit a class from PictureBox

public class SpecialPictureBox : System.Windows.Forms.PictureBox

2) Add a string property FilePath

private string _filepath = "";
[System.ComponentModel.DefaultValue("")]
public string FilePath
{
    get
    {
	return _filepath;
    }
    set
    {
	_filepath = value;
    }
}

3)Inherit a class from System.EventArgs with a string member

public class SpecialEventArgs : System.EventArgs
{
    public string filepath;
 
    public SpecialEventArgs(string _filepath)
    {
	filepath= _filepath;
    }
}

4)Create a delegate for your special event in your SpecialPictureBox class, which uses the SpecialEventArgs.

public delegate void SpecialEvent(object sender, SpecialEventArgs specialEA);

5)Create an event which uses the delegate

public event SpecialEvent SpecialChanged;

6)override the OnClick event of your PictureBox and fire the event, with the Filepath property.

if(SpecialChanged!=null)
{
    SpecialChanged(this, new SpecialEventArgs(this.FilePath));
}

7)In your Form Handle the SpecialChanged event and set the FilePath property

yourSpecialPictureBox.FilePath = "yourpath";
yourSpecialPictureBox.SpecialChanged+= new YourNamespace.SpecialEvent(yourSpecialPictureBox_SpecialChanged);
 
private void yourSpecialPictureBox_SpecialChanged(object sender, SpecialEventArgs specialEA)
{
    //specialEA.filepath
}

Hope it helps!

-- modified at 5:35 Friday 27th July, 2007

All the best,

Martin

Vikas K.26-Jul-07 23:17

Vikas K.

26-Jul-07 23:17

Oh wow, didnt think about it! let me try. Thank you Martin. Big Grin | :-D

Martin#26-Jul-07 23:19

26-Jul-07 23:19

You are wellcome!

Hope it works out for you.
Please let us know.

All the best,

Martin

Mike Dimmick27-Jul-07 2:26

Mike Dimmick

27-Jul-07 2:26

In .NET Framework 2.0, if you're following the EventArgs pattern, you don't need to declare your own delegate, you can use the generic EventHandler<T> delegate. Saves time and metadata space.

So you'd have

public event EventHandler<SpecialEventArgs> SpecialChanged;
 
yourSpecialPictureBox.SpecialChanged += 
  new EventHandler<SpecialEventArgs>(yourSpecialPictureBox_SpecialChanged);

I'm finding this pretty handy.

Stability. What an interesting concept. -- Chris Maunder

Martin#27-Jul-07 2:46