ASP.NET

20-Apr-07 10:37

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

Hasan Ali20-Apr-07 10:46

20-Apr-07 10:46

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

Hasan Ali20-Apr-07 10:54

20-Apr-07 10:54

dim P_CNSTESTM_CSTTYP_CD as string = ""

for i = 1 to 10
P_CNSTESTM_CSTTYP_CD = p_projest(i)
1+=i
next

Hasan Ali20-Apr-07 10:58

20-Apr-07 10:58

DataRow drow ;
drow = dtloc.NewRow();
drow["locname"] = ((TextBox) tx).ID;
drow["locval"] = ((TextBox) tx).Text;
dtloc.Rows.Add(drow);

Jesse Squire20-Apr-07 11:12

Jesse Squire

20-Apr-07 11:12

Maybe I missed it, but was there a question in there? My eyes start to burn when they see Visual Basic code. Big Grin | :-D

--Jesse

"... the internet's just a big porn library with some useful articles stuck in." - Rob Rodi

Colin Angus Mackay20-Apr-07 14:43

Colin Angus Mackay

20-Apr-07 14:43

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.

Upcoming events:
* Glasgow: Introduction to AJAX (2nd May), SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services...

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Colin Angus Mackay20-Apr-07 14:44

Colin Angus Mackay

20-Apr-07 14:44

Try this Microsoft Knowledge Base Article[^]

Upcoming events:Tr
* Glasgow: Introduction to AJAX (2nd May), SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services...

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Christian Graus22-Apr-07 0:08

Christian Graus

22-Apr-07 0:08

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 )

Server generated HTTP-Error in web service

Christian Graus22-Apr-07 0:07

Christian Graus

22-Apr-07 0:07

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.

the-unforgiven20-Apr-07 10:06

the-unforgiven

20-Apr-07 10:06

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

How do i give write permissios to a folder through code

www.Developerof.NET20-Apr-07 8:44

www.Developerof.NET

20-Apr-07 8:44

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???

Re: How do i give write permissios to a folder through code

Davide Icardi20-Apr-07 9:58

Davide Icardi

20-Apr-07 9:58

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

Re: How do i give write permissios to a folder through code

SGnK20-Apr-07 13:47

SGnK

20-Apr-07 13:47

Yup, sorry, I'm not gonna be much help either.

Try looking at chmod[^]

Hopefully I'm not stering you in the wrong direction

Re: How do i give write permissios to a folder through code

xibeifeijian22-Apr-07 16:28

xibeifeijian

22-Apr-07 16:28

Simulate a administrator in your csharp code. D'Oh! | :doh:

▒▒〓▒〓▒▒

▒〓〓〓〓〓▒

▒▒〓▒〓▒▒

▒〓〓〓〓〓▒

▒▒〓▒〓▒▒

Go to the top of the page after GridView rowcommand in UpdatePanel?

vicky45720-Apr-07 6:23

vicky457

20-Apr-07 6:23

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!

DataGrid Getting current Row Values

zamiran20-Apr-07 5:36

20-Apr-07 5:36

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 Smile | :)

Thanks a lot.

Tarakeshwar Reddy20-Apr-07 5:48

Tarakeshwar Reddy

20-Apr-07 5:48

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;

zamiran20-Apr-07 6:03

20-Apr-07 6:03

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 Smile | :)

Arun.Immanuel20-Apr-07 6:09

Arun.Immanuel

20-Apr-07 6:09

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

zamiran22-Apr-07 22:36

22-Apr-07 22:36

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.

Chetan Ranpariya22-Apr-07 23:01

Chetan Ranpariya

22-Apr-07 23:01

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

zamiran22-Apr-07 23:12

22-Apr-07 23:12

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 Frown | :(

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();
}

Chetan Ranpariya22-Apr-07 23:30

Chetan Ranpariya

22-Apr-07 23:30

Hi,

Can you send the code of CreateBoundColumnd() method?

Thanks and Regards,
Chetan Ranpariya