mav888's Q&A profile

• SQL Server SQL Server Date/Time & other data types

  Hi I'm have big problems trying to save Unicode information into my MS SQL Server 2000 Desktop Engine. Alright, so the problem I'm having now is I'm working with MS SQL 7.0 and PHP5. I've trying to get information to save into MS SQL, however it is storing it all weird. When I save the information and try to view it in Enterprise Manager it shows it has random characters but for some weird reason I can output that information on the page correctly when I do a SELECT query. Here's an example of my problems. < php $insQ = "INSERT INTO my_tblBusiness ( pkID, fkbusinessID, ntitle, ...Show All

• Windows Forms How do I print multiple lines using graphics.drawstring?

  I tried g.drawstring("test1", ...) g.drawstring(controlchars.NewLine, ...) g.drawstring("test2", ...) it prints on the same line. How do change line Thanks and Regards! i have found that using "\n" in a string does cause a newline to be printed alternatively, as suggested above, move the location manually. you can use  MeasureString.Height to get the height of&n ...Show All

• Smart Device Development How to Remove the Titlebar From the PropertySheet

  Hi, Please any one can tel me abt how to remove or hide the titlebar from the Propertysheet and Also tell me is there any way to Convert A simple dialog into CpropertySheet. any Help is appreciated. Thank you in advance. Regards, Saravanan Hi, In case you are talking about the property sheet specific title that appears at the top of propertysheet, try to lookout for the propertysheet callback and return zero in response to PSCB_GETTITLE rather than copying in the title to be displayed. ( I assume here that you wan't to modify some code.) In case you want to hide the system title bar. The idea is to ...Show All

• SQL Server CREATE ASSEMBLY failed because method 'UpdateVersion'

  I'm working on a CLR Stored Procedure and have code that builds using Namespace: Microsoft.SqlServer.Dts.Runtime Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll) When i try to create the assembly i get this: CREATE ASSEMBLY failed because method 'UpdateVersion' on type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageVersionUpdate90' in safe assembly 'Microsoft.SqlServer.DTSRuntimeWrap' has invalid attribute 0x1003. You would need to create the Dts.Runtime assembly using Create Assembly statement (as unsafe) since its not one of the supported assemblies. If you r ...Show All

• Visual C# Increasing an array dynamically

  hey there, I want to declare a single dimentional array somewhere and then increase its size dynamically inside a foreach loop. e.g.: //declare array2 foreach int i in array1 { //increase size of array2 } About your question, here is a little example how to encrease the size of an array: Int32[] source = GetArraySource(); Int32[] dest = new Int32[]; foreach ( Int32 i in source ) { Int32[] temp = new Int32[ dest.Length + 1 ]; dest.CopyTo( temp, 0 ); temp[ temp.Length -1 ] = i; dest = temp; } ...Show All

• SQL Server MDX calculation

  Not sure if this can be done any help appreciated. first a little background info a "customer" can have multiple "bill types" I create two calculated members Calculated member1 - returns all the customers that have a bill type "A" Calculated member2 - returns all the customers for bill types except "A" I'd like to have a calculated member that returns all customers that have bill type "A" only. In other words remove those customers from Calculated member1 that exist in calculated member2 One small suggestion - you might want to express it as: CREATE SET ...Show All

• SQL Server How to migrate from Analysis Serveice 2000 to 2005

  I have a Cube designed with SQLServer 2000. How can I migrate it to 2005 Hi Deepak, did you migrate any 2000 database to 2005 in production environment with the Migration wizard Was you pleased with the result of the Migration Wizard How much handwork was invested to get a satisfying result IMHO, the Migration Wizard is really flop. ...Show All

• Visual Studio Express Editions Compare age with birthdate

  I can't think of a function to calculate this. I have a persons BirthDate and I want to check if their age is between two values. It looks like that: user inputs a minimum and a maximum age. Then I make a BindingSource.Filter where I check if there is anyone in the database whos age is between those two values. Because I do a direct BindingSource.Filter I can't change the birthdate in age value, I have to change the age value in a date that can be compared with the birthdate. I hope u can help me find a solution... Hum I think I did it, but there is a new problem. I solved this like that: Dim AgeMin As DateTime = DateTime.Now.Date ...Show All

• Windows Forms Which project to use?

  If I want to create a windows user control with no visual form - just properties and methods like the timer control. Which project should I use so I do not get the visual form. Thanks, Frank Daniel, Yes, you are right.. it is a component. Works !! Thanks, Frank ...Show All

• Visual Studio Express Editions About Combobox

  Hi friends. I'm newest user for Visual Studio 2005 VB, i couldn't find right way, I need some information. Sorry My English is not so good. I can explain so; I have one combobox, i connected that to my db(Access) There is so much Column, When i select somthing in Combobox i wish textbox show what a that row compoist for other column. ----------------------------------------------------------------------- | Sno     | asd        |  312sad |      kashs| sakd   | sadas|  yuha | > Column name -------------------------------- ...Show All

• Visual Studio Error compiling MyC language service project

  Hi, I am trying to build a language service (VS 2003). I started by trying to build the MyC language service available in <VSIP_Root>\EnvSDK\Babel\MyCLangService. However, i first got the an error from the post-compilation tool about some m4sugar file. I searched online and downloaded the bison package and got the m4sugar directory and put it in the appropriate folder (the tool was giving error on ..\share\bison\m4sugar\m4sugar.m4 path, so i put it there), and that error went away. Then it gave me a new error: Running Bison on c:\Program Files\Vsip 7.1\EnvSDK\Babel\Sources\Client\MyC\parser.y ..\tools\bison.exe: m4: No such file or d ...Show All

• SQL Server stored procedure return/result behaviour change from 2000 -> 2005 ?

  Hello, Can someone please help explain if the way MS SQL Server 2005 returns result from stored procedures is different from MS SQL Server 2000 The problem i am having is that i have lots of code that used to connect to SQL-2000 and did this: SqlDataAdapter da = new SqlDataAdapter(sqlCmd); ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) //process rows SqlCmd Type is a StoredProcedure btw, in SQL-2000 if the stored procedure result is empty, i still get one table in the dataset tables collection "table[0]", and the table is empty; in SQL-2005 however i get NO tables at all if the result is empty, whi ...Show All

• Smart Device Development database entegreted

  hi i am mehmet my questions about smart device applicaton database connection i am writing code about smart device connection database but i want to entegreted my computer database (sql server) with pda database for data. data transfer from pda database to sql server on my computer thank you Hello Mehmet, I didn't completely understood your question. Did you want to sync your PDA database with your database on your computer If yes, then you can use active-sync to sync database between computer and PDA. -Thanks, Mohit ...Show All

• .NET Development [system.net.mail.smtpclient]: Does anyone know of a *real* way to validate a successful email send?

  I've looked in the intellisense, online .Net docs, and on here... long story short i can send email but want to read the status code of those emails... preferably the SMTP status code. so far the only close solution to verifying a successful send is using the mailmsg.deliverynotificationoptions.. but that's hardly a solution... that is based on a return email for delivery notification... for catching errors it's easy enough... just try/catch it and grab the status code there... but i'm looking for something on the success/delay (delays can still be successful) status code as well. I'm looking for a status code (250 OK, 500 ERR, etc) ...Show All

• Visual Studio Express Editions SQL Update

  I have been going through the free videos (very good) but have a problem regarding lesson09. The database does not update after closing down the program. I have tried a few times now and even run the downloaded copy but to no avail. Has anyone else come across this problem and been able to overcome it BindingSource1.EndEdit() Dim rowsAffected As Integer = 0 rowsAffected = CustomerTableAdapter1.Update(MyCompanyDataSet1.Customer) MessageBox.Show(rowsAffected.ToString())   Thanks I'm having the same problem with the downloaded sample program so I'd welcome a solution too. ...Show All