finito

Well, it is similar to UPDATE. Just do this [CODE=sql]DELETE FROM table WHERE condition[/CODE] If you show me some of your work, I may better understand what you want. Can you show me your select statement with propagation.

please use code tagging. Where are u setting the Date? Could you please explain what you are doing? From what I can understand you are trying to get a report to show something from a start date to an end date.

Well unless you know how to solder and find the exact chips that have gone bad. And without looking at the motherboard I can't tell you which Chip, transistor, or circuit has gone bad. If you don't know what I am saying, take it to a professional don't mess with …

umm, this may be a silly question, but do you have a CD-Writer or is it just a ROM?

[url]http://www.ehow.com/how_5962454_do-blacklist-site_.html[/url]

Welcome to the forums, Please introduce yourself at [url]http://www.daniweb.com/forums/forum165.html[/url]. [CODE]sql = "delete from budget_details where ID = " & DataGridView1.CurrentRow.Cells(0).Value.ToString() [/CODE]

Date time formats need to be in 'yyyyMMdd hh:mm:ss:fff' format. try '19990907 12:00:00:000' time will be in 24h format. if you want to check for date like Update where the date is 07/09/1999 (dd/MM/yyyy) you can do Where Date between '19990907' and '19990908' This will get you all results with …

Call Microsoft, if you don't do anything it will lock you out after hmm 30 days? or was it 60. Yeah but the point is it will lock you out

I believe the best people to ask are Dell itself. Did you contact them recently? if not you should and ask them what it is, if you did than that is what it probably is. Sorry I can't be more helpful than that, first thing I do is get rid …

Please use code tagging you didn't hook da with the conn.

Welcome to the forums, Please take some of your valuable time and introduce yourself [url]http://www.daniweb.com/forums/forum165.html[/url]. What is the function of your app?

you want to make that part into OleDbCommand not adapter

your code looks good but where is con.Open() what error are you getting?

PXE-E61: Media test failure, check cable PXE-M0F: Exiting Intel Boot Agent. Error is for Network boot, your machine seems to be skipping boot to HD. What you want to do is Set CD to boot first. If you are doing that then maybe your XP disk is not bootable or …

Well for me it seems that the it updates every 5 ten minutes, but posts already in there are updated instantly. threads that I post in for the first time take 5 mins but the ones that i already have posted in are almost instant. At least it looks like …

[CODE]int LastSep=0; for (int i=0; i< textBox1.Text.Length;i++) { if (textBox1.Text[i] == ' ') { label5.Text += new OleDbCommand("Select English FROM Dictionary where Ilokano like" + "'%" + textBox1.Text.SubString(LastSep,i-LastSep) + "%'", conn).ExecuteScaler().toString() + " "; LastSep=i; } if (i == textBox1.Text.Length-1 && textBox1.Text[textBox1.Text.Length-1] != ' ') { label5.Text += new OleDbCommand("Select …

can you try to remove the battery and only give it power via the Adapter?

Try Running this separately [CODE]SELECT DISTINCT c.primaryemailaddress, c.companyname, CAST(m.maxdate AS DATETIME ) AS maxDateCreated FROM companycontact AS c[/CODE] Then try this separately. [CODE]SELECT so.companyname, MAX(so.date_created) AS maxdate FROM ordhed_sales AS so, company AS co WHERE so.companyname = co.companyname AND co.isOEM = '1' GROUP BY so.companyname) AS m[/CODE] Peace.

roll on floor //please add the rest How much are you expecting for that?

From what I understand you are unplugging and plugging the power cables. What you need to do is take off all components. ie. PCI, ISA, USB, Mouse, Keyboard, VGA, Aux Fans (Non-essential Case Fans) etc. Leave only the Processor and the RAM, You want to hear one single Post beep. …

constant beep? Hmm is it coming and going or just is it a continuous tone. Like when you pick up the phone? Can you try and remove all peripherals and leave just the processor and motherboard (and PSU ofc). Remove the RAM as well. you should hear 5 or 4 …

Could you explain what [B]CalculateNewRecordNumber[/B] is supposed to do. I think it can be done more efficiently. Why are you doing this? [CODE] textBox2.Text = DateTime.Now.ToString(strFormat); textBox2.Text = record; [/CODE] This statement doesn't look right [CODE] string strChechID1 = "select LoadingNo from LoadItems where LoadingNo=LoadingNo"; [/CODE] Ok this is Where …

Please Look at [URL="http://www.dotnetperls.com/streamreader-vbnet"]this[/URL]. then Look at [URL="http://patorjk.com/programming/tutorials/vbarrays.htm"]this[/URL]. Read them and see what you figure out. Ask Questions and present your theories. Peace.

Post some more of your code. Provide the data types of the variables. Don't use Help as a subject Matter. Peace.

[QUOTE="sushanth08"]basically can u tell me the code to replace some strings in the rich text box i.e clearing and inserting[/QUOTE] [CODE]//Clearing richTextBox1.Clear(); //Inserting richTextBox1.Text="ABCD\nEFGH"; // Adding /n is to generate a new Line so Output will be // ABCD // EFGH [/CODE] Peace.

I think you are asking about the Raw DateTime format as you receive from it from the Database. This varies on the database itself. MSSQL spits it out like this: yyyyMMdd HH:mm:sss:hhh MySQL I believe is yyyyMMddHHmmss If you mean how to you Enter Date into a DateTime variable Then …

Try running that statement in SQL browser [QUOTE][CODE]Select Personne.[Nom],Personne.[Prenom],Personne.[DateNaissance],Personne.[LieuNaissance],Bulletin.[Autorite],Bulletin.[DateJ] from (Personne inner join Bulletin on Personne.[CodePersonne]=Bulletin.[CodePersonne])where Personne.[Nom]=@nom and Personne.[Prenom]=@prenom"[/CODE][/QUOTE]

You can also use CAST Command [CODE]CAST(fieldname as VARCHAR[50]) [/CODE] But this is more useful in using the field as a temporary basis. Like [CODE]SELECT CAST(fieldname as VARCHAR[50]) from table_name[/CODE] For Permanent change using the above solution is better. (ALTER TABLE) Peace.

What is the Model Number?

[CODE]SELECT username FROM users Inner Join friends ON users.id = freinds.uid WHERE uid = {$this->id} OR fid = {$this->id}[/CODE] There may be a syntax error here. I am assuming that you have only one primary key on both users and friends.

Try using Switch Case [CODE]switch(n) //basically like saying if n = case { case 1: //so if n = 1 then cost += 25; break; case 2: // if n = 2 then cost += 25; goto case 1; // do n=2 then n=1 you need a break to end …

Look at this part alone: [CODE]SELECT 'ClientDocs', ClientID FROM clients WHERE NOT (clients_ClientID IN (SELECT ClientID FROM clients,folders WHERE clients.ClientID=folders.clients_ClientID))[/CODE] In your first post you said: [QUOTE]Client Table: ClientID INT PK AI, ClientName VarChar[/QUOTE] Look at this part: [CODE]WHERE NOT (clients_ClientID IN [/CODE] You are calling for clients_ClientID from the …

I am having some trouble. I have a Linux Server hosting 5.1 MySql. The Windows clients are running a POS Program written in C# using the .Net Connector. The Problem is that the initial connection takes around 12 Seconds which is not a big problem, but when you let it …

Games have become lame. I can't remember the last time I played a game and really liked it. Maybe I have become older? nah It is definitely the games have become too generic. You played one you played em all. I want somthing innovating like MGS, just don't see it …

[url]http://www.cgsecurity.org/wiki/CmosPwd[/url]

Well, Do you know how to retrieve data from the SQL database? Do you know what if statements are? If you can answer both you can do it. Please explain which part you don't understand, so I may try and clarify. Regards.

I am a little confused are you complaining that ExecuteScaler() only gets one value? If so that is it's function. Could you clarify what you are trying to do? What I see is You are getting the ddlProductName.SelectedValue value from the Database, then you are deselecting what ever was selected …

Hello Pooja, Please show some effort or work. Give me your pseudo code. Please read the rules about homework.

Hmm, I would go with the same suggestion your USB port is low on power, try different ports. Also try a different computer.

[url]http://www.iskysoft.com/free-mac-video-downloader.html[/url] [url]http://homepage.mac.com/major4/[/url] Or for lossless MP3 [url]http://www.fraction.jp/log/archives/2008/01/18/FLVMP3Extractor[/url] The quality degradation is minimal. It depends on how good the source is. If the source sucks no matter what you do, you can't get better than the source file. MP3 is a compression standard, if you want high lossless quality you shouldn't …

[url]http://www.codingforums.com/showthread.php?t=398[/url]

Please read the rules, No thread Hijacking. As for your problem, check the GPU fan, it maybe stuck. if there is no Fan, check the heatsink.

I don't see any problem at a glance can you tell me which line you get the error?

I have a screwed install of MySql Server on my Machine its a 10.04 64-bit Ubuntu. I can neither Remove it or Install a new one. [CODE]I tried apt-get remove [/CODE]and [CODE]dpkg --purge mysql-server-5.1[/CODE] They both reach [CODE]dpkg --purge mysql-server-5.1[/CODE] and stay stuck there. Can anyone please help me completely …

can you please elaborate. Show some examples of what you want to do. Add some pseudo code. Regards.

It looks like this is a homework assignment.

[QUOTE]"Object Reference not set to an instance of an Object"[/QUOTE] This usually means no result from the Database, Like the connection is OK but there is no matching criteria. Can you point out where it shows this error, I mean what Line.

[QUOTE]Is it possible that dust collecting inside could be triggering a CPU shutdown because of overheating?? [/QUOTE] Although rather unlikely, does your machine become hot?

If you have the recovery discs, you should be able to use that. If not, then the easiest way is to format and Reinstall everything. If you do not have the Windows Disc, I would recommend Linux distros such as [URL="http://www.ubuntu.com"]Ubuntu[/URL] or [URL="http://www.LinuxMint.com"]LinuxMint[/URL]

Can you provide a sample data of Value Maybe you should use DateTime.ParseExact()