ASP.NET

30-Mar-07 0:30

In gridview I have 3columns.. DoctorId,name and VisitDate.. I am binding data from database. but during runtime I don't want to diaply doctorid.
for this I have put code in pageload event like this:

GVDoctorActivity.Columns[0].Visible = false; ok. its fine. when I am trying to get the doctorid of selected row it is showing null.. when I put Visible= True am getting the value. I have written code in GridviewSElectedrowchanged event..

<asp:GridView ID="GVDoctorActivity" runat="server" AutoGenerateColumns="False" DataKeyNames="DoctorActivityId"
DataSourceID="DoctorActivityDataSource" SkinID="GridView"
EnableViewState="False" OnSelectedIndexChanged="GVDoctorActivity_SelectedIndexChanged"
<Columns>
<asp:BoundField DataField="DoctorId" HeaderText="DoctorId" SortExpression="DoctorId" />
<asp:BoundField DataField="DoctorName" HeaderText="Doctor Name" SortExpression="DoctorName" />
<asp:BoundField DataField="VisitDate" HeaderText="Visit Date" SortExpression="VisitDate" />

protected void GVDoctorActivity_SelectedIndexChanged(object sender, EventArgs e)
{

string strCampaign;
string DoctorId;
LinkButton LbtCampaign;
int rowIndex = GVDoctorActivity.SelectedIndex;
DoctorId =Convert.ToInt32(GVDoctorActivity.SelectedRow.Cells[0].Text); // getting null here if DoctorId visible is false..
LbtCampaign = (LinkButton)(GVDoctorActivity.SelectedRow.Cells[4].FindControl("lbtnCampaign"));
strCampaign = LbtCampaign.Text;
}

help me..
Thanks.

Sun Rays30-Mar-07 1:03

30-Mar-07 1:03

u have this..

irkahc wrote:
<asp:gridview id="GVDoctorActivity" runat="server" autogeneratecolumns="False" datakeynames="DoctorActivityId"
="" datasourceid="DoctorActivityDataSource" skinid="GridView" enableviewstate="False" onselectedindexchanged="GVDoctorActivity_SelectedIndexChanged" <columns="">
<asp:boundfield datafield="DoctorId" headertext="DoctorId" sortexpression="DoctorId">
<asp:boundfield datafield="DoctorName" headertext="Doctor Name" sortexpression="DoctorName">
<asp:boundfield datafield="VisitDate" headertext="Visit Date" sortexpression="VisitDate">

in datakey u can bind doctorID and then when retreiving data

GVDoctorActivity.Datakeys(Seletedrow.index).value.tostring; to get ID.

Thanks,
Sun Rays

irkahc30-Mar-07 1:13

30-Mar-07 1:13

but the datakey is DoctorAcitvityId not DoctorId... I want to get non datakey name values and those are not visible in Gridview..

<asp:GridView ID="GVDoctorActivity" runat="server" AutoGenerateColumns="False" DataKeyNames="DoctorActivityId"
DataSourceID="DoctorActivityDataSource" SkinID="GridView" Font-Size="10pt" Width="920px"
EnableViewState="False" OnRowCommand="GVDoctorActivity_RowCommand">

Sun Rays30-Mar-07 1:20

30-Mar-07 1:20

irkahc wrote:
GVDoctorActivity.Columns[0].Visible = false;

if it's working fine then after binding data to grid u can make it false.

Thanks,
Sun Rays

irkahc30-Mar-07 1:47

30-Mar-07 1:47

Pls see the code:
Page_Load()
{
GVDoctorActivity.Columns[0].Visible = false; //DoctorId
}

protected void GVDoctorActivity_RowCommand(object sender, GridViewCommandEventArgs e)
{
int DoctorID;
DoctorID = Convert.ToInt32(GVDoctorActivity.SelectedRow.Cells[0].Text); // throwing exception here.bcoz it is returning null value..
}

irkahc30-Mar-07 2:56

asp.net with excel and oracle

30-Mar-07 2:56

Yes correct. now working..I gave that after binding. Thank you verymuch Sun Rays..

chitra8130-Mar-07 0:14

chitra81

30-Mar-07 0:14

hi i have a web application in which i am allowing the user to upload an excel file on my server. i want this excel file to be stored directly in my oracle server.it's not just the file. i would like to insert row by row data in my table.can anyone help me in that. pls send me the code to do this. i am making my application in visual studio 2005, .net framework 2.0 and oracle server 10g.
thanks

cant send email with link to CSS file

iuliuz29-Mar-07 23:50

iuliuz

29-Mar-07 23:50

Cant send email with link to CSS file.
When mail server receives new letter, he clears out all "style" attributes from mail content plus replace the link to CSS file ().

Please anybody help ASAP.

Re: How to Identify which dataitem has been clicked in a Gridview?

gauthee29-Mar-07 23:20

gauthee

29-Mar-07 23:20

You can write your logic in datagrid_itemcommand event!
Give two seperate command names for your link buttons.
In your event you can give - if(e.commandname="lnkbtn1").....
do your coding accordingly.

Hope this helps!

Gautham

Same post this many times ??

Sun Rays29-Mar-07 23:10

How to Identify which dataitem has been clicked?

29-Mar-07 23:10

hi, u can modify your post if u have missed something.. dont post same thing again and again..

Thanks,
Sun Rays

Calendar Control Problem

rachitdamani29-Mar-07 23:04

rachitdamani

29-Mar-07 23:04

I need help regarding ASP Calendar control. I am developing one web page in which I am displaying a calendar (month view) using ASP Calendar control.

And I am displaying jobs on particular day. i.e. if job starts on March 1 then I will have to display that job on March 1 cell and so on.

Now what I need to do is to display a bar in the calendar as per the start date and end date of the particular job. i.e. if job starts on March 1 and ends on March 5 then I will have to display a bar starting from March 1 to March 5 and that particular job number on this bar just like Google Calendar. When we create an event in Google Calendar from one date to another date, you will get to see one bar displaying from one date to another date.

irkahc29-Mar-07 22:59

Re: How to Identify which dataitem has been clicked?

29-Mar-07 22:59

In a Gridview there are two templated linkbutton columns. I want to know that on which link(dataitem) the user has clicked.. data is bounded from database... Can any one help me?
pls see the code..

<asp:gridview id="GVDoctorActivity" runat="server" autogeneratecolumns="False" datakeynames="DoctorActivityId"
="" datasourceid="DoctorActivityDataSource" skinid="GridView" font-size="10pt" width="920px" enableviewstate="False" onselectedindexchanged="GVDoctorActivity_SelectedIndexChanged">
<columns>
<asp:boundfield datafield="DoctorId" headertext="DoctorId" sortexpression="DoctorId" visible="True">
<asp:templatefield headertext="Campaign Name">
<itemtemplate>
<asp:linkbutton commandname="Select" id="lbtnCampaign" runat="server" causesvalidation="false" text="<%# Eval("CampaignName")%>"
="" <="" asp:linkbutton="">

<asp:templatefield headertext="ProductName">
<itemtemplate>
<asp:linkbutton commandname="Select" id="lbtnCampaign" runat="server" causesvalidation="false" text="<%# Eval("ProductName")%">

The user may click on any one either on CampaignName or ProductName dataitem... I want to know on which item the user has clicked...? I am using asp.net 2.0 and C#

Sun Rays29-Mar-07 23:07

Re: How to Identify which dataitem has been clicked?

29-Mar-07 23:07

hi,
for that u have to set property of that linkbutton set commandName="CampaignName" and for second one commandName="ProductName" and gridview's rowcommand event get which command is fire...

Thanks,
Sun Rays

irkahc29-Mar-07 23:14

Re: How to Identify which dataitem has been clicked?

29-Mar-07 23:14

ok thanks. the message has been posted many times. sorry for this inconvenience bcoz of some connection problems...

irkahc29-Mar-07 23:34

Re: How to Identify which dataitem has been clicked?

29-Mar-07 23:34

Hi Sun Rays the code you sent is working fine but it is not meet my requirement. My requirement is in Grideview-SelectedIndexChanged event I have to find out.. pls see the code

protected void GVDoctorActivity_SelectedIndexChanged(object sender, EventArgs e)
{

string strCampaign;
LinkButton LbtCampaign;
int rowIndex = GVDoctorActivity.SelectedIndex;
LbtCampaign = (LinkButton)(GVDoctorActivity.SelectedRow.Cells[4].FindControl("lbtnCampaign"));
strCampaign = LbtCampaign.Text;

lbProducts.DataSource = adapterCampaignDrug.GetProductsByCampaignId(1);
lbProducts.DataTextField = "SKU";
lbProducts.DataBind();

Panel3.Visible = true;
MultiView1.ActiveViewIndex = 0;

}

in this event am getting the perticular column data item. if i put this code in rowcommandevent it is giving error... so in this eventonly i want to know which itemhas been clicked.. can you tell me how I can approach?

Sun Rays29-Mar-07 23:55

Re: How to Identify which dataitem has been clicked?

29-Mar-07 23:55

u can do this i have vb.net code

If e.CommandName = "comm1" Or e.CommandName = "comm2" Then

Dim row As GridViewRow
row = CType(CType(e.CommandSource, WebControl).Parent.Parent, GridViewRow)

If row IsNot Nothing Then
Dim lbtn As LinkButton
lbtn = CType(row.FindControl("lbtn"), LinkButton)

irkahc wrote:
LbtCampaign = (LinkButton)(GVDoctorActivity.SelectedRow.Cells[4].FindControl("lbtnCampaign"));

for this u can write this,,

LbtCampaign = CType(row.Cells[4].FindControl("lbtnCampaign"), LinkButton)

End If
end if

Thanks,
Sun Rays

irkahc30-Mar-07 0:17

Re: How to Identify which dataitem has been clicked?

30-Mar-07 0:17

HI Sun Rays pls send me the code in c#. while converting this line of code
row = CType(CType(e.CommandSource, WebControl).Parent.Parent, GridViewRow)

from vb.net to c# am getting problems..

Thanks

irkahc30-Mar-07 0:52

Re: Controlling Page Load

30-Mar-07 0:52

ok I got solution for that one...the equavalant code is

row = (GridViewRow)((WebControl)e.CommandSource).Parent.Parent;

thanks Rays.

Controlling Page Load

Mel Padden29-Mar-07 22:52

Mel Padden

29-Mar-07 22:52

I was just wondering, does anyone know of a way to programmatically control page loading in .NET?

The reason is this. I'm using an open-source text editor control in a private project of mine for content management, where users can edit whole pages and save them to the database, to be approved and displayed later on the front of the site. The control is brilliant, really powerful, but it takes a while to load, and it looks really disjointed when it's doing so, as the page appears like a swiss cheese coming at you out of the mist... I've had a stab at it myself and asked the good men at Google, but no joy so far. Ideally I would set a point, like after the page header, and not display anything to the user until the entire page has loaded, so that it looks more, well, slick. Anybody have any ideas? Confused | :confused:

All the dude ever wanted... was his rug back.

badgrs30-Mar-07 1:38

badgrs

30-Mar-07 1:38

Off the top of me head:
It would be easy to cover the page with a shim that has a nice Web 2.0 animated AJAX loading image (buzzword dump all the way!). This could be done with CSS so the rest of the page would be set to display:none while the shim would fill the whole page (or whatever portion it is you need hidden). You could then set the shim to display:none and display the hidden content once the control is loaded and ready.
The problem is knowing when this happens. document.onload wouldn't work as I assume thats where the control starts loading. The simplest option would be to set a timeout of how long it roughly takes for the control to load, then show the content, but this has loads of drawbacks as you never really know what the time will be.
So after all that it boils down to: does the control have an event that you can hook into that gets raised when the controls loads? If so, use that to hide the shim and show the content.

How to Identify which dataitem has been clicked?

irkahc29-Mar-07 22:51