Re: query for temporary table - C# Discussion Boards

25-Feb-08 21:16

i have a datatable , i mean a temporary table , which has nothing to do with the sql server 2000 database.
now my question is , how can i filter the records from that temporary table , to filter the records.

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

Xmen Real 25-Feb-08 21:25

25-Feb-08 21:25

use Select() and write you filter, that will return DataRow[]

Code:

DataRow[] Dr = DT.Select("EmpId = 'E999'");

all rows, whose EmpId is equals to E999 will store in Dr

hope this will help

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can

Sonia Gupta25-Feb-08 21:37

25-Feb-08 21:37

is there any need of type casting ?

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

N a v a n e e t h25-Feb-08 21:45

N a v a n e e t h

25-Feb-08 21:45

Select returns an array of DataRow. So type casting is not needed.

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

My Website | Ask smart questions

Sonia Gupta25-Feb-08 21:58

25-Feb-08 21:58

GridView inner = (GridView)e.Row.FindControl("inner");<br />
            DataRowView dro = (DataRowView)e.Row.DataItem;<br />
            if (Session["dt1"] != null)<br />
            {<br />
                if (inner != null)<br />
                {<br />
                    DataTable dt = (DataTable)Session["dt1"];<br />
                    DataRowView drowv = (DataRowView)e.Row.DataItem;<br />
                    DataRow[] dr = (DataRow[])dt.Select("No=" + dro.Row.ItemArray.GetValue(0).ToString());<br />
                    inner.DataSource = dr;<br />
                    inner.DataBind();<br />
                }<br />
            }

Am i doing right to bind the data ?

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

N a v a n e e t h25-Feb-08 22:10

N a v a n e e t h

25-Feb-08 22:10

Sonia Gupta wrote:
(DataRow[])dt.Select("No=" + dro.Row.ItemArray.GetValue(0).ToString());

dt.Select("No=" + dro.Row.ItemArray.GetValue(0).ToString());

I think casting is not needed

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

My Website | Ask smart questions

Sonia Gupta25-Feb-08 22:20

25-Feb-08 22:20

stll there is an error
DataBinding: 'System.Data.DataRow' does not contain a property with the name 'Itemno'.
this column name exist in the table.

Following is the code

<br />
GridView inner = (GridView)e.Row.FindControl("inner");<br />
            DataRowView dro = (DataRowView)e.Row.DataItem;<br />
            if (Session["dt1"] != null)<br />
            {<br />
                if (inner != null)<br />
                {<br />
                    DataTable dt = (DataTable)Session["dt1"];<br />
                    DataRowView drowv = (DataRowView)e.Row.DataItem;<br />
                    DataRow[] dr = dt.Select("No=" + dro.Row.ItemArray.GetValue(0).ToString());<br />
                    inner.DataSource = dr;<br />
                    inner.DataBind();<br />
                }<br />
            }

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

Christian Graus25-Feb-08 23:12

Christian Graus

25-Feb-08 23:12

You don't use a property called 'Itemno' in this code. Did you try using a debugger ? Do you know which line has the error ? I doubt it's one of these...

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Xmen Real 25-Feb-08 22:06

25-Feb-08 22:06

casting may require for columns, but for rows you wont need it

Copy to ClipBoard

D i x y25-Feb-08 21:11

D i x y

25-Feb-08 21:11

Hello Friends,
I am developing an Windows application in C#.NET and i have Panel controls on the form in this panel there are some other controls i want that when ever i click on copy button then the panel control will get copied along with it control and whenever i paste it on MS word document then it comes in image or clip format.

Re: Copy to ClipBoard

Xmen Real 25-Feb-08 21:18

Control Combobox on datagrid

25-Feb-08 21:18

can you display the code?

Re: Copy to ClipBoard

D i x y25-Feb-08 21:21

D i x y

25-Feb-08 21:21

IDataObject iData = System.Windows.Forms.Clipboard.GetDataObject();
Clipboard.SetDataObject(panel1.Controls);

Re: Copy to ClipBoard

Christian Graus25-Feb-08 21:32

Christian Graus

25-Feb-08 21:32

You can use the DrawToBitmap method on your panel, and then copy your bitmap into the clipboard. Copying a control into the clipboard, copies the control. Not a picture of it.

dungbt25-Feb-08 20:40

Re: Control Combobox on datagrid [modified]

25-Feb-08 20:40

Hi everybody
I have a combobox on a cell of datagrid
I want do a action flow:
After I chose a value for combobox, I press enter, the cursor have to jump to next cell.
Please help me soon,
Sorry if I write not exactly
If you can please write me a email to dungbt84@gmail.com
Thank you a lot,

Xmen Real 25-Feb-08 20:49

25-Feb-08 20:49

use CellEndEdit or CellValueChanged event, and increase the column index

private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            int Cindex = e.ColumnIndex + 1;
            dataGridView1[Cindex, e.RowIndex].Selected = true;
        }

hope this will help

modified on Tuesday, February 26, 2008 3:16 AM

dungbt25-Feb-08 21:17

25-Feb-08 21:17

thank you for your help but I can't use.
My problem flow:
I have to create a datagrid(for example 5 columns and 3 rows).
If my cursor is at [0,0].When I press enter my cursor jump to [3,0], press enter next it jump to [4,0].
(columns 4 include the comboboxs). After I chose value at combobox. I press enter, the curtor jumb immediate to [1,0].
I think it is so difficult, please help me!
Thank you again,

Xmen Real 25-Feb-08 21:50

25-Feb-08 21:50

so you will need to code yourself, like
if (e.ColumnIndex == 0)
{
}
else if (e.ColumnIndex == 3)
{
}
.........

dungbt25-Feb-08 22:43

25-Feb-08 22:43

I can't do as you said.
Please try to help me again.

Xmen Real 25-Feb-08 22:56

25-Feb-08 22:56

well,

if (e.ColumnIndex == 0)
   DGV[3, e.RowIndex].Selected = true;
else if (e.ColumnIndex == 3)
   DGV[4, e.RowIndex].Selected = true;
else if (e.ColumnIndex == 4)
   DGV[1, e.RowIndex].Selected = true;

hope this will help

dungbt26-Feb-08 19:31

26-Feb-08 19:31

C# default that if you press enter the cursor jump down. So I can't do like as you said.
I think I have to change control. But I can't.
Please help me!
Thz,

Xmen Real 26-Feb-08 21:27

26-Feb-08 21:27

why you cant do????? if you do then it will work else wont and never

i gave you entire code that you need, just put them in CellValueChanged or CellEndEdit event

dungbt26-Feb-08 21:34

26-Feb-08 21:34

I have to override protected bool ProcessCmdKey(ref System.Windows.Forms.Message msg, System.Windows.Forms.Keys keyData) and use sendkey method.
I finished this problem
Thz you a lot,

Xmen Real 26-Feb-08 21:38