list view

Question

Hi frnds plz help me, I am displaying values fro database to listview through code by'listvw.datasource=ds', but i didnt get the values to be displayed in list view,

Glenn Sanchez · Answer

Sorry, listvw.DataBind(); would be the correct line. Do not forget the opening and closing parenthesis and a semi-colon as suggested by other members.

Kunal Vaishya · Answer

Dear Is it DataTable Or DataSet If Ds is DataSet Then try this listvw.datasource=ds.Table[0]; listvw.dataBind();

Glenn Sanchez · Answer

I think you have to call listvw.DataBind after setting the data source

Satyapriya Nayak · Answer

Hi Anil, For web application below code Code Untitled Page EmpID EmpName Empaddress Salary ' /> ' /> ' /> ' /> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace ListView_in_Asp.net { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; SqlDataAdapter sqlda; DataSet ds; string str; protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select * from employee"; com = new SqlCommand(str, con); sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds, "employee"); ListView1.DataMember = "employee"; ListView1.DataSource = ds; ListView1.DataBind(); con.Close(); } } } Thanks If this post helps you mark it as answer

Satyapriya Nayak · Answer

Hi Anil, Please mention it is a web or windows application.If it is a windows application then below is the code. Try this... Code using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Listview_display { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; OleDbDataAdapter oledbda; string str; DataSet ds; DataTable dt; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { listView1.Columns.Add("ID", 70, HorizontalAlignment.Center); listView1.Columns.Add("GRADE", 70, HorizontalAlignment.Center); listView1.View = View.Details; listView1.GridLines = true; listView1.BackColor = Color.Aqua; listView1.ForeColor = Color.Blue; OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from test Query"; com = new OleDbCommand(str, con); oledbda = new OleDbDataAdapter(com); ds = new DataSet(); oledbda.Fill(ds, "test Query"); con.Close(); dt = ds.Tables["test Query"]; int i; for (i = 0; i { listView1.Items.Add(dt.Rows[i].ItemArray[0].ToString()); listView1.Items[i].SubItems.Add(dt.Rows[i].ItemArray[1].ToString()); } } } } Thanks If this post helps you mark it as answer

anil john · Answer

then getting an error " Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman";mso-bidi-theme-font:minor-bidi;} Error 3 Only assignment, call, increment, decrement, and new object expressions can be used as a statement "

Ehtesham · Answer

In Asp.net listvw.datasource=ds.tables[0]; listvw.dataBind();

list view

Answers (7)