|
no wonder i search few hours no have any answer on textarea thx u very much what is <asp:literal id="Literal1" runat="server">i never see this ...
but it still cant append, for my page i nid to do the validation if the user tick the checkboxA, it nid to few in the number on the textboxA, so every checkbox i set
OnCheckedChanged="CheckBoxXS1_CheckedChanged"
protected void CheckBoxXS1_CheckedChanged(object sender, EventArgs e)
{
if (textboxA.Text.Trim().Length == 0)
{
TextArea1.InnerText = "last"; (when result show i nid to append,how should i do? if i create a label it nid alot)
}
}
|
|
|
|
|
I've already done it in VB6 which was perfectly working fine but i've to work it in c#
for locking access database
Sub lockDb(bPath As String)
On Error GoTo Ermsg
Dim iFreeFile As Integer
Dim lLoop As Integer
Dim sString As String
iFreeFile = FreeFile()
Open bPath For Binary As #iFreeFile
sString = "DVUnion Windows Database"
For lLoop = 7 To 19
Put #iFreeFile, lLoop, VBA.Mid$(sString, lLoop - 4, 1)
Next lLoop
Close #iFreeFile
for unlock access database
Sub UnlockDb(bPath As String)
On Error GoTo Ermsg
Dim iFreeFile As Integer
Dim lLoop As Integer
Dim sString As String
iFreeFile = FreeFile()
Open bPath For Binary As #iFreeFile
sString = "Standard Jet DB"
For lLoop = 7 To 19
Put #iFreeFile, lLoop, VBA.Mid$(sString, lLoop - 4, 1)
Next lLoop
Close #iFreeFile
How to do it in c#
www.facebook.com/raazak47
|
|
|
|
|
|
That isn't what the OP stated.
VB6 is not VB.Net. Although it might be better if they convert it to VB.Net and stick to it.
"It's true that hard work never killed anyone. But I figure, why take the chance." - Ronald Reagan
That's what machines are for.
Got a problem?
Sleep on it.
|
|
|
|
|
A direct translation would give you something like this:
void LockDb(string bPath)
{
const string sString = "DVUnion Windows Database";
using (var fileStream = File.OpenWrite(bPath))
{
fileStream.Seek(6, SeekOrigin.Begin);
for (int index = 2; index < 15; index++)
{
fileStream.WriteByte((byte)sString[index]);
}
}
}
void UnlockDb(string bPath)
{
const string sString = "Standard Jet DB";
using (var fileStream = File.OpenWrite(bPath))
{
fileStream.Seek(6, SeekOrigin.Begin);
for (int index = 2; index < 15; index++)
{
fileStream.WriteByte((byte)sString[index]);
}
}
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
HttpPostedFile myPostedFile1 = FileUpload1.PostedFile;
HttpPostedFile myPostedFile2 = FileUpload2.PostedFile;
HttpPostedFile myPostedFile3 = FileUpload3.PostedFile;
HttpPostedFile myPostedFile4 = FileUpload4.PostedFile;
HttpPostedFile myPostedFile5 = FileUpload5.PostedFile;
if (myPostedFile1 != null && myPostedFile1.ContentLength > 0)
{
FileInfo finfo = new FileInfo(myPostedFile1.FileName);
string fileExtension = finfo.Extension.ToLower();
if (fileExtension != ".gif" && fileExtension != ".jpg" && fileExtension != ".jpeg" && fileExtension != ".png")
{
Label3.Text = "error";
}
else if (FileUpload1.HasFile)
{
byte[] productImage = FileUpload1.FileBytes;
string connnStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection conn1 = new SqlConnection(connnStr);
string query = " INSERT INTO Product (ItemImg) VALUES (@img1)";
SqlCommand com = new SqlCommand(query, conn1);
com.Parameters.Add("@img1", SqlDbType.VarBinary).Value = productImage;
conn1.Open();
com.ExecuteNonQuery();
conn1.Close();
}
}
_________________________________________________________________________________________
Cannot insert the value NULL into column 'ItemCode', table 'C:\USERS\MICHAEL\DESKTOP\ASSIGNMENT2\FINAL ASSIGNMENT\FINAL ASSIGNMENT\APP_DATA\DATABASE.MDF.dbo.Product'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'ItemCode', table 'C:\USERS\MICHAEL\DESKTOP\ASSIGNMENT2\FINAL ASSIGNMENT\FINAL ASSIGNMENT\APP_DATA\DATABASE.MDF.dbo.Product'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Source Error:
Line 117:
Line 118: // com.Parameters.AddWithValue("@img1", productImage);
Line 119: conn1.Open();
Line 120: com.ExecuteNonQuery();
Line 121: conn1.Close();
i want to save the image into database viabinary why will occur this problem~ sad
|
|
|
|
|
Michael†Cheong wrote: Cannot insert the value NULL into column 'ItemCode', table '...Product'; column does not allow nulls. INSERT fails.
Your Product table has a column called ItemCode , which has to be set. You are trying to insert a new record without setting a value for the ItemCode column.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
protected void Save_Click1(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
string strInsert;
SqlCommand cmdins;
if (DropDownList1.SelectedValue.Equals("Default"))
{
String txtbox3 = TextBox3.Text;
double t = Convert.ToDouble(txtbox3);
Dis = Math.Round(t, 2);
Label5.Text = Dis.ToString();
}
conn.Open();
strInsert = "INSERT INTO Product (ItemCode,ItemName,ItemCategory,ItemDesc,ItemPrice) VALUES(@code,@name,@ctgy,@desc,@price)";
cmdins = new SqlCommand(strInsert, conn);
cmdins.Parameters.AddWithValue("@code", txtID.Text);
cmdins.Parameters.AddWithValue("@name", TextBox2.Text);
cmdins.Parameters.AddWithValue("@ctgy", RadioButtonList1.SelectedValue.ToString());
cmdins.Parameters.AddWithValue("@desc", Editor1.Content);
cmdins.Parameters.AddWithValue("@price", Dis);
cmdins.ExecuteNonQuery();
conn.Close();
HttpPostedFile myPostedFile1 = FileUpload1.PostedFile;
HttpPostedFile myPostedFile2 = FileUpload2.PostedFile;
HttpPostedFile myPostedFile3 = FileUpload3.PostedFile;
HttpPostedFile myPostedFile4 = FileUpload4.PostedFile;
HttpPostedFile myPostedFile5 = FileUpload5.PostedFile;
if (myPostedFile1 != null && myPostedFile1.ContentLength > 0)
{
FileInfo finfo = new FileInfo(myPostedFile1.FileName);
string fileExtension = finfo.Extension.ToLower();
if (fileExtension != ".gif" && fileExtension != ".jpg" && fileExtension != ".jpeg" && fileExtension != ".png")
{
Label3.Text = "error";
}
else if (FileUpload1.HasFile)
{
byte[] productImage = FileUpload1.FileBytes;
string connnStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection conn1 = new SqlConnection(connnStr);
string query = " INSERT INTO Product (ItemImg) VALUES (@img1)";
SqlCommand com = new SqlCommand(query, conn1);
com.Parameters.Add("@img1", SqlDbType.VarBinary).Value = productImage;
conn1.Open();
com.ExecuteNonQuery();
conn1.Close();
}
}
string strSelect;
SqlCommand cmd;
SqlDataReader myReader;
conn.Open();
strSelect = "Select ItemCode From Product";
cmd = new SqlCommand(strSelect, conn);
myReader = cmd.ExecuteReader();
while (myReader.Read())
{
String Strings = myReader["ItemCode"].ToString();
String intString = Strings.Substring(3, 5);
txtID.Text = "" + intString;
columnValue = int.Parse(intString);
newValue = columnValue + 1;
txtID.Text = "PIC" + newValue.ToString();
}
myReader.Close();
conn.Close();
}
yaya thx u answer~ by clicking one button i nid to do alot function @@ that make me no idea~ but thx u let me know what the problem hehe if u free help me see the code and let me know nid how to do
|
|
|
|
|
Assuming you want the image to be on the record you've just inserted, you need to use an UPDATE query instead of an INSERT :
byte[] productImage = FileUpload1.FileBytes;
string query = "UPDATE Product SET ItemImg = @img1 WHERE ItemCode = @code";
using (SqlConnection conn1 = new SqlConnection(connStr))
using (SqlCommand com = new SqlCommand(query, conn1))
{
com.Parameters.AddWithValue("@code", txtID.Text);
com.Parameters.Add("@img1", SqlDbType.VarBinary).Value = productImage;
conn1.Open();
com.ExecuteNonQuery();
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
haiz i stack this problem for few hs @@ thx u very much
|
|
|
|
|
it's necessary to make use on handler control if i want to receive the binary image from database ? if not have any method?
|
|
|
|
|
Depending on the browser and the size of the image, you might be able to get away with embedding the image as a data URI[^].
Browser support info: http://caniuse.com/#feat=datauri[^]
You can easily build the URI from an array of bytes containing the image data:
public static string BuildImageDataUri(byte[] imageBytes, string mimeType)
{
return "data:" + mimeType + ";base64," + Convert.ToBase64String(imageBytes);
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hi Experts,
I am new in ASP.NET, and having problem with performance of a page.
I am showing around 100,000 record(I don't want to apply paging in data control) in a data control of page. On First call page is taking long time to load. Do any one has solution? Quick response is appreciated.
Thanks....
|
|
|
|
|
Kalim_mughal wrote: I am showing around 100,000 record That's ridiculous, how do you expect your user to find the information they want in that many records? It takes a long time because your are getting lots of records.
Use the best guess
|
|
|
|
|
Do you know answer?
|
|
|
|
|
Yes, do not try and read 100,000 records at a time. It is obvious that it will take 100,000 times some finite period, which is likely to be some minutes at the very least.
Use the best guess
|
|
|
|
|
The answer is to apply paging. The browser will take a long time to render that much data. On top of it, the browser will likely not perform well anyway if the user were to try and scroll and find data. Is there are reason you do not want to do paging?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Paging is only solution?
Do we can use Ajax? If yes how??
|
|
|
|
|
Yes, you could use ajax to load more records as the user scrolls. But at some point, you will still run into a slow performing browser because there is too much data. It is simply a limitation of the browser. You could also cut down on how much formatting you are applying or how many columns of data, that could help.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Kalim_mughal wrote: I am showing around 100,000 record
No chance to load that quickly, even computers are not capable of doing magic work.
Kalim_mughal wrote: I don't want to apply paging in data control
You will have to.[^]
But only when you want a fast loading. Decide yourself what you want.
|
|
|
|
|
I have created a web application for inserting and updating a set of record using C#.net.
the coding is as follows.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class insert : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\PRAVINR\Documents\Visual Studio 2010\WebSites\strikers\App_Data\royal.mdf;Integrated Security=True;User Instance=True");
protected void Page_Load(object sender, EventArgs e)
{
DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("insert rusty values(@CustID,@Name,@Address,@City,@Pin,@State,@Country,@ContactNO)", con);
cmd.Parameters.AddWithValue("@CustID", TextBox1.Text);
cmd.Parameters.AddWithValue("@Name", TextBox2.Text);
cmd.Parameters.AddWithValue("@Address", TextBox3.Text);
cmd.Parameters.AddWithValue("@City", TextBox4.Text);
cmd.Parameters.AddWithValue("@Pin", TextBox5.Text);
cmd.Parameters.AddWithValue("@State", TextBox6.Text);
cmd.Parameters.AddWithValue("@Country", TextBox7.Text);
cmd.Parameters.AddWithValue("@ContactNO", TextBox8.Text);
cmd.ExecuteNonQuery();
Label1.Text = "Inserted Completed..";
}
catch (Exception ex)
{
Label1.Text = ex.ToString();
}
finally
{
con.Close();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
TextBox7.Text = "";
TextBox8.Text = "";
}
}
i need to change the coding to parallel processing so that the process of inserting is done parallel.
Can anyone help me solving this ?
|
|
|
|
|
Can u plz describe ur problem? Not understood....
What is Parallel processing?
|
|
|
|
|
What u want to do actually?
|
|
|
|
|
As far as I can see there is only one insert command in the above, so how can that be made parallel (or more likely multi-threaded)?
Use the best guess
|
|
|
|
|
supposing if there are 2 updates taking place simultaneously the updates takes some time.so to avoid the time delay i need to do it using parallel programming or threading.
My main aim is to reduce the CPU work usage.
|
|
|
|