|
Please how can I insert a table in an excel file into an sqlserver table programmatically using C#.
|
|
|
|
|
Don't cross post.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
hi
i want an article that use reporting services in Visual C#2005, i found many article that show how to design a report, and i know this and know i must use ReportViewer, but i don't know how to use my reports in Visual C#2005 projects and how to set parameters and so on..
can anubody help me ?
thanks
|
|
|
|
|
There is a reportviewer control in Visual Studio which you can use for displaying your reports. Reports can be either local or server reports.
|
|
|
|
|
You should find the following site[^] useful.
However, the site doesn't appear to be working at the moment...
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
thanks pmarfleet
but i could not open this site, can u give me another site ?
|
|
|
|
|
Yes, I modified my post when I tried to access the site and the link didn't work. It used to though...
The only other site I can suggest you look at is MSDN[^].
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
thanks for your post
my problem is also solved, but now i want to send parameter to my report programmatically, can anyBody help me ?
|
|
|
|
|
You can use setparameters method
|
|
|
|
|
Can any body suggest. It's urgent for me, please guide me...
srinivas.
|
|
|
|
|
|
|
Nothing built into VS2008 as far as I know.
|
|
|
|
|
You appear to know what he is talking about, care to clarify?
|
|
|
|
|
I assume he meant IE extensibility integrated into VS, similar to how Office extensibility is built-in to VS.
|
|
|
|
|
nope..What i mean is reverse to above i.e., VS 2008,Office extensibility was very goood, and we can able to write add-ins very easyly and so flexible. like that, is there any thing for IE
nch srinivas
|
|
|
|
|
sorry, Yes what you said was correct. Is there any extensibility?
|
|
|
|
|
can we use c# for web development as well....?
|
|
|
|
|
|
ajhhuer wrote: can we use c# for web development as well....?
google, ask, yahoo, livesearch. Any of these ringing a bell with you at all?
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Ummm, yes, you can.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Ok, I have a class with say 4 string value properties. In an old version of the .dll this class is serialized into an arraylist using the following methodology
ArrayList list = new ArrayList();
foreach(MyClass class in MyClassCollection)
{
List.add(new object[]{class.Property1,class.Property2,class.Property3,class.Property4};
}
Then the ArrayList would be serialized.
When used it would be Deserialized into an ArrayList and then a new object would be instantiated for each object array in the arraylist. Are You Following me?
Now here is my problem, I have been tasked with writing a newer version of the software in VS.net C# 2005. I cannot deserialize the ArrayList of string arrays because it tells me that it cannot find the .dll that this ArrayList was origionally serialized from, even though only string values were put into the ArrayList when it was serialized. Any help or am I gonna have to write a convertor to convert the files to the newer version.
"All of us who served in one war or another know very well that all wars are the glory and the agony of the young."
Gerald Ford
|
|
|
|
|
http://msdn.microsoft.com/msdnmag/issues/02/04/net/[^]
"Finally, when serializing an object, the full name of the type and the name of the type's defining assembly are written to the byte stream."
I strongly suggest you do some reading on .NET Serialization. That article might be as good a place to start as any.
|
|
|
|
|
Considering that the application that serialized the object is not the .dll and the values that went into the arraylist are the string values of the .dll class and not the class itself being serialized why would it write the typestring and type into the stream. I can see if you are serializing an object but not an array of strings.
"All of us who served in one war or another know very well that all wars are the glory and the agony of the young."
Gerald Ford
|
|
|
|
|
Sautin.net wrote: because it tells me that it cannot find the .dll that this ArrayList was origionally serialized from,
Sautin.net wrote: Considering that the application that serialized the object is not the .dll and the values that went into the arraylist are the string values of the .dll class and not the class itself being serialized why would it write the typestring and type into the stream. I can see if you are serializing an object but not an array of strings.
At some point you did serialize an object, you have to, period, that's how it works.
"Finally, when serializing an object, the full name of the type and the name of the type's defining assembly are written to the byte stream."
Your EXE is an assembly. If the error message is citing the DLL name, you have not stated so, then something from that DLL must have been serialized. If the error message is generic "can't find the source DLL" it might be misleading by assuming a DLL when in fact the source assembly was an EXE.
Regardless, the information is in the data and the assembly doesn't exist in your current solution. That is all that is significant here, correct? So now you need to figure out what you can and want to do about it.
In the future you might consider using best practices (isolation / "Separation of Concerns" - Dykstra ) and design patterns like MVC which could assist in avoiding tightly coupled issues.
|
|
|
|