|
thanks for reply
my question is how to sql server implement this technique for display loaded data and loading other data at the same time ?
thanks
|
|
|
|
|
Hi,
I'm using a property grid to update some settings that are stored in my database.
PropertiesControl.OnPropertyValueChanged; 'CurrentDirectory' has been changed.<br />
SqlStatements.Update; Formatted SQL == UPDATE MetaData SET Value = '/sadasd' WHERE Name = 'CurrentDirectory';<br />
DbConnection.ExecuteNonQuery; Performing SQL.<br />
DbConnection.OnStateChange; Connection State Change: Open<br />
A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll<br />
DbConnection.ExecuteNonQuery; Exception: System.Data.OleDb.OleDbException: Syntax error in UPDATE statement.<br />
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)<br />
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)<br />
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)<br />
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)<br />
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()<br />
at UNet.Server.Database.DbConnection.ExecuteNonQuery(String sql) in D:\DbConnection.cs:line 153<br />
DbConnection.OnStateChange; Connection State Change: Closed
I cant see whats wrong. The table is correct, both the values are strings and the sql seems fine to me.
Any ideas?
Regards,
Gareth
|
|
|
|
|
Is MetaData a keyword? Should it be surrounded with [] or something? Maybe you should choose a different name for your table?
|
|
|
|
|
Hi PIEBALDconsult,
I dont think its the table name as i can insert values into it.
Regards,
Gareth.
|
|
|
|
|
Value is a reserved keyword. Rename the field in the table, or if that is not possible, put brackets around the name: [Value].
Experience is the sum of all the mistakes you have done.
modified on Sunday, January 06, 2008 3:19:33 PM
|
|
|
|
|
Hi Guffa,
Thanks, that worked.
Regards,
Gareth
|
|
|
|
|
Hello,
Is it safe to develop windows application with MS Access Database now as I am thinking, Windows Vista and other future versions may not support MS Access ? If I develop MS Access based windows application and I have Office 2003 installed in my machine, do my customers need Office 2003 to run my ACCESS based windows application or they can have any office version installed like MS office 2007 or do they need to have office at all ?
Regards
|
|
|
|
|
bashiwala wrote: Is it safe to develop windows application with MS Access Database now as I am thinking, Windows Vista and other future versions may not support MS Access ?
Can't think why not. What has lead you to think this?
bashiwala wrote: If I develop MS Access based windows application and I have Office 2003 installed in my machine, do my customers need Office 2003 to run my ACCESS based windows application or they can have any office version installed like MS office 2007 or do they need to have office at all ?
Assuming that you are developing your Windows application in .NET and only using Access as a data store, your users don't need Office installed on their PCs.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi,
thanks for your reply. Actually I read an article and it was said that, using MS Access for data storage by applications is discouraged by Microsoft, rather microsoft encourage to use SQL Server Express instead. But I found MS Access is more convenient because my user dont need to install SQL Server. Anyway, thanks for answering me, now I am comfortable to use ACCESS.
Moreover, it is a good news indeed that my user dont need MS office installed in order to run windows application that uses MS Access. Before I though negative.
Regards.
|
|
|
|
|
|
Hi,
I am a .NET developer and I have developed my products using C#.NET 2.0 (.NET framework 2.0). I am using Visual Studio 2005. Now, I am seeing that new Visual Studio 2008 has taken place of VS2005, .NET 3.5 is here. I am worried, do I really need to go for update my development environment for .NET 3.5 and VS 2008 in order to suit my products in my future customer's PC who are running Windows VISTA ? Moreover, If I dont update now, will I stay very backdated ? I learned .NET 2.0 and I am very much comfortable about it, but This new and new versions of VS and .NET coming up which is making me frustrated that, I will have to run and run all the time for updating myself. My question to you all Gurus, Is it very required to update or I can still stay with .NET 2.0 ?
Recently, I visited ASP.NET website and I found another new things, SilverLite, now I feel that, I will have to learn SilverLite too ? few days ago I updated my web applications with latest ASP.NET Ajax, now new and new things....
I would appreciate your response.
Regards.
|
|
|
|
|
Of course not. Vista was working with 2.0 and continues to. In fact, you can build 2.0 apps with 2008.
bashiwala wrote: Moreover, If I dont update now, will I stay very backdated
You will not learn the new language features until you update, but how important that is, is up to you.
bashiwala wrote: I will have to run and run all the time for updating myself
You must be new. The life of a software dev is always like that, get used to it.
bashiwala wrote: few days ago I updated my web applications with latest ASP.NET Ajax, now new and new things....
Just because something exists, doesn't mean you need to use it, and it sure doesn't mean your existing apps need to use it. ASP.NET AJAX is not that great, I'd prefer just to use AJAX by hand.
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 )
|
|
|
|
|
Thank you sooo much for giving me positive hopes.
|
|
|
|
|
hi .. i am able to view picture for this
pictureBox1.Image = Image.FromFile(Application.StartupPath + @"\Picture\" + textBox1.Text);
but when i do that in wpf .. i cant write Application.StartupPath..... no such word startupPath for me to choose..
also no such pictureBox1.Image
below is c# code which last time i did.. no problem..
<br />
private void ShowPhoto()<br />
{<br />
if (!textBox1.Text.Equals(""))<br />
{<br />
try<br />
{<br />
pictureBox1.Image = Image.FromFile(Application.StartupPath + @"\Picture\" + textBox1.Text);<br />
<br />
}<br />
<br />
catch (Exception ex)<br />
{<br />
MessageBox.Show(ex.Message, "Error Loading Photo", MessageBoxButtons.OK, MessageBoxIcon.Error);<br />
}<br />
}<br />
<br />
}
modified on Saturday, January 05, 2008 10:28:56 PM
|
|
|
|
|
WPF is ridiculous ( and very buggy ). You need to use reflection to get the startup path of the application. Image.FromFile isn't going to work either, you need to use the WFP classes that represent an image.
I recommend buying a WPF book, nothing you know from WinForms is going to help you much.
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 )
|
|
|
|
|
hi .. if i have a few textbox with value... e.g. address, postcode..
how do i click on a button and bring those value to microsoft word document...
as printed
address
postcode(new line)
country(new line)
|
|
|
|
|
|
thanks.. i followed that way.. one question here
the below with bold ..( data cannot be displayed all.. only display the last one.. it has been overwrite.. how do i display it all..
private void contact_writeletter_Click(object sender, RoutedEventArgs e)
{
object oMissing = System.Reflection.Missing.Value;
object oEndOfDoc = "\\endofdoc"; /* \endofdoc is a predefined bookmark */
//Start Word and create a new document.
Word._Application oWord;
Word._Document oDoc;
oWord = new Word.Application();
oWord.Visible = true;
oDoc = oWord.Documents.Add(ref oMissing, ref oMissing,
ref oMissing, ref oMissing);
//Insert a paragraph at the beginning of the document.
Word.Paragraph oPara1;
oPara1 = oDoc.Content.Paragraphs.Add(ref oMissing);
oPara1.Range.Text = contact_name.Text;
oPara1.Range.Text = contact_address_home.Text;
oPara1.Range.Text = contact_country.Text;
oPara1.Range.Text = contact_postcode.Text;
oPara1.Range.Text = string.Format(DateTime.Now.ToShortDateString());
oPara1.Range.Font.Bold = 1;
oPara1.Format.SpaceAfter = 24; //24 pt spacing after paragraph.
oPara1.Range.InsertParagraphAfter();
|
|
|
|
|
I'm not 100% sure about your question - what I think you're saying is only the Date is showing up.
If this is so it's because it looks like each line you have in bold is replacing Range.Text with a new value where you should be appending to it instead. What if you try something like this:
string contactInfo =
contact_name.Text + Environment.NewLine +
contact_address_home.Text + Environment.NewLine +
contact_country.Text + Environment.NewLine +
contact_postcode.Text + Environment.NewLine +
string.Format(DateTime.Now.ToShortDateString());
oPara1.Range.Text = contactInfo;
instead?
|
|
|
|
|
In Visual C++ programing, we can change the icon of the EXE file.Is it possible to change the icon of a window form program's EXE in C#? if it is then i will be grateful if anyone tell me about it...
waiting....
|
|
|
|
|
Try googling around 
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
Some comments on applications and icons:
1.
An application typically has two different icons:
- the application itself has an icon at the file level; it gets used by Windows Explorer;
you set it as a project property.
- any form can have an icon; it is a Form property, that you can set through Visual
Designer. It also shows up in the task bar's button (if the Form shows in task bar).
2.
an icon file can hold multiple icons (icons at different sizes), and Windows will pick
one depending on circumstances, so if they do not all look alike, you may get very
confused.
3.
I tend to create icons programmatically; the following code converts a (best small, square) image into a simple icon:
string filename=popupNode.getLongName();
try {
Bitmap bm=(Bitmap)Image.FromFile(filename);
if(bm.Width!=32 || bm.Height!=32) {
bm=new Bitmap(bm, 32, 32);
}
Icon icon=Icon.FromHandle(bm.GetHicon());
bm.Dispose();
string filename2=Path.ChangeExtension(filename, ".ico");
Stream stream=new FileStream(filename2, FileMode.Create);
icon.Save(stream);
env.output("Created icon "+filename2);
} catch(Exception exc) {
env.output("Failed to create icon from "+filename);
env.log(exc);
}
Hope this helps.
|
|
|
|
|
Thnxx for sharing this precious info!
But the fact is i ve changed the form icon as u mentioned i guess.Now i want to change that exe file icon. say in the debug there is a exe file named "dark.exe".This file has its typical exe icon.you know which is common for windows! tht window like. Now as in visual C++ we can change exe file icon to any icon file we want or can convert a bitmap to icon file like you ve posted the code for it.There is already option for tht in the IDE.
If there is an option present in C# IDE(i m using Visual Studio 2005 by the way) then i ll be glad if you tell me if u know already!
or other method ....
|
|
|
|
|
Hi,
the app's exe icon is a project property, hence right click the project in the
solution pane, choose application tab, and specify the icon file/resource there.
|
|
|
|
|
Just look in the properties pages for the project. If you want to embed multiple icons into the executable which are viewable by Windows then might I suggest taking a look at my article[^].
Shameless self-publicising but hey...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
