Today, I am going to take a break off from other software and take a review on one of the .NET component; I would call it [URL="http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html"]Spire.xls[/URL]. The product title says it all, the main purpose of having this software is to enable developers/programmers to fast generate, read, write and modify Excel document for .NET and Silverlight. These are the features of Spire.xls, if you happen to browse through their official site. Directly Operate Excel Document Import/Export Format Cells Insert Content to Excel Document Conversion - Only for .NET Marker Designer Well, let’s not get over the list of features …

Member Avatar
+0 forum 0

Hi guys need urgent help. I am making a youtube downloader that downloads two or more videos from Youtube at the same time and I don't how to do it using System.Net.Webclient in C#.Net. Please post a code snippet. HELP!

Member Avatar
Member Avatar
-2 forum 5

hey Dear members i want to learn asp.net but i am little confuse which is best for beginner any easy is it VB or C#

Member Avatar
Member Avatar
+0 forum 8

Can anyone help me with finding this ebook, it's mentioned but not available on google. :-/ Kindly Help. Thanks Book Title: Essentials of .net programming -Theory and application Author: C. Komalavalli Sanjib K Sahu

Member Avatar
Member Avatar
+0 forum 4

Hi Any suggestion on how to save an image file into mysql using the .NET api? I tried code similar to this : MemoryStream stream = new MemoryStream(); byte[] imgData; //previously available image in the program Image.Save(stream,ImageFormat.Jpeg);// saves the image into the stream imgData = stream.ToArray(); //now I have the bytes in my array StringBuilder sb = new StringBuilder(); foreach(byte n in imgData) sb.Append(n); //assuming the connection is open and everything is init MysqlCommand cmd = new MysqlCommand("INSERT INTO myTable(binarydata) VALUES('"+sb.ToString()+"')"); int affetced = cmd.ExecuteNoQuery(); Don't pay attention to sytax that much I just wanna know how would somebody do …

Member Avatar
+0 forum 0

hi, i have a question in C#.net report viewer. i want to create a report which will take a user input and generate a report. what i want is get the month from the user input and get it as a parameter for the sql query go get the result. say for example the user selects the date 1/1/2011 so it should get the month as january and get all the people born in january and display. i have a feild in the database which tracks the employees born date so from that i can generate the query, but how …

Member Avatar
Member Avatar
+0 forum 18

hi there i have a database which is MS SQLserver 2008 and ihave a database called AdminApp. from visual studio 2008 i add the database and the connection is succeded, but when i get the connection string and add it to my DB class for the db string and run the application i says, can't login to the database, and note the pasword is displayed as ******* in the connection string. but when i erase ******** and type in the letters for the password the connection is ok and it logs in to the database, why is this happening, how …

Member Avatar
Member Avatar
+0 forum 12

hi there, i want to develop a login in asp.net C#. please can someone give me a guide to develop a login web page using MVC pattern i am using visual studio 2008 please can some show how to create a login using MVC thanks

Member Avatar
Member Avatar
+0 forum 2

Hi there, i have a question in C#.NET report viewer. i save the phone number in the database as (234) 233-1346 . so if the use doesn't type in a phone number it will be saved as [() - ] which is show in side the squared brackets, without the squared brackets. in the report it sows as () - for the number that are not inserted. how can i avoid it and leave a blank over there?? please can someone help me!!!!!!!!! thanks

Member Avatar
Member Avatar
+0 forum 2

hi there i have a database called employee and in that there is a table called EmpDetails and in that there is column namely firstname awhat i want to do is to return all the first names in the database. i am using the 3 tier architecture. from the dbcommection after executing a select query a datatable is being returned to the DAO class what from there how do i send the information to the Business layer appricieate help thanx

Member Avatar
Member Avatar
+0 forum 1

hi there, i have a question in C# files. i have a client application which is created in visual studio C#. and from that i copy a file to a folder in the server computer folder. so when i am trying to display it ot the user i user System.Diagnostic.Prcess.Start(PathToTheFileInTheServer) (the file path is saved in the field in the database table.) but there is a problem when one person has open file A and the second person tries to open file A he won't be able to open because the first person has opened it, what is the solution …

Member Avatar
Member Avatar
+0 forum 5

Hi there, how can i create an executable so that anybody can install in their own computer? I want to create from visual studio C#. please give me a tutorial or something, i did some but it didn't work properly please help guide in this thanx

Member Avatar
Member Avatar
+0 forum 3

Hi there, I have a question in EncryptByPassPhrase. I am trying to encrypt the source column in the database table PForm. When I run the code it sasys, “Failed to convert parameter value from a String to a Byte[].” the SourcePath column in the database is varBinary(256) type. What is the problem over here. [CODE] public void AddFormDetails(string ID, string SourcePath) { string query = @"Insert into PForm(ID, SourcePath) Values(@id,EncryptByPassPhrase('AdminApplication',@source)"; SqlCommand command = new SqlCommand(query, DB.getConnection()); command.Parameters.Add("@id", SqlDbType.VarChar).Value = ID; command.Parameters.Add("@source", SqlDbType.VarBinary).Value = SourcePath ; db.openConnection(); command.ExecuteNonQuery(); db.closeConnection(); } [/CODE]

Member Avatar
Member Avatar
+0 forum 2

hi there, i had a question regarding this before as well. i have a datagridview and it has three combo boxes, with one with form name and the other with employee name and the other just a selection. what i want to do is to make the form name combo box to be a datagridview combo box as well as a datagridview textbox . the code is below [CODE] private void dgvForm_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e) { DataGridViewComboBoxEditingControl comboControl = e.Control as DataGridViewComboBoxEditingControl; if (comboControl != null) { //Set the DropDown style to get an editable ComboBox if (comboControl.DropDownStyle != ComboBoxStyle.DropDown) …

Member Avatar
Member Avatar
+0 forum 4

hi there, i have a code to validate a tel number but the thing is i want it to restrict it for 10 digits. currently i can add any number of digits how can i restrict it to 10 digits the code is below [CODE] public bool ValidateTelNo(string TelNo) { bool value = false; string rePhoneNumber = @"[1-9]\d{2}\s?\d{3}\d{4}"; string PhoneNoFormat = @"\([1-9]{1}\d{2}\)\s?\d{3}\-\d{4}"; Regex re = new Regex(rePhoneNumber); Regex re1 = new Regex(PhoneNoFormat); if (re.IsMatch(TelNo) || (re1.IsMatch(TelNo))) value = true; else value = false; return value; } [/CODE] thanks anisha

Member Avatar
Member Avatar
+0 forum 8

Hi I have a question regarding the datagridview cellFormatting event in C#, [CODE] if (e.ColumnIndex >= 0) { if (this.dgvSubContractor.Columns[e.ColumnIndex].Name == "TelNo") { if (e.Value != null) { this.dgvSubContractor[3, row].Value = c.CheckingValue(e.Value.ToString()).ToString(); } } return; } [/CODE] I wrote the below code to format a 10 digit number to (456) 123-7890 But when I add a new row the previous value of the tel no will display in the newly added row, How can I avoid this.

Member Avatar
Member Avatar
+0 forum 3

hi there, i have a text box in a form to enter a float value.say that the user types in 1234567789.09 it should be formatted and display as 1,234,567,789.09 how can i do this. i am using a text box. please can someone help me in this or give me some guidence??? thanxxxxx

Member Avatar
Member Avatar
+0 forum 6

i have a datagridview in that i have two combo box columns, i want to make one of the combo box to be a text box as well as a combox but the other combo box i want to leave it as it is? how can i do this??? i have the code to make it a text box when the cell is clicked [CODE] private void dgvForm_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e) { DataGridViewComboBoxEditingControl comboControl = e.Control as DataGridViewComboBoxEditingControl; if (comboControl != null) { Set the DropDown style to get an editable ComboBox if (comboControl.DropDownStyle != ComboBoxStyle.DropDown) { comboControl.DropDownStyle = ComboBoxStyle.DropDown; …

Member Avatar
+0 forum 0

hi , i have a field in a table with the datatype as datetime. i wrote a query to get that feild but the thing is i want only the date to be displayed, how can i do that, currently the date and the time is being is displayed, how to i chase the query to only display the date only i ma using MS SQL 2008. and C#.NET thanks can some one help me in this thanks

Member Avatar
Member Avatar
+0 forum 1

hi there, i have a question in visual studio report viewer. i created a report in microsoftreport view tool and connected to a server, when i run the application in another machine i cannot view the reports, it gives an error saying " Unhandled exception has occured in your application. Could not load file or assembly 'Microsoft report viewer.WinForms, Version=9.0.0.0, culture=neutral, publick keyToken=b03f5f7f11dd50a3a' or one of it's dependencies'.The system cannot find the file specified" what is the problem over here please can some one give me a solution for this thanxxxxxxxx

Member Avatar
Member Avatar
+0 forum 1

hi there i have a question i have created the login in C# deshtop application and when the application ruins i have amde the cursor to be focused to the username textbox now the thing is soemtimes the user adds the username and then adds the password a and then press Enter but my application does not work for that how can i make that enabled thanx

Member Avatar
Member Avatar
+0 forum 3

Hello all, I have an app that I've developed that has a vb.net front end and a SQL Server 2000 database backend. I currently have it running fine on my machine and it also installs fine on all the users that are inside the domain that the app was written in. When I try to install my application on another domain it hangs and doesn't even run the install script. Has anyone ever experienced problems installing an app accross domains? Is there something that I need to code differently to make it non-domain specific? I could use some suggestions to …

Member Avatar
Member Avatar
+0 forum 5

I have created setup file of my program. I have tried to install it there in two pcs to test it that its working properly or not. One pc has visual studio & my program worked there after being installed but another pc doesnt have visual studio & my program doesnt work there after being installed. It shows error message that "WindowsApplication1 WindowsAoolication has encountered a problem and needs to close. We are sorry for the inconverience." What does it mean? Does it mean it that I couldnt create setup file properly? Would you please help me to get rid …

Member Avatar
Member Avatar
+0 forum 4

I need to install something called .Net Framework. I have checked several sites on Microsoft and this issue is as clear as mud. There is a file called dotnetfx.exe that is supposed to be able to install the .Net Framework to my Windows 98. (I have an 8K console application written in VB.NET that initiates printing.) The download site for the dotnetfx.exe file is some 28MB! Can this be right? Do you really need to download 28MB to your computer just to get an 8K exe to run? Pete

Member Avatar
Member Avatar
+0 forum 9

The End.