identity automatically increment your column values from seed property specified in identify clause. exam create table tbl ( i int identity(1000,1), name varchar(100)) output 1000 ;P 1001 1002 Ganu Sharma

I actually suggested it because in the given scenario ,its having lakhs of records which is not feasible to store at server memory and if its going to be user specific then its going to hazardous for the server and performance of application :) In all it depends on the requirement and the size of data :) Cheers!! Brij Check my latest Article :Exploring ASP.NET Validators

Why, the only reason I can think of for this is to service a presentation requirement, that is a report, output or a form requirement. The relevant word is PRESENTATION, do this type of formatting at the correct place, not in the database, as has been suggested. This is not a suggestion it is a general rule, a database is for the data, not pissing about with formatting and layout. Never underestimate the power of human stupidity RAH

add System.Data.SqlClient namespace 1. Open SQL connection 2. Call SqlCommand member for your query! 3. Read your value by DataReader "Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow Never mind - my own stupidity is the source of every "problem" - Mixture cheers, Alok Gupta VC Forum Q&A :- I/IV Support CRY- Child Relief and You

Hi, you can use this class: class email_validation_class { //var $email_regular_expression="^([a-z0-9_] |\\- |\\.)+@(([a-z0-9_] |\\-)+\\.)+[a-z]{2,4}$"; var $timeout=0; var $localhost=""; var $localuser=""; Function GetLine($connection) { for($line="";;) { if(feof($connection)) return(0); $line.=fgets($connection,100); $length=strlen($line); if($length>=2 && substr($line,$length-2,2)=="\r\n") return(substr($line,0,$length-2)); } } Function PutLine($connection,$line) { return(fputs($connection,"$line\r\n")); } Function ValidateEmailAddress($email) { //return(eregi($this->email_regular_expression,$email)!=0); return(eregi("^([a-z0-9_] |\\- |\\.)+@(([a-z0-9_] |\\-)+\\.)+[a-z]{2,4}$",$email)!=0); } Function ValidateEmailHost($email,$hosts=0) { if(!$this->ValidateEmailAddress($email)) return(0); $user=strtok($email,"@"); $domain=strtok(""); if(GetMXRR($domain,&$hosts,&$weights)) { $mxhosts=array(); for($host=0;$host<count($hosts);$host++) $mxhosts[$weights[$host]]=$hosts[$host]; KSort($mxhosts); for(Reset($mxhosts),$host=0;$host<count($mxhosts);Next($mxhosts),$host++) $hosts[$host]=$mxhosts[Key($mxhosts)]; } else { $hosts=array(); if(strcmp(@gethostbyname($domain),$domain)!=0) $hosts[]=$domain; } return(count($hosts)!=0);

Hi, there are two ways: 1. the easy one: give your Form a MainMenu or MenuStrip and make sure the actions you want are present in the menus; all it takes to create shortcuts is setting their corresponding ShortCut property. 2. the harder way (also for the user as he has no clue what shortcuts are available): let your Form preview the keyboard (Form.KeyPreview) and give it a KeyDown handler. No need to process the keys for each individual Control on the form! :) Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

It is easy to do this. I think this is what I am talking about http://www.vbdotnetheaven.com/UploadFile/prvn_131971/machineprocessvb11182005001454AM/machineprocessvb.aspx[^] Cheers.:rose: Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution. My Latest Articles-->** Simplify Code Using NDepend Basics of Bing Search API using .NET Microsoft Bing MAP using Javascript

Thanks..i will try this.... Regards, S,Inayat Basha.

At least give it a try! First search on google how to open up a file then google for reading it and then for inserting into db. Please don't forget to mark 'Good Answer', if you find it really a good one! Kashif

inayat basha wrote: thx for ur sugession.can u tell me the PDF converter libraries plzzz While I appreciate that English may not be your first language, writing in this textspeak form makes you appear less intelligent than you may actually be. Try searching Google for "PDF Library".

thanks for ur post, but it was not working....