ASPForums.Net RSS Feed additions to the content that appears on ASPForums.Net(c) 2019 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 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>, 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 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 GMTUsing ExecuteReader in MySQL in ASP.Net<p>Can the script to display data on SQL Server be implemented in MySQL?</p> <pre class="brush: vb">Imports System.Web Imports System.Data.SqlClient Imports System.Configuration Imports System.Text Imports System.Collections.Generic Imports System.Web.Script.Serialization Public Class cariAHASS Implements System.Web.IHttpHandler Public Sub ProcessRequest(ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest Dim prefixText As String = context.Request.QueryString(&#34;term&#34;) Using conn As New SqlConnection() conn.ConnectionString = ConfigurationManager.ConnectionStrings(&#34;conn&#34;).ConnectionString Using cmd As New SqlCommand() cmd.CommandText = &#34;select description from m_cabang_ahass where kota like &#39;%&#39;+ @SearchText + &#39;%&#39;&#34; cmd.Parameters.AddWithValue(&#34;@SearchText&#34;, prefixText) cmd.Connection = conn Dim customers As New List(Of String)() conn.Open() Using sdr As SqlDataReader = cmd.ExecuteReader() While sdr.Read() customers.Add(sdr(&#34;description&#34;).ToString()) End While End Using conn.Close() context.Response.Write(New JavaScriptSerializer().Serialize(customers)) End Using End Using End Sub Public ReadOnly Property IsReusable() As Boolean Implements IHttpHandler.IsReusable Get Return False End Get End Property End Class</pre> <p>&nbsp;</p>, 27 Nov 2018 23:50:44 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 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 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>, 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 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 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 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>, 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>, 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>, 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 GMT