|
thanks for the reply. I have a question maybe you or someone else can help with. Either my sql statement is not correct or something. I keep getting an exception because the catch keeps showing up.
I have a database with a table called Movie and it has fields Information and Title.
I have a test value in there called tony.
thanks for the help.
try
{
string strSQL = "DELETE * FROM Movie WHERE Title = ";
strSQL += searchbox.Text;
oleDbDeleteCommand1.CommandText = strSQL;
oleDbDataAdapter1.DeleteCommand = oleDbDeleteCommand1;
oleDbDeleteCommand1.Connection = oleDbConnection1;
oleDbDeleteCommand1.Connection.Open();
oleDbDeleteCommand1.ExecuteNonQuery();
oleDbDeleteCommand1.Connection.Close();
}
catch
{
MessageBox.Show("Not found");
}
Win32newb
"Making windows programs worse than they already are"
|
|
|
|
|
win32newb wrote:
catch
{
MessageBox.Show("Not found");
}
replace that with:
catch (Exception ex)
{
MessageBox.Show(ex.Tostring());
}
You will get a MUCH better error condition, and if you dont know what to do with it, I'm sure many a person on CP will be able to help 
top secret
|
|
|
|
|
thanks i was wondering how to use that. i'm very new to this c# amazes me i konw this much haha.
anyway i got it working.
try
{
string strSQL = "DELETE FROM Movie WHERE Title = '" + searchbox.Text + "'";
oleDbDeleteCommand1.CommandText = strSQL;
oleDbDataAdapter1.DeleteCommand = oleDbDeleteCommand1;
oleDbDeleteCommand1.Connection = oleDbConnection1;
oleDbDeleteCommand1.Connection.Open();
oleDbDeleteCommand1.ExecuteNonQuery();
oleDbDeleteCommand1.Connection.Close();
}
catch (Exception ex)
{
MessageBox.Show("Not found");
MessageBox.Show(ex.ToString());
}
Win32newb
"Making windows programs worse than they already are"
|
|
|
|
|
Dear Sir,
Ihope that this mail finds you in good shape. Well, the thing is that I am really very depressed and dishearted these days. I am a student doing my BS in Computer Science and next week I've to submit my c# project.
The onle problem I'm facing is that
!! HOW DO WE RUN a FLASH MOVIE in a C#SHARP APPLICATION?
I've tried everything. it gives an error.
Object Reference Not Set To an Instance of an Object.
Any Solutions,
Please send them to me
Truly Yours,
Imad
Imad
|
|
|
|
|
Just reference the FlashActiceX component.
top secret
|
|
|
|
|
The thing is that, I have already imported a Com Control by the name of Shockwave Flash Objects. but as soon as I embed and run this control in my C# Windows Application the .NET Framework Crashes.
Please help me out What should I do?
itsimad@hotmail.com
Imad
Imad
|
|
|
|
|
I am trying to create a binary file but the binarywriter doesnt work and its a pdf so I believe it has to be true binary with no unicode style delimiters. Do I need to write c++ code in my assembly or does c# have a way?
Nick
I'm not an expert yet, but I play one at work. Yeah and here too.
|
|
|
|
|
Ista wrote:
I am trying to create a binary file but the binarywriter doesnt work and its a pdf so I believe it has to be true binary with no unicode style delimiters.
What are your trying to write to a file? What is PDF, I thought u are writing a file. Why unicode appear in a binary file?
Ista wrote:
Do I need to write c++ code in my assembly or does c# have a way?
I think you need to look for Dorothy, the lion and the tin man, perhaps they can tell you.
top secret
|
|
|
|
|
leppie wrote:
I think you need to look for Dorothy, the lion and the tin man, perhaps they can tell you.
A little rough, isn't it? 
- Nick Parker
My Blog | My Articles
|
|
|
|
|
Nick Parker wrote:
A little rough, isn't it?
Not rough enough it appears! 
top secret
|
|
|
|
|
I think dorothy would be of more assistance to you.
pdf is just text written to a binary file. The BinaryWriter writes in unicode which is standard in .net.
And when you write a file in .net it leaves unicode delimiters without special formatting.
Its really a simple question if you read it.
I need to create a binary file. How do you do that in c#. As of current I think c++ is the only way.
And yes the lion is someone with at least an advanced background with an understanding of files which hasn't read my question yet.
Nick
I'm not an expert yet, but I play one at work. Yeah and here too.
|
|
|
|
|
|
And yes the pdf code in which I have written was based on the document downloaded from that page.
and yes it is text file saved as a mac binary format.
If you know how to write a binary file I would really appreciate you telling me. I already know the fundamentals.
thanks,
nick
I'm not an expert yet, but I play one at work. Yeah and here too.
|
|
|
|
|
Ista wrote:
and yes it is text file saved as a mac binary format.
Ahhh, now we getting some where
The problem u have is that the current file contains mac line endings (\r), and these just need to be converted to (\n\r). This could be as easy as using a TextWriter.WriteLine(TextReader.ReadLine()) to go thru the whole file (this works at least for Unix->DOS conversion).
Else you will have to feed the content into a string and replace all the occurances, and save it to a text file (not binary, that is used for saving primitives to a bytestream).
top secret
|
|
|
|
|
yeah basically. So in conclusion you can't create one in .NET unless you use c libraries because of the fact that when streams deserialize they leave meta data thus corrupting the file. You could never get the file to be rid of the delimiters without using C++.
Thanks for the input, but the answer is without the use of unsafe code "no".
Nick
I'm not an expert yet, but I play one at work. Yeah and here too.
|
|
|
|
|
Ista wrote:
You could never get the file to be rid of the delimiters without using C++.
I just said how to do it in C#.
Ista wrote:
So in conclusion you can't create one in .NET unless you use c libraries because of the fact that when streams deserialize they leave meta data thus corrupting the file.
What leads you to this conclusion, it's absurd?
top secret
|
|
|
|
|
Well duh, a stream adds its own formatting at the end. I opted to use ansi c calls in a c++ managed dll.
So if theres an easy way in c# to write a file without creating a stream I know of none.
And besides the conclusion has no fault, seeing that you failed to point one out other than give an absurd answer.
I'm not an expert yet, but I play one at work. Yeah and here too.
|
|
|
|
|
Ista wrote:
Well duh, a stream adds its own formatting at the end.
WTF are u talking about? End of what? Stream is a wrapper around FILE*. You are doing something wrong, and not being specific.
Ista wrote:
And besides the conclusion has no fault, seeing that you failed to point one out other than give an absurd answer.
I have been trying to help you, but you are being the stubborn one.
top secret
|
|
|
|
|
well yeah its a wrapper. But the ofstream class adds about 15 characters to the end of the file when it writes for the serialization format. Create one and look at it, its there.
Either way I created a dll that uses the FILE object to write the file and it works fine.
I'm tired of a conversation in which it keeps stepping back even after a valid answer that started off with a flippant answer and I kept it going with even worse replies.
I answered my question and I don't know of any c# function that actually wraps a FILE object using ansi c calls other than a stream which wraps ofstream which wraps FILE thereby creating metadata at the end of the file.
I appreciate your time, but this topic is deemed useless now.
I'm not an expert yet, but I play one at work. Yeah and here too.
|
|
|
|
|
Ista wrote:
The BinaryWriter writes in unicode which is standard in .net.
Only if you tell it to. It uses UTF-8 as default.
"BinaryWriter Constructor (Stream)
Initializes a new instance of the BinaryWriter class based on the supplied stream and using UTF-8 as the encoding for strings."
Ista wrote:
I'm not an expert yet, but I play one at work. Yeah and here too.
If I was you I would hope your boss dont browse CP...
top secret
|
|
|
|
|
Yes I already know that.
I'm not an expert yet, but I play one at work. Yeah and here too.
|
|
|
|
|
Hi.
I have troubles to change the base type of number, (from integer decimal to hexa. for example).
I have a textbox and a variable with an integer valueand I want to fill the text box with the variable's value but in hexadecimal. How could I do that?.
Thanks.
|
|
|
|
|
|
Hi all,
I am trying to add records to a Access DB. I use the following code to do this. The record gets recorded in the db's but when I read the record back from the database. All fields report nothing. Now heres the clincher. When I go to Access and do a query for that record in Access it still reports nothing even though the record is in table. Now when I cut and paste the record back into same table. wahlah its fine. Am I maybe missing some kind of commit in this code? Any ideas?
<br />
try <br />
{ <br />
<br />
DataSet dsHours = new DataSet(); <br />
System.Data.DataRow drTS; <br />
daHours.TableMappings.Add("Table", "Hours" ); <br />
daHours.Fill(dsHours ,"Hours"); <br />
<br />
drTS = dsHours.Tables["Hours"].NewRow(); <br />
drTS["TSDate"] = dtEndDate.Value; <br />
drTS["EmployeeID"] = tbEmployeeNum.Text.ToString(); <br />
drTS["TSMonReg"] = tbMon.Text.ToString(); <br />
drTS["TSTuesReg"] = tbTues.Text.ToString(); <br />
drTS["TSWedsReg"] = tbWeds.Text.ToString(); <br />
drTS["TSThursReg"] = tbThurs.Text.ToString(); <br />
drTS["TSFriReg"] = tbFri.Text.ToString(); <br />
drTS["TSSatReg"] = tbSat.Text.ToString(); <br />
drTS["TSSunReg"] = tbSun.Text.ToString(); <br />
drTS["TSMonOT"] = tbMonOT.Text.ToString(); <br />
dsHours.Tables["Hours"].Rows.Add(drTS); <br />
<br />
daHours.Update(dsHours); <br />
MessageBox.Show("Record Added Successfully !"); <br />
bUpdateTS.Visible = true; <br />
bAddTS.Visible = false; <br />
} <br />
catch (OleDbException err) <br />
{ <br />
string errorMessage = "Message: " + err.Message + "\n" + <br />
"Source: " + err.Source + "\n" ; <br />
MessageBox.Show(errorMessage,"Error in DataCon"); <br />
} <br />
catch(Exception err) <br />
{ <br />
MessageBox.Show(err.Message,"General Error"); <br />
} <br />
<br />
This is for an insert into the Access DB. I use commandbuilder to build the insert into the Access DB. It automatically generates the insert statement for me. Is it possible to assign my own SQL Insert string to the DataAdapters InsertCommand instead? Or is the one generated by the COmmandbuilder more efficient even though it doesn't work properly? Also how can I check to see what the version is for Jet 4 oledb is? Should I use maybe ODBC connection string to the Access DB instead, maybe more reliable? What do you guys think? How can I tell if I have the latest data drivers for .net?
Thanks,
JJ
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
