|
You can check the query which you are generating, check that query by executing it in backend first.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi,
check this out,
(1)
"UPDATE programs SET date_Completed=#" + txtEventDate + "# , date_Trigger=#" + txtEventTrigger + "# WHERE ID='" + ID + "'"
(2)
"UPDATE programs SET date_Completed=#" + txtEventDate + "# , date_Trigger=#" + txtEventTrigger + "# WHERE ID=" + ID
for (1)
provided [date_completed is date, date_trigger is date and ID is string] in database
for (2)
provided [date_completed is date, date_trigger is date and ID is numeric] in database
display this query string in ur browser and copy paste in database, run it out and check.
|
|
|
|
|
ok thanks alot.
it finally solved that problem.
frossie
|
|
|
|
|
If (ID = 2) Then<br />
<pre>TextBox1.Text = ds.Tables("programs").Rows(ID).Item(2)</pre><br />
Dim temp1 As New DateTime(Year(TextBox1.Text), Month(TextBox1.Text), Day(TextBox1.Text))<br />
MsgBox("temp1=" + temp1)<br />
temp1 = temp1.AddDays(7)<br />
ds.Tables("programs").Rows(ID + 1).Item(3) = temp1<br />
<br />
End If
i keep getting this error "Object reference not set to an instance of an object". Why isit so?
frossie
|
|
|
|
|
Which line you get the error? Check whether that object exists or not.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Can you help me complete this ASP.NET exercise wsing Visual Studio 2003?
Your employer wants you to create a shopping cart application. First, create a database called ShoppingXXX (xxx are your initials). For this exercise you will be using Microsfoft ACCESS.
Include the name of the product, price, description, and the product ID.
Create sample data (be creative, you are suppose to be having fun).
Create a web page that displays the data using a DataGrid control.
Format the dataGrid using the Property Builder.
Add your photo, graphics, color, and content to enhance the appearance of the page.
Do all of your work in one folder (all files, database, and graphics). Everything must be in the one folder.
Can you help me with the code I need for this exercise?
Any help would be greatly appreciated.
Thank you very much!!
Kevin
|
|
|
|
|
TheKiwi wrote: Can you help me with the code I need for this exercise?
The short answer is no.
The longer answer is found here[^].
If you want to ask a specific question, or ask for help solving a specific problem you're having, I'm sure you'll find there are many folks here willing to help.
|
|
|
|
|
If you could buy only one book on building Server Controls in ASP.NET, which book would it be and why?
It seems like I spend the most project time debugging controls and tracing what's going on. I'd like to get a definitive guide to developing server controls so that I can master this and get on with the real work!
TIA for you input.
|
|
|
|
|
If you are doing the ASP.NET 1.1, my recommendation is Nikhil's book[^]. For the version 2.0, I'm not sure if he has a plan for the second edition, but Dino Esposito is the name that I respect most and you might want to check out his book[^] and his crash courses in MSDN[^].
|
|
|
|
|
I'm doing .NET 2.0 these days.
|
|
|
|
|
Any suggestions on which methodlogies we should choose? What is preffered for .NET?
How successfull are Agile and Extreme Programming in real world?
Please suggesst some books and/or online article.
Thanks.
Robert
|
|
|
|
|
I'm using a details view for the first time.
I have a data access layer in my program so I'd like to avoid using the SQLDataSource Object if I can.
I've been trying to do an insert with the details view.
On my details view I have OnItemInserting="DetailsViewSubmit_Insert"
in my code section I have a function:
protected void DetailsViewSubmit_Insert(Object sender, DetailsViewInsertEventArgs e)
From what I'm reading the information the user typed into the text boxes is supposed to be an an Idictionary object at "e.Values"
However when I check e.Values.count its always empty.
Has someone else come across this problem, or perhaps is there a better way to use the details view?
Here's the full details view.
<asp:DetailsView ID="DetailsViewSubmit" runat="server"
Height="50px" Width="125px"
DataKeyNames="FeedbackKey"
DefaultMode="Insert" AutoGenerateRows="False"
OnItemInserting="DetailsViewSubmit_Insert">
<Fields>
<asp:BoundField HeaderText="Subject" DataField="Subject">
<ControlStyle Width="600px" />
</asp:BoundField>
<asp:BoundField HeaderText="Body" DataField="Body">
<ControlStyle Height="250px" Width="600px" />
</asp:BoundField>
<asp:CommandField ShowCancelButton="False" ShowInsertButton="True"
InsertText="Submit" />
</Fields>
</asp:DetailsView>
protected void DetailsViewSubmit_Insert(Object sender, DetailsViewInsertEventArgs e)
{
Response.Write("DetailsViewSubmit called - count = " + e.Values.Count);
}
|
|
|
|
|
The e.Values is only specified when you use the DetailsView control with a datasource control, here you have a data access layer you then may consider using the ObjectDataSource with the control. If you don't specify any datasource control in the DataSourceId property of the DetailsView, you'll need to manually get values from the control and do the insert command. You can read more about how to use the ObjectDataSource and DetailsView control in MSDN.
|
|
|
|
|
thank you for your previous help from before
I've been using a detailsview, an object data sources, with a data access layer, and a stored procedure, and my back to a problem with E.values.
What i'm trying to do is, after I insert a new event, I want to get the the key of the newly inserted event and set that key as my current key for the details view.
I've been playing with the parameter output, I know that i'm setting EventsKey to the newly added record. I tried to catch it in "OnItemInserted" but when I output all the values from e.values, the new key isn't part of that list.
I don't know where the output parameter would be stored, or if there's a better way to get this new key value back to the business layer.
Drathmar
Here's my code:
**Object Data source**
<asp:ObjectDataSource
ID="ObjectDataSourceDetailsView"
runat="server"
TypeName="AspNet.StudentHealthRecords.HealthDbUtility"
SelectMethod="EventsGetByKey"
InsertMethod="EventsAdd"
UpdateMethod="EventsUpdate"
>
<SelectParameters>
<asp:Parameter Name="EventKey" Type="String" DefaultValue="-1" />
</SelectParameters>
<InsertParameters>
<asp:SessionParameter Name="UserKey" SessionField="UserKey" Type="string" />
<asp:Parameter Name="EventDate" Type="String" />
<asp:Parameter Name="EventKey" Type="string" Direction="Output" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="EventKey" Type="String" />
</UpdateParameters>
</asp:ObjectDataSource>
**data access layer function**
public static Boolean EventsAdd(string UserKey, string EventTitle, string EventDescription,
DateTime EventDate, out string Eventkey)
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("EventsAdd", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@UserKey", SqlDbType.Int, 4));
cmd.Parameters["@UserKey"].Value = UserKey;
cmd.Parameters.Add(new SqlParameter("@EventTitle", SqlDbType.VarChar, 20));
cmd.Parameters["@EventTitle"].Value = EventTitle;
cmd.Parameters.Add(new SqlParameter("@EventDescription", SqlDbType.VarChar, 500));
cmd.Parameters["@EventDescription"].Value = EventDescription;
cmd.Parameters.Add(new SqlParameter("@EventDate", SqlDbType.DateTime, 8));
cmd.Parameters["@EventDate"].Value = EventDate.ToShortDateString();
cmd.Parameters.Add(new SqlParameter("@DtTm", SqlDbType.DateTime, 8));
cmd.Parameters["@DtTm"].Value = DateTime.Now.ToShortDateString();
try
{
con.Open();
Eventkey = cmd.ExecuteScalar().ToString();
return true;
}
catch (SqlException err)
{
// Replace the error with something less specific.
// You could also log the error now.
throw new ApplicationException("Data error.", err);
}
finally
{
con.Close();
}
return false;
}
**procedure**
CREATE PROCEDURE [dbo].[EventsAdd]
(
@EventTitle varchar(20),
@EventDescription varchar(500),
@EventDate DateTime,
@UserKey int,
@DtTm DateTime
)
AS
INSERT INTO dbo.Events
(EventTitle, EventDescription, EventDate, EventCategory, UserKey, DtTm)
VALUES (@EventTitle, @EventDescription, @EventDate, 0, @UserKey, @DtTm)
SELECT SCOPE_IDENTITY()
GO
** Page function**
protected void DetailsViewItemInserted(object sender, DetailsViewInsertedEventArgs e)
{
for (int i = 0; i < e.Values.Count; i++)
{
Response.Write("item Interted values are - " + e.Values[i] + "<br>" );
}
}
|
|
|
|
|
I have a brain dead third party component that will only show images in it's predefined images folder or in a specific url. I want to define the images in the skin file as with any normal asp.net control, unfortunately it's converted all my urls to relative from the root of the web and not from the theme folder automatically as it normally would.
It does have an imagesfolder property I can set, but since the theme in use depends on the user's selection I don't want to have to programmatically set that, if there were some sort of predefined url to the active theme set by asp.net I could use that in the skin file for the ImagesFolder property and circumvent the problem.
-- modified at 16:35 Thursday 10th August, 2006
|
|
|
|
|
AFAIK, there's no way that you can get reference to the currently active theme and set in the skin file (while you can do in code). I may not understand all your context, but IMHO there are a couple of things you may check:
+ Do you use the root path reference ~ when you set the ImagesFolder property for the custom control?
+ Because you are creating the skin file for a specific theme, so I think you may probably know the theme name and you can hard code this name in the ImagesFolder property of the control in the skin file.
|
|
|
|
|
I´ve heard that its possible to run a web app without aspx files and just host the dlls on the web server. Anyhow, I haven´t managed to get this to work and haven´t found any info about how to do this.
Does anybody know how it´s done?
|
|
|
|
|
|
Premise: I'm new to Web Services.
I have an application that makes use of some assemblies, containing a class library.
I want to communicate with a server (through web services) which must use the data types contained in the same assemblies used by the application.
So I added a reference to those assemblies into the asp.net project and then added a web reference to the web service in the client application project.
I wrote some methods in the web service, they work (from the browser, at least), but Visual Studio generates a stub for the web service exposing different data types (same class names but different namespaces).
So, how can I share the same data types between the web service and the client, keeping them both in the client and in the server (I don't want to "move" the class library into the server because the web service is a secondary tool and the application must also work without it)?
I tried strong-naming but nothing changed.
Thanks for any help.
|
|
|
|
|
I'd try putting all shared classes in the class library and ensure that you reference the class library from both the server and client projects.
i.e. Client app has a web reference to your web service as well as a reference to the class library.
Then ensure that all references in the web service proxy class in the client project reference objects from the class library.
|
|
|
|
|
Naes wrote: I'd try putting all shared classes in the class library and ensure that you reference the class library from both the server and client projects.
i.e. Client app has a web reference to your web service as well as a reference to the class library.
Then ensure that all references in the web service proxy class in the client project reference objects from the class library.
It is already built that way. 
Thank you, anyway.
|
|
|
|
|
IMO, if you want the client and service to use the same objects, you might want to edit the proxy as basically the proxy will contain the implementations for custom objects that are used in the web service. If they don't get generated, the client has no idea to create the objects to work with the service, the exception is you add reference to the shared assembly. However, the downside of editing the proxy is that when you update the service, and you'll need to refresh the proxy and this issue could lead to overwrite the current proxy code. So I think you may trade off in this case, or may think off another way to call the service for example sending SOAP messages ....
|
|
|
|
|
I have a page that will display one of three sections depending on the type of object being edited. I want to send only one of those sections to the user down the wire depending on which type of object it is as each one contains a *lot* of controls.
There are many controls that allow hiding or showing a section dynamically at the end users's browser but they all will still result in the unneeded content being sent every time to the browser.
I'm looking for something that I can still use the UI editor to create and then optionally send or not in the page load event. I know i could just dynamically add those controls at runtime that apply, but that's a bit more clumsy than what I'm looking for and it's a pretty complex layout with a lot of controls.
I've been through all the stock components and methods but I don't think what I'm looking for is there.
I know that I could do this in a convoluted way through master pages and content areas, but that is way overkill for this and will introduce a lot of complexity un-necessarily.
Any ideas would be appreciated.
|
|
|
|
|
Hmmm... would the MultiView work for what you want?
|
|
|
|
|
No because all the content is sent to the user and any of it can be shown at any time in the browser.
What I want is like a panel maybe but one that you can, at the server during runtime, not only hide, but not send at all to the browser.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
