Search results for query: *

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...

Hey I really appreciate you going into hat much detail, ill go through it when I get a chance and take a look at the link provided, everything I've done so far is based on what the college is teaching and I'm slowly learning that what they teach isn't great lol

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...

ill take a into that

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...

ok i will take a look into that thanks

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...

ok its for a college course so they havent gone over anything like that and we are using sqlite is this doable using sqlite? but i will take a look into it and see if i can get it working, thanks

Ok awesome thanks for the notes, I'll make the changes later

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...

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...

Well thats what I have in another form on anther table , I just thought something like a checkbook to select might look a bit better

No I'm not actually using the checkbook for anything atm what I want to use them for is to select one then on button click open a new form that will display all info that is relating to the selected row so ideally I'd only like to be able to select a maximum on 1 checkbox

well i have added a checkbox to my datagridview but im trying to figure out how to set it so i can only check one box at a time // adds a checkbox to each row so user is able to select specific rows DataGridViewCheckBoxColumn dgvCmb = new DataGridViewCheckBoxColumn()...

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 {...

Thats how the college showed us to do it. But ill go through it and remove them tomorrow thanks

For god sake cant believe I missed that, stared at that line for ages aswell ??? working now thanks

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...

Ok I will look into the shown event, I've never used it, just following what my college course is teaching atm

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...