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: Step 2: Create an app.config file On the Solution Explorer, right click on your project, select Add->New Item. On the dialog appeared, click on Application Configuration File, name it app.config. Click OK Open app.config file, modifying it as the figure bellow Step 3: Coding On the SQLConnection.cs file, add the following code:        ...

Read more »

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. public DataTable getData() {             string cnStr = "Provider=Microsoft.Jet.OleDb.4.0; Data Source=HR.mdb";             OleDbConnection cn = new OleDbConnection(cnStr);             string sql = "select * from Employees";             OleDbDataAdapter da = new OleDbDataAdapter(sql, cn);             DataTable dt = new DataTable();             da.Fill(dt);   ...

Read more »

Programmatically read and write a text file

The following is the source code for reading and writing a text file by C#         void readData()         {              string filePath = Application.StartupPath + @"\data.txt";                         if (File.Exists(filePath) == true)             {                 StreamReader reader = new StreamReader(filePath);                 while (reader.EndOfStream == false)                ...

Read more »

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. In the following code, I want to get all the employees with the position of Developer in Employee list, then, I order them by their Salary ascending.             SPWeb web = SPContext.Current.Web;             SPList list = web.Lists["Employee"];             string query = @"<Where>                                              ...

Read more »

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. Now in SharePoint 2010, we have the built in functionality to enforce the uniqueness of the field. But yes do remember that the field must be indexed first before you want to set it as a primary key. Well, just a quick question. Do we have anything as primary key in MOSS 2007? Yes, we do have and that is ID field in list or library. However that does not solve the purpose as it is just used to identify items and used heavily in coding...

Read more »

Saving Changes Is Not Permitted On SQL Server 2008. How To Solve?

Saving Changes is not permitted occurs when doing alter table (table structure is changed): change data type on existing columns or change allow nulls on existing columns To allow you to saving changes after you alter table, do disable prevent changes: Open microsoft SQL Server Management Studio 2008 Click Tools, then click Options Click Designers Uncheck prevent saving changes that require table re-creation Click OK Try to alter your table.                                                                                                        ...

Read more »

Do SharePoint & Silverlight Have a Future Together?

Silverlight was Microsoft's answer to Adobe Flash, an application framework with which to build rich internet applications. It was launched in April 2007 to much fanfare, albeit mainly from Microsoft. Version 5 brought GPU accelerated video decoding and 64-bit support in December of last year. It also brought the conclusion of the Silverlight story, as this version is set to be the final release. Silverlight is no more. Or so people have been speculating, as there has yet to be any official word from Microsoft. Its lifespan might be prolonged as a Windows Phone platform, but it seems likely it will cease to exist as a browser plugin. However this article is not about SIlverlight per se, but rather its somewhat fractured relationship with SharePoint. If we have really seen the...

Read more »