i have a calendar on a form, i am wanting to use the date clicked method so when i click on a date in the calendar amessage box will pop up and pull the informationfrom a field in the database and be displayed
View 7 RepliesI've had a look around, once again and can't find how to set the minimum and maximum dates allowed to be selected on a calendar in ASP.net with VB.
I'm using Visual Studio 2010 and it's just a regular Calendar control at the moment...
At the moment I've seen things like:
Calendar1.DateMin = DateTime.Now
But Visual Basic doesn't seem to like that (maybe it's a C# thing?).
I've been trying to search out the answer to this question, but i couldnt find any. How do set the calendar component to display only certain dates, say 6 weeks from current date?
View 1 Repliesusing the calendar from the webfor tools, NOT CALENDAR EXTENDER, and my question is, is there a way to add text to a specific day of the calendar, for example, that i want to click on the number where its shows 29 of the month december, then it shows me a texbox or anything that takes data from my, and i type anything in there, like an event or something, then i click on a button to save my entry, and next time i visit my page i see that day that i clicked on changed its color and shows my text when i hoover the mouse on top of it,
View 7 RepliesI'm developing a finance software and I want the user to enter a bill and pick the due date via month calendar. I getting it to work was the easy part, but now I only want one month calendar, for each time a user enters in a bill and picks a date.every time the user goes to pick a due date I have to call one of the several I have on screen.Here is my code that I have so far:Add due date button:
Me
The month calender:
Me
.TxtDueDate3.Text = MonthCalendar3.SelectionRange.Start.Date.ToShortDateString()Me.TxtDueDate3.Text
= MonthCalendar3.SelectionRange.End.Date.ToShortDateString()[code].....
I'm new to VB.NET 2010, i have a form that has textboxes and i need to update my Database but i am failing to do so.I maged to create the login page and i can search from my db but i cannot add or insert a record.
My form has the following textboxes, Name, Surname, Username, Password and i have to insert to a table with the same columns
[Code]...
Everytime i run the program and update the data in database. I got the error in this code da.Update(ds, "reservationdata") Dim dt As DataTable = ds.Tables("reservationdata") If resno.Text = "" Or custname.Text = "" Or custaddress.Text = "" Or TextBox1.Text = "" Or endTime.Text = "" Or amouttopaid.Text = "" Or InitialDeposite.Text = "" Or RemainingPayment.Text = "" Or DateTimePicker1.Text = "" Then
[Code]...
After using the following code, no errors are shown, but my database is not updated once i have made a change using my management system application.
Dim constring As String = Application.StartupPath.ToString() + "mydatabaseName.mdf"
Public c As String = "Data Source=.SQLEXPRESS;AttachDbFilename=" + constring + ";Integrated Security=True;User Instance=True"
Sub openConnection()
conn.ConnectionString = c
conn.Open()
End Sub
datagrid( value in combobox come from databse) the textbox of same datgrid show the value of slecete combo box no from same databsesimplyi select a item no form database in combo box of datagrid now i want textbox of datagrid show the item name related to the particular of a particular item no
View 14 Repliesi have datagrid on my interface with few columns eg. student name, address and age. on top of that there is a text box to include the group name. i want to save all the grid data into table called "groups" in access database. as an instance under group 1 all the students names and their details.
View 1 Repliescan anyone give me any tutorial or guide me in building an application using vb.net which can display table from sql databse.
View 1 Repliesi tried a lot of variations in my code and even sql statement but still nothing happens.. i really need to do thing messed up project of mine and put all my efforts here.. but i really can't understand why my combo box isn't showing the names of the candidates w/ that designated position.. heres my current code:
constr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = " & Application.StartupPath & _
"SSC_Automation.mdb; Persist Security Info = False"
[Code]....
i am working on a university student council voting system and what i wanted to do is when the voter selected the radio button name "Vote by Party list" automatically the names of all the partylist that are entered in the databse will be listed in the combo box and all the candidates on that Party list will be shown on the individual combo boxes made for each position..
I have this code and whenever i try to run it, I always get an ODBCEXCEPTION WAS UNHANDLED ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.51b-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'char VALUES('101','noodles')' at line 1
[Code]...
I m entering information of each person in Employee Information form and saving it in MS Access database.Now i want to Show the data of each person Individually and the information of the next person will be shown on the next button click. to do this what shall i use a crystal report or windows form.
View 5 RepliesI am using MS Access 2007. There are 2 tables in my database. One is for payments and other is for departments. In payments table, there is a field for departments. In my VB 2010 project, i want the departments field in the payments form to be in list box. And during the program is running, i want the option to add new departments and as soon as new department is saved, the list in payments form should also upadte.
View 3 Replieswhen i had 3 text box then i did the following code and it worked for me also:[code]in the above code ,depending on the textbox3.text,i performed all the deletion,so it was easy now i have got a three of combo box and three text box.i filled the combo box with the database entries.now i want to perform deletion depending upon the selected items of any one of the three combo box.i cant get the logic of the where portion in the delete syntax.
View 19 RepliesHow to create database in my mysql if it the database name is not currently true in mysql? Using vb.net How to check if database name is already created or available in my localhost using vb.net.
View 5 RepliesWhy my database always reset and what i had enter to the database using my application will be erased.if i dont close the application. the data will stay.
View 3 RepliesIs there a tutorial out there for connecting an access database to a VB project? I want to create an appplication that generates numbers incrementally based on certain other conditions.
which I have been customizing in VB6, but I'd rather be doing the project in VS 2005.
Has anyone a sample code, or point me towards a guide on how to link in a Query from an existing Access Databse into my vb? Im wanting to populate some text boxes with information from a query.
View 1 RepliesCan i ask how do i make the data i retrieve from the database into a link?
View 18 RepliesI have searched a lot regarding my problem but no solution so i am posting here to get advise from the experts.I am making a windows form application , and using Sql compact database.My Problem :When i am inserting records in the database using code (run time) they are inserted deleted , update and i can see them updated,inserted,deleted in my application , but when i close the application and start again only a few times they are changed, once a million :). Else i again see blank database ,or if i directly put values in the database from the solution explorer Visual studio 2010 , they stay there forever. I am using simple update,insert ,delete statement but not sure why the changes made to database disappear when i close the application.
First this For all :
Dim con As New SqlCeConnection
Dim command As New SqlCeCommand
[code].....
There are 3 textboxes->textbox1,textbox2,textbox3 and 1 button.In textbox1 bname will be stored and in textbox2 aname is stored.Bname and aname are columns of databasetable.This are not unique.There are same bnames and anames records.What I am trying to do is:when the user clicks on button then the code should match textbox1 and textbox2 with the databasetable and get the count of rows that match this data.And print the count in the textbox3.If there is no similar bname and aname in the table then the count should show 0.I tried doing this but am pretty sure that its not right as its not working.
View 1 RepliesI would like to view my database in excel.I want to be able to press a button in my program and then have a specified table in my database to be sent to excel to be viewed.How do i do that? Would it be possible to do that? I just want to see the data table in excel, not really looking for anything else, just a simple table in the excel spreadsheet.
View 5 RepliesI am almost finished my project for a vb database app, but lack the apparent knowledge to make this last connection. My listbox populates fine on form_load. I have identified the "category id number" from the database as the identifier for my information to be displayed (from that field). The variable catID returns the proper "category id" number to match the information to be returned when clicked (a description is part of the field for the appropriate number)
I presume the extra sub procedure I wrote for another daCategory = New OleDbDataAdapter is probably not necessary, but I'm very confused. How do i QUERY the information from the database with variable catID? tblSamples.Category(#) to return tblSamples.description to textbox when called from the listbox. I am not/will not use a databinding approach. [Code]
I've got a big database driven project...15 forms 50+ input boxes and im wondering how to do it effieciently. I've got code to connect to the mysql databse but i dont want to put it inside each form over and over for every form. How can i do it so that i only have to clal one method to connect to the db or leave the db connected constantly from the start of the app. here is the code that i got to put in every form -_-
Dim conn = New MySqlConnection()
conn.ConnectionString = "server=localhost;" & "user id=root;" & "password=;" & "database=project"
Try
conn.Open()
[CODE]...
What is my question? Well I believe its not a really hard one for those who know Basic.
Im trying to create a LogBook for an online server. What is the purpose of it, its simple. Right now we are doing it in a forum each one posting in a Log Thread, which game server they did the activity on, date, and time spent.
I have created the program so far, and what i would like to know, is if it would be possible that in the Texboxes i have, once you click submit, you will send the info to a Databse table.
How do i connect to the databse table?
I have a datagridview which is bound to a local databse table through a Linq to SQL class.
Everything works as I would expect, when the application runs, up to a point.
If, in the datagridview tasks pane I enable Adding, Editing and Deleting all work as expected.
If I disable Adding & Deleting, leaving Editing enabled, Editing works as expected.
If I disable Deleting & Editing, but leave Adding enabled, Adding does not work, despite the row for new records being displayed. I can move around the row but not enter data.
I suspect somehow its the datasource as opposed to the datagridview that is the cause of my problem but as I say, I can add rows if the Enable Editing option is selected.
Changing the relevant properties programatically makes no difference.
I've been searching for the reason for a couple of days without success.
I have a workaround, by leaving Enable Editing set and programatically setting each row during the RowPostPaint event to be readonly except the row for new records. I would just like to understand what is going on.
I need help and wondering if you can help me to get my first project...it's a hobby and wondering if you can get me code for this so i can see how it does it* Evaluate( ) Prints the evaluation of the hand to the evaluation Label.
o If IsFlush( ), prints "flush; "
o calls SetPipArray( )
o Uses a For Loop to go through pipArray. For each element, uses a Select Case statement to
[code]....
In our projects we use setting variables to store user setting for the applications. Moreover, with every latest version of the applications, we upgrade these variables to retain user settings.Normally, this works fine, but recently one of my end user reported an error i.e.Configuration System failed to initialize". The error is related to user.config file. Therefore we requested the user to send us his file.After received the folder, we noticed that it contains 3 files (3begfjb.newcfg,3begfjb.tmp and user. config). 3begfjb.tmp is an empty file, while 3begfjb.newcfg and user.config are identical files. We tried to open these files but the data in user.config isn't proper xml rather its unreadable formatted file.Do any you guys had experienced this sort of issue or any ideas how and what may have created these files and corrupted user.config file.
View 3 Replies