|
Sir/Madam,
I am creating the table at run time in MS-Access using vb.net.now the problem is , I wanted to know , Whether Can I programically ascertain , The table that i generated programically at run time , exist any more , or it is droped.
Please help.
Thanks and Regards
Pankaj
|
|
|
|
|
SoapWrapperHandler – Right Exception is passing as a parameter but return “Application Fault”
ExecuteHandlerChain – ExceptionPolicyEntry – “Application fault”
Handle – chainExecution – Input is passing as a “Message not found”, which is MQException and return “Application fault”
RethrowRecommended – IntentionalRethrow – ChainException – Message in Base 64.
Try // Here Input Exception is applicationfault
My code
Catch (ex as SoapException) .
throw EDF.Exceptions.ExceptionHelper.GetServiceException(ex);
End Try
// GetServiceException throw a different Exception ‘Exception has been thrown by the target of an invocation’
Exception raised by GetServiceException is of type TargetInvocationException, which is raised at the time of deserializing it.
Exception is raised at the time of deseriazing it, appException = TryCast(sf.Deserialize(strm), Exception)
Exception – TargetInvocationException
Message – Exception has been thrown by the target of an invocation.
InnerException – Object must implement Iconvertible
Source - mscorlib
While Original SoapException is “App. Fault” and its Innerexception is null.
|
|
|
|
|
This is just a series of somewhat disjointed statements. Is there something you wanted to ask?
I'm going to guess that the question might be: Why do I get the TargetInvocationException when I expect a SoapException?
The reason is that the fault is not in the SOAP part of the request. You mention that it is raised during deserialisation which indicates that the framework is having difficulty reconstructing your object. Specifically the deserialisation process is using reflection and the target (object) that reflection is using does not support what ever it is trying to invoke.
You may find it easier to create some unit tests around the serialisation/deserialisation process to determine where the problem lies rather than attempt to debug it with the overhead of SOAP interaction.
|
|
|
|
|
Hi there,
I have done a search for generating random numbers and have come up empty, as anything i have read does not make any sense to me. 
Could someone please show me how i could do this.
What i would like to do is get a random number between to numbers, sound simple does it not.
|
|
|
|
|
It sure is simple. Are you using VB.NET ? If so, Random.Next is all you need.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Christian Graus wrote: It sure is simple. Are you using VB.NET ?
In this forum, you have to ask the above question quite often. It's boring..., VB6 and VB.NET are completely different topics.
Sorry, I want only to share a bit my frustration...
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
MSDN is your best friend, for instance:
To produce random integers in a given range, use the following formula.
(Visual Basic)
randomvalue = CInt(Int((upperbound - lowerbound + 1) * Rnd() + lowerbound))
if you use .NET then you have to deal with Random class, again, MSDN will help, see here.
To obtain more detailed help, please, clearify your needs (e.g. Do you need integers or double numbers?) and tell me the programming language you intend to use.
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
Thank you for your replys. 
This is what i had and was not doing the job(kept on going out of bounds,which cause an error)
RandomValue = CInt(Int(upper) * Rnd() + lower)
your code fixed that problem in the test app. Will try in in my app.Just to make sure it works;)
oh, BTW i forgot to say which language i was using thought that you would have been a mind reader 
I am using VB2005.
I am back, thought i used the same post....
I changed your line to the following :-
RandomValue = CInt(Int(upper - lower + 0) * Rnd() + lower)
works perfectly now.
Thank again for all your replys.
-- modified at 5:36 Friday 5th January, 2007
|
|
|
|
|
If you are using VB2005, then dont use the solution provided, as it is for VB6. Use VB.NET, which means Random.Next
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Wel l my system will not recognize the command .next with the Random command????
|
|
|
|
|
Public Class Form1
.
.
Private RNG As New Random()
.
.
.
Dim newInteger As Integer = RNG.Next(0, 1000)
.
.
.
Seriously, pick up a beginners book on VB.NET. This is an easy one that gave you a ton of trouble. Learn the basics before you frustrate yourself out of doing this.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Everything is EASY, once you have done it.... My Friend;P
and i have a book but it does not say anything about random numbers.....
Mastering VB2005 EE
As allways, Thank You for your input.
|
|
|
|
|
WestSideRailways wrote: Everything is EASY, once you have done it....
That's true. But, if you couldn't follow the MSDN help, then the problem is not a book on VB, it's knowing enough VB to be able to navigate sources of new information. I second what Dave said, you need to learn some basics, so that you're able to use information sources. I expected you to realise I was telling you that there's a Next method on the random class, and to be able to work out that you need to create an instance of the Random class.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
The idea of being a good gru , is knowing that not every body it at the same level as yourself.
and sometimes you might have to come down off the high horse and help the people , by explaining what you have said in more detail. Don't expect some people to know what you are talking about , just because you do. I know it a bad habbit that we all do to other people at work, myself included.
Hopefully you don't take this the wrong way.Was not meant to be taken the wrong way, I am just giving my opion on the matter. Again hopefully when i ask another question you might remember this and answer in a more explain way.
|
|
|
|
|
Well, had Dave not stepped in, I would have answered in more detail. The truth is, I give a first answer that means that anyone with access to google has all they need. Anyone who proves incapable of using google, or perhaps, understanding what MSDN says, I will give deeper help. But, spoon feeding people on every simple question, that can be answered by google in seconds, is not helping them. I'm trying to teach people how to search for information themselves, when the question is trivial.
And that's what someone who wants to help *should* be doing. No matter what your opinion, if you ask more, I will answer again. I don't keep track of what people say in the past, or keep a list of people to help, or not help.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
It wasn't the topic of random numbers that was giving you the problem. The Random class is just like any other. Instantiate the class, which is then called an "object", then call the methods or set properties on it. The entire .NET Framework works, at a minimum, just like this.
There is, of course, far more to the rest of the Framework, but once you understand the basics of how to instantiate a simple class, like Random, and use it, you can pretty much find your way through the MSDN documentation and figure out how more complex classes work.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi! Counld you help me please?
I want to get the name of SQLServer 2000 and put it into a combobox, SQLServer may be on my computor and may be on Server in my network (my computor is a workstation but it has SQLServer 2000 too). How can I do that, I until use vb.net 2003
Thanks a lot.
|
|
|
|
|
|
|
|
i use vb.net 2003 and not c #
|
|
|
|
|
Hi!
I had refer that URL, but until get error message
I had reference SQLDMO and declare:
private SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass();
SQLDMO.NameList sqlServers=null;
this is my code:
private void Form1_Load(object sender, System.EventArgs e)
{
try
{
sqlServers = sqlApp.ListAvailableSQLServers();
for(int i=0;i<sqlServers.Count;i++)
{
object srv = sqlServers.Item( i + 1);
if(srv != null)
{
this.cboServers.Items.Add(srv);
}
}
if(this.cboServers.Items.Count > 0)
this.cboServers.SelectedIndex = 0;
else
this.cboServers.Text = "<No available SQL Servers>";
}
catch(Exception err)
{
MessageBox.Show(err.ToString(),"Error");
}
}
and i get an error:
System.InvalidCastException:QueryInterface for interface SQLDMO.NameList faild at SQLDMO.ApplicationClass.ListAvailableSQLServer() at ....
Cuold you help me, please.
|
|
|
|
|
Hi
I hope this is the right forum for ths, if not, please direct me to the right one.
I looked at DAAB Ent LIb 2.0 January 2006 release. But I did not want to sprinkle the DAAB DLLs all over my different applications. Also, I wanted to de couple my dependency
on DAAB such that when a newer version comes and there are breaking changes, I can make
those changes only in the wrapper and not in all my projects.
Hence I wanted to create a wrapper on top of it.
I created a wrapper allright, my idea was that I would return data readers, datasets
and adapters from the wrapper. I would then use this wrapper in my app logic layer to get/set data.
However, as the reader requires an active connection, I could not pass it through layers.
Same for Command objects.
I could, however, pass the data table from the populated dataset.
Then I exposed a GetConnection method from the wrapper and returned the conn object.
I would then use it in App Logic layer to create a datareader etc.
However, this approach seems like a hack rather than an elegant solution.
Any ideas about how I can go about this?
Shreekar
|
|
|
|
|
shreekar wrote: I would then use it in App Logic layer to create a datareader etc.
However, this approach seems like a hack rather than an elegant solution.
Any ideas about how I can go about this?
Data Readers, Connections and so on should stay in the DAL (Data Abstraction Layer - i.e. your wrapper). If you must, create data tables and data sets to pass data out of the DAL. It isn't something I'd do, but it is the easiest thing to do.
|
|
|
|
|
Thanks a lot for your comments. I think I will settle with the datatable solution for now.
On a side note, I have read somewhere that the TableAdapter can be used as a replacement for DAAB. Currently, I am using TableAdapters in some forms of the application and after I resolved the connection string issue, it seems to work well. But I am not fully convinced about how well it will handle header-detail or multiple table relationships.
The way I see it, using the Table Adapters, I get strongly typed datasets which I will miss in DAAB, but in DAAB, I can design the App Logic Layer and sort of keep it separate from the DAL.
Before going the full distance with the DAAB/Table Adapters, I would like to know the pros and cons between using DAAB and Table Adapters.
Any thoughts on this?
Shreekar
http://shreekarishere.blogspot.com
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
