Click here to Skip to main content
Page 1 of 9
Page Size: 10 · 25 · 50


Author filtered by: CHill60 [x]
Answer 14 May 2013   license: CPOL
You need to add Launch Conditions to your setup. See How to install Mysql.Data Connector with C# setup[^] for some links on adding launch conditions. I've used that link specifically because it also tells you how to silently install the MySql database setup - you're going to have to ensure...
Answer 14 May 2013   license: CPOL
To improve performance you need to minimise the use of the Excel COM interface.I would suggest converting your list of objects to a datatable first and then exporting that to excel ...Here is a generic way to convert a list to a datatable Converting a List to Datatable[^]and here's how...
Answer 13 May 2013   license: CPOL
You need to set up the new column with identity(1,1), temporarily disable the auto-generate while you populate it with the data from the old DB, and then going forward it should work ...Have a look at SET IDENTITY_INSERT[^] to get you started
SQL
Answer 13 May 2013   license: CPOL
Because these are radio buttons only one rb may be checked at any time. Clicking on one of them will automatically clear the rest. The same will happen if you do it in code.In your code you are setting values to False so the automatic behaviour does not kick in. Try just using Private Sub...
VB
Answer 13 May 2013   license: CPOL
Have a look at this code project article[^] on the subject
Answer 12 May 2013   license: CPOL
Assuming you mean the CMSIS DSP Software Library as provided by ARM Ltd then this is the reference you need CMSIS DSP Software Library documentation[^]
Answer 12 May 2013   license: CPOL
Try loading from Excel into an intermediate DataTable, add your required data to the DataTable and then do the bulkcopy into the database using the DataTable.Here is an example where someone has done something similar[^]and here is the MSDN documentation for that overload[^]
Answer 12 May 2013   license: CPOL
This isn't as obvious as it may sound so it's a shame whoever downvoted your question didn't try it out for themselves.The "obvious" solution is to use something like Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ...
Answer 10 May 2013   license: CPOL
You'll be better off following the instructions from DevExpress themselves.Step 13 in the devexpress documentation[^] deals with this behaviour
Answer 10 May 2013   license: CPOL
In the answers to this asp forums post[^] there are several links to help with filtering gridviews. If the method you want to use isn't covered there then try a google search with "asp.net filter gridview".For the part of your question about sending the data to the database then the MSDN...
Answer 10 May 2013   license: CPOL
Just change your sql statement to sql = "Select studid,s.Bfid,Rate,class from student s left outer join Batch b on s.Bfid=b.Bfid";I've used left outer join in case you have student records that do not have Batch records. If you only want to list students that do have a Batch record then...
C#
Re: 3 Spammers by CHill60
Forum Message 9 May 2013  
We overlapped! I've reported a couple - I'll go and do the rest now
Answer 9 May 2013   license: CPOL
I was very tempted to use lmgtfy.com but ...Work your way through this link http://www.dotnetspider.com/resources/28460-Create-Login-Form-Windows-Application.aspx[^]It faffs about with XML and Datasets - you can substitute a search of an appropriate table in SQL for those bits.If you are...
Answer 8 May 2013   license: CPOL
Try reading the data with the following SQL SELECT TOP 100 percent * FROM [yourtable] ORDER BY newid()You can change the 100 percent - I just assumed you'd want the entire table.You could also drop the percent to get e.g. 100 questions.With acknowledgements to Ralph Shillington[^]
Answer 8 May 2013   license: CPOL
Have a look at this article for 2005[^]I actually found this one easier to follow[^] but it's for an earlier version
Answer 8 May 2013   license: CPOL
This will fire regardless of which checkbox is clicked but shows you how to work out which one it wasprivate void CheckBoxCheckedChanged(object sender, EventArgs e){ CheckBox c = (CheckBox)sender; MessageBox.Show(c.Name);}... and will only fire for the checkbox that was just...
Answer 8 May 2013   license: CPOL
An alternative example that walks through the code with explanations can be found here[^]
Answer 8 May 2013   license: CPOL
It's quite possible that the log file can be greater than the database - it really depends on the number of transactions rather than the number of records. It's ok to change MAXSIZE but you need to be really sure that you want to (you can get all sorts of issues when the transaction log fills...
Answer 8 May 2013   license: CPOL
This would be a question to be directed to the Magento support teamhttp://www.magentocommerce.com/knowledge-base/entry/configuring-email-addresses-for-your-domain[^]
Answer 7 May 2013   license: CPOL
Use openVisualStudio2008.Arguments = @"c:\program.cs"; before the openVisualStudio2008.Start(); (replacing "c:\program.cs" with your appropriate file name of course!)
Answer 7 May 2013   license: CPOL
You can use TextRenderer http://msdn.microsoft.com/en-us/library/system.windows.forms.textrenderer.aspx[^] to determine what size the text box needs to be in the TextChanged event of the textbox - or better yet do as OriginalGriff suggests and make your own re-sizing custom control inheriting...
Answer 7 May 2013   license: CPOL
Firstly you are leaving yourself open to a SQL Injection attack - use parameterized queries rather than concatenated text - your code will be clearer too http://www.dotnetperls.com/sqlparameter[^]Next - your problem is because the time is probably being added on to the string v_expdt. You...
C#
Answer 7 May 2013   license: CPOL
Firstly there is no real concept of a paragraph having a "heading" - each block of text is essentially a paragraph in itself.For example I have a word document similar to this ...Heading 1 Some text or otherHeading 1.1 (Heading 2 style) Some indented textHeading 1.2 (Heading 2...
C#
Answer 7 May 2013   license: CPOL
There are some useful websites provided by Google (themselves - I don't mean search for other links using google).For example http://code.google.com/[^]orhttp://www.google.com/cse/tools/create_onthefly[^]Here's an article from a non-google...
C#
Answer 7 May 2013   license: CPOL
I would refer you to the Yelp website http://www.yelp.com/developers/documentation/v2/authentication[^]or to their developers forum https://groups.google.com/forum/?fromgroups#!forum/yelp-developer-support[^]
Answer 6 May 2013   license: CPOL
The code isn't refreshing the form, you're creating a new form every time p = new Purchase();Define p outside of this code (e.g. define it at the public partial class Form1 : Form level) and re-use that instance when you want to add a row.In other words ...public partial class Form1 :...
C#
Answer 3 May 2013   license: CPOL
You haven't posted sufficient code for me to be able to reproduce your code to a compilable stage (and I'm not prepared to wade through 30+ errors on your behalf!)However you appear to be passing into the function the students that can fit in a room available rather than the number of rooms...
C#
Answer 3 May 2013   license: CPOL
Where you currently have drgvCampaignDetails.DataSource = ds; try defining which table you want ... e.g.drgvCampaignDetails.DataSource = ds.Tables[0];
C#
Answer 3 May 2013   license: CPOL
You are getting the error because you have not defined any columns for the datagridview.You could do this at design time by right-click on the control and choosing "Add column..." but this would tightly bind your UI to the current implementation of facade.GetPurchase so is not the best...
C#
Answer 2 May 2013   license: CPOL
If you search google or yahoo with the phrase "pl/sql exercises" you will get many examples (I got around 60k hits so too many to list here) - some are very basic and some are more complicated. Quite a lot of them are in sample chapters from books on the subject but most are free.If you also...
SQL
Answer 1 May 2013   license: CPOL
This 3rd party tool definitely allows for regex http://www.gnostice.com/nl_article.asp?id=238&t=PDF_Text_Redaction_Using_PDFOne_NET[^] although it's not cheap
Answer 1 May 2013   license: CPOL
Your schema is wrong - the Person Table should not be referencing table RefType but table Ref. As things stand you have no link to table Ref from table Person. In other words you cannot query for the data you are asking for.Make that change and you will also need to change your insert into the...
SQL
Answer 1 May 2013   license: CPOL
Firstly into using tranactions - http://www.sqlteam.com/article/introduction-to-transactions[^] and the microsoft documentation here http://msdn.microsoft.com/en-us/library/ms174377.aspx[^]However, you seem to be implying that the user can make this choice for themselves (compared to...
Answer 1 May 2013   license: CPOL
Probably not the nicest way to do this but it works and does have the advantage that it will work for any version of SQLselect DISTINCT (A) from my_Tablewhere A in (select A from my_Table where B = 1)and A in (select A from my_Table where B = 2)and A in (select A from my_Table where B =...
SQL
Answer 30 Apr 2013   license: CPOL
I'll walk through this solution bit by bit ...Quote:Query should be using "LIKE" operator where Column A1 like ('%B1%') OR Column A1 like ('%B2%').Could be solved with SELECT * FROM A INNER JOIN B ON A1 LIKE '%' + B2 + '%' OR A1 LIKE '%' + B1 + '%'Quote:If column A1 matched from B1 OR B2...
SQL
Forum Message 30 Apr 2013  
... and I thought it was just that my reputation had preceeded me ;P
Answer 29 Apr 2013   license: CPOL
There is an article about that in CodeProject (and about a quarter of a million hits in Google)Changing the color of a row in a GridView in ASP.NET[^]Only about 200k hits in googlehttp://stackoverflow.com/questions/11135353/datagrid-row-color-change-based-on-data[^]
Answer 29 Apr 2013   license: CPOL
Try SET @PFactor=(SELECT MonPfactor FROM dbo.CbzCurMst WITH(NOLOCK) WHERE CurType='INR'
SQL
Answer 29 Apr 2013   license: CPOL
In SQL you can't really determine the order that records will appear (physically) in the table. You can control how they are retrieved though for example you could use select * from OutputReportCustom order by UserECodeIf it is really important to you that the records are retrieved in the...
Answer 28 Apr 2013   license: CPOL
The "proper" way to make triggers really depends on your database schema, your application, your need to audit etc etc .... for example *we* currently audit approximately 150 "sensitive" items across 20 tables ... we don't "care" about the rest. This link has discussions about several...
Re: Users Are Evil by CHill60
Forum Message 28 Apr 2013  
This is where you need to have a cricket bat in the office. Write the users name on it and then when they do this again phone them up to say "Somewhere there is a cricket bat with your name on it" - y
Answer 28 Apr 2013   license: CPOL
Your problem is at the end of you OleDbCommandu.U_id= " + userid, s.U_id = " + userid,ss.U_id=" + userid, con);You need some extra quotation marks in there - I think it should be u.U_id= " + userid + ", s.U_id = " + userid + ",ss.U_id=" + userid, con);I suspect you'll then probably end...
Answer 28 Apr 2013   license: CPOL
Have a look at some of the open source sites - read the documentation for some the stuff already posted without looking at the code, and just have a go.E.g. http://www.codeplex.com/[^]http://channel9.msdn.com/coding4fun/[^]http://www.dotnetspider.com/projects/[^]
Answer 28 Apr 2013   license: CPOL
Have you done any research at all?? For example in MSDN.Microsoft.com you will find the following http://msdn.microsoft.com/en-GB/library/db5x7c0d.aspx[^]
C#
Answer 28 Apr 2013   license: CPOL
Assuming this function actually gets called (you can confirm this by putting a breakpoint in there) then it largely works.Your problem is with wbSource.Close - if you put a break point on cboTemp.Activate and then look at your combobox you will see that it is populated. As soon as you close...
Answer 28 Apr 2013   license: CPOL
You should really attempt to do your own research first before posting questions that could very easily have been answered from your text book, course notes or a google search.Have a look here http://stackoverflow.com/questions/6859248/binding-data-from-the-database-to-a-dropdown-list-in-net[^]
Answer 28 Apr 2013   license: CPOL
The panel isn't scrolling because it doesn't need to ... as far as it's concerned you don't have anything outside the visible range. You can "fool" it into thinking that you're drawing outside the visible range by playing about with the AutoScrollMinSize ... e.g. if (richTextBox1.TextLength >...
Answer 28 Apr 2013   license: CPOL
*Nodding to Zoltán Zörgő*It's almost certainly down to your table definition ... best demonstrated with an example ...-- This version will FAIL if there is a null in FKIDcreate table parent( ID int IDENTITY(1,1) NOT NULL, SomeData varchar(20), CONSTRAINT PK_parentID PRIMARY KEY...
Answer 28 Apr 2013   license: CPOL
I started playing about with this, got something working and then found this link http://msdn.microsoft.com/en-GB/library/ms404318(v=vs.85).aspx[^] - much easier to post this link than to try and post my code!
C#
Answer 28 Apr 2013   license: CPOL
Quote:Now I am having more than 1 user, so If i create a temp table then more than one user will store the data, so, then data may mismatch. - Only if you use global temporary tables (prefix ##). If you use local temporary tables (prefixed with #) then they are "private" to each user so the...

Page 1 of 9
1 2 3 4 5 6 7 8 9


Advertise | Privacy | Mobile
Web04 | 2.6.130513.1 | Last Updated 15 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid