SiddCF's Q&A profile

• Visual Studio Express Editions SOMEBODY SAVE ME

  <WebMethod()> _ Public Function HelloWorld() As String Return "Hello World" End Function .this web service will return the word hello world .now what i wanna do is to return information from my database .how to i go about it cos i donnoe what i should declare my database by...should it be string , int or whatever it is i tried everythinh and there always an error .btw my database is named as PanHotel.mdf Hi wiscon, i suggest you read this book: " Introducing Microsoft Visual Basic 2005 for Developers " ref: http://msdn.microsoft.com/vbasic/learning/introtovb2005/ it is very helpful, and it will guide you to start up ...Show All

• Visual Studio Open report in landscape

  Hello, I have a few reports that have this same problem. The items in the report are to long so it makes the row take up twice the width. Is there a way to show the report in landscape so that this problem will not occur Or is there some other solution. Thanks Hi, i had the same problem and the solution is to switch the "Page width" and "Page height" property of the report, so the reportviwer control renders the report to a landscape format. I hope this hint help you. Best regards Tibor Csizmadia ...Show All

• Microsoft ISV Community Center Forums Help with Excel VBA Code

  I am trying to format different spreadsheets. I need the data to be in the same cells for each worksheet. This data is in column A. I need to check to see if DBCS# ( ) is above Tour, and if so insert rows until Tour is in row 175, column A. The problem is that the number after DBCS# is never the same. How can I use an IF statement to make sure that the cell above Tour says DBCS# (whatever the number is) This is the If statement that I tried. If I put DBCS#46 in my IF statement, it will not work because the number after # isn't always 46. If (Range("A174:A174") = "DBCS#") And (Range("A175:A175") = "TOUR") Then GoTo label_177: Else: Do While (Range("A174:A174") <> "DBCS#") And (Range("A175:A175") <> "TOUR") Select ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Starting work on my GUI system

  Well, I've hit a wall with my game's development, and since there was no GUI with XNA 1.0, I've decided to go ahead and make my own GUI system. I implemented a lot of mechanics for my game, but I need greater interaction to proceed development in a sane manner. So far I've just implemented the text drawing stuff from scratch. It uses only monospace fonts generated with BMFontGenerator without using the generated .xml file. It's decidedly minimal to use only monospace fonts, but keep in mind two things - 1) my particular game doesn't require anything more robust than monospace fonts and 2) a game's engine should be designed around the game's specifc requirements. Otherwise you're scope creepin. I remind myself constantly not to let cool ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Deployment Woes

  Whenever I try to deploy my application, either with Publish or manually, it runs completely fine on my computer. When I try to run it on any non-GSE computer, it comes up with a generic/unreadable error message. The computer has DirectX9c, .NET 2.0, and I installed the XNA Beta2 Redist. Are there any .dll's I might be missing I even tried to run the default XNA project and it failed. What am I doing wrong Alright!  You are the greatest.  That did the trick.  I knew I had used that before (the DX Web Installer), but I wasn't sure if it installed the latest version.  If you want to check it out, my devblog is www.infillion.blogspot.com , but right now my server is down, so the game isn't currently hosted.  Pr ...Show All

• Visual Studio 2008 (Pre-release) GridView CellTemplate

  Hello, I just started using GridView today, it is pretty cool. I have a question about the cellTemplate property of GridViewColumn class. I want to style the content of a cell (fontsize, etc.) so I use cellTemplate (I'm not sure if this is correct ). So I need to define my binding in the cellTemplate's value (a datatemplate resource). But then I would have to define a cellTemplate for each column. Is there a better way to approach this problem, so that I have one style for all my cells regardless of which column the cell belongs to Thanks Houman Yes. Define the template as a resource and then apply the resource to each of the columns using a resource expression. That would look a little someth ...Show All

• Visual FoxPro Visual Foxpro report writer

  I have a dbf with following fields bill no, bill date, cust name,item name,qty,rate,amount and i have 553 records. i want a simple report on 132 column stationary. i dont want totals also. (so no page footer or summary). i used visual foxpro report writer. but the report does not print with proper ejection i.e. second page starts printing from bottom of first page and third page prints from bottom of second page and so on. printer is absolutely fine because documents from excel and word print with proper page breaks. can anybody help I think u are completely mistaken about me. i am a small time foxpro for windows 2.6 programmer from bangalore, india. i am just trying to upgrade myself to visual foxpro. i have got ...Show All

• Visual Studio SqlDataSource wizard showing SQL with wrong syntax

  I've set the quoted identifier stuff in all the locations I can think of and yet SqlDataSource wizard still shows the SQL as SELECT [col1], [col2] from [table]. This syntax doesn't work for us. How does it determine what syntax to use if it's not using things like DataSourceInformation Thanks Reggie (MySQL) Closing this thread, this forum is about programming the Visual Studio APIs, not SQL development (and I am not sure about the best forum to move this to). Craig ...Show All

• SQL Server SQL Report Help

  I have a program that reads a table with quantities of different products from a SQL Server Database using Ado connection. After the quantities are modificated in the program I need to update them in the database. I was told that to write directly to my table I need to export a report definition with a Ado Connection in it( "Provider=SQLOLEDB;Integrated security=SSPI;Data Source=sqlexpress;Initial Catalog=MyDB;Table=myTable") . I was provided with an example file that has .RPT extention. The problem is that I dont understand how does the .rpt file writes directly to the database. When the exporting is done does the report file automatically connects to the database Eventually I was ...Show All

• .NET Development how to add more than one namespace reference to root?

  When I am building an XmlWriter I can use the following to create the root node. xw.WriteStartElement( "svg" , " http://www.w3.org/2000/svg " ); How can I add another namespace reference to the root node eg xmlns:xlink= h ttp://www.w3.org/1999/xlink Alternatively, is there xsl syntax that could do this via a transform Thanks, Tad You can write out the namespace declaration as an attribute as in the following example: const string svgNS = "http://www.w3.org/2000/svg"; const string xlinkNS = "http://www.w3.org/1999/xlink"; const string xmlnsNS = " http://www.w3.org/2000/xmlns/ "; xmlWriter.WriteStartElemen ...Show All

• Visual C# Cannot implicitly convert 'type' to 'type' error

  Code: string processName = processTextbox.Text; Process a = new Process(); a =System.Diagnostics.Process.GetProcessesByName(processName); a.Kill(); It returns this error: Error 1 Cannot implicitly convert type 'System.Diagnostics.Process[]' to 'System.Diagnostics.Process' C:\Documents and Settings\Deru\Mina dokument\Visual Studio 2005\Projects\ProcessKiller1\ProcessKiller1\Form1.cs 30 21 ProcessKiller1 And the help(F1) doesn't help me out too mutch, It says it's trying to convert a type into a type... Now I get this: Error 1 Syntax error, bad array declarator. To declare a managed array the rank specifier precedes the variable's identifier. To declare a fixed size buffer field, use the fixed keywo ...Show All

• Windows Forms Populating a treeview recursively

  Hello, I have a self joined table named: Category. It contains 3 columns only: CAT_ID, PARENT_CAT_ID and Title. I'm using a data reader to get the categories from the database as follow: while (dbReader.Read()) { Title = (string)dbReader["Title"]; CAT_ID = (int)dbReader["CAT_ID"]; PARENT_CAT_ID = (int)dbReader["PARENT_CAT_ID"]; // MessageBox.Show(Title); <- Working!!! } Can anyone please tell me how can I populate a treeview recursivley with the data I pulled from the database Please note: 1. PARENT_CAT_ID = 0 for the root records. 2. Child records doesn't always follow parent record in the database query result, they can be mixed. I would appreciate any help. ...Show All

• .NET Development How to randomly delete 1 row from a DB ?

  Hello, I'm writing a program with the help of VB 2005 Express. It is connected to a DB using SQL Express Server 2005. In my program I want to randomly delete some rows from the table. I use the VB code: Dim WhichOne As Integer = rnd() * 40 (where 40 is the amount of entries in the DB) Dim DeleteQuery As String = "DELETE * FROM Table LIMIT '" & WhichToDelete & "', '1'" Dim DeleteCommand As New SqlCommand(DeleteQuery, myConnection) DeleteCommand.ExecuteNonQuery() If for example WhichOne = 17, it should execute an SQL query: DELETE * FROM Table LIMIT '17', '1' Which imo should delete the 17th entry in the table. Now I get an error on the execution of the SQL command, but what is it that I'm doing wrong ...Show All

• SQL Server Need Comments

  Can someone please give me comments to every lines to this code: (I think I know, but Iam not sure): Dim ConnString As String = ConfigurationManager.ConnectionStrings( "Connectionstring" ).ConnectionString Dim strSQL As String = ( "INSERT INTO Tabel3( City) VALUES ( @City )" ) Dim Conn As New SqlConnection(ConnString) Dim Command As New SqlCommand( "" , Conn) Command.CommandText = strSQL Conn.Open() Command.ExecuteNonQuery() Conn.Close() ------------------------------------------------------------ By the way, I got a question about the DetailsView in ASP.NET 2.0 (none answearing me at forums.asp.net .....: I want to hide a <TemplateField> in Edit-mode of the Detailsview. ...Show All

• Visual Basic Code for Drawing a circle

  Hello all, I need to produce a data file that has the X and Y values for a circle. Origin at 0,0 and radius od 40. Any ideas Matt Hi, If you want to draw a circle on your form take a look at this msdn document: Drawing Shapes on Your Form cheers, Paul June A. Domag ...Show All