I'm trying to list my data into my datagrid creating stored procedures in
oracle db..My data includes questions for a survey....It's simple but i cant
see my datagrid in my web form..I'm now going to send all my codes...Please
help me finding an exact solution...
private void Page_Load(object sender, System.EventArgs e)
{
if (Page.IsPostBack)
return;
if (Request.QueryString["centerId"]!=null)
bindMySurvey(Int32.Parse(Request.QueryString["centerId"].ToString()));
}
private void bindMySurvey(int centerId)
{
coreMarseg.clinicalTrials mySurvey = new coreMarseg.clinicalTrials();
coreMarseg.Units myUnit = new coreMarseg.Units();
DataSet myDataSet = mySurvey.getSurvey(centerId);
comboCenterName.DataSource =
myUnit.getUnitName(Int32.Parse(Request.QueryString["centerId"].ToString()));
comboCenterName.DataTextField = "UNIT_NAME";
comboCenterName.DataValueField = "UNIT_ID";
comboCenterName.DataBind();
textRowId.Text = myDataSet.Tables[0].Rows[0]["ROWID"].ToString();
comboCenterName.SelectedIndex =
comboCenterName.Items.IndexOf(comboCenterName.Item s.FindByValue(myDataSet.Tables[0].Rows[0]["S_CENTER_ID"].ToString()));
textCenterResponsible.Text =
myDataSet.Tables[0].Rows[0]["S_CENTER_RESPONSIBLE"].ToString();
textCenterResponsibleTitle.Text =
myDataSet.Tables[0].Rows[0]["S_CENTER_RESPONSIBLE_TITLE"].ToString();
textCenterResResponsibility.Text =
myDataSet.Tables[0].Rows[0]["S_CENTER_RES_RESPONSIBILITY"].ToString();
bindMyDataGrid(Int32.Parse(Request.QueryString["centerId"].ToString()),
Int32.Parse(Request.QueryString["questionId"].ToString()));
}
private void bindMyDataGrid(int centerId, int questionId)
{
coreMarseg.clinicalTrials mySurvey = new coreMarseg.clinicalTrials();
myDataGrid.DataSource = mySurvey.getSurveyDetail(centerId, questionId);
myDataGrid.DataBind();
}
private void Save_Click(object sender, System.EventArgs e)
{
this.Validate();
if (Page.IsValid)
{
coreMarseg.clinicalTrials mySurvey = new coreMarseg.clinicalTrials();
if ((Request.QueryString["centerId"]==null) ||
(Request.QueryString["centerId"]==""))
{
if (mySurvey.addSurvey(comboCenterName.SelectedItem.V alue,
textCenterResponsible.Text,
textCenterResponsibleTitle.Text, textCenterResResponsibility.Text))
{
myError.Visible = false;
}
else
{
myError.Visible = true;
((Label)myError.FindControl("labelError")).Text =
mySurvey.myError.getLastError();
}
}
}
---------------
<asp:datagrid id="myDataGrid" runat="server" Font-Size="Smaller"
Font-Names="Verdana" Width="979px"
AllowSorting="True" CellPadding="1" CellSpacing="1"
AutoGenerateColumns="False" BorderColor="Gray">
<SelectedItemStyle CssClass="selectedGridRow"></SelectedItemStyle>
<EditItemStyle CssClass="defaultGridEditItem"></EditItemStyle>
<AlternatingItemStyle
CssClass="defaultGridAlternatingRow"></AlternatingItemStyle>
<ItemStyle CssClass="defaultGridRow"></ItemStyle>
<HeaderStyle CssClass="defaultGridHeader"></HeaderStyle>
<Columns>
<asp:TemplateColumn HeaderText="Questions">
<HeaderStyle HorizontalAlign="Center" Width="400px"></HeaderStyle>
<ItemStyle HorizontalAlign="Left" Width="400px"></ItemStyle>
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem,"QUESTION_DESC" )%>
<asp:TextBox id="textQuestionId" runat="server" Visible="False"
Text='<%# DataBinder.Eval(Container.DataItem,"QUESTION_ID")% >'>
</asp:TextBox>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Yes">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
<ItemTemplate>
<asp:CheckBox id="cbYes" Checked="True"
runat="server"></asp:CheckBox>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="No">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
<ItemTemplate>
<asp:CheckBox id="cbNo" runat="server"></asp:CheckBox>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Comments">
<HeaderStyle HorizontalAlign="Center" Width="50px"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" Width="50px"></ItemStyle>
<ItemTemplate>
<asp:Textbox id="textComment" runat="server"
CssClass="defaultTextItemLeft" Width="400" MaxLength="1024"
TextMode="MultiLine" Rows="1"></asp:Textbox>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid>
----------------
public DataSet getSurvey (int centerId)
{
OracleConnection myConnection = new
OracleConnection(myRegistry.getRegistryValue("conn ectionString"));
myConnection.Open();
OracleCommand myCommand = myConnection.CreateCommand();
myCommand.CommandText = "MEDICAL.TRIALS_PKG.GET_SURVEY";
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(new OracleParameter("resultset",
OracleType.Cursor)).Direction = ParameterDirection.Output;
OracleDataAdapter adapter = new OracleDataAdapter(myCommand);
myCommand.Parameters.Add("p_s_center_id", OracleType.Number).Value = centerId;
DataSet myDataSet = new DataSet();
adapter.Fill(myDataSet);
myConnection.Close();
return myDataSet;
}
public DataSet getSurveyDetail (int centerId, int questionId)
{
OracleConnection myConnection = new
OracleConnection(myRegistry.getRegistryValue("conn ectionString"));
myConnection.Open();
OracleCommand myCommand = myConnection.CreateCommand();
myCommand.CommandText = "MEDICAL.TRIALS_PKG.GET_SURVEY_DETAIL";
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(new OracleParameter("resultset",
OracleType.Cursor)).Direction = ParameterDirection.Output;
myCommand.Parameters.Add("p_sd_center_id", OracleType.Number).Value =
centerId;
myCommand.Parameters.Add("p_sd_question_id", OracleType.Number).Value =
questionId;
OracleDataAdapter adapter = new OracleDataAdapter(myCommand);
DataSet myDataSet = new DataSet();
adapter.Fill(myDataSet);
myConnection.Close();
return myDataSet;
}
------------------------------------------
procedure GET_SURVEY (resultset out globals.resultset, p_s_center_id in
number)
is
begin
open resultset for
select S_CENTER_ID, S_CENTER_RESPONSIBLE, S_CENTER_RESPONSIBLE_TITLE,
S_CENTER_RES_RESPONSIBILITY
from MEDICAL.SURVEY
where S_CENTER_ID = p_s_center_id;
end;
---------------------------
procedure GET_SURVEY_DETAIL(resultset out globals.resultset, p_sd_center_id
in number)
is
begin
open resultset for
select * from MEDICAL.SURVEY_DETAIL
where SD_CENTER_ID = sd_center_id
order by SD_CENTER_ID, SD_QUESTION_ID;
end;
