I need to create a DataGridView that will show all the bookings from each room within an SQL database.This will show the rooms down the left hand side and then the time slots in 30 min intervals as the columns.I dont want to use any thrid party controls as i need to do it for college.I have 2 tables called Rooms and Bookings this is the code i have so far
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Sets conn as new connection
Dim conn As New SqlConnection
I've run into another road block while programming my game. The problem is that when a player types North in room "Crash Site" They get the description of traveling to the next room "In Trail" as well as the description of traveling to the next room after that, "Deeper In Trail" before having to type north again. I've looked over the code several times, but can't find the problem....the conditions seem to be fine, but I'm guessing that's where the problem is..
Code: ElseIf LCase$(txtInput.Text) = "go north" And Room = "Crash Site" Then Room = "In Trail"
For my uni project I am designing a system that allows you to book a job into an Access database. My question is, Can you use a something like a calender or a diary to check if there is a job already booked on a certain date (like a duplicate date?), and in turn if there is, show an error message to inform the user that a job can't be booked on that date?
create a chat room? My current hosting is a linux server with mysql. I want to make a client that can connect to the database.(already done) and if the user exists, to open a chat form. I want this to be multithreaded, that way I can have up to 500 people chatting with each other at the same time, from different locations. (realistically will usually be around 50)I have found some winsock type examples, but I dont understand how I can adapt that to work with a linux server... Can anyone help give me examples? I guess I basically want an IRC.(Which I dont know how to implement.)
I am trying to provide a GUI which helps the user to know the room temperature.I am using an 8051 microcontroller with rs232 cable in order to provide the serial communication.
I have a tab where i'm adding more and more controls to it... I have no problem on my computer i can reszie my screen and just refit them but other users may not want to how can i make my tab have scroll bars to if my controls don't all fit it will just be a scroll away??
I am recieving data from my database and i want to view the data in a datagridview.
So, i wrote the query:
Dim Sql as String Sql = "SELECT workorder.ID, merk.merk, type.type, workorder.klacht, CONCAT('�', CONVERT(workorder.totaal, CHAR)) AS totaal FROM workorder
I have created a instant messenger program that works great except for 1 of our computers that is in our vpn but is an offsite location. The computer is able to connect but loses its connection after a few minutes.
I have been looking for a really detailed tut on how to use in a server to client chat room. I looked on google but they just post the script which helps alittle but I need a lot of detail to make a working chatroom.
I am developing a hotel software product, and one of the features required is to be able to display the room numbers in the hotel, and then the status of them for each day of the month.
I am trying to create something similar to a DataGridView control where at the top the column names are the dates of the month, and to the left is the room numbers as rows. Please see the below screenshot of the function I wish to have. However I do not know what control or function they use to create this grid below (it is from an existing product). I need to not just be able to join multiple cells together when it is the same person in the room for multiple days, but also allow drag and drop ability.
Currently I have a DataGridView control and am able to simulate the below screenshot, however with a datagridview control I am unable to join cells across multiple columns nor allow drag and drop ability between rows.
I want to be able to create a roster view in a DatGridView so i have all the employees down the row header and have the date of the week stored in the column header as start and finish so 14 colums in total this would be for a 7 day week. the date would be be set above the datagridview in a label. what i want to be able to do is enter in the start and finish time in the required cell and then press save and load the; employee number from the row header Date from the lable above and the start and finish time all in the Rota Table i have 2 tables Emp and Rota Emp has EmpID and EmpName and Rota has RotaID, EmpID, Date, StartTime and FinishTime.
I'm loading the results of different stored procedures into a DGV.If the second time I load I have less columns - the DGV does not clear the extra ones.Seems if I do dgv.columns.clear I mess up the DGV in general
I want to make my own little chat room window. [url] But I want to do a post or something to log-in. Not just filling out the form values one by one. I've looked at some sources, but I'm overly confused. Anyone have some direction to help guide me, or even some examples?
I am using this code to have current days work show at top of list:(It's working for me so I need to continue using it)
Dim FirstJobOfDay_SP As Integer Dim Today As String Today = DateString
[code]....
I have changed my application. Now it has two separate datagridviews each using the code above (seperate bindingSource and GridView). One each in it's own splitcontainerpanel one above the other. My intent was to allow the user to view both at once or grab the divider and slide the panels up or down to only reveal the grid they want to view.Trouble is, when one grid it completely collapsed I get an error "No room is available to display rows".
Is there any way to build a web based chat room application by using VB.NET as behind code and put it with ASP.NET on the web so users can login the account and start to chat without keep refreshing the browser or frame and have a real time transaction, I know that I have to use .NET.Socket namespaces, but don't know exactly how. I have seen many examples of windows based applications, but I need to know how to put it on the web.
what control should i use in making a room mapping system? i just cant figure out what controls i should use. i plan to use the datagrid but i don't know how to fill the color of cell.
I have a gridview in asp.net using vb 2005. on " Protected Overrides Sub Render"some of the data in the columns gets modified. when i do a view source.. and look at a column1's values it says 0010. in the render i am taking a value of ab0010 and turning it into the 0010 that is seen in the view source.. later on, there is a button_click event that goes through each line of the gridview and grabs some values. Here I'm doing a CType(gvr.FindControl("column1"), Label).Text the value is coming back as ab0010. so the question is.. the view source shows something different than what is in the viewstate?
I have a very simple table in access. The data is stored from VB.NET using the OLEDB adapter. I have a second form which has just a single DataGridView which was dragged/dropped using VS2010 from the Data Sources window.When trying to view the window the first time no data is shown and the second time an exception occurs and the program closes.
[code]...
In the Immediate window after clicking the Form.ShowDialog() button this message appears: A first chance exception of type 'System.ArgumentException' occurred in System.Data.dll Also, the data does not load into the datagridview. After closing the window and then clicking the same button (Not data has been changed at all) this error appears: Input string was not in a correct format.Couldn't store <07/11/2011 00:55:06> in Time Column. Expected type is Int32.
I'm trying to migrate (mostly mentally at this point) from MS Access to .NET for database programming. I've found one of the first tests to be fairly painful. I'm trying to recreate MS Access's datasheet view in Visual Studio.Features I use in MS Access Datasheet View that I haven't immediately found in the DataGridView I'm assuming that a DataGridView will be used to edit records as opposed to being used as a search/list only.1) Form Level BeforeUpdate Event - Here I typically run validation code2) Textbox level BeforeUpdate Event - If I'm feeling anal I'll run validation code here.
i am trying to get data from the clipboard into dataset and view it on a datagridview using the code below. The problem is that every line after the first line starts with a character (like a small rectangle) but when i run a sperate loop to view each character i do not find any unexpected asc code.
'this is the text in the clipboard this is a test to get
Its working for only single row.I got the Error Message is: "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"
Private Sub ViewButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ViewButton.Click con = New SqlConnection(Constr) cmdstr = "Select * From Mcdaily where Mcno='" & McnoCombo.Text & "' and Day(Edate)=" & Dtlog.Value.Day & " and Month(Edate)=" & Dtlog.Value.Month & "" [Code] .....
I have a Datagridview with 100 records and each records contained 15 field/columns hence it's difficult to read single record at a time completely. So my requirement is if I select a record and that particular records should display on a form or whatever
is there a way to view the data contents of a datagridview on screen? i mean if i have a dgv with 7 columns and 7 rows, and i can only view 5 columns and 5 rows of it when i run the program cause i have a small form,(regardless of the scrollbars) is there a way that when i click the button 'viewonscreen', the whole datagridview will be viewed on screen?
Using VB2008 and Sql. I have one table and two forms. On form1 I have details view of table and on form2 I have DataGridView of the same table. What I am trying to accomplish is when i click on DataGridView is that details view changes and shows data selected in DataGridView.
I'm trying to make a carpet calculator that will do the following: 1) How many metres of carpet are needed to cover a room. 2) How many rolls of carpet that will be. 3) How much full-width carpet will be left on the last roll.
The carpet is supplied in rolls that are 5 meters wide and 30 metres long. Any excess width is discarded. This means that rooms that are wider than 5 meters need several strips of carpet. The smallest space that will be carpeted is 1m x1m, the biggest is 20m x 20m. I only need whole meter lengths, so example if only 1.6meters of carpet were used to cover a room it would be rounded to 2 meters.
Here's the code that's giving me incorrect calculations. The number of rolls required to carpet the room seems to be the biggest miscalculation. Private Sub btnCalculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculate.Click Dim width, length As Single 'Defines variables. If IsValidInput(txtWidth.Text) Then width = txtWidth.Text [Code] .....
