.NET (Core and Framework)

6-Apr-14 3:58

You can't.

The only thing you can do is post the picture to a image hosting site and put a link to it in your post.

A guide to posting questions on CodeProject

How to debug small programs

Dave Kreskowiak

working with excel

byka3-Apr-14 4:43

byka

3-Apr-14 4:43

I have an excel template where some rows marked as headers.
For example Row1-> header, Row20-Header.
I will be getting data from sql however i am not sure how to deal with headers because my datarow count will not be the same. how would I handle this situation?

Dave Kreskowiak3-Apr-14 6:02

3-Apr-14 6:02

Handle what situation? Your description of what you have is OK, but your description of what you're doing is completely missing.

A guide to posting questions on CodeProject

How to debug small programs

Dave Kreskowiak

AmitGajjar3-Apr-14 12:35

AmitGajjar

3-Apr-14 12:35

I am not sure what you are trying to do. As per my understanding you have multiple tables in single sheet with user defined header rows. And your not sure how you could fit the data inside other data rows. is this your problem ?

byka4-Apr-14 1:37

byka

4-Apr-14 1:37

correct

Changing VPN domain password

AmitGajjar4-Apr-14 3:36

AmitGajjar

4-Apr-14 3:36

Hope you know how can you store your sql data into excel file. Your confusion is with only header rows.

Here is one possible solution,

You can read your template and check with your header. Place your data row until another header row appear in your template excel. If your data exceed and it look to overwrite your next table you can add one new row there. once you found next template header row you can read your next sql table and store row by row.

hope this will work for you.

Thanks
Amit

Matt T Heffron31-Mar-14 8:32

31-Mar-14 8:32

When I'm connected via VPN to a different domain than my login to the Windows PC, I'd like to be able to change my ActiveDirectory password for the VPN domain.
I think there ought to be a way to be able to do this but I can't find it.

I've looked at writing an app but the Environment.UserDomainName and .UserName are for the Windows PC login, not for the VPN domain.

Any suggestions/pointers would be appreciated.

(The IT "help desk" says we have to call and have them set it for us. Frown | :-(

)

Kornfeld Eliyahu Peter2-Apr-14 18:30

2-Apr-14 18:30

You want to change your VPN password while you are connected over the same VPN?

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Matt T Heffron3-Apr-14 6:40

3-Apr-14 6:40

Not the VPN password, but the login password in the domain that I'm VPN'd into.

Company A and B are both "operating companies" of parent company D.
I work for company A but my office is located in the facility of company B.
(My group used to be part of company B but D transferred the group to company A.)
My computer's normal state is to login to the domain of company B in their "internal" network.
Often I need to access the "internal" network of company A (submit vacation time, record training, etc.) so I VPN into the company A domain.
When my password expires in the company A domain, currently I cannot change it myself, I'm required to call IT to have them reset my password.
I'd like to be able to do the equivalent of the Ctrl-Alt-Del Change Password, but for the company A domain when I'm VPN'd to it.

Kornfeld Eliyahu Peter3-Apr-14 8:13

3-Apr-14 8:13

I'm working in such an environment. I have VPN (Cisco) and after that RDP. While connected I press Ctrl+Alt+End and that brings me the option to change password. But I'm local and domain administrator so it may be the reason. I'm using Windows 7...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Matt T Heffron3-Apr-14 8:50

3-Apr-14 8:50

Yup, Cisco here also.
Win 7 logged in to "company B" domain/user.
VPN to "company A" domain.
Ctrl-Alt-Del gives option to change "company B" domain/user's password.
Nothing appears to reference "company A" domain/user.

Sigh | :sigh:

Kornfeld Eliyahu Peter3-Apr-14 8:55

3-Apr-14 8:55

Can you do 'Switch User' to Domain A on the Windows 7 machine?

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Matt T Heffron3-Apr-14 9:13

3-Apr-14 9:13

Switch user fails to find a "logon server" Frown | :(

Kornfeld Eliyahu Peter3-Apr-14 9:18

3-Apr-14 9:18

Wow! It sounds like a 'good' IT work...I'm sorry I wasn't able to help you... Cry | :((

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Dave Kreskowiak3-Apr-14 18:32

3-Apr-14 18:32

Wow. That means your IT department sucks!

You have a problem. Since you can't login to the domain because it "fails to find a logon server", that means you can't see any domain controllers over your VPN connection. That means you have no way at all of changing your domain password over VPN.

There's nothing you can do about it except scream at your IT department.

A guide to posting questions on CodeProject

How to debug small programs

Dave Kreskowiak

jschell4-Apr-14 8:10

jschell

4-Apr-14 8:10

Matt T Heffron wrote:
The IT "help desk" says we have to call and have them set it for us.

There are of course only only several possibilities based on that statement.
- They are lying or ignorant.
- There is no way for you to do it. When I say "no way" I mean just that.

Might note as well that if it is the first case and you figured out how to do it yourself and then did it are you secure enough in your organization that you wouldn't get reprimanded or even fired?

Another approach might be to approach someone who job is specifically directed towards security and you might mention to them that this arrangement means that there is no way to insure that a login assigned to you is being used by you. As such any security audit either driven internally or even by external sources might reveal this to the determent of the company. Again though this depends on your position and the company since, for example, if the IT manager is also the security manager he might be less than thrilled to get this information.

ASP.NET

Friendsforever MoNu28-Mar-14 23:18

Friendsforever MoNu

28-Mar-14 23:18

Object reference not set to an instance of an object EROR OCCUR in this code;;;

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class Default3 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ss"] == null)
{
DataTable ord = new DataTable("Table");
DataColumn c = new DataColumn();
c.ColumnName = "ordbookid";
c.DataType = Type.GetType("System.Int32");
ord.Columns.Add(c);
ord.Columns.Add(new DataColumn("ordbooktit", Type.GetType("System.String")));
ord.Columns.Add(new DataColumn("ordbookaut", Type.GetType("System.String")));
ord.Columns.Add(new DataColumn("ordbookpub", Type.GetType("System.String")));
ord.Columns.Add(new DataColumn("ordbookpri", Type.GetType("System.Int32")));
ord.Columns.Add(new DataColumn("ordbookqty", Type.GetType("System.Int32")));
ord.Columns.Add(new DataColumn("ordbookamt", Type.GetType("System.Int32")));
ord.Columns["ordbookamt"].Expression = "ordbookpri * ordbookqty";
Session["ss"] = ord;

}
if (Page.IsPostBack == false)
{
SqlDataAdapter adp = new SqlDataAdapter("select * from tb_book where bookid=101", ConfigurationManager.ConnectionStrings["cnn"].ConnectionString);
DataSet ds = new DataSet();
adp.Fill(ds);
DataRowView r = ds.Tables[0].DefaultView[0];
DataTable tb = (DataTable)(Session["ss"]);
DataRow r1 = tb.NewRow();
r1[0] = Convert.ToInt32(r["bookid"]);
r1[1] = r["booktit"].ToString();
r1[2] = r["bookaut"].ToString();
r1[3] = r["bookpub"].ToString();
r1[4] = Convert.ToInt32(r["bookpri"]);
r1[5] = 1;
tb.Rows.Add(r1);
GridView1.DataSource = tb;
GridView1.DataBind();
Label1.Text = tb.Compute("Sum(ordbookamt)", "").ToString();
}
}
}
Confused | :confused:

manish soni

Pete O'Hanlon28-Mar-14 23:27

Pete O'Hanlon

28-Mar-14 23:27

It could be anywhere in there. There will be a stack trace that shows the line the error occurs on.

Dave Kreskowiak29-Mar-14 4:06

29-Mar-14 4:06

Would you mind specifying on what line the error is thrown?? If not, nobody is going to help you.

The problem is simple really. You're assuming an object came back from either a method call or from some collection. You failed to check to see if the returned object is null before attempting to use it. Basically, you assumed the object would be there, and it's not.

A guide to posting questions on CodeProject

How to debug small programs

Dave Kreskowiak

Schatak4-Apr-14 19:02

Schatak

4-Apr-14 19:02

hit a break point in starting of the code, and step over your code one by one, and see which line is throwing exception. and let me know, so that if anything needs to be correct in it.

Dave Kreskowiak5-Apr-14 2:11

5-Apr-14 2:11

Why are you replying to me? The OP now doesn't get an email saying you replied to him. Now it goes to me only

A guide to posting questions on CodeProject

How to debug small programs

Dave Kreskowiak