Hello, I changed my connection string to

DBConn.ConnectionString = "Provider=SQLNCLI;AttachDBFileName=" & App.Path & "\newdb.mdf;Database=newdb;User Instance=true;Trusted_connection=Yes;"

but it gives me run time error like Invalid connection string attribute.. Can you please suggest which attribute is invalid. Thank You.

modified on Sunday, July 31, 2011 12:28 PM

Hello, I connected two computers in LAN 1st having IP 192.168.1.1 and 2nd having IP 192.168.1.2 and i am having sql server management studio express 2005 installed on 1st computer now when i run exe from 192.168.1.2 it throughs an error like. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. where as it runs perfetly on 1st computer. my conection string is

Public DBConn As ADODB.Connection

DBConn.ConnectionString = "Provider=MSDATASHAPE; Data Provider=SQLOLEDB.1;Data Source=TOSHIBA\SQLEXPRESS; Initial Catalog=" & App.Path & "\AVON_AIR_Data.mdf; User ID=sa; Password=; Integrated Security=SSPI; Persist Security Info=False;"
DBConn.Open DBConn.ConnectionString

Please suggest Thank you.

Hello, I connected two computers in LAN 1st having IP 192.168.1.1 and 2nd having IP 192.168.1.2 and i am having sql server management studio express 2005 installed on 1st computer now when i run exe from 192.168.1.2 it throughs an error like. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. where as it runs perfetly on 1st computer. my conection string is

Public DBConn As ADODB.Connection

DBConn.ConnectionString = "Provider=MSDATASHAPE; Data Provider=SQLOLEDB.1;Data Source=TOSHIBA\SQLEXPRESS; Initial Catalog=" & App.Path & "\AVON_AIR_Data.mdf; User ID=sa; Password=; Integrated Security=SSPI; Persist Security Info=False;"
DBConn.Open DBConn.ConnectionString

Please suggest Thank you.

Hello everyone I want to open excel in vb.net for that i write code like.

Dim xl As Excel.Application
Dim xlWorkBook As Excel.Workbook
Dim xlWorkSheet As Excel.Worksheet

Dim misValue As Object = System.Reflection.Missing.Value

xl = New Microsoft.Office.Interop.Excel.ApplicationClass
xlWorkBook = xl.Workbooks.Add(misValue)

xlWorkBook = xl.Workbooks.Add(misValue)
xlWorkSheet = xlWorkBook.Sheets("sheet1")

but it show an error as "Member not found. (Exception from HRESULT: 0x80020003 (DISP_E_MEMBERNOTFOUND))"

hello every One I am using Password in my access database (.mdb) file i want to pass this password in my connection string I used the string like

Public cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=True;Data Source='" & Application.StartupPath & "\\pumpproject.mdb;password=pass")

but its not working please suggest some help its an deskstop applcation... Thank You

Hello Every One I want to upload my Applcation On Net for that i wrote a connection string in Web.config file like:

but the problem is my Default.aspx page is displayed on browser correctly now i wrote method to fill combobox on page load event but i think due to error in this string the combobox is not filled.. This applications runs correctly on my remote computer but shows problem described above when i upload it on FTP after Publishing my website... Please Suggest what shall i do.. Thank You.

hello App_Code.compiled App_Code.dll App_Web_oyclc8-d.dll These are files in my bin folder and i think so if i delete these folders the application would not work.. i tried deleting these files in my remote computer and then run my default.aspx page in browser but it the same error continue...

Hello Every one i am getting an error in default.aspx page when i publish my website and run the default.aspx text file in any browser The error is like: <%@ page language="C#" autoeventwireup="true" inherits="_Default, App_Web_i2fblcad" %> I searched for such error but cannot find any help .. Please Suggest What shall i do.. Thank You..

hello every one, I want to fix two columns of datagridview so that they can not be deleted on double click i tried for Google search but cant get any thing.. Please some one suggest me for the approach. Thank You... :) :) :)

Hello Every one, I am want addition of listview text and display it in label For eg: There is one listview and there are 3 records in it (100,200,300)respectively. now what i want is total of all these records and display it in lable1.text total =100+200+300(This numeric values comes from database) label1.text=total and this should happen each time at listview mouse double click event I stated below code in listview mouse double click event

Dim Tot As Integer = 0

    For i As Integer = 0 To Me.lstview2.Items.Count - 1
        Tot += CInt(Me.lstview2.SelectedItems(i).SubItems(i).Text)
        Tot += CInt(Me.lstview2.SelectedItems(i).SubItems(i).Text)
    Next

    Me.Label1.Text = Tot

but this only gives me position of the selected text So how shall i approach please suggest... Thank You :) :) :)

hello

Dim Tot as integer = 0

For i as integer = 0 to listview1.selecteditems.count -1
Tot += cint(me.listview1.selecteditems(i).subitem(1).text)
Next

me.label1.text = Tot

The code u suggested just gives me the one by one value of items present in listview eg :i placed this code on listview double click event so it just give me value 1 when i double click on selected row and then 2 and goes on. but i want the total of the items present in row and display it in label for eg:suppose there are two listviews both are having columns as Rupees but the first one is having Rs in it like(100,200,300 etc..) what i want is when i double click on any of row of first listview it adds the items preset in the selected row one by one and displays it in label like (100+200+300) which gives result as 600 in label simply saying i want total of text present in the listview so please suggest if some have any idea. Thank You. :) :) :)

Hello Every One I am having one listview in that i am adding one column like

me.listview1.column.add("Rupees,50,Horizontal.centre")

now i fetch records from database in it for filling listview and it worked but the problem is i want to add the Rupees of listview and display it in one label For that my code is like:

dim i as string
dim n as integer
dim t as integer =me.listview1.count
for i = to t-1
n=i+me.listview1.selecteditem(0).subitem(1).text
me.label1.text=n

but this seems to be wrong code can u please suggest some another... i am beginner Please help... :) :)

hello The error that i got is like. if i use my browser as netscape navigator than below error is displayed.

Failed to access IIS metabase.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.Hosting.HostingEnvironmentException: Failed to access IIS metabase.

if i use my browser as IE then error is like.

Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.

Please suggest some solution for this. :) :)

modified on Monday, July 6, 2009 12:33 AM

hello thanks for your help it is working now but the promblem is for metabase this time i am using iis(v 5.1) with asp.net 2005 with frame work 2.0 and dont know how to configure it. i am doing this for first time so can you please suggest how this works.. Thank you. :) :) :)

hello thanks i have done the way you told and it worked thanks for help. Now when i run my application there is error like: XML Parsing Error: syntax error Location: http://localhost/handloom/Home.aspx Line Number 1, Column 1: can u please suggest what this error is.. thank you. :) :) :)

THANK YOU VERY MUCH I DID THE SAME AS U SUGGESTED... BUT THERE IS NO OPTION LIKE CREATE VIRTUAL DIRECTORY ON RIGHT CLICK OF MY FOLDER. SO PLEASE SUGGEST HOW CAN I GET THAT.

hello every one I published my website and then i copied my project folder in www run my project using localhost but what happen is it shows code of my application rahter then design page. i cant get why this happen. Please suggest please help.. :) :) :)

Hello every one I need to develop an application in asp.net where i had to make report in excel for that i wrote my code like

Dim xl As New Excel.Application
xl = CreateObject("Excel.Application")
xl.Workbooks.Add()
xl.visible = True

this code works with vb.net 2005 but the same i want to use in asp.net 2008 now it shows an error like "type 'excel.application' not found" so please help me how to approach I am new to asp.net 2008.

Hello, I having one windows application to be developed in VB.Net 2005 the reports requirement is in MS word so please suggest how shall i approach for the same. I am having my database in Ms Access 2003 in that there is memo field which has one image in it I want to load that image from database to word file. So please suggest how shall i do it. Thank You. :) :) :)

hello every one I am having one project to be developed in vb 6.0 and i am new to it. I want to use Menu strip item & toolstrip menuitem in it i known in .net it is drag and drop method but how is it done in VB 6.0.I made one MDI form in that i want to use these both. Please suggest. Thank You. :) :) :)