Comments by RmcbainTheThird (Top 52 by date)

EI 11

Tried it both checked and unchecked, no deal still can't debug using IE

ms access sql

Well it was unchecked. so I checked it and then unchecked and now F5 works... whow knows?

Can you show the markup for the label? For example on one of my aspx pages I have a label defined as <asp:label id="lblGreeting" runat="server"> and in the code behind I can assign a value thusly: lblGreeting.Text = prefName + "!";

Have you written the all the rows back to the db? Did you refresh your dt collection? inquring minds want to know

So when you run that query raw in the db what do you get back?(pet peeve #1 about linq)

It may be required but what is the justification? What will changing the property names accomplish? What problem will it solve?

Oops gotta learn to read gooder

same result. and I do have a breakpoint set on the first line of code

So what are the inputs valid or invalid and how are they used? What do they have to do with the sql query?

How are you dealing with the problem of two different people working on their local copy of the file at more or less the same time? Who ever saves first is going to lose their changes when the other person saves their copy.

why aren't you setting textBox4.Text = parts[1]?. also there is a real strong assumption that the project name does not have spaces in it. Is that true? If so how do you know that is the case?

What type of security are you using? If it is integrated then it may be the user using the app does not have rights to the db.

Solution three will not even compile

Don't know myself but Google told me about this
https://code.visualstudio.com/docs/editor/tasks#_custom-tasks

Yes that would have been nice but I assume that anyone who has managed to find this site must be able to use google..or am I being to optimistic :)

By constant string do you mean:
private const string PARENT = "parent";

Not at all I agree that sorting is expensive and in retrospect the for loops is a better solution. I have stopped worrying about cpu cycles and running out of memory since I left c some 20 years ago and got on the .net bandwagon. Makes a man lazy.

If you don't sort then that means you are going to have to use a for loop twice, once to find the largest number and then a second time to find the next largest.

Why are you marking the transaction object as shared?

along with sample data a schema would help

Let's see your schema and your insertion code

Let me see if I understand this. somewhere in windows you have copied something to the clipboard. in your application you want whatever you have in the clipboard to appear in the textboxes. and you want this to happen when.....?

ok here is an example from one of my projects. I am going to assume that MySQL and sqlserver have similar layouts
public bool UpdateInfoCenter(InfoCenterParent icData)
{
bool retVal = true;
string sqlStr = "UPDATE [dbo].[InfoCenterParent]"
+ " SET[ListOrder] = @ListOrder"
+ ",[DisplayText] = @DisplayText"
+ ",[Description] = @Description"
+ ",[ImageFile] = @ImageFile"
+ ",[ChildDisplayOrder] = @ChildDisplayOrder"
+ ",[LastUpdatedBy] = @LastUpdatedBy"
+ " WHERE ID = @icID";
List<sqlparameter> parameters = new List<sqlparameter>
{
new SqlParameter {ParameterName = "@icID", SqlDbType = SqlDbType.Int, Value = icData.ID},
new SqlParameter {ParameterName = "@ListOrder", SqlDbType = SqlDbType.Int, Value = icData.ListOrder},
new SqlParameter {ParameterName = "@DisplayText", SqlDbType = SqlDbType.VarChar,Value = icData.DisplayText},
new SqlParameter {ParameterName = "@Description", SqlDbType = SqlDbType.VarChar,Value = icData.Description},
new SqlParameter {ParameterName = "@ImageFile", SqlDbType = SqlDbType.VarChar,Value = icData.ImageFile},
new SqlParameter {ParameterName = "@ChildDisplayOrder",SqlDbType = SqlDbType.VarChar,Value = icData.ChildDisplayOrder},
new SqlParameter {ParameterName = "@LastUpdatedBy", SqlDbType = SqlDbType.VarChar,Value = icData.LastUpdatedBy}
};
try
{
retVal = true;
DataAccess.ExecuteSQL(_connStr, sqlStr, parameters);
}
catch (Exception ex)
{
retVal = false;
FrameworkLogger.Error("Failed to upadte infocenter parent", null, ex);
}
return retVal;
}
this is the method DataAccess.ExecuteSql:

public static void ExecuteSQL(string connStr, string sqlStr, List<sqlparameter> parameters = null)
{
try
{
//using (new Impersonator("ZS9ADAU", "Corp", pword))
{

using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqlStr, conn);
if (parameters != null)
{
cmd.Parameters.AddRange(parameters.ToArray());
}
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
FrameworkLogger.Error("Failed to execute sql staement ", null, ex);
throw ;
}
}

In that case you will need to look at what they type in and if it is a number then your where clause will be [Product Code]=@d1 and if they type in text the where clause be [Product Name] = @d1. You will need to use the same logic to decide how to declare your parameter. But you will not have a where clause with an OR in it.

Are you talking about logging into the application or logging into windows? Are you asking about logging for one application or all applications the user may be using?

Where is the Excel file located?

Can you show us the markup for the label?

Sounds like the traveling salesmen problem but with trains

Does your db tables include as lastUpdated and a UpdatedBy column ? If so then this work would be better done by a scheduled job that scans your db for updated records and send out emails

Well the rebinding works but I was never able to get a value that would allow me to identify the one gridview I was editing in and rebind that one. I ended up having to rebind ALL the nested gridviews. I am going to stick a fork in it and call it done

True the row does not have an ID but it does have columns and what I need to do is get the value of one of those columns when adding a child row We have a one to many relationship between the data in the parent/top gridview and the child/nested gridview. When the parent row has one or more child records(the nested gridview) and I want to add addition rows/records I can get the value of the column that defines that relationship by getting the value of gvBulletItems.DataKeys[0].Value. gvBulletItems being the child gridview and the sender parm on the RowComandEvent. However if there are no rows in the childgridview then for whatever reason gvBulletItems.DataKeys[0] is null. I need to get the data stored in one of the columns (the unique ID)of parent row that defines the relationship between the parent gridview and the new row I am adding to the child gridview.

yes I am. is that an oopsie :)

yes, that is how I am grabbing the value

thank you Vincent. This works My big mistake was assuming that the OnRowDataBound event was only called once( the Row part of the event name should have been a hint :) )

In the snippet I provided what is the value of cnt when the loop is exited?

Yes that was the issue. For what ever reason I had inserted a validatorcalloutextender in my page that was not needed. but I was so focused on the popup thing Ihad my blinders on.

There is no javascript in the app.

Well double checked both thoughts all good. and besides while trying to get this to work I added an event to the code behind to do the same thing and no problem there finding the divs( have I mentioned that I hate javascript)

for (int idx = 1; idx <= 7; ++idx)
{
HtmlControl div = cp.FindControl(divName + idx) as HtmlControl;
Button btn = (Button) cp.FindControl(btnName + idx);

if (idx != id)
{
btn.CssClass = "tabdiy button";
div.Visible = false;
}
else
{
btn.CssClass = "tabdiyactive";
div.Visible = true;
}
}

Yes I have and the GetelementbyID always returns a null even though I can see the name of the element in the developer tools and it matches what is in the javascript method

The code is executed on a button click so everything is rendered before the method is executed
<asp:Button class="tabdiy tablink tabwidth" CommandArgument="2" OnClientClick="openLink(event, 'Tab2')" ID="btnDIY2" runat="server">

I have looked at the rendered code and the id matches what I am building in the javascript. and the Ids I am building in the javascript match the rendered html. most aggravating

And indeed it was programmer error :) found in the head of my aspx file: <base target="_blank"/>

That is what I thought as well. It is all in the code behind ... no ajax no JS of any kind
protected void MenuClick(object sender, System.EventArgs e)
{
Button clickedButton = (Button) sender;
//Response.Redirect(clickedButton.CommandArgument,true);
// WebUtilities.OpenSameWindow(clickedButton.CommandArgument);


//Server.Transfer(clickedButton.CommandArgument);
}

public static void OpenSameWindow(string url)
{
string cmd = @"window.open('{0}','_self',false);";

System.Web.HttpContext.Current.Response.Write(string.Format(cmd, url));
}

Sorry no, I spend enough time writing my own code and am not willing to do yours for free. If you are unsure how to get a connection string from your config file, open a database, query the database, build an insert query with the data from the first query then you need to pick up a book or hit Google to understand and utilize these concepts.