568 Posted Topics
Re: I think HTML5 is not compatible with the version of IE you are using. Please do mention the version you are using. Do you need any help regarding Button rotation and smiling face ? | |
Re: You can also use mssql server data import functionality. you can simply map your csv file columns with your table columns . Regards | |
Re: use scope identification in MSSql server. Google it | |
Hello ! I have a remote control aricraft toy. I want to control it from my pc. I do not know where to start. Is there anyone who did this before or did any project dealing with hardware programming ? Regards | |
Re: are you getting any error while connecting to your server ? if yes please post it here. | |
Re: try this select * from tbl where DateOfBirth >= addDate(day,-1,getdate()) and DateOfBirth <= getdate() you can also use between clause in where condition. Hope this will give you any idea. Regards | |
Re: hye ! what I understand from your question is that you have comboA and comboB and when you select the comboA then records of comboB will filter ? am i right ? . Try to do something like this . //Let suppose we have two comboboxes , 1- cmbSelector 2-cmbFilter … | |
Re: hye ! hope this code helps you dim con as new sqlconnection("connection string") con.open() dim da as new sqldataadapter("select username ,password from table",con) da.fill(dt) cboUser.datasource = dt cboUser.Displaymember = "username" cboUser.Valuemember = "password" con.close() ' now we have two textboxes , txtUsername and txtPassword. and we want to set there … | |
Re: do somthing like this select * from table where id in (@id) and username(@firstname) | |
Re: May be this one help you `select * from tbl where myDate between dateadd(day,1,dateadd(month,-1, myDate)) and myDate` Regards | |
Re: try this dim con as new sqlconnection("connection string") con.open() dim da as new sqldataadapter("select userId , userName from users",con) dim dt as new datatable da.fill(dt) comboBox.datasource= dt; with combobox .displaymember="userName" .valuemember="userId" end with con.close() Hope this will help you | |
Re: hello! check this code may be this helps you [CODE] Dim con As New OleDbConnection("Connection String") Dim cmd As OleDbCommand = New OleDbCommand("select * from table1 where StaffID='"&txtStaffID.text&"'", con) con.Open() Dim myDA As OleDbDataAdapter = New OleDbDataAdapter(cmd) Dim myDataSet As DataSet = New DataSet() myDA.Fill(myDataSet, "MyTable") dgvTableList.DataSource = myDataSet.Tables("MyTable").DefaultView con.Close() … | |
Re: try to move toword automation by using RFID tags , singles , cards etc , and yes you can also work in some advance database applications , like ERP solutions , University student management system , etc . Regards | |
Dear All ! I need to convert date 2013/09/15 to this format Sun, Sep 15, 2013 . any type of suggestion would be greatly appreciated. Regards | |
Re: first the datatype of your field is bit , then use above mentioned code to save the value of your radio button. [CODE] radiobutton1.checked [/CODE] regards | |
Dear All! I have an ASP.net page , and my page is supportted in two language , english and arabic . when user click on arabic , i want to make my all text right align. Regards | |
Re: i think u try this code on the text change event of the textbox1 and on the form load event also , [CODE] Sub MySaleInvoiceList() On Error Resume Next Dim myQuery As String 'defining a string If textbox1.Text <> "" Then 'here i m chking that is user try to … | |
Re: could please provide error message text. | |
Re: i found this query to create the backup of the system BACKUP DATABASE [D:\testing.mdf] TO disk = 'C:\PathToBackup\BackupFileName.bak' | |
Re: try to do somthing like this , after adding all records normally to your datatable , add column like this , myDatatable.column.add("your columnname") | |
Re: use this connection string to get your application connected with excel file Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx; Extended Properties="Excel 12.0 Xml;HDR=YES"; and then just use query like this select * from [$sheet1] Regards | |
Re: for integer datatype , you have to conver your values into integer first , like this Dim myindex As Integer myindex = val(DataGridView1.CurrentRow.Index) Regards | |
Re: It is very simple , just get the file path , open it , and read all the text and then save it to your database. here are some links, helps you to understand the method of reading textfiles using vb.net . [Click Here](http://support.microsoft.com/kb/302309) and [Click Here](http://msdn.microsoft.com/en-us/library/db5x7c0d.aspx?cs-save-lang=1&cs-lang=vb#code-snippet-1) Hope this will … | |
Re: i think you can not change color of the text in dgv . because there is no css involves init , we could easily make graphical changes in webforms ,but i am afraid that it is not possible in desktop applications. May be there are some thired party tools available … | |
Re: if you are getting these records from db then you can just use Count() to get total number of records , here is a sample query from mssql select name , count(*) from table1 group by name Regards | |
Re: please be more specific , i think you could use need datasource event of telerik report. and get selected record of the grid there and then assign values to your report textbox. like this ' do something like this in need datasource event of the report. 'i am taking two … | |
Re: May be when someone delete record ,instead of deleting records code is setting any flag in the table. to get the clue , you could check the code which is retriving records from the db. there may be any filter criteria. Regards | |
Re: if you are using mssql then use this query select field1 , field2 from table1 where table1.DateField = getdate() Regards. | |
Hello All ! I want to make my gridview pagination look like this First -prev -- 1 -2 -3 -4 -Next -Last How can i do this , by using options of Mode it is not possible. Best Regards | |
Re: try something like this string[] strValues = txtHtmlTextBox.Text.Split(','); for(int i =0 ; i<= strValues.Length-1;i++) { //assign values to your textboxes like this //txtDemo.Text=strValues[i]; } Regards | |
Re: 1- New Project -- other project types -- setup and development -- visual studio installer -- setup project--- Ok There will be three folders on your left , application folder user desktop , user programs menu right click on this panel Add special folder option will appear , select option … | |
| |
Re: i think if your column datatype is not supported to 20's , if you are using mssql server then nvarchar datatype may help . Regards | |
Re: you want to use conditions in your db quries ? please be for specific regarding your desired result. Regards | |
Re: use session instead of query string. as it is good for security of your site. | |
| |
Dear All ! I have a table member_email. i have 4 columns in it. Id Email CellNumber Carrier I want to create constraint who check following conditions, 1-Email can be null if Cellnumber is given , and Cellnumber can be null if email is given. 2-both email and cell number … | |
Re: well if you want to create setup then you can simply do this , create a new project , name setup and development , when project will open , you will find three options on your left side. one will be application folder , select this option and then right … | |
Re: simple use datareader object to perform this operation , here is a sample code. dim con = new sqlconnnection("connection string") con.open() dim cmd = new sqlcommand("select a ,b ,c ,d from table1 where id = " & txtId.text,con) dim da = sqldatareader() da = cmd.executereader() while da.read() txtA.text=da["a"].Tostring() txtb.text=da["b"].Tostring() txtc.text=da["c"].Tostring() … | |
Re: can you please mention which error you are getting in this above mentioned code. | |
Re: Read it [Click Here](http://msdn.microsoft.com/en-us/library/12a7a7h3(v=vs.71).aspx) | |
Re: select Distinct t.Student ,(Select count(scores) from table where student = t.Student) From Table t where credit > 2 and credit > 10 may be this will help you . Regards | |
Re: this error came when your database field size is smaller then your data. Regards | |
Re: use anchor. it will do same as your requirement. Regards | |
Re: 1-you did not define dataadapter2 . 2-and you are fill dataset1 and same table with it. First assign query and connection to dataadapter2 then fill dataset1 with it. Regards | |
Hello ! I want to develope a website downloader . which can download entire website on my local drive. i manage to download html code of any page and then save it as .html . but this is not good. can anyone give me any idea to complete my task. … | |
Hello ! hope all of you are fine , i want to know how can i add fb api to my website , i find lots of code on different websites to grab profile picture of any given account , but i haven't find anything regarding adding api link to … | |
Re: you can decompile the application, hope you find a way . :P Regards | |
Re: i think you have to make getter and setter functions for specific textbox and then use them to get and set values . i think there is a property of modifier , it is private bydefault change it to public try it. | |
Re: i think in a desktop application it is not possible , because you cannot have anything life css of any object . but yes for web applications. |
The End.