Comments by _bluRe_ (Top 58 by date)

already did sir. but i cant figure it out. why it will give a null error

i already use the debuger mode and the error lies in that code. hmmm

yes sir. im sure. i have a guess it will still get last thing which is empty so thats why the error occurs.

or maybe because it still count the last value which is nothing?

no sir. it has a rowindex=49

is it because of the counter?

okay sir. will look for it later

the values in the cells are integer value sir

no sir. it throws and exception in gg = (List<int>)metroGrid1.Rows[1].Cells[x].Value;

every time i choose the item that is newly put, the database shows system.data.datarowview

thanks griff. can u suggest a best way to put a connection string?

i wanted to subtract the inventory total price and inventoryout total price where the answer is placed in inventory db

i want to produce the desired output.. subtracting the same product with the latest inputed values in inventoryout.

how can i do integrate it with the chart in visual studio using c#?
like this.chart1.Series["NetIncome"].Points.AddXY("","");

I am using mysql php myadmin

updated

thank you for your time. those variable were just samples. i figured out something else :)

how can i call this method with parameter(totalPrice(double r)) and place its value into a command.para.addwithvalue in the button event?

thanks. what is the 2 in totalPrice(2), is it the value thats in totalPrice?

i tried it but still its wrong. hmm

cmd.commandText = "insert into ....values(@computedTwo)..";
ComputedTwo();
cmd.Parameter.AddwithValue(@computerTwo);

something like this? thats what i want to do but i dont know how to put the method in the parameter..

how can i code this in buttonevent in c#? like assign in a string variable, then..?

hmm something like execute the sub query and assign to variable then put them into the main query, right?

how can i put a selec sum query inside an insert query?

is my select sum function correct?

the code is wrong. well i just wanted to execute multiple sql query and put them in certain column.

no extension method for DataBind(). is it ok to remove this?

i have two combo box (first, second). the problem is when i select in the first, the selectedvalue in the first is the same as the second. so generally everytime i choose, its generates to the other

so generally, everytime is choose an item in diff combobox they choose the same

i have two combobox (firstCombo, secondCombo). the problem is everytime i select an item in firstcombo, the secondcombo does as well. im trying to do a dashboard here :)

im good to go :) thanks!

command.CommandText = "update inventory left join inventoryout on inventory.Product = inventoryout.Product set inventory.Stock = (inventory.Stock - inventoryout.Stock) where inventory.Product = @Products";
command.CommandText = "update inventory left join inventoryout on inventory.Product = inventoryout.Product set inventory.TotalPrice = (inventory.TotalPrice - inventoryout.TotalPrice) where inventory.Product = @Products";

is this ok?

thanks men! u gave me that idea :)

so do u mean a bind method that updates the inventory?

you are right. do i need another database that stores inventory.stock - inventoryout.stock?

this dosen't update the main inventory stock..

this is the updated code

DataSet ds = new DataSet();
try
{
MySqlConnection con = new MySqlConnection("connection...");
con.Open();
MySqlCommand command = con.CreateCommand();
command.CommandText = "Select * from inventory where Product like @cb ";
command.Parameters.Add("@cb", MySqlDbType.VarChar, 20).Value = "%" + this.cbProductDescription.GetItemText(this.cbProductDescription.SelectedItem);
MySqlDataAdapter da = new MySqlDataAdapter();
command.ExecuteNonQuery();
da.SelectCommand = command;
da.Fill(ds);
da.Update(ds);
con.Close();

}
catch (Exception r)
{
MessageBox.Show(r.ToString());
}

still the same. i did something like this this.cbProductDescription.GetItemText(this.cbProductDescription.SelectedItem) no error but nothing happens as well

i was trying to do a search here :)

yaa. the problem is here. cbProductDescription.SelectedItem.ToString(); even is i instantiate the selected value to a string, still same.

why everytime i put data in sql server compact database the data wont retrieve after the program is closed and the computer's off

thanks! i figured something out :D

1st row of stock multiply to 1st row of price = 1st row of total price. thats what im trying to do :)

i cant see the value placed. anyway maybe i'l just let the user input the price because it's not fix. do you know how to place a value in the total row where stock and price is multiplied?

nothing happens. no error either. sad.

oww. let me try that. :)

hmm so that another process right?

i knew it. that's what i've been thinking the whole time. what would be the best solution for this?

this is the whole code. from the moment the user pick the list of products in the cbproductdescription, i want to have a corresponding value or price that should already generated from the chosen product. is the code below possible for that kind of output? :))
try
{
SqlCeConnection connection = new SqlCeConnection("DATASOURCE=Database1.sdf");
connection.Open();
SqlCeCommand command = connection.CreateCommand();
command.CommandText = "INSERT INTO NewInventory(Product Description,Stock,Month,Model Number,Price,Total Cost) VALUES (@Product,@Stock,@Month,@Model,@Price,@Total)";
command.Parameters.AddWithValue("@Product", cbProductDescription.SelectedItem.ToString());
command.Parameters.AddWithValue("@Stock", txtQuantityInventory.Text);
command.Parameters.AddWithValue("@Month", cbMonth.SelectedItem.ToString());
command.Parameters.AddWithValue("@Model", txtModelNumber.Text);
if (cbProductDescription.SelectedItem.ToString() == "Prepaid - 300")
{
command.Parameters.AddWithValue("@Price", 7);
}
command.Parameters.AddWithValue("@Total", 0);
command.Prepare();
command.ExecuteNonQuery();
connection.Close();

oww. really? thanks !

yaa. it says error parsing the query. token line number = 1, token line ofset = 24, token in error = user