Comments by deva936 - CodeProject

deva936 24-Jan-14 21:54pm View

alright i got you. and i like your advice.
can you describe how to move the db to target machine. step by step or any link, please?
thank you

deva936 26-Aug-13 7:42am View

thats why i asked any way to lock it?

deva936 26-Aug-13 1:24am View

sa1.InsertCommand = cmdInsert_PurchaseProduct;
sa1.UpdateCommand = cmdUpdate_PurchaseProduct;
sa1.DeleteCommand = cmdDelete_PurchaseProduct;

sa1.Update(dtPurchaseProduct);

deva936 24-Jul-13 23:36pm View

yeah i have used it
it is fine with 2 tables but can't solve with 3 tables

deva936 22-Jul-13 22:24pm View

i want insert statement to insert data from dataTable to DataBase Table for 3 tables in the question

deva936 17-Jul-13 0:19am View

my insert statement or PurchaseProduct is like this

"INSERT INTO PurchaseProduct" +
"(" +
" Purchase_InvoiceNo" +
.
.
.
")" +
"Values" +
"(" +
" @Purchase_InvoiceNo" +
.
.
.
");";

and @Purchase_InvoiceNo is connected with DataColumn "Purchase_InvoiceNo"

DataRow drPurchaseProduct = dtPurchaseProduct.NewRow();
drPurchaseProduct["Purchase_InvoiceNo"] = Purchase_InvoiceNo;
.
.
.
dtPurchaseProduct.Rows.Add(drPurchaseProduct);

so i have to insert Scope_Identity() into DataTable first

is it possible to do that ?

forgive me if it is a silly question for you

deva936 11-Jul-13 12:00pm View

it don't have .Value property
i have tried it

deva936 11-Jul-13 11:36am View

this line of code causes the error

sa.Update(dtPurchaseProductExp);

the error message is
Missing the DataColumn 'Unit' for the SourceColumn 'Unit'.
i don't have 'Unit' column in dtPurchaseProductExp but in dtPurchaseProduct

deva936 8-Jul-13 8:25am View

hello there
why don't you use your brain to start thinking what i meant. i welcome your criticism if my english or program-ability is very poor. i found an answer on
http://stackoverflow.com/questions/1631054/using-sqldataadapter-to-insert-a-row

please don't act like a hyper lunatic child
thank you

deva936 4-Jul-13 4:42am View

when i bind the filtered rows to the DataGridView show nothing
so i test if it has actual retrieved rows
but i can retrieved like this
DataRow[] foundRows;

foundRows = dtPurchaseProductExp.Select(strFilterOption);

foreach (DataRow drfoundRows in foundRows)
{
MessageBox.Show(
drfoundRows["dtcolnPurchaseProductExpInvoiceNo"].ToString() + " : " +
drfoundRows["dtcolnPurchaseProductExpProductNo"].ToString());
}

what is worong? HELP
cant bind to datagridview

deva936 4-Jul-13 2:18am View

hello
thanks very much for yr reply

when i bind the filtered rows to the DataGridView show nothing
so i test if it has actual retrieved rows
but i can retrieved like this
DataRow[] foundRows;

foundRows = dtPurchaseProductExp.Select(strFilterOption);

foreach (DataRow drfoundRows in foundRows)
{
MessageBox.Show(
drfoundRows["dtcolnPurchaseProductExpInvoiceNo"].ToString() + " : " +
drfoundRows["dtcolnPurchaseProductExpProductNo"].ToString());
}

what is worong? HELP
cant bind to datagridview

deva936 3-Jul-13 23:25pm View

Set a condition on your datatable? how?

i wrote "i also need other rows in that datatable"
so i can't use sql query

thanks

deva936 3-May-13 23:33pm View

my gridview is on groupbox
i want to locate that gridview on other groupbox

Have ideas?

deva936 27-Apr-13 1:45am View

hey
i have updated my questions
now you got what i mean and help me ?

deva936 7-Apr-13 1:50am View

thanks a lot. i will use second one

deva936 5-Apr-13 22:53pm View

really thanks a lot. i got it

deva936 22-Feb-13 5:16am View

thank u for your explanation since i've been waiting for this.

so are you saying that all entities are classes in class diagram? can i take that?
and is it possible that there are more classes than entities for the same system?

Comments by deva936 (Top 17 by date)