debasisdas

1. Do not use reserved key words as variables(Command,Connection etc). 2. Both of your SQL is syntactically wrong.

You need to read [URL="http://www.exforsys.com/tutorials/vb.net-2005/vb.net-simple-data-binding.html"]this[/URL].

Have you tried using [CODE]insert into .......select from ......[/CODE]

Create a view based on concatenated value of all the columns and run the search on that view instead of the table.

You need to read [URL="http://tlug.dnho.net/?q=node/209"]this[/URL].

If you want free --> MySQL Can Pay----MS Access Can pay more ---> Oracle want free but not for business purpose ---oracle express

If your connection is successful using the [URL="http://www.connectionstrings.com/"]connection string[/URL] then it is connected.

what application ? which textbox ? choose what ? why choose ? .... ? HOW MUCH I NEED TO GUESS ?

error on which line ?

I think all the above requirement can be done by SQL and the output needs to be populated in the grid.

Hi Jassica, Welcome to Daniweb.

[URL="http://progtutorials.tripod.com/ADO_NET.htm"]This[/URL] is for you. Happy learning.

since you are storing the data in the DB , need to read the max of existing number and increment the same by 1 to get the new number and concatenate the same with your string.

[URL="http://www.vbdotnetheaven.com/UploadFile/mahesh/2948/"]This[/URL] may be helpful to you.

I think [URL="http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/354285"]this discussion[/URL] is good for your reference.

How are you doing all that currently ? Better to use stored objects than executing raw SQL.

Are you going to pass the same value for search on both the columns ?

Even if login is a key word, since it is wrapped with [] there should not be any problem. check for any mispelled or spaces in the column name. Better to try using a different name as suggested by Jx.

You need to design the database first.

Hi Welcome, Hope you have a nice time here and enjoy sharing all your valuable knowledge and experience.

As you said you have tried using all sort of connection strings, let me give you a work around. open notepad --> do not write anything --> save the file with name Behseini.UDL --> close the file. Now open the file and choose the connection and test it. Once it …

you are facing problem with which part of the code ?

Check if the oracle service and listener services are up and running. Also ensure that the account is unlocked and has permission to connect to he database.

If you want to store long text need to expand your limitations.

I think you need to ignore the white spaces while reading from XML and storing in DB.

It will come from cache if the data in the table did not get changed between your select and create as select statements. To ensure that the number of records are >0 use select count (*) not select *

[B]answer deleted[/B]. sorry, late response, kept he window too long before responding.

The problem is not with the trigger but the remote database. Since you are working over a DB link , the remote DB should always be available from the calling / referring DB.

You have mistyped the common dialog control name. should be [B]cDialog[/B] not [B]dialog[/B].

Timestamp will capture the exact time when the record was changed for each record.

You need to copy only the table data rather than entire table. Please read more [URL="http://www.tutorialspoint.com/mysql/mysql-database-export.htm"]here[/URL].

Indian Premier League -IPL as it is popularly known as in the cricketing world starts this evening. This is the 4th edition of the cricketing extravaganza. With India winning the ICC world cup last week, global feast is over, time for clubbing. Defending champions Chennai Super Kings takes on new …

2178309

[QUOTE=arezz09;1530824] can i view only 2 column in listview, example only column 1 & 2 only in listview.. [/QUOTE] Yes [QUOTE=arezz09;1530824] if i remove code in line 5 and 6 i will get error... [/QUOTE] why ? If you want to display only 2 columns why you need to add …

The following links may be useful to you. [URL="http://sqlserverpedia.com/blog/uncategorized/how-can-i-link-a-sql-server-database-to-ms-access-using-link-tables-in-ms-access/"]Link1[/URL] [URL="http://www.mssqltips.com/tip.asp?tip=1480"]Link2[/URL]

[QUOTE=coolpintud;1527852]..... direct give me code or project file .....[/QUOTE] Don't ever expect that here. You need to show some effort to get help from our experts.

What exactly is the nature of transaction that you are going to execute on this data base ?

[quote]I was excited to see it.[/quote] yes , tell your friends. [quote]i don't really understand[/quote] you will understand as you spend more time here.

Your question was in MySQL or MS SQL ? You need to read [URL="http://www.databasejournal.com/features/mysql/article.php/10897_2201621_1/Deleting-Duplicate-Rows-in-a-MySQL-Database.htm"]this[/URL] for more details on MySQL version of the question.

Have you tried using the MM control ?

Hi, Welcome to Daniweb.

May be you are looking for [URL="http://www.codeproject.com/KB/audio-video/oscilloscope.aspx"]this[/URL].

lets see what you are working on.

[QUOTE=Mike Bishop;1528251] The issue I have is in the VLP_QC_Results_Batch1000 has the testNo within a field called TestNoName and is separated by a “-“ I need to link these so that we can show the upper and lower limit for each test and the test results [/QUOTE] I really did …

Why not make the ID field an auto number .

You need to check the following links. [URL="http://msdn.microsoft.com/en-us/library/x1d5a9f2%28v=vs.80%29.aspx"]link1[/URL] [URL="http://www.vbdotnetheaven.com/Uploadfile/mahesh/GdiPlusBiggeners04272005015358AM/GdiPlusBiggeners.aspx"]link2[/URL] [URL="http://www.vbdotnetheaven.com/UploadFile/dbeniwal321/ShapesInWPF11232008020439AM/ShapesInWPF.aspx"]link3[/URL] [URL="http://www.devasp.net/net/articles/display/1091.html"]link4[/URL]

Read [URL="http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html"]this[/URL] and [URL="http://www.abbeyworkshop.com/howto/lamp/MySQL_Export_Backup/index.html"]this[/URL] for Exporting of mysql

Is that a web application and designed to run using a Browser ?

From the string in the text file how you know which is 1. the book name 2. the chapter 3. the vers what is the database that you are using ?

try this [CODE]SELECT SUBSTRING(QCTEST.TESTNAME, 1, CHARINDEX('-',CTEST.TESTNAME)-1) FROM ....[/CODE]