|
Hi,
Double-check your connection string. This error message is generic and doesn't mean that you are actually trying to connect to SQL Server 2005. It only tells that the server defined in your connection string cannot be found.
Some possible reasons:
- wrong server name / ip-address
- no instance name defined if no default instance at server side
- no port defined if the standard port (1433) is not used on server and so on
Hope this helps,
Mika
|
|
|
|
|
Hi Everyone
I need to call two methods, (one written in javascript defined in the header part of an aspx page and the second written in c# in aspx.cs file of the same aspx page) in the button_click action of a button in the aspx page. The first method is about to show the user a please wat page, and the second method processes the user input.
And I can not put the first method from within the second one, because of some problems.
Please help me.
|
|
|
|
|
semiramisContraA wrote: I need to call two methods, (one written in javascript defined in the header part of an aspx page and the second written in c# in aspx.cs file of the same aspx page) in the button_click action of a button in the aspx page.
You can't do that. You can't call an existing Javascript function from the server side event.
Use the client side click event (accessible throught the OnClientClick property of the control) to call the Javascript function.
semiramisContraA wrote: And I can not put the first method from within the second one, because of some problems.
Of course not. When the server side event runs, the request for the new page has already started, so the first function doesn't exist any more. If you would add code to the page from the server side event for calling the Javascript function, that code would load when the page is completed, and it would call the new Javascript function that would be created when the page reloads after postback.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
1 - use the ASP.NET forum in future
2 - read an ASP.NET book, you obvioulsy have no idea how it all works
3 - if you want to show a 'please wait' page while the processing occurs, you need to use AJAX, otherwise your page will be blank if you are using IE.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Hi, i got a database created in ms access 2003. Inside the database, there are 6 tables and a few relationship.
I want to link my database to my inventory system.
My inventory system is created based on MDI. When the application is loaded, the login form is begin created
childLogin = new FrmLogin();
childLogin.ShowDialog(this);
if (childLogin.DialogResult == DialogResult.OK)
{
stripLblLoginAs.Text = "Login As : " + childLogin.Username;
}
I have added a existing datafile to my project (ebms.mdb). I also created a DatabaseManager.cs to check the connection
public class DatabaseManager
{
public OleDbConnection connection;
public OleDbDataAdapter dataAdapter;
public DataSet dataSet;
public string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ebms.mdb";
public bool GetDataConnection()
{
try
{
connection = new OleDbConnection(connectionString);
dataAdapter = new OleDbDataAdapter("select * from staff", connectionString);
dataSet = new DataSet();
dataAdapter.Fill(dataSet, "Staff");
return true;
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message);
return false;
}
}
}
Now, inside my FrmMain, i have created a new object of this DatabaseManager
public partial class FrmMain : Form
{
DatabaseManager dbm = new DatabaseManager();
And inside my form_load i have check the connection
if (this.dbm.GetDataConnection())
{
MessageBox.Show("Connection Established");
}
else
{
MessageBox.Show("Connection Failed");
}
Now, the problem is how do i validate the username and password entered in childLogin with my staff table inside my database..
|
|
|
|
|
benjamin yap wrote: the problem is how do i validate the username and password
Query against your table that holds the login. If it comes back with an empty dataset, then login has failed, otherwise login worked.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select nric,password from Staff where nric = "+txtUsername.Text+" and password="+txtPassword.Text);
like tthis? can you provide me with some example? i have never use access with c# before 
|
|
|
|
|
Yes, something along those lines is a good start. Instead of string concatenation, which allows for sql injection attacks, google up on using parameterized queries for a more secure approach
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
how do i check if row is empty
|
|
|
|
|
After you execute the query and get the dataset back, use the Count property. If it's zero, then the login credentials are invalid.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
do you have any article that can help me with this? as in excuting the query, and getting the dataset?
|
|
|
|
|
Look up the methods in the TableAdapter class and the DataSet class.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
hi friends :
i want to read Prive1.edb file.this file is an exchange database file.
i want to get mailboxes from this file .
is there any one to help me
thx
|
|
|
|
|
This[^] may help?
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
|
|
|
|
|
Hello everyone,
For the following code, what means {0, 3}? I have searched MSDN but can not find the related format description.
String.WriteLine ("{0, 3} : {1}", str1, str2);
thanks in advance,
George
|
|
|
|
|
It's an alignment specification. See this link[^] for more information, especially the examples at the bottom of the page.
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
Thanks Greeeg,
Question answered.
regards,
George
|
|
|
|
|
I'm using Visual Studio 2008 Professional and can't get any other icon to display apart from the default 'gear'. I'm not trying to use my own bitmap - just one from the built in controls.
I'm adding this attribute:
[System.Drawing.ToolboxBitmap(typeof(System.Windows.Forms.TextBox))]
I've tried with with a user control, component and a simple class that inherits from TextBox but none of them work.
I'm sure I had this working in 2005 - is it a 2008 issue?
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
|
|
|
|
|
Wierd. If I complie the control to a dll and then add it to the toolbox via Choose Items it shows the icon.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
|
|
|
|
|
hello, i wonder how it is possible to get hardware information using C#,net! e.g i want to access the thermal sensor of a graphic card , how is it possible ? ! and let me know if it is even possible under C#.net! i gave it a try and turned up with "Sensor class" in MSDN , but i dont know how to use it ,
another question is , as a matter of getting access to hardware infos, is C# limited compared to VC++?
i mean can i do those thing in C# that im capable of doing in vc++?/.. if yes what specifically can be done as hardware manipulating in C#?
tanx in advance
|
|
|
|
|
Member 4166824 wrote: thermal sensor
u can access the info only if the vendor has and gave the ability to Access
it, if not u'll need to try Assembly (
the thermal sensor is problematic
either way to Access hardware u can try The WMI way :
This[^] Will Help Get Started
Have Fun
Never forget it
|
|
|
|
|
Hi,
How to convert mp3 to wav file.How to do it.if anybody know plz.thanks in advance
|
|
|
|
|
http://media-convert.com/[^]
It is said that the most complex structures built by mankind are software systems. This is not generally appreciated because most people cannot see them. Maybe that's a good thing because if we saw them as buildings, we'd deem many of them unsafe.
|
|
|
|
|
Good Day,
I'm working with the AES Decryptor (using RijndaelManaged), but when I try to initialize a byte[] array to store my ciphertext data, it throws an IndexOutOfRange exception.
using (FileStream Ciphertext = new FileStream(_InputPath, FileMode.Open, FileAccess.Read, FileShare.None))
{
using (FileStream PlainText = new FileStream(_OutputPath, FileMode.Create, FileAccess.Write, FileShare.None))
{
using (CryptoStream CStreamWriter = new CryptoStream(PlainText, Decryptor, CryptoStreamMode.Write))
{
byte[] CTextData = new byte[Ciphertext.Length];
The exact error message is: "Index was outside the bounds of the array."
The weird thing is, this only happens for file > 200MB. But for a 150mb file, I have no problem.
Please advice thanks!
It is said that the most complex structures built by mankind are software systems. This is not generally appreciated because most people cannot see them. Maybe that's a good thing because if we saw them as buildings, we'd deem many of them unsafe.
|
|
|
|
|
Perhaps because the system is unable to allocate an array that large.
Don't read the entire file at once, there is no reason to have all the data in memory at the same time. Create a buffer and read only a small part of the file each time.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
