Sub salsa()

    With ActiveSheet.ListObjects.Add(SourceType:=0, Source:="ODBC;DSN=dwh01;", _

      Destination:=Range("$A$4")).QueryTable

      .CommandText = Array( _

      "SELECT v_ccdata_0.bookingdate, v_ccdata_0.bookingnumber, v_ccdata_0.land_vendor, v_ccdata_0.total_revenue, v_ccdata_0.total_cost" & Chr(13) & "" & Chr(10) & "FROM cheapc.v_ccdata v_ccdata_0" & Chr(13) & "" & Chr(10) & "WHERE (v_ccdata_0.bookingdate>={d '20" _

      , "12-05-05'}) AND (v_ccdata_0.bookingdate<={d '2012-05-12'})")

      .RowNumbers = False

      .FillAdjacentFormulas = False

      .PreserveFormatting = True

      .RefreshOnFileOpen = False

      .BackgroundQuery = True

      .RefreshStyle = xlInsertDeleteCells

      .SavePassword = False

      .SaveData = True

      .AdjustColumnWidth = True

      .RefreshPeriod = 0

      .PreserveColumnInfo = True

      .ListObject.DisplayName = "Table_Query_from_dwh01_1"

      .Refresh BackgroundQuery:=False

    End With

End Sub

http://www.eggheadcafe.com/community/csharp/2/10451142/not-able-to-access-aspnet-session-variable-in-wcf-service-web-applica.aspx

and change it accordingly in my code  how to retrieve HttpContext.Current.Session["test"] in wcf service?

iam not getting how to implement in my code..pls help me out.....try to change in my code itself......i dont want any sample sites and examples.....

I am testing one functionality in  my macros application and it is giving me strange error (It is apending part of text used in the sendkeys string.)

Request you to please help me in resolving this issue. Below is the small code for your reference

Sub Test()
SendKeys "%LRA", True
End Sub

After debugging line 2 I am getting RA in EndSub line i.e last line is coming like RA End Sub

I am using in win7 environment for this. Kindly help me in this regard.

Thanks in advance

hai friends ,

if i select select checkbox then the value enter table. i am uncheck the record delete in the table.

i able to do this using dummy table called "newtable1". now i want perform the task using with string.

how to handle the task with string without table ?

Protected Sub chkTestids_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs)
      Dim ocontactnos1 As New StringBuilder
      Dim arrIDs As New ArrayList()
      Dim CatID1 As Integer = 0
      Dim CatID2 As String
      Dim count As Integer
      Dim chk1 As CheckBox = DirectCast(GVContacts.HeaderRow.FindControl("chkHeader"), CheckBox)

      For Each r As GridViewRow In GVContacts.Rows
        Dim chkin As CheckBox = DirectCast(r.FindControl("chkTestids"), CheckBox)
        If chkin.Checked = False Then
          count += 1
          CatID1 = GVContacts.DataKeys(r.RowIndex)("contact_id").ToString()
          Dim cmd As New SqlCommand("delete from newtable1 where Contact_ID=" & CatID1, conn)
          conn.Open()
          cmd.ExecuteNonQuery()
          conn.Close()
          chkin.Checked = False
        End If
      Next

      Dim adt As New SqlDataAdapter("select * from newtable1", conn)
      Dim dt As New DataTable
      adt.Fill(dt)

      For Each drow As System.Data.DataRow In dt.Rows
        arrIDs.Add(drow("contact_id").ToString().Trim())
      Next

      For Each r As GridViewRow In GVContacts.Rows
        Dim chkin As CheckBox = DirectCast(r.FindControl("chkTestids"), CheckBox)
        If chkin.Checked = True Then
          CatID1 = GVContacts.DataKeys(r.RowIndex)("contact_id").ToString()
          CatID2 = GVContacts.DataKeys(r.RowIndex)("MobileNo")
          If arrIDs.Contains(CatID1.ToString()) Then
            chkin.Checked = True
          Else
            arrIDs.Add(CatID1.ToString())
            Dim cmd As New SqlCommand("insert into newtable1 values (" & HidTokenNo.Value & "," & CatID1 & "," & CatID2 & ",1)", conn)
            conn.Open()
            cmd.ExecuteNonQuery()
            conn.Close()
            chkin.Checked = True
          End If
        End If
      Next

      If count = 0 Then
        chk1.Checked = True
      Else
        chk1.Checked = False
      End If

      If arrIDs.Count = HiddenField1.Value Then
        chkAllGroup.Checked = True
      Else
        chkAllGroup.Checked = False
      End If
      count123()
    End Sub

I am trying to figure out how to get bookmarked value in word using C#. In word template, I have bookmarked few pages where it contains words and some checkbox and etc. Based on list that I compare, I want to place same information to different page where I bookmarked it. I know how to update bookmark but reversing it to get the value isn't working and I can't find any good example that works too.

<asp:Login ID="signInControl" style="width: 250px" FailureText="<%$Resources:wss,login_pageFailureText%>" MembershipProvider="FBAMembershipProvider"

runat="server" DisplayRememberMe="false" TextBoxStyle-Width="250px" RememberMeSet="false" LoginButtonStyle-CssClass="ms-buttonheightwidth"

UserNameLabelText="User name" TextLayout="TextOnTop" PasswordLabelText="Password" LabelStyle-Font-Bold="false" LabelStyle-Font-Size="Small" LabelStyle-ForeColor="#0098e1" LabelStyle-Font-Names="Verdana" LabelStyle-CssClass="ms-standardheader ms-inputformheader" TextBoxStyle-CssClass="ms-input"

CheckBoxStyle-Font-Bold="false" CheckBoxStyle-Font-Names="Verdana" CheckBoxStyle-ForeColor="#0098e1" CheckBoxStyle-CssClass="ms-standardheader ms-inputformheader"

CheckBoxStyle-Font-Size="Small" FailureTextStyle-Wrap="true" FailureTextStyle-Font-Names="Verdana" FailureTextStyle-Font-Size="Small" LoginButtonStyle-Font-Names="Verdana"

LoginButtonStyle-Font-Size="Small" LoginButtonImageUrl="~/_layouts/1033/IMAGES/imageslogsmall.jpg" LoginButtonType="Image" TitleText="LogIn" TitleTextStyle-ForeColor="#0098e1"

OnLoggingIn="OnLoggingIn" TitleTextStyle-Font-Bold="true" TitleTextStyle-Wrap="true" TitleTextStyle-Font-Names="Verdana" TitleTextStyle-Font-Size="Medium" />

protected override void OnLoad(EventArgs e)

try { base.OnLoad(e); }

catch(Exception er)

TGTravelServiceService ts = new TGTravelServiceService();

hai,

i have a gridview with checkboxes and paging can in chenge the page .which items is selected that items are form the string.

i am tring this code it can't get the answer.

Public Sub SelectedCheckBoxes()
      Dim hiddenIDs() As String = {}
      If Not String.IsNullOrEmpty(hiddenCatIDs.Value) Then
        hiddenIDs = hiddenCatIDs.Value.Split(New Char() {","})

      End If
      Dim arrIDs As New ArrayList()
      Dim CatID As String = "0"
      If hiddenIDs.Length <> 0 Then
        arrIDs.AddRange(hiddenIDs)
      End If
      For Each rowItem As GridViewRow In GridView1.Rows
        Dim chk As CheckBox
        chk = CType(rowItem.Cells(0).FindControl("chk1"), CheckBox)

        CatID = GridView1.DataKeys(rowItem.RowIndex)("MobileNo").ToString()
        If chk.Checked Then

          If Not arrIDs.Contains(CatID) Then
            arrIDs.Add(CatID)
            ListBox1.Items.Add(CatID)
          End If
        Else
          If (arrIDs.Contains(CatID)) Then
            arrIDs.Remove(CatID)
            ListBox1.Items.Remove(CatID)
          End If
        End If
        'lblselectedNos.Text = CatID
      Next
      hiddenIDs = CType(arrIDs.ToArray(Type.GetType("System.String")), String())
      hiddenCatIDs.Value = String.Join(",", hiddenIDs)
      lblselectedNos.Text = hiddenCatIDs.Value
    End Sub

create procedure myproc

as

Begin

    DECLARE @variable VARCHAR(50)

    DECLARE @sqlQuery VARCHAR(8000)

    DECLARE @finalQuery VARCHAR(8000)

    Declare @LastUpdate_calldate varchar(200)

    if isnull(@LastUpdate_calldate,'0')='0'

    BEGIN

set @LastUpdate_calldate=replace(convert(varchar,getdate()-510,102),'.','-') + ' 00:00:00.000'

    END

    ELSE

    BEGIN

       set @LastUpdate_calldate=replace(convert(varchar,getdate(),102),'.','-') + ' 00:00:00.000'

    END

    Print @LastUpdate_calldate

  

SET @sqlQuery = 'SELECT DATE_FORMAT(calldate,''''%Y%-%m-%d %H:%I:%s.000'''') as calldate,src FROM mytable where DATE_FORMAT(calldate,''''%Y%-%m-%d %H:%I:%s.000'''') > ' + '''' + '''' + @LastUpdate_calldate + '''' + ''''

   




SET @finalQuery = 'SELECT * FROM OPENQUERY(LNKMY,' + '''' + @sqlQuery + '' + ' Order By calldate desc  ''' + ')'

    SELECT @finalQuery

    INSERT INTO MYTABLE (calldate,userfield)

    EXEC(@finalQuery)

End

BusyIndicator to the user.

The problem is, the BusyIndicator disables the controls on the previous page even after its stopped and closed. When the BusyIndicator is gone ,the checkboxes show up disabled and the debugger shows that datacontext object's boolean property changed.

There is no code from my side doing this enable/disable thing.
all attempts at tracing where and why this property is getting changed in vain so far. anyone seen this issue before?

This is for silverlight 4 and C#.

Is it a bug in silverlight? or am I missing something trivial?

Any help appreciated.

Thanks,
Abhishek

if (DropDownList1.SelectedItem.Text != "ALL" && DropDownList2.SelectedItem.Text != "ALL" && RadioButtonList1.SelectedIndex != 0 && RadioButtonList2.SelectedIndex != 0)

{

i want to execute this method in gridview update:

cmd = new SqlCommand("select sum(credit) AS total from creditadd where cid<=cid and userid='" + TextBox1.Text + "' and username='" + TextBox2.Text + "'", con);