|
Hi I have a MS Database called Holidays with 2 tables called: Destination and Booking.
I have a web form consisting of:
GridView Displaying the data from Destination Table
Label (Text = Holiday ID) with a TextBox (name = txtHolidayID)
Label (Text = Your Name) with a TextBox (name = txtName)
Label (Text = "") and (Name = lblMessage)
Button (Text = Book) and (Name = btnBook)
When the User clicks the Book Button the Web form should check whether the txtHolidyID (In this case 1 - 4) is one of the Holiday IDs in the GridView(Destination Table), If not the lblMessage should display saying "Invalid ID" and not save the Data.
When the User clicks the Book Button and the txtHolidayID is correct (Meaning 1 - 4 in this case), and the txtName is of string, then the holidayID in the TextBox which is from the Destination Table should be saved in the Booking Table along with the Name provided and the lblMessage should display "Booking Successful".
When the User clicks the Book Button and everything is correct but did not save for some reason the lblMessage should display "Booking Failed".
I have searched the forum for something similar but I'm not finding it.
I will add Captures of my Database and Web Form to make things easier to understand.
Sorry for this rookie question.
Database Capture
Shared album - Dreyer Vorster - Google Photos[^]
Destination Table Capture
Shared album - Dreyer Vorster - Google Photos[^]
Booking Table Capture
Shared album - Dreyer Vorster - Google Photos[^]
WebForm Capture
Shared album - Dreyer Vorster - Google Photos[^]
WebForm with Details Capture
Shared album - Dreyer Vorster - Google Photos[^]
|
|
|
|
|
You are telling us what you want to do, makes it look like you want us to do the work for you. If you have no idea then you should get a book or some tutorials and work through them until you are at lease familiar with reading and writing to a database (I suggest any database but MS Access).
When you have a specific problem with the development then you will have a question we can help with.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
I have a Study Guide which I can email to you to show that the info I need is not in there. Sorry for the bother. Will dlt the post.
|
|
|
|
|
You need to write a validator for the click event.
Then just assume that the database write was successful.
Say you have a form with 2 textboxes and a button called "Book", then you would add a validator to validate the form first before sending the data to the database.
I've never used GridView because I don't care for it, but I'm sure you can google "GridView Validators" for better help.
If it ain't broke don't fix it
Discover my world at jkirkerx.com
|
|
|
|
|
MS Access includes a number of (small) application templates.
In your case, you should pick a template that "resembles" your needs and go from there.
Most people don't build a new app from scratch when first starting out; mainly, because they don't know in what order things "should" progress.
The Master said, 'Am I indeed possessed of knowledge? I am not knowing. But if a mean person, who appears quite empty-like, ask anything of me, I set it forth from one end to the other, and exhaust it.'
― Confucian Analects
|
|
|
|
|
Hi,
How do I get the highest number of the folder V.2.4.0.12?. The folder name is V.2.4.0.1, V.2.4.0.2,... V.2.4.0.12 (highest number) But the code did not get
V.2.4.0.12 It's getting
V.3.4.0.9
var FileInOrdered = allFiles.OrderBy(f => f.Name).Last();
|
|
|
|
|
At a guess, because your collection contains folders called "V.2.4.0.12" and "V.3.4.0.9" - and file name comparisons are string comparisons, so they work on a character by character basis: the first different character pair determines the result of the whole comparison.
Me? I'd use the debugger to look at exactly what allFiles contains before I went any further - if it shouldn't contain "V.3.4.0.9" and it does, then you need to look elsewhere. If it should contain "V.3.4.0.9" but this shouldn't be the maximum, then you need to think long and hard about why "V.2.4.0.12" should be selected in preference, and probably write your own more complex comparator method.
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
V.3.4.0.9 is the latest file and I wanted to get the folder with the highest number (
V.3.4.0.12
|
|
|
|
|
Then you don't want to compare file names directly, you need to look at the full path - the debugger will show you that - and write your own comparator to compare just the folder bits you are interested in, probably using either IndexOf / LastIndexOf / Substring or Split.
As I said, string comparisons are simple character-by-character comparisons: they don't look at the "sense" of what they compare!
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Thanks for the explanation. How do I use the Split method? Can you show it to me?
|
|
|
|
|
You are kidding, right?
string s = "1.2.3.4";
string[] parts = s.Split('.');
foreach (string part in parts)
{
Console.WriteLine(part);
}
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
Further to what OriginalGriff is telling you, do some research on "Natural Sort".
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
Thanks for the recommendation
|
|
|
|
|
I recently answered a question with a similar problem involving sorting TreeNodes: [^]. Quote: A more complex way to deal with this is to use a 'SortedDictionary with a custom Comparer: the example shown here exploits the fact that numeric character sequences not at the end of the string are sorted in the order you want; only when the numeric characters are at the start of the string, do you need to compare in "reverse."
You could adapt the code shown there to meet your needs.
cheers, Bill
«One day it will have to be officially admitted that what we have christened reality is an even greater illusion than the world of dreams.» Salvador Dali
|
|
|
|
|
I have enabled your app from this page to automatically install it, but no snapshots can be found and no images of it. Can you install the program with your installation?
page Smaple : Silent Install Mode | General Information | DevExpress Help[^]
Sample Code C# :
D:\Fd\DevExpressUniversal2019.exe /Q /EMAIL:dxcustomer@example.com /PASSWORD:MyPassword /EULA:accept
|
|
|
|
|
Member 14046363 wrote: have enabled your app from this page
What app and what page are you talking about? Your only reference points to the devexpress website.
|
|
|
|
|
We are not devexpress, nor are we their support department.
Go to the DevExpress site, login with your registration information, and try their support. They will know a lot more about their own product than we would!
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
You purchased expensive software from a company with a good reputation for support. Use their support.
«One day it will have to be officially admitted that what we have christened reality is an even greater illusion than the world of dreams.» Salvador Dali
|
|
|
|
|
I got help with installing the app from this page automatically(<a href="https://documentation.devexpress.com/GeneralInformation/15656/Installation/Install-DevExpress-NET-Products/Silent-Install-Mode">Silent Install Mode | General Information | DevExpress Help</a>[<a href="https://documentation.devexpress.com/GeneralInformation/15656/Installation/Install-DevExpress-NET-Products/Silent-Install-Mode" target="_blank" title="New Window">^</a>]), but I didn't get any feedback and no errors. And the app didn't install Can you guide me on what to do to install the app automatically?
Sample Code C# :
D:\Fd\DevExpressUniversal2019.exe /Q /EMAIL:dxcustomer@example.com /PASSWORD:MyPassword /EULA:accept
|
|
|
|
|
Go to the DevExpress site and log in. Click on Support in the menu bar and you can open your own support ticket for problems like this.
|
|
|
|
|
Thanks for your reply but I did the same before, but did not receive any response
|
|
|
|
|
Did you verify the email account you supplied is the one used to login to the DevExpress site?
Is the password for that account specified correctly (case MATTERS!)?
Did you run that command line without the /Q switch to verify it installs?
The only thing I can think of that would stop the installation would be the email/password wasn't valid, or has expired.
|
|
|
|
|
Thanks for your cooperation friends. But I find myself sharing the reason that other friends, if they can find this problem, can use grammar code in this way (or in your program). Saman from Iran
Code Sample is c# :
D:\Fd\DevExpressUniversal2019.exe /Q /EULA:accept /DEBUG
Test Full :Devexpress 2019.1.5
|
|
|
|
|
I am writing a standard WinForm-application in C# using Visual Studio Express 2005. I have a ComboBox that shows certain com ports on my system that can be used to communicate with different embedded products. When USB-to-serial-cables are plugged in or disconnected, I need to update the contents of my ComboBox. I found excellent source code to get events when USB-cables are connected/disconnected: DiskImager/DriveDetector.cs at master · DynamicDevices/DiskImager · GitHub[^]. My problem is that sometimes I want to disable my events temporarily and then shortly thereafter enable them again. In case there was an event during this short period of time, I would like to generate an event retroactively. I think it would be appropriate to generate that event in the same thread as the regular events, that is, the WndProc(ref Message m) thread. So, how do I software-trigger WndProc(ref Message m) to execute?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
