i would like to use it like this string role = GetRole.OfUser(username); So do so; that appears to be correct. Did you try it? or like this even better: string role = GetRole(username); That won’t work; you have to specify the method you’re calling as well as what class it comes from. If you had … Read more
You can’t format when it’s null; hopefully the reasons why are obvious. You need to check for the value first: string formattedValue; if (partData.FW_Step.HasValue) formattedValue = partData.FW_Step.Value.ToString(“F3”); else formattedValue = “default value for null”; You can make this code shorter using a ternary expression: string formattedValue = partData.FW_Step.HasValue ? partData.FW_Step.Value.ToString(“F3”) : “default value for null”; … Read more
Since you didn’t provide any code here and asked for the directions, so here you go. Lets assume your TextBox name is ‘textBox1‘ and there is some button beside it. On the click event of that button you should be querying your database for the customer names that matches the text inside your ‘textBox1‘. The … Read more
! means not. IsNullOrWhiteSpace is a static method of String which returns a boolean value, so the code is returning whether both ‘Code’ and ‘State’ have a value. solved What does this “!string” mean?
Or you could use BETWEEN aside from TOP statement like: SELECT TOP(10) * FROM table1 WHERE cat = 1 and datee BETWEEN DATEADD(day, -1, @dt) AND @dt ORDER BY datee DESC solved Get entries stored in database from yesterday [duplicate]
I have created the Tagging System using ASP.net Check it out.. nd do rate it.. Tagging System using ASP.net by Sumanyu Soniwal solved Tag System in Asp.net
Add a column in the DataTable and save the time stamp of the insertion. You can loop thru the rows and remove the older than 5 minutes ones solved Last 5 minutes on Runtime Datatable [closed]
Let me explain what foreach actually does. It iterates over a collection of elements inside an IEnumerable, in order, without skipping anything, even if the current element has the value null. If you have an array with [5,2,24], the elements will be called in oder 5, 2, 24 and will stop after that. 5 solved … Read more
Web.Config itself is written in XML format right? Yes, but in addition to that it has an XML schema associated and the Configuration class which is responsible to read values from this XML file verifies that the schema is being respected. You should make the distinction between well formed XML and valid XML according to … Read more
Do something like for(int i=0; i< GroupOfPeople.Count; i++) { GroupOfPeople nm = (GroupOfPeople) nm.GroupOfPeople[i]; if(i < GroupOfPeople.Count – 1) names += nm.FirstName + “, “; else names += ” and ” + nm.FirstName; } solved C# ASP.NET for loop issue [closed]
Your stated goal is to link your web pages to your Access databases. This is possible, but you’ll need to do quite a bit of groundwork first. Yes, check out the Getting Started tutorials on asp.net, microsoftvirtualacademy.com, and so on. However, you seem to be missing the basics. A HTML file is something that can … Read more
This one should work exactly for first two files, but won’t work if there any additional special characters in file names: using System; using System.Collections.Generic; using System.Text.RegularExpressions; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { const string example = “PrintFileURL(\”13572_IndividualInformationReportDelta_2012-06-29_033352.zip\”,\”13572_IndividualInformationReportDelta_2012-06-29_033352.zip\”,0,\”53147\”,\”Jun 29 3:33\”,\”/icons/default.gif\”)”; Console.WriteLine(example); const string pattern = “\\\”([a-zA-Z0-9\\-_]*?\\..*?)\\\””; var regex = new … Read more
Ugh, be prepared for an accident that makes a mess of your data with this “associated by position” idea I wouldn’t use LINQ for this either var l = new List<string>(); string prev = null; foreach(DataRow r in dt.Rows){ var s = (string)r[“Column1”]; var t = (string)r[“Column2”]; if(s != prev){ l.Add(s); prev = s; } … Read more
I think you are looking for String.Insert Returns a new string in which a specified string is inserted at a specified index position in this instance. So simply use return name.Insert(extPos, “_180x140”); However as per your error is concerned use return name.Substring(0, extPos) + “_180x140” + name.Substring(extPos); solved Index and length must refer to a … Read more
How to make an algorithm to get all column names from across tables that relations with their primary key in SQL Server and C#? solved How to make an algorithm to get all column names from across tables that relations with their primary key in SQL Server and C#?