|
I have been given a Product table whoes all column types are varchar(8000)
One of the column is Price and other is DecimalPosition. Price column includes price without any decimal place and the data in DecimlaPosition column determins where the decimal should be placed.
So for instance, if the Price column includes '1000' and DecimalPosision includes '2' >> then it means that the actual price for this product is '10.00' and NOT '1000'. Similarly, if the DecimalPosision includes '3' >> then it means that the actual price for this product is '1.000' and NOT '1000'
My question is that when I am getting the price for a product from this table, how can I get the price in the correct format, e..g like '10.00' and not '1000'
Should I use SQL statements to convert 1000 into 10.00 or should I use some sort of programming logic to convert 1000 into 10.00.
kind regards
|
|
|
|
|
You can do it at both places. But its better to do this is a VIEW in the database. This way you avoid bugs. Hope this helps.
CREATE TABLE dbo.ctm
(
Precision varchar(32) NULL,
Val varchar(20) NULL
)
Insert ctm Values('1234567', '1')
Insert ctm Values('1234', '2')
Insert ctm Values('123456', '3')
Insert ctm Values('123456789', '4')
select convert (float,Val)/ POWER(10,convert (float,Precision)) from ctm
Use POW instead of POWER if you are not using sybase.
|
|
|
|
|
I have an access table that has a column called "ItemLink" and is of the type "Hyperlink." When I query this table and select this field, I get the display text of the hyperlink and not the url. How do I get the URL from this field in a query?
|
|
|
|
|
Please show me the steps of how to ocnfigure the MySQL database in windows XP platform?  
beginner programmer..
|
|
|
|
|
Hi,
Does anyone knows how to remove the additional row that appeared at the end of the datagrid? I knew I can do that by setting the datagrid to read-only. But that is not my intention. I need to edit the cell in the datagrid. That's why I cannot set it to read-only.
Thanks,
kk
|
|
|
|
|
string connString = @"Provider=Microsoft.JET.OLEDB.4.0;data source=C:\northwind.mdb";
string sqlString = "SELECT * FROM customers";
// Connection object
OleDbConnection connection = new OleDbConnection(connString);
// Create data adapter object
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(sqlString, connection);
// Create a dataset object and fill with data using data adapter's Fill method
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet, "customers");
// Attach dataset's DefaultView to the datagrid control
dataGrid1.DataSource = dataSet.Tables["customers"];
//no adding of new rows thru dataview...
CurrencyManager cm = (CurrencyManager)this.BindingContext[dataGrid1.DataSource, dataGrid1.DataMember];
((DataView)cm.List).AllowNew = false;
|
|
|
|
|
alam_pune wrote: string connString = @"Provider=Microsoft.JET.OLEDB.4.0;data source=C:\northwind.mdb";
string sqlString = "SELECT * FROM customers";
// Connection object
OleDbConnection connection = new OleDbConnection(connString);
// Create data adapter object
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(sqlString, connection);
// Create a dataset object and fill with data using data adapter's Fill method
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet, "customers");
// Attach dataset's DefaultView to the datagrid control
dataGrid1.DataSource = dataSet.Tables["customers"];
//no adding of new rows thru dataview...
CurrencyManager cm = (CurrencyManager)this.BindingContext[dataGrid1.DataSource, dataGrid1.DataMember];
((DataView)cm.List).AllowNew = false;
Hi,
Thanks for replying. I've not tried to run your code snippet. I've a question on your code snippet that I'm not too sure (shown below). Pardon me as I'm a novice.
// Attach dataset's DefaultView to the datagrid control
dataGrid1.DataSource = dataSet.Tables["customers"];
//no adding of new rows thru dataview...
CurrencyManager cm = (CurrencyManager)this.BindingContextdataGrid1.DataSource, dataGrid1.DataMember];
((DataView)cm.List).AllowNew = false;
What's a CurrencyManager? What's the purpose of obtaining the CurrencyManager? Can I do this(shown below) instead?
DataView dv = dataSet.Tables["customers"].defaultview;
dv.AllowNew = false;
dataGrid1.DataSource = dv;
Thanks
kk
|
|
|
|
|
Yes you can.
But this assumes that only a DataTable or DataView is binded to the DataGrid.
Actually any object implementing IBindingList interface can have the functionality of AddNew, producing a new row you are trying to hide. CurrencyManager is a more generic class deriving from
BindingManagerBase.
Search MSDN, you will get a bunch of information..
|
|
|
|
|
ok. thanks. 
|
|
|
|
|
Are you using a .net datagrid? Here is the c# code to hide a column by the index:
myGrid.Columns[0].Visible = true;
Dirk Watkins
|
|
|
|
|
Dear friends,
How are you?
Have you ever found us? anyway, kindly let me take this chance to introduce you our company:
we are a company engaged in Chinese antique furniture and arts and we do wholesale business abroad.We offer furniture such as beds,benches,cabinets,chairs,coffers,stands,stools,tables,desks,Tibetan and Mongolia furnishings and so on.As well as furniture,we have arts,decoratives,architecture and other perfect things.
We have a large warehouse over 93276 square foot area. It has developed many customers in North America, and Canada and other countries. And our price is lower than the others with good quality.
Kindly do not hesitate to let us know how can we help you to support and stand on you. We'll be more than delightful to develop any inquiries you may have and any concern we may help you solve in the future.
Looking forward to hearing from you soon.
Karen
Mingdragon Gallery,BeiJing
Address:No.616 XinDian Village,TongZhou District,BeiJing,China
Voice:13521208079
E-mail:contact@mingdragon.com
Website:http://www.Mingdragon.com 
|
|
|
|
|
karenyuesong wrote: How are you?
Doing grand thanks.
karenyuesong wrote: Have you ever found us?
No, but I wasn't looking and one cannot find that which isn't being looked for.
karenyuesong wrote: Kindly do not hesitate to let us know how can we help you to support and stand on you
You want to stand on me? 
If you would like to advertise on this site, then may I respectfully suggest this link as a starting point: http://www.codeproject.com/info/mediakit[^]
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
karenyuesong wrote: We have a large warehouse over 93276 square foot area.
So your question is about building a database to keep track of this floorspace ?
Or are you the dumbest spammer in history ?
karenyuesong wrote: We'll be more than delightful
I beg to differ. Your behaviour is not delightful, it's annoying.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
While designing my database, I came across a situation where there are multiple candidate keys. So I have assigned one of them as the primary key. But I need to add UNIQUE constraint to the remaining candidate key.
I am using MSDE and Visual Studio.Net 2003 Professional Edition. Is there a way to specifiy such a constraint using the IDE?
|
|
|
|
|
hi guys !
need urgent help
i m making an vb.net application which installs the required tables and triggers on calling
but first i wanna check
through commands that is the specified database exists or not and if not it should also be created through commands.
i m able to create database but unable to check that if it is already exists not to run that creation commands.
can u guys help me.
abhinav
|
|
|
|
|
You've not said what database you are using so I'll assume SQL Server 2000.
You can initially log in to the master database and check the sysdatabases table. e.g.
SELECT name FROM sysdatabases WHERE name=@nameOfDatabase
Does this help?
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
thanx colin it is working sorry didnt mentioned the database .yes it is sql2000
and now it is working..
can u also tellme the way of enumerating databases through vb.net commands i got an example in c#
http://www.codeproject.com/cs/database/SubmitSQLInfoEnumerator.asp[^]
but it is in c# i want to convert it to vb.net or any other eg. like that in vb.net
can u help me
abhinav
|
|
|
|
|
Hello,
i'm working a VC++ class that calls stored procedures using ADO,
and i'd really like to know how to set a VARIANT to a datetime value,
without using COleDateTime class.
so instead of:
_ParameterPtr pParameter = m_pCommand->CreateParameter(
_bstr_t(sParamName.c_str()),
adDBTimeStamp,
adParamInput,
0,
_variant_t(COleDateTime(1998, 10, 1, 0, 0, 0))
);
m_pCommand->Parameters->Append( pParameter);
i'd like to go
VARIANT vMyDate;
...then some how set vMyDate to '1997-10-1 0 '
then...
_ParameterPtr pParameter = m_pCommand->CreateParameter(
_bstr_t(sParamName.c_str()),
adDBTimeStamp, adParamInput,
0,
vMyDate
);
m_pCommand->Parameters->Append( pParameter);
why do i want to do this?
I'm working on an existing program, a massive monster of program with about 60 people working on it.
the existing class has functions which add parameters of various datatypes, but theres no function for datatime.
the program uses its own custom class to handle dates and times, from which i can easily extract formatted strings
I tried to use and the COleDateTime class, but the compiler didn't recognise it:
'COleDateTime' : undeclared identifier
I'd assume that means the correct header hasn't been included.
This is a bit of a problem, my workplace is very political and anti-microsoft (even though we use vc++ and mssql!), i'm very junior here, if i add a microsoft header file there's a very good chance someone senior will take it out and back out my changes.
Is there any chance that the header has been included and i need to specify a namespace?
I tried to add what i thought was the correct header:
afxdisp.h
and i get the error:
c:\program files\microsoft visual studio\vc98\mfc\include\afxv_w32.h(14) : fatal error C1189: #error : WINDOWS.H already included. MFC apps must not #include
can anyone offer me any suggestions?
thanks
Mat
|
|
|
|
|
I need to pull a FIELD value from multiple records from the same table based off of like fields from the records and I dont know how to construct such a query. Here is some sample data:
<br />
71N7R61 GX280 APL VER 1 8.0.0<br />
71N7R61 GX280 APL VDF 1 4417<br />
71N7R61 GX280 APL DRL 1 10/13/2005<br />
71N7R61 GX280 APL ACT 1 VirusScan Running<br />
71N7R61 GX280 APL DIN 1 05/05/2005<br />
71N7R61 GX280 APL NMM 1 Network Associates<br />
71N7R61 GX280 APL NMP 1 McAfee VirusScan Enterprise<br />
71N7R61 GX280 APL NMP 2 MarimbaEndPoint<br />
71N7R61 GX280 APL NMM 2 Marimba Inc.<br />
71N7R61 GX280 APL DIN 2 04/01/2004<br />
71N7R61 GX280 APL ACT 2 Marimba Running<br />
71N7R61 GX280 APL VER 2 6.0<br />
the first 2 fields doesn't matter... primary keys. Third is a component code field, fourth field is a code tells me what the data in the 6th field means, 5th field is the is a sequence number... so in the sample VirusScan is '1' in the sequence of 'apl' applications and marimba is '2'...
now... what i would really like... is a query that would spit out this:
McAfee VirusScan Enterprise VER 1 8.0.0<br />
McAfee VirusScan Enterprise VDF 1 4417<br />
McAfee VirusScan Enterprise DRL 1 10/13/2005<br />
McAfee VirusScan Enterprise ACT 1 VirusScan Running<br />
McAfee VirusScan Enterprise DIN 1 05/05/2005<br />
McAfee VirusScan Enterprise NMM 1 Network Associates<br />
MarimbaEndPoint NMM 2 Marimba Inc.<br />
MarimbaEndPoint DIN 2 04/01/2004<br />
MarimbaEndPoint ACT 2 Marimba Running<br />
MarimbaEndPoint VER 2 6.0
any clues?
-- modified at 18:12 Friday 14th October, 2005
using c#, asp.net, and sql2000 BTW
|
|
|
|
|
Joshua Lunsford wrote: the first 2 fields doesn't matter... primary keys. Third is a component code field, fourth field is a code tells me what the data in the 6th field means, 5th field is the is a sequence number... so in the sample VirusScan is '1' in the sequence of 'apl' applications and marimba is '2'...
You could join the table onto itself like this:
SELECT a.data, b.dataType, b.sequenceNumber, b.data
FROM #MyTable AS a
INNER JOIN #MyTable AS b ON a.pk1 = b.pk1 AND a.pk2 = b.pk2 AND a.sequenceNumber = b.sequenceNumber
WHERE a.dataType = 'NMP'
AND b.dataType <> 'NMP'
As you can see, I've aliased the table so that I can refer to it as "a" and "b" as if they were different tables.
I'm not sure of the importance of the 'APL' in the source data so I've ignored it. However, it may be important and would likely need referencing the join or where clause. The sample data you've given doesn't give any clues.
Also, the first two columns cannot make the primary key because they are all the same through the sample data - I suspect that the first 5 columns make the primary key.
Does this help?
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
thats almost perfect... let me play with that.. ty
|
|
|
|
|
Here you go
CREATE TABLE dbo.ctm
(
Type varchar(32) NULL,
Indx int NULL,
Val varchar(32) NULL
)
go
Insert ctm Values('VER', 1, '8.0.0')
Insert ctm Values('VDF', 1, '4417')
Insert ctm Values('DRL', 1, '10/13/2005')
Insert ctm Values('ACT', 1, 'VirusScan Running')
Insert ctm Values('DIN', 1, '05/05/2005')
Insert ctm Values('NMM', 1, 'Network Associates')
Insert ctm Values('NMP', 1, 'McAfee VirusScan Enterprise')
Insert ctm Values('NMP', 2, 'MarimbaEndPoint')
Insert ctm Values('NMM', 2, 'Marimba Inc.')
Insert ctm Values('DIN', 2, '04/01/2004')
Insert ctm Values('ACT', 2, 'Marimba Running')
Insert ctm Values('VER', 2, '6.0')
select t1.Val1, ctm.Type, t1.Indx, ctm.Val from ctm
inner join
(select distinct Indx, case when Type = 'NMP' then Val end as Val1 from ctm) as t1
on t1.Indx = ctm.Indx
where Type <> 'NMP' and t1.Val1 <> null
|
|
|
|
|
I'm working on a program that needs to be able to update/delete rows in tables which do not (for whatever reason) have primary keys. I've done extensive searching on the subject and so far all I can turn up are suggestions to write my own custom update/delete SQL statements and attach them to the DataAdapter. The problem with this is that this program doesn't connect to one or two tables exclusively; rather, it allows the user to bring up -any- table.
The only thoughts my coworkers and I have had are to use Oracle's (we're using and Oracle database btw) rowid property, or to maintain a server-side cursor and somehow update/delete using that. The problem with these two solutions is:
1) Oracle's rowid is based off the row's location on the hard drive and is unreliable for uniquely referring to a row
2) I've been reading that ADO.NET has no server-side cursor
Does anyone have -any- ideas at all on how to solve this problem?
|
|
|
|
|
Well, it seems like the Table requires some designing. Assuming you cannot change the schema (like me, I had a similar situation), put all the columns with RowVersion.Original into the where clause. Sounds crazy but let me know if there is a better way.
|
|
|
|
|
Unfortunately, no, I can't change the table design - I am just a lowly developer  I thought about generating a where clause like you said, but that doesn't help us if there are two duplicate rows. Anyone have any other suggestions?
I know this has got to be a common problem, how are people solving it?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
