logadse.blogspot.com

programmingshare-thienle.blogspot.com

Using SPQuery to return SharePoint list items ~ Programming Share

http://programmingshare-thienle.blogspot.com/2012/02/using-spquery-to-return-sharepoint-list.html

The more we share the more we will get back. Sunday, February 5, 2012. Using SPQuery to return SharePoint list items. Using SPQuery and CAML(Collaborative Application Markup Language) is an efficient way to retrieve data in SharePoint list. It help us to filter and order items in the selected list. In this post, I want to introduce to you an example of using them. List = web.Lists[ "Employee". Query = @" Where. FieldRef Name='Position' / Value Type='Choice' {0} /Value. SpQuery = new SPQuery();.

programmingshare-thienle.blogspot.com

Bind data from a SharePoint list to DataTable ~ Programming Share

http://programmingshare-thienle.blogspot.com/2011/12/bind-data-from-sharepoint-list-to.html

The more we share the more we will get back. Wednesday, December 28, 2011. Bind data from a SharePoint list to DataTable. The following is the complete code to bind SharePoint list items to a DataTable. In this post, I keep using the list named "Employee" with 5 column: Title, Birthday, Male, Position, Salary. At first, we need to create an empty DataTable with its column. E dt = new DataTable. Col = dt.Columns.Add( "ID". ColAutoIncrementStep = 1;. ColAutoIncrementSeed = 1;. Dt = dataTableInitiate();.

programmingshare-thienle.blogspot.com

Tabbed infowindow in Google Map V3 ~ Programming Share

http://programmingshare-thienle.blogspot.com/2011/11/multitab-infowidow-in-google-map-v3.html

The more we share the more we will get back. Tuesday, November 1, 2011. Tabbed infowindow in Google Map V3. This article will show you how to create a tabbed infowindow in Google Map V3. First, download the css and js script file. Download here. Then, putting it in your project and referring it in your html code. Link type="text/css" href="/CSS/jquery-ui.css" rel="stylesheet" /. Link type="text/css" href="/CSS/thickbox.css" rel="stylesheet" /. MapTypeId: google.maps.MapTypeId.ROADMAP. Var text1 = [.

programmingshare-thienle.blogspot.com

Sharepoint 2010 – New functionalities for listings ~ Programming Share

http://programmingshare-thienle.blogspot.com/2012/02/sharepoint-2010-new-functionalities-for.html

The more we share the more we will get back. Thursday, February 2, 2012. Sharepoint 2010 – New functionalities for listings. Enforce Unique Values in Site Columns Ability. In MOSS 2007, we do not have any option to set unique column value for the field in document library or list. We can still achieve that with the help of event handlers and adding some code in the ItemAdding event. But still there was no direct way to do it. So let’s see how to go ahead with primary key in list field. Once you set this ...

programmingshare-thienle.blogspot.com

Read and display Sharepoint list data in GridView control ~ Programming Share

http://programmingshare-thienle.blogspot.com/2011/12/read-and-display-sharepoint-list-data.html

The more we share the more we will get back. Friday, December 2, 2011. Read and display Sharepoint list data in GridView control. I have developed a custom web part which reads data from SharePoint List and display in a GridView control by Visual Studio 2010. In this scenario, I have a list name "Employee" with 4 collumns named Title, Birthday, Male, Position. Add the following code to the .ascx file. Add the following code to the .cs file:. Items = list.Items;. GridDataSource = items.GetDataTable();.

programmingshare-thienle.blogspot.com

Programmatically read and write a text file ~ Programming Share

http://programmingshare-thienle.blogspot.com/2012/02/programmatically-read-and-write-text.html

The more we share the more we will get back. Friday, February 10, 2012. Programmatically read and write a text file. The following is the source code for reading and writing a text file by C#. StartupPath @" data.txt". Reader.EndOfStream = false. Line = reader.ReadLine();. StartupPath @" data.txt. Writer = new StreamWriter. Line = "This is a text file". Posted in: .txt. Read and write a text file. Read and display Sharepoint list data in GridView control. Using SPQuery to return SharePoint list items.

programmingshare-thienle.blogspot.com

Get data from SQL database and display in GridView control ~ Programming Share

http://programmingshare-thienle.blogspot.com/2011/12/get-data-from-sql-database-and-display.html

The more we share the more we will get back. Saturday, December 31, 2011. Get data from SQL database and display in GridView control. The following are the basic steps to get data from SQL database and bind to GridView control in ASP.net. I have a Database named ABC with a table named Products, I want to get all the rows in Products table. Step 1: Create new Project. Launch Visual Studio 2010, click on File- New- Website to create a new ASP.NET website Project. Step 2: Create a new Page. Da = null;.

programmingshare-thienle.blogspot.com

How to enter connection string on runtime? ~ Programming Share

http://programmingshare-thienle.blogspot.com/2012/04/how-to-enter-connection-string-on.html

The more we share the more we will get back. Sunday, April 1, 2012. How to enter connection string on runtime? One of the challenging tasks in .NET programming is changing the connection string on runtime. In this post, I will give you the simple step to complete this task. Step 1: Create a SQL Conneciton form:. On the Solution Explorer panle, right click on your project,. Select Add- New Item. Select Window Form. Name it SLQConnection, then click OK. Design it as the figure bellow:. Road the Config file.

programmingshare-thienle.blogspot.com

How to get data from Access database in C#? ~ Programming Share

http://programmingshare-thienle.blogspot.com/2012/03/how-to-get-data-from-access-database-in.html

The more we share the more we will get back. Saturday, March 31, 2012. How to get data from Access database in C#? The following are the complete code to get data from Access database:. First, we connect to the database. CnStr = "Provider=Microsoft.Jet.OleDb.4.0; Data Source=HR.mdb". Cn = new OleDbConnection. Sql = "select * from Employees". Sql, cn);. Then, we load the data to Listview control. Dt = getData();. I = 0; i dt.Rows.Count; i ). Row = dt.Rows[i];. FName = row[ "FirstName". Emp = new Employees.