ASP.NET

Re: on the fly adding DataFormatString to a TableCell in a GridView

18-Mar-09 6:54

I have a strange problem (imho).

I have a gridview and in this gridview it is possible to have DateTime and Decimal objects.
In the database we have stored the format in which these fields should be showed like 'dd MMM yyyy HH:mm' for a DateTime.
But our customer wants to be able to change that formatstring in the database and in the gridview the new choosen formatstring should be applied after a refresh of the grid.

The issue is this.
In the OnRowDataBound event of the grid I call a Method to determine the original datatype of the cellvalue.
I can find that datatype in the DataRowView GetType. And if it is System.DateTime, I can put the value in a datetime object. But then...
How do I know which Cell in the GridView holds this DataRowView value so I could change the TableCell Text property with the value formatted to the formatstring which is found in the database ?

Extra problem:
the dataRowView[0] holds the DataKeyValue for the gridviewrow (needed when selcting or editing).
But tableCell[0] is not always dataRowView[1] because we do not always use all the fields in the dataRowView.

Or is there a better way to solve this?

tech60318-Mar-09 13:59

tech603

18-Mar-09 13:59

I would suggest setting the Date format as a user preference in your application as opposed to allowing the user to update the data in the database. This would be the easiest way to allow this change on your page and would also keep your database from having multiple date values. Here is an article that may assist you in setting up application/user settings.

http://msdn.microsoft.com/en-us/library/aa730869(VS.80).aspx[^]

Hope this helps.

Matthew Vass
QA Analyst
mvass@hostmysite.com
http://www.hostmysite.com?utm_source=bb[^]

Re: on the fly adding DataFormatString to a TableCell in a GridView

Herman<T>.Instance19-Mar-09 2:46

Re: on the fly adding DataFormatString to a TableCell in a GridView

19-Mar-09 2:46

Hello Matthew,
this is not what I am looking for.
There is only 1 setting for al users. It is not attached to user but to datatype.

Any one else who knows how to find the link between datarowview value and tablecell value and the filling on the fly of the dataformatstring of the gridview?

In Word you can only store 2 bytes. That is why I use Writer.

Herman<T>.Instance19-Mar-09 5:29

Problem with my windows service [modified]

19-Mar-09 5:29

Having it fixed

This is the trick
1. Determine for each gridviewcolumn its headertext
2. Determine for each cell in the row.cells if the cell.ContainingField.HeaderText equals the headertext found in the previous gridviewcolumn
3. If the value of an item in the array of the datarowview with (yeah I know it can be buggy) the cell.text value you have found it
Than determine the type of the dataRowView[x] and fill cell.text with the formatstring in the Database.

Anyone a better solution ?

see my code:

public static GridViewRow MaakGridViewRowOp(GridViewRow row)
{
    GridView grid = (GridView)row.NamingContainer;
    DataRowView dataRow = (DataRowView)row.DataItem;
    foreach (DataControlField column in grid.Columns)
    {
        foreach (DataControlFieldCell cell in row.Cells)
        {
            if (column.HeaderText.Equals(cell.ContainingField.HeaderText)
               && !String.IsNullOrEmpty(column.HeaderText))
            {
                //Start with 1 because 0 is DataKeyValue and not shown in GridView
                for (int celwaarde = 1; celwaarde < dataRow.Row.ItemArray.Length; celwaarde++)
                {
                    if (cell.Text.StartsWith(dataRow[celwaarde].ToString(),
                       StringComparison.OrdinalIgnoreCase))
                    {
                        if (dataRow[celwaarde].GetType().Equals(Type.GetType("System.DateTime")))
                        {
                            DateTime datum = Convert.ToDateTime(dataRow[celwaarde]);
                            cell.Text = datum.ToString(MSBNZBLL.ParameterString.
                                    SysteemParameters.GetParameterAsString("DatumTijdFormat"));
                        }
                        else if (dataRow[celwaarde].GetType().Equals(Type.GetType("System.Decimal")))
                        {
                            Decimal getal = Convert.ToDecimal(dataRow[celwaarde]);
                            cell.Text = getal.ToString(MSBNZBLL.ParameterString.
                                    SysteemParameters.GetParameterAsString("VerwerkteMetingFormat"));
                        }
                        else if (dataRow[celwaarde].GetType().Equals(Type.GetType("System.Int32")))
                        {
                            Decimal getal = Convert.ToDecimal(dataRow[celwaarde]);
                            cell.Text = getal.ToString(MSBNZBLL.ParameterString.
                                    SysteemParameters.GetParameterAsString("VerwerkteMetingFormat"));
                        }
                        else if (dataRow[celwaarde].GetType().Equals(Type.GetType("System.Int16")))
                        {
                            Decimal getal = Convert.ToDecimal(dataRow[celwaarde]);
                            cell.Text = getal.ToString(MSBNZBLL.ParameterString.
                                    SysteemParameters.GetParameterAsString("VerwerkteMetingFormat"));
                        }
                        else if (dataRow[celwaarde].GetType().Equals(Type.GetType("System.Int64")))
                        {
                            Decimal getal = Convert.ToDecimal(dataRow[celwaarde]);
                            cell.Text = getal.ToString(MSBNZBLL.ParameterString.
                                    SysteemParameters.GetParameterAsString("VerwerkteMetingFormat"));
                        }
                        break;
                    }
                }
            }
        }
    }
    return row;
}

In Word you can only store 2 bytes. That is why I use Writer.

gottimukkala18-Mar-09 6:30

gottimukkala

18-Mar-09 6:30

Hi

I am developing an windows service that sends email notifications to all not activated members and not published users. I tested my email notifications with a sample windows application but the same notifications are failing in my service. But I put all of the dlls in the same directory as my service exe file.

Here is the piece that fails:

SMPTServer = this.gs.SMTPServer;
if (userEmail != "" && userEmail != null)
{
//Send Email Notification
doXtop.Framework.Messaging.Message msg = new doXtop.Framework.Messaging.Message(); -- it fails here, but this works with my windows test application.
}

The service logged with "Object reference not set to an instance of an object."

Can any give me ideas, how can I solve this.

modified on Wednesday, March 18, 2009 12:47 PM

Herman<T>.Instance18-Mar-09 6:48

18-Mar-09 6:48

You might get the NUll reference because you first check if userEmail = ""

It is more wise to create the next IF

if (null != userEmail && !userEmail.Equals(String.Empty))

gottimukkala18-Mar-09 6:50

gottimukkala

18-Mar-09 6:50

Hi

I checked it, it was not problem in the line of code that I posted but its the problem with

doXtop.Framework.Messaging.Message msg = new doXtop.Framework.Messaging.Message();

This is strange. For me the following line of code is working but the above one is not working:

doXtop.Framework.Messaging.Message.SendEmail("info@doXtop.com", userEmail, subject, message, SMTPServer);

Herman<T>.Instance18-Mar-09 6:57

18-Mar-09 6:57

can/will you show the code of the messaging class?

gottimukkala18-Mar-09 7:05

gottimukkala

18-Mar-09 7:05

Here is the code of my messaging class:
public class Message : IDisposable
{
public Hashtable HtEmails;
public HttpContext Context;
public bool ThreadExecution = false;
public string From;
public string Subject;
public string SmtpClient;
public string Body;
public string EmailProvider;
public string Username;
public string FullName;
public string ActivationMessage;
public Guid UserId;
public GlobalSettings gs;
public Uri Url;
public string ApplicationPath;

public enum Box
{
Inbox,
Outbox
}

DataAccess _da;
DataSource _ds;

public Message()
{
_da = new DataAccess();
_ds = new DataSource(_da);
ConfigurationProvider cp = new ConfigurationProvider();
gs = cp.GlobalSettings;
}
public bool InsertMessage(string from, string to, string subject, string body, string senderIPAddress)
{
try
{
SqlParameter[] _params = {
new SqlParameter("@MessageId", Guid.NewGuid()),
new SqlParameter("@From", from),
new SqlParameter("@To", to),
new SqlParameter("@Subject", subject),
new SqlParameter("@Body", body),
new SqlParameter("@SenderIPAddress", senderIPAddress)
};

_ds.ExecuteNonQueryProcedureProxy("InsertMessage", _params);

return true;

}
catch (Exception e)
{
EventLog.WriteEntry("WideDocs", e.ToString(), EventLogEntryType.Error);
return false;
}
}
}

Herman<T>.Instance18-Mar-09 7:57

Listening for database updates in asp .net

18-Mar-09 7:57

I believe your problem is this:
public Hashtable HtEmails;
public HttpContext Context;
public bool ThreadExecution = false;
public string From;
public string Subject;
public string SmtpClient;
public string Body;
public string EmailProvider;
public string Username;
public string FullName;
public string ActivationMessage;
public Guid UserId;
public GlobalSettings gs;
public Uri Url;
public string ApplicationPath;

they are mostly null. Havent you forget the { get; set; } to use them as properties?

You do not use any of these publics in your class and you cannot set them from outside.

In Word you can only store 2 bytes. That is why I use Writer.

hardboy11118-Mar-09 5:00

hardboy111

18-Mar-09 5:00

Hi All,

I have a mysql database. I have a web portal in php where users can update personal information which is added and stored in the database. Im building another web app in asp .net which will feed from the same database.

Is there anyway of 'listening' for when updates occur in the database efficently from my asp .net web app?

Im not sure what the best approach is.

Any suggestions much appreciated.

Thanks

Mike

Re: Listening for database updates in asp .net

Abhijit Jana18-Mar-09 5:16

Re: Listening for database updates in asp .net

18-Mar-09 5:16

hardboy111 wrote:
Is there anyway of 'listening' for when updates occur in the database efficently from my asp .net web app?

As both the site are sharing the same database then why you are trying to listing? If there is any update in the database from PHP sites, when user refresh or reload the page in ASP.NET he will get the updated data.
Any specific reason to do that?

cheers,
Abhijit
CodeProject MVP

Yusuf18-Mar-09 6:15

Yusuf

18-Mar-09 6:15

hardboy111 wrote:
Is there anyway of 'listening' for when updates

what do you mean by 'listening'. The very nature of web application does not allow you to listen to events on the server, or does it.

One way to try is, since they are sharing the same database, in your asp.net you may want to use AJAX to check for updated periodically. This will be small and quick bursts of status checks. When you detect a change, hen you refresh your asp.net pages to fetch updated data.

Yusuf

Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]

Re: Listening for database updates in asp .net

hardboy11118-Mar-09 7:06

hardboy111

18-Mar-09 7:06

im using a COMET approach. Hence if a update occurs I want to be able to push the update down to the web browser without any request from the client.

Polling isnt what I want to do.

General Webparts Related Question.

mr_muskurahat18-Mar-09 4:21

mr_muskurahat

18-Mar-09 4:21

1) does webparts use sql server 2008 database??? with visual studio 2008?

2) if i use webparts then will i have to face some browser compatibility issues??

Government Dyal Singh College Lahore.

Re: General Webparts Related Question.

Abhishek Sur18-Mar-09 5:20

Abhishek Sur

18-Mar-09 5:20

Ans 1 .. No You can use any Database you want.

Ans 2. Webparts in Sharepoint runs best in IE. But you can create web parts that may run in other browsers too. Thats not a problem

Rose | [Rose]

Abhishek Sur

My Latest Articles
Basics on LINQ and Lambda Expressions

Create .NET Templates

Dropdownlist problem

khuzwayom18-Mar-09 4:19

khuzwayom

18-Mar-09 4:19

Hi All

Please help, here us the scenario.

I get Source and Source code from the database.
I assign Source to the Text property of the DropDownlist and I assign SourceCode to the Value property of the same DropDownList.

What I want to do is that when you select an item from the DropDownlist, I want take the Value for that Item and do some calculations and keep the selected item shown on the dropDownList.

The problem is that..if the selected item has something eg 2 for the Value the application works fine, but if the Value property for that item in null the dropdown display the first item in the list.
It should display the selected item..it only do this if there is something in the value property.

Here is my code, that populates the dropdownlis.

drpDepot.DataSource = ds;
drpDepot.DataTextField = "SourceName";
drpDepot.DataValueField = "SourceCode";
drpDepot.DataBind();
drpDepot.Items.Insert(0, new ListItem(string.Empty, string.Empty));

Please help, I don’t know what is the problem. Please help.

Thank you in advanced

Abhijit Jana18-Mar-09 4:35

18-Mar-09 4:35

khuzwayom wrote:
What I want to do is that when you select an item from the DropDownlist, I want take the Value for that Item and do some calculations and keep the selected item shown on the dropDownList.

Please put the code for this section.

cheers,
Abhijit
CodeProject MVP

khuzwayom18-Mar-09 4:43

khuzwayom

18-Mar-09 4:43

Hi

Thanx for the reply. Here is my code

_kilometers = Convert.ToDouble(txtKM.Text);
_value = drpDepot.SelectedValue.ToString().Trim();

if (_value != "")
{
_value4 = double.Parse(_value);
_transportCost = _kilometers * _value4;
lblMessage.Text = "Estimated Transport Cost is: £ " + _transportCost.ToString();
}

I suppose after finishing executing it should keep the Item selected displayed...

Abhijit Jana18-Mar-09 5:04

18-Mar-09 5:04

khuzwayom wrote:
_kilometers = Convert.ToDouble(txtKM.Text);
_value = drpDepot.SelectedValue.ToString().Trim();

if (_value != "")
{
_value4 = double.Parse(_value);
_transportCost = _kilometers * _value4;
lblMessage.Text = "Estimated Transport Cost is: £ " + _transportCost.ToString();
}

What ever you have to done in the else put.

 else
{
 // 
}

But still i am not able to understand where did you written the code means in which event you are loading the data and checking the value.

cheers,
Abhijit
CodeProject MVP

khuzwayom18-Mar-09 5:09

khuzwayom

18-Mar-09 5:09

Hi Abhijit

Thanx for the assitance.

I populate the Dropwdown in page_load

if (_value != "")
{
_value4 = double.Parse(_value);
_transportCost = _kilometers * _value4;
lblMessage.Text = "Estimated Transport Cost is: £ " + _transportCost.ToString();
}
else
{
lblMessage.Text = "The Source does not have a value"
}

If the execution got inside the if statement, it works fine, it does the calculation and keep the selected item displayed on the dropdown
but if it went ti the ELSe block, it displays the message but the dropdown displays the fisrt item which i sin index 0.

Abhijit Jana18-Mar-09 5:13