|
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?
|
|
|
|
|
Handle what situation? Your description of what you have is OK, but your description of what you're doing is completely missing.
|
|
|
|
|
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 ?
|
|
|
|
|
|
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
|
|
|
|
|
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.  )
|
|
|
|
|
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)
|
|
|
|
|
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.
|
|
|
|
|
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)
|
|
|
|
|
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.
|
|
|
|
|
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)
|
|
|
|
|
Switch user fails to find a "logon server"
|
|
|
|
|
Wow! It sounds like a 'good' IT work...I'm sorry I wasn't able to help you... 
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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();
}
}
}
manish soni
|
|
|
|
|
It could be anywhere in there. There will be a stack trace that shows the line the error occurs on.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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);
if (ds.Tables[0].DefaultView.Count > 0)
{
DataRowView r = ds.Tables[0].DefaultView[0];
if (r != null)
{
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();
}
}
}
Sankarsan Parida
|
|
|
|
|
I need Javascript for the above question.... Please send it as soon as possible...
Thanks...
|
|
|
|
|
|
1. You haven't actually asked a question.
2. We don't do your work for you.
3. This is the .NET forum, not a JavaScript forum.
4. People on this site are volunteers. They work to their timetable, not yours.
5. We don't do your work for you.
|
|
|
|
|
vasuarya wrote: Please send it as soon as possible...
Please forward $1,000,000 to me and I can assure you that I will make this my top priority.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
