By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,424 Members | 1,402 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,424 IT Pros & Developers. It's quick & easy.

datagrid

P: n/a
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;
Nov 16 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Bind a Table or DefaultView in DataGrid from getSurveyDetail DataSet instead
of binding DataSet.

--
Regards,
Amal
http://geocities.com/techsharing
"aylin_sk" wrote:
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;

Nov 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.