i have done sending gridview data as excel to mail, it is working fine
then i had 5 columns in gridview but i want to send 4 column instead of 5 column.
protected void Button1_Click(object sender, EventArgs e)
{
fn_AttachGrid(); // here calling function to send mail gridview data as excel format
}
[Code]....
I have a webpage that lists information about trucks and their map sections and whether the combination is active and will be used.
On the page I put a check box that says Show Only Active and marked the checked property as true by default. When the RowDataBound event fires I check to see if that checkbox is marked as true and if it is I check if the individual map sections are marked as active. If they are not active then I set the row visibility equal to false like below.
[code]....
dv = new DataView(table);
Table.Columns.Add("ID", typeof(string));
table.Columns.Add("Type", typeof(string));
table.Columns.Add("EmpName", typeof(string));
table.Columns.Add("Manager", typeof(string));
row = table.Rows.Add();
row["ID"] = result["ID"].ToString();
row["Type"] = result["Type"].ToString();
row["EmpName"] = result["EmpName"].ToString();
row["Manager"] = result["Manager"].ToString();
Then I am adding boundfield to gridview for all 4 columns. Now I want to check if "Type" column contain "Sales" thne do not show "Manager" columns. Let me know can I do this?
When you click on a button my program have to send a email where a report must be generated from table adapters from dataset. Now this report is not going to be displayed when the button is clicked, so it will be sent automatically by code which I have some part(see below). My questions are:
1. how can you generate or build a report without displaying it.
2.embeed this report or data collection from the table adapters as part of the body of the email
my email code so far is this:
mail.From = New MailAddress("qwerty@[URL]")
mail.To.Add(New MailAddress("qwerty@[URL]"))
mail.Subject = "test"
mail.Priority = MailPriority.Normal
Dim smpt As New SmtpClient
smpt.Host = [URL]
smpt.Port = 25
smpt.Credentials = New System.Net.NetworkCredential("qwerty@[URL]","****")) 'hehe not telling :P smpt.EnableSsl = True................
I have a table dt_details which includes columns - name, address, phone,emailid, website,remarks,paid.
In the datagrid i have to display full columns only if paid is yes and if paid is no only name & phoneno should display.How to do that ?
in asp.net page user able to select gridview Columns, and it will hide remaining columns and that selection done by check box with column list bellow is Image link , what exactly I am looking for [URL] it look bellow after selection of column done [URL]
View 1 RepliesI have an emergency request that I need to sort it out very quickly as I did not notice it early :(.
I have a dropdownlist, the contnet in the gridview (sqldatasource connection) changes based on the value the user slects, say I have play1, play2 from the dropdownlist, I would like to show column1, column2 and column3 with user selects play1; show column4, column5, and clomn6 when use selects play2; the datatable actually includes all 6 columns.
I understand that I need to use something like RowCreated event, and I need to set up condition based on the dropdownlist value, but I dont really know how to.
I am new to ASP.NET and have made a register page, 'get' which on submitting redirects to another page 'pick1' displaying the data in Gridview. In each row of the Gridview there are 'View' buttons which on clicking opens a pop-up page having 2 buttons 'send mail' and 'cancel'. On clicking 'send Mail' button, i want selected row of data to be sent by email instead of the entire gridview. Right now only the entire gridview data is coming to my mail. Also i want to attach a link to the email so that it redirects to the 'pick1' page again on clicking in email. How can I do it?
Below is my code for 'pick1' page:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.BindData();
[Code] ....
And the image of my 'pick1' and 'popup' page:
I have a table in my database called "Profiles". This holds data on Female and Male personal characteristics.On my aspx, I have a formview in edit mode which is binded to an object data source with a GetDataByUserId Select methodwhich retrieves data from the "Profiles" Table via a DAL.The "Profiles" table has some columns which relates to females only and some just males and some are generic to both.See example below
UserId - / of Type GUID
GenreId / of Type BOOL.
Hip Size (For females)
Dress Size ( For Females)
ChestSize (For Men )
TrouserSize (For Men)
Weight ( For both )
When the User logs in , they go to an update Page which has the Formview in Edit Item Mode and contains drop down Lists whichare binded to the Users Selected Value. The DDL are in turn bound to their related table such as HIP, Dress, Chest, Trouser etc.bjectiveIf a female user logs in I just want to show them the (Hip Size) DDL and DressSizeDDL in the Edit item template of the formview and not the ChestSize DDL or TrouserSize DDL.At present the GetProfileByUserId returns all colums from the tableMy question is how do I do this and just show DDL which are relevant to the Female or Male Only. In some cases the usermay not have selected an item in the previous form so they could also be NULL.Am i on the right path by writing a Select Query that checks to see if the User is Male or Female by checking the Genre column in Profiles first.Do I also need 2 panels, 1 to hide Female DDLS and the other to Hide MaleDDLs subject to logged in user genre.
I have 5 column, in first two column read only id in hidden field, but in UI first two column shows empty,this two column in UI does not show only show remaining three column, then how to hide first two column using css ...
View 1 RepliesI want to hide some of the columns of the gridview before printing.
For example gridview contains customerid,city and postal code.
Now i want to show city and postal code during printing.
So how can i achieve this?
My grid view will display the data like below..
Id Name Mark1 Mark2 Mark3
1 aaa 50 30 20
2 bbb 50 30 30
3 ccc 50 30 20
if mark3 has all fields with 0 means i want to hide column mark3. How to do this..
My question is how to freeze specifi columns of Gridview control ? Freeze means...for example say if we are freezing the first column of grid then on scrolling a horizontal scroll bar of the grid will scroll all columns other than the first column. That means the first column will be visible always without any movement. But the first column should move if we use the vertical scroll bar.
View 1 RepliesHow to disable editing the data in the cells of datagridview in c#?
View 1 RepliesI have a Gridview and I want to hide a column when empty. The code works then the column is in Boundfield but not in Templatefield. Can anyone show me the code of how to do it in Templatefield?
Here's my code using OnDataBound event:
protected void hideColumn(object sender, EventArgs e)
I need to send an email in asp.net but I need sender appears like "MySiteName" without info@[URL] need to send an email in asp.net but I need sender appears like "MySiteName" without info@[URL]
View 4 RepliesHow can I send GridView in Email Message.
View 5 Replieshow to send email with database contents?
View 1 RepliesI have gridview that contains a check box, messageId and firstName. The gridview is getting information from the database and showing them in the gridview and in a checkbox. The gridview shows the fields that are selected and that are not selected. I want to send an email to all people that the check box is selected.
I have already created the email system and it is working. What I don't to know is how to get the information from the gridview and place in the mail.To.Add(?); so I can send the information to all people into the database.
---.aspx showing the gridview---
[Code]....
--CODE BEHIND IN C#---
[Code]....
I am updating a gridview. Problem is that when I hide certain fields that I do not want the user to update, they lose their values ie. the data is wiped out in the field unless I show them on the grid and make them writeable. Is there a property I need to set for the field to retain the value when the grid is updated or is this in the sql statement?
View 7 Repliesi am sending email to the users using smtp client and MailMessage class.
i have been adding the addresses of multiple receivers in the to property of the object of MailMessage class. the problem is that the receiver can see the email addresses of other receipents. is there any way to hide the email addresses of other receipents.
i mean setting some property or something like that. otherwise i will be left with only option to send individual email to the users.
Currently I have something like this, but when I click "update" the record doesn't get updated (but no error is returned).
[Code]....
how can I show button for specific user and hide it for another one based on security role in ASP.NET MVC 2.
For example if I have Create button in my view how to show it only for admin and hide it for any other user.
Protected Sub SQLDShowActionRef_Selected(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles SQLDShowActionRef.Selected
View 4 Repliesidnamaimage
2
perda
file/tutorial.pdf
1
gdfgg
file/Doc1.docx
How to show link view file in gridview using asp.net ....