.NET (Core and Framework)

Re: Need A Help Of Nested Grid View

3-Jun-11 7:51

Please edit your answer. You've borked the forums.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Prasanta_Prince9-Jun-11 0:51

Prasanta_Prince

9-Jun-11 0:51

Gridview inside Gridview in asp.net C#[^]

Hope this can help you.

Re: Need A Help Of Nested Grid View

robertalis20-Jul-11 21:47

robertalis

20-Jul-11 21:47

Hello

I am not much experienced but I can give you an overview

Protected Sub grdMaster_RowDataBound(ByVal sender As Object, _
          ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) _
          Handles grdMaster.RowDataBound
    Dim objListItem As DataControlRowState
    objListItem = e.Row.RowState
    Dim intMAsterID1 As Integer
    If e.Row.RowType = DataControlRowType.DataRow Then
        Dim grd As GridView
        If objListItem = 5 Then
            grd = CType(e.Row.FindControl("grdChildGridEdit"), GridView)
            MasterTableID = Convert.ToInt32(CType(e.Row.DataItem, _
                            DataRowView).Row.ItemArray(0).ToString())
            intMAsterID1 = MasterTableID
        ElseIf objListItem = DataControlRowState.Normal Or _
               objListItem = DataControlRowState.Alternate Then
            grd = CType(e.Row.FindControl("grdChildGridNormal"), GridView)
            intMAsterID1 = Convert.ToInt32(CType(e.Row.DataItem, _
                           DataRowView).Row.ItemArray(0).ToString())
            Dim lnkButtton As LinkButton
            lnkButtton = CType(e.Row.FindControl("Edit"), LinkButton)
            If lnkButtton IsNot Nothing Then
                lnkButtton.CommandName = "Edit Master"
                lnkButtton.CommandArgument = intMAsterID1.ToString
            End If
        ElseIf objListItem = DataControlRowState.Edit Then
            grd = CType(e.Row.FindControl("grdChildGridEdit"), GridView)
            MasterTableID = Convert.ToInt32(CType(e.Row.DataItem, _
                            DataRowView).Row.ItemArray(0).ToString())
            intMAsterID1 = MasterTableID
        End If
        If grd IsNot Nothing Then
            grd.DataSourceID = ""
            grd.DataSource = ChildDataSource
            ChildDataSource.SelectParameters(_
               "MasterTableID").DefaultValue = intMAsterID1
            ChildDataSource.Select()
            grd.DataBind()
        End If
    End If
End Sub

visit here to solve your .net grid related problem http://www.dapfor.com/Help/NetGrid/Index.aspx[^]

Message Removed

3-Jun-11 2:06

meetnneel

3-Jun-11 2:06

Message Removed

Re: Bind Sub Grid

Eddy Vluggen3-Jun-11 2:21

Eddy Vluggen

3-Jun-11 2:21

There's a walkthrough[^] on MSDN Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

Not able to save the file of HttpPostedfile from test method

vnr3-Jun-11 1:34

vnr

3-Jun-11 1:34

Hi,

I am working on an MVC application which is written in c#.
I am not able to save the httpposted file to my local folder while running the test case.But the same I am able to run from my controller and its working fine.Pelase find the code below.

string savePath ="c:/test.xlsx";
HttpPostedFileBase uploadedFile = files[0] as HttpPostedFileBase;
uploadedFile.SaveAs(savePath); //not saving the file to the path
can anyone pls help me on this.
Thanks in advance.

Re: Not able to save the file of HttpPostedfile from test method

MicroVirus3-Jun-11 1:48

MicroVirus

3-Jun-11 1:48

I don't know what operating system you are running, but after Windows XP the root directory has become protected. Software normally can't write to it without acquiring permissions first. Try creating a directory C:\Test and then try saving to C:\Test\Text.xlsx.
Also, you can check the return value or catch exceptions SaveAs throws so you can find out more about the specific error. My guess now is that it would be 'access denied'.

.NET development using Apple Computer

RobCroll28-May-11 14:04

RobCroll

28-May-11 14:04

Was wondering if anyone has bumped into any show-stoppers developing .NET apps using an Apple Mac?

I need to support and develop iPhone, Andriod and Windows Phone apps and I'm thinking this might best be achieved on an Apple with a Windows7 bootcamp. Sounds good, looks good but I couldn't find much on the net re: developer experiences.

Anyone been there, done that?

"You get that on the big jobs."

Re: .NET development using Apple Computer

Dave Kreskowiak28-May-11 18:21

Dave Kreskowiak

28-May-11 18:21

So long as your running Windows in a virtual machine, no problem.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: .NET development using Apple Computer

Not Active29-May-11 2:57

Not Active

29-May-11 2:57

There are tools that allow iPhone and Android development on a PC. Unless you are doing the majority of your development for Apple I wouldn't bother with the hassles of trying to develop with a Mac.

I know the language. I've read a book. - _Madmatt

.NET app can't connect to remote NamedPipe when executed by SQL

TrustTheMath27-May-11 8:22

TrustTheMath

27-May-11 8:22

This appears to be a communications issue between .NET and SQL, so I've chosen to put it in the .NET category first.

Problem: A VB.NET app executed from a SQL stored procedure is unable to open a NamedPipe connection on a workstation. When the same app runs under CMD.EXE, the connection is successful. Unfortunately, the app must be initiated from SQL.

Environment: Server is Win Svr 2003 Enterprise, with SQL Server 2005 and .NET 2.0.50727.3620.
Workstation is Win 7 Pro

On the workstation, a job creates a NamedPipeServer (listener), then separately reads from a multicast broadcast. On the server, a stored procedure periodically runs, kicking off a VB.NET app which connects to the NamedPipe. This connection triggers the workstation job to update the SQL database.

This works fine when the workstation job (a VB.NET app) runs in a user context. However, it needs to run as a service on the workstation so that it can be running continuously, not be dependent on a particular user, and automatically restart if the workstation were to reboot.

When I coded it as a service, the workstation code does not see the NamedPipe connection request (triggered by a VB.NET app executed from a SQL stored procedure). It WILL work, however, if I run the "trigger" app on the same server under CMD.EXE.

Things I've tried:
-- Validated all user ids throughout the process, making sure the stored procedure is running under the same id as the workstation job.
-- Affirmed that SQL can actually run the trigger job.
-- Affirmed that the server can see the NamedPipe on the workstation. The existing (non-service) method works fine, the server connects to the NamedPipe, the NamedPipe listener collects the multicast data and sends it to the SQL database.

Something is different about kicking off the executable from SQL vs. CMD; my first thoughts were security, but I've made sure the stored procedure is running under the same id as the workstation job.

Has anyone run into something like this before? I'm guessing it's a trivial setting somewhere, but for the life of me I can't find it. Whatever help you can give me is greatly appreciated.

Re: .NET app can't connect to remote NamedPipe when executed by SQL

jschell27-May-11 8:43

jschell

27-May-11 8:43

Presumably you collected the exact error - what was it?

There is nothing special about CMD versus any other application excluding the fact that CMD itself is an application.

You can of course use CMD itself to run your net app from SQL Server.

TrustTheMath wrote:
but I've made sure the stored procedure is running under the same id as the workstation job.

How exactly?

I haven't tried it, and it may require some fooling about but it should be possible to get SQL Server to pop a CMD shell (console window). There might be a flag that you need to set to get this to work. If you do that then you can type anything you want in there. Including running the net app yourself.

Re: .NET app can't connect to remote NamedPipe when executed by SQL

TrustTheMath27-May-11 9:56

TrustTheMath

27-May-11 9:56

Thanks for replying. There is no error -- none on either side. I've populated the code for the service with log msgs, and it shows that the service is sitting there waiting for a connection, but none comes. If the same .NET job runs from a CMD window, it does make the connection. Part 2 of your reply -- SQL (using EXECUTE AS) can run under a specified domain account; that is the same account used by the workstation when starting the service. In addition, the xp_cmdshell_proxy_account (which allows one to execute CMD) is set to the same domain account.

I'll try your suggestion about having SQL kick off the .NET job using CMD and having CMD initiate the .NET app -- something else at least to try. I've been kicking off the .NET app directly (i.e., xp_cmdshell "myapp.exe /parm=...").

Re: .NET app can't connect to remote NamedPipe when executed by SQL

jschell27-May-11 14:04

jschell

27-May-11 14:04

TrustTheMath wrote:
I've populated the code for the service with log msgs, <layer>and it shows that the service is sitting there waiting for a connection, but none comes.

For how long?

If a firewall blocks a connection then the connection will time out. That can take several minutes (or longer if someone has been messing with OS configurations.)

change datagridrow color after add it

Defender-NF25-May-11 5:46

25-May-11 5:46

hello

i would like to change the background of the added row in a datagrid.

is there any way to get the added row and change its background?

Thanks

Not Active25-May-11 6:24

Not Active

25-May-11 6:24

First please tell us the environment. The answer will be different between Windows and Web

I know the language. I've read a book. - _Madmatt

Pete O'Hanlon25-May-11 7:02

25-May-11 7:02

Defender-NF wrote:
is there any way to get the added row and change its background?

Yes.

Without some context of what you environment you are trying to run this from, we can't really offer anymore help.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Defender-NF25-May-11 8:26

25-May-11 8:26

Ah sorry.

I m working on visual studio 2010 ultimate, wpf/c#
my datagrid are bound to some generic lists/datasets via simple itemsource-bindings.

Thanks

Pete O'Hanlon25-May-11 8:44

25-May-11 8:44

There are a few ways you could achieve this. Without knowing how you are going to determine what triggers a new colour, I can't be any more specific other than to say that you could look at using a different item template using an ItemTemplateSelector, or you could use a DataTrigger to set the background colour. Either mechanism would suffice.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Defender-NF25-May-11 8:48

25-May-11 8:48

Okay, so wich property can i use for the Trigger or the Datatrigger?

I mean is there something like "IsAdd" as a property? The only thing i found is "IsEditing" but i wanna the row change its background only if its a "new" row.

Pete O'Hanlon25-May-11 9:25

25-May-11 9:25

Defender-NF wrote:
I mean is there something like "IsAdd" as a property?

No. If you think about it, the data grid will treat all rows initially as a new row because it has no interaction with the database. You will have to provide some context for it to be able to figure out what a new row is; for instance, you might have an IsSaved property on your data. The key is to look at the data, rather than at the datagrid for the mechanism to add this.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Defender-NF25-May-11 11:17

25-May-11 11:17

Thanks Pete for the Assistance

I already have some solutions for this based on my database.. but i dont wanna programm on all my classes/datasets/lists new property just to do this?
thats why i m looking on a interface-way to resolve that, or maybe an independency function or something, i tryed for example this:

void la2_CollectionChanged(object sender, NotifyCollectionChangedEventArgs e)
   {
       if (e.Action == NotifyCollectionChangedAction.Add)
       {

           emp.NewRowAfterFiltering = true;

       }
   }

NewRowAfterFiltering is a property wich i bound to the the datatriger of the gridrow to change background, but it didnt work.

Defender-NF25-May-11 22:47