I have a windows apllication ,I want to connect to the SQL Server database which is in the web server at USA .Can any one please tell me how to connect the database using VB.NET. Any response with source code will be highly appreciated. Thanks in advance

I am getting the following error when trying to view a page from server.Can anybody please tell me what is the solution.please helpme out i am got stucked. Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a "web.config" configuration file located in the root directory of the current web application. This tag should then have its "mode" attribute set to "Off". Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's configuration tag to point to a custom error page URL.

I want to upload some image files to the web server dynamically from my webpage.I have a folder in webserver with write permission.But when i try to upload the file it asks for password each time .Pleas help me what to do with source code.Its very urgent

Thats great,That is what i was looking for Thanx a lot

I HAVE SOME IMAGES IN MY SQL SERVER DATABASE IN BINARY FORMAT.I WANT TO SHOW THEM ON THE WEBPAGE AT RUN TIME ,THAT MEANS WHEN AN USER SELECT AN IMAGE FROM COMBOBOX THE CORRESPONDING IMAGE FROM THE DATABASE SHOULD BE SHOWN ON THAT PAGE. PLEASE TELL ME HOW TO ACHIVE THIS USING ASP.NET WEB FORMS.

How can i Print the contents of the listview control to Printer .Can any body help me with source code.

I will be glad to have a VB.NET code snippet to implement Concurency control when data inserted or updated on the database through command/datareader objects of VB.NET.

How can i use concurrency control using vb.net.I have used sqlcommand,sqlconnection and sqldatareader(No Dataset) to access data from database in my project.And multiple user can access and modify data ,so how can i use lock and cursor to maintain consistency in database.

Thanx for ur valuable suggestions. Can i have a sample stored procedure which is called recursively.

Yes my application is definitely in the server and i want to execute it at the server when user submits the form. Is it possible to use an usercontrol in web application which is developed in the windows application ?

I have a windows application.I want to run the application in my website,for instance there is a button on my home page ,i want the windows program to run whenever the user clicks on the button.Can any body please help me ,its very urgent.

Can we use Array In SQL Server ,if yes can any body tell how to use the same. Is it possible to call a stored procedure recursively??? Any answer to the above questions will be highly appreciated

Convert the third parameter to Intptr using CType as follows dsBuf.WriteBuffer(0, 0, buf(0),CType(CONST_DSBLOCKFLAGS.DSBLOCK_ENTIREBUFFER,System.IntPtr))

thanx CBoland Its great and working as per my expectation. Thanx a lot Pradipta

I have a VB.net Application ,whenever i click on the EXE a new instance of the application runs .But i want one instance to run at a time .That means if the exe is already running by clicking on it it should show the message that it is already running. Similar case for loading forms.suppose i have a button ,clicking on it a form is comes up ,if i click on the button several instance of the same form is running ,how to get rid of this that means there must be one instance of a form at a time. Please help me its urgent

Try this code Private Sub Cmdprint_Click() 'grdDetailReport(Name of the grid control) Dim i As Integer Dim defaultGridStyle As Integer Dim defaultFixedGridStyle As Integer Dim picGrid As StdPicture Dim defaultFontsize As Single ' Initalize Variables hl = grdDetailReport.HighLight ' Save current settings. tr = grdDetailReport.TopRow lc = grdDetailReport.LeftCol X = 0 Y = 0 defaultGridStyle = grdDetailReport.GridLines defaultFixedGridStyle = grdDetailReport.GridLinesFixed Printer.Orientation = 2 Printer.Font.Size = 18 Printer.Font.Bold = True 'Printer.Print label1.Caption grdDetailReport.Redraw = False ' Highlight off grdDetailReport.HighLight = 0 Printer.Font.Size = 10 Printer.Font.Bold = False Do Until X - grdDetailReport.Rows >= -2 X = X + 45 Y = Y + 1 Printer.Print "Page " & Y If X > grdDetailReport.Rows - 1 Then grdDetailReport.Row = X - 44 grdDetailReport.Col = 0 grdDetailReport.RowSel = grdDetailReport.Rows - 1 grdDetailReport.ColSel = grdDetailReport.Cols - 1 Else grdDetailReport.Row = X - 44 grdDetailReport.Col = 0 grdDetailReport.RowSel = X grdDetailReport.ColSel = grdDetailReport.Cols - 1 End If For i = grdDetailReport.FixedRows To grdDetailReport.Rows - 1 If i < grdDetailReport.Row Or i > grdDetailReport.RowSel Then grdDetailReport.RowData(i) = grdDetailReport.RowHeight(i) grdDetailReport.RowHeight(i) = 0 End If Next For i = grdDetailReport.FixedCols To grdDetailReport.Cols - 1 If i < grdDetailReport.Col Or i > grdDetailReport.ColSel Then grdDetailReport.ColData(i) = grdDetailReport.ColWidth(i) grdDetailReport.ColWidth(i) = 0 End If Next ' Scroll to top left corner. grdDetailReport.TopRow = grdDetailReport.FixedRows grdDetailReport.LeftCol = grdDetailReport.FixedCols ' Copy picture. Clipboard.Clear On Error Resume Next grdDetailReport.PictureType = 0 ' Color. Clipboard.SetData grdDetailReport.Picture If Err <> 0 Then grdDetailReport.PictureType = 1 ' Monochrome. Clipboard.SetData grdDetailReport.Picture End If With flxGrid Set picGrid = Clipboard.GetData(vbCFBitmap) End With grdDetailReport.GridLines = defaultGridStyle grdDetailReport.GridLines = defaultFixedGridStyle

How can i print the contents of the listview control(including header) to printer using VB.NET, can anybody please help me with code Thank U

I tried the following EXEC sp_attach_db @dbname = N'pubs', @filename1 = N'c:\mssql7\data\pubs.mdf' But I am getting following error using the above Stored procedure -------------------------------------------------------- Server: Msg 5105, Level 16, State 4, Line 1 Device activation error. The physical file name 'c:\mssql7\data\pubs.mdf' may be incorrect. ------------------------------------------------------ But the physical path is correct.I also tried with sp_attach_single_file_db but same error results. How can i do the same using Enterprise Manager,It will be highly appreciated if u tell me step by step.

I had created a database(SQL Server) few motnhs before but unfortunately the database is now missing ,i have only the .mdf file of that database(.ldf is also missing),Can someone tell me how to recover the database from the .mdf file. Thanx Pradipta

i think U did not understand the problem.the query u have written only to retrive those DOB which will lie within this week.But DOB means only the month and day will be same whatever may be the year ,for exammple today is 4/4/2003 and DOB of a member 4/4/1975 then today is the birth day of that memeber. so i want only the dob from database whose day and month will be equal to today's day and month and also those whose b'day will be within 7 days beyond today just see the example dob in the data base DOB(mm/dd/yyyy) 4/4/1976 4/4/1970 4/6/1976 4/8/1999 1/1/1990 1/3/2000 ------------ Today is -4/4/2003 i want the the data from database 4/4/1976 4/4/1970 4/6/1976 4/8/1999 because the above dobs will lie on this week pradipta