Manolis's Q&A profile

• Visual Basic Alternative to Data Reader (VB.NET 2003)

  In my following code I want to use any Array variable that can store the result. I don't want to use the Data Reader as given below. Is there any alternative. ----------------------------------------------------CODE--------------------------------------------------------------- Private Sub cmdModify_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdModify.Click Dim strFind, strModify As String Dim FindDr As OleDb.OleDbDataReader Dim cmdFind As New OleDb.OleDbCommand(strFind, cn2) myRecID = Val(InputBox("Enter Item ID:", "Modify Item Entries")) strFind = "Select * from Firms_Master Where FirmID=" & myRecID FindDr = cmdFind.ExecuteReader(CommandBehavior. ...Show All

• SQL Server Unable to see data from Oracle client through SQL link server

  Hello, I was hoping someone had this problem and has a solution... :) Some background info: SQL 2005 Enterprise x64 Windows 2003 R2 x64 Enterprise (clustered) Oracle client 10.2.0.3 (latest as of 2/2/07) The issue I'm having is I have a link server setup within SQL 2005 connecting to a Oracle 8 database server. The Oracle client I'm using is 10.2.0.3 (latest version from Oracle). From the SQL 2005 server I'm able to query the remote oracle server through the link server I had setup if I query the table directly. If I perform a query to a view on the Oracle server I'm able to see the colum names, but not the data. This only happens when I'm using the Oracle client, if I use the MS client for Oracle it works fine OR if I us ...Show All

• Windows Forms Is this legal for me to do this?

  If not, i will happily stop, but right now, i am having a blast with Terrarium in .Net 2.0. http://tanderson.cbs-posi.com/MyTerrarium/checkmeout.jpg Do we reckon this guy is for real Not just because of the effort involved in reverse engineering (since I do notice we're provided with pdb's) but because he appears to be connected to a public server on his screenshot that presumably wouldn't accept 2.0 bugs. That server is maintained by MS, so if he's installed a 2.0 server on it then presumably he wouldn't need to ask if it was legal. /\/ ...Show All

• Visual C++ Help! LINK : fatal error LNK1181: cannot open input file

  Im just a starter on Visual C++ 2005 and needs help from anyone. I renamed a form from its default (Form1 to frmMain) and now I encounter Link error. It says it cannot open the old resource file, but it should not be referenced anymore. Below is the build result. ------ Rebuild All started: Project: General Ledger, Configuration: Debug Win32 ------ Deleting intermediate and output files for project 'General Ledger', configuration 'Debug|Win32' Compiling... stdafx.cpp Compiling... General Ledger.cpp AssemblyInfo.cpp Generating Code... Compiling managed resources... Read in 3 resources from "c:\General Ledger\General Ledger\frmMain.resx" Writing resource file... Done. Compiling resources... Linking... LINK : fatal error LNK118 ...Show All

• Visual Studio Express Editions Suduko?

  I was just wondering if it was possiable to make a suduko computer game with visual c# 2005 express edition i bought the book build a program NOW microsoft visual c# 2005 and did all the projects in the book and wanted to start a suduko game! If its possiable can someone tell me a little on how to start or do it Thanks I believe you will find the link to the webcast here: http://search.microsoft.com/results.aspx mkt=en-US&setlang=en-US&q=sudoku But there are lots of other applicable links as well. ...Show All

• SQL Server Connecting on one remote computer but not the other on sql server 2005

  I am unable to connect to a remote server on Computer A from Computer B, but when I reverse it I am able to connect to a remote server on computer B from computer A. I have SQL Server 2005 Developer Edition on both computers. I am using the using the SQL Management Studio to connect. Both Computers have these settings Using Surface Area Configuration both have local and remote connections checked. Both computers using tcp/ip only checked. Using Configuration Manager both the sql server and the sql browser are running. Both computers have tcp/ip protocols enabled. Under the server properties on both computers, under the Security Tab, I have SQL Server and Windows Authentication Mode checked. Under the Connections tab I have Allow r ...Show All

• Visual C# Is instanciating to null BAD??

  is instanciating a variable to null is a bad practice I took "variable" to mean non-members; which was reinforced with your example using a local variable. Yes, initializing reference members is considered bad practice because they are preinitialized by the framework to null. Local variables, which is what I was referring to, are a different story. ...Show All

• SQL Server database mail to send mail to multiple recipient from table

  I am using database mail to send emails to our Lotus Notes SMTP server using sp_send_dbmail. I want to accomplish the following. I have maintained department-wise users email address in one table . Now I want to send mail to one particular department and there can be 1-15 users as recipient for that mail. How can I do that using sp_send_dbmail Well, I have found answer to it. The following way, we can accomplish. Hope that will help those, who are searching for something similar. DECLARE @email VARCHAR(4000) SET @email = '' SELECT @email = RTRIM(@email) + RTRIM(email) + ';' FROM Users WHERE email <> '' AND DepCode = 'A' PRINT @email EXECUTE msdb.dbo.sysmail_add_account_sp @account_name = ' ...Show All

• Windows Forms datagridview

  hi, i have a datagridview(vid=sual basic 2005 and sql server 2000 thru dsn im working). i want to 1)display data from a table to datagridview 2) add new rows 3)delete 4)update. i added a datagridview and added 15 columns to that ans set name and columnheader for each. i also want some of the columns to be calender etc...(i added genericdatagrid user control.dll) i have the following code in the form load but no data is coming. can u please help con.ConnectionString = "dsn=alphasql" con.Open() da = New OdbcDataAdapter( "Select * from Company" , con) 'da.SelectCommand = New OdbcCommand("Select * from Company", con) da.Fill(ds, "Company" ) DataGridVi ...Show All

• Windows Forms Copy data from datagridview To textbox

  how can copy data from cell of dataGridView to textBox (char by char) if copy char by char in the textbox to textbox we make this code textbox1.text=textbox2.text note : this code add in the textChanged in the textbox1 in the dataGridView wht is the solution to make this ...Show All

• SQL Server Using SQLExpress on a network

  Hi, I have a VS2005 application that I run with a SQL server 2003 database. In order to make the application distributable, I'm trying to get it to run with SQLExpress. I've installed SQLExpress on a spare machine and changed the connection string in my application to use SQLExpress c:\databases\mydatabase.mdf (and the database is obviously in that location!). This works fine on the spare machine. However the problem is getting the application to run on another machine but using the same database. I note that SQLExpress won't let me put the database on a networked drive. On another machine I've also installed SQLExpress, I've enabled the tcpip stuff and the browser but to be honest don't really know what I'm doing! How do ...Show All

• Visual C++ Creating MD5 hash

  Hello, i'm new in C++, i want to make console program for creating md5 has, you can enter string and from that string program would create md5 hash and display it on the screen. I have searched msdn library and i found MD5 class, but i don't uderstand it well, so can somebody give some tips or some sample code. Sorry for my bad english Nishant Sivakumar wrote: With 2003, you need to use the old-syntax. Here's some code to help you along (I ported the other poster's new syntax code to old syntax) that's it, code is runing good, that's i need it, now i can implement my code and i have class for md5, thanks ...Show All

• Visual Studio Tools for Office Prevent outlook from closing or user from changing a item

  Hi again! Im having some troubles on outlook add-ins. Does anyone knows how to: Detect that outlook is closing and ask the user if he really wants to close outlook while the add-in is performing some action (example: sending data or receiving from a server). In this situation is there a way to prevent outlook from closing Detect if a user is changing a item. Prevent a user from changing any item while the addin is doing something. I was hoping for a solution that works both in 2003 and 2007 office systems. Thanks for the tips. Regards, N. Pinto Are you using VSTO target two Office versions with the same add-in Also, have you considered using callbacks with your add-in to as ...Show All

• Windows Forms Populating a datagrid

  I am pretty new to C# and programming for the most part. I currently have an Access database created with data already in it. What I am trying to do is to have a user select from a combo box what he or she wants to look at. After selecting from the combo box I have a button that needs to be pushed so that it can populate the datagrid. private void bGo_Click( object sender, EventArgs e) { if (cbBCBS.Text == "CTA" ) { this .cTA_DIAGTableAdapter.Fill( this .bcbscheckerDataSet.CTA_DIAG); } if (cbBCBS.Text == "MR Breast" ) { this .mRI_BRST_DIAGTableAdapter.Fill( this .bcbscheckerDataSet.MRI_BRST_DIAG); } if (cbBCBS.Text == "MRA" ) { this .mRA_DIAGTa ...Show All

• SQL Server CLR vs T-SQL

  Hi, I bought Pro ADO.NET2.0 but could not find a clear description of the optimum use-case for CLR and T-SQL Stored Procedures in general. (although the book is great) It seems for complex or recursive tasks CLR SP is useful. But would you recommend using CLR SP for basic INSERT, UPDATE, DELETE, SELECT queries Thanks, Bahadir Hi there, check this post http://www.yukonizer.com/dasblogce/PermaLink,guid,59a1fbee-1df3-4f9c-be64-de1c778c198e.aspx Might help you. Cheers, -DS ...Show All