|
Hi guys,
Please help,I am having an issue with data access block connection to the database from my class library project.
using the data access block to connect to database works fine in my website project. but i try creating a separate class library project to connect to the database i now receive an error message.
"The value can not be null or an empty string."
and this is the code:
<br />
Database motomandb = DatabaseFactory.CreateDatabase();<br />
DbCommand motomandbCommand = motomandb.GetSqlStringCommand(query);<br />
<br />
using(DbConnection motomanConnection = motomandb.CreateConnection())<br />
{<br />
DbTransaction motomanTransaction = motomanConnection.BeginTransaction();<br />
try<br />
{<br />
rowsaffected = motomandb.ExecuteNonQuery(motomandbCommand, motomanTransaction);<br />
motomanTransaction.Commit();<br />
}<br />
catch (Exception e)<br />
{<br />
motomanTransaction.Rollback();<br />
}<br />
}<br />
thanks in advance
|
|
|
|
|
saltcode wrote: i now receive an error message.
"The value can not be null or an empty string."
Where?
I'm guessing that it is having problems with the cofiguration file, but without knowing where the error occured it may be somewhere else.
|
|
|
|
|
the error occurred here.
Database motomandb = DatabaseFactory.CreateDatabase();
i don't think is the configuration file bcos i connected to the database normally from the web project appcode folder.
|
|
|
|
|
saltcode wrote: i don't think is the configuration file bcos i connected to the database normally from the web project appcode folder.
You've just extracted this out into its own class library and you are still running it as a web application? Is that right?
Have you tried stepping into the Enterprise Library code and seeing where it's failing in there? Actually, it should tell you in the stack trace for the exception exactly where in the Enterprise Library it failed. Can you copy and paste the stack trace here?
|
|
|
|
|
System.Configuration.ConfigurationErrorsException was unhandled by user code<br />
Message="The type Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging.LoggingExceptionHandler, Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null from configuration could not be created. (c:\\inetpub\\wwwroot\\motoman\\web.config line 57)"<br />
Source="System.Configuration"<br />
BareMessage="The type Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging.LoggingExceptionHandler, Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null from configuration could not be created."<br />
Filename="c:\\inetpub\\wwwroot\\motoman\\web.config"<br />
Line=57<br />
StackTrace:<br />
at System.Configuration.BaseConfigurationRecord.EvaluateOne(String[] keys, SectionInput input, Boolean isTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult)<br />
at System.Configuration.BaseConfigurationRecord.Evaluate(FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult, Boolean getLkg, Boolean getRuntimeObject, Object& result, Object& resultRuntimeObject)<br />
at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)<br />
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)<br />
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)<br />
at System.Web.Configuration.HttpConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String configKey)<br />
at System.Configuration.ConfigurationManager.GetSection(String sectionName)<br />
at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.SystemConfigurationSourceImplementation.GetSection(String sectionName)<br />
at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.SystemConfigurationSource.GetSection(String sectionName)<br />
at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Configuration.ExceptionHandlingSettings.GetExceptionHandlingSettings(IConfigurationSource configurationSource)<br />
at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.ExceptionHandlingConfigurationView.get_ExceptionHandlingSettings()<br />
at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.ExceptionHandlingConfigurationView.GetExceptionPolicyData(String policyName)<br />
at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.ExceptionPolicyCustomFactory.GetConfiguration(String id, IConfigurationSource configurationSource)<br />
at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.ExceptionPolicyCustomFactory.CreateObject(IBuilderContext context, String name, IConfigurationSource configurationSource, ConfigurationReflectionCache reflectionCache)<br />
at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.ConfiguredObjectStrategy.BuildUp(IBuilderContext context, Type t, Object existing, String id)<br />
at Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext context, Type typeToBuild, Object existing, String idToBuild)<br />
at Microsoft.Practices.ObjectBuilder.SingletonStrategy.BuildUp(IBuilderContext context, Type typeToBuild, Object existing, String idToBuild)<br />
at Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext context, Type typeToBuild, Object existing, String idToBuild)<br />
at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.ConfigurationNameMappingStrategy.BuildUp(IBuilderContext context, Type t, Object existing, String id)<br />
at Microsoft.Practices.ObjectBuilder.BuilderBase`1.DoBuildUp(IReadWriteLocator locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[] transientPolicies)<br />
at Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp(IReadWriteLocator locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[] transientPolicies)<br />
at Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp[TTypeToBuild](IReadWriteLocator locator, String idToBuild, Object existing, PolicyList[] transientPolicies)<br />
at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.EnterpriseLibraryFactory.BuildUp[T](IReadWriteLocator locator, String id, IConfigurationSource configurationSource)<br />
at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.LocatorNameTypeFactoryBase`1.Create(String name)<br />
at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.ExceptionPolicy.GetExceptionPolicy(Exception exception, String policyName)<br />
at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.ExceptionPolicy.HandleException(Exception exceptionToHandle, String policyName)<br />
at Motoman.Atn.Dal.PinNumberDB.Save(String sourcefilepath, String formatfilepath) in C:\Documents and Settings\Developer\My Documents\Visual Studio 2005\Projects\motoman\MotomanDAL\PinNumberDB.cs:line 93<br />
at Motoman.Atn.BLL.PinNumberManager.PinSaves(String filepath, String formatfilepath) in C:\Documents and Settings\Developer\My Documents\Visual Studio 2005\Projects\motoman\MotomanBLL\PinNumberManager.cs:line 31<br />
at _Default.Page_Load(Object sender, EventArgs e) in c:\Inetpub\wwwroot\motoman\Default.aspx.cs:line 18<br />
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)<br />
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)<br />
at System.Web.UI.Control.OnLoad(EventArgs e)<br />
at System.Web.UI.Control.LoadRecursive()<br />
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<br />
|
|
|
|
|
Have you included all the relevant DLLs in the references section. Parts of the Enterprise library load dynamically, so Visual Studio is not completely aware of their necessity so it cannot warn you at compile time. You need the DLL that includs this class:
Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging.LoggingExceptionHandler
The DLL you need is: Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging.dll
It can probably be found in the folder:
C:\Program Files\Microsoft Enterprise Library January 2006\bin
|
|
|
|
|
Hello
I have programmed a win-form project in c# with included crystal reports in vs 2003 (crystal report version 9 / bundle).
After that i created a setup project to share my programm.
vs 2003 found automatically all dependencies:
- crystal_database_access2003.msm
- crsytal_managed2003.msm
and it works great.
Now i want transfer that stuff to .net 2.0 + vs 2005 and want to create a setup project in vs 2005 with the same functionality. if i start now to define the primary output in vs 2005 it doesn't show the dependencies like in vs 2003. it also runs but only on stations where vs 2005 installed. its seems that's not enough to install .net 2.0 ?!
If i try to run the program on a station without vs.net 2005. only .net 2.0 installed.
the following error-msg appears:
"The file or assembly CrystalDecision.CrystalReports.Engine, Version=10.2.3600.0, Culture = neutral, PublicKeyToken= 692fbea5521e1304 or a dependencies could not be found. The System could file not found."
Its seems to be a problem with the different Crystal Reports Version.
How could this be able to solve ?
Thanks a lot !
lutz
-- modified at 8:44 Thursday 15th March, 2007
|
|
|
|
|
Hi,
don't know why he doesn't find those merge modules automatically anymore but you could add them manually. They should be placed under "Program Files\Shared Files\Merge Modules".
Robert
|
|
|
|
|
|
I need to populate a listbox named "subcategory" once the user clicks his desired selection in dropdownlist named "category" e.g. c++ has subcategories polymorphism,inheritance etc.
please help me thru code
|
|
|
|
|
manugrg wrote: help to new Programmer
This is a useless subject line.
Everyone asking questions on this forum is looking for help
The fact you are a new programmer has no relevance to your problem.
A better subject line would be "Problem filling listbox on dropdownlist selection"
|
|
|
|
|
Is there some way to use a maskedtextbox for percentages, so that validation would become easier.
There is mask for date, time, and etc., but no mask for percentages. Or does it have to be customized.
|
|
|
|
|
I have made a usercontrol that is basically a container with a nice looking header and an area for content. How do I add the usercontrol to another window and allow me to add other elements to the content area of the control? More specifically, I would like to be able to add the control to a window in blend double click it (change the insertion point) and add other controls as children of the usercontrol and they appear in the correct area. What do I need to do?
|
|
|
|
|
I have a DataTable with my data stored in it, as follow:
ID , Surname , Name
----------------------
null , Parker , Peter
null , Kent , Clark
in C# I create my SqlDataAdpater and SqlCommandBuilder and use adapter.Update(table) to populate the database with my two rows. So on the database side my two rows have their unique Id's now.
What I want to know is how can I update my table with those two Id's? I don't want to retrieve all the data in the database, just the 2 ID's or rows with their new ID's.
One solution I thought off(really a bad idea), is using adapter.Update(rows[] and after a update call "SELECT @@IDENTITY" for each row. I don't like it and don't want to do it but I don't have another way to retrieve the ID's, or do I?
Any help would be appreciated.
Regards,
|
|
|
|
|
Hi all,
Currently I am making one win32 application using VC++.NET 2003. I am using screen color matching for some purpose in the application. But when I changes color depth of screen from 32 bits to 16 bits it is not working because color values of R, G and B are changes. Is that possible to map 32 bit colors to 16bit or vice versa so I can compare them?
Thanks in advance,
Priyank
|
|
|
|
|
Hi,
I am using Asp.net and vb as code behind. I want to connect to Sybase database. I am using sybase sql anywhere . I hve draged and droped odbcconnection and odbc adapter and dataset but nothing is displaying.
if i give odbcadapter1.Fill(dataset11) its showing error
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Pls tell me how can i specify the connection sting and how to connect to sybase database
Can anybody help me plsssssss.
Thanks in Advance
Thanks and regards
|
|
|
|
|
micydon wrote: I am using Asp.net and vb as code behind
Perhaps the ASP.NET forum would be helpful?
led mike
|
|
|
|
|
Can any body tell me how i can convert a DOC file (word document) into a BMP image. Is there any Active-X control for this purpose.
|
|
|
|
|
You do know that this is the .NET forum don't you?
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
With VisualStudio.Net, i'm using an installer class with a custom action
on my setup project to ask the user a serial number. A "Textboxes"
dialog on the "user interface" provides the serial number string to an
overrided version of then install procedure, inside my installer class.
My problem is that the install sub is able to verify the serial number
entered, but then i can't stop/cancel the installation procedure.
|
|
|
|
|
Hi there,
I'm new to .net programming and I've been using C++/CLI to develop a new application. I now have the following problem:
I have a Timer which has an ElapsedEventHandler defined.
Acoustics::Acoustics()
{
timer = gcnew System::Timers::Timer();
timer->Elapsed += gcnew ElapsedEventHandler(this, &Acoustics::timerUpdate);
}
void Acoustics::timerUpdate(Object^ sender, ElapsedEventArgs^ e)
{
ch->LastRxSignalElapsedTime += TimeSpan::FromSeconds(0.1);
ch->LastTxSignalElapsedTime += TimeSpan::FromSeconds(0.1);
}
"ch->LastRxSignalElapsedTime" and "ch->LastTxSignalElapsedTime" are properties in this class.
In the GUI, I define some bindings to these properties:
Label ^labelchrxtimer = (gcnew Label());
labelchrxtimer->DataBindings->Add(gcnew Binding("Text", kvp.Value, "LastRxSignalElapsedTime"));
Label ^labelchtxtimer = (gcnew Label());
labelchtxtimer->DataBindings->Add(gcnew Binding("Text", kvp.Value, "LastTxSignalElapsedTime"));
Now, when ElapsedEventHandler is executed, it is in a different thread, so the labels are not automatically updated by the bindings because the properties were changed by a different thread than the one that created the labels.
How can I have the labels correctly updated?
Thanks,
Spulit
|
|
|
|
|
Hey Guys,
I have a vb.net app that I would like to have upload a text file to an ftp server. Is there a .NET class for doing this? I can't find much on "the google".
|
|
|
|
|
There's an FTP Client implementation in the System.Net namespace in the .NET Framework 2.0, called FtpWebRequest[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi all,
I have a form that contains one button and one textbox, the textbox will take a number that will be passed to another form. I have done this successfully.
The thing is that I need the second form to create a number of pictureboxes = the number received from the first form.
Any ideas?
|
|
|
|
|
sarah_malik wrote: Any ideas?
You have not really asked any question!
Creating Picture box is well documented in the MSDN
PictureBox picBox = new PictureBox();
picBox.Location = new Point(0, 0);
picBox.Size = new Size(10, 10);
picBox.TabStop = false;
picBox.SizeMode = PictureBoxSizeMode.StretchImage;
picBox.BorderStyle = BorderStyle.Fixed3D;
this.Controls.Add(picBox);
and you can loop to the number required and create any many as you wish.
If your question is on positioning of the picture boxes, then if you are using .NET 2 then consider using any of the Layout Panels objects like TableLayoutPanel.
Best regards,
Paul.
Jesus Christ is LOVE! Please tell somebody.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
