private int UpdateJewelry()
{
int flag = 0;
using (SqlConnection con = new SqlConnection(JewelleryHelper.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("spUpdateJewelleryBySerialNumber", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SerialNumber", SqlDbType.NVarChar).Value = this.txtSerialNumber.Text;
cmd.Parameters.Add("@Category", SqlDbType.VarChar).Value = this.ddlCategory.SelectedValue;
cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = this.txtdesc.Text;
if (!string.IsNullOrEmpty(this.imageProduct.Src))
{
byte[] binaryImage = JewelleryHelper.ConvertImageInBinaryData(Server.MapPath(this.imageProduct.Src));
if (binaryImage != null)
{
cmd.Parameters.Add("@Image", SqlDbType.Image).Value = binaryImage;
}
}
cmd.Parameters.Add("@CostPrice", SqlDbType.VarChar).Value = JewelleryHelper.GetEncodedCostPrice(this.txtCostPrice.Text);
double costPrice;
if (double.TryParse(this.txtCostPrice.Text, out costPrice))
{
cmd.Parameters.Add("@SellingPrice", SqlDbType.Float).Value = JewelleryHelper.GetSellingPrice(costPrice);
}
if (!string.IsNullOrEmpty(this.txtSoldPrice.Text))
{
cmd.Parameters.Add("@SoldPrice", SqlDbType.Float).Value = double.Parse(this.txtSoldPrice.Text);
}

if (!string.IsNullOrEmpty(this.txtsolddate.Text))
{
cmd.Parameters.Add("@SoldDate", SqlDbType.DateTime).Value = Convert.ToDateTime(this.txtsolddate.Text);
}

cmd.Parameters.Add("@CustomerName", SqlDbType.VarChar).Value = this.txtCustomer.Text;
cmd.Parameters.Add("@AffectedRows", SqlDbType.Int);
cmd.Parameters["@AffectedRows"].Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery();
con.Close();

flag = (int)cmd.Parameters["@AffectedRows"].Value;
}
}

return flag;
}
}

protected void ibtnUploadImage_Click(object sender, ImageClickEventArgs e)
{
if (this.fuUploadImage.HasFile)
{
this.fuUploadImage.PostedFile.SaveAs(this.imagePath + this.fuUploadImage.FileName);
this.imageProduct.Src = "ProductImage/" + this.fuUploadImage.FileName;
}
}

protected void lbtnJewellery_Click(object sender, EventArgs e)
{
LinkButton lbtn = (LinkButton)sender;
DataSet ds = this.GetJewelleryBySerialNumber(lbtn.CommandArgument);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
this.lblSerialNumber.Text = Convert.ToString(ds.Tables[0].Rows[0]["SerialNumber"]);
this.lblCategory.Text = Convert.ToString(ds.Tables[0].Rows[0]["Category"]);
this.lblConsignmentName.Text = !string.IsNullOrWhiteSpace(Convert.ToString(ds.Tables[0].Rows[0]["ConsignmentName"])) ? Convert.ToString(ds.Tables[0].Rows[0]["ConsignmentName"]) : "N/A";
this.imageProductPopup.Src = "ProductImage/" + JewelleryHelper.GetImageFromBinaryData(ds.Tables[0].Rows[0]["Image"], Convert.ToString(ds.Tables[0].Rows[0]["SerialNumber"]), this.imagePath);
this.lblDescription.Text = Convert.ToString(ds.Tables[0].Rows[0]["Description"]);
this.lblCostPrice.Text = Convert.ToString(ds.Tables[0].Rows[0]["CostPrice"]);
this.lblSellingPrice.Text = Convert.ToString(ds.Tables[0].Rows[0]["SellingPrice"]);
ScriptManager.RegisterStartupScript(this, this.GetType(), "JewelleryInfo", "loadPopup();", true);
}
}

protected void btnUploadJewelry_Click(object sender, EventArgs e)
{
int flag = this.UpdateJewelry();
if (flag > 0)
{
JewelleryHelper.DeleteFileIfExists(Server.MapPath(this.imageProduct.Src));
////JewelleryHelper.DeleteTemporaryInternetFiles();
this.BindJewellery();
this.divUpdateJewellary.Visible = false;
this.lblInfo.Visible = false;
////Alert message after jewellery added successfully.
ScriptManager.RegisterStartupScript(this, this.GetType(), "AddJewellery", "alert('Jewelry has been updated successfully.');", true);
}
else
{
this.lblInfo.Text = flag == 0 ? "Not any rows has been updated." : "An error occured while updating jewelry.";
this.lblInfo.Visible = true;
this.lblInfo.ForeColor = System.Drawing.Color.Red;
}
}

private DataSet GetJewelleryBySerialNumber(string serialNumber)
{
using (SqlConnection con = new SqlConnection(JewelleryHelper.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("spGetJeweleryBySerialNumberForPopup", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SerialNumber", SqlDbType.NVarChar).Value = serialNumber;
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
con.Close();
return ds;
}
}
}

private int UpdateJewelry()
{
int flag = 0;
using (SqlConnection con = new SqlConnection(JewelleryHelper.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("spUpdateJewelleryBySerialNumber", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SerialNumber", SqlDbType.NVarChar).Value = this.txtSerialNumber.Text;
cmd.Parameters.Add("@Category", SqlDbType.VarChar).Value = this.ddlCategory.SelectedValue;
cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = this.txtdesc.Text;
if (!string.IsNullOrEmpty(this.imageProduct.Src))
{
byte[] binaryImage = JewelleryHelper.ConvertImageInBinaryData(S

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.IO;

public partial class SearchByCode : System.Web.UI.Page
{
///

/// Product image folder path to read image file from folder or write image file in to folder.
///

private string imagePath = string.Empty;

protected void Page_Load(object sender, EventArgs e)
{
this.imagePath = Server.MapPath("ProductImage/");
}

protected void btnSearch_Click(object sender, EventArgs e)
{
this.BindJewellery();
}

private void BindJewellery()
{
DataSet dsJewellery = this.GetAllJewellery(this.txtSerialNumber.Text);
if (dsJewellery != null && dsJewellery.Tables.Count > 0 && dsJewellery.Tables[0].Rows.Count > 0)
{
this.lblMessageInfo.Visible = false;
this.gvJewellery.DataSource = dsJewellery;
this.gvJewellery.DataBind();
this.gvJewellery.Visible = true;
}
else
{
this.gvJewellery.Visible = false;
this.lblMessageInfo.Text = "No record(s) found!";
this.lblMessageInfo.Visible = true;
this.divUpdateJewellary.Visible = false;
}
}

private DataSet GetAllJewellery(string serialNumber)
{
using (SqlConnection con = new SqlConnection(JewelleryHelper.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("spGetJeweleryOnSerialNumber", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SerialNumber", SqlDbType.NVarChar).Value = serialNumber;
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
con.Close();
return ds;
}
}
}

protected void lbtnEdit_Click(object sender, EventArgs e)
{
LinkButton lbtn = (LinkButton)sender;
DataSet ds = this.GetAllJewellery(lbtn.CommandArgument);
if (ds != null && ds.Tables.Count > 0)
{
this.txtSlNumber.Text = ds.Tables[0].Rows[0]["SerialNumber"].ToString();
this.ddlCategory.SelectedValue = ds.Tables[0].Rows[0]["Category"].ToString();
this.imageProduct.Src = "ProductImage/" + JewelleryHelper.GetImageFromBinaryData(ds.Tables[0].Rows[0]["Image"], ds.Tables[0].Rows[0]["SerialNumber"].ToString(), this.imagePath);
this.txtdesc.Text = ds.Tables[0].Rows[0]["Description"].ToString();
this.txtCostPrice.Text = ds.Tables[0].Rows[0]["CostPrice"].ToString();
this.txtSoldPrice.Text = ds.Tables[0].Rows[0]["SoldPrice"].ToString();
this.txtCustomer.Text = ds.Tables[0].Rows[0]["CustomerName"].ToString();
if (!string.IsNullOrWhiteSpace(Convert.ToString(ds.Tables[0].Rows[0]["SoldDate"])))
{
this.txtsolddate.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["SoldDate"].ToString()).ToString("dd/MM/yyyy");
}
this.divUpdateJewellary.Visible = true;
}
else
{
this.lblInfo.Text = "An error occured while retrieving data jewelry.";
this.lblInfo.Visible = true;
this.lblInfo.ForeColor = System.Drawing.Color.Red;
}
}

protected void gvJewellery_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRowView drv = e.Row.DataItem as DataRowView;
if (drv != null)
{
LinkButton lbtnEdit = e.Row.FindControl("lbtnEdit") as LinkButton;
LinkButton lbtnJewellery = e.Row.FindControl("lbtnJewellery") as LinkButton;
Image imgJe

Can anyone else tell me please a solution? i need it urgency

did you find any solution? can you tell me please the solution?

I have sent you.kindly check and please help me

send me your email id

USE [DB3184_InventoryDatabase]
GO
/****** Object: StoredProcedure [dbo].[spGetJeweleryOnSoldItems] Script Date: 20/05/2015 19:47:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <author,,name>
-- Create date: <create date,,="">
-- Description: <description,,>
-- =============================================
ALTER PROCEDURE [dbo].[spGetJeweleryOnSoldItems]
-- Add the parameters for the stored procedure here
@Category varchar(50)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
SELECT SerialNumber, Category, [Description], [Image], CostPrice, SellingPrice, SoldPrice, CustomerName, SoldDate
FROM dbo.tblInventory
where Category = @Category AND IsSold = 'True'
END


this is the query on my sql management studio

i have checked its stored procedure

this error coming after i have given double slash "\\SoldCrystalReport.rpt"
Error in File SoldCrystalReport {89DB8975-B569-4C5A-81D3-78F821EE368E}.rpt:
Invalid group condition.

yes I changed the way you mentioned. at runtime when i am clicking on show report, error coming cant load report. this I am doing from my local machine

Will this code work on server? I mean my project is live,

string Reportdoc = Server.MapPath("SoldCrystalReport.rpt") + "\\RPT\\PrintClientBrokerageSum.rpt"

Is this correct? I have put crystal report name inside the server.mappath

can you send the html code to paste in aspx page, as the code you have given error coming, saying buttonshow should come under form tag under runat=server

and my datatable has data

Oh i have named my report file name inside the double quotes after Server.Mappath

and your html code i pasted on a new aspx file, it says put the buttonshow inside form tag under runat server

ReportStream.Read(bytes, 0, ReportStream.Length);

error coming in this line and on the word Encoding
and error on the word Constants. it tells the word Constants does not exist in the current context

My project code is in c#

Thank you for the detailed answer, one last thing shall i create a new aspx page and paste the div code there?

Can anyone please help me with a solution? I need help

Can you please explain me step by step what to do?

I still couldnt understand your solution, I have pasted the 2 lines of div code in one of my aspx page. After that what do i do?

I have placed the code under Content placeholder. Next what do i do?

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="SoldItems.aspx.cs" Inherits="SoldItems" %>
<%@ Register Assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"
Namespace="CrystalDecisions.Web" TagPrefix="crystalReport" %>

<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="Server">
<div id="DivReportVIew" runat="server">
</div>
<div class="content">

View Sold Items

<div class="commonFilters">
<div>
<p>
<asp:Label ID="lblCategory" runat="server">Choose By Category :</p>
<asp:DropDownList ID="ddlCategory" runat="server">
<asp:ListItem >Choose Category
<asp:ListItem>Earrings
<asp:ListItem>Pendant
<asp:ListItem>Bangles
<asp:ListItem>Bracelets
<asp:ListItem>Necklace
<asp:ListItem>Toe Rings
<asp:ListItem>Cuff Links
<asp:ListItem>Rings
<asp:ListItem>Sets
<asp:ListItem>Tie-Pin
<asp:ListItem>Brooch

</div>
<div>
<asp:Button ID="btnShow" runat="server" Text="Show" OnClick="btnShow_Click" />
</div>
<div>
<asp:Button ID="btnPrint" runat="server" Text="Print" OnClick="btnPrint_Click" />
</div>
</div>
<div class="searchResults">
<asp:Label ID="lblMessageInfo" runat="server" Font-Bold="true" Font-Size="14px" ForeColor="Red"
Visible="false">
<asp:GridView ID="gvJewellery" runat="server" AllowPaging="false" AutoGenerateColumns="false"
Width="960px" OnRowDataBound="gvJewellery_RowDataBound">
<HeaderStyle BackColor="#207ce5" Height="75px" VerticalAlign="Middle" HorizontalAlign="Center"
Font-Bold="true" />
<columns>
<asp:BoundField DataField="SerialNumber" HeaderText="Serial Number" ItemStyle-Width="75px"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="Category" HeaderText="Category" ItemStyle-Width="120px"
ItemStyle-HorizontalAlign="Center" />
<asp:TemplateField HeaderText="Image" ItemStyle-Width="120px" ItemStyle-HorizontalAlign="Center">
<itemtemplate>
<asp:Image ID="imgJewellery" runat="server" Height="50px" Width="60px" />


<asp:BoundField DataField="Description" HeaderText="Description" ItemStyle-Width="385px"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="CostPrice" HeaderText="Cost Price" ItemStyle-Width="70px"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="SellingPrice" HeaderText="Selling Price" ItemStyle-Width="70px"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="SoldPrice" HeaderText="Sold Price" ItemStyle-Width="70px"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="Custo

Sorry to say again. I am new to these. How can I use this code to convert my crystal report to html in a div?

Where shall i paste this code? Do i have to make any changes in the code? Where will i put my crystal report name?

Hello can anyone tell me please what path should i gave?
my project is under my documents\microsoft visual studio 2010\projects\Inventory
under inventory the reports are there

yes soldcrystalreport.rpt is stored under wwwroot folder in server side.

Hello you are an indian i suppose with your name, can you please tell me which server version to use for windows server 2008?

My asp.net project is web based, i have done it in visual studio 2010 ultimate and sql server 2008 r2 and .net 4.0

Please tell me any server name which one to buy

Can I buy Windows 8.1 Pro?

What is meant by Windows Server 8.1 pro single user. Can anyone tell me?

Thanks but Why not Windows Server 2003?

Can i buy Windows Server 2003 Enterprise Edition. Will it fulfill my requirements,kindly please help me

in google for windows server 2003 different pricing are showing. Some standard edition, some business edition. Which product to buy? Can anyone please tell me?
i need a server for my ASP.NET project, and Sql Server 2008 R2 and .net 4.0 compatibility

If you could help me in this. Then I will mark it as solved and close this forum

Yes its a more Crystal report question. The print is working fine I just need the dialog box to come in front of the application rather its displaying at the background, So a user has to always minimize the window and then print from the dialog box.

Thanks again for so much help.

Hi. Your code working fine. But 1 thing the dialog box is coming at the background of the application. So I was unable to recognize it. Every time I have to minimize my application and then select options from the print dialog box. Can you please tell the code for bringing it at the front of the application?

Can anyone please tell me?

and in the 2nd code, ReportPrintDocument is showing error. Telling either missing any directive or assembly. Which reference to include?

ReportDocument rDoc = new ReportDocument();
PrintDialog dialog1 = new PrintDialog();
rDoc.Load("C:/Users/SUDESHNA/Documents/Visual Studio 2010/Projects/Inventory/StockCrystalReport1.rpt");
rDoc.SetParameterValue("@Category", ddlCategory.SelectedValue);
rDoc.SetDatabaseLogon("sa", "gariahat");

dialog1.AllowSomePages = true;
dialog1.AllowPrintToFile = false;

if (dialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
int copies = dialog1.PrinterSettings.Copies;
int fromPage = dialog1.PrinterSettings.FromPage;
int toPage = dialog1.PrinterSettings.ToPage;
bool collate = dialog1.PrinterSettings.Collate;

rDoc.PrintOptions.PrinterName = dialog1.PrinterSettings.PrinterName;
rDoc.PrintToPrinter(copies, collate, fromPage, toPage);
}

rDoc.Dispose();
dialog1.Dispose();
}
}

This is what I have written. Nothing is coming. The dialog box not showing even. I have loaded the reference System.Windows.Forms.

Can you tell me why nothing is working?

Its showing error if I write System.Windows.Forms. I am using Asp.net web application

Hi mine is a web application. I have tried to write System.Windows.Forms, its not coming. System.Web comes.

Hello, Please can you help me? Please.

Now what code to write, Can you please help me?

protected void btnPrint_Click(object sender, EventArgs e)
{
ReportDocument rDoc = new ReportDocument();
rDoc.Load("C:/Users/SUDESHNA/Documents/Visual Studio 2010/Projects/Inventory/StockCrystalReport1.rpt");
rDoc.SetParameterValue("@Category", ddlCategory.SelectedValue);
rDoc.SetDatabaseLogon("sa", "gariahat");
//this.crystalReportViewer.ReportSource = rDoc;
//this.crystalReportViewer.DataBind();
//this.crystalReportViewer.Focus();
//rDoc.Refresh();

rDoc.PrintToPrinter(1, true, 0, 0);
}

This is the code that you had told. and I was using it for so many days

Hi can you please tell me how to display the print wizard(set up) dialog box at run time after clicking on print button. the code which you had told me its printing all the pages directly after clicking on print button. But i want to mention specific pages in the print set up page or printer name after clicking on print button

Hi I dont have a windows server. So i am hosting my local machine as server. I have published my project and inside iis i have given the path of the published folder and created a host name as local.jewelry.com.
I have gone to
hosts under drivers and have added the ip address of my computer and host name.
The only error coming at runtime is about the path in web.config.

What path do i give at web.config?

how to get the IIS? can it be downloaded from internet?

showing error still

I solved it myself. i just refreshed my data source. Thanks

showing error

showing error that cannot implicitly convert double to char[]

So shall i use Decimal or Double?

I dont have any decimal in my cost price value. whatever i will enter it in double like 23897 or 21784 or 45230

I have visual studio 2010 ultimate. Is it ok then?

after that configure the webserver (IIS or Apache) for the website using the path where you copied the file on the server.

But I did not understand this statement. I dont have IIS or Apache. I have FTP file transfer server.

Ok. Then 1st i have to install sql server, then using the import and export feature i will import the data to server? Right? Then i will publish my project and the folder which will be created after publish, i will upload all the files to server.Right? Then i can give the same connection string which i have in my web.config. Correct?

i have already inserted 500 records in my local db located in my system. how do i upload that db with records to server?

I have to install full sql server 2008 r2 in server?

I have inserted 500 records in my local db which is there in my system. now next what do i do? to upload my db in server?

Can anyone please help me? I need to make my project live

i dont have any data in the database. I had all the dummy data in my local database.So when i will make it live, i will remove all the data.

And what connection string will i set on the server.

Presently in my local DB.
<add name="InventoryDatabaseConnectionString" connectionstring="Data Source=.\INSTANCE;Initial Catalog=InventoryDatabase;Integrated Security=True">

this is the connection string written.

So next what do I do?

i searched. i am getting half information. can you please just tell the procedure? It will be a great help to me

Please dear help me. minor thing is left. if you help me a bit it might work.

protected void btnPrint_Click(object sender, EventArgs e)
{
ReportDocument rDoc = new ReportDocument();
rDoc.Load("C:/Users/SUDESHNA/Documents/Visual Studio 2010/Projects/Inventory/SoldCrystalReport.rpt");
rDoc.SetParameterValue("@Category", ddlCategory.SelectedValue);
rDoc.SetDatabaseLogon("sa", "gariahat");
//this.crystalReportViewer.ReportSource = rDoc;
//this.crystalReportViewer.DataBind();
//this.crystalReportViewer.Focus();
rDoc.Refresh();
rDoc.PrintToPrinter(1, true, 0, 0);
}

i have now changed the code to this. please can you help me.

i checked by debugging. sorry that time didnt understand. I know how to debug. rDoc.ParameterFields["Category"] is showing a value earrings whatever i have selected from drop down

i checked from crystal report main report preview.from there data is showing.

how to check that? shall i recreate the parameter field again? i think my parameter value is not set properly. beside category a ? sign showing in parameter field [?]@Category like this showing. is it correct?

yes the parameter category exists in the parameter field. see on clicking on any of the 5 items from drop down list, the list gets populated in gridview.

can i share a screenshot? how to do that?

Object reference not set to an instance of an object. this error showing in line
rDoc.ParameterFields["Category"].CurrentValues.Add(paramDiscreteValue);

what namespace to add? it showing error in line ParameterDiscreteValue

Then shall i remove Server.MapPath?

C:\Users\SUDESHNA\Documents\Visual Studio 2010\Projects\Inventory\SoldCrystalReport.rpt

this is the full path where my report is there

ReportDocument rDoc = new ReportDocument();
rDoc.Load(Server.MapPath("SoldCrystalReport.rpt"));
rDoc.SetParameterValue("Category", this.ddlCategory.SelectedValue);
rDoc.SetDatabaseLogon("sa", "gariahat");
this.crystalReportViewer.ReportSource = rDoc;
this.crystalReportViewer.DataBind();
this.crystalReportViewer.Focus();
var paramDiscreteValue = new ParameterDiscreteValue { Value = Value };
doc.ParameterFields[ParName].CurrentValues.Add(paramDiscreteValue);

like this?
and in place of value what do i write?

where to add these two lines? didnt get it?

rDoc.Load(Server.MapPath("SoldItemsCrystalReport.rpt"));

in this line do i have to give the full path? as its still showing error at runtime but when i am checking from inside the crystal report that is Main report Preview its working fine. asking for category value and as i am entering earrings, data are showing in crystal report but at runtime, its showing error

yes the parameter Category is there in the report

showing error in rDoc.SetParameterValue("Category", this.ddlCategory.SelectedValue);
Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))

how to do so? or if you want you can change the code and tell me the correct way without using datasource

i have to set the parameter in the crystal report?

how to do so? can you please help? you helped me last time, it worked. thank u so much. can you please tell me?

didnt get it. last time what you suggested there no drop down list was there, so the other asp forms worked. as i wanted to display all the records.
but this time gridview will show data based on choosing from drop down list and that list should show in crystal report and clicking on print button it should directly print.

private DataSet GetAllJewellery()
{
using (SqlConnection con = new SqlConnection(JewelleryHelper.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("spGetJeweleryOnSoldItems", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Category", SqlDbType.VarChar).Value = ddlCategory.SelectedItem.Text;
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
con.Close();
return ds;
}
}
}

protected void btnPrint_Click(object sender, EventArgs e)
{
SoldItemsDataSetTableAdapters.spGetJeweleryOnSoldItemsTableAdapter getAllJewellerySoldItems = new SoldItemsDataSetTableAdapters.spGetJeweleryOnSoldItemsTableAdapter();
DataTable dt = getAllJewellerySoldItems.GetAllJewellerySoldItems(this.ddlCategory.SelectedValue);
ReportDocument rDoc = new ReportDocument();
rDoc.Load(Server.MapPath("SoldItemsCrystalReport.rpt"));
rDoc.SetDataSource(dt);
rDoc.SetParameterValue("Category", this.ddlCategory.SelectedValue);
this.crystalReportViewer.ReportSource = rDoc;
this.crystalReportViewer.DataBind();
this.crystalReportViewer.Focus();
}
}

if you think its wrong then can you tell me the code please as to what to do?

spGetJeweleryOnSoldItems is a store procedure and getalljewellerysolditems is dataset

Hi InbarBarkai

Can i ask another thing? i have a drop down combo box for products like earrings,necklace,bangles etc.

if i click from the drop down any of the above products, that particular details show in gridview, now i want to print that details which are there in gridview, now the code for print is not working here.

i mean selection based on category. can you tell me please how to do so?

Thanks a lot.

which lines to be removed can you please say? sorry to bothere. if you could mention it

i dont have any subreports. the 1st line where to add in my code?

this code where to add? the code which i wrote shall i erase it?

sorry.no the printer is not set on the report. how to set that? as i click on print button its showing the error that i posted

hello.Can anyone please help me?

Failed to open the connection.
ViewAllCrystalReport1 {509200AC-ED44-49EC-8695-FEF4E5D50013}.rpt
Details: [Database Vendor Code: 17 ]
error coming at the last line.
cryRpt.PrintToPrinter(2,true,1,2)

Failed to open the connection.
ViewAllCrystalReport1 {509200AC-ED44-49EC-8695-FEF4E5D50013}.rpt
Details: [Database Vendor Code: 17 ]

error coming in last line cryRpt.PrintToPrinter

is there any experts who can help me?

can anyone please tell me?

i did not understand, can you explain a bit more

i have sent you mail, let me know what to do.

sudeshnab08@gmail.com

Will i send my project to you? so that you can have a look at it?

hi, i just saw all my images which i m uploading from user end, getting saved in solution under a folder name ProductImage. and in the database it just shows the name of the productimage. so how do i now display image from folder under solution?

i used picturebox but my code i have written according to varchar(max),everywhere showing varchar, if i change in database then it might show error

hello, i changed the datatype of image field to image datatype, then in database image not coming, some ascii value showing and even at front end in grid view image not showing

then i have to change everywhere varchar to image datatype in my back end coding and if then error comes?

this is stored procedure for creation of table?

ok then i will create another new table right with table name img,right?
as i have 1 table already with fields serial number int
category varchar
image varchar(max)
costprice float
selling price float

i have taken image field in database as varchar(max) and how to attach table with crystal report?

Thanks all of you for the help

ok i will try this code and will let you know how its working.Thanks. even i also dnt want to use is identity

ya i have different products category, so for different products serial number will start from 1

Thanks, i will implement this. if it runs will let you know

i dont want to use is identity property. i have used that. if some one deletes any data, then in that place no data will get inserted.

hello. i dnt want that to show in gridview serial number. i have one field in database where serial number exists. that field is my product item code and i have to enter from user end and gets stored in db.

next time when user enters new item, serial number displays new number in textbox field

hello can you help me please.see the second code that i pasted

can anyone please help me. where is wrong in this code? i cant understand it.

no data getting inserted in database.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.IO;
using System.Drawing;
using System.Data;

public partial class AddEarRing : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{


}
protected void Button1_Click(object sender, EventArgs e)
{
string fileName = string.Empty;
string filePath = string.Empty;
string getPath = string.Empty;
string pathToStore = string.Empty;

SqlCommand cmd = new SqlCommand("invent", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SerialNumber", txtcode.Text);
cmd.Parameters.AddWithValue("@Category", cmbcat.Text);
cmd.Parameters.AddWithValue("@Description", txtdesc.Text);
cmd.Parameters.AddWithValue("@CostPrice", TextBox1.Text);
cmd.Parameters.AddWithValue("@SellingPrice", TextBox4.Text);
cmd.Parameters.AddWithValue("@SoldPrice", txtprice.Text);

try
{
if (FileUpload1.HasFile)
{
fileName = FileUpload1.FileName;
filePath = Server.MapPath("Images/" + System.Guid.NewGuid() + fileName);
FileUpload1.SaveAs(filePath);
cmd.Parameters.AddWithValue("@Image", fileName);
int getPos = filePath.LastIndexOf("\\");
int len = filePath.Length;
getPath = filePath.Substring(getPos, len - getPos);
pathToStore = getPath.Remove(0, 1);
cmd.Parameters.AddWithValue("@BookPicPath", pathToStore);
}
con.Open();
cmd.ExecuteNonQuery();
Label8.Text = "Data saved successfully";
Label8.ForeColor = Color.Green;
ClearControls();


}
catch (Exception)
{
Label8.Text = "Data could not be saved";
Label8.ForeColor = Color.Red;
}
finally
{
con.Close();
cmd.Dispose();
fileName = null;
filePath = null;
getPath = null;
pathToStore = null;
}

}
private void ClearControls()
{
txtcode.Text = string.Empty;
txtdesc.Text = string.Empty;
txtprice.Text = string.Empty;
cmbcat.Text = string.Empty;
TextBox1.Text = string.Empty;
TextBox4.Text = string.Empty;

txtcode.Focus();
}

}


This is my new code that i changed just now. its running but going to the catch statement

i cant upload it in database

i have put my code in question area,now can you help me please

yes i solved it but i did not give path. I just wrote my aspx file name within ahref within double quotes and it came.

how to root my file location? didnt get what you meant? did you meant giving the path of the aspx file?

i did not give path, i just wrote with a href, additem.aspx

yes i have given correct path

how to do then? Not coming after even giving the path

i copy and pasted the path, why is it not displaying here?

<li>Jewelry
<ul>
<li>Add An Item</li>

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="Menu.aspx.cs" Inherits="Menu" %>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="Server">
<div class="example">
<ul id="nav">
<li class="current">Sign Out</li>
<li>Jewelry
<ul>
<li>Add An Item</li>
<li>Update An Item</li>
</ul>
</li>
<li>Stock
<ul>
<li>View Stock List</li>
<li>View Sold List</li>
<li>View All Items</li>
</ul>
</li>
<li>Search
<ul>
<li>By Serial Number</li>
<li>By Category</li>
<li>By Price</li>
<li>By Stone</li>
<li>By Category-Price</li>
<li>By Category-Stone</li>

</ul>
</li>
</ul>
</div>


Check the Add an Item line. i gave the path. but its not coming anything

ya i saw the solution1,but didnt understand what you meant.can u explain?

didnt get it.can you explain?

did you see it?

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="Menu.aspx.cs" Inherits="Menu" %>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="Server">
<div class="example">
<ul id="nav">
<li class="current">Sign Out</li>
<li>Jewelry
<ul>
<li>Add An Item</li>
<li>Update An Item</li>
</ul>
</li>
<li>Stock
<ul>
<li>View Stock List</li>
<li>View Sold List</li>
<li>View All Items</li>
</ul>
</li>
<li>Search
<ul>
<li>By Serial Number</li>
<li>By Category</li>
<li>By Price</li>
<li>By Stone</li>
<li>By Category-Price</li>
<li>By Category-Stone</li>

</ul>
</li>
</ul>
</div>



this is the code.

ok

atleast could have given some good solution

how to apply the login form templates in my own project? i have downloaded the login templates

i know VB. as i have done many projects on vb.net but on windows platform.
asp.net i have no idea. ya sure you can send me links here. what is mvc? that only i am getting confused. and if i do in asp.net with vb,shall my requirement be fulfilled? i mean did you understood what i want in my project?

i have to do a inventory project on stones, so i am confused whether i do in windows vb.net or asp.net?

i just want the front end looks good design and the software if viewed by any computer data can be visible. i mean suppose i make changes to data in database from my system,
if someone else opens the software from his/her system can see the changes or can update also something in the db. to for this what exactly platform i need to do?

Thanks for the help. can i ask another question? it might be a very stupid question

Thanks for the help

where is the link?

Thank u for the link,but i am learning asp.net. i dont know how to do.

you can check my other posts,in 2013, i got many help.

no,i am not asking to teach me, i just want some better links so that seeing it i can do something.last year when i was new to vb.net,i got help from codeproject only.
many experts helped me with many links.and i finished my project.
msdn help is for experts who know programming very well.

I saw the links,but did not understand the concept,please if you could help me more.
I will be very obliged.

Thank you for the links,but i did not understand anything as i a amateur in web applications.can you give some more links explaining how to do it or how to start with.
waiting for your response.thanks in advance

hello.can anyone tell me please? or some asp links how to do it entire thing

how to do it? i dont know asp.net. can you help me?

This is my code in the crystal report to load data from datagridview to crystal report.
But the data is not getting loaded in crystal report.the above error is showing. i have added a blank crystal report. created a new dataset and under that new datatable.but the data still not loading in crystal report.

Imports System.Configuration
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.ReportAppServer
Imports System.Data.SqlClient
Imports System.Data

Public Class Form32

Private Sub Form32_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat")
Dim ds As New DataSet
Dim dt As DataTable
Dim cmd As New SqlCommand("select * from fullsort where return_dt is null ", cn)
Dim da As New SqlDataAdapter(cmd)
dt = New DataTable
da.Fill(dt)
'FullsortDataGridView.DataSource = tb2

cn.Close()
' Dim rpdoc As ReportDocument

Dim rpdoc As CrystalDecisions.CrystalReports.Engine.ReportDocument
rpdoc = New stock
Me.CrystalReportViewer1.ReportSource = rpdoc
rpdoc.SetDataSource(dt)

End Sub
End Class

Can anyone help me in rectifying my error

i think my coding is wrong, because in same project my other crystal reports are working, only this report where i have written this code to extract data from datagridview and print in crystal report, this report not working

Can anyone help me please. not getting the data loaded in crystal report from datagridview

why this error coming?

when i am running my application and clicking on print button to display the crystal report
the following error is coming
Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win64_x64\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified.

showing error that fullsortdatagridview is not declared

where will i add this code? in form32? that is crystal report viewer?

cr1 is the name of my crystalreport

Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat")
Dim ds As New DataSet
Dim dt As DataTable
dt = New DataTable()

ds.Tables.Add(dt)
cr1.SetDataSource(ds)
CrystalReportViewer1.ReportSource = cr1

this error i am getting
Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win64_x64\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified.

this is the code i wrote in crystal report for loading datagridview data to crystal report but its showing error. what is wrong in it?

Can anyone help me plz.

That only i dont know what code to write when return_dt is null or blank.
Can you help me. the above code is for delete,add,print and edit records that i have posted the code.

Can any one help me.how to do that?

RegisterClientScriptBlock method is obsolete. This error is showing in green underlined

Variable file1 is used before it is assigned a value.
This error showing in line
Dim imageInfo As FileInfo = New FileInfo(File1.Trim())

I am using web application

and in this line, its showing warning that this variable is used before its assigned a value

ok. but now error is coming in this line
RegisterClientScriptBlock("alertMsg", "<script>alert('please select one image file.');</script>")

now error is coming in these 3 lines-
Case ".JPG" : UpLoadImageFile(File1.Value.Trim())
Case ".GIF" : UpLoadImageFile(File1.Value.Trim())
Case ".BMP" : UpLoadImageFile(File1.Value.Trim())

file1.value.trim()

and also previously error was coming in line
RegisterClientScriptBlock("alertMsg", "<script>alert('please select one image file.');</script>")

I have declared the file1 as string
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim File1 As String
Dim imageInfo As FileInfo = New FileInfo(File1.Trim())
If imageInfo.Exists() = False Then
RegisterClientScriptBlock("alertMsg", "<script>alert('please select one image file.');</script>")
Else
Select Case (imageInfo.Extension.ToUpper())
Case ".JPG" : UpLoadImageFile(File1.Value.Trim())
Case ".GIF" : UpLoadImageFile(File1.Value.Trim())
Case ".BMP" : UpLoadImageFile(File1.Value.Trim())
'default: RegisterClientScriptBlock("alertMsg", "<script>alert('file type error.');</script>")
End Select
End If
End Sub

Can you help me with some other alternative, its just that i am learning, so just want to know how to upload and retrieve images to and from database

Then how to create string with file1? can you help me

Ya i meant the same

http://www.aspnettutorials.com/tutorials/database/Save-Img-ToDB-VB/

this is the website from where i got the code

even I dont know what is it? i searched website for uploading image to database and found this code,so I wrote. As i am new to this language.

Yes it was useful.Thanks a lot.Thats why i already gave thanks

No,i did debug the code and its not going to else part unless i give wrong password.
Its in asp.net with vb code

its working now.Thanks

now the page is being redirected to login.aspx which is under account/login.aspx
and I have created a separate log.aspx which is outside the directory

Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration

Public Class log
Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

End Sub

Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("loginConnectionString").ConnectionString)
con.Open()
Dim cmd As New SqlCommand("select * from log where username =@username and Pass=@password", con)
cmd.Parameters.AddWithValue("@username", TextBox1.Text)
cmd.Parameters.AddWithValue("@password", TextBox2.Text)
Dim da As New SqlDataAdapter(cmd)
Dim dt As New DataTable()
da.Fill(dt)
If dt.Rows.Count > 0 Then
Response.Redirect("Account/ChangePassword.aspx")
Else
ClientScript.RegisterStartupScript(Page.[GetType](), "validation", "<script language='javascript'>alert('Invalid Username and Password')</script>")
End If
End Sub
End Class

i deleted that project and created a new one,
I will post the code

same login page is displaying

I used response.redirect with full path, but no change,page is not getting redirected to other page

I did but same.no change. is anything wrong with my code? in the if statement? please can you re check it.

sorry this url is showing but the page is not getting redirected

http://localhost:13523/Account/Login.aspx?ReturnUrl=%2fAccount%2fChangePassword.aspx

Yes the ChangePassword.aspx and login.aspx are in same account directory

No,i meant how to create a web application project using asp.net

I am sorry.tell me i will modify the question according to what you say.i just need help in asp.net.as i am new to it

Thanks