Add data in gridview from multiple tables and combobox [modified] - C# Discussion Boards

Re: Add data in gridview from multiple tables and combobox

12-Mar-09 14:06

Hi,
Basically i am trying to make a combobox in 2nd row of gridview...

two issues in below function:
Two things:
1. Now adapter2 is populated in gridview and i do not see any combobox instead i see only columns from adapter2

2. I do not see the adapter1 filled at all???

void fillData()
{
database = new OleDbConnection(connectionString);
database.Open();
OleDbDataAdapter adapter1 = new OleDbDataAdapter("select BillD.ProductName,BillD.ProductID,BillD.Saletype,BillD.InQty,BillD.SBtype,BillD.Dis1,BillD.Type,BillD.InPrice from BillDetails BillD", database);
OleDbDataAdapter adapter2 = new OleDbDataAdapter("Select Products.ProdID,Products.ProductName,Packing.PackingName from Packing INNER JOIN Products ON Packing.PackingID=Products.Packing", database);

{
DataGridViewComboBoxColumn dgridcolumn = new DataGridViewComboBoxColumn();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataTable packDT = new DataTable();
adapter1.Fill(dt);
dataGridView1.DataSource = dt;
adapter2.Fill(packDT);
ds.Tables.Add(packDT);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = ds.Tables[0].TableName;
dgridcolumn.DataSource = ds.Tables[0];
dgridcolumn.ValueMember = ds.Tables[0].Columns[1].ColumnName.ToString();
}
}

Thanks,

Please help

modified on Friday, March 13, 2009 4:51 AM

haroon198012-Mar-09 22:52

Add combox in gridview - Getting OledbException

12-Mar-09 22:52

Any help pls

haroon198012-Mar-09 13:19

Re: Add combox in gridview - Getting OledbException

12-Mar-09 13:19

Hi,
I get Oledb Exception:"No value given for one or more required parameters." at line below

adapter2.Fill(packDT); // error here on this line

Basically i am trying to make a combobox in 2nd row of gridview..

Also one more thing i need to add to my above post..that i need to select some columns from one table and then in one of the column of the gridview i need to add combobox in gridview...

OleDbDataAdapter adapter1 = new OleDbDataAdapter("select BillD.ProductName,BillD.ProductID,BillD.Saletype,BillD.InQty,BillD.SBtype,BillD.Dis1,BillD.Type,BillD.InPrice from BillDetails BillD", database);

OleDbDataAdapter adapter2 = new OleDbDataAdapter("Select P.ProductName,P.ProductID,Packing.PackingName from Packing INNER JOIN Products ON Packing.PackingID=Products.Packing", database);

void fillData()
        {
            database = new OleDbConnection(connectionS :( :confused:tring);
            database.Open();
            OleDbDataAdapter adapter1 = new OleDbDataAdapter("select BillD.ProductName,BillD.ProductID,BillD.Saletype,BillD.InQty,BillD.SBtype,BillD.Dis1,BillD.Type,BillD.InPrice from BillDetails BillD", database);
            OleDbDataAdapter adapter2 = new OleDbDataAdapter("Select P.ProductName,P.ProductID,Packing.PackingName from Packing INNER JOIN Products ON Packing.PackingID=Products.Packing", database);
 
            {
                DataGridViewComboBoxColumn dgridcolumn = new DataGridViewComboBoxColumn();
                DataSet ds = new DataSet();
                DataTable dt = new DataTable();
                DataTable packDT = new DataTable();
                adapter1.Fill(dt);
                dataGridView1.DataSource = dt;
                adapter2.Fill(packDT); // error here on this line
                ds.Tables.Add(packDT);
                dataGridView1.DataSource = ds;
                dataGridView1.DataMember = ds.Tables[0].TableName;
                dgridcolumn.DataSource = ds.Tables[0];
                dgridcolumn.ValueMember = ds.Tables[0].Columns[1].ColumnName.ToString();
 
 
            }

Thanks,

please help

haroon198012-Mar-09 14:02

Is it possible to receive key input into two controls simultaneously?

12-Mar-09 14:02

sorry i am not getting exception as i fixed it bec of a pb in sql query...

Yellow_Yackets12-Mar-09 11:26

Re: Is it possible to receive key input into two controls simultaneously?

12-Mar-09 11:26

Hello,

I am creating a text editor that supports 'word completion'. I already figured how to put the 'word completion list box' at the position (caret position) where the user is currently typing. My question is: how can I make the 'word completion list box' be edited while the user is typing the word?

A much better descriptive question is: How can I make two text-box receive key input at the same time? Meaning that if I press 'A' the word 'A' should appear in bot text-boxes at the same time.

Also, is there a way to exempt a key input from being processed. The thing is that: when the user press enter to select a word from the 'word completion list box', the caret is placed at the next line. Instead of doing that, if the 'word completion list box' is open and the user press enter, the selected word should replace and the caret should not be taken to the next line.

Is there a way to make such thing?

Nagy Vilmos12-Mar-09 11:52

Re: Is it possible to receive key input into two controls simultaneously?

12-Mar-09 11:52

Rephrase your question and you kind of get there:
Is there a way to have two update two controls based on a single key press

You'll find that is the way to think and the answer will become apparent. Go on, have a try!

Panic, Chaos, Destruction.
My work here is done.

Yellow_Yackets12-Mar-09 11:57

Re: Is it possible to receive key input into two controls simultaneously?

12-Mar-09 11:57

Sorry men., But I tried that but it doesn't work.

when I tried this:

public Form1()
        {
            InitializeComponent();
        }

        private void tectbox_keypress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == (char)Keys.Return)
            {
                string enter = "<enter>";
                richTextBox1.Text += enter;
                richTextBox1.SelectionStart = richTextBox1.Text.Length - enter.Length;
                e.Handled = true;
            }
            else
            {
                listBox1.Text += e.KeyChar;
            }
        }

        private void listbox_keypress(object sender, KeyPressEventArgs e)
        {

        }</enter>

The caret of the text-box still goes to the next line and the items of the list-box aren't selected while I type in the text-box... Is there something that i'm missing???

Nagy Vilmos12-Mar-09 12:09

Re: Is it possible to receive key input into two controls simultaneously?

12-Mar-09 12:09

I'm guessing you want the listbox to go to the relevant entry, yesno?
listBox1 does not have the focus and so will not raise a keypress event. This is what I said to start with, they all need to change based on the single event rather then a single event being passed to each control.
You probably need to mimick a bit more, try looking at what happens when the value changes, what is the event you are getting?

[I'll push you in the right direction, but I won't write your code. sorry.]

Panic, Chaos, Destruction.
My work here is done.

Yellow_Yackets12-Mar-09 15:22

Re: Is it possible to receive key input into two controls simultaneously?

12-Mar-09 15:22

Yeah very nice... I like your game... Althought I don't quiet get when you say "they all need to change based on the single event rather then a single event being passed to each control". Yu mean create a single event handler that holds both controls?
Plus I kinda don't know what to respond on "what is the event you are getting?" Maybe keypress? or keyup??? I used keypress but sounds like there is a better event that I should be using?

Yellow_Yackets12-Mar-09 15:40

Re: Is it possible to receive key input into two controls simultaneously?

12-Mar-09 15:40

OK..., make sense to create a single event that holds each control...
But I don't see it clear on how can I make the list-box be selected without being focused...? mmmm... I'll keep trying...

Nagy Vilmos12-Mar-09 23:09

Re: Is it possible to receive key input into two controls simultaneously?

12-Mar-09 23:09

Here's the outline:

// catch key presses on the text box:
private void textBox_KeyPress(object sender, KeyPressEventArgs e)
{
    if (!e.KeyChar.Equals(Keys.Enter))
    {
        // update ListItem being shown();
    }
    else if (listBox.SelectedIndex != -1)
    {
        // update Rich Text From List
    }
    else
    {
        // update Rich Text From text
    }
}

// user clicks the list:
private void listBox_DoubleClick(object sender, EventArgs e)
{
    // update Rich Text From List
}

Each piece should be in a private method, don't polute the event handlers.

Panic, Chaos, Destruction.
My work here is done.

Yellow_Yackets13-Mar-09 7:10

Splitting video into frames

13-Mar-09 7:10

Make sense to do that. Thanks to the clue that you gave me I figure that it is possible to share a event method with two or more controls. (didn't know that before). I also figured how to select the list-box items by typing in the text-box.

The only thing is, I dunno how to stop a key-command from doing its job. For example: if I press the space bar while typing on the text-box a space will be added to the text-box. Is it possible to cancel that command and when I press the space bar no space will be added?

The C# book that I have doesn't talk about it and my search in Google isn't lucky... Frown | :(

Payam Rastogi12-Mar-09 10:25

Payam Rastogi

12-Mar-09 10:25

Hi I want to know that how to divide video files into its constituent frames using c#.net

Re: Splitting video into frames

Ravadre12-Mar-09 11:37

Ravadre

12-Mar-09 11:37

If I understand you correctly, you should check out DirectShow.NET which is managed wrapper, you can then create graph with some frame grabber and "run" it.

join pieces in an image

Umangj12-Mar-09 9:54

Umangj

12-Mar-09 9:54

heyyy pls help me...
i need to join these puzzle pieces in an image.....
the gap in b/w the pieces is the transparent color where alpha component of the pixel is 0,
for example:

i need to change an image from this:
http://www.freeimagehosting.net/uploads/th.61647e9923.jpg

to this:
http://www.freeimagehosting.net/uploads/th.11322f3595.jpg

Re: join pieces in an image

Nagy Vilmos12-Mar-09 10:00

Re: join pieces in an image

12-Mar-09 10:00

First up learn where the shift key is, it will help you.
Secondly you haven't actually asked a question.

I can infer from your message that you can't work out how to do this. But what I am not sure is if this is due to not understanding a nuance of c# that has caused you to go in circles with an implimentation problem or because you are thick.

Please can you let us know!

Panic, Chaos, Destruction.
My work here is done.

Umangj12-Mar-09 10:07

Umangj

12-Mar-09 10:07

For You:

I just want to know how should i move the pixels so tht transparency between the pieces is gone.I have tried shifting the pixels row by row and also column by column but that is not working.... jus tell me any other way to do this....

Re: join pieces in an image

Nagy Vilmos12-Mar-09 11:00