|
You are absolutily correct Mr Arun Kumar.We have to update lock_flg as zero when user enters correct pwd.Actually i included that in my project.But i forgot to tell that. Sorry
|
|
|
|
|
Public Function CeProjTrend_Data(ByVal p_projno As String, ByVal p_projest As String())
Dim P_CNSTESTM_CSTTYP_CD As String
Dim n As Integer
Dim Dt_CePT As New DataTable
Dim Sql_CePT As String
Do
Sql_CePT = "select a.CST_TYP_AMT, a.CST_TYP_DT, a.WPWKMIX, a.MANDISDV, b.LOC_1_TXT || b.LOC_2_TXT as LOCATION, C.CNST_ESTM_RSN_CD from IEIT002_CONTESTM a, IEIT003_PROJECT b, IEIT010_CONTESTM_CHNG C where a.CNSTESTM_CSTTYP_CD = " & P_CNSTESTM_CSTTYP_CD & " and a.WPITEM || a.WPITMSEG || a.WPPHAZGP || a.WPPHAZTP || a.FINPRJSQ = " & p_projno & " "
While (p_projest(0) <= p_projest(10))
n = 0
P_CNSTESTM_CSTTYP_CD = p_projest(n)
End While
n = n + 1
Loop
Return Dt_CePT
End Function
|
|
|
|
|
Public Function CeProjTrend_Retrive(ByVal p_wpitem As String, ByVal p_wpitmseg As String, ByVal p_wpphazgp As String, ByVal p_wpphaztp As String, ByVal p_finprjsq As String)
Dim p_projno As String
Dim Dt_ProjEst As New DataTable
Dim p_projest As String()
p_projest = New String() {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}
p_projest(0) = "10"
p_projest(1) = "20"
p_projest(2) = "30"
p_projest(3) = "40"
p_projest(4) = "50"
p_projest(5) = "60"
p_projest(6) = "80"
p_projest(7) = "65"
p_projest(8) = "75"
p_projest(9) = "70"
p_projest(10) = "85"
p_projno = p_wpitem & p_wpitmseg & p_wpphazgp & p_wpphaztp & p_finprjsq
obj = New Construction_Dal
Dt_ProjEst = obj.CeProjTrend_Data(p_projno, p_projest)
Return Dt_CePT
End Function
|
|
|
|
|
dim P_CNSTESTM_CSTTYP_CD as string = ""
for i = 1 to 10
P_CNSTESTM_CSTTYP_CD = p_projest(i)
1+=i
next
|
|
|
|
|
DataRow drow ;
drow = dtloc.NewRow();
drow["locname"] = ((TextBox) tx).ID;
drow["locval"] = ((TextBox) tx).Text;
dtloc.Rows.Add(drow);
|
|
|
|
|
Maybe I missed it, but was there a question in there? My eyes start to burn when they see Visual Basic code.
--Jesse "... the internet's just a big porn library with some useful articles stuck in." - Rob Rodi
|
|
|
|
|
Jesse Squire wrote: Maybe I missed it, but was there a question in there?
Your eyes are fine (I think). I didn't see a question in there either.
|
|
|
|
|
|
Wow - I only saw his first post, at the bottom of a page. It's worst than I thought. That's an awesome link tho, I've bookmarked that for future reference.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
What did you expect this to do ? You're incrementing n outside your while loop, so it looks likely to me that it will loop forever. Your SQL is ripe for injection attacks. I don't see how this can work at all, or at least, how it can do anything.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hello,
can someone please tell me, if it is possible (and how) to generate a server-generated-error like "HTTP 404 - File not found" or "HTTP 403.4 - Forbidden: SSL is required to view this resource error" from within a asp.net WebMethod call?
All this exception stuff that I tried, produced a "HTTP 500 Internal server error"
best rgds and thanxxx in advance
the-unforgiven
|
|
|
|
|
Help!!!
How do i give write permissios to a folder through code and whenever not needed i can take away the permissions. How 2 achieve this???
|
|
|
|
|
I'm not an expert on this subject but I think that usually it is not possible because changing a folder permissions require special code permissions that the ASP.NET process doesn't have.
Usually if your web application need to write on a folder you must ask the administrator to manually set the write permissions.
If you use a shared hosting probably you have a control panel to set the permissions on the folder.
Consider also that usually for ASP.NET 2.0 the App_Data directory is already configured with the right write permissions (if configured correctly).
Davide
|
|
|
|
|
Yup, sorry, I'm not gonna be much help either.
Try looking at chmod[^]
Hopefully I'm not stering you in the wrong direction
|
|
|
|
|
Simulate a administrator in your csharp code.
|
|
|
|
|
I am using AJAX UpdatePanel for a GridView. The GridView has serveral row commands. Most of the row commands prefer to have the page staying at the same posistion after the command, except one command. That command will display a panel at the top of the page and the user will do something on the panel. It works fine when the list is short because the user can directly see the panel being displayed. However, when the list is very long, it doesn't work well. The reason is when a user click on that row command, the page still stay at the same position because UpdatePanel only does partial page postback. So the panel being display on the top of page won't be seen by the user.
I think, probablly, to use javascript to reset the page position when that row command is clicked, but I don't know how to do it. Could everybody give me some hints, or does anybody have better ideas to do it?
Thanks in advance!
|
|
|
|
|
Hi Everybody,
Thanks for looking at my topic. I'm completely new to C# ASP.NET, so my question might be too easy.
I'm trying to get current values from the row in the DataGrid, that has Field1, Field2 fields.
I'm doing something like this:
string item = (string)((TextBox) e.Item.FindControl("Field1")).Text; on the update button click event.
I do not want to go through the DataTable, just get the current values from the active row in the DataGrid.
Please help me
Thanks a lot.
|
|
|
|
|
zamiran wrote: string item = (string)((TextBox) e.Item.FindControl("Field1")).Text;
You need to pass the name of the Textbox to the Findcontrol function.
string Item = ((TextBox)e.Item.FindControl("txtItem")).Text;
or
string Item = ((TextBox)e.Item.Cells[1].FindControl("txtItem")).Text;
or you can also use
string Item =((TextBox)e.Item.Cells[1].Controls[0]).Text;
|
|
|
|
|
Hi,
thanks for a quick response but I'm doing this
(string)((TextBox) e.Item.FindControl("Field1")) the same as you've suggested but this doesn't help
may be the problem is that the name of the TextBox is wrong, I'm using the caption under the columns. Doe that represent the name of the control.
I also have tried this out, with out of range error every time.
I've tried putting different Cell numbers and Control numbers
string Item =((TextBox)e.Item.Cells[1].Controls[0]).Text;
By the way I can not understand what is Control? Item is initializing the selected row, cell is the textbox, what is Control?
Thanks a lot for you help and patience
|
|
|
|
|
U might have bound the Grid with new values
before the execution of this code.
Can U please send the entire code?
Regards,
Arun Kumar.A
|
|
|
|
|
Hi,
thanks for all your help!
I'm just trying to understand how it all works so, I'm trying to make it simple (IMHO). I want the contents of the cell to be put as a text on Label control on Cancel click event (it doesn't make much sense but, just for the sake of simplicity). Here is the code:
private void missionGrid_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
try
{
string item = (string)((TextBox) e.Item.FindControl("Field1")).Text; // I do have field called Field1
Label1.Text = item;
}
catch (Exception ex)
{
Label1.Text = ex.Message ;
}
Thanks again
}
The exception error message is this one.
Object reference not set to an instance of an object.
|
|
|
|
|
Hi,
Here you tell that you have a field called "Field1". Is this field is from your database?
If yes then obivously you will not find any control with ID "Field1". Item of your datagrid should contain a control with the ID with which you are finding the control.
So first you put a textbox in the cell with an id lest say "Field1". Then only you will able to find the control and convert it to the TextBox.
Here you are getting NullReferenceException because the code can not find the control with the ID "Field1" or in case it is able to find then it is not able to convert it to the TextBox.
I hope this may help you.
Thanks and Regards,
Chetan Ranpariya
|
|
|
|
|
Hi Chetan,
Here is the way I populate the DataGrid. I thought in this way the textboxes will be called after the DataColumns.
I have the Column Names in my DataGrid named "Field1", "Field2" - but is this different from the control name?
Now I'm totally lost
Thanks for your kind help.
private void Bind()
{
fieldList = new ArrayList();
fieldList.Add("Field1");
fieldList.Add("Field2");
missGridTable = new DataTable();
missGridTable = sp.BindWithFieldList(web,"Test List",fieldList,error); //this brings back table with field names specified in the fieldList array.
missionGrid.DataSource = missGridTable;
missionGrid.AutoGenerateColumns=false;
missionGrid.DataBind();
foreach(DataColumn c in missGridTable.Columns)
{
missionGrid.Columns.Add(CreateBoundColumn(c));
}
missionGrid.DataBind();
}
|
|
|
|
|
Hi,
Can you send the code of CreateBoundColumnd() method?
Thanks and Regards,
Chetan Ranpariya
|
|
|
|
|
zamiran wrote: By the way I can not understand what is Control? Item is initializing the selected row, cell is the textbox, what is Control?
Every column in a row is called a cell. When you try to edit the row in a datagrid, you use controls(like textbox) to edit the data in each cell. To get the data from the controls we access it by using
((Textbox)e.Item.Cells[1].Controls[0]).Text;
This code gets the value of the textbox which is the first control in cell 1 of the selected row in the datagrid
|
|
|
|