|
i have two month records in my table........,
example:
table look like this:
id date remarks
1 02/28/2006 test1
2 02/24/2006 test2
3 03/31/2006 test3
4 03/12/2006 test4
5 03/12/2007 test5
if i tell month on "3" and year on "2006" then it want to display...,
id=3 & 4 only...............,
how to do that....
plz hlp me.....
Regards,
Magesh,
regards,
-- modified at 3:27 Monday 26th March, 2007
Magi
|
|
|
|
|
Hi,
Use the following SQL,
select * from tablename where datepart(yy, [date])=2006 and datepart(mm, [date])=3
it will select all the records having year 2006 nad month 3 depending upon clolumn DATE.
Mubashir
Every job is a self portrait of the person who did it.
|
|
|
|
|
Thanks lot...........
Keep in touch...........
Magi
|
|
|
|
|
Can my vb.Net windows application be linked to outlook express or MS-Outlook if yes how can it be done?
|
|
|
|
|
yes. reference microsoft.office.tools.outlook
|
|
|
|
|
hi,
i have a readonly textbox and a FolderBrowserDialog box. I am selecting the file from the dialog box and filling the textbox. The problem is that i have to fill the textbox only for UNC format. How can i check the format?
Pankaj
|
|
|
|
|
Hi All,
Iam Using Datagrid with combobox...If i pressed the Enter key, Combobox values are displayed in Datagrid cell...So i need some Related coding format Pls.... advanced Thanks.........
Thanking you
Somasundaram g
|
|
|
|
|
Hello,
I have added one setup project to my already existing vb.net application.
in this i have included uninstallation routine to uninstall application from
program menu.
Added the following code:
Dim arguments As String() = Environment.GetCommandLineArgs()
Dim argument As String
For Each argument In arguments
If argument.Split("=")(0).ToLower = "/u" Then
Dim guid As String = argument.Split("=")(1)
Dim path As String = _
Environment.GetFolderPath(Environment.SpecialFolder.System)
Dim si As New ProcessStartInfo(path & _
"\msiexec.exe", "/x " & guid)
Process.Start(si)
Close()
Application.Exit()
End
End If
Next
If i mention the path as C:\Program files\MyFiles\MyApp while installing the setup, then how i could i retrieve the same path using above code.
which statement is that. Here i have to remove MyApp Folder with all files which consists of file created after running the exe.
I have added one custom action and beneath its uninstall folder, i added Primary output and sets its argument property to "u" "[TARGETDIR]\".
Please tell at the earliest how the path can be obtain from argument list.
Any help would be highlty appreciated.
Thanks.
|
|
|
|
|
hi there,
i want to write line in textbox through textwriter but vb giving some errors
the coding is:
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click<br />
Dim a As TextWriter = New StreamWriter(lkj.Text)<br />
a.WriteLine("ssss")<br />
End Sub
can some one tell where is the mistake or problem
|
|
|
|
|
xmen_xwk wrote: lkj.Text
I'd guess that your variable names suck.
It's hard to say more, b/c you didn't tell us what the error is, or what line it occurs on.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
|
Why on earth would you post an image to a site that shows it to me resized so I can't read it, instead of pasting the text in here ?
It looks like an argument exception ( hard to read ), what is the value of the text going in ? Did you set a breakpoint ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
i post image because in text some important info. might be remain
no i dont use any breakpoint ever
|
|
|
|
|
xmen_xwk wrote: i post image because in text some important info.
Yeah, that makes sense
xmen_xwk wrote: no i dont use any breakpoint ever
Do you mean you don't know how ? F9 gives you a breakpoint, the code will stop when it reaches it, and you can examine the state of variables, etc.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
The error says "empty path name is not legal". The text property of lkj is returning an empty string. You need to supply a file to be written too. StreamWriter will not accept an empty string.
|
|
|
|
|
yeah you are right the textbox is empty but man i want to write "ssss" in the textbox
|
|
|
|
|
You don't need a textwriter for that. What you are attempting to do with your code is write the text "sssss" to a file on your harddrive. The file to be written to would be whatever the path is in the textbox. If you want to set the text of the textbox just use:
lkj.text = "ssss"
|
|
|
|
|
yeah buddy, i know this , i want to do this in another way,
my whole problem is that ,i create an application in which Richtextbox contains about 10 lines of numbers
eg.
10
121
153....
and i want to add the textbox`s number which will be enter by user in every line thats why i was asking for textwriter
|
|
|
|
|
It took you 5 and a half hours to FINALLY describe what your trying to do with this instead of insisting that you need a TextWriter. You don't. If all you want to do is add the Text typed in by the user to the RTB, then all you have to do is:
myRTB.AppendText(myTextBox.Text & Environment.NewLine)
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
hehe ,nice and thanks i will check it,
|
|
|
|
|
buddy it adding lines at the end of text
it wont add the given number to line
|
|
|
|
|
The code provided will add whatever text is in the textbox to the end of the RTB. If the textbox is empty it will add a blank line. Just enter your number into the textbox and click the button.
|
|
|
|
|
Then you're going to have to re-explain and draw some text pictures of what you want it to do because as of right now, noone understands what you want it to do. And DON'T use what you've already posted.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
ok listen i want to add (eg.10+1=11) number which will in textbox to rtb lines so i coded it like this:
Dim srr As TextReader = New StringReader(rtb.Text)
Dim lineIn As String = ""
While Not (srr.Peek = -1)
lineIn = srr.ReadLine
lineIn = Val(lineIn) + Val(textbox.Text)
End while
its reading the lines but how to put back the value of "lineIn" in the place of same line where it read
now i think you will understand my problem
|
|
|
|
|
OK. You STILL do not need a StreamReader for this. And I STILL don't understand what you're trying to do. But, to get through the lines of an RTB is very easy using it's Lines property:
Dim newText As New StringBuilder()
For x As Integer = 0 To RichTextBox1.Lines.Length - 1
newText.AppendLine("test " & RichTextBox1.Lines(x))
Next
RichTextBox1.Text = newText.ToString()
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
