kapojian

hey..what country are you from???

hi in my program the users need to update his record every week. every week there will be a different food that will be given to him. i have a table where his info are saved, column week determine what week it is?(1 month = 4 weeks) i want to …

hi. i have a main form and log-in form. when i try to log-in and entered a wrong user or password it gives me error and i dont understand why the error is in the main form??? heres my code in my login form.. [CODE] private void Lgbtn_Click(object sender, EventArgs …

use "distinct" on your query

hi, how do you add days automatically to current date? lets say i created an account in my program, and get its current date, augest 3 2011 for example, how would i add days automatically every after day, still keeps the date when i created my account. my goal is …

hi i would like to select in my database the latest date he updated his record. in my database theres a column date_updates. date_update Username(foreignkey) 08/10/2011 aaa 08/17/2011 aaa 08/24/2011 aaa now i want to select his last date update.. select date_update will select them all, i want to select …

place [CODE]baglan.Open();[/CODE] before [CODE]oku = veri.ExecuteReader();[/CODE]

hi, im not that good in sql and i dont know how to make a stored procedure. in my windows form, i need to archive two table from my database but only those inactive user will be archived. if user is not updating his profile for a month.... e.g TABLE1 …

heres a sample. if you like to search in your databse i prefer to use "LIKE"... eg select * from tablenme where column_name LIKE "variable".. [CODE] CN = new SqlConnection(concString); String qry = "update BookMaster set Cat_code=" + int.Parse(Cat) + " Title='" + title + "' Publisher='" + Pub + …

[CODE]CN.Open();[/CODE] put it before int[CODE] executed = com.ExecuteNonQuery();[/CODE] your error is no connection so the problem is in connection string. i use update like this [CODE]string sql=("UPDATE Users SET firstname="+"'"+textBox9.Text+"'"+","+" lastname="+"'"+textBox10.Text+"'"+","+" Username="+"'"+textBox1.Text+"'"+","+"[Password]="+"'"+textBox2.Text+"'", conn)[/CODE] correct me if im wrong hehe

i have one in C, but its not yet finished. wanna see it for reference? lolz

in my c# program, you will have to create accounts for you to log-in. now, when i create an account, (username, password, age, gender, date...) the info will be inserted in a table named "users". ones a users has a created an account he needs to update his record everyday, …

how bout a monitoring system?? that gives the user a guide on what to eat based on his bmi?

hi, i would like to ask where should i put my access database before publishing my application?? its inside my "windowsformapplication1" folder in project folder.. but when i publish it, there's no database in it. lol, already created an application yer doesnt know how to publish w database. :D thanks...

my program doesnt seem following my if statement condition, i have || and && in my statement... is there a better way to do this??thanks this just an example of my code... [CODE]else if (age>19&&bmires2>=18.50||bmires2<=25.00) {messagebox.show("normal weight"); } else if (age<19&&bmires2<18.50||bmires2>13.25) { messagebox.show("underweight"); }[/CODE]

i had the same error before but i forgot what i did... i guess its about the cn.open(); put it in after string sqlquery=select idnum. hehe

how can you remove the excess width in may datagridview??? after that long blank space theres another field.. as shown in the image.. my code goes something like this [CODE]//create a command builder OleDbCommandBuilder cBuilder = new OleDbCommandBuilder(dAdapter); //create a DataTable to hold the query results DataTable dTable = new …

i think this is what you need.... :p open your own oledb connection then in the button edit the code below.. :v [CODE]cmd = new OleDbCommand("insert into Users(firstname,lastname,username,[password],weight,height,age,BMI,gender,illness1)" + "values(" + "'" + textBox6.Text + "'" + "," + "'" + textBox7.Text + "'" + "," + "'" + textBox1.Text …

in my access database the column "foods" has multiline text..but when i view it in datagridview in my c# form it only has single line text,,, the width and height in datagridview is not the same as in my access database... my access database looks like this [U]|primary key|[/U][U]|foods|[/U][U]|servings|[/U] 00000001 …

ist possible to have another if statement after the first if statement.. this is just an example [ICODE] private void button_click(object sender, eventargs e) try { if(age>5||age<=10) {massagebox.show("young");} else if(age>10||age<20); messagebox.show("example"); } catch(exception) messagebox.show("error"); //can i have another if statement here??? if(something ==eg) {messagebox.show("thanks"); } [/ICODE]

i have a main form that has a button, when click a subform1 will open. in subform1 theres another button that will open subform2 in main form..i have this code in subform1. [CODE] { profilefrm prf = null; foreach (Form existingForm in this.MdiChildren) { prf = existingForm as profilefrm; if …

i think this what you need? this not mySQL so revise it. lolz... well atleast there's a reference.. :v [CODE]private void Lgbtn_Click(object sender, EventArgs e) { OleDbConnection conn = new OleDbConnection(@"provider=microsoft.jet.oledb.4.0;data source=C:\Documents and Settings\Anakz\My Documents\PDG.mdb"); OleDbCommand cmd = new OleDbCommand("SELECT Username,Password,age FROM Users", conn); OleDbDataReader reader; bool permit = false; …

i have three forms, mainform(which is the "MAIN") log-in and home form. when accessing buttons in the main form to enable it i did this. its property is set to public. [CODE](this.Owner as Main).homebtn.Enabled = true;[/CODE] after logging in homebtn is anabled, when clicked, the home form will show and …

help please.. how can i store the selected value from my database to a variable in my c# form... (eg. variable=select idnum from tblename)<--- i know i cant do that.. how can i pass its value?? im talking about a specific value from the database. lets say i log in …