|
my connection code is:
String strConnection;
strConnection = "server=localhost;User ID=sa;Password=sas;database=db";
SqlConnection conn = new SqlConnection(strConnection);
conn.Open();
how will i write it in any application configuration file working in windows form,and call it on every page that needs to b connected??
can any body help me??
$h@ma!|@
|
|
|
|
|
i write in the folowing manner
<appsettings>
<add key="sqlserver" value="server=localhost;User
ID=sa;:Dassword=sa;database=db" ;="">
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
First and foremost, this is a VB.Net question (Not ASP.Net since you are using Win Forms) second in your app.config you need a < connectionStrings > < /connectionStrings > section (like below) then add your connection string as I have. The weird thing about your post is you ask how to make it work in the app.config in Windows Forms then you ask how to call it on every "page" taht needs it, Windows Forms dont have "pages". The below example will work in Windows Forms (which is what you asked).
As for the 2nd part of your question, the easiest way to call it is to write a function like below:
'This returns the connection string
Public Shared Function GetConnectionString(ByVal strConnection As String) As String
Dim strReturn As New String("")
'If you have multiple connection strings then you can pass it a connection name otherwise it defaults to your default connection
If Not String.IsNullOrEmpty(strConnection) Then
strReturn = ConfigurationManager.ConnectionStrings(strConnection).ConnectionString
Else
strReturn = ConfigurationManager.ConnectionStrings("MyConnectionName").ConnectionString
End If
Return strReturn
End Function
Then on the form that needs a DB connection call it like this:
Dim oConnection As New SqlConnection(YourClassName.GetConnectionString("MyConnectionName"))
<connectionstrings>
<add name="MyConnectionName">
connectionString="Persist Security Info=False;Data Source=localhost;Initial Catalog=db;Integrated Security=SSPI;Trusted_Connection=TRUE;Application Name=AppName"
providerName="System.Data.SqlClient" />
</add>
</connectionstrings>
If you mis-worded your question and need this for an ASP.Net application (not Windows Forms) reply and let me know and I'll help as much as I can
"Well yes, it is an Integer, but it's a metrosexual Integer. For all we know, under all that hair gel it could be a Boolean."
Tom Welch
|
|
|
|
|
in windows application i want to apply validation checks.i hv trued one for empty textbox
i.e.
if (textBox1.Text == "")
{
MessageBox.Show("Enter phone number", "Error in Input", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.textBox1.Clear();
this.textBox1.Focus();
return;
}
how to validate numbers and alphabetic characters??
|
|
|
|
|
try ur code on key press event
if(e.keychar>=67 && e.keychar<=90)
{
e.handed=true;
}
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
it is giving error
'System.Windows.Forms.KeyPressEventArgs' does not contain a definition for 'keychar'
software student
|
|
|
|
|
this is the code.
private void keypress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar >= 67 && e.KeyChar <= 90)
{
e.Handled = true;
}
}
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
I made a page using CreateUserWizard but I restrict it for Admins only. The problem is when an Admin create an account for the new user, after completing the steps, it automatically change the logged in Admin to the new created account. Is there anyway not to login after creating an account? Except for the Security setup wizard on ASP.NET Configuration. 
Thanks!
|
|
|
|
|
what code u r writing ?
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
I'm using Visual Studio 2005 and I'm writing ASP.Net pages. CreateUserWizard is very easy to use but I don't know how to change the settings so that after creating a new User, it will not automatically log-in on the user... Only Admins could create a new user.
|
|
|
|
|
Can you copy over the aspx code here?
<< >>
|
|
|
|
|
I want to do it for Drag & Drop & upload.
i want to drag a file from my desktop & drop on my web page.
Can i getimage path,image which i dropped.
it will be a dynamic file may be some image, text file or anything.
Thanx In Advance.
|
|
|
|
|
You'll need to embedd an activeX or .NET control into your page in order to offer this functionality, you can't do it otherwise.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
|
Thank you for your reply.
I was not think about window application. I want to Drag file from client's machine (e.g. Desktop) and Drop it on the web page. and upload it. Please try the code below in html file
http://www.codingforums.com/showthread.php?t=36896
I want same as above but I want to see all dragged images on web page in thumbnail format and the upload.
Thanks in advance.
|
|
|
|
|
hi
I am using asp.net 1.0.
My problem is, button click event firing two times wen i click one it.
how i solve this issue??
All I ever wanted is what others have....
CrazySanker
|
|
|
|
|
A button event generates a postback. There is no way you're getting two click events for one click, there's something wrong in your code. Try posting it.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
hello vipin,
I think the problem has arised due to the HTML design so plz check ur design. and also bcoz of the events that r fired when the page is created like initalze component(),page load,rendering... etc
ok try like that u will get byeee
Murali
|
|
|
|
|
Whenever I try to connect to the PUBS.MDF database, a login failed error message will appear.
I defined the connection string in the web.config file under the connectionstrings section like this:
[code]
add name="Pubs" connectionString="Data Source = localhost\SQLEXPRESS; Initial Catalog=Pubs;Integrated Security=SSPI"
[/code]
And setup the connection in the click event of a button:
[code]
Dim connectionString As String = WebConfigurationManager.ConnectionStrings("Pubs").ConnectionString
Dim myConnection As New SqlConnection(connectionString)
myConnection.Open()
..........
[/code]
And I put the PUBS.MDF file in the same folder as the vb source files.
How do I connect to the database correctly?
|
|
|
|
|
KaKa` wrote: add name="Pubs" connectionString="Data Source = localhost\SQLEXPRESS; Initial Catalog=Pubs;Integrated Security=SSPI"
This looks for a named instance of SQL Server called SQLEXPRESS, and then tries to find a DB called pubs in there. It sure as hell isn't going to find a file called 'pubs.mdf' ( which is an access database )
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
what is the database extension supposed to be?
I downloaded it from the microsoft website and it states that these databases are for sql server 2000.
|
|
|
|
|
hello,can we download a .exe file without entering into a website,is it possible,i think we can do that by using RMI,but 'm not sure
can u pls help me out,as soon as possible...
Regards
shilpa
|
|
|
|
|
Not sure exactly what you mean - for a client to download a program, they need to request it from a web page, or connect to a site via an FTP program. You can't download a program without a program on the client end attempting the download, via HTTP or FTP, or via a web service call ( which is HTTP anyhow )
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Is it., After getting regular expression, still he don't know how to integrate that with javascript,. it's shame on him. He can integrate this expression with javascript and that will give the result what he expected..
This is the article u have posted ystrday... See , this is the place to share ideas but not keep a Group Discussion or a quarllying place ok.. If we dont know we can post the article and share the doubts but wat is there to feel ashame ...So, plz dont use this kind of terminlogies...We need to help each other then only knowledge will be gained.
This applies to to even SSK also...
ok Murali....
Murali
|
|
|
|
|
1 - never post personal messages as new posts, the odds are that navneeth won't see this, because of other posts that will occur
2 - Goodness knows what you're talking about here. I am sure the terminology he used was correct, it's not his fault you didn't understand it ( assuming I've read you right ).
3 - If you google, you'll find out how to use regex in javascript, it's widely documented.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
