oivindroed's Q&A profile
SQL Server How to write Store procedure
Hi, I am new to using store procedures Can anyone please check and tell me whats wrong in it create procedure Poll_Grid @top int, @ofset int, @orderby varchar(50) as if (@orderby = "question") select top @ofset substring(question,1,50) question, startdate, username,categoryname from polls join users on polls.userid= users.userid join category on polls.categoryid= category.categoryid where pollid not in ...Show All
Windows Forms Good all around Datagrid operations
I see several posts for various datagrid operations. Where could I find some good info on select, insert, update, delete, as well as changing colors of datagrids Thanks Bill Very good information can be found at http://www.syncfusion.com/FAQ/WinForm ...Show All
Visual C# Whither encapsulte field in Express beta2?
Where did the refactor/Encapsulate Field option go That was dead handy, and I was looking forward to more like it to speed development not less! Have I missed something Is there a config option hiding somewhere to switch it back on Or should I know how to roll my own by now Yes, in Beta 2, the only refactorings we now support are extract method and rename. I've passed this question on ...Show All
.NET Development Now what's wrong?
<% Set pageCount = Server.CreateObject("MSWC.PageCounter") pageCount.PageHit() %> <p>You are visitor number <% =pageCount.Hits() %> since the last reboot. Any thoughts on how to make this persistant, i.e. survive a reboot. My thought to write to the server disk causes a protection error. You can store the value on disk, or the registry (with the given permissions requirements met) but you will have ...Show All
SQL Server Failing to "Jump to report" from hyperlink
I am designing a report and have a text box containing a hyperlink that should navigate to another report when clicked. In the "advanced textbox properties", on the naviagtion tab, I have clicked "Jump to report" and selected the report I want to jump to from the drop-down. (The target report is in the same folder) When I preview this from the IDE, all is OK but when deploying to the Report server, clicking the link just brings ...Show All
Windows Forms binding dataset to a datagrid
i am using a winform datagrid.i m trying to bind it to a dataset whose datatable contents are filled at runtime depending on user input. i do it like datagrid.datasource=dataset the datagrid shows an expandable tree view.It opens to show the required datatables correctly.But when i try to navigate to a table by clicking it, it refuses to do so. The same thing when i try to associate it with an untyped dataset(which is filled with a sql ...Show All
Windows Forms Make column width autofit to width of grid - can it be done?
Hi all, I have a question and your help will be greatly appreciated. I have a datagrid (don't we all!) and a three column table as its datasource. I can fix the width of two columns to say 100px but then I would like to create a ...Show All
Smart Device Development me.close
hi there, i have a device application, why whenever i perform me.close for any form, i can never show it back from others form for example: Private Sub btnClose_Clicl(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnClose.Click me.close End Sub Private Sub btnShow_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnShow.Click Form2.show() End Sub note that, btnClose is ...Show All
.NET Development .net remoting issue with proxies
Hey everyone, I have posted this on another forum but got told to post it here. I have a asp.net 1.1 app that is using .net remoting to create a remote object and send data to it. It work just fine up until a certain point. That point is when I try to connect to a computer in a completly different location (i.e. a different businesses computer that has my app installed on it). I get this error: The underlying connection was ...Show All
Visual Studio Crystal report paging
Hi, How to control paging using database field values and formulas Thanx in Advance! K.Murugan ...Show All
Windows Forms How to change the column name in datagrid?
I have a window form datagrid. May i know how to change the column name in the datagrid For example, one of the column name in the database is EMP_NO, so the datagrid will show this column name also, how can i change it to Employee No there is a difference between column name and column headertext the column name is the name that you use in your code the column headertext is what appear to the user ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Multiple Monitors as Independent Displays
Is there a way to use DirectX to write to a monitor on a second display adapter when the monitor is detached from the Windows (XP Pro) desktop The MSDN library contains a topic "Using Multiple Monitors as Independent Displays" which suggests that one can use the GDI function CreateCD or the DirectX function DirectDrawCreate (now a deprecated function). What currently supported DX9 function will let me open the device and use it for ...Show All
Visual Studio 2008 (Pre-release) constructor not executed on deserializing
When using wcf to send an object over the wire, it seems the default constructor is not executed on deserialization. My breakpoint doesn't get there. Also fields with initialization code are not initizialised on deserialization. I'm implementing [ OnDeserializing ]. After that the members that have been marked as DataMember are being set. At that point I noticed the wrong state. Yes your are right. Constructor is not called for DataCont ...Show All
Visual Basic listbox I/O help plz
ok, i have contents of a listbox as follows (as example) a ab abc i have tried using listbox.text as the output like for textbox "print (1, blah.text & vbCrLf)" but it gives me the error that it cannot be part of the I/O or somthing i want to save that contents as "file.txt" as it looks above. how do i do that As this isnt particularly clear what your trying to do. The following will get the items f ...Show All
.NET Development Mutual authentication and allowing only certain hosts.
Is it possible to only allow certain machines to access a web service I am using VB.Net (VS 2005) and WSE 3.0. Right now I am at the point where any machine with a valid certificate can access the web service as long as the certificate is verifyable. I want to make sure that only certificates I issue for certain machines are allowed to access a web service. Is it possible to create a special cert store for this purpose Would I be better of ...Show All
