hi i have developed my application in vb.net2005 & inbuilt crystal report. i have taken one maskeditbox with 'shortdatetime' data type & in database - sql server2005 there is also datatype is 'datetime'.but after executing application following error occured - error - unable to cast object of type 'system.string' to type 'system.IFormatProvider' my namespaces are - imports system.data imports system.data.client sql_str = " insert into abc(mdate2,itemcode)(select mdate2,itemcode from xyz where mdate2 = " & " " & convert.date(me.maskedbox1.text) & " )" my stored date format is 'dd/MM/yyyy' with time 00:00:00. but i do not want this time.what i do ? plz. help me. i want only date in dd/MM/yyyy format without time and datatype 'datetime' using maskeditbox . how can i do calculation on date suggest me code with sample.

Thanks bye

thanks for reply. then what should i do for printing on dot matrix ? pliz. suggest me code.

Thanks bye

hi to close the application use - application.close() & to close the current form simply use - me.close()

Thanks bye

hi guys i want to print windows based report on dot matrix printer. is it possible? if yes what will be the h/w , s/w requirement for it ? and coding structure for it in vb.net. since i have developed report in vb.net2005 & crystal report.

Thanks bye

hi but it is working in vb6. so i think that it is possible in vb.net also. if i use dtpicker then is it possible ?

Thanks bye

hi first of all thanks for helping me to lock the control keys function. it works greately. similarly i want to lock 'Save As' option in menu toolbar because whatever documents i am showing on web page that are most confidential so nobodies could not copy,delete,save,print that data. it is only for displaying purpose. i think i got my point. so pls. help me to lock save option. once again thanks.

Thanks bye

hi guys maskedtextbox1.mask = "##/##/####" mskedtextbox2.mask = "##/##/####" i am using maskedtextbox for getting i/p of date. i have taken mask properties short datetime. my data is stored in sql server 2005 where i have taken data type is varchar(10) in dd/mm/yyyy format (28/08/2007 & 31/08/2007). my problem is that when i execute the sql query for the selected period in maskedtextbox it does not show correct data. e.g. sql_str = "insert mdate into xyz (select mdate from abc where " & _ "mdate between" & " '" &maskedtextbox1.text& "' and '"&mskedtextbox2.text&"'" "and flag= '" & mflag & "')" or using where condition it is not executing correct data. can i get where i am wrong ? if is there any more suggestion for me suggest me.

Thanks bye

hi how can i design multicolumn combobox for selecting 2 columns from popup ? i am using 2 fields - itemcode & length. for same itemcode there is multiple length which i have to select. e.g. itemcode - length - rate abc - 15m - 2.0 abc - 20m - 1.20 abc - 200 m - 4.0 asd - 2 m - 0.50 asd - 1 m - 0.20 if i have to select 1 popup item thru combo box. how do that ?

Thanks bye

hi i want to lock 'Save As' option at the time of running my web application. how it will be possible? so that nobody can copy my confidential documents which is i am showing at the run time.

Thanks bye

hi guys i am using tablmapping property of data adapter. my data table is the o/p of sql query execution. that table i am mapping with datatable in database as follows - da.tablemapping.add("table","abc") it shows data correctly in datagrid. but instead of datagridview i have to add that data in my database table - abc which is empty. how can i do this ? & tell me one thing what is the diff. betn. in tablemapping & datatablemapping property ? when it should be use? this table i have to use for crystal report . if is there any direct method for collecting data from 2,3 tables & printing it.

Thanks bye

hi thanks. i want to store data table of database from query's o/p whatever will come.

Thanks bye

hi thanks for immediate reply. but for only data display we can use datagridview . then what will be the difference betn datagridview & data set

Thanks bye

hi i want to know which one is better to use regularly either data set or data reader ?

Thanks bye

hi can i directly update data table from execution of sql query ? or at the time of query execution can i store o/p directly into table?

Thanks bye

hi is it possible to insert Internet Inbox ? if yes then how? so that only authorised person can see mail & reply it.

Thanks bye

Thanks it helped me greately. my problem is solved. now tell me how to clock 'save as' option in application at run time?

Thanks bye

hi i want to generate crystal report in vb.net . is there any inbulit facility of report writing except crystal report ?

Thanks bye

hi can i prohibit the ctrl key function just like ctrl+C - copy ,ctrl+P - print after running the application on web page? if yes then how ?

Thanks bye

hi i want to know is it necessary to use printdialog,printpreview control for crystal report in vb.net2005? if yes then how it is use? & one more question is that what is the difference between crystalpreview dialog control & printpreview ? -- modified at 8:50 Sunday 30th September, 2007

Thanks bye

hi can anybody help to me how to write report in vb.net 2005 ?

Thanks bye