Any one knows how to access Oracle DB on Unix using C# service application ? - C# Discussion Boards

swjam10-Jan-07 12:42

10-Jan-07 12:42

I would like to add a new row in my datagrid, which is the summary of the other rows in the datagrid. Much like a "Total" row in excel spreadsheet. Thing is, when my user sorts the datagrid by clicking one of the column headers, I would like this Summary row to stay at the bottom. Have done my research but the only thing I came across when it comes to sorting is the AllowSorting() method.
Also, it would be great if I can have my first column also frozen when I scroll to the right, such that the user will be able to see to which row header the value belongs to without having to scroll back to the left everytime.
Thanks in advance!

I am a SysAdmin, I battle my own daemons.

Re: Freeze Row/Col in DataGrid

swjam11-Jan-07 0:30

swjam

11-Jan-07 0:30

PS I know how to add another row to the datagrid. What is proving to be tricky is making this extra row stay at the bottom when the column is sorted by clicking the header. Anyone got any idea?

Thanks!

I am a SysAdmin, I battle my own daemons.

Re: Freeze Row/Col in DataGrid

ed^nrgc11-Jan-07 2:37

ed^nrgc

11-Jan-07 2:37

In the ItemDataBound:

Try something like this:

switch e.Item.ItemType
{
case ListItemType.Footer:
e.Item.Cells(0).Text = "Sum : " +FigureSum(internalSum);
}

Windows Forms Custom Control Reference

Mr. Rogers10-Jan-07 12:29

Mr. Rogers

10-Jan-07 12:29

I've been looking around for a book or a site that does a good job explaining how to create a custom control. I would like that it cover issues like efficiency and usage of current .Net technologies. I haven't been able to find any information out there except for a book that was written while .NET was in beta. Anybody have suggestions?

Re: Windows Forms Custom Control Reference

Nader Elshehabi10-Jan-07 13:21

Nader Elshehabi

10-Jan-07 13:21

Mr. Rogers wrote:
Anybody have suggestions

Ummm... CodeProject[^]? Smile | :)

PS.
Take a special look at hit 5.

Regards

Re: Windows Forms Custom Control Reference

Mike Hankey11-Jan-07 21:15

Mike Hankey

11-Jan-07 21:15

I found that "Windows Forms Programming in C#" to be an overall excellent book on intermidiate to advanced levels. Written by Chris Sells, published by Addison Wesley.
ISBN # 0-321-11620-8. He covers Custom controls in much detail!

Good Luck

Inserting a Record in Access database using tableAdapter.

dsovino10-Jan-07 12:16

dsovino

10-Jan-07 12:16

Hi everyone, i'm a little bit stuck. D'Oh! | :doh:

While i was amazing myself discovering the dateset design wizard (which means that me querys methods will get waaaay shorter now Laugh | :laugh:

), i'm not able to insert a row in the Access database.

I'm using a query to load a treeview, which works just fine:

<br />
<br />
private void GenerateTreeview()<br />
{<br />
treeView1.Nodes.Clear();<br />
onAirDataSetTableAdapters.contenidoTableAdapter contAdap = new Loteria.onAirDataSetTableAdapters.contenidoTableAdapter(); <br />
DataTable tabla = contAdap.ObtenerDatos();            <br />
DataView dataViewHijos = new DataView(tabla);<br />
<br />
and so on....<br />
<br />
}<br />

now, i want to add a node on the treeview, and store that into the database table where I have my items. I tried this on a try/catch/finally, just to make sure i'm not getting any errors. I call generateTreeview() function on finally, to reload my Treeview.

<br />
try<br />
{<br />
onAirDataSetTableAdapters.contenidoTableAdapter contAdap = new Loteria.onAirDataSetTableAdapters.contenidoTableAdapter();<br />
contAdap.InsertarCategoria(dlg.nombre, nodoPadretempID);                    <br />
}<br />
catch (OleDbException ode)<br />
{<br />
MessageBox.Show(ode.ToString(), "Error de Conexion con base de datos");<br />
}<br />
<br />
catch (Exception er)<br />
{<br />
MessageBox.Show(er.ToString());<br />
}<br />
<br />
finally<br />
{<br />
GenerateTreeview();<br />
}<br />
<br />

Everything works ok, i get the updated Treeview while running my app, but the database doesn't get updated.

I restart the app and i get the same initial treeview, and of course, no changes are being performed on the mdb...

PLEASE HELP!!

thanks for eveyones time

OMG | :OMG:

kiweed

Any one knows how to access Oracle DB on Unix using C# service application ?

btsrinath10-Jan-07 11:51

btsrinath

10-Jan-07 11:51

Does any one of you have an example to connect to Oracle DB on Unix machine using C# service application ? Any hint or idea would be of great help....

Srinath

Re: Any one knows how to access Oracle DB on Unix using C# service application ?

ed^nrgc11-Jan-07 2:39

ed^nrgc

11-Jan-07 2:39

Have you used the OracleProvider?

Re: Any one knows how to access Oracle DB on Unix using C# service application ?

btsrinath11-Jan-07 5:11

btsrinath

11-Jan-07 5:11

Yes..

Srinath

searching an index with FindIndex() method

Yustme10-Jan-07 10:48

Yustme

10-Jan-07 10:48

Hi,

I've got a List object containing listviewitems. And i have a few items added to my listview control.

With the findIndex() method i wanna search for an index of an element in the List object and add another element as a subItem to that element.

The problem is, i don't understand the arguments FindIndex() expects.

Can somebody give me an example?

Thanks in advance!

Re: searching an index with FindIndex() method

Stefan Troschuetz10-Jan-07 11:18

Stefan Troschuetz

10-Jan-07 11:18

MSDN topic for List.FindIndex Method[^]

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

Re: searching an index with FindIndex() method

hpjchobbes10-Jan-07 12:50

hpjchobbes

10-Jan-07 12:50

The MSDN information is what I would read to get the information, as well as some sample code, though I do have some trouble understaing it sometimes. From my understanding (still learning) the FindIndex takes a predicate. The predicate is basically a function that accepts a value of whatever type your list contains, does a calculation, and returns true or false.

So let's say I have a List of INTs. If I wanted to search for the first occurance of a number greater than 5, I would create a function like this:

<br />
public bool IsGreaterThan5(int i)<br />
{<br />
if(i > 5)<br />
   return true;<br />
else<br />
   return false;<br />
}<br />

Then, when I want to find the first instance in my INT list that is greater than 5, I do this.

<br />
int FirstOccurance = myIntList.FindIndex(IsGreaterThan5);<br />

There are also other variations of the FindIndex function that you can use:
List.FindIndex(int32, predicate) - Limits the search range from the int32 element to the end of the list
List.FindIndex(int32, int32, predicate) - Limits the search range from int32 to int32.

Hope that helps!

Re: searching an index with FindIndex() method [modified]

Yustme10-Jan-07 20:49

Yustme

10-Jan-07 20:49

Hi guys,

I've read the msdn library for both code sample of this method and the documentation about it.

But i didn't understand it very well.

I've also searched with google for another example...

This is what i've tried:

// convertedString is an int
int indexOfNumber = this.listViewItems.FindIndex(FindIndexOfListViewItem(convertedString);

private int FindIndexOfListViewItem(int index)
{
for (int i = 0; i < this.listViewItems.Count; i++)
{
string currentItem = this.listViewItems[i].ToString();
//this.number is the item i wanna add as a subItem
if (currentItem == this.number)
{
return i;
}
}

return -1;
}

These are the errors i get:

The best overloaded method match for 'System.Collections.Generic.List<system.windows.forms.listviewitem>.FindIndex(System.Predicate<system.windows.forms.listviewitem>)' has some invalid arguments

Argument '1': cannot convert from 'int' to 'System.Predicate<system.windows.forms.listviewitem>'

What am i doing wrong?

Thanks in advance!
-- modified at 3:26 Thursday 11th January, 2007

Capture video

Yevgeny Efter10-Jan-07 9:55

Yevgeny Efter

10-Jan-07 9:55

Hello!

I would like to capture video from a camera, but I just can't find information about it... I found some articles, but there are no explanations there...

Maybe anybody knows where can I find information about it?

Thanks in advance!

Re: Capture video

Christian Graus10-Jan-07 11:32

Christian Graus

10-Jan-07 11:32

DirectShow is what you need to use. There are articles on it on CP, just do a search.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Re: Capture video

Andrei Ungureanu10-Jan-07 21:02

Andrei Ungureanu

10-Jan-07 21:02

Hi,
You can also search for articles that use avicap32.dll for webcam capture.

Do your best to be the best

Re: Capture video

Yevgeny Efter11-Jan-07 2:06

Yevgeny Efter

11-Jan-07 2:06

Thanks!

Have a nice day!

Read Unstructured PDF FILES In C#

adnanrafiq10-Jan-07 9:34

adnanrafiq

10-Jan-07 9:34

Hi all,

I want to read ustructured pdf documents, how can i do that, any idea will help me to start this project.or any helpful links.

Many Thanks,
adnan

Re: Read Unstructured PDF FILES In C#

Christian Graus10-Jan-07 11:32

Christian Graus

10-Jan-07 11:32

There's code for reading PDFs on sourceforge, and also commercial components you could try

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Microsoft JScript runtime error: 'TV_FilePlan_Data' is undefined

Melissa4118310-Jan-07 9:25

Melissa41183

10-Jan-07 9:25

When i run the web page, most of the time the treeview works fine but sometimes this error pops up:

Microsoft JScript runtime error: 'TV_FilePlan_Data' is undefined

and it asks, "continue or break" it won't let me continue and if i break, i can't edit the code. in the Http://localhost.../default.aspx page.

Please help.

-Melissa

Forms

BlitzPackage10-Jan-07 7:41

BlitzPackage

10-Jan-07 7:41

Good People,

How do I get a form I have added to my project to show? I want it to show in response to a user's button click.

Also, how do I design a form that looks like, for example, the "Exception Assistant" dialog? It doesn't have that heavy blue border/header at the top. Is there some criteria or selection that should be checked or must I code it?

Thank you,
BP

Re: Forms

Christian Graus10-Jan-07 7:44

Christian Graus

10-Jan-07 7:44

BlitzPackage wrote:
How do I get a form I have added to my project to show?

Create an instance of the class and call ShowDialog()

BlitzPackage wrote:
I want it to show in response to a user's button click.

Then you need a click event. Double click on the button in the designer and you'll get one.

BlitzPackage wrote:
It doesn't have that heavy blue border/header at the top.

Change that property in the form designer. I forget it's name, although I always change it ( the default is resizable form and I never want that ) The default also puts an item in the taskbar, I never want that, either. The default is stupid.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: Forms

BlitzPackage10-Jan-07 8:11

BlitzPackage

10-Jan-07 8:11

Thanks Christian,

You'll never believe the error tht kept me from showing the form - I did not create an instance of the class and was trying to call show on the type - LOL!

At any rate, I'm still searching for the feature that will remove the blue border at the top.

Thanks again,
BP

Re: Forms

ndoran10-Jan-07 8:31

ndoran

10-Jan-07 8:31

You can remove the blue border at the top by selecting None for FormBorderStyle in the visual designer. If you don't like the way that looks, there are several other choices.

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