|
hi all..
i am using script task in SSIS.i am new to it.
I have a oracle connection string in the code say:
now i want to access this conection via variable: OraConn. how to do it?
is it like below?
OraConn.ConnectionString = Dts.Variables["OraConn"].Value.ToString();
but its not working can anybdy suggest?
FBG
modified 19-Jan-12 8:56am.
|
|
|
|
|
bigphish wrote: but its not working
Without some more information it's impossible even to make a guess.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
Hi All,
First off I am new to C# so please forgive me if I ask obvious questions.
I am required to write code that will communicate with a SOAP based web service hosted by a third party. I have imported the provided WSDL using wsdl.exe and implemented the generated code in my program. This successfully generates the required SOAP request with the correctly structured XML contained in the body. I have working XML/SOAP samples that I have successfully used to get the expected response from the service via a small Delphi test application so I know how the structure of the call must look.
The C# generated call (captured using Fiddler) is almost the same as the samples however there are two additional tags in the samples that are not in my generated call. These tags are the first two tags in the SOAP body after which the rest of the XML is correct.
My question is how do I (or can I at all) add these tags at run time to the generated message?
I hope this is enough information but please let me know if I need to provide more.
Kind Regards,
Francois
|
|
|
|
|
Shew, no a single reply... I hope I haven't broken a rule or committed some other faux pas.
|
|
|
|
|
Hi,
Actuially Iam using vs2010. My requirement is simple. Once the user click on listview-header then its
visible has set to false.
Currently Iam using the below codes, and its fine...No problem...
<pre>
listView1.ColumnClick += new ColumnClickEventHandler(this.MyLstVw_Vsble)
private void MyLstVw_Vsble(object Sender, EventArgs e)
{
listView1.Visible = false;
}
But my clarification is, why not assigning the controls visible property, directly like the below.
listView1.ColumnClick += listView1.Visible = true;
Is it possible?...
Thanks
|
|
|
|
|
Paramu1973 wrote: But my clarification is, why not assigning the controls visible property, directly like the below.
listView1.ColumnClick += listView1.Visible = true;
No, that's not possible. ColumnClick points to an event, not to a line of code. You could use an anonymous delegate though.
listView1.ColumnClick += delegate { listView1.Visible = true; };
Enjoy
Bastard Programmer from Hell
|
|
|
|
|
Thanks Eddy
|
|
|
|
|
You're welcome
|
|
|
|
|
ColumnClick is an event, so you have to use += with a delegate reference. Depending on the version of .Net you have, there are several ways to do that:
- All versions: explicit new expression as in your example.
- .Net 2+: implicit cast of a method name (listView1.ColumnClick += MyLstVs_Vsble)
- .Net 2+: anonymous delegate (see the post above this one)
- .Net 3+: lambda function: listView1.ColumnClick += (s, e) => listView1.Visible = false;
The last is the closest way so far of assigning an expression directly to a delegate.
|
|
|
|
|
|
Hi guys
After reading some MSDN I still have some things I don't understand.
Having an application with the folowing structure
class MainApplication (thread handling UI controls)
class CModuleA -> (starts a thread thWorkerA)
class CModuleB -> start a thread thWorkerB
here are my questions:
1. From thWorkerB I raise an event intended to be caught by subscriber CModuleA class.
Inside CModuleA it is the handling event funtion.
The execution of the thWorkerB thread remain blocked inside the eventHandling function from CModuleA until it finishes?
2. How is exactly this send event handled? In what context is it done?
3. The Invoke method should be used to execute delegates on the current UI thread, which chage controls.
This Invoke function could be used in other cases, not involving UI controls? (similar situations)
modified 19-Jan-12 4:05am.
|
|
|
|
|
1. From thWorkerB I raise an event intended to be caught by subscriber CModuleA class.
Inside CModuleA it is the handling event funtion.
The execution of the thWorkerB thread remain blocked inside the eventHandling function from CModuleA until it finishes?
Yes. Unless you delegate execution to another thread, event handlers run in the thread from which you called them. An event handler should never do anything which will take a long time for this reason (except in cases where you are happy for that component to have its queue stalled); you should post messages onto a queue which is handled by another thread, or something similar, and return as quickly as possible.
2. How is exactly this send event handled? In what context is it done?
Methods called through a delegate are in the same execution context as the method from which they were called, similar to a normal method call.
3. You can use Invoke to execute across threads if you have a Control to call it on, or you have a Dispatcher to hand (WPF). If you don't want it to still block, though, you should use BeginInvoke (generally you can do a fire-and-forget and not bother with EndInvoke as you don't need the return value).
In a pure component situation, where you don't have any UI related infrastructure, you should handle the cross thread execution yourself. As I mentioned above, a good way to do this is to have a thread which watches a queue, and have the event handler post a message onto the queue for the handler thread to deal with. You can use WaitHandles (i.e. AutoResetEvent) to notify the thread that it should wake up without doing 'hot waiting' (i.e. checking the queue in a loop).
Alternatively you can spawn new tasks and push them into a ThreadPool or, if using .Net 4, use the Task Parallel classes in the Framework. Both of these mechanisms essentially run a queue and multiple handling threads pulling tasks off them.
|
|
|
|
|
ok, thanks!
Still I am wondering how this messaging(event sending) between classes is implemented.
(like a function call, or like messaging in a separate thread or context)
but this is not so important.
|
|
|
|
|
Hi
I'm having a weird bug in my application. This is my first time in this forum I hope you can help me because this bug is making me crazy.
It's a desktop application where I have a form with some MaskedTextBox in it. The goal of these text boxes is allow the user to introduce values with format "000.000".
When the user modifies the textbox, the value is stored in a internal variable and until then everything works fine. The problem appear when the application reloads the textbox control from the variable. In my computer the value is retrieved correctly, the application shows in the text box the same value the user has introduced before, but in some computers the value is retrieved wrong. For instance, the user inserts 001.000 and when the application reloads the control, the value updates to 100.000.
First time I thought that it would be a Culture issue, but the user uses the same as mine (es-ES) and I have included information about culture in the code (invariant culture). This is the definition of the textbox:
this.tbxFrequency10.Culture = new System.Globalization.CultureInfo("");
this.tbxFrequency10.Location = new System.Drawing.Point(177, 254);
this.tbxFrequency10.Mask = "000.000";
this.tbxFrequency10.Name = "tbxFrequency10";
this.tbxFrequency10.PromptChar = '0';
this.tbxFrequency10.Size = new System.Drawing.Size(135, 20);
this.tbxFrequency10.TabIndex = 116;
this.tbxFrequency10.TextMaskFormat = System.Windows.Forms.MaskFormat.IncludePromptAndLiterals;
this.tbxFrequency10.Validated += new System.EventHandler(this.Control_Validated);
The main problem here is I can't reproduce the bug the user has. Just in case I changed my Windows regional configuration in order to try to reproduce the bug but with no success. Anyone has an idea about what could be the reason of this bug?
Thanks in advance. Sorry for my english.
Regards,
|
|
|
|
|
The behavior is by design[^];
MSDN states: "." -> Decimal placeholder. The actual display character used will be the decimal symbol appropriate to the format provider, as determined by the control's FormatProvider property.
Bastard Programmer from Hell
|
|
|
|
|
Where is the code that stores and restores the value? (Or the data binding definition, if you have bound the text box?)
You should use CultureInfo.InvariantCulture not new CultureInfo(""), but that is unlikely to be the source of the problem.
|
|
|
|
|
The problem appears when the program validates the textbox content. There is where the value is updated:
if (control.DataBindings.Count > 0)
control.DataBindings[0].ReadValue();
The value is restored from a String variable which has the correct value. The main problem here is I can't reproduce the bug in any machine, it only happens with the user machine so I can't debug it properly.
Anyway, I have been reading too much about MaskedTextBox (and its possible bugs) and there is nobody with my problem. It seems the bug should come from another part of the code. I have heritage this code from the previous developer of the application and it's not a very good code (he does really tricky things just to update the textbox) so I'm going to remake this part.
I will let you know if the bug persist or the solution if I find it.
Thanks for your replies.
|
|
|
|
|
I have this method:
public List<ProjectModel> GetProjects(ProjectType ProjectType, bool ActiveOnly = true, int ParentId = 0)
{
using (SparesDataContext context = getDataContext())
{
List<ProjectModel> retVal = (from p in context.tblProjects
where p.ProjectTypeId == (int)ProjectType &&
p.ParentId == (ParentId == 0 ? p.ParentId : ParentId) &&
p.IsActive == (ActiveOnly ? true : p.IsActive)
select new ProjectModel
{
ParentId = p.ParentId,
ProjectType = (ProjectType)p.ProjectTypeId,
Caption = p.Caption,
Warehouse1 = getWarehouseModel(p.WarehouseId1 == null ? 0 : p.WarehouseId1.Value),
Warehouse2 = getWarehouseModel(p.WarehouseId1 == null ? 0 : p.WarehouseId1.Value),
IsActive = p.IsActive.Value,
Revision = p.Revision,
Comments = p.Comments
}).ToList();
return retVal;
}
}
The Warehouse Id's can be null in the table. In this code if the WarehouseId from the table
is null I convert it to 0 before calling getWarehouseModel. If it's zero I then return an empty WarehouseModel.
This doesn't feel right. Anyone know a better approach?
Thanks
Everything makes sense in someone's mind
|
|
|
|
|
Kevin Marois wrote: Anyone know a better approach?
Don't allow NULL s as WarehouseId s. Seriously, don't. What is the reasoning behind allowing them?
|
|
|
|
|
If the database allows for nulls in the column, then he may not have much choice but to handle them.
I wasn't, now I am, then I won't be anymore.
|
|
|
|
|
Yes, but that doesn't answer my question.
|
|
|
|
|
Because not all projects have warehouses
Everything makes sense in someone's mind
|
|
|
|
|
Then the simplest solution is to have a "Not a warehouse" entry in the warehouse table. This technique works well if you present a (drop down) list of warehouses to the user who can then select the warehouse.
However, personally, I'd prefer, rather than having a warehouse Id column in the project table, having a (many-to-many) relationship table. Some projects would have an entry (just one), others would have no entry. This is likely a better design for your project*, but I suspect your project is too far along to do it this way.
* A warehouse has several projects, a project doesn't have a warehouse.
modified 18-Jan-12 19:58pm.
|
|
|
|
|
Why is having a 'no warehouse warehouse' better than allowing nulls in the table? A null is actually what best represents the situation the data's representing, and it makes the special case code a lot more obvious (comparing to null instead of comparing to a particular row key).
And adding a relationship table when it is a (nullable) many-to-one relationship seems like overkill, too.
|
|
|
|
|
BobJanova wrote: better than allowing nulls
It's just a way to avoid the special cases, and allows for addtional functionality, but it's really just a bandaid to cover up a flaw in the schema. I (probably) wouldn't do it that way.
BobJanova wrote: A null is actually what best represents the situation the data's representing,
Yes, but the schema doesn't seem to represent the real world.
BobJanova wrote: many-to-one relationship seems like overkill
Not to me. And from what I can tell, it better represents the real world. And, after reviewing the question again I see he already has two warehouses so he really should have many-to-many.
|
|
|
|