I'm trying to update some data fields in an existing data table, and want to access the data directly. I know it's possible, and I used to do it years ago in VBA, where you could do things like
[Code]...
I want to use dataset for sql server for adding/modifying/deleting data from sql server.
View 8 Repliesi'm tying to send email in my application directly by the smtp server but the server doesn't allow me to do that.The application its used by everyone in the company, so i set the smtp client UseDefaultCredentials to True, but the server replies with this when i try to send an email:[code].....If i set the credentials by hand, the server sends the email. So my problem is how to make this work to everyone? I don't want to have one public/friend var all time in the application with the credentials of the current user?
View 9 RepliesI want to collect all stocks information within 2009 & 2010. I stored the required parameters (YMD & stock code) in DB. Is it possible to write a VB.Net windows application to pass all required parameters (post method) to web server and retrieve the web response automatically? (1 - 5 are valid stock code) It is
View 2 RepliesI have written a VB.NET 2008 application, incorporating Microsoft.Office.Interop.Excel, that modifies an existing Excel 2007 spreadsheet. It works perfectly on my WinXP development computer.When I upload the app to a Microsoft Web Server 2008, it opens the file and reads from the file, but when the app tries to save the file, it throws this exception:"System.Runtime.InteropServices.COMException (0x800A03EC): 'july2009.xlsx' is read-only. To save a copy, click OK, then give the workbook a new name in the Save As dialog box."The file is NOT read-only, nor is it opened by any other user or app.The app and the Excel file both reside on the D: (data-only) drive.My first instinct was to look at file permissions. When nothing else worked, I literally created a temporary Group, added EVERY user and security entity to it and granted the group full control of the entire D: drive. No luck.
Then I tried manually elevating the permission by running my app as administrator. No luck.Finally, I copied the file to my XP development computer and ran the app there. Of course it worked perfectly.Can anyone please tell me how to give my program permission to edit a file on Server 2008?
How can I configure my connection that directly my data save into server. I am using databinding approach, like this me.tblnameTableAdapter.Fill (me. DbnameDataSet.tblname). It is possible to stored data into server just like ADO.Net?
View 3 RepliesI was wondering, if there is a way to use httpwebrequest post method to send data to a PHP function directly (no forms, or whatever)
so for example, i have this PHP function, which writes to a file:
<?php
$File = "textfile.txt";
$Handle = fopen($File, 'a');
[Code]....
Now, i have a form which would usually post the text which should be writen, so, can this be done directly, without that form, using httpwebrequest in VB?
since upgrading from 2008 to 2010 i have seen an issue where i pause my vb.net project,modify some code, resume, but the app does not execute the new code, it continues as if nohthing was changedery strange, very frustrating
for example
msgbox("1")
if i pause my app and change this to
[code].....
I'm testing the code below from another author, which works well for reading in the data. Despite this, once the data is populated I also need the DataGrid to be able to accept and delete data too. Is it possible to modify the code for this? I tried several things (in properties too) but am not sure if it is possible in this example.
Dim statesXml As XElement = _
<states>
<state name="California">
<abbreviation>CA</abbreviation>
<year>1850</year>
[Code] .....
Modifying data with the ListView's EditItemTemplate by programmatically settings its DataSource property and calling its DataBind method. I don't have option to use data source control for ListView. All ListViews are bound with data from code-behind. So, I have to handle the Edit/Update mode of ListView manually. [Code]
View 2 RepliesFrom my initial readings on unit testing it is wise to put all of your setups and tests in a separate project from the code being tested.I've recently begun reading The Art of Unit Testing, trying to discover how to break dependencies on things such as database calls.The methods offered involve changing areas of the test code, such as adding specific interfaces and "stub" methods to the production code.This seems to defeat some of the good things about keeping tests and production code separate.Is there any recommended dependency-breaking technique that doesn't involve changing production code?
View 3 RepliesI'm trying to modify this program so that a function procedure determines the student's grade. The problem is, I don't even know where to start. here's my current code:
[Code]...
Locality Not repeating code..Modifying program means modifying one aspects.
View 11 RepliesI am new to VB.net. I want to read and input file and store that data to an SQL Server database. Do you have an sample code that do such?
View 1 RepliesI modified some code to suit one of my other programs, but have come across a difficulty: For some reason, the output file is not outputting. I can tell all the calculations are being made (my computer is loud), but it's just not outputting.What should I look out for when modifying stanav's code that would cause the output file not to be outputted ?
View 6 RepliesI've seen this great example of serial communication in VB.NET
[URL]
I try to use it in a project I am working on but somethings are not clear to me.
1: Now the send and received data is shown in one RichTextBox but I would like to split this into two RichTextBoxes (RtbSend and RtbReceived).It is unclear to me how and were data is assigned to the RichTextBox?
2. the received data is shown in the Richtextbox as one long line, I would like to get a new line for every send message.So for example: I I send "test" four times, I would like to see:
Test
Test
Test
Test
now I see: Test Test Test Test I've tried ctrlf but this does not work.The example describes that "comPort_DataReceived" is executed when data is waiting in the buffer. Where can I see the eventhandler responsible for this? How does it know data is waiting?The problem is this kind of coding is a bit to difficult for me. I want to understand the code before I implement it into my project.
I am populating data form database in combobox. This data is in the form of numeric codes like 112, 113,
The thing i want to do is on selecting some code like 113 from combobox, it will display it as ABC113 in the combobox.if code like 114 selected from combobox, it will display it as ABC114 in the combobox.
I don't want to store this modified string in database.
Please help me to achieve this.
Provide me some sample code or link for simple combobox or combobox in datagrid.
i think there is no change in code in both above cases.
reading and modifying data from database
View 4 RepliesI have a dataset bound to a DGV thus:
Me.BudgetTypesTableAdapter.Fill(Me.RestelDataSet.BudgetTypes)
When I save new data I use :
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Me.Validate()
[Code].....
should work as the Rowstate is checked to see what should happen ie (UPDATE, MODIFY OR DELETE).
I have a running program which is installed in the server side and this program is running 24hrs a day. Now I made some enhncements on this program and would like to publish it. I tried to publish first in my local disk but after publishing Im having some errors "Critical error: Required processing file is missing" after clicking the setup.exe file. Now Im thinking of publishing this directly to my server. If I publish it directly to my server would it disrupt the running program? is it safe to do that? or is there something that I need to do it first?
View 6 Replies1. The application's text box controls are entered manually in my.settings (e.g., tb1, tb2, tb3)
2. The application user "adds" a row of text boxes, which are iteratively assigned a name to match the above my.settings names
3. Upon "save" by user, the text in each text box is associated with its control (e.g., If cntl.Name = "tb1" then My.Settings.tb1 = cntl.Text)
4. The User needs to delete one or more rows previously added
Question:Under #4 of above, what is the best way to delete the rows and how can I use the app.config file to update the above data so I can reuse the named text boxes and keep everything sequential?
I want to create a page that allows a user to upload a file directly to my ftp server. For some reason when I run the code and try to upload a file I get:
ERROR: Could not find file 'C:Documents and SettingsuserMy DocumentsVisual Studio 2010ProjectsASP.NETuploadASP.NETuploadfile.txt This is not where the file is located. I am fairly new to .NET programming so I may have done some things incorrectly.
Here is my code:
If FileUpload1.HasFile Then
Dim fileExt As String
fileExt = System.IO.Path.GetExtension(FileUpload1.FileName)
fileExt = fileExt.ToLower
[code]....
I am new to programming, so I am looking for somewhere to start with this project.What My project needs to do, is that the user inserts data consisting of multiple lines (up to thousands of lines) Into a text box of any type.When a button is clicked on it goes through the lines and alters lines based on what it starts with.
[Code]...
Clicking the button would cause every line with DDE at the beginning to be deleted, while leaving everything else intact.I'm not just looking for handouts, I do want to learn. I just to know what to look at to do this.
is there any code to copy and rename data within the sql server.actually i reated a database which will be like default template and ever company will have the similar database with different name.So what i want when a new company is created, a copy of default database will be created with new name.
View 2 Replieshow to use vb code to code the crystal report viewer in the vb to print directly instead of view first before print from specific NAME of printer? i also need to ask how to set the printer name through in the vb code ??
View 4 RepliesI want to start learning/using modules instead of integrating the code directly into the program. So, I tried to make an example. Basically, what I wanted the program to do, is I click button1 and it lists details about my computer. So, I added 7 labels to the form, and a button. Then, I added a module (Module1.vb)
[Code]...
I've been having trouble converting the following fairly straight forward c# code into vb.net 4.0, which I understand has anonymous delegates. I just havn't been able to figure it out yet.
_combo.DataBound += (sender, args) =>
{
var item = _combo.FindItemByValue(values[0].ToString());
if (item != null)
[code]...
I have tried the following
_combo.DataBound += Function(sender, args)
Dim item = _combo.FindItemByValue(values(0).ToString())
If item IsNot Nothing Then
[code]...
But the compiler complains that DataBound can not be called directly, but has to be called with RaiseEvents
I've got several methods that all need to add items to a single list which will eventually be used to populate a listview. I thought about declaring the list at class level so that all of these methods could access it, but it didnt really make sense as the only methods that access this list are Shared methods, so I didnt think it was worth having a list just sat there for the entire time that any instances of the class are created, when in a lot of cases the list would not be used.
So what I ended up doing was just declaring the list in the Shared method that then calls these other methods that need to add to the list, and for each of these methods it calls it passes the list in as an argument. The methods can then add items to the list and as the list is a reference type it updates the underlying list object, so once all of the methods have been called then the list in the calling method is up to date and can be used. Then when that method exits, the list is no longer in scope and so is removed from memory. This all works fine, but it feels a bit... wrong. Would it be better to just declare the list at Class level and not be bothered about the small overhead of the list always being in scope when instances of this class are created that will not even use the list?
EDIT: Actually, thinking about it.. because the methods that use the list are shared then the list would need to be shared as well if it was at class level - so the list would not only be around when instances of the class are created, but all of the time. So it will just be sat in memory for the lifetime of the program wont it? I assume this could make a noticeable impact on memory usage after the list has been filled with data, so I guess if I went down that route then I would have to make sure I cleared the list once I had populated the listview. This is another reason why it just seems much easier and more manageable to declare the list as a local variable in the shared method that then calls the other methods that also add to the list.
We have an assignment to create some XML outputs from data in SAP R/3. We are using SAP .NET Connector, for doing this. The problem we are facing is that there are some fields which are not exposed by any standard BAPI. Unfortunately we cannot create customized BAPI on this particular system.
We are therefore restricted to whatever standard BAPI are available. I have seen on internet that tools like ERPConnect can provide access to tables directly using RFC. How can this be performed in VB, without purchasing any such tool, using or without using .NET Connector.
on a Windows Form, an object myObject is bound to myObjectDataBindingSource like this:myObjectDataBindingSource .DatSource = myObject on the form, i have a check box bound to the property: chkProp1 for example of the object: myObjectDataBindingSource In the code when the checkbox is clicked, I need to go in code and change another text property of the object txtProper2 for example like this:
Private Sub chkProp1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles chkProp1.CheckedChanged
[code].....