Search results for query: *

  • Users: rowlandsfc
  • Content: Threads
  • Order by date
  1. R

    Resolved why is date from table not displaying properly

    i have a datagrid view that displays the information in a table, there is a created row which stores dates how ever when the information is loaded into the datagridview only the first number is displayed, currently the format of the date is yyyy-MM-dd, if you change the format to say dd-MM-yyyy...
  2. R

    Question why am i getting insufficient parameters supplied to the command error

    i have trying to read a database and display it into a datagridview but i keep getting the error private void nameSearch() { using (SQLiteCommand cmd = connAccount.CreateCommand()) { connAccount.Open(); try { connAccount = new...
  3. R

    Question sqlite multiple tables with calculations and save back to tables

    i have a database with multiple tables, i have created a sql select statement using 2 tables to make a calculation. the return works and displays the calculation correctly. what i need to do next is take the results of the calculations and save them back into the correct table. my other question...
  4. R

    Question how to update database row by row while doing a calculation for each row

    i have an application that takes data from a table and displays it into a datagridview. the table is for accounts and includes an accrued column. i have a button that i want to use that when pressed will calculate the daily accrued amount and add it into the accrued column for each account. so i...
  5. R

    Question calculating interest amount based on values from datagridview

    hi i have an application that displays customers accounts in one table and products information which includes the interest rate for that specific product in another table, both tables get displayed inside a datagridview. for my accounts database there is an accrued column which i need to code...
  6. R

    Resolved calculate days between two dates

    as the title says imtryign to calculate the number of days between 2 dates, now this is where im at atm and this works ok so far, but this results with 365.75 but if i change the difference to int as i just want whole number i get a conversion error on span.totaldays DateTime start = new...
  7. R

    combobox inside datagridview

    i have a datagaridview that on form load loads details from a database into it, what id like to do if possible is add a combo box to one of the columns(status) andbe able to change this from either closed or open. private void showProducts() { try {...
  8. R

    Resolved 'SQL logic error near ")": syntax error'

    i have a basic app in visual studio that is connected to a database, im trying to add a new antry into the account table but i get the error 'SQL logic error near ")": syntax error' for this line: int recordsChanged = cmd.ExecuteNonQuery(); private void btnAdd_Click(object sender...
  9. R

    Question retrieving information from sqlite database

    Hi i have a basic application that is used to display customer information from a sql database, i am using a datagridview to display the information, i also have a form that has texboxdes on it to enter customer information for adding to that database which currently works. what i need to do now...
  10. R

    Question finding duplicate in a list and skipping/delete that element and replace

    Hi so ive created a game for college using windows forms app where enemies drop from the top of the form, the enemies are a class and using a list 5 are created as the form loads. what i would like to do is ensure that when the 5 are created that they do not appear in the exact same location. i...
  11. R

    Answered need help with a windows forms app game

    so i created a basic game and it has a level that is basically space invaders. i have a class for the bad guys, and a class for the bullets, but sometimes i have an issue in game where the bullet just goes straight through the enemy rather than actually hitting it. this doesnt happen all the...
  12. R

    help sorting text file

    so i have created a basic game, it has a simple scoring system where the score and player name(both variables) is saved to a text file, leaderboard.text. i have an issue with sorting the file by the score and not the name, i cant get it to work .`` // reads the leaderboard txt...
  13. R

    moving forms background image

    im creating a game where i need the background image to move to the left evry time i click on the key d, i got it working with a picture box but when i add another picture box and set it to transparent it shows the forms background rather than the first picturebox image, if it is possibly to...
  14. R

    Help with arrays

    im new to this, im currently in my first year of college studying coding and we have tro create the game hammurabi, im having issues getting my array towork as i need it, i need to use to store data from each year(button click = 1 year) up to 10 years. the data is calculated based...
Back
Top Bottom