Ravi Nidhonkar's Q&A profile
SQL Server Why it is rounded off the decimal number??
I am using the following code but it rounded off the decimal number and save the number in rounded form in the database(SQL). Plz tell me what is problem with this code. using System; using System.Data.SqlClient; using System.Collections; using System.Windows.Forms; using System.Data; namespace ConsoleApplication1 { class Program { static void Main( string [] args) { string connString = "server=(local);database=WH;Integrated Security=SSPI" ; SqlConnection conn = new SqlConnection (connString); try { conn.Open(); DataSet oDS = new DataSet (); // Create the DataTable "Orders" in the Dataset and the OrdersDataAdapter SqlDataAdapter oOrdersDataAda ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Rendering To Textures in Beta2
I used Texture2D's heavily with the usage RenderTarget, however in Beta 2 its like a whole new API. I understand that Surface no longer exists and RenderTarget/2D should be used. The problem is, the whole mentality is backwards compared to what im used to. From what I see I should create a RenderTarget2D and set that as a render target, then do rendertarget.GetTexture() if I want to set it. Thats fine. However, how do I copy between render targets There is no StretchRect or equivelent function I can see, which I used alot before. Surely I dont have to go about getting a texture, setting it, creating a 'copy' effect, setting a new render target, resolving the new render target just to copy from one to another Is there no alte ...Show All
.NET Development how to read only certain fields(columns) from a loaded dataset
1)how would i read only certain fields(columns) from a loaded dataset and display them in a datagridview for instance: if i have a datasetAll which has col1,col2,col3,col4,col5,col6.... now i want to retrieve col1,col3,col5 based on filter condition and show the results in a datagridview. thanks Just remember that Select is a copy method, the results of which are not connected to the original data table. Therefore, updating one DataTable will not update the other DataTable (a'la DataView). ...Show All
SQL Server Need to insert parent/child relationship rows into DB
Hi I need to read a file and write parent/child relationship rows. I cannot seem to fugure out how I can generate keys that I an use for the relationship. I looked at using a variable, but have no joy - I cannot instantiate the variable and it errors - notsure wy. I also looked to see if I can write to a DB table that maintains key id, but not sure how to do that. I alo thought of setting up the parent table key to be auto-increment,but canot see how I can read this so that I can us it in the child row inserts. Help will be really appriciated Thanks in advance. Suresh, You can generate a surrogatekey in the dataflow by using a script component. With this method you will know right in the dataflow ...Show All
Visual Studio Team System Schema changes and form updates
After I change a work item type's schema (i.e. adding a field and making a UI change), I import the schema and add a new work item and I see the changes. But if I bring up a work item that was added under the previous schema, the changes are not there. Is there a way to apply the new schema to the existing work item so I can now enter data into the new fields on that work item as well -Larry Try restarting the IDE - UI caches work items it worked with, and opening such item can bring you one from the cache. Or you could try refreshing that work item - that should do the same thing. Thanks, Alex ...Show All
Visual Studio Team System Unable to create project after projectserver integration
Hi! I'm unable to create project in Team System because of the wizard cant create protal on wss with the following error (got it from error log) 2006-05-27 13:06:47Z | Module: WssSiteCreator | Thread: 4 | TF30267: Exception: System.Web.Services.Protocols.SoapException: Exception of type Microsoft.SharePoint.SoapServer.SoapServerException was thrown. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.TeamFoundation.Proxy.Portal.Admin.CreateSite(String Url, String Title, String Description, Int32 Lcid, String We ...Show All
.NET Development .Net 3.0 install error
I keep getting an install error #0x13EC when I try to install the 3.0 framework. XP Media Center VS2005 Any Ideas Thanks Hi, Can you please find install and error log for netfx 3.0 from your %temp% folder. Can you please zip it and send it to us. Thanks, Manisha. ...Show All
Visual Studio Crystal Report connection to SQL server 2005
Hi, I am new to crystal report. I am using Visual studio .net 2005 with crystal report. This is the scenario: I want to connect to sql server 2005. so i tried the OLEDB Provider for SQL server, then i am prompt to enter the server name, user id, pwd, database,etc. After entering, i select 'Finish' but an error msg pop up,"Login failed for user <my username>. The user is not associated with a trusted SQL Server connection." Can anyone advise me on how to resolve this problem hi check the sql server authentication mode,and if u cant log on then u may trying using ODBC ...Show All
Visual Studio Team System Get file attributes - checked out or not (in code)
Hi, I am wondering if there is any command in the TFS API that lists all files in a folder, and shows whether they are checked out or not. I do know of the QueryPendingSets command, but I would have to combine that with a list of ALL files to get their state - checked in/out. I saw this helpful post about listing checked out files: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=153326&SiteID=1 Is there any API call that allows me to see this in one call P.S. For some reason, the 'Insert Hyperlink' button does not seem to work in FireFox. Thanks, I'm glad you've found it to be useful. If you are looking for the combination of GetItems() and QueryPendingSets(), then you most likely want the GetExtendedItems(). The only ...Show All
Visual Studio Service pack or hot fix of CR for VS2005
Where can I find service pack or hot fix of cr for vs2005 I've searched in business object site, it only has cr for vs2002 and vs2003. I've download a hot fix of cr for vs2005 before, which fixed a bug in previewing report with stored procedure, but I lost the link now and cannot find it in their site. It works!! Thank you very much!!! Do you know the hot fix link for 64bit runtime too ...Show All
Software Development for Windows Vista DirectShow "DES" is missing from Vista SDK?
We have a number of products based on DirectShow and DES that we're trying to move to Vista. The released Vista SDK as eliminated the DirectShow Editing Services code samples. Is DES still supported in the "Vista SDK" release of DirectShow If so, where can I get the samples, and if not, what should we use instead Thanks! Robert Swirsky Theme Park Photo, LLC Great. BTW, the best person I have seen online for DES questions is Joe Flynn. He hangs out in the newsgroup microsoft.public.win32.programmer.directx.video and I don't know if he frequents this forum. -TMH ...Show All
Visual Studio Team System building web projects
Is there a way to build a web project to simulate the same structure as the "Publish Web Site" building in Visual Studio Or would I have to create custom tasks to handle the files after compilation I have tried that, but for some reason it only puts the log in the build directory, everything else is stored normally in the Sources directory, even though it "Completed Successfully".. This happens with Web Sites and Web Services using Debug/.Net and Release/.Net ...Show All
Visual Studio 2008 (Pre-release) What does VisualXSnappingGuidlines do??
Hi, I'm developing some controls for WPF and had some problems in the OnRender-method to draw some pixel exactly to the device pixels, even if SnapToDevicePixels is true. So I saw the protected member VisualXSnappingGuidelines resp. VisualYSnappingGuidlines of the class I'm deriving from. I haven't found any useful information how to use this member, so I hope maybe you have one... Greetings Cheesenhomer ...Show All
Visual Studio Express Editions Printing
I have made a web browser and I am using it right now. I have 5 problems. 1. Right now on this posting thing I can't right-click the text-box and paste code. HOW CAN I MAKE ME BE ABLE TO PASTE, CUT, AND COPY 2. I wnat to be able to print my webpage by pressing a button here's my code so far: PrintDialog1.ShowDialog() If Windows.Forms.DialogResult.Ok Then PrintDocument1.Print() END IF 3. I have a menu strip on the top of my form. one of the thing's says BOOKMARKS. I need some code to add a webpage to bookmarks and make code to get us to the web site when I click on it. 4. I have a progress bar and I need it to react to how muc ...Show All
Visual Basic Looping through form controls (simple I know!)
Hi I'm trying to write something that will loop through every text box on a form but it's not working quite right. The text boxes may be inside containers such as tabpages or group boxes and this is what's causing the problem. How do I loop through every control regardless of if it's in a container Example :- For Each control As Control In Me .Controls If TypeOf control Is TextBox Then MsgBox(control.Name) End If Next Thanks Dustin's method is a 'cleaner' solution, so just use that one :) Basically, the Do...Loop I used, is replaced by a Sub that calls itself - and which adds textboxes to the ReturnList if any are found. Dim zListOfTextBoxes As New ArrayLi ...Show All