ASP.NET

Colin Angus Mackay1-Feb-09 12:43

*Developer Day Scotland - Free community conference
*Colin Angus Mackay's Blog
*Latest Scottish Developers Newsletter

1-Feb-09 12:43

This might be a completely stupid question, but do you actually have an image in the database, or just a series of bytes that translates to the string "System.Web.HttpPostedFile"

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Remember that the force of gravity can go up as well as down.

vaghelabhavesh1-Feb-09 13:02

vaghelabhavesh

1-Feb-09 13:02

Or is it possible that the image may have not been saved in the database correctly?

Be careful, there is no Undo Button(Ctrl+Z) in life.

Colin Angus Mackay1-Feb-09 13:04

*Developer Day Scotland - Free community conference
*Colin Angus Mackay's Blog
*Latest Scottish Developers Newsletter

1-Feb-09 13:04

crudeCodeYogi wrote:
Or is it possible that the image may have not been saved in the database correctly?

That's what I was implying.

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Remember that the force of gravity can go up as well as down.

Anita_Kamat_inds1-Feb-09 16:19

1-Feb-09 16:19

well in the 2005 sql db the field type is image and when I open the table I field reads BinaryData, does that mean the image is corrupted.

Colin Angus Mackay2-Feb-09 8:43

*Developer Day Scotland - Free community conference
*Colin Angus Mackay's Blog
*Latest Scottish Developers Newsletter

2-Feb-09 8:43

Anita_Kamat_inds wrote:
well in the 2005 sql db the field type is image

image is deprecated, use varbinary(max) instead.

Anita_Kamat_inds wrote:
when I open the table I field reads BinaryData, does that mean the image is corrupted

No, I'm suggesting you never put the image in there correctly in the first place.

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Remember that the force of gravity can go up as well as down.

Anita_Kamat_inds2-Feb-09 9:02

2-Feb-09 9:02

OK, Will try changing the field type, and see what happens. Thanks Man.

Colin Angus Mackay2-Feb-09 9:53

*Developer Day Scotland - Free community conference
*Colin Angus Mackay's Blog
*Latest Scottish Developers Newsletter

2-Feb-09 9:53

Going by what you get back in your application, I suspect it was the input of data from your .NET application that was in error.

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Remember that the force of gravity can go up as well as down.

Anita_Kamat_inds2-Feb-09 10:01

2-Feb-09 10:01

this is the code I am using to insert the image into the db. I think this line of code has en error:

nBytesRead = theStream.Read(Buffer, 0, BUFFER_SIZE);

the BUFFER_SIZE should be the size of the image,not a const. my guess.

const int BUFFER_SIZE = 255;
int nBytesRead = 0;
Byte[] Buffer = new Byte[BUFFER_SIZE];
StringBuilder strUploadedContent = new StringBuilder("");

Stream theStream = uplTheFile.PostedFile.InputStream;
nBytesRead = theStream.Read(Buffer, 0, BUFFER_SIZE);

while (0 != nBytesRead)
{
strUploadedContent.Append(Encoding.ASCII.GetString(Buffer, 0, nBytesRead));
nBytesRead = theStream.Read(Buffer, 0, BUFFER_SIZE);
}

HttpPostedFile UploadPic = uplTheFile.PostedFile;
int UploadPicLength = UploadPic.ContentLength;
byte[] PicArray = new byte[UploadPicLength];
UploadPic.InputStream.Read(PicArray, 0, UploadPicLength);

OleDbConnection conn = new OleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings["XXXXXX"].ConnectionString);

OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;

string strSQL = "Update tbl set FileData= '" + UploadPic + "' WHERE (ID = 'xcv') ";

Anita_Kamat_inds1-Feb-09 16:06

1-Feb-09 16:06

I have an actual image saved in the DB

Anita_Kamat_inds1-Feb-09 16:08

Gridview binding to both base n derived classes

1-Feb-09 16:08

do you think that msg means that the image is corrupted.

dotnet.coder1-Feb-09 2:59

dotnet.coder

1-Feb-09 2:59

I have a employee class and manager class derived from it . I want to show the objects/records of both the base

class (employee class) and derived class (manager class) in a single gridview . How can i bind both the base

class n derived class in a gridview ? pls send me a link or code . In addition to this , i want to show the D'Oh! | :doh:

records of base class and dervied class with different colours on grid ? how can i do that ? pls help , its

urgent !

Re: Gridview binding to both base n derived classes

Manas Bhardwaj1-Feb-09 4:01

Manas Bhardwaj

1-Feb-09 4:01

dotnet.coder wrote:
pls send me a link or code

www.rentacoder.com

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Label and Absolute Positioning

swjam1-Feb-09 1:15

swjam

1-Feb-09 1:15

I would like to be able to select absolute positioning for 'Label' controls but whenever I select this control type the 'Position...' item in 'Format' is disabled. Why is it so? Is there a way to select absolute positioning for this type of control? Thanks!

----------------------------------------------------------
this is a sig++

Autocomplete AJAX

CrimeanTurtle20081-Feb-09 0:23

CrimeanTurtle2008

1-Feb-09 0:23

Hi All,

I am trying to use a autocomplete Ajax tool for a textbox to register search possibilities from the database. For some reason when I load up the application nothing happens. My web method is below and Im not sure if there is anything wrong with it since it does return an array of strings from the datatable.
Would someone be able to assist with this? Many thanks and kind regards.

<br />
using System;<br />
using System.Collections;<br />
using System.Linq;<br />
using System.Web;<br />
using System.Web.Services;<br />
using System.Web.Services.Protocols;<br />
using System.Xml.Linq;<br />
using System.Collections.Generic;<br />
using System.Data;<br />
using System.Configuration;<br />
<br />
using System.Web.Security;<br />
using System.Web.UI;<br />
using System.Web.UI.HtmlControls;<br />
using System.Web.UI.WebControls;<br />
using System.Web.UI.WebControls.WebParts;<br />
<br />
using System.Data.SqlClient;<br />
<br />
/// <summary><br />
/// Summary description for WebService<br />
/// </summary><br />
[WebService(Namespace = "http://hello.org/")]<br />
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]<br />
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. <br />
[System.Web.Script.Services.ScriptService]<br />
public class WebService : System.Web.Services.WebService {<br />
<br />
    public WebService () {<br />
<br />
        //Uncomment the following line if using designed components <br />
        //InitializeComponent(); <br />
    }<br />
<br />
<br />
   <br />
<br />
 <br />
[WebMethod]<br />
    public  string[] GetCountry(string country)<br />
    {<br />
<br />
        string query = "SELECT COUNTRY FROM CUSTOMERS WHERE COUNTRY LIKE @Country";<br />
        using (SqlConnection conn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\NORTHWND.MDF;Integrated Security=True;User Instance=True"))//"Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\NORTHWIND.MDF;Integrated Security=True;User Instance=True"))<br />
        {<br />
<br />
            SqlDataAdapter adapter = new SqlDataAdapter(query, conn);<br />
            adapter.SelectCommand.Parameters.Add("@Country", SqlDbType.VarChar,15).Value = country + "%";<br />
            DataTable dt = new DataTable();<br />
            adapter.Fill(dt);<br />
            string[] items = new string[dt.Rows.Count];<br />
            int i = 0;<br />
            foreach (DataRow dr in dt.Rows)<br />
            {<br />
                items.SetValue(dr["Country"].ToString(), i);<br />
<br />
                i++;<br />
            }<br />
            return items ;<br />
<br />
<br />
<br />
<br />
        }<br />
    }<br />

javascript

kushalrshah1-Feb-09 0:06

kushalrshah

1-Feb-09 0:06

how to open a new window in asp.net using javascript? i should also be able to control its size parameters . and i want to place some controls like textbox in it..

mr_muskurahat1-Feb-09 3:17

mr_muskurahat

1-Feb-09 3:17

its a basic question just read javascript window.open function...

umerumerumer

vaghelabhavesh1-Feb-09 12:56

vaghelabhavesh

1-Feb-09 12:56

You can use window.open()[^] javascript method.

window.open ("http://www.codeproject.com","mywindow","location=1,status=1,scrollbars=1,width=100,height=100");

Be careful, there is no Undo Button(Ctrl+Z) in life.

kushalrshah1-Feb-09 17:57

kushalrshah

1-Feb-09 17:57

but i want to keep textboxes and labels in that window and according to values entered in that newly opend window specific event should be fired.

kushalrshah1-Feb-09 17:58

kushalrshah

1-Feb-09 17:58

but i want to keep textboxes and labels in that newly opened window and according to that values entered by the user specific event should be fired