ASP.NET

Re: how to increment column value by 1

22-Feb-13 21:39

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

Member 870181322-Feb-13 22:33

22-Feb-13 22:33

usertypeid =usertypeid + 1 i am getting the required o/p

Web Task Scheduler

Mohammad Hussein Fakhravari22-Feb-13 11:17

22-Feb-13 11:17

What is the timing of the implementation of the web؟

هـر جا چراغی روشنه از ترس تنها بودنه ای ترس تنهایی من ، اینجا چراغی روشنه

Richard MacCutchan22-Feb-13 23:23

22-Feb-13 23:23

I am sorry but this question makes no sense. Can you try explaining your problem in more detail?

من متاسفم، اما این سوال باعث می شود حس. آیا شما سعی می کنید تا مشکل شما را در جزئیات بیشتر است.

Mohammad Hussein Fakhravari23-Feb-13 0:21

23-Feb-13 0:21

What tools should be used for scheduling the Web?

هـر جا چراغی روشنه از ترس تنها بودنه ای ترس تنهایی من ، اینجا چراغی روشنه

Richard MacCutchan23-Feb-13 0:35

23-Feb-13 0:35

What do you mean scheduling the web? The web is the internet, it is always there.

Mohammad Hussein Fakhravari24-Feb-13 1:01

24-Feb-13 1:01

Method of Application
At different time intervals
Non-stop

هـر جا چراغی روشنه از ترس تنها بودنه ای ترس تنهایی من ، اینجا چراغی روشنه

Richard MacCutchan24-Feb-13 1:10

24-Feb-13 1:10

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

Mohammad Hussein Fakhravari24-Feb-13 20:17

24-Feb-13 20:17

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>
هـر جا چراغی روشنه از ترس تنها بودنه ای ترس تنهایی من ، اینجا چراغی روشنه

Richard MacCutchan25-Feb-13 0:10

25-Feb-13 0:10

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

gridview

Member 870181322-Feb-13 7:34

delete a table data&structure

22-Feb-13 7:34

i wrote below code for gridview columns

XML

<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") %>' />&nbsp;&nbsp;&nbsp;&nbsp;
              <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.

Member 870181322-Feb-13 3:25

22-Feb-13 3:25

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

Richard MacCutchan22-Feb-13 4:01

22-Feb-13 4:01

Why are you using Convert.ToString() on the Text properties of TextBoxes?

Member 870181322-Feb-13 4:30

22-Feb-13 4:30

because i want to pass textboxe's value as string

Richard MacCutchan22-Feb-13 4:45

22-Feb-13 4:45

It's already a string; please make use of the documentation[^].

Member 870181322-Feb-13 5:53

22-Feb-13 5:53

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

Richard MacCutchan22-Feb-13 6:07

22-Feb-13 6:07

You first need to check that the string is a valid integer, so you should use TryParse[^].

DROP TABLE

David Mujica22-Feb-13 4:20

David Mujica

22-Feb-13 4:20

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.

Re: DROP TABLE

Member 870181322-Feb-13 4:31