Can-Ann's Q&A profile

• SQL Server How to Refresh a Data Source View and autogenerate/Re-Deploy the corresponding Report Model

  Hi everyone!, Our team is new to SSRS and we are trying to figure out how to refresh the data source view, autogenerate the corressponding report model and Re-Deploy the Report Model (rewrite existing Report Model) on the server on a periodoc basis or trigger the whole action whenever there is a change in the database on some specific tables. We prefer to do this action through a Agent job ( a diff approach is also welcome). Are there any stored procs out there Appreciate your time. -PN Hi Teo, Thanks for ur help. I tried in the same lines and was able to achieve my task. I need to know whether it is recomended to change the xml definition of the Report Model. Thanks ...Show All

• SQL Server RS.EXE parameters not working

  Hi Everyone, I am having a problem with the RS utility not recognizing my query parameters that I am passing to my timed subscription. I have set up my report with a "WorkOrder" parameter. I have created a trigger that causes my subscription to fire, and that trigger passes in the workorder number to the utility. The subscription fires successfully, but I am getting a blank report. I set the parameter value to "can be blank" so that I could create my subscription w/o an error. I know that my subscription id is correct when I use the fire method, because I DO get the appropriate report. I am also having the same problem when I actually log in to the report server and execute the utility from the command line. I ...Show All

• Visual C# support for SuperVGA graphics in system

  Hello All , How can i know that my system has support for SuperVGA graphics or not....Programatically C#. and also Support for DirectX 9 graphics and about how much is Graphics memory Any Help Regards, Aamir Thanks for replying.. i have mentioned that i wanna do it progrmatically throug c#.Like one can know about the Processor info through select * from Win32_Processor.. is there any Api for it which show me ..... Regards, Aamir ...Show All

• Windows Forms Idiot guide required

  Hi Folks I am having a bad day and cannot even get by the simple stuff today. I have created a new sql 2005 db with table and sproc and I want to use this with a simple login form in a windowsforms app and validate the details by calling the sproc and . - Whats the best way to do this (the sproc returns the details of the person if found) Cheers Gregor easily done Basically, you validate the form (username and password, make sure they have entered valid inputs) Then you call the SPROC, giving the values entered in the appropriate textboxes and it should return you the details of the user. Now, it depends on how you designed your SPROC. The way I personally do it is: Add a usernam ...Show All

• Visual Basic updating data grid connect to ms access database.

  I have a ms access database with a table consisting of the fields user_id and password. i have a datagrid binded with this information that is displayed in a vbform. i have added an "add" button. when i press this i want the new data entered in the datagrid to be updated in the msaccess database as well as the datagrid. so far i have the following code: Dim connStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source = C:\Documents and Settings\Owner\My Documents\Telephone.mdb" Dim con As New OleDb.OleDbConnection(connStr) con.Open() Dim objcommand2 As SqlCommand = New SqlCommand objcommand2.CommandText = "INSERT INTO Users" & _ "(User_ID, ...Show All

• Windows Forms Activation failed - The system cannot find the file specified error...

  We are using ClickOnce to distribute our application. The application is available in offline mode and also the check for updates mode is set to "Before application starts". Below is the error message that I get when I publish a new version and launch the application from the start menu. I get this error only if I have an earlier version of the same application installed on my machine. If I uninstall the application and install after or try to install the same application on a machine that does have it, it works just fine. So it seems that the problem is mostly related with the update. I would really appreciate if you can take a look at the error message below and provide you insights. Thanks, Murat PLATFORM VER ...Show All

• Internet Explorer Development Temporary Internet Files

  Why is it that if I go into Widows Explorer i can not find the temp internet folder I checked in the internet options where the folder is suppose to be located, but if I go to the folder(local settings) it's not there. While I'm browsing I can go to the internet options and look at the settings, view files, and nothing is there either. Doesn't IE7 store information like IE6 did Plus where is the cookie folder at Hi, I saw your posting about temporary internet files and you seem very knowledgable. I can't open excel attachments in Outlook Express because it can't find the temporary internet files\content.IE5\IMC6L9MJ\. I can't view the folder in explorer and don't know how to get this back. Any sugg ...Show All

• Connected Services Framework Could not find the CSF-Administration-OU Organizational Unit in Active Directory

  I am trying to install CSF 3.0 on a machine joined to my domain. I choose Complete install, and leave the Optional Top Level OU box unchecked. I've also tried manually creating the CSF-Administration-OU in AD, but I get the same error. Am I supposed to have SSL Certs pre-installed before running CSF install This is from the MSI log: Property(C): SetCertificateList = SESSIONWEBSITECERTIFICATE,IDMWEBSITECERTIFICATE,PMWEBSITECERTIFICATE,PIWEBSITECERTIFICATE,SCWEBSITECERTIFICATE,NPWEBSITECERTIFICATE Property(C): DEBUG3a34 = 34 Property(C): DEBUG1a34 = 34 Property(C): SetSqlComboBoxSet = 1 Property(C): ORGDESC = CSFHOSTINGORGANIZATIONDESC Property(C): ERROR = No SSL Certificates in Certificate Store! Property(C): ERRORTRACE = &nbs ...Show All

• .NET Development Update a access db's with VB express

  I have an access 2003 db's  but no of the methods of the help index can insert an element to the database. I've tried with data adapters. The dataset of the db's try to update but no can do. help   following the code Dim lect As IDataReader = Me .SistemasDataSet1.CreateDataReader sistemasDataSet.EstadisticasDataTable.Item(1).Rows.Add( "otros" ) 'sistemasdataset.tables("nombretabla o el indice de la tabla).row(i).colum("importe").tostring() + suma Me .EstadisticasTableAdapter.Insert( "joya" , "no ug" , "12 / 12 / 2006" , "tigre" ) other code on other button   Dim dt As New DataTable( "tblDemo" ) Dim coche As DataRow Dim i As Integer Dim j As Int ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. SpaceWar with a PC controller?

  Hello, I was experimenting the SpaceWar application, but it seems to expect a xbox360 controller instead of a broad PC controller since... well, I'm running it on a PC. Do you know anything about that I should be able to use it. I have a team that wants to use XNA for the PC platform - we could hardly care about the xbox360 at the moment. Forcing our players to have a xbox360 controller when they already have a fully capable controller does not make any sense. Did XNA leave out DirectInput or something I'd hate to drop back into MDX just because of this necessity. If MS has no answer for this, may I suggest that DirectInput should be included in XNA when the program detects its running on a PC Average Joe may not want to play the game ...Show All

• .NET Development Different ways of using xpath query within C#

  I havent used xpath in months (years ) and I was looking at a few examples Uses XPathNavigator and XPathNodeIterator http://www.codeproject.com/soap/myXPath.asp Using SelectSingleNode http://www.mastercsharp.com/article.aspx ArticleID=69&&TopicID=9 Is the 2nd listing the old way of doing it under the 1.1 framework No, XPathNavigator can be implemented over different stores, .NET 1.x and .NET 2.0 have it over XPathDocument, XmlDocument and XmlDataDocument and allow it to be implemented over other stores if someone wants to do it. MSDN has some examples I think e.g. XPathNavigator over .NET objects structures. In .NET 1.x SelectSingleNode is a method around in the .NET DOM implementation (System.Xml.XmlDoc ...Show All

• Windows Forms Saving Stream to File

  I have the URL of a PDF document, and I'm using this code to read the URL and get a Stream WebRequest MyReq = WebRequest .Create(varURL); WebResponse MyResp = MyReq.GetResponse(); Stream data = MyResp.GetResponseStream(); //Create the bytes array store the Stream byte [] buff = new byte [MyResp.ContentLength]; //Read the Stream and Load the array int len = 0; int cnt; do { cnt = data.Read(buff, len, buff.Length - len); len += cnt; } while (cnt > 0); data.Close(); MyResp.Close(); //Recreate a Stream and pass it as a parameter MemoryStream ms = new MemoryStream (buff); Then I'm showing a Dialog to users in order to save the doc SaveFileDialog ...Show All

• Visual C++ $(Program Files\Microsoft Platform SDK\Bin Does not work

  I been trying to set up VC++E for days now! i thought i had the problem fixed and its back again windows.h not found i followed the instruction in some video and it told me to add $(Program Files\Microsoft Platform SDK\Bin to the list of dir but when i push the "check mark" button it says such directory does not exist. so i use "C:\Program Files\Microsoft Platform SDK\Bin" it does not give me an error that this file does not exist but when i try to compile it gives me the error that windows.h; No such file or directory can someone please help me ...Show All

• SQL Server syscomments table text field does not allow more than 8060 chars

  Hello, I have a table in SQL Server 2000 which has few triggers. When I try to update a record in that table, I get following message: Warning: The table '[TABLE_NAME]' has been created but its maximum row size (17275) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes. where the data I am updating is well less than the field limit. The triggers are stored in syscomments table and when I dropped these triggers, the update statements were executed without this message. Is there anyway I can change the data type of field text in syscomments from nvarchar to ntext Thanks Din Hi Din, You absolutely never ...Show All

• .NET Development How to pass the command to the other executable file?

  Hi, I'd like to make a gnuplot to load a file and do some commands in the file. I would like to use C#. I found that I could use in C#: Process.Start("wgnuplot.exe"); to call and run gnuplot, but I don't know how to pass the command for the gnuplot. The command I'd like to pass to gnuplot is: load 'command.gp' where command.gp contains some commands for the gnuplot. There are qestions: Is it possible to pass the command to the other executable file If it is possible, how to do it Thank you very much, Komomomo I'm making an asumption here so correct me if I'm wrong but is wgnuplot, "Win-GNU-PLOT" and therefore have accessable source code ...Show All