ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2017 www.aspforums.com. All rights reserved.What Data type we need to use to store binary files data in MySQL<p><span class="hps">hi</span> <span class="hps">all</span> <span class="hps">masters</span> <span class="hps">asp.net</span><br /><span class="hps">I</span> <span class="hps">use</span> <span class="hps">mysql database</span>, <span class="hps">to</span> <span class="hps">save</span> <span class="hps">a word file</span>, <span class="hps">pdf</span> <span class="hps">her</span> <span class="hps">what</span> <span class="hps">data types</span>? <span class="hps">if</span> <span class="hps">in</span> <span class="hps">sqlserver</span> <span class="hps">2005</span> <span class="hps">=</span> <span class="hps">varbinary</span> <span class="hps atn">(</span>max) <span class="hps">if the</span> <span class="hps">mysql</span> <span class="hps">what</span>?</p> <p>&nbsp;</p>http://www.aspforums.net/Threads/101030/What-Data-type-we-need-to-use-to-store-binary-files-data-in-MySQL/http://www.aspforums.net/Threads/101030/What-Data-type-we-need-to-use-to-store-binary-files-data-in-MySQL/Mon, 17 Nov 2014 02:10:43 GMTUsing LINQ with MySQL in C#<p>sir,</p> <p>I used ur code while developing some of my modules and they work fantastic...now i have a prob was working on that from last week bt unable to correct it can u plz help m out??</p> <p>I have a textbox under that i have taken a checkbox that is giving input in form of 1 or 0</p> <p>and under that i have taken a gridview in which my column name is ID,name and Ismain with a radiobutton what i want is that when i select checkbox the ismain should give value 1 or 0 else when i select radiobutton &nbsp;Ismain should give the same value as Id....</p> <p>hope to have a positive rply from ur side...</p> <p>thanks in advance..</p> <p>i have done this using linq..This is what i have done till nw&nbsp;</p> <pre class="brush: csharp">public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { fillgrid(); } } protected void btnsub_Click(object sender, EventArgs e) { masterdataDataContext db = new masterdataDataContext(); { string name = txtname.Text.ToString(); int IsMain = Convert.ToInt32(Chckmain.Checked); int checkBoxVal; if (Chckmain.Checked) { checkBoxVal = 1; } db.getdata(name, IsMain); db.SubmitChanges(); fillgrid(); } } protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { fillgrid(); } public void fillgrid() { masterdataDataContext db = new masterdataDataContext(); var categories = db.getalldata(); GridView1.DataSource = categories.ToList(); GridView1.DataBind(); } }</pre> <p></p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p>http://www.aspforums.net/Threads/146182/Using-LINQ-with-MySQL-in-C/http://www.aspforums.net/Threads/146182/Using-LINQ-with-MySQL-in-C/Sat, 06 Oct 2012 06:12:26 GMTupload image to mysqldatabase using ajaxfileupload control in ASP.Net<p>is there any Tutorial on how to upload image into mysqldatabase using ajaxfileupload?</p>http://www.aspforums.net/Threads/140572/upload-image-to-mysqldatabase-using-ajaxfileupload-control-in-ASPNet/http://www.aspforums.net/Threads/140572/upload-image-to-mysqldatabase-using-ajaxfileupload-control-in-ASPNet/Mon, 25 Jul 2016 02:03:19 GMTSave and Retrieve files from MySQL Database in ASP.Net<p>code for retriving &nbsp;image in mysql database. image logblob...</p> <p>asp.net</p>http://www.aspforums.net/Threads/765476/Save-and-Retrieve-files-from-MySQL-Database-in-ASPNet/http://www.aspforums.net/Threads/765476/Save-and-Retrieve-files-from-MySQL-Database-in-ASPNet/Thu, 28 Aug 2014 03:11:03 GMTRussian characters are not displaying on page with MySQL Database in aSP.Net<p>Hi,</p> <p>i am trying to insert russian language from asp.net front end into database.But when i insert <strong>?</strong> are going into database.Similarly if i insert into database from backend it is showing fine in database but when i fetch same record using select query from asp.net page it is showing<strong>?</strong>.</p> <p>How to solve this issue(utf-8) for asp.net.</p> <p>Thanks</p> <p>Rajeev Punhani</p>http://www.aspforums.net/Threads/576595/Russian-characters-are-not-displaying-on-page-with-MySQL-Database-in-aSPNet/http://www.aspforums.net/Threads/576595/Russian-characters-are-not-displaying-on-page-with-MySQL-Database-in-aSPNet/Wed, 20 Mar 2013 02:50:32 GMTResources for getting started with MySql in ASP.Net<p>What resources are available to help me get started with MySQL?</p>http://www.aspforums.net/Threads/437426/Resources-for-getting-started-with-MySql-in-ASPNet/http://www.aspforums.net/Threads/437426/Resources-for-getting-started-with-MySql-in-ASPNet/Thu, 06 Aug 2015 07:44:33 GMTUnable to perform Date Filter in MySQL Database when date stored in VARCHAR column<p>MySQL's default DATE field format is "YYYY-MM-DD".<br /><br />But in my one of the MYSQL DB Table (in which Data is coming from other service) Date is stored in Format "DD/MM/YYYY"</p> <p>i.e., 24/03/2014<br /><br />which creates problem when I Filter the data of that Table using DATE filter in My Web page.<br /><br /><br />There is a web page in which a Textbox , Button , and Grid is there.<br />When I choose Data in Textbox(using ajax calander) and click on button, related DATE data should show in Grid.<br /><br />Since the Date format is not correct in DB table, it do not filter any data.<br /><br /></p> <p><strong>HTML code:</strong></p> <p>&nbsp;</p> <pre class="brush: html">&lt;asp:TextBox ID=&#34;TFDate&#34; runat=&#34;server&#34; Width=&#34;40%&#34;&gt;&lt;/asp:TextBox&gt; &lt;cc1:CalendarExtender ID=&#34;CalendarExtender1&#34; runat=&#34;server&#34; Enabled=&#34;True&#34; Format=&#34;dd-MM-yyyy&#34; TargetControlID=&#34;TFDate&#34;&gt;&lt;/cc1:CalendarExtender&gt; &lt;asp:Button ID=&#34;Bshow&#34; runat=&#34;Server&#34; Text=&#34;Show Report&#34; OnClick=&#34;Bshow_Click1&#34;/&gt; //Also, Gridview</pre> <p>Please suggest some way how to solve this problem while doing DATE filter. Because I can not change the date format which is coming in DB Table.<br /><br />Please reply.</p>http://www.aspforums.net/Threads/270530/Unable-to-perform-Date-Filter-in-MySQL-Database-when-date-stored-in-VARCHAR-column/http://www.aspforums.net/Threads/270530/Unable-to-perform-Date-Filter-in-MySQL-Database-when-date-stored-in-VARCHAR-column/Tue, 15 Apr 2014 23:34:10 GMTTo Display records in the data base by keeping a column id as distinct<p>Hi.....</p> <p>plase suggest me a way solve a query to display records in the My SQL server database such that keeping a a column id value as distinct.</p> <p>Query type: LINQ or Lambda Expressions.</p> <p>database: my sql</p> <p>technology:C# asp.net Mvc3 application</p> <p>Thankyou,</p> <p>Ruqsana.&nbsp;</p>http://www.aspforums.net/Threads/116333/To-Display-records-in-the-data-base-by-keeping-a-column-id-as-distinct/http://www.aspforums.net/Threads/116333/To-Display-records-in-the-data-base-by-keeping-a-column-id-as-distinct/Sat, 01 Sep 2012 06:22:16 GMTSyntax error in MySQL Query in C# .Net<p>I am writing a code where query is like:</p> <p>select *from users where username!='ABC';</p> <p>but when i write it in c# code as</p> <p>string excludedname="abc";</p> <p>string query="select *from users where username !='"+excludedname+"'";</p> <p>its giving error in syntax what is the correct way to do this??</p>http://www.aspforums.net/Threads/168426/Syntax-error-in-MySQL-Query-in-C-Net/http://www.aspforums.net/Threads/168426/Syntax-error-in-MySQL-Query-in-C-Net/Fri, 07 Feb 2014 02:18:38 GMTSUM of Multiple columns of MySQL table<p>NAME &nbsp;X &nbsp; &nbsp;Y<br />A &nbsp; &nbsp; &nbsp; 10 &nbsp;20</p> <p>B &nbsp; &nbsp; &nbsp; &nbsp;12 &nbsp;24&nbsp;</p> <p>C &nbsp; &nbsp; &nbsp; &nbsp;15 &nbsp;22&nbsp;</p> <p>D &nbsp; &nbsp; &nbsp; &nbsp; 18 &nbsp;9<br /><br />i want to get name of students group by their total marks in desc order</p>http://www.aspforums.net/Threads/335604/SUM-of-Multiple-columns-of-MySQL-table/http://www.aspforums.net/Threads/335604/SUM-of-Multiple-columns-of-MySQL-table/Fri, 27 Jun 2014 04:01:55 GMTStore image in MySQL using ASP.Net<p>I just want to scan image and store in a data base&nbsp;</p> <p>&nbsp;</p>http://www.aspforums.net/Threads/195406/Store-image-in-MySQL-using-ASPNet/http://www.aspforums.net/Threads/195406/Store-image-in-MySQL-using-ASPNet/Thu, 08 Nov 2012 00:09:18 GMTShow Custom Error message when Foreign Key Violation error occurs in C# .Net<p>I am using VS2010 and Sql Server 2000. There are two tables referenced by foreign key and I am not allowing Master record to be deleted, if record is present in child table. The scenario is working fine, but the problem is that&nbsp;when user will try to delete the record, I want to show custom error message to the user instead of sql exception. How can I do tha?</p>http://www.aspforums.net/Threads/103453/Show-Custom-Error-message-when-Foreign-Key-Violation-error-occurs-in-C-Net/http://www.aspforums.net/Threads/103453/Show-Custom-Error-message-when-Foreign-Key-Violation-error-occurs-in-C-Net/Mon, 11 May 2015 07:48:13 GMTSave date in ddMMyyyy format in MySQL Database in ASP.Net C#<p>i need to get some values from Mysql Db. i have passed some values to mysql and get the result.how to pass date format in &nbsp;MySql from Asp.net C# code.</p>http://www.aspforums.net/Threads/355971/Save-date-in-ddMMyyyy-format-in-MySQL-Database-in-ASPNet-C/http://www.aspforums.net/Threads/355971/Save-date-in-ddMMyyyy-format-in-MySQL-Database-in-ASPNet-C/Sat, 15 Feb 2014 00:10:39 GMTSave and Retrieve Image files with Path saved in MySql Database and Image File in folder in ASP.Net<p>hi all help me</p> <p>i want three fileupload</p> <p>this my table&nbsp;,&nbsp; datbase mysql</p> <p>id&nbsp;&nbsp;&nbsp; int</p> <p>name varchar (30)</p> <p>file_regulation1 varchar(100)</p> <p>file_regulation2 varchar(100)</p> <p>file_regulation3 varchar(100)</p> <p>&nbsp;</p> <p>i m saving file in folder/path</p>http://www.aspforums.net/Threads/150113/Save-and-Retrieve-Image-files-with-Path-saved-in-MySql-Database-and-Image-File-in-folder-in-ASPNet/http://www.aspforums.net/Threads/150113/Save-and-Retrieve-Image-files-with-Path-saved-in-MySql-Database-and-Image-File-in-folder-in-ASPNet/Thu, 29 Jan 2015 01:40:53 GMTRead XML File and get the values using C#<p>I have this code to read XML file</p> <pre class="brush: xml">var fileName = &#34;D:\\info1.xml&#34;; XDocument doc = XDocument.Load(fileName); var col = from dummy in doc.DescendantNodes() select dummy; foreach (var myvar in col) { //Get the code and description here }</pre> <p>The XML file has this element? how can I get the value of code and desc?</p> <p><strong>&lt;maritalStatus code="M" desc="Married"&gt;</strong></p>http://www.aspforums.net/Threads/128935/Read-XML-File-and-get-the-values-using-C/http://www.aspforums.net/Threads/128935/Read-XML-File-and-get-the-values-using-C/Tue, 23 Aug 2016 10:06:04 GMTRead values from XML File and save in MySQL Database using C#<p>how to splite lat and lon from xml file and store into mysql database.</p> <p>plz reply as early as possiable.</p>http://www.aspforums.net/Threads/211892/Read-values-from-XML-File-and-save-in-MySQL-Database-using-C/http://www.aspforums.net/Threads/211892/Read-values-from-XML-File-and-save-in-MySQL-Database-using-C/Mon, 13 May 2013 01:33:53 GMTPopulate ASP.Net GridView with MySQL Database<p>how to create grid view for mysql data base?</p>http://www.aspforums.net/Threads/773598/Populate-ASPNet-GridView-with-MySQL-Database/http://www.aspforums.net/Threads/773598/Populate-ASPNet-GridView-with-MySQL-Database/Thu, 01 Nov 2012 04:43:12 GMTNeed to check read the task scheduler for a remote machine using c#<p>I am using Framework 4.0. I need to read the task scheduler(Windows) using c# console application. I have tried a technique but it is not working for me. I could not find a function called scheduled tasks. Please help.</p> <pre class="brush: csharp">static void checkScheduledTask(string computerName) { try { ScheduledTasks st = new ScheduledTasks(@&#34;\\&#34; + computerName); string[] taskNames = st.GetTaskNames(); Task task; string status; for (int i = 0; i &lt; 1; i++) { task = st.OpenTask(taskNames[i]); status = task.Status.ToString(); switch (taskNames[i]) { case &#34;CacheTask&#34;: if ((string.Compare(status, &#34;0*0&#34;) != 0) || (string.Compare(status, &#34;0*1&#34;) != 0)) { makeExcelFile(&#34;All Tasks did not complete successfully. Please check&#34;); globalVariable.body.AppendLine(&#34;All Tasks did not complete successfully&#34;); globalVariable.sw.WriteLine(globalVariable.computerName + &#34;: All Tasks did not complete successfully&#34;); goto skip; } break; default: if (string.Compare(status, &#34;0*0&#34;) != 0) { makeExcelFile(&#34;All Tasks did not complete successfully. Please check&#34;); globalVariable.body.AppendLine(&#34;All Tasks did not complete successfully&#34;); globalVariable.sw.WriteLine(globalVariable.computerName + &#34;: All Tasks did not complete successfully&#34;); globalVariable.sw.Close(); goto skip; } break; } } </pre> <p>Name space TaskScheduler.DLL...Please suggest me a better snippet to chk. I am using Framework 4.0.</p>http://www.aspforums.net/Threads/924911/Need-to-check-read-the-task-scheduler-for-a-remote-machine-using-c/http://www.aspforums.net/Threads/924911/Need-to-check-read-the-task-scheduler-for-a-remote-machine-using-c/Mon, 24 Apr 2017 02:03:26 GMTMySQL Update Query not working and not updating records<p>I have a table</p> <p>stu_id,stu_name,stu_age the first stu_id is auto increment column ..</p> <p>1 nnnnnn 25</p> <p>2 sssssss 23</p> <p>3 vail &nbsp; &nbsp; &nbsp; 22</p> <p>&nbsp; Code:</p> <pre class="brush: csharp">OleDbCommand cmd = new OleDbCommand(&#34;update bannerdetails set bannername=&#39;&#34; + textslidename.Text + &#34;&#39;,bannerimage=&#39;&#34; + upload.PostedFile.FileName + &#34;&#39;,bannerlink=&#39;&#34; + textslideurl.Text + &#34;&#39; where id=&#34; + userid + &#34;&#34;, conn);</pre> <p>now i want to update the ssssss for 4 ...if u anty idea pls give me..</p>http://www.aspforums.net/Threads/298417/MySQL-Update-Query-not-working-and-not-updating-records/http://www.aspforums.net/Threads/298417/MySQL-Update-Query-not-working-and-not-updating-records/Sun, 06 Apr 2014 03:01:10 GMTMySQL Stored Procedure for searching in Table<p>how to create procedure search string in mysql</p> <p>&nbsp;</p> <p>&nbsp;</p> <pre class="brush: csharp">DELIMITER $$ USE `dbcoba`$$ DROP PROCEDURE IF EXISTS `carii`$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `carii`(IN id_lembaga INT) BEGIN SELECT l.id_lembaga,p.propinsi_nama,k.kabupaten_nama,l.nama_lembaga,pr.peraturan_terkait FROM tbl_nama_lembaga l JOIN tbl_peraturan pr ON pr.id_peraturan=l.id_peraturan JOIN tbl_kabupaten k ON k.kabupaten_id=pr.kabupaten_id JOIN tbl_propinsi p ON p.propinsi_id=k.propinsi_id JOIN tbl_sektor sek ON sek.sektor_id=pr.sektor_id JOIN tbl_type_perda ty ON ty.type_id=pr.type_id WHERE l.id_lembaga=id_lembaga; END$$ DELIMITER ;</pre> <p>&nbsp;</p>http://www.aspforums.net/Threads/396534/MySQL-Stored-Procedure-for-searching-in-Table/http://www.aspforums.net/Threads/396534/MySQL-Stored-Procedure-for-searching-in-Table/Wed, 25 Mar 2015 04:49:21 GMT