Comments by milenalukic (Top 97 by date)

Try running the insert statement from SQL. If you still get an error please send create table script and error received to be able to examine further.

What have you tried so far?

Well in that case you have 2 choices:

If you want null values you do not require a default in which case remove your default of 0

If you prefer to have 0 instead of null, first update your data and set all faxno to 0 where they are null. Then remove the null check box and leave the default of 0.

The whole idea of having a default value is not to have nulls.

Does the code behind the step/job run from SQL management studio?

You need to use this code from where you have the code you submitted.

Behind tool strip sounds good yes.

Are these custom fields columns for which you do not know the names?
If so how do you query them at present?

And your third parameter?

you just need to query your database and attach the datsource

A table for each node.
boking table with bookingRef and date.
contact table with bookingref,addreass1.
passenger table with bookingref,passenger item,title,firstname.
bookingelement table woth bookingref,bookingitem,elementref,elementtype.

And so on.

My problem is how to get the bookingref to read with all the other info as this will be the foreign key in most cases.

If you can show me an example then I will work out the rest.

Thanks in advance.

Create Procedure InsertUser
@Name varchar(50),
@address varchar (50)
as begin

insert into MyUserTable(name, address)
values(@name,@address)
Return @@identity

End


the syntax may not be 100% as I did not test it.

What code have you done so far?

Great thanks. That is even easier than I was expecting.

I believe SQL only releases unused memory if another application requires it.

If your beat detector is moving left I assume you want to trigger you code when the left side of the beatdetector hits the label. In this case you will meed to compare the beatdetector postion+its width for the trigger.

Yes I will as soon as Wes adds his solution as he was the one who gave me what I needed.

You will definately need to have a table with your restrictions. If you show your tables and what you have tried it would be easier for someone to help you. Also will your restrictions be permanent or expiring on a certain date? Need more info.

Perfect. Just what I needed. thanks

So how would I need to do this. Can you send me a sample code please?

I assumed this would be eaasy enough but found nothing on the net.

Yes I see your point but he asked to only use SELECT and DATEDIFF. I'm assuming this is a school project.

Thanks for that Wes, but would be an easy solution which I could have easily found sample code.

What is seems I am not getting through to you both is that I have no way of knowing what file types my users would have received from colleagues. It may be an Excel file, a word document, a presentation an image or whatever else may be required.

What I was hoping to achieve is to have an option in my application to open received files folder, from where the user can open any received file, provided he has the software to do so. I would expect an error if the required program was not installed, similar to what you get from windows explorer, but otherwise if I have a word document and word is installed I would want this to open. Same goes for any file type. If this is not possible just let me know.

thanks again

It will only open files where the user has the relevant program to open it with just as windows explorer does.

If I try to open an xlsx file and do not have excel 2007 it will obviously not open, but if it is a txt file it should open with notepad or whatever you have set your pc to have a default for that type.

That is all I want and would appreciate some sample code rather than sarcastic comments please.

I'm not sure I understand you. Do you want your progress bar to be completey filled before showing the list?

If so you need:

progressbar1.minimum=0;
progressbar1.maximum=100;
timer1.enabled=true;

List.Sort();
timer1.enabled=false;
Progressbar1.value=100;
listbox1.datasource=list

timer1_tick()
{
progressbar1.performstep();
}


This will start your progressbar from 0, then when the sort is complete will show a full progressbar and then show the listbox.

Yes the dialoge does return the filename. All I want to know is how to open the file from there. And no I am not lost or confused in what I need to do but I need some help in trying to do it as explained above. I have no way of knowing what the file type could be as it could be anything a user has received.

The reason I think the file is not open is because it does not show on screen. I think that is quite obvious and what any user would expect when they click on open.

My clients would receive files from colleagues that will be saved in a specific folder. All I want to do is to allow them to open this folder from within the windows application and to open any file they have received. The received files could be anything.

So I want the facility like in windows explorer to select a file and open it in read write mode.

I cannot understand you mathematical formula and how you are geting your results but if you need to get previous row in SQL you need to have an identity column of type int. This will give you a row number. Once you add this to your data and you select a row you need to declare a variable @previousrow of type int and assign it to your ID value -1. Then select the row with ID=@previousrow

It seems like that when you create the DB from visual studio you are using an account with more privilleges than you would like your users to have. you will need to go to you SQL server directly and create a restricted access user, giving only the rights that your users require. Also using stored procedures is a more secure way of programming SQL.

Thanks for the links.

What I want to know is how to do this. I created the tables for Booking, Booking Element and Receipt. How do I get the data into all the tables?

Worked here too thanks. The problem I had is because I had the code over 2 lines. As soon as I put then on the same line it worked.

Done that but it's exactly the same. Any other ideas?

Yes i know that. But their answer is to comply with thoses documents. What the question was is how to comply.

The listview works. The only problem is that when I select an item it highlights the icon and the text together and the highlight shows different shades of blue for some reason. I need to get it all the same colour or just highlight the text.

I have seen loads of articles and if I understand correctly, I would need to send a message from the client to the server so that the server can read the address and return a message received message. The problem is that I cannot find any information on how to do it. That is why I hope to get some sample code that I can test and then implement in my project.

I suggest you post the sample you found maybe someone could explain it to you and alter for your needs.

have a look in the DGV Tasks - the little black arrow on the topright of grid. Make sure the datasource is set and that the columns are included.

Use the report wizard to create the report. You will be guided throught o select a datsource and then you need to select the report type - Matrix. When you click next to select the fields you have option for page,column,rows,details.
Put the student in page and this will give you one page per student.

I am building a system where the user queries on multiple fields, which would be straight forward if there was one criteria per field. The problem is that for each field the user can select all, one or many options so the query needs to change accordingly. What I've done so far is to have the basic script for the dynamic SQL in the sp and add the where clauses according to the selections.(ie nothing if they select all, where field=selection for one item selected or where field in (multiple selections)). Then I append all these to the initial script for the dynamic sql and run it.

This gives me the bookings we are interested in into a temptable and then I run the required query on these bookings. I have a number of different procs working in the same way some with a cursor over each booking, so it is quite complex.

This second part of the query saves to another temp table from which then I select the required data to present to the user (eg totals per supplier etc).

For most cases I get results in a few minutes which is great until I have a user who requires a large data set and gets all the others queuing to use the temp tables. I want to avaiod this queue and maximise cpu usage. That is why I was trying to create temp tables for each user. The problem I cannot work round is that SQL doesn't carry forward parameters into dynamic SQL.

Any ideas please?

I am passing in another variable which I populate from Visual studio by using Enviornment.UserName

I tried both permanent and temp tables. The issue here is not the performance of a single query. It is the fact that a user with a 2 minute query could have to wait 10 minutes or more because another user is running a larger query and blocking him. The time required for one query is acceptable. It is the queuing that is not, and what i am trying to solve.

I believe it would be a separate thread as each client who wants to receive requests the stream from the server.

What I would like to do is to use the client as its own video server, using the main server only for connecting/ getting IP address.

Shouldn't your query condition require a column name?

where COLUMN NAME contains

I considered the click once and found the following problem:
if users did not accept update by mistake I would need to recompile as it does not offer the update again.

how would you use the xml settings? Could you give an example please?

What is your problem? explain better so that users can help you.

I tried that. Users have the option not to take update. Some users were not offered the update. If a user is offered and does not take the update he will not be able to take it later. Also it shows up that it is checking for update on load which does not look good.

Maybe its some setting I did?

That works when you do it directly into SQL.
my problem is:

using(mydatacontext dc = new datacontext())
{
Table tbl = dc.tbl.first();
tbl.name = textbox.text;
dc.submitchanges();
}

If a textbox saves to a new record it works fine but here where there is an update it does not.

How can I pass the "N" into the update?

Show what you have so far.

Also why would I need Visual Basic powerpacks when I am using c#? Its confusing.

He tried checking for updates but it did not solve the problem. Will give that another go tonight. What I cannot understand is that I did not use anything new in the update I made - It was a minor code change. - So why would it require any new components? Would users always require to have the latest windows updates for my system to work?

Good luck!

in SQL to do a for each loop you need a cursor

Declare c1 cursor for select * from table

I suspect this is your main issue. Give it a go and come back if you have any problems,and post your code.

When I initially joined I was googling for info. After some time I noticed that codeproject comes up often and with good solutions so I began to frequent the site more. Only recently did I have the courage to post my first question and then while waiting for a reply I had a look at unanswered questions and found that I could help a few people out. Since then I enjoy posting questions and looking through the unanswered. Yesterday Dalek posted a comment to my question and I checked out his profile. I might become addicted to this!!

Great! Thanks very much worked first time.

I had a similar problem which was quite silly when I solved it. I was trying to run the camera while transmitting on another program. If so just switch the other off.

When you go to the properties of the report, there is page size. Set this to the size of your paper and select the margins you would like. Fit your report into the grid area and you should be OK.
Make sure that you do not go over the limits as you end up with multiple blank pages when printing.

In the report properties there are the page size and margins. Make sure that on the design the background does not go over these limits as it will look OK but give problems when printing and exporting. IE if your page is 29.7 X 21 (I believe)and you set your margins to 1 all round even if the report itself is within these limits the background need to also fit in. hope this is clear enoygh and helps you out.

Just had a look at your profile after your comment to my question. If you're quite new to programming I would suggest you look into LINQ as it makes life much easier. I suspect any applications you build will be heavy on data so it would help to work on the database side. (Just my personal opinion here.)Sorry can't help you in web dev - I stick to windows myself.

It would help if you explain better what you would like to do.

You are on the right track. What you will need to do is to split your SP into smaller ones that perform one action and call what is necessary from your main sp depending on your original result.
Using nested SP is common practice.
Use in line documentation to be able to do future changes.

You may also need to consider if your db design is normalised.

The advantages of using SP is speed and reducing network traffic. If I get it correctly you have the same front end which you use for multiple customers who could be using different DB types but require the same business logic.

Business logic makes more sense to be on the DB side with only results being transported. SP are best used when there is a lot of calculation to be done and when only a small result set is required of the whole data otherwise transported e.g. Creating invoices, getting customer history.

SP can be easily scripted and implemented on another db with minimal changes.

How to create a Stored procedure:
CREATE PROCEDURE MY_SP

--ADD PARAMETERS IN THE FORMAT
@Customer varchar(50),
@Date datetime

AS
BEGIN
SET NOCOUNT ON;

Select * from customers inner join invoices on customers.CusID=Invoices.CusID
where Customers.name=@customer
and invoices.date>=@date

END
GO


This would give the invoices for that customer on or after that date.

You can put any query in the proc and any calculations required.
To run it all you will need is to call the proc and pass the parameters. It will then return the required result.

The more your data increases the more you would see the benefits as otherwise you would call all the customers and all the invoices and do your calculation on the front end. Server are generally more powerful than client PCs and you must remember that any system will only be as fast as the slowest link.

PS If you require any changes to business logic you can change the procs as required and as long as you do not change the input parameters or the format of the result set you will not need to recompile the front end.

I hope this helps you out.

I am not using MOSS or Sharepoint - I found those articles.

The third one, I cannot really understand. The only thing I imagine could cause the problem would be that I modify the registry on load to be able to save usernames and passwords. Could this be the issue?

You're welcome. Let me know how you get along and if you need any help.

I do not know if this is the right one. I found it under security - Audit Success. Nothing else seems to make sense.

What has been happening is that it gives the above error and an option to continue. When selecting continue it launches but does not close the installer.

Log Name: Security
Source: Microsoft-Windows-Security-Auditing
Date: 05/03/2011 22:35:06
Event ID: 4672
Task Category: Special Logon
Level: Information
Keywords: Audit Success
User: N/A
Computer: Fleur-PC
Description:
Special privileges assigned to new logon.

Subject:
Security ID: SYSTEM
Account Name: SYSTEM
Account Domain: NT AUTHORITY
Logon ID: 0x3e7

Privileges: SeAssignPrimaryTokenPrivilege
SeTcbPrivilege
SeSecurityPrivilege
SeTakeOwnershipPrivilege
SeLoadDriverPrivilege
SeBackupPrivilege
SeRestorePrivilege
SeDebugPrivilege
SeAuditPrivilege
SeSystemEnvironmentPrivilege
SeImpersonatePrivilege
Event Xml:
<event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<system>
<Provider Name="Microsoft-Windows-Security-Auditing" Guid="{54849625-5478-4994-A5BA-3E3B0328C30D}" />
<eventid>4672
<version>0
<level>0
<task>12548
<opcode>0
<keywords>0x8020000000000000
<timecreated systemtime="2011-03-05T22:35:06.512727200Z">
<eventrecordid>36395
<correlation>
<execution processid="552" threadid="5624">
<channel>Security
<computer>Fleur-PC
<security>

<eventdata>
S-1-5-18
SYSTEM
NT AUTHORITY
0x3e7
SeAssignPrimaryTokenPrivilege
SeTcbPrivilege
SeSecurityPrivilege
SeTakeOwnershipPrivilege
SeLoadDriverPrivilege
SeBackupPrivilege
SeRestorePrivilege
SeDebugPrivilege
SeAuditPrivilege
SeSystemEnvironmentPrivilege
SeImpersonatePrivilege

Do you need to know how to send the mail message?
How to create the body of the message?
How to include the file name that you have in the variable?
How to get the file name?

If you post an example of your code it would help

I had an issue a long time ago using between but cannot remember what the outcome was back then. Now I always use:

where DTE>=@FromDate and DTE<=@ToDate

and also make sure that dates are in the same format DD/MM/YYYY etc

I don't know if this is true, but I tried to do this and was blocked by the IS. I was advised to use some third party software like TeamViewer to access the machine. Good luck.

Thanks again. You saved my day!

OK thanks for pointing me in the right direction.

I was thiking of passing three parameter with an array of the subitem, imageindex and names separately and reconstructing the listview at the other end.

On load I have this

Disposed += p_Disposed;
Activated += p_Activated;
Deactivate += p_Deactivated;
CreateHandle();
var host = ConfigurationManager.AppSettings["serverHost"];
var parameters = new RemotingParameters(host, 4002);
parameters.Cryptography = new RijndaelManaged();
fConnection = new RemotingClient(parameters);
fConnection.UserChannelCreated += p_UserChannelCreated;
var server = (IServer)fConnection.InvokeStaticMethod("GetServer");
fClient = server.Connect(user, new Client());

I have this server interface


namespace FTNCommon
{
public interface IServer
{
IServerClient Connect(string nickName, IClient client);
}
}

which is implemented here

public Server()
{
fServer = new RemotingServer();
fServer.RegisterStaticMethod("GetServer", typeof(Server).GetMethod("GetInstance"));
fServer.CryptographyMode = CryptographyMode.Required;
fServer.RegisterAcceptedCryptography<rijndaelmanaged>();
fServer.MustUseAsyncVoidCalls = true;

fServer.UserChannelCreated += p_UserChannelCreated;

UnlimitedThreadPool.Run
(
delegate
{
try
{
fServer.Run(4002);
}
catch
{
}
}
);
}

I have a common class library if that helps

OK a friend did the basic server for me and I am building around it. Would think WCF but not sure. Any way I can check?

Windows service

Stupid mistake. It populates but because of the column widths was not visible.

Back to the original issue. The name property of the listview item is still lost when calling the server to update the list.

So userlist leaves client with name but arrives without.

When I open this form it sets the columns on load event. (the ones we swapped round). then it calls a server procedure to connect to all online users and update their userlist. this worked fine in the old setup which set the imageindex and subitem and name properties. Once swapping the columns the list view was no longer populated. I expected the columns to change place only.

I have various settings the user can make which change the position and image for his username.(the original problem) With the old column settings the userlist populated correctly but lost the name property, which does not allow me to select a second change from any user.

Hope ita a bit clearer now.

Sorry I must be confusing you. These happened on loading way before the original issue where I lost the name property, if that makes sense

Original it showed the image and then mystring (icon and text)
With columns swapped nothing showed in the listview.
This seems very starnge. I expected it to just change position and to be able to check if the name property had been stored.

I really appreciate your patience with me on this issue.

Just tried that but it didn't load at all.

The code to load the items is:
item.imageindex=myint;
item.subitems.add(mystring);
item.name=myname;

When I swapped the columns I got nothing returned into the list. I thought that would work.

same problem if passing a single listviewitem???

On form load I create the columns as below

listUsers1.View = View.Details;
listUsers1.FullRowSelect = true;
listUsers1.Columns.Add("Icon", 35, HorizontalAlignment.Left);
listUsers1.Columns.Add("UserNick", 200, HorizontalAlignment.Left);

and then populate the list;

So the first subitem would be the image.


Working on the function now.

Good so far - just one little bit more!

When you call your main form below you need to pass in the permit parameter

SCRIBE_REPORTS sr = new SCRIBE_REPORTS(permit);

When loading Scribe_Reports you need to remove the menuitems according to the permit level. Best practice would be using SWITCH(permit) CASE code;

Yes I have 2 sub-items a string and an image. How can I check if it is being serialised?

How can I show you the data? I can only see it when debugging!

I have a list of listviewitems - sorry the tags messed up what I wrote. When I pass it as a parameter the name property of the listviewitem is removed. All the items are in the list but missing the value for the name parameter. ie the parameter is now an empty string.

Tried this and it seems to be working on local network. Need to test further to confirm. Thanks.

using (FTNDataDataContext fdc = new FTNDataDataContext())
{
FT_User me = fdc.FT_Users.Where(x => x.FT_RMU_USR_ID==userID).First();
me.FT_RMU_Admin = true;
fdc.SubmitChanges();
}

I am using the above code from the client side and then querying a view based on the users table linked to another 2 tables to get the current users from the server side.
It appears that the view is not updated till the server reads but a couple of seconds later it is.

I believe ~I am committing the data. Had a look at that article but could not understand it.

I have about 2.5 million records and need to reference additional tables. This is a dump from a legacy system with no unique columns. I'm currently inserting primary key columns when I can as they take ages so I stop the dump in the meantime. Plan on indexing main queried fields.

I have captured daily inserts through triggers to give information on current activity and am planning reports on historical data.


If I could join the two it will wgive me more flexibility.

Can you suggest the best way forard?

Adding the field directly from the server worked. It took some time but got there at last.

The data is a live dump from a legacy system which is still live. I'm trying to add the field through design directly from the server and it does not seem to time out. Has been running for about 30 mins now. The cursor is a good idea if this doesn't work. Normalising the data is my ultimate goal but i think that would involve rewriting the legacy system I have to live with!!

Thanks very much.

I have now configured the program to send mail from the server side and it works perfectly.

I will check, but this is probably the problem. Is there a workaround to bypass the block?

I don't quite understand what you mean by dc and helper function.

I managed to do it through parameters.

Thanks for your time

I think I did not explain properly what I am trying to do:

I have 1 report with multiple tables (6) each with its own dataset.

What I need to do is to hide a table if there is no data for that table leaving the others visible.
I am using LINQ for the data so hat will be in a List - If list.count=0 hide table

That is what I tried first.

through C# I have tried o find an option e.g. reportviewer1.table1.visible but have not succeeded

through the report designer on table properties there is the visible option but when I tried the function I could not find how to set the visibility
e.g. iif(Count(Fieldname)=0,table1.visible=false,table1.visible=true)