Hi All is it possible to click a button on a web user control and have it retain the focus of the current control on the webform ? I am trying to integrate the cool TCKeypad Numeric Keypad Web User Control[^] into a webform and want the output of the button to go to the current control of a textbox on my webform rather than the built in textbox of the control. Any ideas or suggestions would be appreciated Cheers Dom

Hi All Im trying desparately to search a sql table image field passing in a parameter which is a byte array. I am having no luck whatsoever. I get this error when i run my code below :The data types image and image are incompatible in the equal to operator. Public Sub SearchByteArray(ByVal ByteArr() As Byte) Dim strSQL As String Dim oConn As SqlConnection Dim oCmd As SqlCommand Dim oBLOBParam As SqlParameter Dim str As String = "" ' Try ' Create and open connection object oConn = New SqlConnection("data source=XXX;initial catalog=CustomApps;user id=sa;pwd=xxx;") oConn.Open() ' Insert statement ' Notice that @BLOBValue is a placeholder for the actual data strSQL = "SELECT BlobField from MyImageTable where BlobField = (@BLOBValue)" ' Create a command object oCmd = oConn.CreateCommand() ' Set SQL statement oCmd.CommandText = strSQL ' Create a command parameter oBLOBParam = New SqlParameter("@BLOBValue", SqlDbType.Image, ByteArr.Length, ParameterDirection.Input) ' Finally, set the actual data oBLOBParam.Value = ByteArr ' Add this parameter to the command oCmd.Parameters.Add(oBLOBParam) ' Execute SQL statement MessageBox.Show(oCmd.ExecuteNonQuery()) ' Close the connection oConn.Close() End Sub Can anyone help or assist please ?

can anyone help me with this...any samples in vb would be great i have already searched google and had no luck. thanks

How do I remove the breaks between items in my autocomplete extender see picture in link ? http://img212.imageshack.us/img212/9526/cplu1.jpg

modified on Thursday, June 12, 2008 9:07 PM

thanks mate

can someone help with useful code i have the following in my codebehind

Public Function GetCust() As String
Return Session("CustCode")
End Function

And this in the aspx page

<asp:Label ID="Label1" runat="server" Text=<%# GetCust() %> ></asp:Label>

Can someone please tell me how to fix this and not to do it another way as i have to implement this method. I have simplified the above to get the point across. thanks i hope someone can help its annoying me badly..

can you show suggestion ?

can this be done anyone ? obviously the code below does not work but if someone knows how to embed session varible within querystring in the aspx page that would be awesome. thank anyway ppl something like this :

hyperlinkfield headertext="User Name" datatextfield="username" datanavigateurlformatstring="test.aspx?session("usercode")

thanks i have searched google already this was my last resort... thanks anyway

i'll repeat the question can you have a gridview embedded within a modal popup in ajax? not can you have a modal popup created from a gridview !

i have tried it and it does not work - but alot of my project don't work :) anyone ?

thanks everyone :) doh!

OK people I am a hack programmer - think of me as the homer simpson of programming See my code below and please help me eliminate the "Null reference exception" warning/error I get.. Thanks I know this is a easy and i am a d*mb one

Public Overloads Function LoadOrdersData() As Data.DataSet
Dim sqlConn As New SqlConnection(ConfigurationManager.ConnectionStrings("SqlConn3").ConnectionString)
Dim sqlDa As New SqlDataAdapter("spBackOrders", sqlConn)
Dim sqlDs As New Data.DataSet

    sqlDa.SelectCommand.CommandType = Data.CommandType.StoredProcedure
    sqlDa.SelectCommand.Parameters.AddWithValue("@Customer", Session("CustCode"))
    sqlDa.SelectCommand.Parameters.AddWithValue("@Customer2", Session("CustCode2"))

    Try
        sqlConn.Open()
        sqlDa.Fill(sqlDs)
        sqlConn.Close()
        Return sqlDs
    Catch

    Finally
        If sqlConn.State = Data.ConnectionState.Open Then
            sqlConn.Close()
        End If
    End Try
End Function

i have a gridview within a scriptmanager and within the gridview i have a templatefield which contains a hyperlink control which when clicked resubmits this page with some query strings attached. see code below:

<asp:TemplateField HeaderText="Order">
<ItemTemplate>
<asp:HyperLink ID="Hyperlink3" runat="server" NavigateUrl='<%# "default.aspx?SearchType=Wip&CustPO=" & rtrim(DataBinder.Eval(Container, "DataItem.PO#")) & "&StockCode=" & DataBinder.Eval(Container, "DataItem.MStockCode") %>'
Target="_self" Text='<%# DataBinder.Eval(Container, "DataItem.PO#") %> ' ToolTip="Check Work In Progress!">
</asp:HyperLink>
</ItemTemplate>
</asp:TemplateField>

How can i catch this event when the user clicks the hyperlink from the gridview. obviously page.ispostback or ScriptManager1.IsInAsyncPostBack do not catch this event. ? any ideas people - ajax newbie so forgive my ignorance Cheers

Hi All I have a web service that was not working and bringing up the dreaded internal server error page. I have this web service working on another server so i know code wise it works but could not get it to work on my new server. I tried other web services on my new server and they work fine. Just not this particular one. i changed the network indentity to local system in the application pool and the web service works so was hoping someone had any clues where i should look to fix this issue as i dont want it running under the local system identity. one last thing this webservice uses a com object. any help appreciated cheers

thanks for youre help :) sorry for all questions

can you show me please if possible ? thank you

but the code remains the same from the example on the website the only difference is i have incorporated a code behind file ? so i dont quite understand why it works when there is no code-behind ????

why did it work when there was no code behind form ?

Hi All I am getting a excpetion when i run my code, it was taken from the below url http://www.sitepoint.com/article/net-shopping-cart-datatables[^] I have run the code when there is no code behind page as per the authors page and it runs fine but when i try and recreate the code with a code behind I run into the obj.reference exception can someone please tell me how to correct this error. Code Below Thanks Protected Sub AddToCart(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdd.Click Dim objDT As System.Data.DataTable Dim objDR As System.Data.DataRow objDT = Session("Cart") Dim Product = ddlProducts.SelectedItem.Text Dim blnMatch As Boolean = False For Each objDR In objDT.Rows <-------this is were the exception occurs!!!!!! If objDR("Product") = Product Then objDR("Quantity") += txtQuantity.Text blnMatch = True Exit For End If Next If Not blnMatch Then objDR = objDT.NewRow objDR("Quantity") = txtQuantity.Text objDR("Product") = ddlProducts.SelectedItem.Text objDR("Cost") = Decimal.Parse(ddlProducts.SelectedItem.Value) objDT.Rows.Add(objDR) End If Session("Cart") = objDT dg.DataSource = objDT dg.DataBind() lblTotal.Text = "$" & GetItemTotal() End Sub