In my .NET application I have to manage bookings for rooms. I enter the room booking via an SQL query to a MS Access database using an INSERT INTO statement. Before I insert the booking, I need to check if a booking already exists for that time period, and if it does stop the user from being able to book at that time. I have written co...
Hello Everyone ! Please help me with the following set of code: Dim daTest as New SqlDataAdapter Dim dsTest as New DataSet Dim cbTest as SqlCommandBuilder Dim dRowTest as DataRow Dim conx as New SqlConnection(conxString) conx.Open() daTest.SelectCommand = New SqlCommand("Select * From Table1", conx) cbTest = New SqlCommandBuilder(daT...
Using VB.NET How to get Datagridview cell value. I want to insert a Datagridcell value in the table, How to get datagridview cell value. Need vb.net code Help ...
Hi, Please excuse my choice of wording and/or mixup of terms, I am a dummy when it comes to socket programming. I am trying to connect to a TCP server, write a message and process a response. I use the following code: Dim tcpClient As Sockets.TcpClient = New TcpClient() tcpClient.Connect(hostname, 9080) Dim networkStream As NetworkSt...
I have a for xml raw select query that returns a xml string in server2005 and i would like to write that string to a file using vb.net. ...
How can i do a isDate() control on a date like 16/01/2008 in vb.net? ...
Hello, i have a list of Hostnames from computers in my network and now i want to know how i can get the computer-description from these computers. Anybody an idea? Kind regards Nico ...
In my VB.NET code I construct a ODBC.COMMAND to call a stored procedure that eliminates a record from table in SQLSERVER 2008, I use this code in a FOR NEXT loop, it may contain 1 to 20 records_ID to pass to stored procedures to delete the records. This code work well for several months, but since the last compilation it only deletes th...
We have been working on our application for about a year now and today we performed a manual stress test with about 70 users. Our SQL server and WinForms application ran smooth, however, once the web application hit around 20 users, the server started acting strange. One error that we received multiple times was when a stored procedu...
So I've recently been vexed by problems similar to this one: Oracle .NET error - Wrong number or type of arguments. I know oracle is famous for its terrible error reporting, but this is a giant pain to debug -- if you have ten parameters, that's twenty things to check by hand (types and names,) not to mention the actual number of paramet...
Ran into this while converting a VB.NET interface to C#; the VB version defines an event which doesn't conform to the typical (object sender, EventArgs e) signature: VB Public Class SomeType ' Does *NOT* inherit from EventArgs End Class Public Interface ISomething Public Event SomeEvent(sender as Object, value as SomeType) End...
I am using Resharper 4.5 in Visual Studio 2008. Whenever I try to extract a block of code into a method, it tries to create a subroutine and not a function. The return type option is disabled. Does anyone have any advice as to how I can get it to create a function and not a subroutine? thanks! ...
We decided to use the registry for handling our deployment with connection strings in our VB.net application. The requirements are: If the program cannot connect to the server, first check the registry for a connection string. IF not, create the folder and fill in the name, type, and data. Make sure its encrypted. I have never e...
Is there something like a doc.GETITEMVALUE("Attachment")(0) ? Also, I can't find any documentation for the domino API. Does anyone have a good resource for this? ...
To recreate this behaviour, you need to create a pop-up form with the following properties: (1) ShowInTaskBar = False (2) Display the form with the Show method and loop until the form is not Visible. (3) In order to close the form when the mouse is clicked out of it, override OnDeactivate, and set visible to False. Next, create anoth...
Can values from web.config be read completely at runtime or does the application make a copy of the current web.config upon initialization. Essentially, I'm wandering if I make a change to web.config if it will take effect on the users next postback or if they would need to initialize an entirely new page load. In particular, I'm inter...
How do I pass a BigInt value to SQL Server? ...
I have a VB.NET Project, and would like to, as with C# Projects, build and have dll files generated and dumped in the Bin/debug folder. Currently, I have the project configured for ANY CONFIGURATION and ALL CPUS but when I do a build, I still do not have a bin folder or a debug folder containing a DLL. What am I missing here please? Tha...
How does enum work in .NET ? eg. Enum eOpenMode Add = 1 Edit = 2 End Enum If LOpenMode = eOpenMode.Add Then rdoAddProject.Checked = True ElseIf LOpenMode = eOpenMode.Edit Then rdoEditProject.Checked = True How does this gets compared by their value(1,2) or by its name (add,edit) and what will be memory allocation sch...
I have an application in VB.NET. I want to call that application from a remote system by using Java servlets. Can anybody tell me the methods for that? ...