从数据库中向Accordion控件显示记录 [英] Showint the records to Accordion control from the database
问题描述
我的代码如下;
private SQLDAL SCon = new SQLDAL（）;
private DataTable dt = new DataTable（）;
private DataSet ds = new DataSet（）;
String Sql;
protected void Page_Load（object sender ，EventArgs e）
{
if（！Page.IsPostBack）
{
试试
{
getdata（）;
}
catch（Exception ex）
{
LblErr.Text = ex.ToString（）;
返回;
}
}
}
public SqlConnection con = null;
private string himtConnectionString =Data Source = india; connect timeout = 120; Initial Catalog = sample;
public void Bindcon（）
{
con = new SqlConnection（）;
con.ConnectionString = himtConnectionString;
if（con.State == ConnectionState.Closed）
{
con.Open（）;
}
}
private void getdata（）
{
尝试
{
SCon.Bindcon（）;
Sql =从类别按类别从Tb_Staff_Doubt_Register组中选择类别;
SqlDataAdapter adp = new SqlDataAdapter（Sql，SCon.con）;
DataSet ds = new DataSet（）;
adp.Fill（ds）;
Accordion1.DataSource = ds.Tables [0] .ToString（）;
Accordion1.DataBind（）;
}
catch（例外情况）
{
LblErr.Text = ex.ToString（）;
返回;
}
}
源页面代码如下
< ajax：Accordion ID =Accordion1HeaderCssClass = accordionHeaderHeaderSelectedCssClass =accordionHeaderSelected
ContentCssClass =accordionContentrunat =serverSelectedIndex =0FadeTransitions =true
SuppressHeaderPostbacks =trueTransitionDuration =250FramesPerSecond =40
RequireOpenedPane =falseAutoSize =None>
< ajax：AccordionPane ID =AccPan1runat =server>
< Header>
- < / Header>
-
< ajax：AccordionPane ID =AccPan2runat =server>
< Header>
- < / Header>
-
显示手风琴控制的数据来自数据库。
当我运行手风琴窗格时显示
。在该窗格中数据不会显示在数据库中。
来自我上面的代码我犯了什么错误。请帮帮我。
问候，
narasiman P.
My code as follows;
private SQLDAL SCon = new SQLDAL();
private DataTable dt = new DataTable();
private DataSet ds = new DataSet();
String Sql;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
try
{
getdata();
}
catch (Exception ex)
{
LblErr.Text = ex.ToString();
return;
}
}
}
public SqlConnection con = null;
private string himtConnectionString = "Data Source=india;connect timeout = 120; Initial Catalog=sample;
public void Bindcon()
{
con = new SqlConnection();
con.ConnectionString = himtConnectionString;
if(con.State == ConnectionState.Closed)
{
con.Open();
}
}
private void getdata()
{
try
{
SCon.Bindcon();
Sql = "select category from Tb_Staff_Doubt_Register group by category order by category";
SqlDataAdapter adp = new SqlDataAdapter(Sql, SCon.con);
DataSet ds = new DataSet();
adp.Fill(ds);
Accordion1.DataSource = ds.Tables[0].ToString();
Accordion1.DataBind();
}
catch (Exception ex)
{
LblErr.Text = ex.ToString();
return;
}
}
source page code as follows
<ajax:Accordion ID="Accordion1" HeaderCssClass="accordionHeader" HeaderSelectedCssClass="accordionHeaderSelected"
ContentCssClass="accordionContent" runat="server" SelectedIndex="0" FadeTransitions="true"
SuppressHeaderPostbacks="true" TransitionDuration="250" FramesPerSecond="40"
RequireOpenedPane="false" AutoSize="None">
<ajax:AccordionPane ID="AccPan1" runat="server">
<Header>
--</Header>
--
<ajax:AccordionPane ID="AccPan2" runat="server">
<Header>
--</Header>
--
displaying the data to accordion control from the database.
when i run the accordion panes is displayed. in that pane data are not displayed from the database.
from my above code what is the mistake i made. please help me.
regards,
narasiman P.
推荐答案
private string himtConnectionString =Data Source = india; connect timeout = 120; Initial Catalog = sample;
更改为
private string himtConnectionString = "Data Source=india;connect timeout = 120; Initial Catalog=sample;
Change to
private string himtConnectionString = "DataSource=india;ConnectionTimeout=120; Initial Catalog=sample;"
Sql =从类别按类别从Tb_Staff_Doubt_Register组中选择类别;
更改为
Sql = "select category from Tb_Staff_Doubt_Register group by category order by category";
Change to
Sql = "select category from Tb_Staff_Doubt_Register group by category";
修改上述更改你的代码。
谢谢和问候，
Anand.G
Modify the above changes in your code.
Thanks & Regards,
Anand. G
这篇关于从数据库中向Accordion控件显示记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
