More Related Resource Links

Hi,
I want to change the border colour of the Textbox. However, when I override the OnPaint method, some strange behaviour occurs.
The new border is drawn, as is the textbox background. However, the text itself appears in bold and only while I actually type something in, afterwards it disappears. I have provided a sample of my code here:
protected override void OnPaint(PaintEventArgs e) { base.OnPaint(e); Rectangle rect = new Rectangle(0, 0, this.Width, this.Height); ControlPaint.DrawBorder(e.Graphics, rect, _BorderColour, ButtonBorderStyle.Solid); }
I have also set the style of the control to Userpaint, so that the paint method is actually used.
Does anybody know how to solve this issue?

Could someone explain me how to provide some value to the parameters in a finder method. For exemple I know that the BDC list WP use this method. Is there a way to provide some value for those parameter at runtime? I really don't understand (even after some
deep search on the web) where are the values for the parameters from and how we can connect to them. Even with C# code I can't find any information on how it work.

I don't want to define my parameters as filter in the ADF because then I will have this filter section in my BDC list WP (or is there a way to get rid of that?). Actually one of the parameter should be automatically calculated from a value in a SP list,
the other parameter should be provided by my own filter web part.

I want to put POCO object to Velocity cache. How can I serializable ICollection to Velocity cache, or exclude ICollection from serialization?

I got this exception

Type 'System.Collections.Generic.ICollection`1[Model.Collection]' cannot be serialized. Consider marking it with the DataContractAttribute attribute, and marking all of its members you want serialized with the DataMemberAttribute attribute. If the type is a collection, consider marking it with the CollectionDataContractAttribute. See the Microsoft .NET Framework documentation for other supported types.

My problem is this, i have a nested listview that works fine but if i need to do an insert and the nested listview dont have retrived any values (that is no posts created) i cant get hold of the fk that i need. If i put a hiddenfield in the parents listview with the fk how can i find it in codebehind when i do an insert?

I have a C# application that inserts XML into Sql Server 2005. When the message is more than 300 lines or so, it doesn't make it there. The data shows in the application variables (stringWriter) but doesn't get inserted and that's confirmed
looking in Profiler.
The stored procedure is simply:
usp_WS_OrderEntry_InsertWSOrder @doc=@p1,@WSOrderId=@p2 output
INSERT INTO WS_OrderEntry_Order (OrderXML) VALUES(@doc) .....
C#
.....
tableAdapter.usp_WS_OrderEntry_InsertWSOrder(stringWriter.ToString(), ref wsOrderId);
....
In any cases, the variable "stringWriter" contains the data (as text).
In profiler for a successfull call:
declare @p1 xml
set @p1=convert(xml,N'<OrderHeader><CustomerNumber>1234</CustomerNumber><Pr.....</PO></ShipToName>
declare @p2 int
set @p2=1077
exec dbo.usp_WS_OrderEntry_InsertWSOrder @doc=@p1,@WSOrderId=@p2 output
select @p2
In unsuccessfull call:
It shokes on the convert part and doesn't display any data (and doesn't insert as well). I looked in LOGs, events and didn't find anything.
Any help appreciated. Thanks.

Hi,
I'm having a very strange problem when inserting rows into a table. Let me try to explain a little better:
Table1 (for example Book) with a lot of fields and one foreign key to Table2 (idVolume) and a primary key (identity - idBook). This table has a clustered index only on the primary Key. (this table has something like 10 Millions rows)
Table2 (for example Volume) with a lot of fields and a primary key (idVolume) identity. (this table has hundreds of rows)
Now, the problem starts when I make a insertion on Table2. When I made an insertion, it was taking minutes to finish, so I stopped it.
After looking into the execution plan of the query, there was something very very strange, there seems to be a clustered index scan on Table1... the problem is that since Table1 has so many rows, this index scan takes forever...
Can anyone explain me why does the insertion on Table2 makes an clustered index scan on Table1? It really doesn't make any sense to me.
Thanks in advance.
João Teixeira

I am trying to perform a bulk insert on pipe delimited file (approx 25 columns,5000+ rows of data).
Normally this is no problem however this file has a header and trailer record with no delimiters (1 column).
I could use a utility like grep to remove the header/trailer record but I would like to capture the entire file inside sql server.
I can bulk insert the entire file into a single column (wide) that would include the delimiters.
My problem from there is to process the single column data into the appropriate rows /columns.
I am looking for a set solution as opposed to a cursor type solution. HTML?
Seems slow. Cross Apply?
Changing the file format is not a viable solution.
I’m likely to have more than a few of these oddball formats with a variable number of columns.
Any ideas?
I thank you for your time on this puzzle.

(Visual Studio 2005, .NET framework ver. 2.0 sp1, C#)
ÃÂ
Hi all - I hope there's a some simple solution for this. I have a SQL Server 2005 (.dtsx) SSIS package file which I open and make a slight change to, then save it back. The problem is that the resulting saved file differs from the original, even if i haven't made any programattical changes at all.
ÃÂ
Specifically, if i do something like this:
ÃÂ
using System.XML;
XmlDocument doc = new XmlDocument();doc.Load(DTSXFile);doc.Save("TEST-COPY_" + DTSXFile);
ÃÂ
So I found that even if i completely remove any modifications i was making, and break it down so that all I am doing is simply loadingÃÂ the file, and then turning right around and saving it, I get line breaks inserted for nodes that have empty values...I looked over the entire file, and the issue is not happening if there is a value...only in the case where the value is missing.
ÃÂ
a line like this in the source file:
<DTS:xProperty DTS:Name="VersionBuild">7</DTS:xProperty>
ÃÂ
comes over perfectly after saving as this:
<DTS:xProperty DTS:Name="VersionBuild">7</DTS:xProperty>
ÃÂ
But, in the source file, a line like this (empty value):
<DTS:xProperty DTS:Name="VersionBuild"></DTS:xProperty>
ÃÂ
will end up looking like this in the TEST-COPY file after saving:
<DTS:xProperty DTS:Name="VersionBuil

Sometimes this call reaches to WCF Service successfully but sometime it lost and UpdateTable() method could not be invoked on service side. I am not sure but I think WCFSvcObject.Abort() code aborts the WCF request before it reaches to the service. I can not use Close() method here as my client application hangs on the Close(). Please suggest me what may be the reasons of the client call could not reach to the WCF Service. Should I not use Abort() method. If yes then how can I dispose the WCF proxy(since Close() method is not working here).

I have a class that runs calculations on numbers and populates the results to my SQL database. My code behind page instantiates the class object, and in a loop it makes use of the method five times (once per loop). Essentially, my code behind collects the information from controls and passes the information to the class method for processing. The method works just fine most of the time.

On one of the iterations I get a error before the code even gets to the class. The error is, "Arithmetic operation resulted in an overflow." What strikes me as odd is that while stepping through the code, the loop crashes with that error before getting to the class that runs the calculations. Additionally, no arethmetic operations are performed on the form's code-behind page (which calls the method). I even put a break-point on the class constructor but the code crashed before reaching that constructor.

The information being sent is the results of matches from a sporting event. As a troubleshooting measure I changed the order of the matches by deleting them an re-entering them into the database in a different order. Again only this one particular match crashed.