Recent content by VDavid

Hi, I don't know if there is a role for stored procedures, what I do is give the person execute permission one procedure at a time. grant execute on PROCEDURE_NAME to USER_NAME I think there is a way to create a role with the permissions you need, but I haven't done it. Hope hits helps. David

Hi, Could you post the code you're using? Maybe the problem is in the connection when opening the excel file or it's not in the same location in the client computer. David

Thank you!!! With your example I was able to find the problem. I was missing: Me.Controls.Add(dgv) Thank you again.

Hi, Getting back from the weekend. I tried your suggestion, still not working. But I have another clue, not only I can't access the columns, but neither the rows. It's like the datagridview hasn't been initialize. I will with this theory and search for solutions. Any help will be...

Hi, let me try your suggestion and I'll get back to you on Monday. Thanks

Hi, Thanks for the replay. But I have done that and it didn't work. Also, according to the help if the datagridview is populate trough a datasource the AutoGenerateColumns property is set to true by default. I did tried it anyway just to be sure :) Any other idea will be appreciated. David

Hi, I'm going to guess that the stored procedure returns a recordset in the query analyzer. If that's true you can use insert into [YOURTABLE] EXEC spQueryAD @LDAP_Query, @Verbose Hope this helps. David

Hi, Here I am, wondering what I'm missing in my code. Maybe I should just ask if there is a problem or a must-do-code that have to be present when one tries to create a datagridview in runtime and then tries to access the columns. I always gets zero for the columns count even thought I can...

Hi, The way I see your problem, there are different approach depending in the data platform of your new software. 1-If the new software use or doesn't use the data from a MSSQL database: 1.1- For the historical information, create a one-use DTS package, copy the information in your new...

Hi, Sorry for the delay... jebenson Thanks for the links, those are very useful. I don't know how I miss them, guess I didn't use the right search keywords :) RiverGuy Thanks for your advice. I'll take them in consideration

Thank you for answering me jebenson But as I understand, that will only work with if the commands are in vbscript, I'm looking for a way to execute VB.NET code lines. I was using the message box as an example, but I would like to interact with the .net program, changing variables values or...

Hi, I was wondering if there is a way to execute code in VB.NET from a string. I'm using VB.NET 2008 Express. For example, read a file or database and put it in a string then execute the command in runtime. Dim StrCommand as String strCommand = "Msgbox(""Hello World"")" Execute(strCommand)...

PHV, JohnYingling and trollacious thanks for the reply. I was already thinking in read the entiry file, but I was hoping not to do this. Thanks all.

Hi, In a existing text file, I need to replace one line with something else. Is there a way to do this in VBScript. For example, the file is first line second line third line ... What I want to do is modify the file so it will look like this was the first line second line third line ...

laperouse For what I see the insert statement UserRec = "Insert INTO [UsersTemp] ([UserID], [Location], [FullName], [Dept]) Values ('" & NxtUserID & " , " & Location & ", " & E - Mail & ", " & Department & "')" should be UserRec = "Insert INTO [UsersTemp] ([UserID], [Location]...