| | |
How to create a Calculated and a Lookup Field
Please support our C# advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Jan 2009
Posts: 2
Reputation:
Solved Threads: 0
Hello
I'm working with VS2005 and C#, I'm using Firebird, however I think Database engine is not relevant in this case.
I want to create a lookup field and a Calculated field for my table, I search in google, but I have not find a good answer.
My code at the moment, starts like that:
I'm working with VS2005 and C#, I'm using Firebird, however I think Database engine is not relevant in this case.
I want to create a lookup field and a Calculated field for my table, I search in google, but I have not find a good answer.
My code at the moment, starts like that:
C# Syntax (Toggle Plain Text)
public partial class FrmServer : Form { private FbConnection _connect; private FbCommand command1; private FbDataAdapter DA_Item; private DataSet DS_Item; public FrmServer() { InitializeComponent(); _connect = new FbConnection("****"); _connect.Open(); command1 = _connect.CreateCommand(); command1.CommandText = "SELECT Item,TipeItem,Name,Cost,Price,weight,Item_date,"; command1.CommandText += "old_price,barcode FROM ITEM WHERE (barcode IS NOT NULL)"; DA_Item = new FbDataAdapter(command1); DS_Item = new DataSet(); DA_Item.Fill(DS_Item); DataTable TArt_Item = DS_Item.Tables[0]; } }
•
•
Join Date: Aug 2008
Posts: 1,735
Reputation:
Solved Threads: 186
Well. depends on the calculation - if for example you had item, cost, quantity, and wanted "totalcost" you could do so in your query.
So i guess you need to work at least what you want to look up and do with any answer, as well as what calculation you want.. and what you want to do with that, before you stand a chance of coding it - and perhaps this will help you refine your searches
So i guess you need to work at least what you want to look up and do with any answer, as well as what calculation you want.. and what you want to do with that, before you stand a chance of coding it - and perhaps this will help you refine your searches
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
![]() |
Other Threads in the C# Forum
- Previous Thread: Help with RegEx and matchcollection screen scraping
- Next Thread: instantiation; and arrays & structures really objects?
| Thread Tools | Search this Thread |
.net access algorithm array barchart bitmap box broadcast c# check checkbox client combobox control conversion csharp custom cyclethruopenforms data database datagrid datagridview dataset datetime degrees development dll draganddrop drawing encryption enum event excel file finalyearproject form format forms function gdi+ getoutlookcontactusinfcsvfile globalization httpwebrequest image index input install installer java label list listbox mandelbrot math mono mouseclick mysql operator panel path photoshop picturebox pixelinversion post programming radians regex remote remoting richtextbox save server silverlight sleep socket sql sql-server statistics stream string table text textbox thread time timer timespan update upload usercontrol users validate validation visualstudio webbrowser wia windows winforms wpf xml






