I am trying to create a new item in a sharepoint list. Not getting any error messages but the item does not appear in the list.
Here is my code:
'Declare and initialize Lists Web service.
Dim listService As New Lists()
'Authenticate
[Code].....
I am trying to add items in a SharePoint list and I would like to use vb. I have tried using this this from here: [URL] but i get this error: Type SPWeb is not defined.
[Code]...
I'd like to write an app that would allow users to modify existing records in a WSS sharepoint list and/or create new records.I feel confident that its possible, but I just don't know exactly how. Sharepoint access, for me, is accessed with domain credentials, so I"d need some method for getting those from the user, in the winform, and passing those along to the WSS server.
View 1 RepliesSo I've been trying to retrieve a list from sharepoint using Lists() web services and then displaying the list on a datagrid. However I am having some weird problem. My code so far is
'Declare and initialize Lists Web service.
Dim listService As New Lists()
'Authenticate
listService.Credentials = System.Net.CredentialCache.DefaultCredentials
[Code]...
1) It also displays a column called "ows_owsHiddenversion" which I have no idea where it's coming from.2) The order of the columns that are displayed are different from the order in the sharepoint site.3) I have a column called "DONE?" and it is a choice type with the options of choosing 'Yes' or 'No'. But for some reason, in the datagrid, the column under DONE is all blank and I cant figure out why all the 'Yes's and 'No's are not showing up. All the other values for the other columns appear fine.4) I am sorting the data from the sharepoint list by the "Division" column which is fine but the header of the column in the datagrid is labeled "Title". I checked the XmlNode outer and inner xml and for some reason the Field Ref is set to "Title" to represent the "Division" column
I am writing a small program to update data in a SharePoint list. Now where I cannot develop or use applications for SharePoint unless I am on a SharePoint server, I thought I would cheat the system by using Access to link to SharePoint lists, and then use Visual Basic to play with the Access tables. I need additional functionality other than what VBA can provide me, so that is why I am using the VB layer.Is it possible that this is not permitted? Whenever I try to update an item in the table, I receive the message:
"cannot update '(expression)'; field not updatable"
The word 'expression' here is not a filler I added, this is the actual error.If I try to make the edit manually in the table using Access, it works fine (I haven't tried it through Access VBA yet...).
How my code works is this:I have a Dataset added to the project which connects to the Access database. I add one of the tables to the dataset and create a Class object to reference the table adapter (essentially a Data Access Layer). I can read all of the data fine, and when a change is made in SharePoint, my application sees the updates when it refreshes. But when I try to write back to the table I get the error message above.
For
Each r As
DataRow In TableAdapter.GetData.Select("Name LIKE '*" & FileName &
"*'")
[code]....
There are other columns in the table and some of them have default null values. I only want to update these two fields, but it almost seems like this is not possible. I thought I might be somehow opening the Dataset in a Read Only mode, but I can't seem to find that option anywhere.
First timer here, I love the site!
Running:
- VS 2008
- Sharepoint 3.0
- Access 2007
- Windows Vista (The machine I'm developing it from)
History: (Do excuse me if I don't reference different methods I've taken so far correctly, I'm still learning!) I am building some search software for a law firm that I work for in Australia. It's all coming along really well, but I seem to have hit a snag getting data out of sharepoint lists and into my project!
I first attempted to add a web reference to sharepoint and after a while was able to pull in all of the data from the lists, fantastic!(OR NOT!). The issue then was when I attempted to load it up into an array using XMLNodes, whilst it loaded up fine and I could see all the data, if there was a null value in one of the columns, it wouldn't pull that null value across, therefore, I couldn't really use the data...
[Code]...
I am having problems with adding up the totals of the books in the lstcosts it works if I have only 1 book selected but the minute I choose more than 1 I don`t even know where its getting the subtotal from...It`s probably just something little of an error...but if anyone has a clue as to why the Sub Calculate() code isn`t working for the subtotal
HTML
Public Class ShoppingCart
Dim decSubTotal As Decimal 'subtotal variable
Dim decTotal As Decimal 'total variable
[Code]....
i have a listbox, that i want to make sure the value im about to add to it, is not already in the list, here is what i have but it dosent put anything in the list box.
For Counter As Integer = ListBox1.Items.Count - 1I To 0I Step -1I
If InStr(CStr(ListBox1.Items(Counter)), hyperlinked(0)) < 1 Then
ListBox1.Items.Add(hyperlinked(0))
[code].....
building simple program that i could print index pictures to 11x17 size paper. and came across with listbox multi items selected and wanted to add them to different picture boxes?
View 1 RepliesHow would I go about uploading an entire directory and all sub-directories and files to a SharePoint 2010 Server?
I don't think this function is specifically built into SharePoint (just uploading multiple documents in one folder). But the way I understand it, I can write something in VB or C# to accomplish this.
I'm trying to access a list from sharepoint when I do i get an error Here is my code
[Code]....
I am not sure where to post this as I didn't see a forum for SharePoint on here. I hope someone can help me with this.I have a form sitting on a webapp outside of the sharepoint server (which is why I am using the Client Object Model). To make a long story short the form is sending data to a SP list. This list is made up of regular string fields, date fields, lookup lists, choice lists and user data.
I am able to insert data that isn't part of a list with no issues. However, when I update any of the lookup lists i receive the following error:Invalid look-up value. A look-up field contains invalid data. Please check the value and try again. So I then wrote code that went to the list and got the entire item as follows (please bare in mind this is not very eloquent, but it gets the data)
[Code]...
I have a .net asp app that updates a SP form. I am using the Client object model. Currently when inserting a record the record is inserted using the App pool ID. Is it possible to somehow set the context to use the ID of the person logged into the webapp or a custom ID separate from the default. I can't find any data in this in the web or gong through the context methods.
View 3 Replieswebpart vb.bet 2010 not visual webpart I want to grab the selectindexchanged, and run the code after button click. I only really need is the SelectedItem.Text
here's how I did it in VB.net asp page.
Protected Sub listbox_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles Click_button
But SharePoint doesn't see this as valid handle.
how I can add a Month control to appear in the centre screen when I click a button?
View 1 RepliesI'm looking for adding a control on top of others controls during runtime.
I read that the only way of playing with the Z-Order of controls is by playing with the order of the controls inside the Form.Controls Collection. I find this solution very weird and weak and I'm looking for an alternative.
Does anyone has an idea? I just want to make some kind of modal dialog that'll show below another user control to notice the user that the user control is currently doing something.
Edit: I tried using Control.BringToFront() but it doesn't work at all.
I am trying to create a simple Word doc that when the user presses the button it takes the information in the boxes and tosses it into a template style paragraph. But my issue is that I have two combo list boxes as seen in the picture. I want to have two values in the drop down list as seen in the labels next to them but for the life of me I can't figure out how to do this in Word 2007. In Visual Studio this is much easier but I am work and need to snap this out for the folks at work. Is there an option that I can choose in the properties where I type in the values for each drop down or do I have to add them in at run time?
View 1 RepliesI am trying to add a datatable to a database. Here's what I've been trying:
Dim newDataTable As DataTable = New DataTable("Example")
VocabularyDataSet.Tables.Add(newDataTable)
SqlDataAdapter1.Fill(VocabularyDataSet.Tables("Example"))
I've tried various incarnations of Fill and Update. But the tables will not save on the database!
Is there a way to loop through each constant in the ControlChars module programatically? I want to add each of the enumerated control characters to a combobox control.
View 2 RepliesI'm trying to add a group of four radio buttons to a form. There are other radio buttons so I'm grouping them by placing them on a Panel. However using the below I just get the panel added to the form without the radio buttons... Am I doing something wrong here?
Dim arrRButton(3) As RadioButton
arrRButton(0) = New RadioButton
arrRButton(1) = New RadioButton
[code].....
I have an MDI application, say name of MDI is MDIParent. From form1 I am adding new tab pages to form2. In the first tab of form2 I have generated a ListView by calling a ListViewCreate() function in Load event of form2. I am not able to generate ListView for the new tabs. I tried calling the ListViewCreate() while adding newtab. But, it is not creating listview nor throwing any error.
View 4 RepliesI have been attempting to do this in so many ways. I have tried using rundll32 printui.dll, PrintUIEntry and for some reason it stops working on vista. I have no clue why. It wont even try to work with HP printers using the inf file. What is the best way to add a LPR port printer programmatically? I can create the LPR port with NO issue what so ever.
View 3 RepliesI am adding a TextBox to my asp.net page programatically via a PlaceHolder Control. However when I set the TextMode value to MultiLine I get this error:System.FormatException: Input string was not in a correct format.
View 3 RepliesI have a unbound datagridview for which i want to add a new row at the bottom when a user selects a value in the 2nd column of a 9 column DGV. The issue is that i have a default value (0.00) programmically entered into the last row once this 2nd column value is entered. When i call DGV.rows.add() it places the new row at teh top, but when the user enters or changes the last coulmn value then a new row is added at the bottom. I want my programmically added row to be at the bottom and have not found a way of doing this.
PS. What is the logic behind this different behavior on adding rows?
OK - I have worded this search 40 different ways and I seem to be lost here. Every example I find seems so happy that you can easily drag and drop a datagrid and let the user fill it in -- then they stop! I know how to do everything I am asking through LINQ. That obviously won't translate here. I really should have learned ADO.NET first, then LINQ, but NOoooo... I need to know how to do the following in .NETCF (Windows Mobile 5) using a SQL CE database on the device.
Add a new record and populate some or all of the fields with data I supply. I don't need to add a record to a datagrid - sometimes the user will not even see the record. How do I add a new record -- put data into it and save it? For example: Create a new delivery record, say, and have the program store the date in one field and a number in another field. Search for a record, then update data in it. Again, using LINQ I can do this easily -- I cannot for the life of me find any examples of doing it without it.
I can find lots of examples of populating a grid of databound fields, letting the user make changes then saving it out. I don't need to do that. Say I need to search for the one record that meets a criteria (customerID=10 and orderID=1234), then when (if) that record is found, update a field in it.
I'm trying to use a split button from a tool strip to add and remove selected items in a listview.Users click the button to add the selected item which appears in the split button drop down menu as checked.The drop down menu has three items at any one time, each with a default value of <none> - this is replaced with the text from the listview when an item is added.When users click the item from the drop down, the item is unchecked and the text returns to <none>.
The drop down should populate from the top down so if a user removes item 1 or 2, the items below would appear to be moved up with the 3rd item now showing <none>.
[Code]...
I am attempting to read the results from a SQL query into a List(Of) and I can see the List.count while adding items to the List increments, however in another part of my code when I am attempting to read the List the List.Count returns 0. My List is as follows:
[Code]...
1. I have a DataGridView box, that is connected to a MySQL database via the 'Data Source'. I am trying to do the datagridview1.rows.add("info here"), however i receive an error i cannot do this programmatically. I DO know the code to post to MySQL via the "insert into" la la la.However, I was curious if I can do this via the datagridview a bit..easier/simpler, such as a "datagridview1.rows.add(stuff)" sorta thing.
2. I am attempting to make a custom control, and as with ANY control, they have their.. settings. Example, a textbox, or label, has so you can set the Text. and color, etc.Others, have it (such as datagridview) have the little icon on the control itself, where you click it, and it opens a small window with settings.
A few more details. I need to programmatically (Winforms, VB.NET) check if a site is in the Allowed Sites list of the IE Pop-Up Blocker (IE 7 and 8 and Windows XP, Vista and 7) and if not, add it. The application is fully trusted and I don't want to disable the Pop-Up blocker entirely. To clarify some things, this is for a web-automation application with several users across 3 countries. I want to avoid receiving tons of emails and explaining each time how to add the website to the Allowed Sites manually. Also, some of the users have Google Toolbar installed, which also has a Popup Blocker creating trouble to my app. Can this also be done programmatically?
View 1 RepliesDoes anybody know which version of Visual Studio 2010 contains the full set of Visual Basic SharePoint Templates? I am about to embark on a project to create Visual Web Parts to be used in a SharePoint report.
At the moment I am using Visual Studio 2008 and even though the WSPBuilder is installed none of the relevant SharePoint templates are present.Having searched SO and the web, most advise to install the templates via the Visual Studio command prompt: devenv /installvstemplates
Alas the Visual Studio command prompt is also missing from my VS2008 installation.So, the question remains: which version of VS2010 contains what I need for pain-free SharePoint development? There is a rather large price different between VS2010 Professional and VS2010 Premium, so can anyone tell me if the cheaper version (VS2010 Professional) contains all the Sharepoint templates?