have a look to the following links Link 1 Linkk 2 Link 3 Hope it'll help you Cheers!! Brij Check my latest Article :Exploring ASP.NET Validators

Refer this link below http://1diot.blogspot.com/2007/10/creating-subheader-in-gridview.html[^] LatestArticle :Log4Net Why Do Some People Forget To Mark as Answer .If It Helps.

Hi, I think if you do not need to edit,then you can change the text to div or other containers to display the HTML format.

Luc Pattyn wrote: the 'Œ' character (and eszet 'ß' and most accented characters used in Western languages) is part of code page 1252, whereas the French Franc and most other (possibly obsolete) monetary symbols are not. Not even the need for a CHCP 1252, since it gets stuffed into a unicode field. Question seems answered though, I'll wait for the repost :-D I are Troll :suss:

I don't see any code to commit the transaction ? Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Well, the problem is you cant get total as no data is stored within the Total, rather it holds only the Formula. Rather you have to calculate the total yourself in SQL. :rose: Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

What you would do is create a list of IDs that you want to delete and then use the Contains statement. Here's an example: List<int> list = new List<int>(); list.Add(5); list.Add(9); list.Add(58); list.Add(7); var result = from r in db.Role where list.Contains(r.ID) select r; I've just knocked this up in the Code Project textbox, so I apologise if the formatting isn't 100%. "WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes. My blog | My articles | MoXAML PowerToys | Onyx

There is one .cs for converting linq to datatable //.cs file using System; using System.Collections.Generic; using System.Text; using System.Reflection; using System.Data; public class LinqToDataTable { public static DataTable ObtainDataTableFromIEnumerable(System.Collections.IEnumerable ien) { DataTable dt = new DataTable(); try { foreach (object obj in ien) { Type t = obj.GetType(); PropertyInfo[] pis = t.GetProperties(); if (dt.Columns.Count == 0) { foreach (PropertyInfo pi in pis) { if (pi.PropertyType.Name == "Nullable`1") { string str = pi.PropertyType.FullName; str = str.Replace("System.Nullable`1", ""); str = str.Substring(str.IndexOf("System")); str = str.Substring(0, str.IndexOf(",")); dt.Columns.Add(pi.Name, str.GetType()); } else dt.Columns.Add(pi.Name, pi.PropertyType); } } DataRow dr = dt.NewRow(); foreach (PropertyInfo pi in pis) { object value = pi.GetValue(obj, null); dr[pi.Name] = value; } dt.Rows.Add(dr); } } catch (Exception) { dt = null; } return dt; } } //DataTable dtEmployees = LinqToDataTable.ObtainDataTableFromIEnumerable((IEnumerable)employees); now assign the datatable in dataview Padmanabhan

As your starting point DetailContext.Employees is probably a class I think you are in trouble. If you use a datatable/viw as your starting point and AsEnumerable then you can cast the result as a dataview. I do that in this article[^] These look promising[^] but I'll bet they all start from tables Never underestimate the power of human stupidity RAH

If your are using ASP.NET then you may use ~ (root) operator to resolve path with server controls. Save ~/images/xyz.jpg in database. However, you said "Is it possible to get back full path?". Yes you can: Use, Server.MapPath or Request.MapPath or MapPath method. eg. String fullpath=Request.MapPath("~/images/xyz.jpg"); or String fullpath=Request.MapPath("../images/xyz.jpg"); A DATAPOST COMPUTER CENTRE (K.V Prajapati)

Put this code in .aspx page <asp:DataList ID="dataListImages" runat="server" RepeatColumns="3" RepeatDirection="Horizontal" Width="100%" CellPadding="2" CellSpacing="0"> <ItemTemplate> <img alt="" src='<%#DataBinder.Eval(Container.DataItem, "Image_Path")%>' /> </ItemTemplate> </asp:DataList> In code behind .cs file private void BindDataList() { using (SqlConnection connection = new SqlConnection("Database=DOTNET;Server=HELLO-COMP;Integrated Security=SSPI")) { string queryString = "SELECT Image_Path FROM Image_Table"; SqlCommand command = new SqlCommand(queryString, connection); SqlDataAdapter da = new SqlDataAdapter(command); DataTable dt = new DataTable(); da.Fill(dt); dataListImages.DataSource = dt; dataListImages.DataBind(); } } protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindDataList(); } }

Hi, base one your code: protected void BindGrid() {   try   {      var employees = from e in DetailContext.Employees select new {e.Emp_Id,         e.Emp_Code, e.F_Name, e.L_Name, e.Designation };      GridView1.DataSource = employees;      GridView1.DataBind();                        }   catch (Exception ex)   {      throw ex;   } } you can add this from e in DetailContext.Employees orderby [columnfield] descending Hope this one can help. Thanks Hi, Please select Good Question if my answer are fit to your Question.

Something like this might help: EmployeesDetailsDataContext DetailContext = new EmployeesDetailsDataContext(); //check if there exists a record with the same First and Last Name bool exists = DetailContext.Employees.Any ( e => e.F_Name == txtFname.Text.Trim() && e.L_Name == txtLname.Text.Trim() ) if (exists) //display message else //insert record Regards, Syed Mehroz Alam My Blog My Articles Computers are incredibly fast, accurate, and stupid; humans are incredibly slow, inaccurate and brilliant; together they are powerful beyond imagination. - Albert Einstein

pranavcool wrote: while @@fetch_status = 0 set @topic = '' There you have it - that's the loop that executes. You need to put the statements in a block using begin and end. Regards, Rob Philpott.

hi see this http://www.codeproject.com/script/Forums/View.aspx?fid=1725&msg=2932578[^] Hope it Helps Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za

Asp.Net Validation Controls Open This URL jpsprince.blogspot.com/2009/02/aspnet-validation-controls.html

string country = ddlCountry.SelectedValue; IEnumerable regions = from reg in db.Regions where reg.Country == country orderby reg.Name select reg; ddlRegions.DataSource = regions; ddlRegions.DataBind();

This is a easy way, Just set grid view page index with that text box values. Before doing that, ensure that entered cound should be numeric and less or equal to total no of pages in grid view. Parwej Ahamad R & D with IIS 5.0/6.0