Hi, I make a small project in Vb.NET, it also have some crystal reports. The reports works well in my computer. But when I run my project on other computer, the reports cannot runs well. Actually it gives a dialog box and ask to Enter "Server name","Database Name", "Login ID", "PAssword" Why this happens when my project runs on other computer. Plz give me a possible solution. EsHbAn BaHaDuR

Hi, Thank you for your reply. Now my code runs fine. I just exclude single quotes. As far as like operator is concerned, i concat the % sign with the alphabets like A,B or C etc. Thank you EsHbAn BaHaDuR

I am making a small program. Actually on my form there are two comboboxes. From these two comboboxes, user specify the search criteria. In first combobox, there are alphabets from A-Z. In second combobox, there are selection criteria like "search By Author", "search by publisher" etc. I just show data in a datagird. I use the following code. ''' This code is used for concatenation % sign to use in like operator''''''' Dim var1 var1 = Me.ComboAlphabets.Text() var1 = var1 & "%" MsgBox(var1) ''''Gettiong values of combobox''''''''''''' Dim searchby searchby = Me.ComboSearch.Text() MsgBox(searchby) Dim da As New SqlClient.SqlDataAdapter("SELECT * from books where '" & Me.ComboSearch.text & "' like '" & var1 & "' ", cn) Dim ds As New DataSet If da.Fill(ds, "books") = Nothing Then MsgBox("No Record Found") Me.ViewBookGrid.Hide() Else ds.Clear() Me.ViewBookGrid.Show() Try da.Fill(ds, searchby) Me.ViewBookGrid.DataSource = ds.Tables(searchby) Catch ex As Exception MsgBox(ex.Message) End Try MsgBox("Records Found") End If Everything is run fine , but there is a problem in select query after the where clause. Actually i want to select those records from database which user has mentioned from combobox. Like if user select "Publisher name" from combo box, then it select record from "publishername" column only. I use the query, it works 100% fine 'Dim da As New SqlClient.SqlDataAdapter("SELECT * from books where publihsername like '" & var1 & "' ", cn) At "publishername", i want to mention combosearch.text values. Means if i select "Publishername" from combobox, then my query becomes. 'Dim da As New SqlClient.SqlDataAdapter("SELECT * from books where publihsername like '" & var1 & "' ", cn) If i select "AuthorName", then my query becomes 'Dim da As New SqlClient.SqlDataAdapter("SELECT * from books where authorname like '" & var1 & "' ", cn) I try a lot and use this query Dim da As New SqlClient.SqlDataAdapter("SELECT * from books where '" & Me.ComboSearch.Text & "' like '" & var1 & "' ", cn) But this query cannot fetch correct result. If i exclude me.combosearch.text from query and replace this with "publishername" or "authorname", then it

I have a little chat project which is developed in ASP and XML. But it just give one error. If anyone can help me, then plz give me your email address, i will contact you and tell you the error Eshban EsHbAn BaHaDuR

I have a little chat project which is developed in ASP and XML. But it just give one error. If anyone can help me, then plz give me your email address, i will contact you and tell you the error Eshban EsHbAn BaHaDuR

I have a field in SQlServer Database which name is "PublishingDate". In it, Date is stored in that format i.e 3/28/2005 In my vb.net program i use select query to fetch all the records of column "PublishingDate" I use the query below to just select year out of whole Date and display result in a combobox. "select distinct DATEPART(yy,publishingdate) from books" Everything will be fine. In Combobox it show all "years" like 2000,2001,2002,2003 I want that when user clicks on any year in a combobox like '2000', it will display results according to that query Select * from books where publishingdate='" & ComVal.text & "' But this query cannot display the result because in database date is stored in this format "3/8/2005" Hope you got the meaning. I use this query, but it cannot display the result. SELECT * From books where publishingdate IN (select Datepart(yy,publishingdate)from books) How can i do this? Plz help me in this regard. Eshban EsHbAn BaHaDuR

Well I have IE 6 version which is i think latest version of IE upto now.But it doesnot works.If u think that u have latest version of IE then i would send it to u to check that is it working properly. waiting for ur courtesy. EsHbAn BaHaDuR

hi, I have displayed some data in Data Grid control through my code. Now i want to clear all the data displayed in datagrid, by pressing a button. How can i do this. plz help. EsHbAn BaHaDuR

I am having a problem in small file where the ASP code contains java scripting where we r opening a new window but it is not working the error says invalid property assignment 'response.write' EsHbAn BaHaDuR

Hi, can anyone solve this error, i am a beginner in asp, kindly help me urgently Here is the code. It gives error : response.write"" & window.open(" "chat.html?userid=count " & " name " & user & " " "," " " "," " toolbar=no,location=no,directories=no," & " status=no,menubar=no,resizeable=no," & " scrollbars=no," & " copyhistory=no,width=650,height=300" ")" when i run the file through localhost, it gives following error. ERROR: ===== Microsoft VBScript compilation (0x800A03EE) Expected ')' /chatasp/login.asp, line 27, column 42 response.write"" & window.open(" "chat.html?userid=count " & " name " & user & " " "," " " "," " toolbar=no,location=no,directories=no," & " status=no,menubar=no,resizeable=no," & " scrollbars=no," & " copyhistory=no,width=650,height=300" ")" Kindly correct this error, i am waiting for a positive response EsHbAn BaHaDuR

I have a chatting software in ASP and XML but my system is not configured to run it because The code is using DOM component object programming and i have to install this component to run it.I want to know from where i can install this component. waiting... EsHbAn BaHaDuR

Hi, I backup my SQL server database to deploy it to another computer. But i don't know that how to restore it on the other computer. What r the steps. Kindly help me in this regard. Bye EsHbAn BaHaDuR

Hi, I have some records in excel file. Like i have 2,000 records. I want to store it in a databse (Acccess or SQL ServeR). Is there any software available. plz reply EsHbAn BaHaDuR

1)How to make (.mdf) file in Sql Server (use to deploy database on other computer) Actually i want to deploy my SQL database along with its data to other computer EsHbAn BaHaDuR

How to use "Joins" in Crystal Reports. Here is my query. select books.bookid,books.bookname,issuebooks.issuedate,issuebooks.returndate,issuebooks.datereturned from books,issuebooks where books.bookid=issuebooks.bookid and memberid= '" & TextBox1.Text & "'" I am making a report regarding to this query. How can i use this query in "crv.SelectionFormula" method, where crv is the name of the "Crystal Report Viewer" Control. EsHbAn BaHaDuR

Hello, I attach a textbox on the form. How can i check a text box for a valid email address. Means if user enters invalid address in a text box e.g (aaaa.com), then it will alert a message. plz reply. EsHbAn BaHaDuR

i attach a datetime picker control the form. Then i display a message on its "TextChanged"event. Here is the code. Private Sub DateTimePicker1_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DateTimePicker1.TextChanged Msgbox("Code Runs") End Sub Means this code will display a message when i change any day from the datetime control. But when i changed the month, then it display message 30 times, and when i change year, it display my message 365 times. I need that when i change the month and year from this controls, then it cannot display message. It only display message when i change the day. How can i do this. plz help EsHbAn BaHaDuR

It is possible through SQL query. Use 'ALias' command of sql. example select 'FirstName'=au_fname,'LastName'=au_lname from authors use this query, hope you understand it. au_fname and au_lname are column names, where as 'First Name' and 'Last Name' are fake names. bye EsHbAn BaHaDuR

I attach a text box on form. user has to enter date in that text box. How can i set the format mask for date like dd:mm:yyyy EsHbAn BaHaDuR

I want to select some data from database and display it in DATAGRID control, how can i use it without using "Data Adapter" and "DataSET" objects EsHbAn BaHaDuR