|
hi in my table request i have columns as follows
requestid,applicationid,statusid,usertypeid & the data is
1,xxxxx, 1,6
2,xxxxx,2,7
3,xxxxx,3,8
i vil pass requestid to a storedprocedure , and i want to increment statusid,usertype by 1.
create procedure updateusertypeid_statusid
@requestid int
as
begin
update request set usertypeid += 1, statusid += 1 where requestid = @requestid.....this is not working
pls help me to implement this requirement
|
|
|
|
|
usertypeid =usertypeid + 1 i am getting the required o/p
|
|
|
|
|
What is the timing of the implementation of the web؟
هـر جا چراغی روشنه از ترس تنها بودنه ای ترس تنهایی من ، اینجا چراغی روشنه
|
|
|
|
|
I am sorry but this question makes no sense. Can you try explaining your problem in more detail?
من متاسفم، اما این سوال باعث می شود حس. آیا شما سعی می کنید تا مشکل شما را در جزئیات بیشتر است.
|
|
|
|
|
What tools should be used for scheduling the Web?
هـر جا چراغی روشنه از ترس تنها بودنه ای ترس تنهایی من ، اینجا چراغی روشنه
|
|
|
|
|
What do you mean scheduling the web? The web is the internet, it is always there.
|
|
|
|
|
Method of Application
At different time intervals
Non-stop
هـر جا چراغی روشنه از ترس تنها بودنه ای ترس تنهایی من ، اینجا چراغی روشنه
|
|
|
|
|
I still have no idea what you are trying to do or what your problem is. Please try a full description of what you want to do including any problems you are having. Not just three or four words.
Use the best guess
|
|
|
|
|
Thanks Richard MacCutchan
Write a program that
See news sites I read RSS.
insert data to table
-------
Writing software not hard.
My main question is the timing of the implementation of this method in
Task Scheduler
How to create ??
That automatically Ranged time Will work.
-----------------------
Example asp.net
Global.asax
<pre lang="c#">protected void Application_Start(object sender, EventArgs e)
{
this._scheduler.StartTask();
}</pre>
هـر جا چراغی روشنه از ترس تنها بودنه ای ترس تنهایی من ، اینجا چراغی روشنه
|
|
|
|
|
Sorry I don't know the answer, and I could not find any useful references to _scheduler.StartTask() in the MSDN documentation.
Use the best guess
|
|
|
|
|
i wrote below code for gridview columns
<Columns>
<asp:TemplateField HeaderText="S.No">
<ItemStyle HorizontalAlign="Left" VerticalAlign="Middle" />
<ItemTemplate>
<asp:Label ID="Lblslno" Visible="false" runat="server" Text='<%#Eval("RequestId")%>' />
<%#Container.DataItemIndex+1 %>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="RequestId" HeaderText="RequestId"
ItemStyle-VerticalAlign="Top" ItemStyle-HorizontalAlign="Left"
SortExpression="RequestId" >
<ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
</asp:BoundField>
<asp:BoundField DataField="ApplicationId" HeaderText="ApplicationId"
ItemStyle-VerticalAlign="Top" ItemStyle-HorizontalAlign="Left"
SortExpression="ApplicationId" >
<ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
</asp:BoundField>
<asp:BoundField DataField="Document1location" HeaderText="Document1 Location"
ItemStyle-VerticalAlign="Top" ItemStyle-HorizontalAlign="Left"
SortExpression="Document1location" >
<ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
</asp:BoundField>
<asp:BoundField DataField="Document2location" HeaderText="Document2 Location"
ItemStyle-VerticalAlign="Top" ItemStyle-HorizontalAlign="Left"
SortExpression="Document2location" >
<ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
</asp:BoundField>
<asp:BoundField DataField="Document3location" HeaderText="Document3 Location"
ItemStyle-VerticalAlign="Top" ItemStyle-HorizontalAlign="Left"
SortExpression="Document3location" >
<ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
</asp:BoundField>
<asp:BoundField DataField="descr" HeaderText="Description" ItemStyle-VerticalAlign="Top" ItemStyle-HorizontalAlign="Left" SortExpression="descr" />
<asp:TemplateField ItemStyle-HorizontalAlign="left" ItemStyle-VerticalAlign="Top">
<HeaderTemplate>Action</HeaderTemplate>
<HeaderStyle />
<ItemTemplate>
<asp:LinkButton ID="lnkverify" runat="server" Text="Verify" CommandName="Application_verify" CommandArgument='<%#Eval("RequestId") %>' />
<asp:LinkButton ID="lnkreject" runat="server" Text="Reject" CommandName="Appication_reject" CommandArgument='<%#Eval("RequestId") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Application_verify")
{
int projectid = Convert.ToInt32(e.CommandArgument);
Response.Redirect("~/details.aspx?RequestId=" + RequestId);
}
}
catch (ApplicationException ex)
{
lblsuccess.Visible = true;
lblsuccess.Text = ex.Message;
}
catch (Exception ex)
{
StackTrace st = new StackTrace(new StackFrame(true));
StackFrame sf = st.GetFrame(0);
int line = sf.GetFileLineNumber() - 1;
if (ex.Message.StartsWith("Thread") == false) { Response.Redirect("~/HandleError.aspx?ID=" + ex.Message, false); }
}
}
can anyone tell me why i am getting "RequestId" doesn't exist in the current context on response.redirect(~/details.aspx?RequestId=" + RequestId);pls help me
i got solution
modified 22-Feb-13 13:43pm.
|
|
|
|
|
hi ,this is my code
DataTable dt = new DataTable();
dt =
conn.select_usertypeid(Convert.ToString(txtemailid.Text),Convert.ToString(txtPassword.Text));
here i am getting data for dt
for ex
column1 column2 column3
data1 data2 data3
now i want to delete data as well as columns....when i use dt.clear() only data is getting deleted...ie the o/p is as follows
column1 column2 column3
what is d syntax to delete data as well as column names.....pls help me
|
|
|
|
|
Why are you using Convert.ToString() on the Text properties of TextBox es?
|
|
|
|
|
because i want to pass textboxe's value as string
|
|
|
|
|
|
ok.now i removed convert.tostring
if i want to pass textbox's value as int then can i use convert.toint(textbox.text)....pls don't mind as i am a fresher
|
|
|
|
|
You first need to check that the string is a valid integer, so you should use TryParse [^].
|
|
|
|
|
Are you looking to delete both the data and the structure on the SQL server?
If so, I believe you want the "DROP TABLE" SQL command.
|
|
|
|
|
drop table is used in mssql....but i want to do in codebehind file
|
|
|
|
|
I'm learning MVC.
So far I have customized the default sample app.
One thing that leave me baffled is...
In the samples app there 2 web config!!
~/web.config
~/Views/web.config
WTF?
Why 2? Which one does what? What's the point?
|
|
|
|
|
Super Lloyd wrote: In the samples app there 2 web config!!
~/web.config
~/Views/web.config
First thing, you can have multiple config files at different levels. One in root folder and one in other branch folder is perfectly Ok. At times, it is needed for folder configuration.
Out here, Views config is to configure views. It is there to block direct access to the view aspx pages that are supposed to be served only through controllers.
|
|
|
|
|
Thanks for the clarifications!
|
|
|
|
|
|
Hi,
Currently working with virtual path provider class in loading a whole website from database, and off course you cannot replace the web.config as a rule. my problem is how could i load or move my application settings to the web.config?
|
|
|
|
|
So I have a program that was written in visual studio and goes through vb c# then to fortran to calculate values. I am trying to get this to run online and running into problems.
I first tried asp.net in vb where I created a new project and referenced the DLL's that were created by the original code, which only worked on the computer the original code was written on and would fail on my computer during the fortran transistion.
Stepping through the code did not solve anything either as when it cycled through the fortran code it would get to a certain part and fail. It gave me a chance to look at the disassembly because there was no actual error message and it had a file path in the problem area of the disassembly.
I have attached images of the problems I was getting during trying to solve this.
This error message appeared after running the asp.net program the first time before the browser popped up
http://i.imgur.com/kfUVKw7.jpg[^]
This error message appears after I have entered all the values in the input form and they get submitted to the code.
http://i.imgur.com/yaau5At.jpg[^]
I am wondering if it is an pathing error based from the second picture as the actual asp.net program was in my C:\users folder but the source file is saying C:\Data(which was the file structure for the computer the original code was written on) when it shouldn't need to go to C:\Data if all of the code is complied into dlls that are added as references.
I am now trying to implement it into python but am not getting as far, so if someone could help me out with the asp.net problem or have another way that this can be put online that would be greatly appreciated and I can also supply more information if it is needed.
|
|
|
|