ASPForums.Net RSS Feed additions to the content that appears on ASPForums.Net(c) 2017 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"></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>, 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 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>, 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>, 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></p>, 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 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 page it is showing<strong>?</strong>.</p> <p>How to solve this issue(utf-8) for</p> <p>Thanks</p> <p>Rajeev Punhani</p>, 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>, 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>, 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# Mvc3 application</p> <p>Thankyou,</p> <p>Ruqsana.&nbsp;</p>, 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>, 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>, 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>, 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>, 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 to pass date format in &nbsp;MySql from C# code.</p>, 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>, 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>, 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>, 13 May 2013 01:33:53 GMTPopulate ASP.Net GridView with MySQL Database<p>how to create grid view for mysql data base?</p>, 01 Nov 2012 04:43:12 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>, 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>, 25 Mar 2015 04:49:21 GMTMySQL Query to get names of all Tables in Database<p>MySql query to get all table names of a database in</p>, 24 Nov 2013 18:44:47 GMT