DAVID SAIANI's Q&A profile
.NET Development Newbie, Updating Records
Hello, I'm quite new to .Net/C# in VS2005. Having years of experience in Delphi/Vcl environment blocks me here. I've created a grid that allows me to search in data, when selecting a record in that grid i'm updating another tableadapter to select the complete details of this record. In the search only the descriptions are selected. This works fine. The data is displayed with textboxes that have databinding. I've even (by test) attached a datanavigator to the 'editing' tableadapter. Whenever i change a value in a textbox, and than press the V-ok button of the navigator, or my own button that starts a this .productsTableAdapter.Upda ...Show All
SQL Server SSIS Variables not changing value?!
Greetings my SQL friends, I have a very simple package which consists of a SQL Task component and a Script Task. The SQL Task retrieves a single value from 1 row table in one of my database and assigns that value to a variable. The Script task simply outputs the value of the variable in to a message box. I know, it's all simple stuff (I am trying to master SSIS ) The problem I have is that when I change the value of the column in my table, the value of the variable is not changing when I re-run my package. It seems to be the same value every time. What am I doing wrong ! Your help would be much appreciated. Hi dreameR, Is your SQL ...Show All
Visual C# Reader.HasRows
Hi all, I had this select statement String strSelect = "select UpdatedTime from criticalmessage where ServerName = '" + ServerName + "' order by UpdatedTime desc limit 1" ; As my table do not have the specified ServerName, I am expecting that the statement should return reader.HasRows = false as there should be no rows return. I am using MySQL as my database. But instead, it returns a true value, and thus I was thrown with an ArgumentOutOfRangeException because of the statement below : if (reader1.HasRows == true ) { string time = reader1.GetString(0).Substring(0,19); .... ...Show All
Visual Studio A data source instance has not been supplied for the data source 'DataSet1_Clientes'.
Hello i'm cuban and i'm doing an aplication in Visual Studio 2005. I have a problem with this code because i have an error. I want dinamically load differents reports in one page usin the reportviewer control. This is my code. please help me and tell me what's wrong here. This code i'ts for a test Protected Sub Page_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Load Me .ReportViewer1.ProcessingMode = ProcessingMode.Local Me .ReportViewer1.LocalReport.ReportPath = "C:\Inetpub\wwwroot\pepe1\report1.rdlc" Me .ReportViewer1.LocalReport.DataSources.Add( New ReportDataSo ...Show All
Windows Forms Refresh Binding
Hi all, I have the follow situation: An instance with 2 records on table "LNG" of dataset dsLanguage in the frmLanguage; An empty instance of dataset dsLanguage in the frmLanguageEd. On the constructor of frm I have the following code: public frmLanguageEd(dsLanguage pData, BindingContext pBinding): this () { BindingContext = pBinding; // Copying BindingContext dsLanguage = pData; // Copying DataSet structure and data } On the "Open button" of the frmLanguage I have the follow code: frmLanguageEd vFormLanguageEd = new frmLanguageEd(dsDados, BindingContext); vFormLanguageEd.ShowDialog( ...Show All
Microsoft ISV Community Center Forums accessing another program from Excel
Hi How do I access another program from Excel What I'd like to do is click on a line in Excel with information about a journal and have Excel automatically go to another program, paste one of the fields from the line and send a search request. The other program is a Windows XP program. The other programs are library catalog client programs (not the actual library catalog program itself), one is used for acquisitions, ordering and paying for books and journals, the other is used for cataloging, adding the information for books and journals, like the journal name, publisher, call number and so on. The products are from a company calle ...Show All
Windows Forms Sending mail with VB.Net
This may ultimately be an SMTP admin question (as opposed to VB.Net) but, I wrote the following code to send a mail messge from a VB.Net app. Dim from As String = "dexterm@mindspring.com" Dim mailto As String = "dexterm@mindspring.com" Dim subject As String = "Test Message" & ...Show All
Visual C# Unrecognized configuration section 'connectionStrings'
Hello ,can someone help me in the following : I have some pages that have been created with VWD express but when I try to test these pages with Dreamweaver or when I upload these pages on to a Host provider I get the following error message: Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: Unrecognized configuration section 'connectionStrings' Source Error: Line 10: <configuration> Line 11: <appSe ...Show All
Visual C# How to finish my own project Template in C# of VS2005?
Hi all, I just make my own Template in C# of VS2005 with two wizard pages. I know that I can create a project first and "export templates..." to the "\Visual Studio 2005\Templates\ProjectTemplates\Visual C#". But I have two wizard pages,So the question is how to put the wizard pages files to that ProjectTemplates folder,is it possible Question 2: Now I just do it like VS2003,put the my own template(named as myWiz) folder into the VC#Wizard folder and myWiz-Html -Images &nb ...Show All
.NET Development Accessing data in a DataSet
Hello all, ADO is very new to me, so I hope this question doesn't seem too simple. If anybody can recommend a good ADO book or tutorial that would be great. I am using C# Express and SQL Express. I've been able to connect to my database, use a TableAdapter to get access to it, and fill a DataSet with a query from the TableAdapter. My question is, how can I get access to the the rows and columns in my DataSet I know how to "databind" them to a form control, but I'm trying to just get them into variables. For example, if my table looks like this: int myAlbumsID (primary key, isIdentity=yes) varchar[50] albumName ...Show All
Visual Basic Problem with VB6 SQL Server Express and Stored Procedures
I am trying to migrate an application running in VB6 which interfaces with SQL Server 2000 to SQL Server Express. I am having a problem with stored procedures which contain multiple steps. If I run the stored procedure in Mgt Studio Express, the resulting recordset displays correctly. In VB6, the rs.open does not generate an error but any subsequent attempt to access a property of the recordset causes the error 'Operation is not allowed when the object is closed'. Single step stored procedures run fine. The .Provider = SQLNCLI and the app references the Microsoft ActiveX Data Objects Library 2.8. VB6 is SP6 Windows 2000 SP4 ...Show All
.NET Development VS 2005 Application Deployment
Hi, All I am evaluating the VS2005 and made some applications , now i am stucked at a point where i want to Deploy the application on a client machine for testing. i tried using the publish option, but it does'nt work. could some one help me with this, what are the pre-requisites for application to run. are they available in the VS2005. Thx. Hi, Applications built using .NET Framework 2.0 would require the machines on which they are deployed to have .NET Framework 2.0 redistributable installed on them at a minimum. And as Paul has pointed out, only Beta 2 has the Go-Live license - so make sure you are using atleast Beta 2 of the .N ...Show All
.NET Development Generate Xml describing my textbox or any UI controls
Hey, I want to beable to generate an XML document describing my textbox, buttons or other controls properties, like size, location etc. Can anyone give me the code or help I tried to use the System.Xml.Serialize but it says it does not support buttons.gettype method This is what XAML is used for. Check out WPF (formerly known as Avalon). ...Show All
SQL Server ForEach Loop Container
I am using a SQL Task to load the data needed for the loop into a variable, then using a script task to perform calculations. Is it possible to update a table from the script task with the calculated values . Thanks Yes the structure for all reports are the same, the calculations are dependant on the specific measure. May I contact you offline and not involve the forum until a suggestion is ready ...Show All
Windows Forms docking ...
why can we not have two controls on a form and both have Fill set for Dock property, so that when one control is collapsed the other one takes the remaining area and vice versa In the <A HREF="http://www.windowsforms.net/Applications/application.aspx PageID=20&tabindex=8">TaskVision</a> sample application is an xPander control you can leverage to do& ...Show All