|
Hi,
I made an even handler for removed rows in the datagridview.
The datagridview gets its data from an xml file. When a row is removed in the datagridview, the row should be removed in the dataset as well.
This is my event handler in constructor:
this.grdTest.RowsRemoved += new DataGridViewRowsRemovedEventHandler(grdTest_RowsRemoved);
This is the code in that event handler:
void grdTest_RowsRemoved(object sender, DataGridViewRowsRemovedEventArgs e)
{
DataSet ds = new DataSet();
ds.ReadXml("Test.xml");
foreach (DataRow dr in ds.Tables[0].Rows)
{
string remove = dr["Row"].ToString();
DataRow[] temprows = ds.Tables[0].Select("Row = " + remove);
if (temprows[0].RowState == DataRowState.Deleted)
{
ds.Tables[0].Rows.Remove(temprows[0]);
}
//if (dr.RowState == DataRowState.Deleted)
//{
// ds.Tables[0].Rows.Remove(dr);
//}
}
ds.Dispose();
}
This is how the xml file looks like:
<?xml version="1.0" encoding="UTF-8" ?>
- <Root>
- <Column>
<Row>test1</Row>
</Column>
- <Column>
<Row>test2</Row>
</Column>
- <Column>
<Row>test3</Row>
</Column>
- <Column>
<Row>test4</Row>
</Column>
</Root>
When i try to start the proram, it gives me this error:
Cannot fine column [test1].
In this line:
DataRow[] temprows = ds.Tables[0].Select("Row = " + remove);
I've tried almost everything to fix this.
I'm running out of ideas...
Can somebody help me with this problem?
Thanks in advance!
|
|
|
|
|
Which line is the error occurring on? (hint: use the debugger to see this info, or look at the stack trace of the error being thrown)
|
|
|
|
|
Hi,
I posted the line too.
In this line:
DataRow[] temprows = ds.Tables[0].Select("Row = " + remove);
By the way, is this the way to do the thing i wanna do correct?
|
|
|
|
|
Hi
I have a problem of filling null value in the column.
I have written the following query,
select c.column_name,t.constraint_type from all_cons_columns c, user_constraints t where t.table_name=c.table_name and c.table_name='student'
student table
student id - primary key
studentname - varchar
but the oracle query returns only the column having primary or foreign key. not returing the studentname. i want student name also with constraint type=null
we can do this is sql server by isnull(c.constraint_type,'')
but how to do the same in oracle? Any one help me please.........
kesavan
|
|
|
|
|
Since this is a database-specific question, you might want to try asking in the ADO/ADO.NET forum, or optionally, in an Oracle-specific forum.
|
|
|
|
|
Scenario: In general user will take database backup from database server to local system (local copy of database). User perform some changes to his local copy of database based on his requirement. Again user connects back to database server and click on update, local database should update to server database by informing each record status to the user. ex: record 1 updated / call closed do you want to update?
Here local database is going to be Pocket pc database and server database is on SQLDatabase. Can any one suggest best way to implement this feature in Windows Pocket pc, c#. I would appreciate your reply.
Thanks,
|
|
|
|
|
Well, this is not an easy task, I don't think. There are some companies that exist solely to do database synchronization, and they charge a good amount of money to these complicated tasks. Extended Systems, for example, is a company that does database synchronization between different databases, including mobile and server databases.
If you're really interested in doing this yourself, and both mobile database and server databases have the same schema (i.e. same tables, views, etc.) one possibility that comes to mind is you could save each database command you issue. When you go to update the other database, issue those commands against the other database.
I'm not really sure how well that'd work, haven't really thought it through, just an idea. 
|
|
|
|
|
hi, everyone
i have a windows service which is trigerred by a timer to perform certian action(parse a xml file and insert into database).
i used a timer time interval to 1 sec( i cannot increase it)
and then i used getfile(dir) to get all files from directory. what happened is that after avery one sec the same file is updated in the database.
so i am thinking of having a thread which can stop timer and start it self and then before aborting the thread enable the timer again. and during the lifespan of thread perfrom the requierd tass?? is it poosible if yes can u just provide
an algorithm to do it.
thank you
hope to hear soon.
|
|
|
|
|
Hi Justin. I hate your music. 
Can you better describe your problem? You said the same file is updated in the database -- is that a problem? When do you want the file to be updated in the database? Only when it changes?
|
|
|
|
|
I have a JPEG file with the standard tags that i want to show the picture in C#.net. Does .Net support this kind of format? How?
|
|
|
|
|
You should be able to use a PictureBox control for it.
Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon
|
|
|
|
|
I think I couldn't explain my problem in a good way. I mean I have a binary file which contains the information of a jpeg file (with its header and everything). How can I show it in a picture box in C#.NET? I mean how can I convert it to a file with JPG extension in order to be able to assign it to the image property of a picture box?
|
|
|
|
|
Image.FromStream or Image.FromFile will take care of many formats, including JPEG.
Luc Pattyn
|
|
|
|
|
I think I couldn't explain my problem in a good way. I mean I have a binary file which contains the information of a jpeg file (with its header and everything). How can I show it in a picture box in C#.NET? I mean how can I convert it to a file with JPG extension in order to be able to assign it to the image property of a picture box?
|
|
|
|
|
Bitmap bm = new Bitmap(filepath);
should do it. Then, you can assign that bitmap to a picturebox ( which is good for limited showing of bitmaps ), or you can handle your paint event and draw it yourself.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
I think I couldn't explain my problem in a good way. I mean I have a binary file which contains the information of a jpeg file (with its header and everything). How can I show it in a picture box in C#.NET? I mean how can I convert it to a file with JPG extension in order to be able to assign it to the image property of a picture box?
|
|
|
|
|
Hi all !
I have a NHibernate question and really need your help.
i have 2 tables with one-to-many relation like this :
-tblCategories with these fields:
catID int primary key ( reference category field of tblItems)
catName nvachar(30);
catDesc nvarchar(100);
-tblItems with fields
itemID int primary key
category int
itemName nvarchar(50);
itemPrice double;
Now i create a IQuery like this
IQuery q=session.CreateQuery("Select item.ItemID,item.Name,item.Price
from Item as item,Categories as cat
where item.Category.catID = cat.catID and
cat.ID=:_inputID ");
This query executes OK but the problem is that i don't know how to get the result as the datasource of a datagrid ( for example ). Can anyone help me???. I need it very much.
Thanks in advance
Merry chrismas and happy new year!!!
|
|
|
|
|
I don't think too many people here have experience with NHibernate, or at least, not enough experience to solve your problem. Perhaps you should ask this question in an NHibernate-specific forum.
|
|
|
|
|
I am coding my own webbrowser and downloader. From the browser, if I request a download like "www.domain.com/download.aspx?blabla.zip", the browser wants to re-navigate. But I could not get the next URL from "webBrowser1_Navigating" and either from "webBrowser1_FileDownload" eventhandlers. What is the solution of getting the 2nd URLs. Is it possible? I know many of you will say "YES". But I don't know HOW???
Thanks in advance.
hU
|
|
|
|
|
Have a look at this CP article[^] that talks about extending the WebBrowser to include some of the information you require.
|
|
|
|
|
I will describe the situation I have encountered with narrative text. I am working on an application that implements a drag and drop event handler. In the drag and drop event handler, there is a dragOver() event and a paint() event. In the DragOver event there is a refresh() method called that I believe calls the paint event to be called again to repaint the control.
The problem is that the control does not repaint the entire control when the control is dragged. It only repaints the top portion of the control when it is dragged. Is this because the control cannot repaint the amount of area required fast enough before it is redrawn?
How do I get the entire control to be repainted when it is refreshed or invalidated? How would the clipping rectangle or the region properties be utilized to solve this issue? Do I need to break the control up into regions to be repainted so that all of it could be repainted or could the entire control be implemented with a clipping rectangle so that all of it could be repainted? Would appreciate some insights as to how to approach this issue.
-- modified at 20:42 Saturday 23rd December, 2006
|
|
|
|
|
When you call Invalidate, it notifies the control that it should be repainted at the next available time. A call to Update actually stops processing and repaints the control immediately. Typically, Invalidate is the right one to call.
IIRC, the Invalidate method has some overloads that let you specify which region of the control you can redraw. Have you played with those at all?
|
|
|
|
|
hi,
can any1 provide me d code for wave playback and DTMF code identification using TAPI in c#.net.
i will be highly thankful
i need it urgently
pllllllllllaaaaaaaaa help me
Lets hope 4 d best 
|
|
|
|
|
A quick search for "C# TAPI" reveals some possible hits. Have you tried searching?
|
|
|
|
|
yeah i tried but did not find anything help full.
my problem is i can detect and answere incomming call..
i wanna play a wav file and detect d digit pressed by user in response...now m stuck in d code
ITBasicCallControl2 bcc=(TAPI3Lib.ITBasicCallControl2)ici;
ITTerminalSupport ts =(ITTerminalSupport) ia[line];
ITTerminal fpbt = ts.CreateTerminal(TAPI3Lib.TapiConstants.CLSID_String_FilePlaybackTerminal, TAPI3Lib.TapiConstants.TAPIMEDIATYPE_MULTITRACK, TAPI3Lib.TERMINAL_DIRECTION.TD_CAPTURE);
ITMediaPlayback mp = (ITMediaPlayback)fpbt;
object[] audiofile=null;
audiofile[0]=Path.GetDirectoryName(Assembly.GetEntryAssembly().Location) + @"\Welcome.wav";
mp.PlayList=audiofile;
//because it requires objet array.
bcc.SelectTerminalOnCall(fpbt);
TAPI3Lib.ITMediaControl mc=(ITMediaControl)fpbt;
mc.Start();
MessageBox.Show("playing wav file");
//will start playing the audiofile
can anyone pin point d error....
m really woried
plllllllllzzzzzzzzzz help me
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
