568 Posted Topics
 | sorry but i cant get your point , can you please tell me that you want to create buttons and stopwatches dynamically , but how to get the number of buttons and stopwatches you have to create ? . sorry for my bad english , but rephrase your question so … |
| | |
| | hello ! i dont have any experience of access , i am writing here code for mssql , hope this will gives you an idea [CODE] dim mycon as new sqlconnection("connectionstring") dim da as sqldataadapter("select * from SaleInvoice where InvoiceID="& val(txtInvoiceID.text),mycon) dim dt as datatable da.fill(dt) datagridview.datasource=dt [/CODE] this record … |
| | trye this query [CODE] "update tablename set status=@status where DateOfReturn='" & datetimepicker.value.date & "' and AND TimeOfReturn >= '" & datetimepicker1.value.time & "'" [/CODE] hope this will solve your problem . Regards  |
 | you can not delete single column value , you have to delete full record , if you want to delete value of single column then try to use update , just update the value with null . Regards |
 | i think you have to use query which get only required columns , |
| | do you worked on it? , do some efforts then others will help you ,  |
| | hello PF2G ! use this code to fill combobox [CODE] dim myCon as new sqlconnection("ConnectionString") myCon.open() dim da as new sqldatadapter("yourquery_select username from users",myCOn) dim dt as datatable da.fill(dt) combobox.datasource = dt combobox.displaymember = "username" ' your column name ,which you want to show [/CODE] hope this will helps you … |
| | Re: question hello ! for example we have two variables [CODE] int first ; string second ; string Final; first = 23; second = "rollNo"; //you can concatenate them like this Final = second + "=" + first; [/CODE] hope this will helps you |
| | hello EveryOne! i am very new in JS and JSON , or you can say this is my first day to learn something about JS and JSON, i have few questions 1- what is difference between JS and JSON. 2-My Task is to connect MSSQL server 2008 and show records … |
| | hello ! why not you try a stored procedure to delete records from multiple table , by using stored procedure you have to do very little coding . Regards  |
 | Re: sounds use a listbox control and add paths of your sound files in it , then give index of listbox where you have to give path of your sound file , Regards |
| | hello ! try to use query to get filtered records , and then populate your grid [CODE] select customer,Model,Foam,Grade,item,Thick,Width,Length,sum(Qty),25 as ItemPerPackage from YourTable group by customer,Model,Foam,Grade,item,Thick,Width,Length [/CODE] Hope this will help you Regards  |
| | hello ! check [url]www.iconfinder.com[/url] , hope this will solve your prob Regards  |
| | hello ! you should visit telerik official web site [URL="http://www.telerik.com/"]http://www.telerik.com/[/URL] this will help you alot Regards M.Waqas Aslam |
| | hello! i think there is no need to change your code , try to visit this link hope this will solve your prob [URL="http://msdn.microsoft.com/en-us/library/7eh4aaa5.aspx"][/URL] and [URL="http://stackoverflow.com/questions/6090913/make-an-installation-program-for-c-sharp-applications-and-include-net-framework"]http://stackoverflow.com/questions/6090913/make-an-installation-program-for-c-sharp-applications-and-include-net-framework[/URL] [URL="http://msdn.microsoft.com/en-us/library/8st7th1x.aspx"]http://msdn.microsoft.com/en-us/library/8st7th1x.aspx[/URL] |
 | hello ! if Reverend Jim is right then why not you try to use global variable to get your values , as Reverend Jim said that 'may be by the time you try to get values the form has entered a state where that data is not available' Regards |
| | hello ! you can do , like this [CODE] 'first make this sub sub MyInsert(ByVal SaleDate As Date) As Integer Try MyFields = "(SalesDate)" MyValues = "(@SalesDate)" MyConn.Open() Dim Mycmd As New SqlCommand Mycmd.Connection = MyConn Mycmd.CommandText = "insert into " & MyTableName & " " & MyFields & " … |
| | hello ! your are using complicated code for insert, use this code [CODE] Try MyFields = "(SalesID,SalesDate)" MyValues = "(@SalesID,@SalesDate)" dim MyConn as new sqlconnection("connectionstring") MyConn.Open() Dim Mycmd As New SqlCommand Mycmd.Connection = MyConn Mycmd.CommandText = "insert into table1 Values " & MyValues Mycmd.Parameters.Add("SalesID", SqlDbType.BigInt).Value = saleid Mycmd.Parameters.Add("SalesDate", SqlDbType.DateTime).Value = … |
| | hello ! use this [CODE] "update Prod_DB_Completed_Board set Stock Level = '" & TextBox2.Text & "' where Laminate = '" & ComboBox2.Text & "' and Board Size = '" & ComboBox3.Text & "'" [/CODE] It will work fine :) if your prob is solved please mark this thread solved :) … |
| | hello ! you can play video by adding com component of windows media player , and use windowsmediaplayer.play ="path" to play the video , but what i understand from your question is that you want to play video as a background image of your form , am i right ? …  |
| | y not you are using concatenation for this , i cant understand your question , but i assume that if you press add button then the line will add in your giving format , [CODE] 'code this on the click event of your button datagrid1.rows.add(txtserialno.text,txtproductid.text,"TEST0000"& textorderid.text) [/CODE] if please you … |
| | hello ! this will solve your prob :) [URL="http://www.codeproject.com/Articles/23752/Convert-Number-to-Word"]http://www.codeproject.com/Articles/23752/Convert-Number-to-Word[/URL] if your prob is solved please mark this thread solved :) Regards M.Waqas Aslam |
| | hello ! check these links, i m sure you will find your solution :) [URL="http://www.vbforums.com/showthread.php?t=246451"]http://www.vbforums.com/showthread.php?t=246451[/URL] [URL="http://www.codeproject.com/Articles/29281/Spell-Check-in-NET-without-adding-a-reference-ahea"]http://www.codeproject.com/Articles/29281/Spell-Check-in-NET-without-adding-a-reference-ahea[/URL] [URL="http://msdn.microsoft.com/en-us/library/aa537153(v=office.11).aspx"]http://msdn.microsoft.com/en-us/library/aa537153(v=office.11).aspx[/URL] Regards |
| | hello ! if u just want to use keypress event then use this code [CODE] if e.keychar= chr(keys.m) then 'here place your code endif [/CODE] hope this will helps you Regards M.Waqas Aslam |
| | hello ! i have not use this query at my end ,please let me know if you have prob . [CODE] select ID,Data1 ,Data2,Data3,Data4 from ( select tA.id,tA.Data1 as Data1,"" as Data2,"" as Data3,"" as Data4 from TableA tA group by tA.ID union all select tB.id,"" as Data1,tB.Data2 as Data2,"" … |
| | u declare first variable Dim strRand As String = lblHomeID.Text , i think the lblHomeID.text is giving the integer value and datatype of variable name strRand is string . Regards M.Waqas Aslam  |
| | use sqlcommand , for this purpose [CODE] dim con as new sqlconnection("connection string") con.open() dim cmd as new sqlcommand cmd.connection = con cmd.commandtext = "your query" cmd.parameters.add("@rcomer",datatype).value = yourvalue 'cmd.parameters.add("@rcomer",int).value = val(textbox1.text) cmd.executenonquery(); con.close() [/CODE] may be there is some spelling mistakes , as i type directly here , so … |
| | Hello ! i think adam_k is right , u have to use datatable for it or give table name to the dataset , [CODE] dim dt as new datatable 'OR dim ds as new dataset ds.table("Table1").clear ' now you have a table name table1 in your dataset [/CODE] |
| | Hello Every one ! i am trying to make query to show the growth of sale of the product month wise ,i have one table name Sales .having following fields , SalesID,ProductID,amt,Qty,SalesDate i use this query to show my records [CODE] select ProductID,Amt,Qty,substring (datename(month,SalesDate ),1,3)as months,DATENAME(YEAR,salesdate ) as years [/CODE] … |
| | hello ! i think this will helps you , i dont know much about dealing with access so here is code for mssql to perform same function which u want [CODE] dim con as new sqlconnection("connection string") con.open() dim da as new sqldataadapter("ur sql command",con) dim dt as new datatable … |
| | hello ! i think its not possible as far as concern with windows form application to rotate controls , Regards M.Waqas Aslam |
| | Re: CStr() vs Str() hello ! please check this link [URL="http://www.bigresource.com/VB-Str-Str-and-CStr--jcuerOtRwA.html"]http://www.bigresource.com/VB-Str-Str-and-CStr--jcuerOtRwA.html[/URL], hope so it will helps you Regards M.Waqas Aslam |
| | hello ! adam_k you are right , rohne0809 you have to use a stored procedure for this . [CODE] create proc MyDoubleInsert @parameter1 varchar(50)..........,@ParameterTable2 varchar(50) as insert into table1 values (@ParameterTable1,...........) insert into table1 values (@ParameterTable2,...........) exec MyDoubleInsert(value1,value2,.......) [/CODE] Hope this will helps You Regards M.Waqas Aslam |
 | hello Pooja ! m not sure that the solution i m providing u is helpful for u or not , but i regularly using this thing in my projects , y not u try databinding and bindingsource , like this take a bindingsource1 [CODE] dim dt as new datatable dim … |
| | Hello Every One ! I m working on a software , i have one field name expiry_Date , now i want to make an query which subtract the current date from the expiry_date and give answer in no.of days , i use getdate() for current date , can any one … |
| | hello ! i cant get ur point , u just want to move value of the textbox from one form to another or u want to save it then it will show in the previous form ? please rephrase it Regards M.Waqas Aslam |
| | hello ! Use openfiledialog to open ur required file use rich text box control or textbox control with multi lines , Regards M.Waqas Aslam |
| | Hello ! i m developing a application i want that my notification form will pop up just like messengers , anti virus , and other applications forms pop from right bottom of the screen what can i do for it , i m using this code for it [CODE] Me.Location … |
| | hello! i think u have to post this question in c# forum , well ,if u want if u give the 5th records value and want to show all the records , starting from 5th row , u have to edit ur sql query , check this one [CODE] dim … |
| | |
| | u can do this in this way [CODE] dim myPass as string mypass = "TopSecret" 'now use this in ur if statement , 'now if u want to change the password then place this code on ur replace button mypass = "" mypass = txtReplacePass.text 'now ur pass is changed … |
| | hello ! i think , first populate the grid in a normal way then add a new row at index(o) [CODE] DataGridView1.Rows.Add() 'place this code in the end after populating ur grid [/CODE] hope this will helps u , if ur prob will solved please mark this thread Solved Regards, … |
| | hello !aishapot i think you should take multiple picture boxes, and then databind them with your data source , may b your code look like this [CODE]dim mydataset as new dataset dim myconn as new sqlconnection(___your connection string) dim da as new sqldataadapter(your query,mycon) mydataset.table("MyImages").clear da.fill(mydataset,"myimages") bindingsource1.datasource = mydataset("myimages") picturebox1.databing.add("Image",bindingsource1,"_dbfieldname",true) … |
| | hello , u can do like this , place this code before con.close(); [CODE] datagridview1.column(0).headertext = "StudentID"; datagridview1.column(1).headertext = "Last Name"; [/CODE] Regards M.Waqas Aslam |
| | hi! u want to move textbox from one form to another ? y not u try to get values from textbox of first form to textbox of 2nd form , |
| | hi ! try this code [CODE] datagridview1.rows.clear() [/CODE] it will remove all the rows then assign new data to it Regards Hope this will helps u Regards . M.Waqas Aslam |
| | hi ! set time format custom , hh , and then save like this , datetimepicker.text :) Regards M.Waqas Aslam |
 | Hi ! i think if u use pre defined path for images , then all the images will load at the load event of the form , so there is no use of a progress bar , Regards M.Waqas Aslam |
| | hi ! if u r using sql db to populate ur grid then use this code [CODE] dim mycon as new sqlconnection("ur connection string ") dim ds as new dataset() dim da as new sqldataadapter("select * from table1 where fielddate >=" & datetimepicker_from.value.date & "and fielddate<="&datetimepicker_to.value.date,mycon) ds.table("mytable").clear() da.fill(ds,"mytable") datagridview.datasource = … |
The End.