Search results for query: *

  • Users: lional
  • Content: Threads
  • Order by date
  1. L

    automatically updating database values

    Hi everyone. I am writing a small leave app for a friend. I have done most of it but I would like the accrued days to automatically increase with the allocated days per month and the database table to be updated. would this automation be done via the app or as a stored procedure in SQL Server...
  2. L

    read from one table and insert in another

    Hi I am busy with my student app where one subject consists of one or more modules. I have a database table that groups modules by the subjects that they belong to so when a student is added and they are registered for a subject it should add all the modules for that subject to their profile. I...
  3. L

    making combobox selection from a database

    Hi I have an app where students are inputed and stored in a database table. Certain combobox selections are made and stored in the table. Is is possible when later editing the student that those selections are automatically selected in the combobox. I am using wpf which I am very new to along...
  4. L

    Resolved datagrid selection available in another page

    Morning all. I have a datagrid that selects records from a database. If a record is double clicked then it opens a page with that record so that it can be updated. I have made it that the student number gets selected because this is a unique field. I have got that all working, what I am battling...
  5. L

    Comparisons

    Hi I am trying to do a comparison that is confusing me I start by extracting the portion of the ID number that pertains to gender. 0001 - 4999 is female, and 5000 - 9999 is male. I then see what the gender is that is being selected and I compare it In my tests I use the gender portion to be 5001...
  6. L

    Answered Only one word in a text box

    Hi I am trying to prevent the user from inputting or pasting more than one word in a text box. Which would be the best way to accomplish this. I was thinking of creating a keypress event forbidding spaces but not sure if this will cater for pasting text as well. I am creating a form for...
  7. L

    Binding combobox from database

    Hi All I am new to C# and used to do procedural programming so now I am doing my app in OOP. I want to bind my combobox key and value from a database but I have numerous comboboxes to do so I am doing it as a method. I will first post the code I have done and then the exception that I am getting...
  8. L

    multi window application

    Hi All Just need a bit of advice. I wrote a windows forms app in C# about a year ago, badly written it was my first app, I have learnt a lot since then. I am doing a new version of the app in WPF. It is a multi-window app so my mainwindow has the menu items that I don't want to repeat on each...
  9. L

    Running C# Database application for multiple clients

    Hi I have a database application written in C# for a theological college. If I want to use the same application for another college at a different site with another database, what is the best way to connect to the database. I currently use a connection string but that means changing the string...
  10. L

    C# and Moodle

    Morning all I am very new to C#, but been doing web development in PHP for a while. I wrote an app for a college in C# and they use Moodle for the students portal Whenever a change is made in the app I would like Moodle to automatically be updated. I know that Moodle has web service api's, and...
  11. L

    Selecting and inserting into sql database

    Hi I am very new to C# and learning as I go along I am writing a student app So what I am trying to accomplish is the following: I have a table with modules linked to a subject. So when a student registers a subject I want the modules to automatically be written to the StudyHistory table. I have...
  12. L

    Joins

    Hi All This is a cross post between database and C# I am writing a student app and I want to have a datagridview for all the letters sent out per student number. On the datagridview I want a combo box that lists all the available types of letters but it must default to the letter that was sent...
  13. L

    valuemember in combobox

    Morning all In my student administration app I had some comboboxes where the display member and the value member differed so I used the following code which seems to work fine // ### populate combobox for Remembering Rating Code ### // Create a List to store our KeyValuePairs...
  14. L

    updating another form with a selected record in datagridview

    Morning all I really appreciate all teh assistance this forum gives newbie C# developers like myself. I am still busy with my student app that is progressing slowly but I am learning a lot. I am trying to use datagridview to search for students then populate the student profile form with the...
  15. L

    importing from access to SQL Server

    Hi All The next stage of my college app. I need to export data from an old access database, into SQL Server that my app uses The data needs to be manipulated because it does not conform and the fields in the new database has changed. What is the best method. I was thinking of reading data from...
  16. L

    assigning student numbers

    Hi all I need a bit of advice I am writing a student application for a college (bearing in mind this is my first application), and I am not sure of the best route to follow with regard to assigning student numbers. Is auto-incrementing best or randomly assigning numbers. The additional problem...
  17. L

    Selecting multiple options from a list box

    Hi I am busy writing an application for a theological college I am writing the form where they add modules and I would like to be able to add books to each module. What I would like to do is have a list box or combobox where the selected items be written to a database table. I would like the...
  18. L

    Value different to item in combobox

    Hi All I am trying to add a combobox control whose value that gets written to the database is different from the text shown in the combobox at runtime. Both of these fields are drawn from a database table. I know how to add the database item to the value but been battling with having a...
  19. L

    Question Autonumber with prefix

    Hi All I am new to C#, in fact this is my first project. I was given a task of writing a student administration application for my client to replace their very old app done in Access 2003. I have developed in PHP and VB many years back but chose C# and very glad I did. The app is progressing...
Back
Top Bottom