gnanas's Q&A profile

• Smart Device Development Slow when retreiving data from database

  Hi I have this problem of slow starting forms in my pocket pc application. Its only for the forms that starts with a connection to a database. the application is also slow when making any connection to the database. I was wondering if there is a proper way to speed this up, and whether using XML files (or even txt files) fatser (almost on the fly) I'm creating a database class that makes a connection and query the database using this code: private DataSet Query(string SQL) { SqlCeConnection cn; SqlCeCommand cmd; DataSet ds; SqlCeDataAdapter da; cn = new SqlCeConnection(LocalConnection); cn.Open(); // Initialize a new command cmd = new SqlCeCommand(SQL, cn); // Initialize a new dataset ds = new Dat ...Show All

• SQL Server Using FreeTextTable Conditionally

  Hello all! I have a stored procedure that accepts a parameter @SearchTerm that may be null. In my WHERE clause, I check for all records where @SearchTerm is null, or are LIKE '%' + @SearchTerm + '%' when not null: SELECT (some records) FROM (some tables) WHERE @SearchTerm IS NULL OR (some fields are LIKE '%' + @SearchTerm + '%'); I am trying to use FTS with a FreeTextTable to make our search ability more robust: SELECT (some records) FROM (some tables) JOIN FreeTextTable(tableName, columns, @SearchTerm) ft ON ft.[KEY] = tableName.[KEY] However, because @SearchTerm can be null, meaning the user is not filtering our records by a search, doing a JOIN to a FreeTextTable throws an error (cannot have null as search string). Ple ...Show All

• Visual Studio Team System Creating new reports for defects

  Hi. I'm having some trouble getting the reports in Project Portal to work. I need to provide a periodic status report showing defect counts by state for a couple of team projects. I'm thinking to myself "Hmmmm Visual Studio 2005 & TFS is so incredibly powerful, these reports are very likely built in". Am I high Question: Can a report of this type be easily created, and if so, how If the solution to create these reports is to go to the project portal, then click on Reports, then I've got anotner problem. When I do this I'm getting the following error: The report server is not responding. Verify that the report server is running and can be accessed from this computer. So there are a couple of pr ...Show All

• SQL Server Restoring database

  Hi everyone, I made a backup for my Bilgiler database and then by relying on this back up, I erased my Bilgiler data base. so now I tried to restore this Bilgiler database by using Enterprise Manager however I could not succeed. How can I overcome this Thanks What is the error message / numbe you are getting HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Express Editions Stuck in loop; newbie need help

  Hi All ! The following code seems to stuck in loop. Any idea why Function koe( ByVal u As Short ) As Boolean Dim z As Integer = 0 Do My .Application.DoEvents() Out(&H378S, 1) For z = 1 To 200 z += 1 Next Out(&H378S, 0) 'Stop For z = z To 1000 z += 1 Next 'Acc = 0 z = 0 Out(&H378S, 0) Loop While u = 1 'Acc = 0 z = 0 Out(&H378S, 0) End Function The code comes out of do loop when u = 1, but it still keeps doing output to LPT Thanks in advance Chopa I'll add, here, that you need to learn to use the debugger : rather than simply run the program and wonder why it doesn ...Show All

• Visual Studio Express Editions Treeview with dataset

  Hi, I have a dataset with multiple tables (from Oracle) My Requirement: I have a root node say "Tables" Under which i have all the tables listed as "Parent nodes". When i expand it has to have all the colums listed under it Plz help me do it. vj_electric, There is an article in MSDN knowledge base that can help you with the problem. This step-by-step article demonstrates how to add multiple levels of nodes to a Microsoft Internet Explorer TreeView WebBrowser control by using a DataSet object that includes multiple tables. This article also demonstrates three ways to optimize how much data you send and when you send the data to the client. For a small set of data, you want to send all of th ...Show All

• SQL Server Parse dataset in report

  I am using a "jump to report" that accepts multivalue parameters for fiscal periods. It works fine, returning the correct data. However, I want to add the chosen fiscal periods to the report header in a textbox. When I use =Join(Parameters!DATEfiscalperiod.Value, ", " ) the results in the textbox show as: [DATE].[fiscal_period].&[5], [DATE].[fiscal_period].& When using:: =Parameters!DATEfiscalperiod.Value results in [ rsInvalidExpressionDataType] The Value expression used in textbox ‘textbox5’ returned a data type that is not valid. Is there a way to parse the dataset to only return "5, 6" in a string TIA ...Show All

• Windows Forms dataset.merg() New to C#

  I am trying to merge data from a odbc database to a winmobile database. this code compiles and runs, but no data is transfered. fB7MobileDBDataSet.Merge(dataSet1.CUST, false , MissingSchemaAction .Ignore); I obviously don't understand the concept of this method. It says this is used to transfer data between larglely similar tables. Well my tables in my estimation re not largely similar. Here are my tables data schema ODBC WInMobile Code String 10 Code String 5 Link String 1 Lname String 40 Firstname String 36 FName String 35 LastName String 70 Name String 80 Name String 110 ...Show All

• Windows Live Developer Forums On mouse out over pushpin

  Hello Folks, Is it just me or is there no onmouseoutcallback event with the map control I got the mouseover callback working the way I want, but how can I make it go away when the user mouseouts the pushpin Thanks for the help ;) Dean ...Show All

• SQL Server Can I retrieve a result set from a sp into a variable within a Execute SQL Task?

  Can I retrieve a result set from a sp into a variable within a Execute SQL Task agentf1 wrote: I am passing the sql in a variable and have a resultset set up to retreive the output/result set from the SP. So where exactly is the problem If you need the sql statment to be dynamic; you may want to use an expression inside of the Execute SQL Task to set the SQLStatementSource property: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=662860&SiteID=1 Now the second part would be to get the SP output into a SSIS variable; for that you can follow Jamies sugestion. If the SP returns more than one row you will need a SSIS variable of Object type. ...Show All

• Visual C# toolStrip with Database connection

  i have a combobox on my toolStrip How can I populate with data from a database very simple. I assume you are asking on how you can add entries into the combobox SqlCommand theSQLCommand = new SqlCommand("SELECT * FROM tableName"); theSQLCommand.Connection = someConnection; //create your SqlCommand the above is an example. Then... SqlDataAdapter theDataAdapter = new SqlDataAdapter(theSQLCommand); DataSet theDataSet = new DataSet(); theSQLCommand.Connection.Open() theDataAdapter.Fill(theDataSet); //fills the results given back from SQL into the dataset theSQLCommand.Connection.Close(); this.theComboBox.DataSource = theDataSet.Tables[0].DefaultView; this.theComboBox.DisplayMember = ColumnName ...Show All

• Visual Studio Express Editions open a file in listview control

  Hello all, Part of an application that I'm working on uses a treeview/listview control. My goal is pretty simple, I think... I've created an application that parses HTML files. It allows the user to edit these parsed fields and save their changes over the existing file. I realize that I could use the filebrowser dialog, or simply enter the path of file, but I need the user to be able to select a file in the listview control and have that file load in a textbox. Again, user selects (clicks) a file in the listview. By clicking the file it automatically opens in the textbox. I have no clue as to how to accomplish this seemingly simple task. Any help would be very much appreciated! Thanks, Mike ...Show All

• Visual Studio 2008 (Pre-release) "Download Dialog" from an XBAP

  According to these: http://msdn2.microsoft.com/en-us/library/aa480229.aspx and http://msdn2.microsoft.com/en-us/library/aa970910.aspx I can fire off a "Browser Download Dialog" from within an xbap, which I assume would enable me to give a file to the client. How exactly is this done I've searched for hours now and can find no example. I've tried using a frame control but it fails with "Failed to convert resource into object." Will I need to write some something to force a download from an html page embedded in a frame I've found a vague tip here http://scorbs.com/2006/06/14/photostore-xbap-standalone to set the Content-Disposition header to “attachment” on the server. But that tells me nothing about what I need t ...Show All

• Visual Studio Express Editions Creating a table in access database Visual basic express 2005 edition

  Hey to one and all, I'm working on developing an application that is connected to access 2003 database. I made a few querys with the help visual basic express. I made a query in access to create a table. In visual basic express i'm seeing that the query is placed under "stored procedure". I would like for example if the user clicks on a button "make new table" that a new table in my database in made. I can't even access this "stored procedure". I was thinking on adding this query to tableadapter but i do not get the option to do that. Can someone explain if this support in VB express 2005.. The same query string that you used in the query genera ...Show All

• Visual Studio 2008 (Pre-release) Avalon databinding/threading problem

  I'm building an app that has to show a network graph (you know, vertices and edges). The graph is constructed in a separate thread from the UI thread based on sent and received network packets. Now, I want to update the UI showing the graph changes. I have already read a lot about Avalon threading, but I just don't seem to get it working. Is there anyone who can give me a tip on how to solve this issue The Graph object has two collection properties that I want to deal with in the UI, like this: public class Graph<T> { public Collection<T> Vertices; public Collection<T> Edges; ... (a bunch of add/remove stuff) } First I have a graph control that I want to bind to Graph.Vertices and Graph.Edge ...Show All