|
I have this code in as Procedure in SqlServer
alter PROC Aut.SpGetArshive(@userId Int,@SecID bigint)
AS
BEGIN
SELECT *,str(isnull(a.Row,0))+' '+a.Title+ ' ('+a.Zonkan+')' AS des FROM aut.Archive a
WHERE (a.UserId IS NULL AND a.SecId=@secId) OR (a.SecId IS NULL AND a.UserId=@userId)
END
and have this table adapter in vb.net 2005 dataset
SpGetArshiveTableAdapter.Fill(Me.Ds.SpGetArshive, UserID, SecID)
and I wana pass null value to userId but Icant
I Use
SpGetArshiveTableAdapter.Fill(Me.Ds.SpGetArshive, dbnull.value, SecID)
or
SpGetArshiveTableAdapter.Fill(Me.Ds.SpGetArshive, nothing, SecID)
but there is Error
tanx
|
|
|
|
|
|
tanx
I changed my procedure .
|
|
|
|
|
I'm a newbie with VS 2005.
I'm porting an app from VB6 to VB.NET, writing it from scratch.
I created a multiline text control and it works fine.
If i fill the control with the content from a string (like "txt_control.text = string") I'm not able to add text anymore. The only edit function that works is the delete and backspace key.
Any hint?
marco
|
|
|
|
|
Hi
Change the max length of the text box and try.
Thanks
Mitesh
~Khatri Mitesh
khatrimitesh@hotmail.com
Bikaner (Rajasthan)
INDIA
|
|
|
|
|
Thank you so much!
It worked!!!
|
|
|
|
|
Hi All
I have a stored proc in SQL which I call using VBA from a workbook. Although the App claims to have made the call successfully, it actually only gets to about 80% through the proc. When I run the proc manually, it works fine.
The proc does take a long time to run, so I'm thinking that it may be some crazy timeout that does not get noticed, or is ignored by VB when the ConnectionTimout and CommandTimeout properties are set to 0.
I'm using ADODB.Connection.
Does anybody have any idea's on this? I'm completely stumped. 
Thanks
|
|
|
|
|
The ConnectionTimeout property only describes how long the Connection object will wait for the connection request to open, not how long a connection will last.
The CommandTimeout proerty describes how long to wait for a request to complete. The default is 30 seconds. Now, there are TWO CommandTimeout's. One on the Connection object, and another on the Command object. Use the one on the Command object to extend the length of time to wait for a request to complete.
|
|
|
|
|
Thats great. Thank you very much.
|
|
|
|
|
Hi,
I am using CrystalReportViewer control to display a report in Visual Basic.Net application. My application has unique look and feel like Microsoft Office 2007 themes. I want to customize the CrystalReportViewer control to match my application look and feel. I know that the CrystalReportViewer control consist of 5 controls with PageView control being one of them. The PageView control contains Tab control to display the actual report.
My main concern is the Tab control of PageView control. I want to customize this Tab control to have transparent background color or some other color. I also want to have transparent color background or some other color background for the Tab control.
I hope I made myself clear.
Any help would be appreciated.
Thank You.
|
|
|
|
|
I have a question here.. if i wan my application to continue even if it cant found the file tt i wan, wat can i do??
something like tt..
if "C:\Testing" = False
msgbox.show("found")
endif
i not sure if u understand my question i just dun wan my application to stop when the file is not found or not exist.
|
|
|
|
|
try using this
If IO.File.Exists("C:\Testing") = True Then
Msgbox("Found")
End If
thanks
Anoop
|
|
|
|
|
|
could also use "if my.Computer.FileSystem.FileExists(strFilePath) then".
I have found the IO.File method to perform better if checking a large amount of files though.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Also learn to use the english language, text speak in the forum is discouraged. You have a kyboard, use it!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
Can anybody give me how to use StringBuilder Class or its similar one in VB 6.0. Atleast give me any link sor code snippet.
Thanks a Lot,
Aleem Mohammad.
Thanks & Regards,
Md. Abdul Aleem
NIIT technologies
|
|
|
|
|
|
I beleive you have asked this question a number of times. StringBuilder is in DOTNET and is NOT in VB6.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
If he would've read the article that sum guy posted when he last asked this question he would've find out how to use Mid in vb6 to accomplish what he wants. This "write my code cause i dun wanna read anything" is starting to be more than boring.
Code? Yeah i love it fried together with a glass of wine.
|
|
|
|
|
You have been asking this question over and over for a week and have been getting the same answer for a week.
Stop spamming the board.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
<sarcasm>No, please don't stop asking. Do it again and again. People love rading the same question without end.
|
|
|
|
|
I would like to ask if anyone knows wat is the maximum number of character a RTB can have? And wat is the maximum interval a timer can have??
|
|
|
|
|
Subjugate wrote: wat is the maximum number of character a RTB can have?
Up to available memory.
Subjugate wrote: And wat is the maximum interval a timer can have??
The depends on which Timer you're talking about. If it's the Timer in the Toolbox, then it's Int32.Max, or about 2.14 billion. If it's the Timer in the Threading namespace, then it's Int64.Max, or about 9.2 Million Trillion milliseconds.
In either case, if you need to set an interval that high, you really need to rethink your design.
|
|
|
|
|
Dave Kreskowiak wrote:
In either case, if you need to set an interval that high, you really need to rethink your design.
I agree. Though it is nice to know what the limit is, the upper bound really doesn't have any practical purpose. I can't even begin to think of anything that would need that long of a duration between ticks. Especially the 9.2 million trillion milliseconds, that is quite a few years ( ~291 million ) 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Thanks for the ans. I wanted to know is becos my application is a 24/7 running application. i am afraid if my RTB just full and i am not aware, it might crash the application.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
