|
We are looking either an ASP.NET web toolkit or someone who can assist us for the handling images within a SQL Server database and displaying them. We do not need editing, conversion, PDF. Does anyone know of a ASP.NET DLL toolkit that will do this. More on the requirements below.
We would like to create a web application in ASP.NET for doing web based training for State employees. The concept is to have a set of Courseware pages that the creators of the training content can insert images and text into. Then the students (State employees) will be able to view the images and text from a web browser and takes the courses.
The images for the training content are going to be clipboarded using a very popular and State supported package called SnagIt from TechSmith. From what we understand the native clipboard format for SnagIt is PNG. We do not want to save the snag’ed images to files. The SnagIt product has a wonderful virtual clipboard that eliminates all of the issues with saving images to files and remembering the names later.
The images that are captured using SnagIt and clipboarded will be stored in a SQL Server 2005 database in either an (Image) or (VarByte) data typed column. We do not want to use saved image files with links to the files defined in the SQL Server database and then manage the transfer of the images files between the courseware creator and the web server. Our goal is to simplify the courseware creation using the supported environment and tools (SnagIt).
Our research indicates that you can not write ASP.NET web code that uses the windows clipboard because of security concerns. Many Google’d pages indicate this can only be done with a 3rd party DLL or Active-X components. The State does not allow Active-X but will allow a DLL within the web application.
We have created a test platform with a SQL Server 2005 database and the table with the (Image) data type column in it. We can Snag images and clipboard them into the image column using an MSAccess simple form linked to the database. We can then page through the images using the MSAccess form. We are trying to avoid having to use MSAccess for the courseware development part of this application. We really want the entire solution to be web-based.
Even with the MSAccess form and saved images in the SQL Server 2005 database we can not get a web page to just display the images from the database. We have a number of posting in the ASP.NET forum in an effort to resolve this. We have tried HTTP Handler, byte arrays, memory streams, etc to no avail. We think the issue has to do with us clipboarding the image from SnagIt and how it’s saved using MSAccess. Again we want to avoid any MSAccess in this solution.
We have started research on 3rd party toolkits but so far all of them are for heavy duty image processing, editing, etc. We need a simple data bindable image control for SQL Server 2005.
John H Schuster
Consultant
Phoenix Workgroup COmputing LLC
(517) 927-7400
|
|
|
|
|
John Schuster wrote: The State does not allow Active-X but will allow a DLL within the web application.
The state is then stupid, they end up being the same thing :P
What you need should be easy to write, it's just a bit of code that runs in a web page, and grabs an image from the clipboard, and sends it through to the server.
Here's a thought. The client is running snagit and needs to send you their screenshots, right ? Why does this have to be a web app ? Why not a client side app that sends the images to a webservice or something ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi there,
I am in a problem..like i have one gridview and the DataKeyNames is say "ID"
i have one imagebutton field for changin the status of a customer in that image button i setup one commandargument field say "StatusValue"..and the CommandName is Status...
when i click status button ie, in the "GridView1_RowCommand" event i need both the values ie ID and StatusValue corresponding to that row....
Can anybody give me a help to solve this...
i am using asp.net 2.0 and c#
|
|
|
|
|
Use the gridviews rowdatabound event.
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Button Button1 = (Button)e.Row.FindControl("Button1");
DataRowView drv = (DataRowView)e.Row.DataItem;
Button1.attributes.add("id", dvr["id"].tostring());
}
}
I didn't get any requirements for the signature
|
|
|
|
|
hi
thanks for your response..but i coudn't able to come up with a result...i set the attributes with id value
but how can i retrieve those values...now i have command arguemnet in image button and the id value is in imagebutton's ID value..so how can i retrieve those values in row command u have any idea.
regards
alex.
|
|
|
|
|
Button button1 = (button)sender;
button1.attribute["ID"].value ?
I didn't get any requirements for the signature
|
|
|
|
|
Hi,
No that's not possible..because gridview is the sender....because image button is inside the gridview..i tried but it makes error....
regards
alex
|
|
|
|
|
Sorry, I guess I usually used an item template column.
You should still be able to determine the gridviewrow and use its findcontrol method. If that doesn't work you could pass both values as the command argument and use string.split. I'm sure you can figure it out.
I didn't get any requirements for the signature
|
|
|
|
|
Hi,
Thanks man finally it works..i used both values in the command arguement and split it out...
thanks once again.
regards
alex.
|
|
|
|
|
r widgets and webparts same ?
plz help me...........
|
|
|
|
|
Yes, a WebPart is a Widget, created for ASP.NET, MOSS...
Calin
|
|
|
|
|
To create a webpart, in Toolbox, go under WebParts tab and use WebPartManager and WebPartZone and add something to it, or by inheriting from System.Web.UI.WebControls.WebParts.WebPart class and override CreateChildControls() to add controls.
Calin
|
|
|
|
|
thank u calin,
can u plz suggest any link to develop widgets
|
|
|
|
|
Hi all,
I have a treeview control, loading data using an xml file, and have a trigger [TreeView1_TreeNodePopulate] in the codebehind. Don't know for some reason it is not getting fired. Even though I'm raising an error in my trigger, it seems it doesn't work.
Could anyone help me find this PLEASE?
Here is my aspx:
<asp:treeview id="TreeView1" runat="server" datasourceid="BookXmlDataSource" xmlns:asp="#unknown">
<databindings>
<asp:treenodebinding datamember="Book" textfield="Title" />
<asp:treenodebinding datamember="Chapter" textfield="Heading" />
<asp:treenodebinding datamember="Section" textfield="Heading" />
</databindings>
</asp:treeview>
<asp:xmldatasource id="BookXmlDataSource" xmlns:asp="#unknown">
DataFile="Book.xml"
runat="server">
</asp:xmldatasource>
codebehind:
<br />
protected void Page_Load(object sender, EventArgs e)<br />
{<br />
TreeView1.TreeNodePopulate += new TreeNodeEventHandler(TreeView1_TreeNodePopulate);<br />
}<br />
<br />
protected void TreeView1_TreeNodePopulate(object sender, TreeNodeEventArgs e)<br />
{<br />
throw new Exception("alsdjfla");<br />
}<br />
Thanks A LOT.
Muthu
|
|
|
|
|
set PopulateOnDemand = true
Calin
|
|
|
|
|
I tried this. But still it is not working. Thanks for the quick response.
|
|
|
|
|
Im trying to print to a printer shared on a network , keep on getting this error
Im allready using impersonation on the server where the web app is hosted
If anyone can please give me pointers , I am able to print to some printers on the network,
is there maybe some settings on the client pc a need to change for the printer or something ,
Im realy stuck on this one  
|
|
|
|
|
Hello All,
I am trying to delete rows from database . For this i am using following code...
When i debug my web service it shows me row.count decrease or increase when i delete or add row in "dtimages" databale respectively.
But when i finaly update my dataset "ds" using dataadaptor then row deletion changes are not shown in DB but row addition has been successfull.
<b>Please help as soon aspossible.</b>
<code>using (SqlDataAdapter dataAdapter = new SqlDataAdapter(ol_DB.lfnGetCommandObject("Select * from property_image where property_nbr = " + Prop.property_nbr)))
{
using (SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(dataAdapter))
{
DataSet ds = new DataSet();
dataAdapter.Fill(ds, "property_image");
DataTable dtImages = ds.Tables["property_image"];
int AllRowCount = dtImages.Rows.Count;
int RwCount = -1;
int cntImages = 0;
int pdfImages = 0;
foreach (DocumentPropertyProperty_image allImage in Prop.Images)
{
if (allImage != null)
{
if (allImage.Img_Org_Name != null)
{
if (System.IO.File.Exists(FeedFolder + "\\" + allImage.Img_Org_Name))
{
try
{
DataRow[] drSelected = dtImages.Select("Img_Org_Name = '" + allImage.Img_Org_Name + "'");
if (drSelected.Length > 0)
{
RwCount++;
lfnUpdateImage(drSelected[0]);
if (allImage.img_file_type == 0)
cntImages++;
else
pdfImages++;
}
else
{
RwCount++;
if (allImage.img_file_type == 0)
{
lfnAddImage(Prop.property_nbr, allImage, ref dtImages, cntImages + 1);
cntImages++;
}
else
{
lfnAddImage(Prop.property_nbr, allImage, ref dtImages, pdfImages + 1);
pdfImages++;
}
}
}
catch (Exception e)
{
Remarks += e.Message + "\r\n";
}
}
}
}
}
for (int rcnt = AllRowCount-1; rcnt > RwCount ; rcnt--)
{
DataRow drw = dtImages.Rows[rcnt];
//drw.Delete();
//drw.AcceptChanges();
dtImages.Rows.Remove(drw);
//dtImages.Rows.RemoveAt(rcnt);
dtImages.AcceptChanges();
}
dataAdapter.Update(ds);</code>
|
|
|
|
|
Hi,
i have a one integer type field in table. it allows null values.
i want to pass null to the integer field?
how can i pass null values to integer type?
Regards
Keyur Satyadev
|
|
|
|
|
|
Are you talking about normal integer or integer Database type.
If you are talking about Database integer field, pass DBNull.Value from your application.
If you are talking about int of application end, you cannot assign null to value type data. Rather you can assign default value to integer.
do int i = default(int);
Hope it helps
Abhishek Sur
|
|
|
|
|
i want to pass the value null to my database but as you know
integer can not accept the null values. what should i have to do so that
integer can accept and allow to pass null values.
in my application integer is not accepting the null as integer.
it not allow to convert.
if i m convert the value it will treated as 0 for null.
Regards,
Keyur Satyadev
|
|
|
|
|
|
try to use DBNull or sommething like that....
|
|
|
|
|
Hi friends, i am asked to do my final year college project on COLLEGE INFORMATION SYSTEM maintenance s/w. The part of which requires me to develop a module which automatically downloads the marks of all the students in the dept, as soon as the result is announced by the university and then produce an analysis report on no. of passed students, distinction students,etc ...
Can anyone give me any idea on how i could achieve it. I need your help desperately cause deadline for the project submission is march 6 2009. Pl reply as soon as possible.[:'(][:'(][:'(]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
