sknake

Welcome to Daniweb Steve! Please use code tags when posting code: To answer your question I think you want to make the member as static: namespace Gathering_Tool { public class Program { public static string targetserver; public static void Main(string[] args) { targetserver = "whatever"; } public void Test2() { …

With your fresh install did you change versions of Microsoft Office? You could be referencing the wrong interop DLL libraries which [b]is a very common problem[/b] so double check your files and version. PS - I love your comments

Please make sure you get your code tags right when posting: [noparse] [code=vb.net] ...code here.... [/code] [/noparse] Next please paste the complete method you're using to upload. It looks like your [icode]PName[/icode] variable in VB.NET is likely null (Nothing).

What database are you using? I have a similar application and what we did is something like the following (assuming you can run this MSSQL query): [code=sql] IF OBJECT_ID('ItemMaster', 'U') IS NOT NULL DROP TABLE ItemMaster IF OBJECT_ID('ItemAttributes', 'U') IS NOT NULL DROP TABLE ItemAttributes GO Create Table ItemMaster ( …

This sounds like more of a j2ee problem than an SQL one. If you can run queries with TSQL but not j2ee & the ODBC driver then you're probably posting in the wrong forum.

What is a "auto on button"? Just click the button and it will post back the textBox if you used an <asp:TextBox> in the form fields

Post the code that is causing a problem. Be sure to post [b]all[/b] relevant code and use code tags: [noparse] [code] ...code here.... [/code] [/noparse]

I'm not sure on what your question is but the .NET DataSet is tested, tried and true. It will work and let the DataSet worry how it handles the RowStatus because that is internal to its workings really. I personally do not advocate or use a DataSet but for other …

Yes. Post your relevant table structures and what you have tried so far and we'll go from there :)

Drop a button and and a label on a form: [code=csharp] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using Timer = System.Timers.Timer; namespace daniweb { public partial class frmTimer : Form { private Timer timer; private const int requiredWaitTime = 10; …

Just for the hell of it? No. If you have a reason then perhaps... plus it also depends on the port.

Welcome to daniweb John! Please use code tags when posting code: Can you upload a sample application demonstrating this behavior? You could also try adding this to the forms load event: Private Sub frmSpawn_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If (Me.WindowState = FormWindowState.Minimized) Then Me.WindowState = …

One of those two is correct. Also can there only be one answer or is there more? I think one more might be true.

Database Triggers: [QUOTE]DDL Triggers are a special kind of trigger that fire in response to Data Definition Language (DDL) statements. They can be used to perform administrative tasks in the database such as auditing and regulating database operations.[/QUOTE] You're looking for a table specific trigger and not a database trigger. …

That depends. If you're doing a [icode]GET[/icode] request then your progress bar is the loading bar on the browser ;) If this is an AJAX request for retrieving data you can use a loading panel. Its not a "progress bar" but it lets them know something is churning: [url]http://www.google.com/search?hl=en&source=hp&q=ASP.NET+loading+panel&aq=f&oq=&aqi=g1[/url]

If you're talking about opening multiple instances with the debugger you can right click on the project in your solution explorer and select "Debug -- Start New Instance" and repeat the operation until you have the desired number of instances open. If you're talking about at runtime you can do …

Please use code tags when posting code on daniweb: [noparse] [code=vb.net] ...code here... [/code] [/noparse] You can't very well insert a picture boxes [icode].Dock[/icode] state in to the database. You need to use parameters and a byte array. Do a quick google search on "parameterized SQL" and that should get …

Yes .. just move the code you have off in to a thread and away you go. You would want to use the thread pool and and feed file names to your thread starter since you have a fixed set of logic to run on each file.

SQL 2005 has deprecated old binary image storage types so your best bet is using a [icode]varchar(max)[/icode] in SQL 2005 or later, in SQL2000 you can use the [icode]image[/icode] data type. Here is an ASP.NET page that retrieves an image and uploads it. You can ignore the ASP.NEt specific stuff …

Because on Windows Server IIS is run by an unprivelaged user account. When you're running it in the VS IDE you're running as your local user. You should use SQL Authentication and create a user on the SQL Server to log in the ASPNET process. -or- You can use identity …

[icode]Session.Abandon();[/icode]

What do you mean can't trace it back? I'm guessing you're running the application inside of VS and have the project output set to Debug? Hit CTRL+D, then E. This will bring up the exceptions window. The checkboxes in the right column should all be checked. For trying to catch …

Change this line: [code=vb.net] mySQL = "INSERT INTO image (patientIC, picture) VALUES (@IDValue, @BLOBValue)" [/code] To: [code=vb.net] mySQL = "Update image Set picture = @BLOBValue Where patientIC = @IDValue" [/code]

How many users are we talking about here and what is the back end database? For example if this application has a large number of users and is powered by MSSQL you could have a problem with locks in your database. If five users request a table lock then the …

Great Britian has summer daylight savings time which means your clock is off by an hour.

This is a PHP question, not MSSQL question. If you store the data properly and retrieve the data properly with PHP then its all good. You can use [code=sql] Select DataLength(image) As Sz From Table [/code] To verify you have the complete image. If the file sizes match then its …

It looks like what you have is correct. It makes no sense whatsoever but it seems functional.

I don't understand what you are asking

Excellent post! You included a sample project plus a sample database :) Just one more thing -- when you paste code on Daniweb please use code tags. I can't get the project to run though :( Locking up on the connection. Anyway I think I see the problem: private void …

Slap your professor.. C# doesn't have functions!

Send stdout and stderr to /dev/null: [code=bash] sk@sk:~$ which bash /bin/bash sk@sk:~$ which bash >> /dev/null 2>&1 sk@sk:~$ [/code] You can still access the return value which is usually why this is done. Here is an example: [code=bash] sk@sk:~$ which bash >> /dev/null 2>&1 sk@sk:~$ echo $? 0 sk@sk:~$ which …

Stored procedures have their advantages and disadvantages like every other technology. A lot of people recommend SPs because they cache the execution plan, which they do, but if you form a query properly using parameterized SQL and don't build the query dynamically then it also uses a cached execution plan. …

[code=sql] Select Email, ( Select Top 1 FirstName From Table As x Where x.Email = Table.Email Order By x.CreateDate Desc ) From Table Group By Email Order By Email [/code] You could modify the logic about to form a join syntax if you wanted.

Use an [icode]HttpWebClient[/icode] and post form fields to search pages or figure out their URL structure and call it directly. I'm pretty sure search engines will ban you for automating searches if the volume is large enough. <1000 queries a day shouldn't be a problem.

I personally recommend subversion+trac but you need a server that will maintain the repository. You *never* want to work off of the repository copy of the version control system. What you can do is have a "master" copy on one developers machine and he has a local copy of the …

[icode]COALESCE('Togas', Column1)[/icode] will always return 'Togas' thus Column1 will never be called. But to answer your question you need to escape the control characters: [code=sql] COALESCE('Togas', Replace(Replace(Column1, '[', '[['), ']', ']]')) [/code] There are also other LIKE operators you should take in to consideration. There is an [icode]ESCAPE[/icode] claused but …

Buy a PDF encoding library or find a free one on the internet. The implementation depends on the library you use so I cannot give advice beyond that. They should have examples.

Open up the access modifiers for the class then. You obviously want to use the base class outside of the .exe assembly because you're trying to access a derived class. Change the access modifiers to public and you should be good to go. Also -- This is all managed code …

You will need to write a "scraper" which depends on the format of the page displaying the links. Please use code tags to paste the HTML of the page you're wanting to scrape for links or post a link to the page here. How to use code tags: [noparse] [code=html] …

It sounds like your password is incorrect for the sa account. Can you login with the sa account using the "Query Analyzer" or the other "Database Manager" application? I forget the name of it in SQL2000, they renamed it in SQL2005 :P

[code=vb.net] Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim newHeight As Integer = Math.Truncate(SystemInformation.WorkingArea.Height * 0.8) Dim newWidth As Integer = Math.Truncate(SystemInformation.WorkingArea.Width * 0.8) Me.Height = newHeight Me.Width = newWidth Me.Top = Math.Truncate((SystemInformation.WorkingArea.Height - Me.Height) / 2.0) Me.Left = Math.Truncate((SystemInformation.WorkingArea.Width - Me.Width) / 2.0) End …

Please explain what you are doing and why you are doing this. This is a rather odd question

Are you talking about the Visual Studio IDE? There was an option when you installed it to use the local help files or attempt to access the online help files. Please clarify what content you're wanting to search offline and we'll go from there.

In addition to the information Salem requested here is one way to go about it: IANA Numeric ICMP Types: [url]http://www.iana.org/assignments/icmp-parameters[/url] iptables block on type: [code=bash] ${IPTABLES} -A INPUT -p icmp --icmp-type 8 -j DROP [/code] [b]DO NOT[/b] join the rest of the world and block all ICMP traffic. iptables man …

You can't terminate the file handle. You can only kill the process. Meddling with another processes resources will likely cause the application to raise an exception and close anyway. Obviously if the application holds the database open it expects that subsequent calls to the database do not require reconnecting -- …

Mac/Darwin is a modified FreeBSD, not linux. I hope that helps you some -- I would start looking at BSD options.

motters: Please post your project. Zip it and upload the entire project.

Do you have access to the application's source code for debugging? It could be prepending the file path with wrong information or some other programming mistake causing the error.

Are you creating the controls on the postback? If you don't then you won't see the updated data.

[code=sql] IF OBJECT_ID('Uniq', 'U') IS NOT NULL DROP TABLE Uniq Create Table Uniq ( ID UniqueIdentifier ) GO Insert Into Uniq (ID) Values (NewId()) Insert Into Uniq (ID) Values (null) GO --Now we have our test data set up Delete From Uniq Where ID Is Null Select * From Uniq …