M.Waqas Aslam

please check these links , hope they will help you. [Click Here](http://www.codeproject.com/Articles/123441/SQL-Server-2008-Backup-and-Restore-Databases-using) [Click Here](http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/5638666e-cd2e-467d-bd03-6d20e2cbbe1b/) regards

yes you can join then or use nested select statements ,like this Customers ---------- custid custname Interest --------- interestid custid interestname now you have to get all the customers who have interest in football , you can do like this . select c.custid,c.custname ,i.interestname from customers c inner join interest …

just right click on your project , select properties then select compile option then select advance compile option then there will a combobox with value .net 4 Client Profile just select .net framework 4 . you will have crystal report viewer for use :) if this helped you please vote …

quran is word of God , and there is no changes in it even after 1400 years .There are currently millions of muslims who fully memorised same exact qur'an down to the dots and crosses so to speak These millions of people are spread in all corners of the world …

just set the combobox.valuemember = your_field_name , and where you are getting the value of combobox just use this combobox.selectedvalue . Regards

happy stay at daniweb

mohanrajan , always start new thread for your new questions. well yes you can use glass effect on your forms , but for this make sure your application is running on windows 7 , because in windows xp this functionality will not work. Regards

i dont know much about the list view control , but here is a code to get value of the cell from the datagrid whos checkbox is checked , dim myarr as new ArrayList for i = 0 to datagridview1.rows.count-1 if datagridview1.item(1,i).value = true then myarr.add(datagridview1.item(0,i).value.tostring()) end if next this …

can you please tell me your tables fields .so that i can write query for this prob ? Regards

just change this line of code cmd.CommandText = "Update HallTransaction Set status=@status where ID=@ID" Regards

are you populating your grid from database ? or there are pre-define rows in your datagrid ? Regards

hello use this Dim fs As IO.FileStream = New IO.FileStream("d:\a.txt", IO.FileMode.Append) Dim sw As IO.StreamWriter = New IO.StreamWriter(fs) sw.Write("TEXT" & vbCrLf) sw.Close() Regards

hello ! please check the attach sample project of count down counter . here is a code , i have three textboxes , txtsec , txtmint , txthours. and a timer here is a code . Dim sec As Int16 Dim mint As Boolean 'use this code at the timer …

if you are using vs2008 then you can make applications on 2.0 , 3.0 and in 3.5 frameworks. and if you are working on 2010 then you can make applications of 4.0 framework.

you can do somthing like this . add a module and just call this public sub at your form when ever you want to clear your textboxes or other controls . Public Sub ClearAllTextBox(ByVal myControl As Object) Dim i As Integer For i = 0 To myControl.Controls.Count - 1 If …

where you want to perform this action , i mean where you want to press the tab key to populate your grid from your database. Regards

well there is a site [Click Here](http://www.planet-source-code.com/) you can find your required application from here , hope this will solve your prob Regards

hello try something like this. dim con as new sqlconnection("connection string") dim cmd as new sqlcommand con.open() cmd.connection = con cmd.commandtext = "update table1 set col1=@col1,col2=@col2,col3=@col3,col4=@col4 where recid = @recid" cmd.paramerter.addwithvalues("@col1",txt1.text) cmd.paramerter.addwithvalues("@col2",txt2.text) cmd.paramerter.addwithvalues("@col3",txt3.text) cmd.paramerter.addwithvalues("@col4",txt4.text) cmd.paramerter.addwithvalues("@recid",txtRecId.text) cmd.ExecutenonQuery() con.close() hope this will help you . Regards

try something like this dim con as new sqlconnection("connection string") dim cmd as new sqlcommand con.open() cmd.connection = con cmd.commandtext = "update table1 set col1=@col1,col2=@col2,col3=@col3,col4=@col4 where recid = @recid" cmd.paramerter.addwithvalues("@col1",txt1.text) cmd.paramerter.addwithvalues("@col2",txt2.text) cmd.paramerter.addwithvalues("@col3",txt3.text) cmd.paramerter.addwithvalues("@col4",txt4.text) cmd.paramerter.addwithvalues("@recid",txtRecId.text) cmd.ExecutenonQuery() con.close() i typed it here so may be there are some spelling mistakes in it …

hello , i am getting error on it , object refrence is not set to an instance of an object , my code is if (dgvBlockSites.Rows[j].Cells[1].Value.ToString() != "-1") { //-------------- some code here } i dont know what is wrong with it , i have 4 or 5 rows in …

hello ! i want to restrict user to not visit www.abc.com site , from my pc , how can i do it in c# , user will use chrome , firfox , IE etc , Regards

hello ! i am working on a simple application that can block the sites ,after searching i found that if i add name of the site in c:\windows\system32\drivers\etc\hosts then i can block those sites , for this i want to open this hosts file in my textbox with administrator rights …

hello ! use this code at the search textbox textchange event. Sub search() dim con as new sqlconnection("your connection string") con.open() dim dt as new datatable dim da as new sqldataadapter("select * from table1 where firstname like '%" & txtSearch.text & "%'",con) da.fill(dt) datagridview1.datasource= dt con.close() End Sub simple change …

shortcut key ? please explain little bit . and as i understand your question you can do like this. ' use this code on the textbox keypress event if e.keychar = chr(keys.f3) textbox1.text = now().tostring end if hope this will help you. Regards

hello! i am developing a simple application which will get data from different database like mssql , access , foxpro , and after getting data it will create 4 text files tows.txt , customer.txt , product.text , trasection.txt , prob is this that i am very new to foxpro , …

hello ! i am now working on office management system. i have a code to disable the usbport , i want to use it in win7 , before this i already used it in other project on windows xp , it works fine , but now in windows 7 it …

well you have to add columns first in order to add any value to your grid.

what do mean by passing values , are you want to add value in any cell ?

i cant get your point please be more specific , and little bit explain ,it .

hello ! i am working on a simple parental lock application . i want to know all the websites visited by the user , i mean , for example now i am visiting daniweb.com , is there is any way to get the name of daniweb.com and after getting it …

and you can use this query also. select * from myTable where MovieName = 'VI' Regards

can you please just tell me your requirements , not code or what you have done so far , just to the point tell me your requirements.

please always ask to the point question , this will make easy to others to help you , now tell me the basic prob you are facing . so that i can better answer your prob. Regards

the better way is to auto save your data after specific time as in Visual studio .VS save data i think in every 5 mint , in a temp file , so if your system restarted abnormally then VS ask you on the next start that you want to restore …

well i think we can only get the system date time , and we consider it orignal date time , .you can get time from any server , or from any site .

or you can use isnull(value , 0 ) in mssql Regards

try somthing like this. 'on form1 we have two textboxes (txtName ,txtAge) and one button and on form2 we have grid having two columns , 'name and age . 'now use this code at the button click event on the form1. form2.show() 'now use this code at the load event …

change this code with this Checkbox1.Text * TextBox2.Text ' it your code change it val(Checkbox1.Text) * val(TextBox2.Text) ' use this code.

and you can manually format your string of masg by using vbcrlf , vbtab etc ,

if you are using vs2010 then GetAsyncKeyState lib will not work , regards

hello ! i want to connect foxpro db file .dbf and want to show all the records in my grid . i am using vs2008 can anyone give some idea. Regards.

please have a look on this link [Click Here](http://forums.asp.net/t/1163565.aspx/1)

well simply use this. frmOne.button1.enable = false Regards

ok do like this , for example your 2nd column of grid is you amount column , which you want to sum , dim mySum as integer mySum = 0 for i = 0 to datagridview1.rows.count -1 nySum = val(datagridview1.item(1,i).value.tostring) + mySum Next This will Sum all the rows of …

well simple use this. msgbox(txtbox.text) and if you have so many txtboxes and want to show the data in masg then you can use this. msgbox("name:" & txtName.text & vbCrlf & "Age:" & txtAge.text) hopr this will help you. Regards.

yes just after the code where you assigning the datasource to your grid use this code. datagridview1.column(0).headertext = "your text" datagridview1.column(1).headertext = "your text" . . . Regards

well i think , you can just make two public functions for got focus and lost focus , and just call them , this will reduce your code ,

please check this out [Click Here](http://www.daniweb.com/software-development/vbnet/code/366392/encryption-and-decryption-functions-in-vb.net) hope this will solve your prob :) Regards

yes you can easily do this , first just add a bindingsource in your form and do like this. dim con as new sqlconnection("your connection string") dim dt as new datatable con.open() dim da as new sqldataadapter("select * from table1 ",con) da.fill(dt) bindingsource1.datasource=dt con.close() after this you can call following …

hello ! may God bless all of you, i m good in mssql , but this is very first time that i am very confuse , the case is , i have a table , having fields 1- ContactPersonId 2- Name and 2nd table having fields 1- recId 2- ContactPersonId …