Writing Objects into a Database - C# Discussion Boards

Re: problem with TopMost Property of forms ?

PIEBALDconsult26-Dec-07 8:01

PIEBALDconsult

26-Dec-07 8:01

Don't use TopMost, it's user hostile.

C# marquee control needed

Member 351000126-Dec-07 1:12

Member 3510001

26-Dec-07 1:12

Hi! I'm making a program in C# but have some trouble.
I want to use marquee control, but .Net doesn't provide marquee control.
I've searched for that, but I found some commercial controls or broken download link to free control - "Marquee Label .Net Component 1.0" by Ning Zhao.

Is there anyone who has "Marquee Label .Net Component 1.0" or something like that?
Thank you for any help.

Re: C# marquee control needed

Sun Rays26-Dec-07 1:31

Sun Rays

26-Dec-07 1:31

Hi,
you can use marque in aspx page.
Its working fine, you will get red line (error underline) but it will work.

<marquee>Hello World!</marquee><br />

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Re: C# marquee control needed

N a v a n e e t h26-Dec-07 1:34

N a v a n e e t h

26-Dec-07 1:34

Sun Rays ou can use marque in aspx page.

Looks like OP is asking for windows applications.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: C# marquee control needed

N a v a n e e t h26-Dec-07 1:34

N a v a n e e t h

26-Dec-07 1:34

Use a timer and move the label. It will look like a marquee.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: C# marquee control needed

DannyAdler26-Dec-07 1:55

DannyAdler

26-Dec-07 1:55

Hi there,

Found this the other day:
http://www.codeproject.com/KB/miscctrl/csmarquee.aspx?df=100&forumid=14623&exp=0&select=424537[^]

Danny

Re: C# marquee control needed

Paul Conrad26-Dec-07 7:41

Paul Conrad

26-Dec-07 7:41

Just make a custom control to do it for you. Not that tough.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Writing Objects into a Database

00carl0026-Dec-07 0:55

00carl00

26-Dec-07 0:55

Hi,
Im using C# and MS Access,
I was wondering if someone could tell me how to store an object of a class into the database, with an sql query.

My class is variable length so i cant separate its members into columns.

class Item
{
string name;
int id;
ArrayList values = new ArrayList();
}

Item i;

I need to sstore an object 'i' into the database.. can anyone help me?
I tried to find out a way to serialize, because i've done it before in php, just wondering if it can be done in that way in c#. If theres another way, do let me know about it..
Thanks,
Carl

Re: Writing Objects into a Database

Giorgi Dalakishvili26-Dec-07 1:18

Giorgi Dalakishvili

26-Dec-07 1:18

You can convert an instance of Item class to byte array and store it in database in blob field

#region signature
my articles
#endregion

Re: Writing Objects into a Database

00carl003-Jan-08 0:48

00carl00

3-Jan-08 0:48

hi.. i tried to do this with th ebinary formatter, but it gives an error

Type 'Billing_Module.Bill' in Assembly 'Billing Module, Version=1.0.2924.30808, Culture=neutral, PublicKeyToken=null' is not marked as serializable.

MemoryStream fs = new MemoryStream();
BinaryFormatter formatter = new BinaryFormatter();

formatter.Serialize(fs, (object)newBill);

fs.Close();

aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+path);
string queryCommand= "insert into BillHistory values ("+newBill.billNumber.ToString()+","+fs.ToString()+")";

can someone help me?

Re: Writing Objects into a Database

Giorgi Dalakishvili3-Jan-08 2:50

Giorgi Dalakishvili

3-Jan-08 2:50

You can make your class serializable by applying Serializable[^] Attribute

#region signature
my articles
#endregion

Regarding Sorting in DataGridView

Ram_Pcr26-Dec-07 0:08

Ram_Pcr

26-Dec-07 0:08

i want to sort the DataGridView...
i dont want to sort first row of the DataGridView.. i just want to sort only from the second row..
whenever i click the header the DataGridview should get sorted only from the second row, the first row should not get sorted

Context menu

Hum Dum25-Dec-07 23:54

Hum Dum

25-Dec-07 23:54

I created a system tray icon & attach Context menu to it,
Now on this i am opening some forms.

Suppose there is menu item "Open" & it opens a form,
now when form is opened & if user click again on "Open" it opens
again, i.e it doesnot focus the same opened one, instead open new instance.

So, How to rectify this.

what if i used mnuItem.checked property to solve the problem?

And plz tell me other ways to do this, if this is one Smile | :)

Thanks in advance to all.

Re: Context menu

N a v a n e e t h26-Dec-07 0:08

N a v a n e e t h

26-Dec-07 0:08

You need to keep the forms object somewhere, and check it's IsDisposed property before creating new Form instance. If it is not Disposed, use BringToFront() to give focus to that form. If it is disposed, create new instance and store it.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: Context menu

Hum Dum26-Dec-07 0:27

Hum Dum

26-Dec-07 0:27

N a v a n e e t h wrote:
check it's IsDisposed property

I think(not sure) dispose method handle this part, or when we closes the form it get called?

a) Now how can i ues this property?
Do i have to use the click event of menuItem.

N a v a n e e t h wrote:
You need to keep the forms object somewhere

b) Not clear?. what do u mean by this, as i am creating object of form, on the context menu form. How i keep the form object somwhere?

c) What about the checked property?

Re: Context menu

N a v a n e e t h26-Dec-07 0:34

N a v a n e e t h

26-Dec-07 0:34

humdumof wrote:
or when we closes the form it get called?

When the form is closed, Disposed property will be set to true. If form is active, it will be false.

humdumof wrote:
Not clear?. what do u mean by this, as i am creating object of form, on the context menu form. How i keep the form object somwhere?

Declare an ArrayList instance as public in the class. In the context menu click, check ArrayList has any form instances. If yes check it's IsDisposed property. If it's disposed, created new instance and add that to array list. If not disposed, cast it to form and call BringToFront() method.

Hope it helps.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: Context menu

00carl0026-Dec-07 0:58

00carl00

26-Dec-07 0:58

You could try using mutex to check if an instance of the program is already open or not..

Sorry i cant help you too much with mutex, however google and msdn have a lot of articles about it.

Re: Context menu

Xmen Real 26-Dec-07 1:01

Xmen Real

26-Dec-07 1:01

Use ShowDialog() instead of Show()

Becoming Programmer...

Sorting Array

sindhutiwari25-Dec-07 22:40

sindhutiwari

25-Dec-07 22:40

hi
My aim is to delete a paricular array element and sort it
example
int[] array1 = new int[5];
array1[0] = 1;
array1[1] = 2;
array1[2] = 3;
array1[3] = 4;
array1[4] = 5;

now i want to delete the array[2] element and bring the array it the order
1245
plz tell me how to do this

regards
sindhu tiwari

Always Innovative

Re: Sorting Array

N a v a n e e t h25-Dec-07 23:37

N a v a n e e t h

25-Dec-07 23:37

Why don't you use an ArrayList ?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: Sorting Array

sindhutiwari25-Dec-07 23:46

sindhutiwari

25-Dec-07 23:46

sir if u dont mind plz tell me in brief...
sindhu tiwari

its me sid

Re: Sorting Array

N a v a n e e t h25-Dec-07 23:55

N a v a n e e t h

25-Dec-07 23:55

ArrayList is a collection class which can hold object types. You can use that . It provides built-in support for removing and sorting.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: Sorting Array

Xmen Real 26-Dec-07 0:58

Xmen Real

26-Dec-07 0:58

ArrayList array1 = new ArrayList();
array1.Add(1);
array1.Add(2);
array1.Add(3);
array1.Add(4);
array1.Add(5);

now if you delete any element then just call array1.Sort()

Becoming Programmer...

Re: Sorting Array

Guffa26-Dec-07 1:20

Guffa

26-Dec-07 1:20

You can't delete items from an array. The size of an array can't be changed.

Use a list instead:

List<int> list1 = new List<int>();
list1.Add(1);
list1.Add(2);
list1.Add(3);
list1.Add(4);
list1.Add(5);
list1.RemoveAt(2);

The list now contains 1, 2, 4, 5.

There is also a Sort method, if you for example want to add an item and sort:

list1.Add(2);
list1.Sort();

The list now contains 1, 2, 2, 4, 5.

Experience is the sum of all the mistakes you have done.

Dynamically Add Rows

Laxmi R25-Dec-07 21:56

Laxmi R

25-Dec-07 21:56

Hi Sorry to paste vb code instead of c# code.

Please help me. How to add rows dyanamically in c#, when i am clicking addbtn it shows only one row. How can add more than 2 rows. Plz help me.

laxmi

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