Topics
-
-
- Administrators
- 1 reply
- 994 views
Nothing like try to script/code in something that you haven't ever done prior to put you in your place :( I am having trouble getting a if then else structure in a UDF - CREATE function aw_GetShiftDate (@excavator varchar(20),@datetime datetime ) returns datetime as begin Declare @return datetime Set @return = convert(datetime,Convert(varchar,DatePart(month,@datetime)) + '-' + Convert(varchar,DatePart(day,@datetime))+ '-' + Convert(varchar,DatePart(year,@datetime)) ,110) Set @datetime = Convert(datetime,Convert(varchar,DatePart(hour,@datetime)) + ':'+ Convert(varchar,datepart(minute,@datetime)) + ':' + Convert(varchar,datepart(second,@datetime)),8) Decla…
Last reply by PlausiblyDamp, -
-
-
- Administrators
- 1 reply
- 659 views
I am using MSSSQL 2000 and would like to know what the alternative is to using GetDate within a UDF?
Last reply by PlausiblyDamp, -
-
- 0 replies
- 650 views
I want users to create there own reports. I have visual studio 2005. and mysql. how can I manage this? help is appreciated thx,
Last reply by inter, -
- 5 replies
- 3k views
was thinking of putting something like this in my class :D Private Sub Test() Dim sqlCmd As New SqlCommand Dim param As SqlParameterCollection = sqlCmd.Parameters param.Add("@Branch_ID", SqlDbType.VarChar, 6, Session("branch_id")) execSP("spTest", param) End Sub Public Sub execSP(ByVal spName As String, ByVal param As SqlParameterCollection) Dim com As New SqlCommand With com .CommandType = CommandType.StoredProcedure .Parameters.Clear() For Each p As SqlParameter In param .Parameters.Add(p) Next ... End With End Sub but it gives this exception "The SqlParameter is already contained by another S…
Last reply by lamy, -
- 7 replies
- 3.1k views
in my javascript i have this function submitToFrame(url) { var frm = document.forms[0]; frm.target = "myIFrame"; frm.action = url; frm.submit(); return false; } and a submit button with this attribute Sub Page_Load() btnSubmit.Attributes.Add("onClick", "return submitToFrame('page.aspx');") End Sub clicking the button would cause this error in the target page Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster. i have several buttons which has differ…
Last reply by lamy, -
-
- Leaders
- 4 replies
- 1.2k views
Using the code below, I'm displaying a context menu item when the user right clicks the mouse over a listview. The problem is that the menu item appears in the top left corner of the screen. Not only is it not over the listview, it's not even over the form itself. It sits alone on the desktop in the upper left corner. Anyhelp? Private Sub lvwLeftList_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles lvwLeftList.MouseDown If e.Button = Windows.Forms.MouseButtons.Right Then Me.cmnuStrip1.Show() End If End Sub Private Sub cmnuSelectAll_Click(ByVal sender As System.Object, ByVal e As System.Eve…
Last reply by snarfblam, -
-
-
- *Experts*
- 2 replies
- 1.4k views
Hi All Im new to this forum and new to VB.NET coming from VB6. I have a problem with a dynamic array and am unsure why i get the error "Object reference not set to an instance of an object." im trying to add the text of a textbox to the array, i have also noticed that when i initilise the array with elements instead of keeping it dynamic it works. Anybody have any ideas??? Thank you experts My code is as follows Dim ctrl As Control, lbl As Control Dim iCtrl, i As Integer Dim strSizeArray() As String For iCtrl = 0 To Panel1.Controls.Count - 1 ctrl = Panel1.Controls(iCtrl) If ctrl.GetType Is GetType(Syste…
Last reply by MRRX8, -
-
- 0 replies
- 768 views
Is there any way to open an MS Access Report in ASP.Net?
Last reply by lorena, -
- 3 replies
- 753 views
It seems like I can never find good enough advice that is specific to my needs - even though the internet is full of db examples. :( I have a small windows application written in vb.net that I am planning on commercially distributing soon. However, all of my data storage currently exists in encrypted text files. Prior to distrubition, I would like to re-write my data storage to be a bit more "professional" and give me more flexibility down the road. I would like a db solution that is simple and free. I do not have a lot of complex data I'm storing - just contact information on users, etc. I want the db to be completely self-contained within the program... i.e. …
Last reply by Nate Bross, -
- 1 reply
- 7.2k views
Hi, I have recently ported a vb.net web service from .net 2003 to 2005. My web service was working correctly on Friday. This morning I ported a web application from .net 2003 to 2005, again no problem. I set the anonymous access to true for each project in IIS. I also updated the web service. When I build the application I do not encounter any problems. However when I go to access the web service from the web application I get the following error: "System.Security.Cryptography.CryptographicException: Bad Data". I then tried to call one of the functions in the web service my using the web browser to access the web service directly. When I click the Invoke b…
Last reply by mike55, -
-
- Leaders
- 21 replies
- 3.5k views
Ok, I've finished the GDI+ replic of a graphic engine simulating the old Eye of The Beholder game! I will just kill the final bugs and add some wall variations to make it look nicier, before uploading the project. I'll upload the program today (22-01-2006). Note, the grapics were created by me using Cinema 4D, thus, THEY ARE legal. Screenshot http://img.photobucket.com/albums/v698/EFileTahi-A/EOB_Replic.jpg
Last reply by EFileTahi-A, -
-
- 2 replies
- 1.7k views
Hi Everyone, Not sure if I've posted this in the right place, as it could be perceived as being rather general... But here goes - I want to embed '%SystemRoot%' as part of a constant for a connection string. Will this work, or do I need to define a structure or class instead to lock the value of the variable (i.e. return a read only property)? Thanks in advance, Paul.
Last reply by mandelbrot, -
- 1 reply
- 1k views
Hey all, Getting this error when I try to open an access connection: I know the file isn't open, so do I need to setup any special permissions? If so, how?
Last reply by IxiRancid, -
- 1 reply
- 1k views
hi i'm using a dataset to add a row to an existing table in a database. is there a way to generate automaticly the value for the primarykey-field of the table? best regards george
Last reply by IxiRancid, -
- 2 replies
- 3.1k views
Hi Guys, Do we have a control in asp.net where we have a combo-box with checkboxes in it? Meaning lets say we have 3 items in the combo-box, we should have 3 checkboxes assigned to each item in the combo-box so that user can select multiple records at once Any tutorial or reference would be very helpful.. Thanks in advance..
Last reply by a1jit, -
-
- Administrators
- 2 replies
- 794 views
I have two collections of custom class objects like this. Dim NewItems as Collection Dim OldItems as Collection Every user defined amount of time NewItems will be cleared and populated. I need to figure out if there is an item in NewItems that IS NOT in OldItems and if there is add it to a third collection. I am trying to use the following code to check if the item is a re-occurance. If OldItems.Count <> 0 Then For Each OldItem As Item In OldItems For Each NewItem As Item In NewItems If NewItem.ItemID() IsNot OldItem.ItemID() Then UnViewed.Add(NewItem) …
Last reply by Nate Bross, -
-
-
- Administrators
- 2 replies
- 895 views
In MSSQL is it possible to set the default value of a column to a function of another column (ie. max([field]) + 1)? If so... how?
Last reply by PlausiblyDamp, -
-
-
- Administrators
- Leaders
- 5 replies
- 807 views
I was wondering if anyone know the code for this problem. I was to click a button and have the text from within txtbox1 'copied' to the clipboard. I pretty much want the button to act as a ctrl+c. if anyone can help me that would be great.
Last reply by PlausiblyDamp, -
-
- 1 reply
- 748 views
I am working in VB.net and wondering if this is possible. What I want to do is declare thinks within a class. and then be able to call those items from any form within the project. for example in class1.vb i want to put Dim a as string a = "Text Example" and then be able to go into form1 and have a textbox.text equal to "a".
Last reply by Nate Bross, -
-
- Administrators
- 2 replies
- 1.9k views
I have a variable (StringBuilder) that I want to save in a specific format (Unicode). I have successfully saved it as UTF-8 (where notepad.exe can view it correctly). This is in reference to the .zcfg files for ZoomSearch (http://www.wrensoft.com/zoom/&e=42). The documentation states that the .zcfg files are in a double byte Unicode format - which I have been unable to reproduce from VB.NET. It seems to be sticking on the carriage returns - they don't get encoded properly or something. Any helpful links/code would be appreciated.
Last reply by jdenman, -
-
Who's Online 0 Members, 0 Anonymous, 59 Guests (See full list)
- There are no registered users currently online