|
Register the database server in you local systems enterpirse manager using SQL authentication.
^[^]
Sathy
|
|
|
|
|
Hi
thanks for the articles
One thing i have noticed is that in the error log there is not trace of the connections attempts i have tried to make from the web sever
is there a reason for this?
thanks again
|
|
|
|
|
Can you tell me the steps you followed to register the server database ??
Sathy
|
|
|
|
|
thanks for the reply
I am not the database administrator however and he is not contactable today
Shall I give you a detail of what I have done so far to try and connect the web server to the sql server which are on different machines.
Our firewall is not blocking any ports
web server is not blocking any ports from being accessed
The port 1433 and IP address 172.16.0.10 can be pinged from my machine
The same can be done using telnet, both are successful
I have checked my connection string that I am using and it seems to be correct.
TCP/IP and Named Pipes are both enabled on SQL Server
any help would be great thanks
|
|
|
|
|
Do you have SQL authentication username and password for the database server ??
Sathy
|
|
|
|
|
yes i think so
i have access to the sql server, where would i find this ifnormation?
in the connection string would I just use the normal login and password for the database?
thanks
|
|
|
|
|
ok Im getting a new error message now
it was the 500 error message when i try and run the code but now i turned friendly error messages off its:
No suitable nodes are available to serve your request.
|
|
|
|
|
Yes, how about this rebuttal: This is the ASP.NET forum. Not the ADO.NET one. Nor the SQL Server one.
Try googling for "surface area configuration" sql 2005 and you might get lucky.
|
|
|
|
|
Its not an ado.net or sql server forum!!?
You could have fooled me, is that why it says Forum: ASP.NET at the top of the screen!
Thanks for the suggestion but I'm using SQL 2000
|
|
|
|
|
ASP.NET is the web part of the .net framework. Not the database part. So indeed, you are absolutely right, it says clearly on top of the screen that this is NOT the ADO.NET (which is the data access part of the .net framework) or the SQL Server forum.
In SQL Server 2000 remote connections are enabled by default. Its from the time when MS felt that security should be an option for people with special interests.
|
|
|
|
|
and did you know Microsoft Word is a product of Microsoft and an apple mac computer is made by wait for it... Apple
I'm joining in with you as it must be "Day to give obvious comments day"
Yes Microsoft has got over excited about security(see Vista or any new product after 2004)
|
|
|
|
|
I disagree. It is high time it's taken seriously.
Mocking me for pointing out that you're posting to an inappropriate forum however is not overdue.
|
|
|
|
|
I can not bind a validator to any of my controls
the validator property named "ControlToValidate" does not recognize any of my controls (I am using Visual Studio.NET 2003)
Can anybody advise the reason
Mohamed Gouda
Egypt
|
|
|
|
|
Hi,
add one new form in your website and add new textbox in form and add requirefield validator.
Now check and post here.
Thanks,
Sun Rays
To get something you must have to try once.
My Articles
|
|
|
|
|
Sun Rays dd one new form
This works properly, but the problem occure in case of importing predesigned html form
However, I discovered that I had to convert all my form fields to server controls before validating them
Thanks for help
Mohamed Gouda
Egypt
|
|
|
|
|
Hi,
controlValidator are used only for Server control.
So change as per desired situation.
Thanks,
Sun Rays
To get something you must have to try once.
My Articles
|
|
|
|
|
i am using this code to bind the data to the combo box .its showing error "Cannot bind to the new display member.
Parameter name: newDisplayMember"
i dont know what to do
con.Open();
SqlDataAdapter da = new SqlDataAdapter("Select emp_id from ep_emp_personal", con);
DataSet ds = new DataSet();
da.Fill(ds);
cobo_emp_id.DataSource = ds;
//cobo_emp_id.DisplayMember = ds.Tables[0].Columns["emp_id"].ToString();
cobo_emp_id.DisplayMember = "emp_id";
cobo_emp_id.ValueMember = "emp_id";
// cobo_emp_id.DataBindings.Add("Text",ds,"emp_id");
|
|
|
|
|
Cuckoo wrote: cobo_emp_id.DataSource = ds;
Change this to
cobo_emp_id.DataSource = ds.Tables[0];
|
|
|
|
|
How can i convert System.Drawing.Image to System.web.UI.Image in asp.net with C#.
byte[] storedImage = (byte[])scmd.ExecuteScalar();
MemoryStream stream = new MemoryStream(storedImage, 0, storedImage.Length);
System.Drawing.Bitmap bmp = new System.Drawing.Bitmap(stream);
bmp.Save(stream, ImageFormat.Gif);
Upto this i have . After this what should i do.
Is there any other way to display directly from the sql where i have stored the image with Image datatype.
VanithaVasu
|
|
|
|
|
u want draw image directly on aspx page From Database
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
|
|
|
|
|
VanithaVasu wrote: How can i convert System.Drawing.Image to System.web.UI.Image in asp.net with C#.
You have to save the Image to the Server (file path) and set the ImageUrl property of the Image control to the file path.
VanithaVasu wrote: Is there any other way to display directly from the sql where i have stored the image with Image datatype.
You can also use Binary datatype, which is common for all the binary files (doc, xls, whatever)
|
|
|
|
|
No, I have saved the image in the sql column as image datatype.
And i have retrieved the image and converted to bytes[] as in the previous message.
I am trying whether it works out from System.Drawing.Image to System.web.UI.Image.
My Actual problem is to load the image directly to the treeview icons.
Also I don't get "Image" property in the Intelisense box. It shows only the "Image Url" Property. How to define the image.
VanithaVasu
modified on Monday, February 11, 2008 6:15 AM
|
|
|
|
|
VanithaVasu wrote: Also I don't get "Image" property in the Intelisense box. It shows only the "Image Url" Property. How to define the image.
That is what I am telling you. There is not property as "Image" (which accepts bytes/System.Drawing.Image as value) in web world. So, you have to get the bytes and store it as a file (say mypicture.jpg), then use that image url and assign that to the ImageUrl property of your TreeView icons.
|
|
|
|
|
You would have to create a seperate page or preferable an http handler for you image. You would set the image url on your tree view to this page with, for example, a query string parameter identifying the image in the database to be retrieved.
e.g. ImageUrl = "MyImagePage.aspx?ImageId=XX";
Then inside your MyImagePage.aspx you would write some code along the lines of that shown below. Note: You must make sure no other content is sent down along with the bytes i.e. no html in the code infront if you use an aspx page (which is one reason why a handler would be better).
byte[] abImageData = (byte[])command.ExecuteScalar();<br />
<br />
Response.ContentType = "image/jpeg";<br />
Response.Write(abImageData);<br />
Response.End();
|
|
|
|
|
Hi,
I have a dropdown,textbox,"Go" button and a gridview.I have bind the dropdownlist with the column name that appear in gridview.I have written the following code for binding the dropdownlist with the column that appears in the gridview and call that method on the page load.
public void GetColumnName()
{
try
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].Visible == true)
{
DropDownList2.Items.Insert(i, GridView1.Columns[i].HeaderText);
}
}
DropDownList2.Items.Insert(0, "-- Search By --");
}
catch (Exception ex)
{
lblMsg.Text = "The following Error has Occured:- " + ex.Message;
}
}
Now i want to filter the data in the gridview.If user select a particular column name from the dropdownlist and enter some text in to the textbox and click the "Go buton",the grid view should filter the data according to that column name which user has selected in the dropdown and the text that the user has enter in to the textbox and show it in the gridview.
Please let me know how to filter the data in gridview by column name.Currently i am in the middle of the project.Please explain by giving some example or by providing some useful link related to this topic so that i can refere to.
Thanks&Regards
Pranav dave
Pranav Dave
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
