debasisdas

From where the values in the listview gets populated ? Is there a database available ?

1. find the position of the word that you are looking for. 2. find the position of the previous and next new line character. 3. delete / remove everything in between. 4. go to step 1

You need to format the date as desired before inserting the same into Database.

Please pass more info.

kindly post the code that you are working on.

do not hijack others old thread. start a new thread of your own.

You need to go through some of [URL="http://www.google.co.in/search?aq=f&sourceid=chrome&ie=UTF-8&q=Armstrong's+Axioms"]this[/URL].

so go ahead and create, what is the problem ?

Yes, i know for sure.

The statistics is very common for newbie posters. As you keep contributing usefully to the community, you will keep moving up the ladder.

BLOB is a stream of binary data. You need to read from DB and reconstruct the file from binary stream and use the file.

You need to go through [URL="http://bytes.com/topic/visual-basic/insights/726143-adding-items-treeview-listview-database"]this sample[/URL] .

This should be a paid job.

try this sample [code] Dim C As ColumnHeader Dim i As Integer For i = 1 To 4 Set C = LV1.ColumnHeaders.Add() C.Text = "Field" & i C.Width = LV1.Width / 4 Next i[/code]

We don't do assignment for you. Show some effort if you want some assistance.

Better put the logic in a function and call the same to generate the value for the column. Once the date changes it will reset the value.

You can't handle windows keys.

Hi Philip, Welcome to daniweb forum.

is that code not working for you ?

Table ? Which table ?

Both are equally effective.

What is the problem , i don't see anything wrong with the SQL.

what about this 1. book (book_id,book)name,author_id,....) 2. author (author_id,author_name,.......) Composite key on book (book_id, author_id)

Yes, you can connect to any database from PHP if you know the connection method and have the proper drivers.

Kindly post what have you tried so far from your side and also post the proper table structure for analysis.

You need to use [B]ALTER VIEW[/B]. Please read [URL="http://msdn.microsoft.com/en-us/library/ms173846%28v=sql.90%29.aspx"]this[/URL] for details.

Why not create insert script using some tool (best in EXCEL) and insert the parent record and then the dependent child record.

you need to insert a page break after each record.

No one can snatch your job if you are competent enough.

Hi Conor, Welcome to Daniweb.

Have you included the Excel library into the project ?

follow these steps. 1. populate the combo only (not the text box) from the recordset. 2. to populate the text --capture the value from combo and pass the same back to DB using SQL. Fetch the Description and display in a textbox.

You need to write a recursive function to find and delete all the files of specific format. Kindly post the code that you are working on currently.

The problem is because of the software of the scanner (may be the driver) is corrupted. Try to completely re install the software of the device. Also check if the reference to the scanner components is removed accidentally from Project---> references

what you want to display if item code is not assigned . Instead of displaying from multiple tables, create a view based on your desired logic and pull records from the view to display in the application.

Hi Susheel, Welcome to Daniweb.

What about using the Horizontal scroll bar .

That is because you are opening the recordset everytime. You need to open the recordset only once (in the form load).

Report , what report ? Where you enter data ? Is that connected to database ? What database ? How the report gets populated ? ? ?? ???

Hi Lorenzo, Welcome to Daniweb.

Hi Sajid, Welcome to Daniweb.

What ever you have posted here is not an E-R diagram.

may be i will read this LONG question in weekends.

[quote]its so strange that i have uploaded my project to show you what iam doing and you are still asking to show you my effort???[/quote] the solution to the problem is simple arithmetic. @satti so far as uploaded the entire project file is concerned, i am here to share my …

Show the code that you are working on or just pay for the code you want ? Coding is not a free service. How much you can pay for the service ?

What does your player do ?

Try this. [code]SELECT CAST((STR( YEAR( @date ) ) + '-' +STR( MONTH( @date ) ) + '-' +STR( DAY(@date ) ) ) AS DATE_AS_I_WANT[/code] or this [code]SELECT CONVERT(varchar, @date,112)[/code]

[QUOTE=VernonDozier;1497005]I'm guessing we have an 850,000 way tie for spot 4,444. [/QUOTE] Now the member count has increased by another 100. So you have to make more parts of the pie. :icon_lol:

Need more info to help you. How the datagridview gets populated ? What exactly you want to show ?

Are you getting something like SQL WORKSHEET under application development ?