Search results for query: *

Hi ; I have installed MSDE and I passed following parameters at the time of installation. [Options] INSTANCENAME=MQIS DISABLENETWORKPROTOCOLS=1 SAPWD=CC2004 now, I want to know who is the Defualt user for that and what is his password. I am trying to run a Crystal Report connecting to...

Hi Dear; I am using VB.NET 2003, Crystal Report 9.2 and MSDE Database. I created a report using SQL Server database and now I want to run it with MSDE and I changed my Database Location in design time in Crystal Report to MSDE Connection. I did not set any user ID and Password in that...

Follow the procedure: 1- Declare variables 2- Set values 3- Use dyanmice Sql to make a sql statement 4- run it use exec (SQL) For Example : I am assuming your red values as variable Declare @var1 varchar(10) Declare @var2 varchar(10) Declare @var3 varchar(10) Declare @var4 varchar(10)...

Your question is not very clear to me but you can try that INSERT INTO T_CollectionMembers (UID, MemberUID) SELECT UID , 99999 FROM T_Collections I hope it would work.

Thanks, I have one more question related to your answer, actually, my button is in Grid and Grid built in button, I want to invoke that pop up window just after saving records into database on update button of Grid records. I want to do two functions on button click. Button_Click() 1-...

Hi ; I am using ASP.NET and VB.NET 2003. I am trying to do one thing. I have a update button to update record in a grid. I want to launch a pop up window whenever user press upate button. That small pop up window will not have anything but a text box with a button send to send email to a...

Thanks, it worked for me. Actually, that line Split(unsplitString, """,""") work for me, I was using Split(unsplitString, ",") Thanks.

Hi; I am using VB.NET 2003. I am trying to importing data from text files and I am using split() function to get each substring in one row which is comma delimated and have inverted comma's for each subtring. It is working fine if there is no Comma in between inverted Commas. It gives me...

incomplete information about the problem, could you please explain your problems in details so that you would get proper response.

Hi ; I have been facing problem in connection pooling for two weeks and I did search each website and forum and I noticed that this is one the most comman problem using ASP.NET with VB.NET and SQL Server 2000. I went thru my application and checked for any open connection and I ensured there...

Thanks a lot.

Hi; I am using VB.NET 2003, I am using MDI Form with Menu Strip , I want to change the color of the menu bar for that particular application , I noticed that it is taking setting from default windows setting. How can I change it for one particular application. Thanks.

Hi ; I want to use Color Codes in Programming instead of using color variable which are available in system.drawing.color class. For example, I want to use #FF6600 for orange and different color codes. I want to change the HeaderBackColor of a Grid in a style in coding. Thanks.

Hi ; I have a website which is developed using ASP.NET 2003 and SQL Server 2000. I am having a problem with Connection Pooling and try to make sure either each connection object is close and destry and I did and checked the whole website and closed and destroyed each and every connection ...

Use Derived Table in FROM clause like that. select i.id as itemid , iaid.TopItemID from item i inner join customer c on i.customerid=c.id left join (select top 1 ca2.itemid as TopItemID from itemassign ca2 inner join account a2 on ca2.accountid=a2.id where a2.customerid=c.id and...

You could try two thing; 1- Try to use Cast here in your insert 2- Try to using another variable i.e. int and setting it to your results from dynamic sql @value variable. e.g. @ValueInt = @value Post your result again.

Thanks for giving me this link, I think I have to purchase it so I'll look into demo version first. I have another question, in the same code above posted, Can I use multiple email address with semicolon ";" seperated to send emails to more than one receipient. Thanks.

Dear All; I am using VB.NET 2003 and I am using following code to send emails using Outlook object. When its sending email Outlook prompts a popup of security alert and Ask user to you want to allow to send that email and I can selected check box to allow and selected minutes how long the user...

Oops, after posting my last post, I got two more response. Actually, I have to submit forms and two buttons on one page which sends email to two different receipient. I was having problem with my HTML so I posted that question. But, after re-arranging my HTML it is working properly. Thanks for...

No, I tested it and it is working properly. I was having problem with HTML. Thanks.