how to put 'x' in date field in gridview - ASP.NET Discussion Boards

Hi friends,
I have created a NUnit plugin and testing giving the connection and stored procedure
The tests works fine for sp refering single table under the condition the test method passes all the paramters in th stored procedure.Issue arises when my sp refers two tables and when both tables have common column name
ERROR: Duplicate name(column name)occurs.
Is there anyway to solve this issue??

Thanks In Advance,
praveen

Go to right column for better answer Hmmm | :|

Anand Desai
Developer
Atharva Infotech

Hi Anand,
Thanks for the suggestion .But in my case the Stored procedure refer to both the tables and iam not priviledged to change the stored procedure.

Thanks,
praveen

This is not ASP.NET Question.. go to right forum

Anand Desai
Developer
Atharva Infotech

[Message Deleted]

Dont repost ur question !!!

Anand Desai
Developer
Atharva Infotech

onClick = "window.open (this.href, 'popupwindow','width=850,height=700,scrollbars,resizable');return false;">

this is mine, make your code the same and see if that works

i am using .net 2005.i do my project in asp.net.
My project title is master log attendance.
our project is mainly used for see the employee attendance details.
i want vb.net or C# code for,how to put 'x' at date field in gridview.
here 'x' means present.
date field will displayed as what we select from date and to date.
i am using 2 tables.first table name as emp_details contain 2 field names as emp_id,emp_name.
second table name as attendance contain 2 field names as emp_id,date.
employees are put attendance daily.
in web form i keep emp_name,from date,to date.
i select emp_name,from date and todate.
in following example i use dash(-) for space.
for (ex):
in emp_details table,
values are
emp_id---emp_name
--11-------ashok
--12-------ramu
in attendance table,
values are
emp_id----date
--11-----05-06-08
--11-----06-06-08
--11-----09-06-08
--12-----05-06-08
--12-----07-06-08

i select emp_name as ashok,from date as 05-06-2008,to date as 09-06-2008 means
i want to display 'x' in date available in table for that selected name as ashok in gridview as follow.

emp_id--name----05-06-2008---06-06-2008 --07-06-2008 --08-06-2008 --09-06-2008
---11----ashok------------x----------------x---------------------------------------------------x

here no 'x' for 07-06-2008 and 08-06-2008 for ashok.because no date(07-06-2008 and 08-06-2008 ) for id of ashok in attentance table.that means he is absent.

i select emp_name as all emp_name,from date as 05-06-2008,to date as 09-06-2008 means
i want to display 'x' in date available in table for that particular name in grid view as follow
emp_id--name---05-06-2008---06-06-2008 --07-06-2008 --08-06-2008 --09-06-2008
---11---ashok------------x-----------------x---------------------------------------------------x
---12---ramu-------------x--------------------------------x

here no 'x' for 07-06-2008 and 08-06-2008 for ashok.because no date(07-06-2008 and 08-06-2008 ) for id of ashok in attentance table.that means he is absent.
like wise no 'x' for 06-06-2008,08-06-2008 and 09-06-2008 for ramu.because no date(06-06-2008,08-06-2008 and 09-06-2008) for id of ramu in attentance table.that means he is absent.
i want vb.net or C# code for to put x in date field in grid view.
so how to put 'x' in date field in grid view.if employee present.

Are you using any GridView inbuild features Like Paging,Sorting... etc ?
If no then you should not user Griview for this purpose
Repeater control is best for displaying the data.
There you can have your won type of colouns and you can show the things as you want.
For example in these scenario create a user control which will common for each row
This user control will be your item template
You can show as you want.

Else create a Custom Control here you will get more power as you will be resposible for rensering all HTML content in the Page

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

Check My Blog

I find using a pivot query easiest. Then the database takes care of the work.
Examples on pivot queries here[^]

In an aspx page,I am opening a child page through client side window.open() function. When I close the child page, the parent page must be submitted. How would i do? A snippet of code if available plz pass on.

Note: I tried openning the child page using window.open(). I also tried using window.showModalDialog(). While using showModalDialog,another child page is opened, when i close the child page.

Thanks in advance,

Muthu

window.parent.reload();

In ASP.Net2.0 there is a property called AutoCompleteType. It is a bool property. I am using ASP.NET 1.0 where this property is not available. What to do if need to incorporate the property.I need to avoid auto completion of text. Plz advice me. Frown | :(

Muthu

Well logic would suggest that if it isnt in asp.net 1.0, you wont be able to use it.
You really should upgrade your version of asp.net anyway

There is no change of upgrading the version, as the whole development is done in version1.0. Is there a possibility to avoid at client side?

Muthu

Check this might help you
TExtBoxID.Attributes.Add( "autocomplete", "off" );

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

Check My Blog

Thanks works fine buddy.
But when the textboxes are directly placed on the form, there is no problem. But if textboxes are used with DataGrid,[textbox is bound with grid] then the method is a flaw.

Because during run time, the records are inserted in grid. Thus textbox is not bound with the property. Plz advice me.
thanks.

Muthu

i am using .net 2005.i do my project in asp.net.
My project title is master log attendance.
our project is mainly used for see the employee attendance details.
i want to put 'x' at date field in datagrid.
here 'x' means present.
date field will displayed as what we select from date and to date.
i am using 2 tables.first table name as emp_details contain 2 field names as emp_id,emp_name.
second table name as attendance contain 2 field names as emp_id,date.
employees are put attendance daily.
in web form i keep emp_name,from date,to date.
i select emp_name,from date and todate.
in following example i use dash(-) for space.
for (ex):
in emp_details table,
values are
emp_id---emp_name
--11-------ashok
--12-------ramu
in attendance table,
values are
emp_id----date
--11-----05-06-08
--11-----06-06-08
--11-----09-06-08
--12-----05-06-08
--12-----07-06-08

i select emp_name as ashok,from date as 05-06-2008,to date as 09-06-2008 means
i want to display 'x' in date available in table for that selected name as ashok.
emp_id--name----05-06-2008---06-06-2008 --07-06-2008 --08-06-2008 --09-06-2008
---11----ashok------------x----------------x---------------------------------------------------x

here no 'x' for 07-06-2008 and 08-06-2008 for ashok.because no date(07-06-2008 and 08-06-2008 ) for id of ashok in attentance table.that means he is absent.

i select emp_name as all emp_name,from date as 05-06-2008,to date as 09-06-2008 means
i want to display 'x' in date available in table for that particular name.
emp_id--name---05-06-2008---06-06-2008 --07-06-2008 --08-06-2008 --09-06-2008
---11---ashok------------x-----------------x---------------------------------------------------x
---12---ramu-------------x--------------------------------x

here no 'x' for 07-06-2008 and 08-06-2008 for ashok.because no date(07-06-2008 and 08-06-2008 ) for id of ashok in attentance table.that means he is absent.
like wise no 'x' for 06-06-2008,08-06-2008 and 09-06-2008 for ramu.because no date(06-06-2008,08-06-2008 and 09-06-2008) for id of ramu in attentance table.that means he is absent.

Seems pretty straight forward to me. What's your actual question?

How to poop up a Calender Control in an aspx page and after selecting a date from that calender, this value will go to the parent page's text box

thanks in advance
Deepika

DeepikaAggarwal wrote:
How to poop up a

mistype...

there are plently of articles out there to help you on this.
Your question is too vague to try and explain how to do each aspect

DeepikaAggarwal wrote:
How to poop up a Calender Control in an aspx page

window.open('myPage.aspx','Title',........)

Put calendar control on myPage.aspx and write belove code on SelectionChanged event of calendar control

  protected void Calendar1_SelectionChanged(object sender, EventArgs e)
    {
      
            Response.Write("<script language="javascript">opener.document.getElementById('YourParentTextBoxID').value='" + Calendar1.SelectedDate.ToShortDateString() + "'; self.close();</script>");
}

please don't forget to vote on the post that helped you.

Hi there,

I've just done some work to update a web project and at deployment time i moved it to a 2k3 server box. I've been getting loads of Interop errors and I don't seem to be able to get to the bottom of what's causing them. This is the error message:

System.Runtime.InteropServices.COMException: Creating an instance of the COM component with CLSID {6D52994B-FDB5-4E5F-96DA-C243B8B42CF5} from the IClassFactory failed due to the following error: 800a0030.

Just to check that i had deployed everything, I published the project to the old server and registered the new version of the dll and it runs fine on that machine.

Is there a security issue with running com components out of iis these days? I've done a fair few searches for things like "asp iis interop security" etc and don't seem to get anything back.

Any help would be greatly appreciated,

Russell

I don't know much about COM Exceptions but error message 800a0030 usually means that the application is busy. I don't know about error code
6D52994B-FDB5-4E5F-96DA-C243B8B42CF5.
You can check following things
1. Reboot the server and start the application, If you get same error open Task Manager and check all process might be your COM process is running.
2. Might be the COM dll you are using in the application is not properly installed in this server.

Are you using EXCEL Object ?

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

Check My Blog

Thanks for your answer.

6D52994B-FDB5-4E5F-96DA-C243B8B42CF5 is the guid for the com component that i'm trying to call. It's registered properly and a registry search for the clsid shows the correct path to the dll.

I've tested a few methods on the dll by using vbscript on the desktop and it works fine, it's just the IIS environment where it doesn't work. Rebooting the server isn't an option

I'm not using Excel