568 Posted Topics
hello ! i want to disable my usb port using c# or vb.net ,is it possible to do so using .net ? if yes then any idea how i can do this ? Regards | |
Re: use this ddl_Course.DisplayField = "course_name"; ddl_Course.ValueField = "course_id"; | |
Re: tola = grams/12.5 masha = (grams/12.5)/12 or tola/12 ratti = ((grams/12.5)/12)/8 or masha/8 | |
Re: i dont know , in which database your are working , here is a query you can use for mssql server. hope this will help you Select p.EmpNumber,p.ss,q1.wages,q2.wages From Personel p left outer join q1 on p.personelid = q1.personelid left outer join q2 on p.personelid = q2.personelid Regards | |
Re: Please post your complete code , | |
Re: there are many ways to do so , 1-If your application has database then store time and date of first run of your application and then check remaining days on load time. 2-If your application has no database then you can store installed date and time in registry of windows. … | |
Re: i think you should configure your sql server before .click on start --> microsoft sql server 2005 --> configuration tools --> sql server surface area configuration ---> surface area configuration for services and connections --> select remote connection option from the list on left side. then enable local connections and … | |
Re: try something like this reportViewer1.report= new myReport(); This code works for telerik reports. hope this will help you Regards | |
Re: i never used rdlc . but normally there are two methods to show data in report. 1- use wizard .2- set datasource to your report and map your fields with columns of datasource. | |
Re: no one will give you complete code . try to make it by your self. then in case of any issue post your query here. people of daniweb are not here to provide complete solutions. Regards | |
Re: as guru iyer said try to call the grdLoad method on the combobox selected index changed event and add connection to the sqldataadapter like this SqlDataAdapter sqlDataAdap = new SqlDataAdapter(sqlCmd,con); Regards | |
Re: hello ! use this code to open another form , on the click event [CODE] formEventRegistration.show () [/CODE] Regards | |
Re: Please visit this link hope you find solution of your prob [Click Here](http://www.codeproject.com/Articles/11142/Generate-a-Random-String-Key-in-VB-NET) Regards | |
Re: you want to make log of specific applications or every thing user do ?. Please be more specific | |
Re: try this int id ; sqlconnection con = new sqlconnection("your connection string"); sqlcommand cmd = new sqlcommand(); con.Open(); cmd.Connection = con; cmd.CommandText = "select isnull(max(loading_record)) + 1 from testing "; sqldatareader dr = cmd.executereader(); while(dr.read()) { id = convert.toInt16( dr["loading_record"].toString()); } string ID = "PA-"+DateTime.Now.Day+"-"+DateTime.Now.Month+"-"+DateTime.Now.Year+"-"+id; dr.close() con.close i typed this … | |
Re: i cant get your point ,i think you want to delete the selected record from the grid and also from db. you can do this on button click event after selecting your row from grid. dim con as new sqlconnection("your connection string") con.open() dim cmd as new sqlcommand() cmd.connection=con cmd.commandtext="delete … | |
Re: if there is any control on form2 , you can just set focus to that control on the load event of your form 2. like me.comboBox1.focus() Hope this helps you. | |
Re: dear ninjastormns you can just change the following value Txtrandom.Text = Gen.Next(1, 101).ToString to Txtrandom.Text = Gen.Next(1, 100).ToString it will generates from 1 to 100. Regards | |
Re: Hello ! If you are using windows form application and want to show the records from database to your from you can do like this .First add a textbox name txtSearch and then a button name btnSearch and a gridview name dgvSearch . now use this code. sqlConnection cn = … | |
Re: as tinstaafl said object reference is not set to an instance may occur if you create any instance with out new keyword. but this error normally comes when we get null value and assign it to some variable ,object etc. It is always better to convert null into empty string. … | |
Re: hello ! you can simple disable the datetimepicker like this Me.dateTimePicker1.Enabled = false Regards | |
Re: please check these links , hope you will find something usefull in them [Click Here](http://www.codeproject.com/Articles/9196/Links-with-arbitrary-text-in-a-RichTextBox) in my point of view you have to format part of the string here are some links please check them out [Click Here](http://vbcity.com/forums/t/143833.aspx) [Click Here](http://www.startvbdotnet.com/controls/rtb.aspx) [Click Here](http://stackoverflow.com/questions/109032/vb-net-richtextbox-apply-formatting-to-sele) Regards | |
Re: first install sql server management studio , then make sure server computer is connect with your computer , then give that server name like server/sqlexpress , then connect it , | |
Re: in case if you have to use lots of images then reduce the size and resolution of images . then set the strech property of your image. Regards | |
Dear All! I want to get my columns value into rows . i am taking sum of qty of each month . like this select sum(Case when month(invoicedate) = 1 then qty else 0 end) as janQty, sum(Case when month(invoicedate) = 1 then qty else 0 end) as febQty, sum(Case … | |
Re: hello ! i think there is prob with your query , you are using this one INSERT INTO Sensor Table (Equipment ID, Location, Supervisor, Alarm Start, Alarm Stop) Values (@Id, @Loc, @Sup, @Astr, @Asto) in above mentioned query if your table name is sensor then remove word table after sensor … | |
Re: for vs2008 win xp or 7 , and for vs2010 win 7 , just install vs your mssql server will auto installed with that setup , in case of vs2008 mssql 2005 will installed and in case of vs2010 mssql server 2008 will be installed. after installation you just have … | |
Re: you can use three datatables for this , get required records for each datatable and then assign them to your grids. | |
Re: well it is better to clear datagrid view DataGridView.Rows.Clear() Regards | |
Re: hello ! u have to import ur data from excel to access then u can put all ur data in dataset for populating ur grid then save it in MSSQL , but first u have to import ur excel data in access Regards M.Waqas Aslam | |
Re: Hello nore ! you can do like this , just take a bindingsource and use this coding [CODE] Sub MyGridData() dim mycon as new sqlConnection("your conn string") dim myDataTable as new DataTable myconn.open() Dim myDataAdapter as new SqlDataAdapter("your query ", mycon) myDataTable.table("MyTable").clear MyDataAdapter.fill(myDataTable,"MyTable") BindingSource1.datasource = myDataTable.table("MyTable") GataGridView.DataSource = bindingsource1 EndSub … | |
Re: ok lets assume if we have two textboxes , txt1 and txt2 , i want to get control on txt2 if i press enter and also got control txt1 if i press enter in txt2 , use this code [CODE] '---use this code at the keypress event of the control … | |
Re: i second you sir ancient dragon. vb.net is not able to make your own operating system but if you are very good in assembly and C then you can make a try . here is a book having detailed information about 32 bit operating system [Click Here](http://www.amazon.co.uk/Developing-Your-32-bit-Operating-System/dp/0672306557/ref=sr_1_1?ie=UTF8&s=books&qid=1215589290&sr=8-1) Regards | |
Re: what do mean by file , do you want to open text file ? or want to execute any application's exe file? . Regards | |
Re: here is a link , hope this will help you [Click Here](http://www.dreamincode.net/forums/topic/44150-printing-in-vbnet/) Regards | |
Re: dataadapter get all data and put it in dataset at once ,but datareader get data line by line . so what i think dataadapter is faster then datareader. one more thing in datareader data is only readonly . here is a link please visit it for more information [Click Here](http://social.msdn.microsoft.com/Forums/nl/csharplanguage/thread/93f9f5a7-cb04-4963-8e32-60359add8036) … | |
Re: try something like this, combobox.selectedValue= form1.gridview1.item(1,2).value.toString | |
Re: yes you can do same by using datetime picker .try something like this, 'here is a code to show the data in grid dim con as new sqlconnection("your connection string") dim strQuery as string strQuery = "select * from table1 where 1=1 " 'here is a code to add from … | |
Re: to insert record you can do this dim con as new sqlconnection("connection string") dim cmd as new sqlcommand() con.open() cmd.connection = con cmd.commandtext="insert into table1 (field1,field2) values(@field1,@field2)" cmd.parameter.addwithvalue("@field1",txtfield1.text) cmd.parameter.addwithvalue("@field2",txtfield2.text) cmd.executenonquery() con.close() Regards | |
Re: can you please repharse your question i dont get you , well what i understand is that you want to filter your datagrid by selecting values from 2nd form ? Regards | |
Re: well if you want to run you application at the startup of windows then you can simply do this , when you make setup of your application in vs , you have 3 items on your left , 1-application folder 2-user desktop 3-i dont remember right now:P on this list … | |
Re: what i understand is that you have two forms , having datagrid , when you click datagrid1 on form one or select any customer form the grid then the second grid will populate with all related data of selected customer , if yes then you can do like this . … | |
Re: well , you can do by saving all your data in a text file , and read that file at the load event , and simply fill your controls with that data. Regards | |
Re: can you please explain little bit , ?what you want to do ? may be we can give to better solution . Regards | |
Re: dont use this Trim(newQE_Date.ToString("MM-dd-yyyy HH:mm:ss")), just get value and insert it . Regards | |
Re: what do you mean by sliding forms ? do you want to move your form from one location to another or you want to change your forms size (width and height) ? Regards | |
Re: post your code which is not working regards | |
Re: how you are accessing the textbox in another form ? |
The End.