20,284 Topics

Member Avatar for
Member Avatar for leo88

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 " …

Member Avatar for sandeepparekh9
0
123
Member Avatar for moone009

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 …

Member Avatar for NETProgrammer
0
2K
Member Avatar for whin_lopez

Hi please help me with this problem i really need it those kind hearted programmers out there please help me :) thanks

Member Avatar for longstrd
0
3K
Member Avatar for saj_amo

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 …

Member Avatar for chriswelborn
0
856
Member Avatar for chriswelborn

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 …

0
216
Member Avatar for rak4u

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

Member Avatar for azimuth01
0
892
Member Avatar for deva.v

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 …

Member Avatar for deva.v
0
762
Member Avatar for Silvia Todor

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 …

Member Avatar for Olias2k11
0
75
Member Avatar for leo88

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 …

Member Avatar for leo88
0
290
Member Avatar for ritesh2190

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 …

Member Avatar for sandeepparekh9
0
158
Member Avatar for deva.v

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 …

Member Avatar for sandeepparekh9
0
902
Member Avatar for ZER09

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 …

Member Avatar for ZER09
0
4K
Member Avatar for Piotr__11

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&ltmpl=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&ltmpl=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 …

Member Avatar for NETProgrammer
0
186
Member Avatar for Pgmer

Hi All, Can anyone throw idea to make the form as Resolution Independent? Thanks..

Member Avatar for sandeepparekh9
0
146
Member Avatar for bettybarnes

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 …

Member Avatar for NETProgrammer
0
261
Member Avatar for vishalrane

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 …

Member Avatar for sandeepparekh9
0
1K
Member Avatar for taxmybrain

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 …

Member Avatar for sandeepparekh9
0
197
Member Avatar for mike888

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 …

Member Avatar for Unhnd_Exception
-1
369
Member Avatar for imarc

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 …

Member Avatar for imarc
-1
182
Member Avatar for moone009

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 …

Member Avatar for Unhnd_Exception
0
95
Member Avatar for vishalrane

[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 …

Member Avatar for debasisdas
0
110
Member Avatar for kitjo

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?

Member Avatar for Pgmer
0
163
Member Avatar for jayawant.sawant

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 …

Member Avatar for slaith
0
235
Member Avatar for jugnu

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 …

0
68
Member Avatar for cmis

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 …

Member Avatar for slaith
0
169
Member Avatar for Bheeman89

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 …

Member Avatar for twiss
0
184
Member Avatar for kazekagerandy

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 …

Member Avatar for Jeff-Bennett
0
417
Member Avatar for jonkeeler

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 …

Member Avatar for Unhnd_Exception
0
511
Member Avatar for gspeedtech

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) …

Member Avatar for gspeedtech
0
187
Member Avatar for tranand3

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

0
44

The End.