 |
|
|
Can somebody plz tell me that how can i show data from sql server in sharepoint list ...ie i wabt a column in a custom list that when user fills the column data he will get a drop down that will show data from a sql server database and then when he selects a value i want some other fields to get auto populated getting their data also from the database.
|
|
|
|
|
|
|
Hi
My requirement is Get all the items in the list with Current System date.
The list has a column name "Created" type is "DateTime".
I write a CAML query like following
Today_Date = System.DateTime.Now.Date.ToString("yyyy-MM-dd");
SPQuery qry = new SPQuery();
qry.Query = "<pre>Query Where Eq </pre>";
qry.Query += "<pre> FieldRef Name=\"Created\" </pre>";
qry.Query += "<pre> Value IncludeTimeValue='FALSE' Type=\"DateTime\";
qry.Query += <pre>Today_Date + "Value";<pre>modified on Thursday, March 18, 2010 12:40 AM
|
|
|
|
|
|
|
Please format the code using pre tags so all relevant code is visible
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
|
|
|
|
|
Bangalore, March 11, 2010: Content management technologies first entered the market primarily in the form a separate line-of-business (LOB) application such as a human resources portal or a dealer extranet. They were basically rolled out in response to specific business needs. The technology vendor base was categorised with the key players focusing on a niche within content management, such as document management, Web content management or digital asset management.
Slowly with time and usage, both customer and vendor organisations started realizing the value proposition that content management could bring to the table to address multiple business problems across numerous departments. Thus Enterprise Content Management (ECM) was born, serving as a platform for:
• Building multiple content- and process-centric applications
• Deploying tens to hundreds or even thousands of Web sites and portals
• Supplying content and content services to other enterprise applications, such as enterprise resource planning (ERP) and customer relationship management (CRM) systems
• Facilitating content lifecycle management
With the maturation of the ECM industry, vendors continually added new functionality to their product suites to address the growing variety of content management needs found within corporations worldwide. What began as an industry primarily focused on niche applications has expanded into a market where vendors now offer a full spectrum of content management capabilities, from document management and imaging, digital asset management, and records and retention management, to Web content management and collaboration.
In the 90s, many of us became familiar with browser based content management, by way of GeoCities. Users could create their own personal web pages, maintained from the comfort of their own browsers. No longer bound by the shackles of FTP, GeoCities was a harbinger of user generated social media power, large scale browser based CMSs and communities like MySpace, Linkedin and Facebook.
In the same period, big companies were figuring out that they could delegate content management amongst site stakeholders by building proprietary browser based CMS applications. The “sales department” could maintain the appropriate corner of the corporate website, their HR page, their customer service page etc.
Now, incredible browser content management systems, that (literally) would cost millions to develop, are available for free. WordPress, Joomla, Drupal and many are free-of-charge for the clever to customize and use.
The evolution of CMS over the past few years has been rapid and radical. While mid-to-enterprise-level commercial content management systems improved in recent years, they’ve been pushed aside by “the user revolution”.
Saltmarch Media's annual Great Indian Developer Awards honors software products across 12 categories, based on their productivity, innovation excellence, universal usefulness, simplicity, functionality and most importantly on the ground feedback from India’s software developer ecosystem. In the Enterprise Content Management tools category, the final shortlist consists of IBM’s WebSphere Portal, Drupal, Microsoft’s Office SharePoint Server, Oracle Universal Content Management, Microsoft’s Content Management Server. EMC Documentum was the first content management tool to win this award in 2008 followed by Microsoft Office Sharepoint Server in the 2009 chapter of the same awards.
If there is a particular development environment that you personally endorse to your colleagues or you evangelize about them at the first opportunity you get, here is your chance to vote for it (voting closes April 10 2010) and see it win this prestigious award. Visit the 2010 Great Indian Developer Awards website and cast your vote. It counts! Voting is open from http://www.developersummit.com/gida3_llist.
A Saltmarch Media Press Release
E: info@saltmarch.com
Ph: +91 80 4005 1000
|
|
|
|
|
|
|
This is not the place for advertisements 
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
|
|
Hi, I'm sending this to my sharepoint server and it keeps on failing with error 12044 (ERROR_WINHTTP_CLIENT_AUTH_CERT_NEEDED).
POST /_vti_bin/Lists.asmx HTTP/1.1
Content-Type: text/xml; charset=utf-8
Authorization: Basic <Username:Password base64encoded>
User-Agent: MySimpleApplication
Host: <MySharePointServer>
Content-Length: 449
Cache-Control: no-cache
SOAPAction: "http://schemas.microsoft.com/sharepoint/soap/GetList"
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<GetList xmlns="http://schemas.microsoft.com/sharepoint/soap/">
<listName>ListName</listName>
</GetList>
</soap:Body>
</soap:Envelope>
|
|
|
|
|
|
|
Might it have something to do with you trying to use basic authentication while SharePoint uses Windows authentication?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
|
|
How do I change this to include Windows authentication instead? Do I need to send different windows authentication for every request?
|
|
|
|
|
|
|
Solved it. I found out that if SharePoint server returns (12044)ERROR_WINHTTP_CLIENT_AUTH_CERT_NEEDED, just resend the content again but this time without the header. Kinda hackish, but works for me 
|
|
|
|
|
|
|
Hi Can someone please tell me that how can i make data go from a asp.net form to a list in sharepoint ie when user opens the form and clicks save the data should get stored in the sharepoint list.
Thanksmodified on Sunday, March 14, 2010 8:40 PM
|
|
|
|
|
|
|
Hello Sin,
Let me give alternative method to do without writing Submit Button code in the ASPX page :
Step1:Create a SharePoint List with columns(if Required) to Save data whenever user clicks the Submit Button in the ASPX form
Step2: Open the List in the SharePoint Designer and Check Out the List and Navigate to navigate it to NewForm.aspx(default APSX pages for a list)
Step3: Right Click on NewForm.aspx and Select New from Existing Aspx page named it as NewForm1.aspx
Step4: Open the NewForm1.aspx in the SharePoint Designer and Hoovers it as Default to Master Content
Step5: Select Insert Menu in the top of the options and Navigate to SharePoint Controls
Step6: Navigate the SharePoint Controls you will get the option Custom List Form
Step7: Click it you will see all the columns created in the List with Button OK and Cancel
Step8: Customize the Button Text and Value
Step9: Customize the ASPX page Example: creating the Custom Master Page and CSS and Apply for the NewForm1.aspx
Step10: Fill all details for the Columns in the Textbox’s and Click the Button Ok
Step11: It will Automatically Save the data in the SharePoint List and Refresh it
Done!!!!
Regards,
Siva(SharePoint Developer)
Egon Software Pvt Ltd,
Nagar Road,Pune
modified on Sunday, April 25, 2010 10:45 AM
|
|
|
|
|
|
|
Hello Sin,
Let me give alternative method to do without writing Submit Button code in the ASPX page :
Step1:Create a SharePoint List with columns(if Required) to Save data whenever user clicks the Submit Button in the ASPX form
Step2: Open the List in the SharePoint Designer and Check Out the List and Navigate to navigate it to NewForm.aspx(default APSX pages for a list)
Step3: Right Click on NewForm.aspx and Select New from Existing Aspx page named it as NewForm1.aspx
Step4: Open the NewForm1.aspx in the SharePoint Designer and Hoovers it as Default to Master Content
Step5: Select Insert Menu in the top of the options and Navigate to SharePoint Controls
Step6: Navigate the SharePoint Controls you will get the option Custom List Form
Step7: Click it you will see all the columns created in the List with Button OK and Cancel
Step8: Customize the Button Text and Value
Step9: Customize the ASPX page Example: creating the Custom Master Page and CSS and Apply for the NewForm1.aspx
Step10: Fill all details for the Columns in the Textbox’s and Click the Button Ok
Step11: It will Automatically Save the data in the SharePoint List and Refresh it
Done!!!!
Regards,
Siva
modified on Saturday, August 14, 2010 2:58 AM
|
|
|
|
|
|
|
Hi ,
Thanks for replying Rao ...i know of this customization of newform but don't know excatly what all can be done ...i ll tell u my scenario...i have a form and all the data from that form has to go in a custom list ..now the thing is that in the form there is a feature of repeating table column ie the user who fills the form can enter one row or might be 2 ,,3 or any ....and this data has to be stored in the list now i want to know that how can i create columns on the fly ie i want to have a table in this customized newform that users can fill and then when they click save the data should be stored in the custom list .
|
|
|
|
|
|
|
Hi Sin,
i understood the scenario can you give me sometime so that i can start doing in my machine and forwared the steps to make it clear for all. i will send the procedure tomorrow
Cheers,
Regards,
Siva(SharePoint Developer)
Egon Software Pvt Ltd,
Nagar Road,Pune
|
|
|
|
|
|
|
|
|
|
|
|
|
Thanks Siva ..but now the requiremnts have changed and i won't be using the aspx forms ..but thanks for help the code great ..learned some good points from that ...
Can you plz tell me that how can i show data from sql server in sharepoint list ...ie i wabt a column in a custom list that when user fills the column data he will get a drop down that will show data from a sql server database and then when he selects a value i want some other fields to get auto populated getting their data also from the database.
|
|
|
|
|
|
|
Hello Sin,
I am having the code Getting data from the sql server for a dropdown list i will send it in the evening and selected field autogenerated to show extra information this scenario we can try it using JavaScript or we can try it using AJAX Controls i will give some breif descrition tomorrow regarding this scenario
Cheers,
Regards,
Siva(SharePoint Developer)
Egon Software Pvt Ltd,
Nagar Road,Pune
modified on Sunday, April 25, 2010 10:44 AM
|
|
|
|
|
|
|
Let me start out by saying that I am aware that you can pass parameters to an InfoPath form by coding the FormEvents_Loading event.
Unfortunately by adding code to the InfoPath form you then have to have the form authorized by a system administrator. My client finds this intolerable when developing an InfoPath form.
I am looking for a way to pass data to an InfoPath form field without coding so that the form can be published directly to a form library, without the need for authorization from the system administrator.
Any information will be greatly appreciated.
If that is not possible is there a way to include custom functions in InfoPath so I could use it to format a field?
|
|
|
|
|
|
|
Dears,
Suppose I have an array of IDs in my code and I want to use them to filter a list.
I need to use SpQuery because I need the resulting view to be rendered as HTML.
So how can I filter by ALL the IDs?
Should I create an OR statement for each one or there is a more logical way?  Best Regards
3ala2
|
|
|
|
|
|
|
I want to handle the event of my Document Library.
I use the "SPEventReceiverDefinition" class to test the event of the list.
It is worked.
Then i deleted the assembly that i tested in previous.
I create my new event class and update this assembly to eventreceivers of sharepoint.
But it is still worked with the first assembly.
I don't know why it is happened.
Pls point me.
|
|
|
|
|
|
|
You can't just delete the assembly. You must delete the feature.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
|
|
Thanks for your reply.
It is worked fine after restarting IIS.
|
|
|
|
|
|
|
Are you sure that you restarted IIS?
There is no foolish question, there is no final answer...
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Rant 
Admin