|
Please help me.
I use the SHSetFolderPath function to Assigns a new path to a system folder through its CSIDL.But it return fail.The source code as follow:
HRESULT hr = NULL;
HINSTANCE hLib = NULL;
typedef HRESULT (WINAPI *SHSetFolderPath(int,HANDLE,DWORD,WCHAR*);
hLib = LoadLibrary("shell32.dll");
if(hLib)
{
SHSetFolderPath lpfSHSetFolderPath;
lpfSHSetFolderPath = (SHSetFolderPath)GetProcAddress(hLib,(LPTSTR)232);
hr = lpfSHSetFolderPath(CSIDL_FAVORITES,NULL,0,L"E:\\TestFolder");
}
The "hr" return value is not S_OK,why?
Thanks
|
|
|
|
|
Why are you asking questions about and posting C# code in the VB.NET Forum?
I can tell you you're calling this function the hard way.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Sorry.
I have made a mistake.I wanted to ask the question in the C++ Forum.
|
|
|
|
|
There is some images that do not be needed.
How to remove them from resources file?
|
|
|
|
|
What version of VB.NET are you talking about? In 2005, just double click MyProject, click on the Resources tab on the left, right click the resource line that has the image and click on Delete.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
I tried creating Splash screen in VB.NET. But when i close it main form also gets closed. I tried opening it from sub main() but same problem. Can any body tell how to create splash screen in VB.NET.
Niranjan
|
|
|
|
|
ok splash screens are easy
on the form that serves as the splash screen, put a timer control, then turn enabled to true in the properties, and the interval to whatever you want. 1000=1sec.double click on the timer control and enter me.close
Me tells the program that it is only dealing with that one form and close closes the form. If you use End it will close the whole program.
BINARY
|
|
|
|
|
In VB.NET if u close first screen even with ME.Close() it closes all other forms. I.e if i open main from from splash screen then it will close that form also....
|
|
|
|
|
set it up with the timer on the splash screen, then create a module with something like this
Module Startup<br />
<br />
Public Sub Main()<br />
Dim frmSplash As New frmSplash<br />
Dim frmMain As New frmMain<br />
<br />
frmSplash.ShowDialog()<br />
frmMain.ShowDialog()<br />
<br />
End Sub<br />
End Module
make sure that in the timers tick event you put me.close, oh and change the startup object to SubMain and everthing should be fine.
BINARY
|
|
|
|
|
Search the articles for "Splash Screen" and you'll find a bunch of examples of how to do it the "right way".
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I just wrote a program and was wondering how to change the appearance of the exe file in the start menu such as adding an Icon.
BINARY
|
|
|
|
|
Hye
Right click on the project and go to properties. In the build option you can change the icon. As far the links in Start menu are concerned. Add a deployment project. and create a short cut in User Program menu for your output exe. and in the short cut properties you can change the icon.
cheers....
|
|
|
|
|
hi there,
Can someone help with this.
Syntax error in INSERT INTO statement.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.
Source Error:
Line 84: strsqlinsert = "INSERT INTO Transmittal(Action, Copies, Drw_Doc_Num, Kind_Attn, Project_Name, Referenced_To, Rev_Num, Title, Username)" + "VALUES('" + TextBox9.Text + "', '" + TextBox7.Text + "', '" + TextBox6.Text + "', '" + TextBox4.Text + "', '" + TextBox2.Text + "', '" + TextBox3.Text + "', '" + TextBox8.Text + "', '" + TextBox5.Text + "', '" + TextBox1.Text + "' )"
Line 85: TransDataAdapter.InsertCommand.CommandText = (strsqlinsert)
Line 86: TransDataAdapter.InsertCommand.ExecuteNonQuery()
Line 87: TransConnection.Close()
Line 88: End Sub
Source File: C:\Inetpub\wwwroot\OM\trans1.aspx.vb Line: 86
Stack Trace:
[OleDbException (0x80040e14): Syntax error in INSERT INTO statement.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) +41
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +154
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +92
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +65
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +112
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +54
OM.trans1.Button1_Click(Object sender, EventArgs e) in C:\Inetpub\wwwroot\OM\trans1.aspx.vb:86
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1263
|
|
|
|
|
manik nath wrote:
[OleDbException (0x80040e14): Syntax error in INSERT INTO statement.]
insead of writing the long codes you can just work on insert statement. if you could post the value of strsqlinsert variable then we could suggest you
some thing better and proper
|
|
|
|
|
well rizwan,
here's the value of strsqlinsert
strinsert = "INSERT INTO Transmittal(ReferencedTo, Title, NumberofCopies, Username, ProjectName, KindAttn, RevisionNumber, Action, DrawingDocumentNumber)" + "VALUES ('" + TextBox3.Text + "', '" + TextBox5.Text + "', '" + TextBox9.Text + "', '" + TextBox1.Text + "', '" + TextBox2.Text + "', '" + TextBox4.Text + "', '" + TextBox10.Text + "', '" + TextBox11.Text + "', '" + TextBox7.Text + "' )"
it doesn't come in one line here.
help me if you could.
|
|
|
|
|
Two problems...
The first is that you don't have a spcae just before the word "VALUES", so your SQL looks likes this:
...Action, DrawingDocumentNumber)VALUES ('...
which I believe is a syntax error in SQL...
Second, drop this string concatenation garbage and make your life much easier and convert this to parameterized queries. You'll automatically eliminate about 75% of the problems you get, like the one your facing now!, by using string concatenation...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi dave,
thanx for your sugesstion. but i did not eaxctly get you. could you just modify the string i sent and then give it you me.
|
|
|
|
|
strinsert = "INSERT INTO Transmittal(ReferencedTo, Title, NumberofCopies, Username, ProjectName, KindAttn, RevisionNumber, Action, DrawingDocumentNumber)" + " VALUES ('" + TextBox3.Text + "', '" + TextBox5.Text + "', '" + TextBox9.Text + "', '" + TextBox1.Text + "', '" + TextBox2.Text + "', '" + TextBox4.Text + "', '" + TextBox10.Text + "', '" + TextBox11.Text + "', '" + TextBox7.Text + "' )"
All you had to do is add a space before your "VALUES" keyword.
This is one reason why you DO NOT USE string concatenation to build your SQL statements. How you're building your statement can be broken so easily, it's silly. All the user has to do is put a ' character in any one of those text boxes and your code breaks. Learn how to do it the correct way now, before this bad habit becomes your normal method.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
thanx dave,
the problem is solved by ur code. but the this method is working fine on one application. but on another it again gives the same syntax error. what to do? also what do you mean by parametrised query. or what is the better method can you tell me.
|
|
|
|
|
The syntax error is coming up because you miss-paired double quote marks somewhere.
You can get a taste of parameterized queries here[^].
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
but dave if that is the case then it should give error in both the cases. in one form the syntax is working fine and in another form it's giving error. i have also double checked everything.
|
|
|
|
|
All I can say is you're doing something wrong. If you're using the EXACT same statement in both forms, you've missed a character somewhere. Think about it! If the statement works on one form, it must work. So what's different about it on the second form?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
ii checked everything dave twice and thrice. but the webform on which the code doesn't work and gives the error. also doesn't work with a code as simple as this.
strsqlinsert = "INSERT INTO Chec (first)" + " VALUES (" + TextBox1.Text + ")"
if there is something wrong with it i don't know about it.
|
|
|
|
|
If your getting a "syntax error", you might want to consider what the field "first" is defined as and what is in the textbox.Text. If your trying to put a string into a number field, obviously, it's not going to work.
Seriously, pick up a book on SQL and VB.NET and save yourself the aggravation.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
A quick overview of my project aim might help you understand what I am trying to achieve. I am trying to create an area on a form where users can draw a turing machine! For those who dont know what one is , it does not matter too much (although i believe every computer scientist should at least have a basic background of one as it is the foundations of computing! it basically defines what can and cannot be computed).
Basically, i need an area where users can draw circles(which represent the states of the machines) and lines connecting these circles (which represent the transitions). I would like an place where users can click on a icon in the toolbar and then be able to click on the space to create the relevant shape.
I would appreciate any comments on where i can start looking. I've been looking around, and gdi's seem to turn up, but i'm not sure if this is the best way to approach this. Another semi-solution i have thought of is just to create images of these shapes and create a new instance?? of them as required! I am totally lost...
Thanks for your time and effort!
million thanks,
zoe xx:
confused:
|
|
|
|
|