• Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in protected internal vs internal access specifier

    [Click Here](https://msdn.microsoft.com/en-us/library/ms173121.aspx) Can't explain it any better than this.
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in clear() function aint working

    Do you have a `KeyPress` or `KeyDown` event linked to the textbox?
  • Member Avatar for Fenrir()
    Fenrir()

    Began Watching transfer Numbers 1 to 100 from client to server using sockets in a console

    Please help me -_- transfer Numbers 1 to 100 from client to server using sockets in a console application. Number one second per second transmitted -_-
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in transfer Numbers 1 to 100 from client to server using sockets in a console

    So what's the problem? are you receiving errors? or is the code just not working in general?
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in transfer Numbers 1 to 100 from client to server using sockets in a console

    Have you tried anything yourself? This sounds like a typical homework assignment. Here are some links that could get you started on building a constructive question and actually post some …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Best way to declare paths

    You can try something like this [Article](http://www.codeproject.com/Articles/21186/SQL-Connection-Dialog) usually it would be better to host the database in a central location instead of user pc's. Or just use plain windows authentication. …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in SQL DATAREADER saying varchar to numeric

    As depicted above. try inserting a breakpoint in your code on line 7 `cmd.CommandText = "SELECT CAPITAL FROM TblProduct WHERE Description='" + descd.Text + "'and ` Hover over the CommandText …
  • Member Avatar for Fenrir()
    Fenrir()

    Marked Solved Status for Profile View

    Is anyone else having problems viewing their Profile? It was working fine until about a day ago now everytime i click on my profile i just get a blank page. …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Profile View

    Thanks seems to be working perfectly now.
  • Member Avatar for Fenrir()
    Fenrir()

    Edited Profile View

    Is anyone else having problems viewing their Profile? It was working fine until about a day ago now everytime i click on my profile i just get a blank page. …
  • Member Avatar for Fenrir()
    Fenrir()

    Created Profile View

    Is anyone else having problems viewing their Profile? It was working fine until about a day ago now everytime i click on my profile i just get a blank page. …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in The connection was not closed. The connection's current state is open.

    Just to clarify. The reason you are receiving that message is due to the fact that after the `SqlConnection` was opened it was never closed. So your statement `connection.Close();` never …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in writing in richtextbox

    Do you mean that you want the first half to be centered on top and then the second part below it to be left alinged? this is a very simple …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in How to Add Icons for Items in a ListBox

    > I have a simple code for listing database elements in a listbox and I would like to add icon for each element Just to explain this abit simpler seeing …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in c# xml multiple item to sql?

    assuming the nodes in the XML are static you can just call an item from the list above by referencing the index. seeing as you know what item would be …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Import xlsx file to textbox

    Alot of examples here [Click Here](http://stackoverflow.com/questions/657131/how-to-read-data-of-an-excel-file-using-c)
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in SQL Query only returns one item (rather than complete list) - asp.net mvc

    I don't see anything wrong with your code. as depicted in your code snippet above try inserting a breakpoint on lines 5,10 and hover over dropItems and dropItems2 it should …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in programe that creates,save, open file and writes user's input to a file

    So where exactly are you have problems? are you getting exception? Or is the data not displaying in your file? Are you limited to a certain type of file? Sorry …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in programe that creates,save, open file and writes user's input to a file

    Is there some problem with the code? Or is it merely for imformative purposes?
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in problems with foreach control

    Try this. `(c as CheckedListBox).CheckedItems.Count`
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in problems with foreach control

    Can't quite remember where i found this but it works like a charm. Add the following method in your application public IEnumerable<T> FindControls<T>(Control control) where T : Control { var …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in WPF make DataGrid have te same width a has the template

    Could you please post your code that populates the grid. Are you manually defining the columns on the grid? or are they auto generated by the item source. If they …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in WPF make DataGrid have te same width a has the template

    After adding a datagrid to the dockpanel add the following in your XAML for your datagrid. `Height="{Binding RelativeSource={RelativeSource AncestorType={x:Type Window}}, Path=ActualHeight}"` This will force your datagrid to maintain the host …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in WPF make DataGrid have te same width a has the template

    Try adding it to a dock Panel [Click Here](http://wpftutorial.net/DockPanel.html)
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in draw graph showing relation between data

    You should be able to create a user control for this in the WPF side and then use an element host in your winforms application. Here is a nice link …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in How to get Base64 String of Scaled Image

    There might be a better way but i'm lazy so i loaded the image into the picturebox it ads the size mode and then i save and load the image …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in how to separate fields while updating from one table to another

    So you're saying that on table 1 you have 3 column values in one column? and you want to split it and add it to columns 1,2 and 3 in …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in listview

    You would be able to do this with a listview yes. But it will be far from easy Have you tried anything on your own? start small instead of thinking …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Mysql Common Connection

    Create a new public class and declare a static connection string `public static string SqlConnection = Your .sdf connection string` or just declare an actaul SqlCeConnection instead of a string. …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in How to make search between two dates accept null not obligat

    So you're not using DateTimePickers for the dates? the problem is that when a textbox has no value the value is actually a blank string " " and not Null. …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Adding data to a cell in a DataGridView with C#

    `if (comboBox2.Items[comboBox2.SelectedIndex].ToString() == "1")` Do you mean this line? Could you please paste the exception you are getting?
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Data Grid View deleting after selection from Search Box.

    You mean `If (Textbox2.Text == "")` ? you should be able to add that in the text changed event
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Data Grid View deleting after selection from Search Box.

    Try adding a breakpoint on row 10 and checking the value of your RowFilter by hovering on it a small magnifying glass should appear. Click it and paste the text …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in how to take the first letter from input and put it in another textblock

    You can use this [Click Here](http://msdn.microsoft.com/en-us/library/ms256054(v=vs.110).aspx)
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in FtpWebRequest Upload creates blank file

    I've had this in the past and i felt pretty stupid but there wasn't enough space to actually create the file which will probably not be the case seeing as …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Auto Generate ID

    Once you have the value from the database you should have no problem concatenating the prefix. Or are we missing something? [Click Here](http://msdn.microsoft.com/en-us/library/hdt3k85x(v=vs.110).aspx) Here's a good example that might help …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Auto Generate ID

    I would suggest you get the max emp ID from the database first and then increment it by whatever you need `SELECT MAX(Emp_Id)+1 FROM Table`
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Lists

    For this type of application it would probably better suit you to use something like an XML file or database. The problem is passing data from one form to another. …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Excel data needs to be updated in existing SQL table

    [Click Here](http://www.aspdotnethelp.com/2014/02/export-data-of-datagridview-to-excel.html) Have a look here
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in how to import excel file in window form application database plz help ..

    A very quick google led me to this [Click Here](http://stackoverflow.com/questions/21670983/import-data-from-an-excel-sheet-into-a-sql-server-database) that should help you getting started on writing your own code for accomplishing this.
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in thread in looping method error

    Can you post the exact error you are receiving
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Substring Function in SQL Server

    [Click Here](http://stackoverflow.com/questions/761036/why-is-sql-server-storing-question-mark-characters-instead-of-japanese-character) This article should help you understand the problem. with the current collation settings on your database the above query should return `llo ??????`
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in How to restrict/block a user on 3 unsuccessful attempts by him/her in c#

    else { MessageBox.Show("Invalid user name or password. Please try with another user name or password", "Task", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtUsername.Focus(); } A simple solution would be adding a field on your …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Insert data

    What exactly do you have in your checklistbox? If you want an Insert Statement to run for each item in your checklistbox then you have to assign your parameters and …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Having problems accessing MS Access with C#

    Can you please paste the exact error you are receiving
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Read 'date' n Sum from a text file n compare it to user's input

    decimal Summe = 0; // <-- outside loop for (int y = 1; y < nofrows; y++) { line = sReader.ReadLine(); tileNo = line.Split(','); string unparsedDate = tileNo[0]; DateTime datum …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Read 'date' n Sum from a text file n compare it to user's input

    The variable `datum` is only assigned inside your `try{}` so that's where you need to do your comparisons
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Read 'date' n Sum from a text file n compare it to user's input

    Glad we could be of assistance.
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Read 'date' n Sum from a text file n compare it to user's input

    Sorry i was assuming you were using MS SQL here is the C# version string test = "41521.880937(04.09.13 21:08:33)"; DateTime date = Convert.ToDateTime(test.Substring(test.IndexOf("(")+1, (test.IndexOf(")") - test.IndexOf("(")-1)).Replace(".","-")); output : 4/9/2013 9:08:33 …
  • Member Avatar for Fenrir()
    Fenrir()

    Replied To a Post in Read 'date' n Sum from a text file n compare it to user's input

    So you're looking for something like this? DECLARE @Val VARCHAR(100) = '41521.880937(04.09.13 21:08:33)' SELECT CAST(REPLACE(SUBSTRING(@Val,CHARINDEX('(',@Val,0)+1,(CHARINDEX(')',@Val,0)-CHARINDEX('(',@Val,0)-1)),'.','-') AS DATETIME) AS Date Wrote this very quickly so feel free to play around with …

The End.