nice_true

Hello, I need to transliterate the names of employees that are fetched from my database and write the transliterated values back into the database... For this I need to run a javascript code in a loop for as many no of records as in the database.... The code I am …

Hi, Does anyone know how to pass table name as parameter in a cursor? ALTER PROCEDURE [dbo].[error_calculation] @tablename nvarchar(50) AS DECLARE @part_no nvarchar(50) --Current Year Cursor DECLARE db_cursorpartno CURSOR FOR select distinct part_no from @tablename ///This gives error OPEN db_cursorpartno FETCH FROM db_cursorpartno INTO @part_no

Hello everyone! I would like to know if there is a way to pass the Id value for an image in gridview through Session to an ashx file.... Here is my vb code in Gridview1_Rowdatabound event if e.row.rowtype=datacontrolrowtype.datarow then dim image as system.image.web.ui.webcontrols.image=ctype(e.row.findcontrol("imgphoto"),system.image.web.ui.webcontrols.image) session("passid")=val(databinder.eval(e.row.dataitem, "id")) image.imageurl="showimage.ashx" And here is my …

Hello! How do I redirect hyperlinks within an RDLC to a blank window? It normally redirects within the same window, as a result of which moving back to the main report is very cumbersome.... Thanks in advance.......

Hi, I would like to know how to find duplicate records based on exact match on some columns and slight difference on others... for example, I have a table with the following fields 1. Name nvarchar(50) 2. City nvarchar(50) 3. State nvarchar(50) 4. Age int(10) Now, I wish to search …

Hi! I work in NIC (National Informatics Centre). When I try to send email thorugh my asp.net code, I am not abe to do so, reason most probably being the ports being blocked by our ISP. To confirm, I fired telnet command for ports 25, 465 and 587, but in …

hi everyone! I want a "Continuous marquee text" over and over again... back to back... i dont want the text to finnish scrolling right the way across before the next one starts... as soon as it has fully scrolled onto the flash file i want the same text to start …

Hi! How can I seach all of the fields of every table in a databae for a particular value? When it is found, I want to be able to display the table name and the field name, then continue to search.

hi! I have 2 pcs in LAN, I wish to create a vb.net application in one of the pcs which displays a button on clickling which I can run any application on the conncted pc screen. How do I do this???? This is really urgent, plz reply soon................Thanks

hi! I wanted to know the query for binding a combobox with all available access databases' names in bin folder of an application ............... PLease help me out with this.......... Thanks..............

Hi! I have a problem in vb.net............. I have generated reports displaying employee details of a particular department.............. The problem is that the report contains more than 500 records and I want only 15 records to appear per page....... How can I continue the remaining data on successive pages???????????? This …

Hello! I have a small problem in asp.net ... I wish to create a pdf file and write text entered into a textbox into it using asp.net. The following lines of code work properly for creating and opening pdf files [code=asp.net] Dim fs As FileStream = File.Create(Server.MapPath("files/newfile.doc")) Dim sw As …

hello! I would like to know the method of preserving the format of text when entering it into the databse, so that the same format is restored when data is retrieved bak from the database. for example if I write hello world [B]good morning[/B] [COLOR="red"]how are you[/COLOR] all the three …

Hi! I would be grateful be grateful if I get an answer to this problem...... I have 2 dropdownlists, one contains country names and the other contains states' names. Now what I wish to do is that when i select a particular country from the first dropdownlist, its corresponding states …

hi all! plz help me with this prblm of mine I wish to bind a datagrid dynamically with access database , and at the same time it should contain "add", "delete" and "edit" buttons too this can be done very simply in html if the table name is fixed. but …

hi everyone! i wanted to know the command to check whether a particular table exists in access or not............ for example, in sql server, we write ("select * from sysobjects where name='table1",con) what is the equivalent command for this in access????????? thanks..................

Hi! I wish to display checkbox beside every row in a bound datgarid in a vb.net windws form. For instance, I select 3 records from SQL, I want it to display with checkboxes beside. How to do that? I further wish to find out in a button click event which …

Hello! I had problem sending mails through asp.net, even after writing the code. But after providing the IP address of my pc in the relay option in IIS, the problem finally got solved. But now the problem is that the same code when I tried to run on a pc …

Hi! Can anyone make it clear as to when to use cache variables and when to use session variables, i.e. what is the difference between the two?

Hi! can u plz tell me what is the code for setting the focus to a checkbox in vb.net 2003 project. How is this possible? I have tried checkbox1.setfocus=true but itdoes not work. Secondly, I wish to fire the click event for a button when I press the enter key. …

Hi! I cannot get the focus event code in vb.net 2003. Like in vb.net 2005, we write checkbox1.setfocus(), but what is the alternative for this in 2003? Please keep in mind, I am working with [B]vb.net 2003[/B] secondly I wish to write the keypress event for a textbox so that …

Hi! I wish to specify more than one databases in my connection string in a vb.net project, in order to retrieve records from both of them. For example, I have 2 databases , database A and database B I wish to retrieve the city field from the emp tables of …

Hi! I have coded a project in vb.net. It contains code that retrieves around 15 lakh records from the database and displays them in a grid. I use data adapter and fill the dataset with it. Then I specify the dataset as the datagrid's datasource. Now the problem is that …

Hi! I wish to copy the records in a dataset into an aary? How is this possible? Secondly, I would like to know whether using "=" operator while comparing is better or using an "in" operator is better For example,putting the following in a for loop Select city from empinfo …

Hi! I am running vb.net applications on a sytem with 512 mb of ram. The project includes retrieving data from a database which has approx. 20-25 lac records. On running the project for the first time itself, either a "time-out" message appears or the system gets hanged up. I tried …

Hi! The problem is that, when I write the following text as a query and try to run it, it returns 0 rows 'select * from receipts where grno not in (select grno from gate)' But when I write the above text in a stored procedure and then call it …

Hi! How can we convert date entered in (dd/mm/yyyy) format into (mm/dd/yyyy) format and vice versa at runtime?

Hi! I wish to display a message displaying the text "NO RECORDS FOUND." in the datagrid when no records are returned. At the same time, I dont want even the datagrid header containing the field names to be displayed. Only the message should be displayed. Can you plz help me …

Hi! I am inserting text in a table which contains date field. In some of the entered records, the date field is to be left blank. By default, it enters something like "1/1/1900". Now I wish to display data from this table into a datagrid. For the records in which …

Hi! I had raised a query titled "Many-to-one relationship", and received the reply from your side too. I am so sorry to inform you that by mistake the reply got deleted from my account. Could u plz be kind enough to resend me the reply? Extremely sorry for the caused …