How to auto populate table data in share point webpart

Question

Hi Friends My requirement is i have Sql table data one column data i need auto populate in textbox share point visual WebPart How can achive please suggest me

Priyaranjan K S · Answer

Bhaskar Have you tried out the same code for Share Point Web part ? Because if the ASP Code you posted is working for you the same code should work for Visual web part because its nothing but an aspx page along with a code behind . But the only thing that has to be differently implemented is the calling of web method . In Share Point as you know you might get a code behind file for the web part. But if you write the web method there you wont be able to call it from the aspx ajax call(this is default behavior). So the work around here is : - Add an application page to your project and write the web method there . - Call this web method from the web part aspx page These links will be helpful : http://sharepoint.stackexchange.com/questions/98184/call-webmethod-from-js-in-visual-web-part http://onceinawhilescribble.blogspot.in/2015/02/ajax-call-from-visual-web-part.html Thanks Priyan If you found this useful Please mark this as Answer

Priyaranjan K S · Answer

I am sorry Bhaskar . Please make it clear . I understood that you back end has sapid and email id . Now you want to have a visusal web part which contains a text box . When should the text box be auto populated ? With what data should the text box be populated ? Should the autopopulation happen based on the current logged in user ?

Bhaskar Yadav · Answer

Hi Priyan Thanks you. Regards Bhaskar.

Bhaskar Yadav · Answer

Thanks Priyan... Regards Bhaskar.

Priyaranjan K S · Answer

I will give it a try today . Thanks Priyan

Bhaskar Yadav · Answer

Hi Priyan in asp .net i have achived this requirement below code i have used same thing i need to do visual webpart u have any idea means let me know. aspx pge code $(document).ready(function () { SearchText(); }); function SearchText() { $(.autosuggest).autocomplete({ source: function (request response) { $.ajax({ type: POST contentType: application/json; charset=utf-8 url: MyWebParet.ascx/GetAutoCompleteData data: {'username':' + document.getElementById('txtSearch').value + '} dataType: json success: function (data) { response(data.d); } error: function (result) { alert(Error); } }); } }); } Enter UserName: aspx.cs page code [WebMethod] public static List GetAutoCompleteData(string username) { List result = new List (); using (SqlConnection con = new SqlConnection(@Data Source=WIN-4AMGGL21FRA;Database=koti;Integrated Security=True;uid=sa;password=mbhaskar@123)) { using (SqlCommand cmd = new SqlCommand(select DISTINCT UserName from UserInformation where UserName LIKE '%'+@SearchText+'%' con)) { con.Open(); cmd.Parameters.AddWithValue(@SearchText username); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { result.Add(dr[UserName].ToString()); } return result; } } } Regards Bhaskar.

Bhaskar Yadav · Answer

Hi Priyan When should the text box be auto populated ? user type that text box With what data should the text box be populated ? in text box sapid data populate sql table i have sapid values (515328445153284651532847) like that data i have in textbox user will type 5153 means what ever data is there in sql table data sapid values populate in that text box. Should the autopopulation happen based on the current logged in user ? yes current user. Regards Bhaskar

Bhaskar Yadav · Answer

i have sql table columns like sapid and mailid i need to autopoulate sapid data autopopulate in textbox when ever user will type that text box sapid data autopopulate i need to do visual webpart only so please give me any suggestions

Priyaranjan K S · Answer

What do you mean by Populating a text box in visual web part with one column of sql data ? Please clearly state your requirement . Text box would ideally contain data from a single sql cell . If you want to show the entire sql data you will have to go with SPGridView . Thanks Priyan