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

...|| ' ' || customer.lastname AS Name, product.isaname AS ProductName,product.intrate, balance, (account.accrued + ((product.intrate/365)*account.balance))AS accrued, active FROM account INNER JOIN customer ON customer.custid = account.custid INNER JOIN product ON product.prodid =...

ok i will take a look into that thanks

..."Only for the bankers") { interestRate = 0.08 / 365; } accrued = (interestRate * double.Parse(balance)).ToString(); ; updateAccrued(); } } private void updateAccrued() {...

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

...{ try { conn = new SQLiteConnection(dbConnection.source); string sqlcommand = @"SELECT * FROM product"; da_Products = new SQLiteDataAdapter(sqlcommand, conn); dt_Products = new DataTable()...

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

...void showCustomer() { using (SQLiteCommand cmd = conn.CreateCommand()) { cmd.CommandText = "SELECT * FROM customer WHERE custid = '" + this.cb_custID.Text + "';"; SQLiteDataReader read = cmd.ExecuteReader(); while...

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