the actual value is stored in variable in by val and in byval reference is stored in the variable and actual data is stored in the heap

hi friend user control shall be use by single appllication and custom control is used by multiplication application

datagridview1.currentrow.cell(0).value this will work and give the connection

if u take mdi form then for child control u can take a contextmenustrip in tooltip. then the form .then u write the name. and double click and write dim frm as new formname frm.showdialog this is the only coding

i check what u have written is also not working what i will give u this is the correct coding copy it Dim ctrl As Control For Each ctrl In Me.Controls If TypeOf ctrl Is TextBox Then ctrl.Text = "" End If Next

hi first u write the code and in load form for line u disable radio button not first ok your problem is sol ve

hi you can take the toolbox from openfiledialogbox1

yes

in select statement strdelete="delete from tablename where datefield='date' objsqlconn=new sqlconnection("user id=sa;password=;data source=servername") objsqlconn.open try Dim vbmsg As String vbmsg = MessageBox.Show("Are u sure to delete this record", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Information) If vbmsg = vbYes Then strdelete = "delete from tablename where datefield='date'" objsqlcmd = New sqlcommand(strdelete, objsqlconn) objsqlcmd.executenonquery() Else MessageBox.Show("There is no field exits") End If catch (ex as exception) exception(ex.message) end try

hi this is the coding to fill the combo strselect="select fieldname from tablename " objsqlconn=new sqlconnection("userid=sa;password=;data source=servername") objsqlconn.open() objdataset=new dataset objsqlcmd=new sqlcommand(strselect,objsqlconn) objsqldataadapter=new sqldataadapter(objsqlcmd) objsqldataadapter.fill(objdataset,"Tablename") cmbname.datasourc=objdataset.table("Tablename") cmbname.displaymember="Fieldname" cmbname.displayvalue="fieldname" this is how to fill the combo have a nice day

i suppose use non abstract class but not sure

both are one and the same thing what u suitable u can do it if u write single line then this is smart work

objsqlconn=new sqlconnection("user id=sa;password=;data source=servername") objsqlconn.open objsqlcmd=new sqlcommand objsqlcmd.connection=objsqlconn objsqlcmd.commandtext="master..xp_cmdshell 'del d:\" + databasename + "'" objsqlcmd.commandtype=commandtype.text objsqlcmd.executenonquery objsqlcmd.commandtext=" backup database " + databasename + " to disk='" + databasename + "'" objsqlcmd.commandtype=commandtype.text objsqlcmd.executenonquery this is coding to backup of database from the server

imports system.data.sqlclient dim objsqlconn as sqlconnection dim objsqlcmd as sqlcommand dim dataset as dataset dim strupdate as string first update objsqlconn=new sqlconnection("user id=sa;password=;initial catalog=databasename;data source=servername") objsqlconn.open strupdate="update EMP set f_name=:txt_name where id=:txt_id" objsqlcmd=new sqlcommand(strupdate,objsqlconn) objsqlcmd.executenonquery() messagebox.show("Record successfully update") second delete objsqlconn=new sqlconnection("user id=sa;password=;initial catalog=databasename;data source=servername") objsqlconn.open strdelete="delete from EMP where id=:txt_id" objsqlcmd=new sqlcommand(strdelete,objsqlconn) objsqlcmd.executenonquery() messagebox.show("Record successfully delete")

u want to filter so , u are writing the query. ok then in where clause fieldname like '" & textbox1.text & "%' u will get the result

listviewitem_click event code dim strshow=listviewitem.selecteditem(0).subitem(colname).text

u will take the dll of datetime picker put the datagridview1 in the toolbox and drop in the form right click of addcolumn then there are three field (1)Name (2) Type (3) header text in name write the column name , type select the type of dll ,write the name of the header

see this only u want to save the data grid this is the code objsqlcon=new sqlconnection("user id=sa;password=;initial catalog=databasename;data source=servername") objsqlcon.open dim i as integer for i=0 to datagridview1.rowcount-1 strinsert="insert into tablename(fieldname1,fieldname2) values('" & datgridview1.cell(columnname1).rows(i)(0).value & "',"' & datgridview1.cell(columnname1).rows(i)(0).value & "')" objsqlcmd=new sqlcommand(strinsert,objsqlcon) objsqlcmd.executenonquery() next messagebox.show("Record Successfully Saved ")

hello friend where u get the back of data base it is not saved full some thing is missing so again take back up and there is no error tell me how to creat database with sqlscript or enterprisemanager if u take backup of enterprisemanager is best this is the step (1) open Enterprisemanager (2) right click on database name (3) All Task (4) Attach database (5) MDF File database to attach (Browse the path) (6) click mdf file and ok button you have succesfully attach in the server database then your problem is solve connection to database coding have a nice day

hi friend you are right there is mistake in sql please correct it right string strSQL = "select FilmName from films where FilmName like '" & cmbContent.Text & "%'" ; wrong this is your "select FilmName from films where FilmName like" + "'" + cmbContent.Text + "*'";