Comments by srihari1904 (Top 21 by date)

Hi Thank you. working but in empty data's it showing error "#Error" like this ? how to solve it. That is "TotalPaid column is null for another Id" in this time access showing error "#Error"

@marcin Thank you I solved.

Hi, More Sub-Query in first SQL Query that's why that code getting error so to solve that I remove address separately from Company and Customer Table and Add that finally by INNER JOIN.

I didn't get exact answer from them so I asked here.

@Thomas when i edit that code i got error like this "The best overloaded method matches found... has invalid arguments"

Hi Alex, Here am using Tool called "DevExpress" it wont support this code who send.

Thankyou Guys, I got now, I changed to temp.ToString("N2") while storing. Sorry small modifucation both values are decimal that is 6900.00 & 5.00. Now I sloved.

yes. Windows Application only

Binding ? How. I tried in runtime new value is set in unbound column. but when i click new row it(value) assign to all columns ? what's my error

Hi ^Mo^, I need to perform two calculation 1) normally [Quantity * Each] this is done using

<pre lang="c#"> e.Value = getTotalValue(view, e.ListSourceRowIndex);</pre>

If the 1st column(RepositoryLookupEdit) in Gridview == ["Discount"] in this condition i need to perform other calculation. I want to get a cell value from previous row and get a cell value from current row and i need to multiply both & then set in a Unbound Column[PriceQuantity]. How to complete this task.

Hi Maciej, Am new to c# so tell, How to check the cell content ? give me some code.

yes. How to complete this task ?

Hi Harsh,

For eg 1st column of Gridview is RepositoryItem LookupEdit If I select A Item in than eg Paste, remaining columns(Item Description, Tax, Price, Quantity, Total) fill automatically. Now in second row if i select "offer on previous item" I need to fill this row corresponding to previous row. I need to get price amount and if offer is 5% i perform some calculation and show this result in Total. so I need to get the previous row cell value.

private void repositoryItemButtonEdit1_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
string oper = "A";

New_Invoice frm = new New_Invoice(oper, Convert.ToInt32(gridView1.GetFocusedRowCellValue("invoice_number")));
frm.Show();
gridView1.RefreshData();
}
this code in form 1 and this code in Form 2

public partial class New_Invoice : DevExpress.XtraEditors.XtraForm
{

string getOper = "A";



public New_Invoice()
{
InitializeComponent();
}

public New_Invoice(string oper, int invoive_number)
: this()
{
// TODO: Complete member initialization
//this.oper = oper;
//this.p = p;
textEdit5.Text = invoive_number.ToString();
textEdit5.Visible = false;
getOper = oper;
}
private void New_Invoice_Load(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:/Srihari/OrionSystem.accdb");

int i = Convert.ToInt32(textEdit5.Text);

OleDbCommand da = new OleDbCommand("select * from invoice_top where invoice_number='" + i + "' ", con);
con.Open();
OleDbDataReader reader = da.ExecuteReader(); // now error shown as "Data type mismatch"
while (reader.Read())
{

textEdit12.Text = reader.GetString(1);
textEdit13.Text = reader.GetString(2);
textEdit4.Text = reader.GetString(3);

textEdit1.Text = reader.GetString(5);
textEdit2.Text = reader.GetString(6);
textEdit3.Text = reader.GetString(7);


}

con.Close();
}

it bring value from previous Form <pre lang="c#">private void repositoryItemButtonEdit1_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
string oper = "A";

New_Invoice frm = new New_Invoice(oper, Convert.ToInt32(gridView1.GetFocusedRowCellValue("invoive_number")));
frm.Show();
gridView1.RefreshData();
}</pre>

Hi OriginalGriff,
Now I changed error not shown but it shown Form with Empty Fields means it wont took Column value i think so ?