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; 1 3755
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;
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: pei_world |
last post by:
I want to implement a key hit with enter to dropdown a combobox that is in
the datagrid. in this case I need to override its original behaviours. I
found some codes from the web. Does anyone know...
|
by: Rick |
last post by:
Hello all, I hope all is well with you.
I am having a seriously difficult time with this problem. Allow me to
set
up the problem.
I have a System.Web.UI.Page with the following controls...
|
by: Richard Ryerson |
last post by:
Hello all, I hope all is well with you.
I am having a seriously difficult time with this problem. Allow me to set
up the problem.
I have a System.Web.UI.Page with the following controls (watch...
|
by: CSL |
last post by:
I am using the DataGrid in a Windows Application, how can
I adjust the widths of each column individually.
|
by: Dave |
last post by:
Are there any add-on products or samples available that can do the following
in an vb.net datagrid
I want to compare 2 rows in a datagrid - one row from one database and
another row for another...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |