how can I return vaule recordset and @@rowcount from stroed procedure in asp? Stored Procedure: CREATE Pro sp_results ( @FileNumber varchar(100), @StreetNumber varchar(50) ) AS SET NOCOUNT ON BEGIN SELECT RecordIndexDB.entity_id, RecordIndexDB.job_entity_id, RecordIndexDB.file_number, RecordIndexDB.file_location, RecordIndexDB.street_name1, RecordIndexDB.street_name2, RecordIndexDB.street_name3, RecordIndexDB.street_name4, RecordIndexDB.street_name5, RecordIndexDB.street_number1, RecordIndexDB.street_number2, RecordIndexDB.street_number3, RecordIndexDB.street_number4, RecordIndexDB.street_number5 FROM RecordIndexDB WHERE RecordIndexDB.status = 1 AND ( (RecordIndexDB.file_number Like '%' + @FileNumber + '%' AND len(@FileNumber)>0 ) OR (len(@FileNumber)=0) ) AND ( ((RecordIndexDB.street_number1 Like '%' + @StreetNumber + '%' OR RecordIndexDB.street_number2 Like '%' + @StreetNumber + '%' OR RecordIndexDB.street_number3 Like '%' + @StreetNumber + '%' OR RecordIndexDB.street_number4 Like '%' + @StreetNumber + '%' OR RecordIndexDB.street_number5 Like '%' + @StreetNumber + '%') AND len(@StreetNumber)>0 ) OR (len(@StreetNumber)=0) ) ORDER BY RecordIndexDB.file_number ASC END Return @@RowCount In my asp page, I have a recordset to hold the results, but I don't know how to get the @@RowCount value. have any idea??

Lisa

Hello, Ray, I created another field called thumbnail and the datatype is image, and I run it again, the result is the same, it still gave me the same error. thanks!

Lisa

I'm trying to save the image to sql database, there is error "object must implement Iconvertible" when I run it. Here is my code: (image is the location + the name of the image) Try Dim strFn As String = image Dim fiImage As FileInfo = New FileInfo(strFn) Me.m_lImageFileLength = fiImage.Length Dim fs As FileStream = New FileStream(strFn, FileMode.Open, FileAccess.Read, FileShare.Read) m_barrImg = New Byte(Convert.ToInt32(Me.m_lImageFileLength)) {} Dim iBytesRead As Integer = fs.Read(m_barrImg, 0, Convert.ToInt32(Me.m_lImageFileLength)) fs.Close() Catch ex As Exception MessageBox.Show(ex.Message) End Try Try Me.SqlConnection1.Open() If SqlCommand1.Parameters.Count = 0 Then Me.SqlCommand1.CommandText = "UPDATE HRRecordIndexData SET pdf_location = @Picture WHERE entity_id = @ID" Me.SqlCommand1.Parameters.Add("@Picture", System.Data.SqlDbType.Image) Me.SqlCommand1.Parameters.Add("@ID", System.Data.SqlDbType.Int, 4) End If Me.SqlCommand1.Parameters("@Picture").Value = Me.m_barrImg Me.SqlCommand1.Parameters("@ID").Value = Entity Me.SqlCommand1.ExecuteNonQuery() Catch ex As Exception MessageBox.Show(ex.Message) Finally Me.SqlConnection1.Close() End Try If there is everyone knows what it needs to fix at my code, I would very appreciate it .. thanks!

Lisa

recall the function after the data add. Lisa -- modified at 8:51 Monday 8th May, 2006

will you please link some how to slove this kind problem articles for me? Thanks. Lisa

Hello, Here is the problem I have, is there anyone know how to slove it? I have a Window XP SP2 machine with Microsoft SQL 2005, All my database are in this machine. I have an application is installing in another Window XP SP2 machine and in the same network. I cannot get access to the database from the second machine using my application. When I run the application, it says [DBNETLIB][ConnectionOpen(connect()).] SQL Server does not exit or access denied. I know there is a firewall issue in the window xp sp2, I have already open the port 1433 in the server machine, but it still cannot connect. I very apperiate your help. Lisa

Hello, Dave..That's so funny..I can't find the AllowLaterVersions property in Launch conditions -> .Net Framework ->property. There are only 4 propperties (Name, InstallUrl, Message, SupportedRuntime) and I'm using VS2003 version. Do you have any idea? Lisa

I have changed the version of the dependancy to 2.0.50727, and it works fine under the 2.0 framework. But when I test in another workstation only have .net framework 1.1. The installation request it to install the .Net Framework 2.0, but my application should run under .net framework 1.1 without any problem. How can I work around this? When the workstation has .Net framework version 1.1 and up, it doesn't need to install any more .net framework. THanks, Dave! Lisa -- modified at 12:17 Friday 10th February, 2006

I have an app created by VS2003. The launch conditions of .net framework's supportedRuntime is V1.1.4322. It can be installed in those machine had this version. I have another machine that only have the newest version framework V2.0. When I installed it, it asks me to install the .net framework V1.1.4322. I think that should not happen when the computer has the newest version .net framework in it. But my app can't be installed. Is there anybody know how to solve this issue? THANKS!! Lisa

Is anyone know about Crystal Reports with vb? I created a mailing label in crystal reports 8.5, but I don't know how to skip used mailing labels and print duplicate. any idea? Lisa

is there any source for building a calendar like outlook calendar in vb.net, you can input a link or button in each date, and when you click it, it will open another window. any idea? Lisa

when I run it, it shows this error: Specified argument was out of the range of valid values. parameter name: Index 32 is out of range. but the control.count shows result is 53, why it is out of range? Lisa

how can I remove the dynamic textboxes? I have tried to remove it use controls.remove, but it doesn't work, it just remove all the textboxes when it load, then doing nothing. can you help me see what's wrong with it? Thanks a lot. Dim tempCtrl As Control For Each tempCtrl In GroupBox1.Controls Groupbox1.Controls.Remove(tempCtrl) Next tempCtrl Lisa

thanks..Dave. I have another question to ask you. if I created textboxes, do I need to remove them when I use it again? when I resign the iStartIndex and iEndIndex and recall the sub textboxshow(), what should I do to make the second call shows correctly? Private Sub textboxShow() setStartIndex() setEndIndex() clearTextboxes() MessageBox.Show(iStartIndex & "," & iEndIndex) Dim I, J As Integer Dim sData As Integer = 1 While sData <= iEndIndex For I = 1 To 6 For J = 1 To 7 Call AddDataShow(sData, I, J) sData += 1 Next Next End While End Sub Public Sub AddDataShow(ByVal sText As String, ByVal I As Integer, ByVal J As Integer) Dim txtDataShow As New TextBox Dim UserLft, UserTop As Integer Dim X, Y As Integer Dim a As Integer a = sText - iStartIndex UserLft = 20 UserTop = 80 txtDataShow.Height = 80 txtDataShow.Width = 80 txtDataShow.TextAlign = HorizontalAlignment.Left txtDataShow.BorderStyle = BorderStyle.FixedSingle 'txtDataShow.BackColor = Color.White txtDataShow.BringToFront() If a > 0 And a <= iEndIndex Then txtDataShow.Text = a 'MessageBox.Show(a) Else txtDataShow.Text = "" End If If txtDataShow.Text = "" Then txtDataShow.BorderStyle = BorderStyle.None Else txtDataShow.BorderStyle = BorderStyle.FixedSingle txtDataShow.BackColor = Color.White End If txtDataShow.Multiline = True txtDataShow.ReadOnly = True X = UserLft + (J - 1) * txtDataShow.Width Y = UserTop + (I - 1) * txtDataShow.Height txtDataShow.Location = New Point(X, Y) 'MessageBox.Show(X & "," & Y) Me.GroupBox1.Controls.Add(txtDataShow) End Sub Private Sub clearTextboxes() Dim ctrl As Control Dim txtBox As TextBox For Each ctrl In GroupBox1.Controls If ctrl.GetType().Equals(GetType(TextBox)) Then txtBox = CType(ctrl, Control) txtBox.Text = String.Empty End If Next End Sub Lisa

this code is write by vb6 and it convert to vb.net, when I run it, it gets me error. is anybody knows hot to fix this or what should I code it in vb.net? Thanks! Private Sub clearTextboxes() Dim txt As System.Windows.Forms.Control 'Set each textbox's value to "" For Each txt In frmMain.DefInstance.Controls 'UPGRADE_WARNING: TypeOf has a new behavior. Click for more: 'ms-help://MS.VSCC.2003/commoner/redir/redirect.htm?keyword="vbup1041"' If TypeOf txt Is System.Windows.Forms.TextBox Then txt.Text = "" Next txt End Sub Lisa

hello, Ranoush, I tired to use the mail label templet, it works for the 6 labels in a page.. the only problem I have that it's the position. for example, you already used the first label in your label template, then next time when you want to print another labels, you want it to start from the second label position. how schould I do this in Crystal Reports. Thanks all your help! Lisa

Thanks, Ranoush.. I follow your steps, and it shows the correct result in each page, if I input 6 values, they show in 6 different pages. But I want them in one pages, how can I do it? I created 6 formula field call @label1, @label2, @label3, @label4, @label5, @label6, and put it to a 6 diferrent location in a page. I don't know how to do it. and one more thing is if there is @label1 and @label2 are already used, I want to print the new labeb in position @label3, is there anyway I can do it in Crystal Reports? and the ID Parameter is passing from VB. Thanks! Lisa

I have tried using Crystal Reports, And I have problem with it. First, I have 6 parameters for the 6 labels entityID, the query like this: Select name, address From company -- In the select expert Company.entityid is one of ?ID1, ?ID2, ?ID3, ?ID4, ?ID5, ?ID6..when I input values, nothing shows in preview. I don't know how to correct bind to the 6 labels when the parameters have input. and how can I put the right label, the first two labels already used, so I want to choose the third label to print, how can I do that in the Crystal Reports? Lisa

I'm doing a vb application, and there is one problem I have and I don't know how to do it from VB. One sheet 8.5"x11", 6 Labels 3.333"x4" each Label, this is the Label sheet standar. I have to create a form to print this Labels in correct position. I don't have any idea to do this in VB form. should I have a datagrid and bind the mail address data to it, or a textbox or other controls, any ideas? Lisa

hello, is there anyone know how to auto-fill a textbox? I have 4 textbox, first_name, middle_name, last_name, and full_name, I want the full_name textbox to be auto-filled when the first_name, middle_name, and last_name entered, so user doesn't need to fill in the full_name textbox. any idea to do this? thanks. Lisa