20,899 Topics
 | |
 | Hello everyone! Am trying to retrieve data from sql server based on two columns. Its a web application being developed using VS2010 (vb.net) but i keep getting the error: incorrect syntax near '=' Here's my code below: [CODE]Sub GetBasicMidwives() ' Set the SelectCommand properties... With objDataAdapter .SelectCommand = New SqlCommand() … |
| | Hi, folks. Need some help to develop a method/function. No problem if there is no code but I would like to start discussing the best way of doing this even in high level language. First of all would like to provide you with some information. The set that I use … |
| | friends i am new in vb.net -i have a webbased proj. What i need is to connect the vb.net app to an sql server via internet. My projects run fine in a standalone pc. what conn. String should i use to finish my proj? tnx for your concern.  |
| | Hi everyone I have a question about vb.net I have a textbox textbox: 145|145 145|859 146|745 and so on .... I want to make my program do this: if I execute the button it must do this: it must take each line of the textbox apart. then split that line …  |
| | I am have been trying to teach myself ASP.NET and Javascript for a project and have been stuck on one problem for literally dozens of hours now. I found a really nice javascript drag-and-drop list online, copied the source offered and split the css into a .css file, the javascript … |
| | Hello! My first post here. I have a problem. I want to make a Windows form that it's exist a button, and if you click that button, then the mouse cursor will move to a choosen X and Y coordinates and after that the cursor will click left or right. … |
| | I'have this litle piece of code which worked nice under windows XP and Windows Vista but won't do a thing under Windows7. I use it to store link adresses to apllications I wish to hoock up to. Basicly I first select a apllication with a "Open File Dialog" and then …  |
 | Hi Some background: I'm trying to create a Server/Client Sync scenario for my application using Sync Services for ADO.NET specifically the LocalCache custom tool which sets the whole thing up for me. My server DB has 5 Tables, all of which are being synchronized to the client application, which now … |
 | I use Visual Basic 2008 I use bound Datagridview I use mysql database If i run this code, everything on the screen ( in the datagridview) [COLOR="Green"]neatly Updated[/COLOR]. But when I look at records in the table [COLOR="Green"]"stock"[/COLOR] always the first row (0) of the DataGridView [COLOR="red"]not updated [/COLOR]in the … |
| | how to load content of panel to a another panel?? |
| | how i can check any text string in a doc file.the searchinh should be fast as i have to do other code if it found the string |
| | Hi, look into codes below: [CODE] Sub Main() Dim tmr As New Timers.Timer tmr.Interval = TimeSpan.FromMinutes(5).TotalMilliseconds tmr.Start() 'Do function End Sub [/CODE] As my program above, i set the time interval to every 5 minute which it will do the function. However, after 5 minites it does not affect any … |
| | i want to detect if listview has been updated eg: there are listview1,listview2 and a button1 .u can send items to listview2 from listview1 .if the listview2 has an item button1 will enable if the listview2 is empty button1 will disable what is the suitable event for this?? (there is … |
| | I am replacing an AutoHotkey script with a VB.net application. Part of the script involves sending keystrokes to an active application. VB uses SendInput and does send the keystrokes, but the application doesn't "get" them, but when AutoHotkey sends the same key to the same application, it works. I have …  |
 | Hey guys, As you can see below I am trying to add row of data to a table called tblOut. When i execute the code, it works without a single error message but the problem is I dont see any new record when i preview my table data. Can anyone … |
| | Hello everyone! Please am developing a web application using vb.net with visual studio 2010 and .NET framework 4.0. its complete but i want it accessible over the network (LAN) so i have tried to host it on the local server (IIS) but i keep getting the following error message from … |
| | I am working with application for Excel sheets in vb.net My database is Sql server 2005 I am having around 8 lakhs of rows in my database and 64 columns. when I import a excel sheet for searching the Duplicate of excel sheet rows in database i get this Error … |
| | Hi, How to write into excel sheet using oledb connection or how to export dataset into excel sheet using oledb connection. Iam using console application in vb.net. If there are any alternate ways to write into the excel files from dataset. |
| | Hi, I am trying to create comm dll. In which i am reading the contents of the excel and have to return it either as dataset or dictionary object or 2-dimensional array strings. The same dll we are using in javascripts. Here, When i return dataset or dictionary object in … |
| | Anyone knows how to change the Forms and controls of the project as the Screen resolution of the computer changes? please teach me or give me a tutorial. thank you  |
| | I'm new to VB.net and am looking for some advice. To start with I need to develop something that I can import 3 different csv files into and then once I've created a query then return my results in a datagrid view. I'm not sure where to start with how … |
| | I am getting this error when i try to connect to the server... Hot to rectify it... "This version of Microsoft SQL server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg) |
| | I am Importing a Excelsheet(xls) in to my Application, but the date and Number column showing blank in dataset when comes to application. the values are there in Excel. what must be the problem Any other way to import the excel sheet to application, so that i should get all … |
| | Hi. I have a datagridview on a form that displays values generated in a for loop when a user presses a button. Here's the code. [CODE] Dim i as Integer Dim Period as double Dim rate as double Dim interest as Double Dim amount as double Dim payments as Double … |
| | Hi all, i'm a student. My Final Year Project supervisor want me to develop a software for wholesale industry, and he want the software can update the data from time to time Example: A company having 2 Branch in B and C place While B place made a sale! the … |
| | Dear All, I am new to VB2010 and writing a MDI child form to open another form as dialogbox, then pass a value back to the MDI child form, the value is successfully passed back to the MDI child form but it can't be shown on a text box, my … |
| | hello when i try to add new data source aftre selecting the table & befor finishing i got the message An error occured while creating the new data source An error occured while generating the data source and in error window following error does come Custom tool error: Failed to …  |
| | Hey guys, I was wondering if there is a way to group controls together without using any containers such as panel, group box, or container. Thanks  |
| | Attached is a visual representation of My Array that was used in my VB6 program the dimensions are: [CODE]Dim MyArray(5,30) Option Base 1[/CODE] I am using an ACCESS DataBase to populate the array. Using the For Next Loop I can access any position within the array such as a individual … |
| | i have a page which dynanically create a link when it load, after i click on the link it should loop in the database fetch all the record and display another set of link , then when i click on these link it should give me all information about this … |
| | Hi Everyone, I'm having a hard time on using Transaction then after that I need to use sqldataadapter. When I tried the code below I'm having an error "[COLOR="Red"]ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The … |
| | Hi I have been looking all day trying to find a way to do this. I need to run a Batch file which is held on a server, the file path begins with a IP Address which DOS doesn't like. So i found the pushd command which assigns a temp … |
| | hi all, please help me on this... Is there a way to get the SQl View's String Command used to create said View? For Example, I have a View named tryView, now I want to get the string command used to create tryView like this one... [QUOTE] CREATE VIEW tryView … |
| | I'm using the following code to send an email: [CODE] Dim SendMessage As New Net.Mail.SmtpClient Dim userToken As New Object Dim EmailMessage As New MailMessage With EmailMessage .From = New MailAddress("username@gmail.com") .To.Add("username@xxx.com") .Subject = "Test" .Body = "test" End With AddHandler SendMessage.SendCompleted, AddressOf sendMail_SendCompleted With SendMessage .Host = "smtp.gmail.com" .Port … |
| | HI , i have a little problemn. I have to tables codMP and Content.Display like this. codMP name In 1 x ? - 20 - here i want to sum the column from the second table where codMP = with what is in the column codMP. The same for the … |
| | General Codes [INDENT]this code which go back [CODE]WebBrowser1.GoBack() 'Go back[/CODE] this code which go forward [CODE]WebBrowser1.GoForward() 'Go Forward[/CODE] this code which stops web browser [CODE]WebBrowser1.Stop() 'stop loading current page[/CODE] this code which refresh current web browser [CODE]WebBrowser1.Refresh() 'refresh current web browser[/CODE] this code which go to home page for current … |
| | Hello everyone, I am current upgrading some of the functions on an inventory system. Current system accepts manual data input from the user and stores them in a SQL database. One of the inputs is control number which is a primary key in one of our table so it needs … |
| | This code will show find dialog in web browser here is the code [CODE] Dim data As DataObject = Clipboard.GetDataObject 'get current clipboard Me.WebBrowser1.Document.ExecCommand("Copy", False, Nothing) WebBrowser1.Select() SendKeys.SendWait("^f") Clipboard.SetDataObject(data) 'load previous clipboard back [/CODE] |
| | Hi everyone! I need help on "How to import or put Microsoft 3d Movie maker in VB 2008?" I have searched in internet but got none.. I also tried to but I don't get it. I will really appreciate correct answer for my question, Thank you. |
| | Anyone can help my problem? I ask a favor on how to network vb.net with ado.net in access database. Thanks. |
| | Function to Convert Dataset to Excel. It will export all the table of the given dataset to the given excel. Example: [CODE]ExportDatasetToExcel(dsFinal, "d:\\my.xls") [/CODE] where dsFinal is my Datase and second parameter is the excel file location. Make sure the excel file exist. |
| | hello and good morning i have a problem regarding about the image. i want to make the image become blur . i have attach some image for the refer of the image. also, i have problem about how to clear the listbox. i mean not like this [CODE]listbox1.item.clear()[/CODE] it have … |
| | Hello! I need to create a system that will not calculate weekends and holiday. Can somebody help me? Thanks in advance. |
| | Hi, I am exploring a timer function which I wants my program function runs every 10 minit interval. Below is my coding: [CODE] Dim timer As Timer timer = New Timer(600000) 'timer.Enabled = True timer.Interval = 600000 timer.Start() 'Do function timer.Stop() [/CODE] Actually I am not familiar with timer function, … |
| | I was wondering if anyone knew of a more efficient way to run this? I feel that there has to be a more efficient way. Thanks [CODE] Dim doc As New XmlDocument Dim nodes As XmlNodeList Dim nodes1 As XmlNodeList Dim nodes2 As XmlNodeList Dim nodes3 As XmlNodeList Dim nodes4 … |
| | i have two dbf that should write in excel file,,ive already done writing on the first table my problem is how can i join the other table from the other but theyre not going to combine,,first table id in the upper part and the second table is in lower part,, |
| | Good day, I have a ReportViewer showing a report that is bound to a dataset. The dataset gets its data from a Access database backend. I have a separate form that allows the user to add/update/delete data. My problem is when the user makes changes to the data using the … |
| | Im currently working on a project to build an application for Windows Mobile 6. Im just stuck with this stupid issue: I have a SQL query string: Dim connectionString2 As String = "Data source = " + path + "\HC.sdf" Dim cmdText2 = "SELECT * FROM BigC_Rangsit_0_" I want to … |
| | I wrote a text editor, and what I want to do is opening other text files with it. I can already open it from program, but I want to be able to drag&drop the files on the form and more importantly, right click on a file and use "open with..." … |
| | Hi Guys, I Need to create a COM DLL and Register it using RegServer.Exe. After that I want to use that Control in any Scripting language like JavaScript, VBScript etc.. vis CreateObject and want to use the functions.. I want to create a dll like oleDB.dll or office components like … |
The End.