dinesh.isuranga

In SQL 2012 there is a new clause available OFFSET-FETCH. But the trick is first you have to order the result. Please add below clause after ordering. OFFSET 0 ROW FETCH 1 ROW ONLY;

I have created a Column chart and Pie Chart using silverlight 4. but now i want to implement a Stacked Chart. But I have no Idea to implemnt it. here is my data repository if anyone can please help.. [code] public class DataList { public string SbuName { get; set; …

this is the way that i used to fill dataset in the formloader (); [CODE] String Query; DataSet ds; SqlDataAdapter myadapter; SqlCommand mycommand; connInterface conn = new connInterface();//connection class private void Form1_Load(object sender, EventArgs e) { cmbEmpID.DataBindings.Clear(); Query = "select * from dbo.bind_tab b"; mycommand = new SqlCommand(Query, conn.createconnection()); myadapter …

I have table with Gender Column.. it is nvarchar(1) column named as "empsex" which hold "M" if employee is male and "F" if employee is female.. really i onfused with binding this one column to two radio buttons.. if someone know the way.. please help me.. thanx..

I Have a Just Simple Question. But It Made me Confuse. I have a DataTable Which has bind to textBoxes and Other Items. therfore when I made a change through txtBox or Other Items it reflect to dataTable. what I have to do is Saving updated Datatable to Sql Table. …

I have a Fully Completed report in ms Excel. I want to change My Report using SSIS Pakage.. i realized that 'unpivot' and 'pivot' component will be needed.. so someone can help me to solve this matter.. thanks..

how to bind a double property to text box in C#..

I have a Report Model List Controller and I want to get Selected Row Of data to be used.. my Row has there are four data colums.. Name.Age,Birth and Salary... please help me to solve this... thanks...

How to convert DATE into string in C++.. please help me...

Please Help me to Solve This Problem..

i'm a C# developer and new to C++. I have to learn about C++ due to my new Project. but no clear idea about Pointers.. therefore if someone who know about Pointers,please teach me them..

/*The best way of creating connetion is using a separate class for connection.. */ [code] using System; using System.Collections.Generic; using System.Data.SqlClient; using System.Text; using System.Windows.Forms; namespace ImageUpload_Download { class connection_class { public String connection_string = "Data Source=MY_PC;integrated security=true;initial catalog=master"; public SqlConnection conn; public connection_class() { //default constructor here } public …

Please help me learn session handing in C# using default.aspx

Please Help me to create or add a new chat system module to an existing asp.net web site..

this is wrong USER-7DA292602D\user the correct way is USER-7DA292602D\\user