ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2018 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>https://www.aspforums.net:443/Threads/101030/What-Data-type-we-need-to-use-to-store-binary-files-data-in-MySQL/https://www.aspforums.net:443/Threads/101030/What-Data-type-we-need-to-use-to-store-binary-files-data-in-MySQL/Mon, 17 Nov 2014 02:10:43 GMTUsing Pivot in MySQL<p>Hi sir/mam,&nbsp;</p>
<p>I'm pulling some data from the database and displaying in GridView But i need to display some data in common way like horizontally and some values as vertically.&nbsp;</p>
<p>Example</p>
<p>Suppose i pulling the id, date, name from the users table.The id and date should come horizontally but the name should come vertically.&nbsp;</p>
<p>How can show that please help me.</p>
<p>i'm using mysql database</p>https://www.aspforums.net:443/Threads/482926/Using-Pivot-in-MySQL/https://www.aspforums.net:443/Threads/482926/Using-Pivot-in-MySQL/Tue, 28 Nov 2017 03:12:47 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>https://www.aspforums.net:443/Threads/146182/Using-LINQ-with-MySQL-in-C/https://www.aspforums.net:443/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>https://www.aspforums.net:443/Threads/140572/upload-image-to-mysqldatabase-using-ajaxfileupload-control-in-ASPNet/https://www.aspforums.net:443/Threads/140572/upload-image-to-mysqldatabase-using-ajaxfileupload-control-in-ASPNet/Mon, 25 Jul 2016 02:03:19 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>https://www.aspforums.net:443/Threads/270530/Unable-to-perform-Date-Filter-in-MySQL-Database-when-date-stored-in-VARCHAR-column/https://www.aspforums.net:443/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>https://www.aspforums.net:443/Threads/116333/To-Display-records-in-the-data-base-by-keeping-a-column-id-as-distinct/https://www.aspforums.net:443/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>https://www.aspforums.net:443/Threads/168426/Syntax-error-in-MySQL-Query-in-C-Net/https://www.aspforums.net:443/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>https://www.aspforums.net:443/Threads/335604/SUM-of-Multiple-columns-of-MySQL-table/https://www.aspforums.net:443/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>https://www.aspforums.net:443/Threads/195406/Store-image-in-MySQL-using-ASPNet/https://www.aspforums.net:443/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>https://www.aspforums.net:443/Threads/103453/Show-Custom-Error-message-when-Foreign-Key-Violation-error-occurs-in-C-Net/https://www.aspforums.net:443/Threads/103453/Show-Custom-Error-message-when-Foreign-Key-Violation-error-occurs-in-C-Net/Mon, 11 May 2015 07:48:13 GMTSelect query with Like function in MySQL<p>can someone help me with this code of mine. when i write things into the search box the search dosent work and here is the code</p>
<pre class="brush: vb">Dim adapater As MySqlDataAdapter
Dim ds As New DataSet
Try
con.Open()
adapater = New MySqlDataAdapter(&#34;SELECT * from inventory where Iterm like &#39;or&#34; And TextBox1.Text &amp; &#34;%&#34;, con)
adapater.Fill(ds)
DataGridView1.DataSource = ds.Tables(0)
con.Close()
</pre>
<p>&nbsp;</p>https://www.aspforums.net:443/Threads/934210/Select-query-with-Like-function-in-MySQL/https://www.aspforums.net:443/Threads/934210/Select-query-with-Like-function-in-MySQL/Tue, 07 Nov 2017 05:09:35 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>https://www.aspforums.net:443/Threads/355971/Save-date-in-ddMMyyyy-format-in-MySQL-Database-in-ASPNet-C/https://www.aspforums.net:443/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>https://www.aspforums.net:443/Threads/150113/Save-and-Retrieve-Image-files-with-Path-saved-in-MySql-Database-and-Image-File-in-folder-in-ASPNet/https://www.aspforums.net:443/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 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>https://www.aspforums.net:443/Threads/765476/Save-and-Retrieve-files-from-MySQL-Database-in-ASPNet/https://www.aspforums.net:443/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>https://www.aspforums.net:443/Threads/576595/Russian-characters-are-not-displaying-on-page-with-MySQL-Database-in-aSPNet/https://www.aspforums.net:443/Threads/576595/Russian-characters-are-not-displaying-on-page-with-MySQL-Database-in-aSPNet/Wed, 20 Mar 2013 02:50:32 GMTRestore deleted data from MySql<p>Is there is any posibilites to recover mysql table date?</p>
<p>Help me for solution!!</p>
<p>&nbsp;</p>
<p>&nbsp;</p>https://www.aspforums.net:443/Threads/402836/Restore-deleted-data-from-MySql/https://www.aspforums.net:443/Threads/402836/Restore-deleted-data-from-MySql/Thu, 07 Sep 2017 04:24:59 GMTResources for getting started with MySql in ASP.Net<p>What resources are available to help me get started with MySQL?</p>https://www.aspforums.net:443/Threads/437426/Resources-for-getting-started-with-MySql-in-ASPNet/https://www.aspforums.net:443/Threads/437426/Resources-for-getting-started-with-MySql-in-ASPNet/Thu, 06 Aug 2015 07:44:33 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>https://www.aspforums.net:443/Threads/128935/Read-XML-File-and-get-the-values-using-C/https://www.aspforums.net:443/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>https://www.aspforums.net:443/Threads/211892/Read-values-from-XML-File-and-save-in-MySQL-Database-using-C/https://www.aspforums.net:443/Threads/211892/Read-values-from-XML-File-and-save-in-MySQL-Database-using-C/Mon, 13 May 2013 01:33:53 GMTPopulate Line chart from MySQL Database using C# and VB.Net in ASP.Net<p>how to create line chart using&nbsp;mysql database.</p>
<p>Please...</p>https://www.aspforums.net:443/Threads/446888/Populate-Line-chart-from-MySQL-Database-using-C-and-VBNet-in-ASPNet/https://www.aspforums.net:443/Threads/446888/Populate-Line-chart-from-MySQL-Database-using-C-and-VBNet-in-ASPNet/Fri, 02 Feb 2018 22:42:05 GMT