| Column Expression question |
|
 |
Index ‹ DotNet ‹ ADO
|
- Previous
- 1
- 2
- 3
- ADO >> Tablemappings and join?Hi,
I have this sql command:
Select recommendation, timescale from audits, auditItems where
AuditItems.ParentAuditID = Audts.AuditID and Audits.SupplierId = '" &
ComboItem.Value & "'"
So what do i set tablemappings to?
I usually do this:
myDataAdapter.TableMappings.Add("Table", "Audititems")
but that doesnt work... Any ideas?
Thanks,
Dan
- 4
- Net Framework >> Wrong Byte order when writing with a binary writerHi!
I have the following problem:
I want to write an integer value (e.g. 14) with a binarywriter.
The written file contains the following entry:
0E 00 00 00
I want the entry to be the following:
00 00 00 0E
Does anybody know how to get the desired result (Language vb)?
Thanks in advance,
Marko
- 5
- Microsoft Project >> "resource usage"- view errorHi..
I open a Project and use the reource-usage view. I choose a resource and
look at the actual work by other enterprise Projects. The actual work of
all the other projects is 0 although I am sure thet they are not .
What is the reason for this problem?
Thanks..
- 6
- Net Framework >> Updating a windows forms control from a threadI've gotten this question a couple of times in interviews and I don't know
what they are looking for:
How do you update a control's property, such as a textbox.text property,
from a thread, in .NET? It seems to me you just update it normally. What
are the interviewers looking for here? Thanks.
- W
- 7
- Dotnet >> icon for desktop shortcut not workingHi all,
I am attempting to deploy a vb.net application. That is working fine.
I also configured the installer so shortcuts for the application
would appear on the desktop and the user program menu. That's working
too. What isn't working is the icon that I am setting for these
shortcuts. The icon is a .ico file that works fine for the program
itself, and for any shortcuts that I manually create. After I created
the shortcuts of the primary output in the file system editor, I set
the icon property to my .ico file. However but the shortcut s that
result from installation still show your basic, generic "file" icon.
Anybody have any idea why the icon isn't appearing on the shortcuts
created by installer? I followed the .net help file instructions
exactly!
thanks,
Mike Cooper
- 8
- 9
- ADO >> Convert System.Transactions.Transaction.Current to System.Data.Common.DbTransaction?I have been trying to figure out a way to convert
System.Transactions.Transaction.Current to System.Data.Common.DbTransaction
with no luck so far. Is this even possible? I am using the Enterprise
Library, and several of their calls take in a transaction, but it is of type
DbTransaction. I have tried straight casting, but it is not compileable.
DbTransaction transaction = (DbTransaction)Transaction.Current;
Error 1 Cannot convert type 'System.Transactions.Transaction' to
'System.Data.Common.DbTransaction'
- 10
- Visual C#.Net >> Windows Services and System.Web.UI.Page.RequestHi.
I am wondering how to handle AbsoluteUri values inside windows
services?
It seems that the absoluteuri is called from the System.Web.UI.Page
namespace
which is not allowed inside a windows service (that I am aware of).
But, I need to call the following inside my service:
Request.UserAgent,
Request.UserHostAddress,
Request.Url.AbsoluteUri
Since I can't use the Request object (in the sense of
System.Web.UI.Page),
how do I access the above values from within my service??
Thanks for your help.
Peter
- 11
- Microsoft Project >> Project 2007 Not Enough Memory to PrintOur schedule won't print more than once at a time. If we do a print preview,
it won't print at all. The message, "There is not enough memory to complete
the operation. To free up available memory, close programs, projects, or
windows you aren't using, and then try again." I can close all but Project,
and it still won't print. The only thing that works is to close Project,
reopen it, then open the project without previewing it. It prints fine, but
cross your fingers. If it is two pages wide, you won't know until you waste
a ream of paper.
- 12
- Visual C#.Net >> Running code compiled in Framework 1.0 with Framework 1.1Hello,
We have an application written using Framework 1.0 (VS2002), we have
deployed it to a server that only has Framework 1.1 installed, the
client does not want to Install Framework 1.0 because it might have an
impact with other .Net applications written using Framework 1.1, so
rather not getting into a debate with the client I have agreed to
investigate if we could get our application to run using Framework 1.1
without recompiling it. Is this possible, if so how?
Thanks,
- 13
- Visual C#.Net >> MSMQ triggerApart from designing a timer to examine the queue, I know
that the new version of MSMQ over XP/2003 platform
provides a way called 'MSMQ trigger', anyone had some
experience of using it from programmer's point of view?
thanks in advance
- 14
- Winforms >> New to WindowsFormsHi I am learning windows fomrs and started with the sample in the quickstart
tutorials and I am not able to display the control on my aspx page.
I created a control library with one simple control having a panel and a
button. panel's visible property is false by default and I added color to
panel.
On the button press event , I set the visible property of the panel to true
to show the panel.
This control is created as test1.dll and then added to a web application and
added to aspx page as an object and calling with the classid property to
display the control. I have also set the objects property "VIEWASTEXT' .
The problem is that the aspx page does show the placeholder but does nto
display the control.
what am I doing wrong?
Please advice.
thanks
sam
- 15
- Microsoft Project >> Printing in MS Project 2007Does printing in MS Project 2007 just not work like it did in 2003.
I am having a terrible time getting all my info on my gantt chart to print
and it will not do a "fit to" at all.
Starting to wonder if I should just go back to 2003.
Extremely frustrated.
|
| Author |
Message |
AnthonyD
|
 Posted: Fri Feb 20 04:50:22 CST 2004 |
Top |
ADO >> Column Expression question
Hello!
After filling table into DataSet (ds), I added following line ...
ds.Tables(0).Columns("MyColumn").Expression = "<MyFormula>"
... and calculation is working fine - but I need to save this calculated
field value into database also because it makes easier to make SELECT
queries later and it's quite often needed value in many cases too. This
"MyColumn" is as a field in database too, and is used too when making
DataAdapter in SELECT-query.
When trying to save, I'll get error message ...
"The column mapping from SourceColumn 'MyColumn' failed because the
DataColumn 'MyColumn' is a computed column."
Is it possible to save computed column values into database table at all?
--
Thanks in advance!
Mika
DotNet441
|
| |
|
| |
|
Miha
|
| Posted: Fri Feb 20 04:50:22 CST 2004 |
Top |
ADO >> Column Expression question
Hi,
One solution would be to add a column to table (before saving) and copy
computed values to it.
Then use that column to store data.
The other way would be not to use expressions at all - rather compute it by
yourself.
--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com
"Mika M" <EMail@HideDomain.com> wrote in message
news:%EMail@HideDomain.com...
> Hello!
>
> After filling table into DataSet (ds), I added following line ...
>
> ds.Tables(0).Columns("MyColumn").Expression = "<MyFormula>"
>
> ... and calculation is working fine - but I need to save this calculated
> field value into database also because it makes easier to make SELECT
> queries later and it's quite often needed value in many cases too. This
> "MyColumn" is as a field in database too, and is used too when making
> DataAdapter in SELECT-query.
>
> When trying to save, I'll get error message ...
>
> "The column mapping from SourceColumn 'MyColumn' failed because the
> DataColumn 'MyColumn' is a computed column."
>
> Is it possible to save computed column values into database table at all?
>
> --
> Thanks in advance!
>
> Mika
>
>
|
| |
|
| |
|
| |
|
Index ‹ DotNet ‹ ADO |
- Next
- 1
- ADO >> Can't find primary keyI have a dataset that I first do a FillSchema(dataset, SchemaType.Mapped, "Table") on, and yet it still throws System.Data.MissingPrimaryKeyException when I do a dataset.tables("Table").Rows.Find(key).
The column is marked as a primary key in the table and the sql statement is just "SELECT * FROM tableName"
Anybody have any idea why this can happen?
P.S. Sorry if I didn't give enough info, but I am patching together someone else's mess, so I haven't gotten a chance to read it all yet.
-Thanks
- 2
- Winforms >> VB6 Form Upgrade to .Net ErrorI am upgrading a VB6 application to VB.NET. In the VB6 application I have a
form with a sub called ShowScreen that takes arguements. This has always
worked with no problem/ When I try to upgrade I get the Buil error
"'ShowScreen' is not a member of 'System.Windows.Forms.Form'".
How do I resolve this issue? This might be related to the issue for some of
my Sheridan controls "losing" some of their properties and methods.
Thanks,
Kirk
- 3
- Microsoft Project >> Project should provide "print across then down" like ExcelIs there a way to "print across then down" in MS Project like you can do with
Excel? I'm printing my Gantt chart 2 pages wide by 5 pages high, and it's
annoying that the bars that go with page 1 are on page 6.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=941d70e0-2117-47fa-a491-1ff5a3154e4d&dg=microsoft.public.project
- 4
- 5
- Visual C#.Net >> Modify IIS Folder PermissionI need to change Directory Security permission on folders under the IIS
default web site tree:
Internet Information Services
- Machine Name
- Web Sites
-Default Web Site
+testfolder
Specifically: on the the Directory Securty Tab (right click on a folder
under the Default Web Site) click the edit button next to Anonymous access
and authentication control, uncheck Anonymous access, check Basic
authenticatoin and enter Domain and password...and finally uncheck Integrated
Windows authentication.
I may have chosen the wrong class "IIsWebFileSetting" to change the
properties described above...which also could have added to the confusion.
I am using windows server 2000, with IIS 5.0
I know in the end we are really just changing/entering data in the IIS
metabase, right?
Thank you so much for taking the time to help....I'm really stuck on this one.
Mark
- 6
- ADO >> Data column expressionHi,
Consider the following code statement:
dstest.Tables("test").Select("intfield = " + CStr(intval))
Suppose table test has the column name "intfield" with
int32 datatype. Let's dataset test contain the following
rows
Test:
Col 1, Col 2, Col 3 ..., "intfield", ... ,Col 1[0-9]
* , * , * ..., 17 , ... , *
* , * , * ..., 16 , ... , *
* , * , * ..., 6 , ... , *
Could the result of the statement return 0 row if the
intval has the value 6?
It shouldn't, right? However, what we had found for the
return number of rows is really 0. Why is that?
Best regards,
KPH
- 7
- Microsoft Project >> Project 2003 Custom Form, macro & toolbarI have created a custom form in VB, a custom toolbar and a custom macro to
run the VB form from Project. I am able to get the custom toolbar to run the
form on my local MS Project, but when I create a template, and another person
opens the template, the custom toolbar to run the form doesn't appear. I
have gone through the riggamarole of the organizer to ensure that everything
exists in the global template and the custom template, but still doesn't work.
Any ideas?
Thanks!
- 8
- Microsoft Project >> Lot production schedule which identifies the Numbers of Lots Released over time?Hi,
I'm working on an Urban Development Program in MS Project 2000. Basically
we are Civil Engineers who design subdivisions of large landholdings for
developers. We subdivide the land into smaller lots in stages. Each stage
has a construction start and finish date, cost and number of lots released.
It is important for the Developer to have a particular number of lots
available for sale each year.
Using the Gantt Chart and the Entry: Table, my project header looks like
this;
ID, Task Name, Duration, Start (Date), Finish (Date), Construction Cost ($),
Lots Serviced (No), Lots Released (No), Predecessor
I've added fields such as "Lots Serviced" and "Lots Released" as Number 1
and Number 2 Customised Fields. Among other things, i would like to produce
a lot production schedule which identifies the Numbers of Lots Released over
time. I've tried to create a report or use "Analyze timescaled Data in
Excel" to generate what i require.
How do I produce a lot production schedule which identifies the Numbers of
Lots Released over time.
Any help would be appreciated. Thanks
Troy
- 9
- Visual C#.Net >> IsAccountLocked and LDAPI think IsAcountBlocked does not work with Active Directory if the conection is an LDAP:// configuration. Am I right? Does someoe have an example with WinNT://
Thanks
Jason
- 10
- 11
- Microsoft Project >> SQL to MppHi guys/gals,
I have been administrator for MS Project 2000 for a while
now. It has always been the case that our projects are
stored in a SQL database.
We have a complicated structure with actual projects,
consolidated master projects on several levels, milestone
projects (where all actual projects are linked upto)
We suddenly have to extract actual & milestone projects to
mpp files so that it can be viewed by an outside source.
Lets just say that just by attempting to do this, has run
into major problems. I would compare it to medevil heart
surgery!!! ripping someones heart out, and shoving it into
an open chest and expecting it to work!!!!
Is there a reliable proceedure of how to do this???
Thanks in adv
Robert
- 12
- 13
- ADO >> Problems with return parameter from Oracle functionI have an oracle function that looks like this:
AuthenticateUser(UserName IN VARCHAR2, pPassword IN VARCHAR2, AppName IN
VARCHAR2) RETURN VARCHAR2
Using the Oracle client provider, I'm setting up my command text as:
:results = call AuthenticateUser(:username, :password, :appname)
I then add parameters as follows:
OracleParameter p = new OracleParameter("results", OracleType.VarChar);
p.Direction = System.Data.ParameterDirection.ReturnValue;
p.Size = 255
xcmd.Parameters.Add(p);
xcmd.CommandText = _authenticateCall;
xcmd.Parameters.Add(new OracleParameter("username",
OracleType.VarChar)).Value = "abc";
xcmd.Parameters.Add(new OracleParameter("password",
OracleType.VarChar)).Value = "123";
xcmd.Parameters.Add(new OracleParameter("application",
OracleType.VarChar)).Value = "Test";
However, when I execute the command, I get an ORA-01036: illegal
variable name/number exception.
If I leave out the :results paramater from both the command text and
don't add it to the parameters of the command, then I can call the
function w/o the exception. So it seems like .Net can't figure out how
to bind my parameters correctly (this is more or less confirmed by the
stacktrace of the exception).
In every example I've seen, this is the recommended way of calling a
function. What am I missing that would make it bind the return parameter
correctly?
- 14
- Microsoft Project >> How to extract the total number of work days in a month?I am creating a report using Reporting Services. The report should contain a
list of employees and the amount of work done during a month (Actual work)
for each employee as well as the total number of work days in the month. As
all information should be extracted from Project Server database, I need to
create stored procedures to do so. All managers of the company use Project
Professional to access Project Server database.
So far I have not had any problems with the list of employees and actual
work done during a month. But I encountered a problem with extracting the
total number of work days in a month. Obviously, to calculate it, I need to
subtract the number of non-work days from the total number of days in a
month. Project Professional displays such information in the Calendar, which
means that the data can be extracted from the Project Server database, but I
can not find where the data is stored and how it can be consolidated. I have
already examined the docs carefully and tried to identify the query with SQL
Profiler, but without success.
Could you please help me to extract the total number of work days in a
month?
- 15
- Winforms >> TopMost problemHi guys.
I am writing an aplication with C#.Net in VS.Net2003
I have a Mdi form wich has 2 child forms.
How can I set one of the child forms as a topmost ?.
When I set TopMost property to true it does not work.
I tried every thing but nothing helps.
Can anyone send me an example of code.
Thanks
|
|
|