|
use this format
Label.Text = Format(DateTime.Now,"dd'/'MM'/'yyyy hh':'mm':'ss tt")
for more format see msdn
Ishak
|
|
|
|
|
search for this:
DateTime.Now().ToString(...)
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
Dear All,
How can we restict the TextBox to enter only specified language(other than english like arabic or etc..)in vb.net,means that can be access only arabic charecters
Ishak
|
|
|
|
|
You can't. The character set used depends on the Input Local specified in the Regional Settings control panel. The language itself can't be restricted.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
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.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
