Re: query: Oledb database and a BindingList - C# Discussion Boards

Re: Problem in retreiving Methods of current class using Reflection

Christian Graus7-Jun-07 1:50

Christian Graus

7-Jun-07 1:50

But members of the base ARE members of the current class, by definition ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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: Problem in retreiving Methods of current class using Reflection

leppie7-Jun-07 2:27

leppie

7-Jun-07 2:27

You have to at least specify Instance or Static and Public or NonPublic for BindingFlags.

A better way to get the type would be to do: Type type = typeof(MyClass);

xacc.ide-0.2.0.57 - now with C# 2.0 parser and seamless VS2005 solution support!

Re: Problem in retreiving Methods of current class using Reflection

Brady Kelly7-Jun-07 3:19

Brady Kelly

7-Jun-07 3:19

He's iterating all types, so doesn't have a MyClass to look at.

Re: Problem in retreiving Methods of current class using Reflection

szukuro7-Jun-07 4:20

szukuro

7-Jun-07 4:20

Well there's always the cumbersome but at least functional option of getting all methods of the class, then getting the methods of its base type and the result will compose of the methods that only appear in the former array.

query: Oledb database and a BindingList

sharp source7-Jun-07 1:29

sharp source

7-Jun-07 1:29

goal:
Display all records from a specified table in a Visual Foxpro database in a DGV.
This would not be a problem, except, i only want those rows which have a record id contained by a BindingList<string> TableId

I've tried this:

OledbConnection = new OleDbConnection(connectionString);<br />
OledbCommand = new OleDbCommand(query,connection);<br />
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connection);<br />
<br />
<br />
foreach(string id in TableId)<br />
{<br />
     query = "SELECT * FROM " + tableName + " WHERE (" + tableRecordIDColumn + " = '" + id + "') ORDER BY " + tableRecordIDColumn;<br />
     command.CommandText = query;<br />
     dataAdapter.SelectCommand = command;<br />
     dataAdapter.Fill(dataTableFromDb);<br />
}<br />
bindingSource1.DataSource = dataTableFromDb;<br />
dataGridView1.AutoGenerateColumns = true;<br />
dataGridView1.DataSource = bindingSource1;

Allthough this works, it's extremely slow. Especially since my BindingList<string> TableId could contain 20 000 record id's.

Would there be any way to create a dataset with two tables on wich i could excecute a select query wich an inner join on the record id's??

And then use the results as the DataGridView.DataSource?

grts, thx

Re: query: Oledb database and a BindingList [modified]

AikinX7-Jun-07 3:06

AikinX

7-Jun-07 3:06

sharp source, the problem is: you do to many connections to DB.
I can propose two different solutions:
1) We can include all of this in one SQL:
'OR' version:

<br />
            string queryCondition = "";<br />
            foreach (string id in TableId)<br />
            {<br />
                queryCondition += tableRecordIDColumn + " = '" + id + "' OR ";<br />
            }<br />
            // We need to cat ' OR ' from the end of the string (4 letters)<br />
            if (queryCondition != "") queryCondition = queryCondition.Remove(queryCondition.Length - 4);<br />
<br />
            string query = "SELECT * FROM " + tableName + " WHERE (" + queryCondition + "') ORDER BY " + tableRecordIDColumn;<br />

'In' version:

<br />
            string queryCondition = "";<br />
            foreach (string id in TableId)<br />
            {<br />
                queryCondition += "'" + id + "', ";<br />
            }<br />
            // We need to cat ', ' from the end of the string (2 letters)<br />
            if (queryCondition != "") queryCondition = queryCondition.Remove(queryCondition.Length - 2);<br />
<br />
            queryCondition = tableRecordIDColumn + " in (" + queryCondition + ")";<br />
<br />
            string query = "SELECT * FROM " + tableName + " WHERE (" + queryCondition + "') ORDER BY " + tableRecordIDColumn;<br />

Remark: You can get an exception like "the query is too long" (because of 2000 OMG | :OMG:

entries). You can split them to 100th packs, for example

2) Restricting the logic of data getting (I think it is better)
I think you can find an way to get more simple selecting condition

>>Would there be any way to create a dataset with two tables on wich i could excecute a select query wich an inner join on the record id's??
You can. You can load all data to data. Then you just need to filter the data by using BindingSource class. But this solution is valid when you have to filter data many times per minute.

-- modified at 9:13 Thursday 7th June, 2007

Re: query: Oledb database and a BindingList

sharp source7-Jun-07 3:35

sharp source

7-Jun-07 3:35

Your 2 first suggestions i allready tried. And as you say, i need to limit the data getting.
Btw, it's not 2000 but 20 000 WTF | :WTF:

rows....

So restricting the logic of data getting.
How would i do that?
So i create a dataset
Add two DataTables
OledbDataAdapter.Fill(DataTable1);

How do i get the BindingList<string> TableId into a table?

And after I have a dataset with the two tables... I gues i can figure that out.

Thx

Re: query: Oledb database and a BindingList

AikinX7-Jun-07 4:20

AikinX

7-Jun-07 4:20

>> And as you say, i need to limit the data getting.
Do you want to get a code with splitting by 1000 (for example) Ids?

>> So restricting the logic of data getting.
I meant "restructuring", sorry. So change the logic of the app. To group some ID into groups...
I need to see you task to give you more ideas.

>> How do i get the BindingList TableId into a table?
>>And after I have a dataset with the two tables... I gues i can figure that out.
No, you will have one table with full data in it.
But you will display only necessary information.
To do that you have to bind you table to DataGridView (for example) through BindingSource:

<br />
            BindingSource bs = new BindingSource(someDataSet, "SomeMember");<br />
            someDataGridView.DataSource = bs;<br />
<br />
<br />
<br />
            // then in an other place you can filter: Filter condition, like: <br />
            bs.Filter = "SomeColumn = 'id1' OR SomeColumn = 'id2' OR ..... ";<br />

create dynamic text boxes

tauras817-Jun-07 0:51

tauras81

7-Jun-07 0:51

how to create dynamic text boxes in c#.net

Re: create dynamic text boxes

Sathesh Sakthivel7-Jun-07 1:01

Sathesh Sakthivel

7-Jun-07 1:01

Get it[^]

Regards,

Satips. Rose | [Rose]

Re: create dynamic text boxes [modified]

Chintan.Desai7-Jun-07 1:41

Chintan.Desai

7-Jun-07 1:41

Textbox txt=new Textbox();
Controls.Add(txt);
txt.show();//it wud display txt at top-left corner of the form
Rose | [Rose]

-- modified at 8:11 Thursday 7th June, 2007

Regards
Chintan
www.visharadsoft.com
(Nothing is so purify as KNOWLEDGE)

Re: create dynamic text boxes

AikinX7-Jun-07 2:29

AikinX

7-Jun-07 2:29

There is no reason to call method show.
Any control is shown up on the form at time it has been added to form's component container
P.S. Chintan.Desai, there were many syntax mistakes in you post

Re: create dynamic text boxes

AikinX7-Jun-07 2:24

AikinX

7-Jun-07 2:24

What did you mean: "dynamic text boxes"?
May be you wanted to say how to create text boxes dynamically?

There is the solution:

<br />
        private void Form1_Load(object sender, EventArgs e)<br />
        {<br />
            TextBox myDynamicTextbox = new TextBox();<br />
            myDynamicTextbox.Size = new Size(100, 20);<br />
            myDynamicTextbox.Location = new System.Drawing.Point(10, 10);<br />
<br />
            this.Controls.Add(myDynamicTextbox);<br />
        }<br />

Hello Is there is away to convert GraphicsPath to Image ?

Epsilone37-Jun-07 0:36

Epsilone3

7-Jun-07 0:36

Thank for the replay.

Re: Hello Is there is away to convert GraphicsPath to Image ?

szukuro7-Jun-07 1:50

szukuro

7-Jun-07 1:50

The trick is to use a Graphics object obtained from the Image and use that for drawing.

GraphicsPath gp = new GraphicsPath();
// Construct the path
Bitmap bmp = new Bitmap(200, 200);
using (Graphics g = Graphics.FromImage(bmp))
{
    System.Drawing.Pen pen = System.Drawing.SystemPens.InfoText;
    g.DrawPath(pen, gp);
}

USB Scanner and keyboard

AmitG777-Jun-07 0:29

AmitG77

7-Jun-07 0:29

I'm attempting to set up a text input field so that keyboard entry is rejected, but barcode scanner via usb is accepted. How can I programmatically distinguish between the keyboard and a USB based bar code scanner?

Re: USB Scanner and keyboard

Dave Kreskowiak7-Jun-07 4:25

Dave Kreskowiak

7-Jun-07 4:25

Most of the time, a barcode scanner will supply the data it scans as keystrokes. There's no way to tell the difference between the two.

If the barcode scanner exposes an API, you'd have a much easier time with this since you get the data from the API.

But, disabling keyboard input on this field is a bad idea. What does the user do if the barcode scanner fails?? Big Grin | :-D

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

System.EventHandler

Muammar©7-Jun-07 0:17

Muammar©

7-Jun-07 0:17

private void nPic_MouseDown(object sender, MouseEventArgs e)
{
    MessageBox.Show("ok");
}

private void pnlMap_MouseClick(object sender, MouseEventArgs e)
{
        nPic = new PictureBox();
        nPic.Name = "test"

this.nPic.MouseDown += new System.EventHandler(this.nPic_MouseDown);
}