.net professional

Update a share point list through asp.net application

2010-05-06T23:33:00.000-07:00

To update a sharepoint list very first requirement is to reach upto that list. This can be possible with the help of sharepoint webservices. Share point webservice cannot called without authorization. If a user has full permission for sharepoint server access then by using his/her credentials we can call the share point webservices. First we need to add the required web service in our asp.net application. After adding webservices we get classes access of that webservice. Then call authentication webservice. This webservice is used for authentication of the user. Call to sharepoint webservices also depend upon the subsite process or subfolder process. So be careful during the call to subsites.
After successful authentication of the user a ticket will be generated by the sharepoint service for future operations. By using this ticket a user can call another webserice of sharepoint server. To update a list user need to call the lists.asmx webservce. By using authentication ticket of authentication.asmx websevice one can get list of all lists under root or subdomain. With the help of user defined xml one can update the required list of sharepoint server by using Update method of lists.asmx webservice.

Web Site Setup

2010-04-20T23:32:00.000-07:00

Hi Friends,

To make a website set up in .net is quite easy. .net gave its own inbuilt tool for this purpose. Go to file add new project , go on Other project type select set up and deployment and from right hand side select webset up project. By doing this a webset project wil add in your website. After doing this you can add your website(s) in this project for which you want to create set up. When you run this websetup on windows it will ask for virtual directory name and then it will create your virtual directory in your iis and add website pages that you add in setup. This set can also create database in sqlserver. and configure your website on run time. i have done all this code and test it many times. Luckily it is working fine every where. Contact me to get that code.

Comma separated column values in sqlserver

2009-08-25T17:13:00.000-07:00

If there is any requirement arieses we need to show comma separated column values eg:
Dummy values (Requirement)
abc,xyz,pqr etc.
Database column values
fields have an id
CatId CatName
1              abc
2              xyz
3              pqr

To achieve above requirement use following code:
DECLARE @Cat varchar(2000)Select @Cat = COALESCE(@Cat + ', ', '') + CAST(SubCategoryName AS varchar(200))FROM SubCategoryWHERE CategoryId=@CategoryIDReturn @Cat

File downloading when button is in update panel

2009-07-24T15:50:00.000-07:00

Following is the normal code for file downloading. But it will not work if button is placed inside update panel.
Syntax(C#):
//string FileResponse="";
string fileName = Request.QueryString["Region"];

string PdfFilePath = "";
PdfFilePath = Server.MapPath("Contracts/" + fileName);
//PdfFilePath = "http://www.thsweb.com/contracts/" + HiddenField2.Value;
if (File.Exists(PdfFilePath))
{
FileInfo fileInfoObj = new FileInfo(PdfFilePath);
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment;filename=" +fileName);
Response.AddHeader("Content-Length", fileInfoObj.Length.ToString());
Response.ContentType = "application/octet-stream";
Response.WriteFile(fileInfoObj.FullName);
//Response.Write(fileInfoObj.Name);
Response.End();
}

To make it working perfectly we need to add some javascript code on that page where our button to download the file is present.
Following is the code for javascript:
Syntax(Javascript):
function InitializeRequest() {
// Create an IFRAME.
var iframe = document.createElement("iframe");
// Get the desired region from the dropdown.
var region = document.getElementById('clientid of control that contains file name').value;
// Point the IFRAME to GenerateFile, with the
// desired filename as a querystring argument.
iframe.src = "GenerateFile.aspx?region=" + region;
// This makes the IFRAME invisible to the user.
iframe.style.display = "none";
// Add the IFRAME to the page. This will trigger
// a request to GenerateFile now.
document.body.appendChild(iframe);
$get('updaetpanel id').className = "progress";
}
function EndRequest()
{
$get('updaetpanel id').className = "normal";
}
By doing this it will redirect to GenerateFile.aspx page and on its page load it will execute the file downloading code, that i posted at top(start of page).

Open div where you click with mouse

2009-07-24T13:17:00.000-07:00

If you want to open your div with absolute position near or close to your mouse click. Then use following code:
Syntax(javascript):
//get the scroll postion to use as our offset for our absolute position
var scroll_pos = document.body.scrollTop;
if (scroll_pos == 0) {
if (window.pageYOffset)
scroll_pos = window.pageYOffset;
else
scroll_pos = (document.body.parentElement) ? document.body.parentElement.scrollTop : 0;
}

now scroll_pos contains top margin height with respect to your mouse. As in eg i set scroll_pos to div:
addDiv.style.marginTop = 100 + parseInt(scroll_pos) + 'px';
Here "addDiv" is clientid of Div.

In javascript find control id in composite databound control

2009-07-24T12:58:00.001-07:00

To find the exact id of control that is placed in itemtemplate of composite databound control like (datalist or gridview).Suppose we want control's id onClient click, Call a javascipt function onclientClick and pass a parameter named "event". it is default keyword.
Syntax:

OnClientClick="AddOccupant(event);return false;"
Now go in your javascript function. as in example we go in AddOccupant function in javascript.
Syntax(javascript):

function AddOccupant(event) {
var obj = event.srcElement event.target;
var seltreeNode = obj;
var selectedId = seltreeNode.id;
//now seletedID contains your client side of control that is in compositedatabound control.
}

Javascript function with parameters call onclientclick

2009-07-24T12:49:00.001-07:00

To call a javascript function and pass parameters on client click of any button , link button etc. use following syntax:

OnClientClick='<%
"ShowBookingDialog(\""+Eval("CreditCard")+"\",\""+Eval("NonSmoking")+"\",\""+Eval("CreditCardType")+"\",\""+Eval("CreditCardExpiration")+"\",\""+Eval("SrNo")+"\")"
%>
Here my button or link button is in datalist or gridview and i set its datsource.
And "ShowBookingDialog" is a javscript function and passing parameters to it onClientClick.

Register client script when using Update panel

2009-07-23T09:51:00.000-07:00

Page.RegisterClientScriptBlock(string key,string script) will not work if control is inside the update panel. To solve this problem we need to use
ScriptManager.RegisterClientScriptBlock(Control,Type,string key,string script,bool addScriptTags);
Let us take an example suppose a Datalist named "dtalistNames" is in updatepanel and we need to register the script in Datalist's item command event. Then use following text to alert a message.
C# syntax.
string Message="";
Message="";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "mess", Message, false);