20,284 Topics
| |
Hi, I am doing a window servise application using VB.net. I have faced problems with sql suery, as below: [CODE] Dim dt As New DataTable() SQLStr = "SELECT FautyScanTbl.Model, FautyScanTbl.Version, FautyScanTbl.WIP, FautyScanTbl.ScanNo, FautyScanTbl.LotSize, FautyScanTbl.SerialNo, FautyScanTbl.PIC," & _ "SerialNoTbl.SetWeight, SerialNoTbl.AccesWeight, SerialNoTbl.pdmid, ScannedPartNoTbl.ScannedTime " & _ "FROM FautyScanTbl LEFT OUTER JOIN " … | |
I have a list box where the user can add choices depending on what items they want active in the database but I cannot figure out how loop through this listbox to update the items. Any ideas? Visual Studio 2010 [CODE] Dim lstitem As String For i = 1 To … | |
Hi please help me with this problem i really need it those kind hearted programmers out there please help me :) thanks | |
Hi Guys, I have little problem to open any url link from my application i have placed a textbox and a button on the screen. what i want is any url which i write in the textbox and when i press the button automatically that url would open in the … | |
I was looking for a piece of code to show all users logged on to my system. What I mean by that is: only 1 person is ever truly logged in at my house, but there are sometimes other users "logged in" with programs running under their account. This is … | |
Hi i am using .net 2.0 & a window application which is connected to sql server there is checkbox in the application. i want to bind the checkbox with database field which is bit type 1 or 0 please tell how to ? thanks in advance | |
Hi I would like to get the connection string for both 2003 excel (*.xls) and 2007 excel (*.xlsx). I want to read both files depends upon the selection. When I was using this code [CODE] Dim cn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & a_sFilepath & ";Extended Properties= Excel 8.0;HDR=YES;") [/CODE] I … | |
I am currently using microsoft access 2007 and vb.net 2008. The problem senario is this: I have a database-table that contains two columns, items, and the price of each item. I tried to drag this table to the form as a checkbox tool, but only one checkbox1 was diplayed. The … | |
hi, I am from c# field and now are doing a project using VB, I wants to ask about question as below: 1) private static DataSet ds; I wants to convert the C# codes above to VB syntax, but VB seems like don't have equivalent keywords of "static"(Correct me if … | |
i am writing a vb.net program which gets a c program as an input and checks it for errors,now i want my program to skip the comments in the c program,i have written some code but its not working pls tell me where i have gone wrong,or if u have … | |
Hi, I am creating a text file using a save file dialog and copying the path to the text box which file is used to write from vb.net. when i try to write i get an error "The process cannot access the file '....fileName.txt' because it is being used by … | |
can anyone can help how to create a live search in vb.net 2008 using combo box. example when i try to search a name then a press a then there should be a drop-down with a list of suggestions of name. here is my code [CODE] Private Sub ComboBox4_SelectedIndexChanged(ByVal sender … | |
Hi. I need to fill some field on webpage in my webbrowser . This field has not got ID and I can not use [CODE]WB1.Document.getelementbyid("dsdsfsda").innertext = "dsd"[/CODE] Specyfically I need to fill "E-mail" field like at Google Adword registration : [URL="https://www.google.com/accounts/ServiceLogin?service=adwords&hl=pl-PL<mpl=signup&passive=false&ifr=false&alwf=true&continue=https://adwords.google.com/um/SignupToken&app=Signup&sourceid=awo&subid=emea-pl-ha-bk_awo&medium=ha"]https://www.google.com/accounts/ServiceLogin?service=adwords&hl=pl-PL<mpl=signup&passive=false&ifr=false&alwf=true&continue=https://adwords.google.com/um/SignupToken&app=Signup&sourceid=awo&subid=emea-pl-ha-bk_awo&medium=ha [/URL] Can you help me with this ? I … | |
Hi All, Can anyone throw idea to make the form as Resolution Independent? Thanks.. | |
hi guys i know this is just a very simple but i do not know to get started.. im developing a loan mng't system wherein the starting application of the customer say for example today. 06/08/2011, the initial payment will be on 08/08/2011.. how am i going to that do … | |
is it possible to call form load event on button click Following is the vb code i want same function in vb.net [CODE] Private Sub cmdaddcancel_Click() Form_Load End Sub[/CODE] Private Sub cmdaddcancel_Click() Form_Load End Sub in vb we simply call Form_Load is it possible in vb.net For eg: IN VB.net … | |
Hope someone can help [B]I am using Visual Studio 10 Languague VB [/B] It is web based and conects to remote SQL Server If i run a query on database connecting using Sql Server management studio this query give correct results which is to find minimum value in a column … | |
Hello, I am new i vb .I need to . Each asterisk represents $100 in sales by using for next loop. also i have a problem i do not want it to go next store until the data in the first store is correct, and so on the problem say … | |
Alright, so I got a very unique issue. It combines a little bit of SQL, VB.net Skill, and patience. The program I am trying to make needs to be structured like this. Table 1: Estimates (Details View) Customer ID Employee ID Form Factor Problem Proposed Solution Estimate Acceptance (Boolean) Table … | |
Can someone please tell me why the results of my query are not appearing in my console application? I have a feeling it is something wrong with the console.writeline or readline [CODE]Imports System.Data Imports System.Data.SqlClient Module Module1 Private Property Sql As String Sub Main() Dim ConnString As String = "Data … | |
[CODE]Private Sub frmCust_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load dbSource = "Data Source=xx-B4C521B850\SQLEXPRESS;Initial Catalog=TT;Integrated Security=True" con.ConnectionString = dbSource con.Open() da.Dispose() sql = "Select * from Cust" da = New SqlClient.SqlDataAdapter(sql, con) da.Fill(ds, "Cust") da.Update(ds, "Cust") con.Close() MaxRows = ds.Tables("Cust").Rows.Count inc = -1 End Sub [/CODE] if after … | |
i published my projects but it seems when i install the published setup, the application does not fetch data from the database yet the database is included in the published application. could anyone help me with this exception? | |
Hi, In windows form in button click event how to export the file in a location select by showdialog & it will be delete permanently at a same time.How can i do this! because in .net it will produces error "IO Exception was unhandled" or "The process can not access … | |
Hello I m using ComponentOne C1 Flexgrid in my project. Scenario is i have an Order Detail Table and an Order Delivery Table. when form loads grid show three rows with a checkbox in its 1st column. what i want to know is the logic i need to use is … | |
Hi All I am working on a grid view where I have an acitve column which has radio button, user can select either yes or no for the active column. depending on the selection I am able to update the database. I am using the code below to get the … | |
Dear Friends, I have a question in security programming. As all of us know, when we have a database with passwords or anything sensitive, we would like to encrypt it so it is not readable by other. Now I want to know, which of the method is secured or less … | |
how can i crop an image based on the size of my picturebox? my picturebox's size mode is normal, i want to have for example, a 100 x 100 image using a 100 x 100 picture box, also i can drag the the image inside the picturebox so that i … | |
Hi this is my first post so hello everybody, I've recently been exploring the uses of linq to use for comparisons,but really need a bit of a kickstart. Say for instance i have a listview populated with numbered names and I want to put up a message box if certain … | |
I am working with existing VB.NET code for a Windows Application that uses StreamWriter and Serializer to output an XML document of transaction data. Code below. [COLOR="Green"] [CODE]Private TransactionFile As ProjectSchema.TransactionFile Dim Serializer As New Xml.Serialization.XmlSerializer(GetType(ProjectSchema.TransactionFile)) Dim Writer As TextWriter Dim FilePath As String Writer = New StreamWriter(FilePath) Serializer.Serialize(Writer, TransactionFile) … | |
I have a textbox in a form and when I save the textbox content goes to an xml file called settings.xml.I was able to achieve that.When I open the form again ,the textbox should be loaded with the content from the xml file again.How do I achieve that |
The End.