|
There's two questions here, both easy to answer using articles on this site, or through google.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
I assume that your questions are; "how i can store images in sql and display in C#". 
1) you can´t display images in the gridview, but you don´t need it any way! just trigger your store procedure and display string, int or date data in the gridview and display the images in a picturebox .
2) if you want to know more in how to store images in sql just type "sql image store (whatever)" in search article, and you will get some answers! Theres good articles about it. It´s not hard.
Good Luck
|
|
|
|
|
create a folder in your application folder and store images into that instead of storing them into database, in your database store that image's URL.Now to retrieve them in gridview control bind the gridview's column using Eval method.
for example
in between <asp:gridview xmlns:asp="#unknown">....
<asp:image runat="server" id="myimage" imageurl="<%#Eval(" your="" image="" url="" ")#%>"="" xmlns:asp="#unknown">
use all those formatting like columns and itemtemplates and all the stuff this is just a clue,so obviously a bit messy but if u don't understand ask anything... 
|
|
|
|
|
Hi,
I have 'SQL Server 2000' on 'Windows Server 2003'.
From my application that installed on another computer (with windows XP), I want to connect to my DB (on first computer) but this error appears :
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections
I don't installed SQL Server 2005 at all!
Best wishes
|
|
|
|
|
mehrdadc48 wrote: my application that installed on another computer (with windows XP)
Are you sure that machines doesn't have SQL Server 2005 or SQL 2005 Express installed on it?
"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,
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
