.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

baptism by fire

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server

Well, I have very little experience with MS SQL, but some basic knowledge of SQL by way of other platforms. My first troubleshooting duty is to debug a stored procedure.

The error I am getting back:

_doQuery: [Error message: Could not execute statement] [Last executed query: exec gf_DY_Reports_Goal @verbo = 1, @goalID =684] [Native code: 0] [Native message: Sep 30 2010 12:00AM]

For starters, what does [Native code: 0] mean?

Secondly, it appears that SQL thinks that Sep 30 2010 12:00AM is not a valid date?


View Complete Post

More Related Resource Links

Ho to fire the Application Error in asax from the code?


 Hi All,

I have this code in Global.asax but it not firing once an error occured:


void Application_Error(object sender, EventArgs e)



        // Get the error details

        HttpException lastErrorWrapper = Server.GetLastError() as HttpException;

        Exception lastError = lastErrorWrapper;

        if (lastErrorWrapper.InnerException != null)

        lastError = lastErrorWrapper.InnerException;



        string lastErrorTypeName = lastError.GetType().ToString();

        string lastErrorMessage = lastError.Message;

        string lastErrorStackTrace = lastError.StackTrace;



Please help me so I can call this method from any page?

Thaxxxxxxxxxxxxx a lot,



Modal does not fire up


Hi I have following functional code that works on one machine but not the other.  Could some one provide me with the trouble shooting techniques for jQuery, I have used alert and it fires even a the last statment.

<link href="Content/Themes/cupertino/jquery-ui-1.8.1.custom.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="Scripts/athenajs/jquery-1.4.2.min.js"></script>
 <script type="text/javascript" src="Scripts/athenajs/jquery-ui-1.8.1.custom.min.js"></script>

$(function () {

                title: "my title",
                modal: true,
                height: 500,
                width: 500,
                autoOpen: false,

EventReceiver does not fire for other users than Administrator


Hi all

My code adds a EventReceiver to some SPLists. When I log into Sharepoint as Administrator, then the EventReciever is fired.

When i log in as an other user, it does nothing.


My current code is this:

string assm = "Minimizer, Version=" + FileVersionInfo.GetVersionInfo(Root.Res.DLL).FileVersion + ", Culture=neutral, PublicKeyToken=d2d19387a15c363f";
          string cls = "MinimizerPlugin.Minimizer";
          l.EventReceivers.Add(SPEventReceiverType.ItemUpdated, assm, cls);
          l.EventReceivers.Add(SPEventReceiverType.ItemAdded, assm, cls);

What can I do to register this EventReceiver to all users?

Thanks for your help!!

jquery click event doesn't fire after postback anymore

Hello there,I have a small website where I want to display a confirmation dialog after clicking on a button.When you click the confirmButton the dialog appears. Then you can choose between Yes or No to either continue with the PostBack or to return.Problem: The first time you get into the site all works fine. But after you click Yes to continue with the PostBack, no click event will be triggered anymore.Here is some code.<asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <script type="text/javascript"> function loadConfirmDialog() { //Dialog configurieren jQuery('#confirmDialog').dialog({ autoOpen: false, width: 400, modal: true, resizable: false }); //Dialog öffnen jQuery('#confirmButton').bind('click', function () { jQuery('#confirmDialog').dialog('open'); return false; }); //Postback ausführen jQuery('#continueButton').bind('click', function () { jQuery('#confrimDialog').dialog('destroy'); __doPostBack('confirmButton', ''); }); //Postback abbrechen jQuery('#cancel

Custom event does not fire

Hello,I have a base server control class for all my user controls. Inside this class I have the following declaration:#region Event Handling Management public event EventHandler ItemSaved; public event EventHandler ItemCancelled; protected virtual void OnItemSaved(EventArgs e) { if (this.ItemSaved != null) { this.ItemSaved(this, e); } } protected virtual void OnItemCancelled(EventArgs e) { if (this.ItemCancelled != null) { this.ItemCancelled(this, e); } } #endregion Concrete user controls used in the application are used always inside a ModalPopupExtender object and the popup it is always handled with server-side code. This means that there are no controls binded to the OkControlID and CancelControlID properties of the ModalPopupExtender.The responsibility to show the Modal Popup is then given to the aspx that has code like thisin the ASPX file...<gsl:PhoneNumberUC ID="ucPhoneDetail" runat="server" />in code behind...protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //Bind to the event handler ucPhoneDetail.ItemSaved += new EventHandler(ucPhoneDetail_ItemSaved); ucPhoneDetail.ItemCancelled += new EventHandler(ucPhoneDetail_ItemCancelled); } } protected void btnNewPhone_Click(object sender, EventArgs e) { //Show the Modal Popup this.mpePopupPhone.Show(

Can't get target of BindingOperations.SetBinding to actually fire its bindings.

Let's say I have a user control named 'MyControl'. MyControl is used in a Window as follows: <MyControl SelectedName="{Binding Target, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}" > ... </MyControl> The SelectedName property in MyControl is a dependency property that's declared as follows: public static readonly DependencyProperty SelectedNameProperty = DependencyProperty.Register("SelectedName", typeof(string), typeof(MyControl), new PropertyMetadata(string.Empty)); public string SelectedName { get { return (string)GetValue(SelectedNameProperty); } set { SetValue(SelectedNameProperty, value); } } Within MyControl is a TreeView and I want to bind the TreeView's SelectedItem's Name property to MyControl's SelectedName (we can assume that a selected item will always have a name) . To do that, I've added the following in MyControl's constructor: public CubeAssetsTreeViewControl() { InitializeComponent(); var treeViewSelectedItemBinding = new Binding("SelectedItem"); treeViewSelectedItemBinding.ElementName = "myControlTreeView"; treeViewSelectedItemBinding.Mode = BindingMode.OneWay; var treeViewSelectedItemNameBinding = new Binding("SelectedItem.Name"); treeViewSelectedItemNameBinding.ElementName = &

get url from server and fire event

i want to open new window ,but i dont want to provide url link in script because i want to hide this link from user.so is there any method to get URL from server and fire event to open new window after cliking button which has some server logic on that basis serever return URL. 

Services takes forever to fire up....

Is there some magic way to keep the services alive?...I think IIS keeps shutting it down and when I make a call I have to wait like 10-15 seconds for it to respond :/

How to Fire events on SharePoint DateTime Control in visual web part

Hi All, I am working on visual webpart of SharePoint 2010. I am using a <SharePoint:DateTimeControl> i m trying  to fire OnDateChanged event on it. I am not getting the Appropriate way to create the event. please help me out!!!!   void ToDate_OnDateChanged(object sender, EventArgs e)         {                         if (ToDate != null)             {                 DateTime min = Convert.ToDateTime(FromDate.SelectedDate.ToString());                 DateTime max = Convert.ToDateTime(ToDate.SelectedDate.ToString());                 int noofdays = Convert.ToInt32((max - min).TotalDays);                 txtNoOfDays.Text = noofdays.ToString();             }         }    <SharePoint:DateTimeControl runat="server" Calendar="Gregorian"  

Cannot get Asyncfileupload to fire UploadComplete event... :(

hey everyone!I cannot get the asyncfileupload to fire the uploadcomplete event at all. I did a test:    Protected Sub AsyncFileUpload1_UploadedComplete(ByVal sender As Object, ByVal e As AjaxControlToolkit.AsyncFileUploadEventArgs) Handles AsyncFileUpload1.UploadedComplete         Dim currentUser As MembershipUser = Membership.GetUser()         Dim currentUserId As Guid = CType(currentUser.ProviderUserKey, Guid)         errorLabel.Text = "Test"     End Sub    Protected Sub AsyncFileUpload1_UploadedComplete(ByVal sender As Object, ByVal e As AjaxControlToolkit.AsyncFileUploadEventArgs) Handles AsyncFileUpload1.UploadedComplete       errorLabel.Text = "Test"    End Suband... nothing. The background turns green, my throbber activates successfully.. but then, I get nothing. It doesnt even make it to the uploadedComplete event. I also did the same test in the error event.. and still nothing. Any ideas??

GridView EditTemplate DropDownLists' Loads fire before SelectedIndexChanged events on AutoPostBack=

My GridView allows EditTemplate but no DataSource in the aspx page. I set the DataSource & DataBind in code behind. My problem is with 2 of the 4 DropDownLists: they require AutoPostBack=true b/c the load of ddlDptmtGrid is dependant on the selection from ddlOrgGrid, and the load of ddlPosGrid is dependant on the selection from ddlDptmtGrid. The problem lies in that every postback calls each ddl's load & then the SelectedIndexChanged event, by this point the SelectedValue has been reset or wiped. And i can't use "if (!IsPostBack) { }" b/c the initial click of the lnkEditBtn is a postback & the DropDownLists don't even exist till in Edit Mode, so i need this initial load. But it appears on every postback all the controls in Edit mode are wiped & re-initialized, so it forces each DDL to be re-declared & re-loaded, but then the SelectedValue (which caused the postback) cannot be remembered?<asp:GridView ID="gridPendRoles" runat="server" CellPadding="5" AutoGenerateColumns="False" BackColor="#CCFFFF" BorderColor="Black" BorderStyle="Solid" onrowdeleting="gridPendRoles_RowDeleting" onrowediting="gridPendRoles_RowEditing" onrowcancelingedit="gridPendRoles_RowCancelingEdit" onrowupdating="gridPendRoles_RowUpdating"

DataGrid Button + event in Footer, event not getting fire!

hi.First Time i am trying this...I have one Datagrid with Footer. Footer Row Contains Input fields with one Button to add New Values. I have button click event but not getting fires. my code follows:protected void dgPrice_ItemCreated(object sender, DataGridItemEventArgs e)    {            Button btnAdd = new Button();            btnAdd.Text = "Add";            btnAdd.Width = 80;            btnAdd.ID = "btnAdd";           // btnAdd.Attributes.Add("onClick", "return validateRates()");            btnAdd.CommandName = "add";            btnAdd.CommandArgument = e.Item.ItemIndex.ToString();            btnAdd.Command +=new CommandEventHandler (PriceNew);            e.Item.Cells[6].Controls.Add(btnAdd);}protected void PriceNew(object sender, EventArgs e)    {}btnAdd.command/ btnAdd.click event not getting fired I also tried to

OnItemCommand event won't fire

My formview OnItemCommand event . What do I need to do to capture this event?  <asp:FormView ID="fvMemberDetail" runat="server" DataKeyNames="Ident" EnableViewState="False" OnItemUpdating="fvMemberDetail_OnUpdating" OnItemCommand="fvMemberDetail_ItemCommand" OnItemInserting="fvMemberDetail_OnInserting" >  protected void fvMemberDetail_ItemCommand(object source, FormViewCommandEventArgs e) { if (e.CommandName.ToString() == "Insert") { MemberInfoInserting(); DlMembers.Visible = true; fvMemberDetail.Visible = false; } if (e.CommandName.ToString() == "Update") { MemberInfoUpdating1(); DlMembers.Visible = true; fvMemberDetail.Visible = false; } } Thanks for your suggestions. EJM

ImageButton does not fire

Hi.I have the following image button:<asp:ImageButton ID="submit" EnableViewState="true"                                   ImageUrl="/images/btn_submit.png" AlternateText="Submit" CssClass="f-right"                                 runat="server" onclick="submit_Click"></asp:ImageButton>The event is fired in Firefox but not in IE*. anyone any ideas?ThanksJason.

SSRS custom security extension behind a router fire wall not working

I have a instance of SSRS 2008 installed (we are not using IIS) with custom security extension which accepts a application user ID and password and sends back a sql authorization cookie back to client for logging into SSRS.  The (SSRS) server is behind a router,  SSRS is configured on port 81,  Port 81 in router if forwarded to the SSRS server. Here is the problem If I am inside the router firewall (RDP'ed to the machine) I am able to access report server (http://xx.xxx.xxx.xx:81/ReportServer) and reports manager (http://xx.xxx.xxx.xx:81/Reports) without any issues. If  am outside the firewall and try to go to report server page (http://xx.xxx.xxx.xx:81/ReportServer) from browser and try to login it works (I am getting the cookie back and authentication goes through fine).   But if I try to access reports manager (http://xx.xxx.xxx.xx:81/Reports) the login page shows up when I enter user ID and password and hit enter to authenticate it comes back to the login screen (I am not gettint the cookie back from SSRS). Any help is highly appreciated on how to debug /fix this issue. Note : if I first login to Reportserver (which sends the cookie back) and in the same session I login to Reports Manager I am able to get into Reports Manager page since I got the cookie when I logged in to reports server page already.  When I

1st PostBack only: SelectedIndexChanged events fire AND GridView & ReadOnly controls disappear

On initial load of the page, everything is visible & runs correct. On the first PostBack fired by any one of my DDLs, RadioBtns, LinkBtns that have the AutoPostBack=true property, then ddlPriority_SelectedIndexChanged & ddlPendUserReqType_SelectedIndexChanged events always fire (and only from these DDLs, the others don't fire inappropriately), even when neither of those controls had been selected. Then my GridView gridPendRoles disappears, unless a DataSource & DataBind() is forced. Any ReadOnly controls (lblTicketID, txbxInsertTicketDate, lblPendUserID) will also loose their data/text in the first PostBack. However, every PostBack following will not inappropriately fire events. And as long as a DataSource was set & DataBind() called a 2nd time at any time during any PostBack, the GridView will stay visible with correct data displayed. Again, as long as the ReadOnly controls have their data/text set a 2nd time during any PostBack, they too will retain their data/text for every following PostBack. I've tried debugging with Trace on & walked thru everything very thoroughly, but still cannot catch any reasons why this would occur. And since I am using the Delete & Edit command linkBtns in my GridView, I can't just force a DataSource & DataBind() on every PostBack, or I would loose those Row

When exactly does UIElement.LostFocus fire?

I am observing that if a control is deep within the Visual tree of a user control, and I click on another element further up or down the tree, UIElement.LostFocus does not fire.  If, however, I click on a closer element or its immediate parent, LostFocus fires correctly.  Am I missing something?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend