Anyone knows how to manage the delivery report information?

Of course, I know. If I had *@codeproject.com blocked in my email config I didnt receive any email, and the problem is: sometimes I receive (when someone replies to a question (created by me), and sometimes I dont.

In advanced apologise me if that bug in on bug list, the only I saw related is the bug "voting should send notifications". I confirmed some days ago my email address, but still dont receive all email notifications (answers and comments on posted threads). Some days I receive, others dont. If I had to guess I'll say I receive about 20% email notifications I should receive. Can I do something ?

I'm trying something similar to this: http://msdn.microsoft.com/en-us/library/ms838165.aspx[^] I used that code to handle de editing:

private void grdOrders_CurrentCellChanged(object sender,
System.EventArgs e)
{
if (!inUpdateMode)
{
if (inEditMode && !grdOrders.CurrentCell.Equals(editCell))
{
// Update edited cell
inUpdateMode = true;
grdOrders.Visible = false;
DataGridCell currentCell = grdOrders.CurrentCell;
grdOrders[editCell.RowNumber, editCell.ColumnNumber] =
txtEdit.Text;
grdOrders.CurrentCell = currentCell;
grdOrders.Visible = true;
inUpdateMode = false;
txtEdit.Visible = false;
inEditMode = false;
}

// Enter edit mode
editCell = grdOrders.CurrentCell;
txtEdit.Text = (string)grdOrders\[editCell.RowNumber,
  editCell.ColumnNumber\];
Rectangle cellPos = grdOrders.GetCellBounds(editCell.RowNumber,
  editCell.ColumnNumber);
txtEdit.Left = cellPos.Left - 1;
txtEdit.Top = cellPos.Top + grdOrders.Top - 1;
txtEdit.Width = cellPos.Width + 2;
txtEdit.Height = cellPos.Height + 2;
txtEdit.Visible = true;
inEditMode = true;

}
}

But I'm having a problem. I dont know what to put on Form1 Design so I'm getting the error: txtEdit does not exist on current context. Can you please help me ?

I dont need what ?

hisen wrote:

You should use DataGrid. It has edit, insert and delete function itself.

Thanks! Should I save information with SQL Server CE or XML ? Can you please point me to information where I can learn to do those operations?

I need to display information from MS SQL table, and I need to have edit, insert and delete options. What should I use? ListView? DataGrid..? Or another ?

Hello, Can anyone explain me how to build ListView from SQL Query? (MS SQL Server)

When I use "Add a new Data Source" to add my database to my application I get the message "Could not retrieve schema information for table or view..." after I click Finish to Choosing the Database Objects (tables). In "Data Sources" I see the tables in the database but I cannot see the fields. If I right-click on a table and click "Preview Data", I can see all the data in the table. It's strange because I already did a function where I can see if table exists or not and it works perfectly, so I'm only having problems creating the dataset...

modified on Monday, November 30, 2009 3:06 PM

Thank you guys I was just curious about the reason but now I understand :)

N a v a n e e t h wrote:

This is how identity columns works.

There is not a way that usually there's no way do alter value of the primary key. So I suppose thats not possible to do something around that, am I right?

I have a table with field ID int IDENTITY(1,1) (primary key) So lets say I have only two elements, with ID=1 and ID=2. So if admin (id=1) remove element where ID=2 and then add a new element, I will have an element with ID=3 and not with the ID=2. (so table will have two elements one with id=1 and another with id=3 instead id=2) Why this happens?

Christian Graus wrote:

Have you set breakpoints to see if your data here is persisted or if it's lost ?

Could you recommend where to set breakpoints? I am not doing breakpoints but I'm using Response.write in many places to know where of there's any data not executed. But I think I know the problem: with the solution in my second post (after sort grid disappears), looks like cant sort temporary table... maybe I should use another temp table ?

Christian Graus wrote:

Are you using viewstate, or is it turned off ?

public DataTable Temp
{
get
{
object o = ViewState["Temp"];
if (o == null)
{
DataTable dt = new DataTable();
return dt;
}
else
return (DataTable)o;
}
set
{
ViewState["Temp"] = value;
}
}

Have I answered to your question? If not I'll try again.

Christian Graus wrote:

Have you done any sort of debugging ? What have you found ? Why don't you use descriptive variable names ?

I have found nothing.. I forgot to present my exact problem: if I run with the code in first post, and I try to sort, it happens nothing. With the "solution" of my second post, when I sort the Gridview disappears. What is exactly descriptive variable names? Can you give an example?

Rather Use DataView dataView = dataTable.DefaultView Maxdd 7 wrote: Session["data"] = dt; Why do you need Session to store datatable. .. D'Oh! D'Oh! D'Oh! Also what exactly the problem is? Check Page_Load, if you have set DataSource and DataBind for every page postback.. You should filter out using if(IsPostBack)

Yes, in fact Session["data"] its nothing ;P My temp table is loaded this way: if (!Page.IsPostback) TempTable(); So I suppose I set DataSource and Databind just one time.. but its strange because if I do if(Page.Ispostback) my gridview does not appears... Your advice, DataView dataView = dataTable.DefaultView, should I apply it in the code of my first post ( DataTable dataTable = GridView3.DataSource as DataTable; ) or the second one ? (DataTable dataTable = Temp as DataTable;) I tried with both but the problem still exists.. (first does not happen nothing, second disappear :( Dont know else to do... Thanks for your help!

modified on Tuesday, November 24, 2009 4:50 PM

I tried to work around this:

DataTable dataTable = Temp as DataTable;

    if (dataTable != null)
    {
        DataView dataView = new DataView(dataTable);
        dataView.Sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection);

        Temp.AcceptChanges();
        GridView3.DataSource = dataView;
        GridView3.DataBind();

but it not working. When I try to sort, the GridView disappears. I think I not seeing the way datatable works (or its not even necessary), so if anyone can give me an hint, I appreciate very much.

I have a big GridView (with, edit,update,delete and insert operations),(forgive all this code, I cant present my problem other way :(( The template field is like this: (the gridview has OnPageIndexChanging="GridView3_PageIndexChanging" OnSorting="GridView3_Sorting" AllowSorting="True" properties)

<asp:TemplateField HeaderText="Nome" SortExpression="Nome">
<EditItemTemplate>
<asp:TextBox ID="txtname" runat="server" Text='<%# Bind("Name") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblname" runat="server" Text='<%# Bind("Name") %>'></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtNName" runat="server" width="75px" Visible='<%# (bool) show_hide_insert() %>'> </asp:TextBox>
</FooterTemplate>
</asp:TemplateField>

The Grid View is populated this way:

public void TempTable()
{
DataTable dt = new DataTable();
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("Name", typeof(String));
dt.Columns.Add("Year", typeof(String));

// i've erased some colummns here

    dt.Columns.Add("Image", typeof(String));



    Session\["data"\] = dt;
    Temp = dt.Copy();

// query. ...

    DataSet ds = GetData(query);
    GridView3.DataSource = ds;
    GridView3.DataBind();

}

DataSet GetData(String queryString)
{

    string connectionString;
    connectionString = WebConfigurationManager.ConnectionStrings\["ConnectionString1"\].ConnectionString;
    DataSet ds = new DataSet();

    try
    {
     
        SqlConnection Conn = new SqlConnection(connectionString);
        SqlDataAdapter adapter = new SqlDataAdapter(queryString, connectionString);
        adapter.Fill(ds);

    }
    catch (Exception ex)
    {
        Response.Write(ex.Message);

    }

    return ds;
}

public DataTable Temp
{
get
{
object o = ViewState["Temp"];
if (o == null)
{
DataTable dt = new DataTable();

Abhishek Sur wrote:

<% =Session["nome"] as string %> instead of <% Response.Write(Session["nome"].ToString()); %>.

That way gives the same error. Maybe you are all right, I really should remove that. I was trying do that because I had a problem using LoginView:

<asp:LoginView id="logview" runat="server">
<LoggedInTemplate>
Welcome <asp:LoginName id="txtUserName" runat="server"/>

</LoggedInTemplate>

</asp:LoginView>

The problem is: since the login name is email ID, (and the name of the user is another field in DB), it appears something like "Welcome tmm@yahoo.com"

Christian Graus wrote:

Response.Write is idiocy in this context. Just remove it.

I havent asked you if its idiocy or not. I asked you if there is a alternative or solution.

I have a GridView where I can export to excel file. In the beginning of the page where gridview is, I have the following:

<b>Bem vindo <% Response.Write(Session["nome"].ToString()); %>!</b>

Now I've tested the export funcionality again, and having the following error: The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>). I googled about it, and looks like because Response.write does not allow the export encoding operation perform correctly, so I commented that line, and now its working again. So I'm wondering, I really want to use that line. How do I do it? Is it possible? Many thanks.