|
Try changing the double quotes to single quotes. I haven't looked closely at this but first guess is that is causing the problem.
|
|
|
|
|
SQL query parameters are in single quote.
|
|
|
|
|
'" & Convert.ToInt32(Session["ProductId"]) & "', field_type='" & DropDownList & "', field_ID='" & ddPCBackSide & "'"
try by using this
hi to all
with regards,
susa
|
|
|
|
|
Can we use static variables to maintain state in ASP.Net Application in place of storing at Application Object? What are merits/demerits
Abhinav
|
|
|
|
|
In traditional ASP, we always had the Application object to store application-wide variables in. This of course came at the price of memory allocations. In .NET we can now take advantage of Static Variables, which in most cases can be faster than accessing the Application object.
In .NET, most objects are actually classes, and Global.asax is no exception. To take advantage of this, we first have to give our Global.asax a Classname. We do this by adding the directive naming mine 'MyGlobals':
<%@ Application Classname="MyGlobals" %>
Then, we specify our Static Variable inside the script tags, using the 'Public' and 'Shared' keywords in the Global.asax:
VB:
Public Shared sGreeting as String = "Visit HarrisonLogic.com!"
C#:
Public Static String sGreeting = "Visit HarrisonLogic.com!"
Now that we have the variable 'sGreeting' set up, we can call it directly from our .aspx page using the Class name and the Variable name:
x = MyGlobals.sGreeting
But in case of at some sitiations you may need to acces certain data with respect to the applications like storing number of hit counts for the application.
Major differences
------------------
1) Static variables cannot persist its value after server post backs.
2) But Application object will persist its value after server post backs
Regards
Mohan P
|
|
|
|
|
i would like to create a .aspx page prgramaticlly in asp.net.
dolly
|
|
|
|
|
Self modifying code is very rarely needed in programming.
What is it that you think would be best solved using this?
---
b { font-weight: normal; }
|
|
|
|
|
In this case you have to wite Inline script for this page. Simply create a string and save it as ASPX.
Note that in page directive Codebehind attribute should not be there and do write all the login in
tag
Nobody is perfect i'm Nobody
|
|
|
|
|
I created a project in C# ASP.net...and i called Excel shett on main window....
the problem is i m not able to resize the excel sheet....its taking full window place........
i want ....Excel sheet should take half part of that windows.....Is it possible....if yes then how?
also i want to know that can we restrict the noumber of rows and columns in the windows.....
krishnarjun
|
|
|
|
|
Hi everyone,
I have a situation where I must add ImageButtons dynamically on a page. This I managed to do, but I need them to respond to the Click event and they won't.
Here's a snippet which represents what I'm doing:
public partial class _Default : System.Web.UI.Page
{
ArrayList imagenes = new ArrayList();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ImageButton ib3 = new ImageButton();
ib3.ID = "ib3";
ib3.ImageUrl = "Puesta de sol.jpg";
ib3.Click += new ImageClickEventHandler(ImageButton_Click);
ib3.Width = new Unit(100, UnitType.Pixel);
ib3.Height = new Unit(100, UnitType.Pixel);
form1.Controls.Add(ib3);
imagenes.Add(ib3);
Session["Imagenes"] = imagenes;
}
else
{
imagenes = (ArrayList)Session["Imagenes"];
foreach (ImageButton ib in imagenes)
form1.Controls.Add(ib);
}
}
protected void ImageButton_Click(object sender, ImageClickEventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), null, "alert('HEY');", true);
}
}
After clicking on the ImageButton, the page reloads, enters the Else clause, the ImageButton is restored, but it won't enter the Click handler.
Also, I tried setting the handler manually inside the Else clause after the control has been added to the form but it won't enter the handler either.
My guess is this is happening because asp.net is actually assigning the handler, but the call to the handler is simply 'lost' during the restoration of the controls since it appears asp.net expects to fire events for 'static' controls only.
I've checked that when a Click event is fired for a 'static' ImageButton, the execution path goes through the Page_Load first and ends into the handler. That's why i re-create the control in the Else clause in Page_Load.
It's not as important for me to get every delegate for each control restored(which i guess it actually is) and working, as it is getting all of them getting into one handler as expected, since I'll possibly assing all of them the same handler.
Thanks a lot in advance for any help you could provide,
Oxi
-- modified at 4:52 Tuesday 11th July, 2006
|
|
|
|
|
Ok, strangely enough, when I set the handler now, after re-creating the controls, its working. I'm sorry, i thought i had tested this yesterday already.
I guess I can go on now.
Nonetheless, I'm still interested in a way of storing and retrieving the delegates just in case i stumble uppon a situation where I actually need to use different event handlers for different controls.
Thanks for your support,
Oxi.
|
|
|
|
|
I am using Datagrid and in it Questions are being displayed from Database.So when user print these questions then Datagrid Header is displayed only on first page .I want datagrid header to be displayed on all print pages.How can this be done.
|
|
|
|
|
Hello All,
I'm trying to develop an application where, i have a flash file running in an ASPX page and that page contains an aspx save button. I need to capture a portion of the screen(i 've filled a rectangle with color and an image in flash-- this need to be captured) and save that as a jpg file in the server on an aspx button click. Code behind is C#.net.
Can anyone help me.
Regards,
jeeva
|
|
|
|
|
You can't do that using ASP.NET. As the graphics is shown on the client computer, you will need a component that runs in the browser that captures the graphics and sends it to the server.
You can't even use a server control to trigger the process, as doing so will cause a postback, and when the browser returns from the postback, the page that you wanted to capture is gone.
---
b { font-weight: normal; }
|
|
|
|
|
Thanx for the reply.
can u figure out a possible solution for this?
i somehow want that portion of the screen to be saved on the server.
(Is it possible with javascript or vbscript).
regards,
jeeva
|
|
|
|
|
You can't access the graphics of the client using client script. You need something like an ActiveX component or a Java applet.
---
b { font-weight: normal; }
|
|
|
|
|
Can u tell me how to achieve my goal with Activex or the java applet.
Hope u can give me some tips.
Thank You.
Regards,
jeeva
|
|
|
|
|
Hi all
i am trying to insert data into access database but it is giving this error plz can any one tell me why it is giving this error
ERROR :
-----------
Operation must use an updateable query.
MY CODE :
----------
Dim sConnectionString
Dim objCmd As New System.Data.OleDb.OleDbCommand
sConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("users.mdb") & ";")
Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString)
objConn.Open()
objCmd.Connection = objConn
objCmd.CommandText = "INSERT INTO userInfo(username,userpasswd) values('" & TextBox1.Text & "','" & TextBox2.Text & "')"
objCmd.ExecuteNonQuery()
objConn.Close()
THX
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
-- modified at 3:26 Tuesday 11th July, 2006
|
|
|
|
|
That is because you haven't set write permission on the database file for the account running the code.
---
b { font-weight: normal; }
|
|
|
|
|
HI
How can i set the permissions....
What settings i have to change
Can u plz explain me
THX
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
|
|
|
|
|
Right click the mdb file and go to the security tab, make sure the .net worker process has access (write) to it.
|
|
|
|
|
I am adding reference for microsoft outlook. i have selecting microsoft outlook 11.0 object library.
but in my code it gives error in c#.net 2005. but its working in visual studio 2003. Please help me.
Error:
The type or namespace name 'Interop' does not exist in the namespace 'Microsoft.Office' (are you missing an assembly reference?)
using System;
using System.Collections.Generic;
using System.Text;
//using System;
using System.Reflection; // to use Missing.Value
using Outlook = Microsoft.Office.Interop.Outlook;
namespace CheckOutlook
{
class Program
{
static void Main(string[] args)
{
try
{
// Create the Outlook application.
// in-line initialization
Outlook.Application oApp = new Outlook.Application();
// Get the MAPI namespace.
Outlook.NameSpace removed = oApp.GetNamespace("mapi");
// Log on by using the default profile or existing session (no dialog box).
oNS.Logon(Missing.Value, Missing.Value, false, true);
// Alternate logon method that uses a specific profile name.
// TODO: If you use this logon method, specify the correct profile name
// and comment the previous Logon line.
//oNS.Logon("profilename",Missing.Value,false,true);
//Get the Inbox folder.
Outlook.MAPIFolder oInbox = oNS.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox);
//Get the Items collection in the Inbox folder.
Outlook.Items oItems = oInbox.Items;
// Get the first message.
// Because the Items folder may contain different item types,
// use explicit typecasting with the assignment.
Outlook.MailItem oMsg = (Outlook.MailItem)oItems.GetFirst();
//Output some common properties.
Console.WriteLine(oMsg.Subject);
Console.WriteLine(oMsg.SenderName);
Console.WriteLine(oMsg.ReceivedTime);
Console.WriteLine(oMsg.Body);
//Check for attachments.
int AttachCnt = oMsg.Attachments.Count;
Console.WriteLine("Attachments: " + AttachCnt.ToString());
//TO DO: If you use the Microsoft Outlook 10.0 Object Library, uncomment the following lines.
/*if (AttachCnt > 0)
{
for (int i = 1; i <= AttachCnt; i++)
Console.WriteLine(i.ToString() + "-" + oMsg.Attachments.Item(i).DisplayName);
}*/
//TO DO: If you use the Microsoft Outlook 11.0 Object Library, uncomment the following lines.
/*if (AttachCnt > 0)
{
for (int i = 1; i <= AttachCnt; i++)
Console.WriteLine(i.ToString() + "-" + oMsg.Attachments[i].DisplayName);
}*/
//Display the message.
oMsg.Display(true); //modal
//Log off.
oNS.Logoff();
//Explicitly release objects.
oMsg = null;
oItems = null;
oInbox = null;
removed = null;
oApp = null;
}
//Error handler.
catch (Exception e)
{
Console.WriteLine("{0} Exception caught: ", e);
}
// Return value.
//return 0;
}
}
}
Prya
|
|
|
|
|
my application is actually a web application where i manually upload CSV file to the database.but i want to automate the process,so i have thought of a second stage to this application i.e through a windows application i would download the CSV file from the NSEIndia.com site automatically and then upload the same to SQLServer on the server.i am facing a problem with upload i.e exporting the data to the database.it would be a great help to me if any one could provide me a solution either in VB.Net code or C# code.
AMIT(TATA CMC)
|
|
|
|
|
You need to programaticcaly involke DTS package.
for this you need to add 3 COM object references
1. Microsoft DTS Custom Task Object Lib
2. Microsoft DTSDatapump scripting object
3. Microsoft DTS Package object lib
once you do this i suggest u to use import / export wizard to import data and save package in VB file.
once you open this VB file you will be abl to under stand how to use object of above mention references
Nobody is perfect i'm Nobody
|
|
|
|
|
Hi all
i wants to save the images with name in database.i want to bind the images and imagename with control to show in list .
please send the code.
Best Regards,
srinandan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
