Comments by Member 11148509 (Top 126 by date)

ya i have tried that but dint work out ...i have small doubt..i have entered characters in textbox so it should immediately tell only numeric are allowed ...can i get that by using this regularexpression ???actually im doing using telerik and using radtextbox...

I'm using utilityhelper its better option me to write directly rather than using datasource....

i have used image datatype in database ...and i want to show image in radbinaryimage

this is the code for preview of the image and the code which i have shared in the starting for inserting into database ..imusinf radaschyncupload and radbinary image..
protected void Page_Load(object sender, EventArgs e)
{
RadAsyncUpload.FileUploaded += new Telerik.Web.UI.FileUploadedEventHandler(RadAsyncUpload_FileUploaded);

Radbtn_Upload.Click += new EventHandler(RadBtn_Upload_Click);
}

protected void RadAsyncUpload_FileUploaded(object sender, FileUploadedEventArgs e)
{
Bitmap bitmapImage = ResizeImage(RadAsyncUpload.UploadedFiles[0].InputStream);
System.IO.MemoryStream stream = new System.IO.MemoryStream();
bitmapImage.Save(stream, System.Drawing.Imaging.ImageFormat.Bmp);
RadBinaryImage.DataValue = stream.ToArray();

}
public Bitmap ResizeImage(Stream stream)
{
System.Drawing.Image originalImage = Bitmap.FromStream(stream);

int height = 100;
int width = 100;

Bitmap scaledImage = new Bitmap(width, height);

using (Graphics g = Graphics.FromImage(scaledImage))
{
g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;
g.DrawImage(originalImage, 0, 0, width, height);
//g.DrawString("My photo from " + RadComboBox2.SelectedItem.Text + ", " + RadComboBox1.SelectedItem.Text, new Font("Tahoma", 18), Brushes.White, new PointF(0, 0));
return scaledImage;
}

protected void Page_Load(object sender, EventArgs e)
{
RadAsyncUpload.FileUploaded += new Telerik.Web.UI.FileUploadedEventHandler(RadAsyncUpload_FileUploaded);

Radbtn_Upload.Click += new EventHandler(RadBtn_Upload_Click);
}

protected void RadAsyncUpload_FileUploaded(object sender, FileUploadedEventArgs e)
{
Bitmap bitmapImage = ResizeImage(RadAsyncUpload.UploadedFiles[0].InputStream);
System.IO.MemoryStream stream = new System.IO.MemoryStream();
bitmapImage.Save(stream, System.Drawing.Imaging.ImageFormat.Bmp);
RadBinaryImage.DataValue = stream.ToArray();

}
public Bitmap ResizeImage(Stream stream)
{
System.Drawing.Image originalImage = Bitmap.FromStream(stream);

int height = 100;
int width = 100;

Bitmap scaledImage = new Bitmap(width, height);

using (Graphics g = Graphics.FromImage(scaledImage))
{
g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;
g.DrawImage(originalImage, 0, 0, width, height);
//g.DrawString("My photo from " + RadComboBox2.SelectedItem.Text + ", " + RadComboBox1.SelectedItem.Text, new Font("Tahoma", 18), Brushes.White, new PointF(0, 0));
return scaledImage;
}

Im using Radasyncupload...can u tell me how to do in that ....i just want to store to database that's... im able to select image and also see preview of that ..

Reply Modify the comment. Delete the comment.
ALTER procedure Insert
as
begin
@FirstName nvarchar(50),
@LastName nvarchar(50),
@Photo image,

INSERT INTO Employee
(FirstName, LastName,photo)
VALUES (@FirstName , @LastName,@Photo)
end

ALTER procedure Insert
as
begin
@FirstName nvarchar(50),
@LastName nvarchar(50),
@Photo image,

INSERT INTO Employee
(FirstName, LastName,photo)
VALUES (@FirstName , @LastName,@UserType,@Photo)
end

ALTER procedure Insert
as
begin
@FirstName nvarchar(50),
@LastName nvarchar(50),

@LastName nvarchar(50),
@Photo image,

INSERT INTO Employee
(FirstName, LastName,photo)
VALUES (@FirstName , @LastName,@UserType,@Photo)
end

ya ya i have removed that and tried but same problem...actualy in my code i have code in ispostback in page load..so when i kept break point and saw..after i press upload it is going to postback and checking and then coming to button click ...with in this time fileupload.filename is unable to maintain state...this is what i have understood..just thinking of solution for this ..hope u got me and suggest me some solution ...can i use session????or postbacktriggers???

ya i have tried this too ..when i execute that its not going inside the loop...i unable to understand what to do ..

i dint solve it ...i have tried inanother pge where in i got the output...with the same code when im trying in my mian page im not getting that ...can i use postback triggers?

ya its inside update panel ..and k will try to use something else

Anyother code whothout using ifelse...

no error...couldn't do paging....i need process ..i mean how to do ...

connection string

<add name="constr" connectionstring="Server=; Database=databasename;Integrated Security=True " providername="System.Data.SqlClient">

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());

SqlDataAdapter da = new SqlDataAdapter("select * from EmployeeAndPersonalInfo", con);
DataSet ds = new DataSet();
da.Fill(ds, "EmployeeAndPersonalInfo");
RadGrid_Details.DataSource = ds;
RadGrid_Details.DataBind();

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from tablename", con);
DataSet ds = new DataSet();
da.Fill(ds, "tablename");
RadGrid_Details.DataSource = ds;
RadGrid_Details.DataBind();

connection string

<connectionstrings>
<add name="DBCS"
="" connectionstring="Server=.;Database=project; Integrated Security=SSPI;" providername="System.Data.SqlClient">

namespace BusinessLayer
{
public class EmployeeBusinessLayer
{
public IEnumerable<employee> Employees
{
get
{
string connectionString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
List<employee> employees = new List<employee>();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("AllEmployees", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Employee employee = new Employee();
employee.EmployeeID = Convert.ToInt32(dr["EmployeeID"]);
employee.Name = dr["Name"].ToString();
employee.Gender = dr["Gender"].ToString();
employees.Add(employee);

}
}
return employees;

}
}
}

}


connection string:

<connectionstrings>
<add name="DBCS"
="" connectionstring="Server=.;Database=project; Integrated Security=SSPI;" providername="System.Data.SqlClient">

ya have done it showing status as started....

Checked the site couldn't solve the problem

Thank you

Can we do it without using library...ie another way ??/