Finally i made it....taken a long time but i succeeded in attaching my database file to the instance of sqlserver.I put my database files in a folder 'db' and add it into bin\debug folder of my project and change the app.config file as below:
<appSettings>
<add key="mycon" value="Data...
I tried out that too as;<add key="mycon" value="Data Source=.;Integrated Security=true;AttachDbFilename=|DataDirectory|MovieCalalog.mdf;Database=dbname;Trusted_Connection=Yes" />
but i got an error message Database'C:\Users\Sid\Desktop\WatchUrStuff\WatchUrStuff\bin\Release\MovieCalalog.mdf'...
OK...Finally,i succeeded in making setup of my application using 'ClickOnce'.............but but...its working fine when install on my system but when i try to install it on client pc,i got error related to path of database file as i have defined db path in connectionstring(changed this time...
i have my connection string something like this:
<appSettings>
<add key="mycon" value="Data Source=My-pc;Initial Catalog=MovieCatalog;User ID=sa;Password=pwd123" />
<add key="ClientSettingsProvider.ServiceUri" value="" />
</appSettings>
and i am calling it like this...
Ok..What if i go for ClickOnce method but i have read somewhere that ClickOnce is use for deploying Web applications only.Does it work for Windows applications also?
If it is then how?
Thanks for your valuable information....
OK, i would like to go with option 1...but how to include my database file and configure installer in VS to install SQL Server on local machine(and how to attach db with the instance of SQL Server on local machine)...in short how to create complete...
Hi,
i have develop an window application using **VB.NET** and** SQL SERVER2008R2**.I have Sql server2008R2 installed on my system containing sql database file.I have my connectionstring in app.config file as:-
<appSettings>
<add key="mycon"...
plz explain me...what i have done is...
Try
Dim strdatetime As String = DateTimePicker1.Text + " " + DateTimePicker2.Text
Dim date1 As Date = Date.Parse(strdatetime, System.Globalization.CultureInfo.InvariantCulture)
sqlupdate1 = "UPDATE paper SET date='" & date1.ToString & "'...
hi friends,
i have two datetimepickers in a window form application.One datetimepicker is used to select date and second one is for time.
Now i want to combine date from DTP1 and time from DTP2 and update the database with the selected combined datetime value using vb.net.
Thankyou
hi frnds,
i have a window based datagridview with "examdate" as one the editable datetime column .Now i want user to update or change the date to a fully valid format(dd:mm:yyyy) just on pressing enter key within the datagridview. A popup message must appear when user enter wrong date.
Any help...
hi...i m again here...
i have a datagridview on a form which contains studentname (in alphabetical order) and a blank rollno field according to the particular class.Now what i m suppose to do is to assign roll no on button click, starting from first student to last student.
Roll no is like...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.