16,010,114 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by srihari1904 (Top 21 by date)
srihari1904
30-Mar-14 5:08am
View
Thankyou that's working fine
srihari1904
24-Mar-14 6:48am
View
FORMAT ((SELECT IsNull(TotalPaid,0) FROM sumoftotalpayment WHERE sumoftotalpayment.InvoiceId=NewInvoice_1.InvoiceId), "0.00") AS AmountPaid
I tried this code but showing error "Wrong number of argument is used with function in query expression 'IsNull(TotalPaid,0'"
srihari1904
24-Mar-14 6:36am
View
Hi, Sorry am new to access how to make this query ?
IIF(ISNULL(AmountPaid),0,AmountPaid),
FORMAT ((SELECT TotalPaid FROM InvoiceList WHERE InvoiceList.InvoiceId=NewInvoice_1.InvoiceId), "Fixed") AS AmountPaid,
this code didn't working help me
srihari1904
22-Mar-14 7:58am
View
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"
srihari1904
22-Mar-14 5:41am
View
Thank you very much its working fine
srihari1904
22-Mar-14 5:41am
View
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"
srihari1904
21-Mar-14 8:23am
View
@marcin Thank you I solved.
srihari1904
17-Mar-14 1:08am
View
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.
srihari1904
16-Dec-13 1:25am
View
I didn't get exact answer from them so I asked here.
srihari1904
30-Nov-13 2:39am
View
@Thomas when i edit that code i got error like this "The best overloaded method matches found... has invalid arguments"
srihari1904
28-Nov-13 4:40am
View
Hi Alex, Here am using Tool called "DevExpress" it wont support this code who send.
srihari1904
28-Nov-13 4:38am
View
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.
srihari1904
27-Nov-13 7:36am
View
yes. Windows Application only
srihari1904
27-Nov-13 0:04am
View
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
srihari1904
26-Nov-13 0:33am
View
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.
srihari1904
22-Nov-13 23:41pm
View
Hi Maciej, Am new to c# so tell, How to check the cell content ? give me some code.
srihari1904
14-Nov-13 1:36am
View
yes. How to complete this task ?
srihari1904
12-Nov-13 8:06am
View
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.
srihari1904
6-Nov-13 6:59am
View
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();
}
srihari1904
6-Nov-13 6:33am
View
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>
srihari1904
6-Nov-13 6:28am
View
Hi OriginalGriff,
Now I changed error not shown but it shown Form with Empty Fields means it wont took Column value i think so ?
Show More